Please assist me.
I have the following scenario:
1- DSO(based on EKBE table)
Key fields: PO number, PO Item, Mat Doc num, Mat Doc year,Mat Doc item, ZEKKN, VGARE.
2- DSO(based on 0FI_AP_4)
Key fields:Company code, Fiscal year/period, Accounting document number, Account document posting line, Fiscal year variant ,Due date item number.
I have enhanced field AWKEY in 0FI_AP_4 extractor from BKPF.
AWKEY = Mat Doc + Mat DocYear.
Now I have Mat Doc + Mat Doc Year in DSO(0FI_AP_4).
I want to do a lookup on DSO(EKBE) and bring PO and PO Item and DMBTR and WBTR fields . My Driver would be 2nd DSO.
Can we write a start routine to get fields from 1st DSO and put in 2nd DSO. I would like to see Amounts paid(Vendor) for a PO in single report.
Appreciate if anyon can give a sample code.