on 08-23-2017 4:37 PM
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:
Thank you in advance.
Gennaro
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.