Skip to Content
0
Aug 23, 2017 at 03:37 PM

Enhance 0FI_GL_4 with AFVC

111 Views Last edit Aug 23, 2017 at 03:41 PM 2 rev

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