Hi Experts,

[former_member1354655]

I want to get the count of disconnection and re-connections against business area. Disconnection data stores against EDISCDOC and Business area is maintained at contract account level (FKKVKP). Please let me know how to achieve it.

Table for DiscDoc.: Header - EDISCDOC i am using below selection criteria.

Process variant, Discon. reason, Disc. doc statsus.

[AmlanBanerjee · Accepted solution]

Hi Venkatesh,

Check the reference object type that you are using for the Disconnection scenarios. You will find this in the EDISCDOC table. This will drive the logic for retrieving the respective contract account.

Say for example, if you are using Reference Object type as ISUACCOUNT (normally used for Disconnection through Dunning), then you will find the field Reference object key in EDISCDOC table populated with the Combination of Contract Account and BP.

You can extract the CA info and pass it into FKKVKP for the desired information.

Now, Say, if your reference Object type are INSTLN,PREMISES or DEVICE, you need to retrieve the corresponding contract and the Contract account, by querying the history tables, or by using the FM, ISU_GET_OBJECTS.

Thanks,

Amlan

[former_member1354655]

Thank you very much Amalan.

[mohammedmuzammil]

Dear Venkatesh,

This is not a straight forward requirement. The fields EDISCDOC-REFOBJTYPE and EDISCDOC-REFOBJKEY can be used.

The field EDISCDOC-REFOBJTYPE stores the reference object category against which the disconnection has been made and the field EDISCDOC-REFOBJKEY stores the value of the reference object.

For, example if the disconnection has been done against a business partner then the reference object category ( EDISCDOC-REFOBJTYPE ) would be ISUPARTNER and the field EDISCDOC-REFOBJKEY stores the value of the business partner.

For a business area, identify the contract accounts and business partners from the table FKKVKP. Using the contract accounts, trace the below reference objects.

Create an internal table with all the reference object values in one field ( BP, CA, C, CO, P, I, D ), then using FOR ALL ENTRIES on the table EDISCDOC pass the reference object values to the field EDISCDOC-REFOBJKEY.

There can be a better solution for your query if you can have the reference objects as input in your report or if the selection happens based on the business area and one of the reference objects ( selected by the user through a radio button ).

Thanks.