Enhance 0FI_GL_4 with AFVC

[Former Member]

Hi all,

first of all, please excuse me if any mistakes, but I am not a SAP expert.

A customer asked to load data from BSEG and BPKF tables, so we decided to use the 0FI_GL_4 extractor. All worked fine until we have been asked to load also some info contained in AFVC table (Operation within order).

Of course, if we use BSEG table, we can join AFVC with a condition like

LEFT JOIN AFVC WHERE BSEG.AUFPL = AFVC.AUFPL AND BSEG.APLZL = AFVC.APLZL AND BSEG.BUKRS = AFVC.WERKS 

but in this case we loose the efficency of the 0FI_GL_4 extractor, so I would like to enhance this extractor in order to add AUFPL and APLZL fields of the BSEG table.

I tried following some example like this, but it seems that those fields are not visible for 0FI_GL_4 and I cannot add them.

I would like to:

• either to know if it's possible to enhance 0FI_GL_4 extractor with those fields
• either if not, is there another extractor I can use instead of 0FI_GL_4?

Thank you in advance.

Gennaro

[TammyPowlas · Accepted solution]

My take: not all records in BSEG/BKPF will have an order, so I would create a new extractor with the desired fields

You can take a look at the delivered CO extractors to see if they meet your needs.