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:
Thank you in advance.