Data from BSEG matching custom table..

[Former Member]

Hi Friends,

I got a little tricky requirement.

Client has got 2 custom tables which holds the document number and the unique ID (UID).

Now I am expected to get the amount data relevant to this from BSEG.

Flow -> Get the doc number from 2nd custom table based on some keys in 1st custom table. Then pass on this to BSEG to get the data using doc number.

Am not clear if its related to Gl, AP or AR...yet. All I am aware is to get the amounts data from BSEG, as per the requirement.

Am thinking of below solutions:

• Use the standard extractor (0FI_GL_04 alone?) which gets the data from BSEG and BKPF (Read from other posts). Enhance this with the unique Key (UID). Build this into a DSO. Build the DSOs on other 2 custom tables (Transparent) ones (Generic DS), and do a look up on these in the DSO of 0FI_GL_04 to get the amounts for the UID. Not sure about this approach though
• Go for the View on req fields in BKPF/BSEG with join on key fields, create a generic DS. Load this to the DSO, and then look up the other 2 custom table DSOs? Is a view possible on BKPF/BSEG (BSEG being cluster table - Read from other posts that it is possible?)
• Build a FM based extractor for all the 3 tables in source? Guess this might be complicated? Am not familiar with this. View is not possible on join of these 3 as there is no key field common in BSEG to the custom tables.

Please suggest on solutions as I really need your help in pros and cons or any other better alternatives for this

[KamalMehta]

Hi Aditya ,

From my point of view  you have to achieve this with the help of Generic extractor using FM.

1. Your document numbers are already there in your custom tables now you need to check for some field in this table only to identify the document number getting changed/created during that period.

2. Once you get these document numbers you can select the relevant data from BSEG/BKPF in the select statement in the Open cursor statement in the FM Source code .

Also please refer http://scn.sap.com/message/14307484 .

This is relevant and you also have some code for your reference.

Your other 2 approaches doesn't look feasible to me .

Thanks

[Former Member]

Thanks Kamal.

Will check that link.

Please check my latest response and suggest