Skip to Content
0
Former Member
Mar 27, 2009 at 03:36 AM

Lookup between 2 DSO's

33 Views

Hello all,

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.

Thanks,

Praveen