Hi Experts !!
I want to create a report displaying accounting document no and GL account no buy providing PO No and material document no (MIGO No).
I want a database table from where I can get material document no (MIGO No)(MBLNR/BELNR) and accounting document(BELNR) no both.Currently I am using
BSEG for getting HKONT,EBELN,BELNR
MSEG for getting MBLNR by using EBELN (P.O. NO)
BKPF for getting BUDAT.
the problem came with EBELN (P.O. NO) as repeated entries are there.
I am unable to write query for getting MBLNR and BELNR for same EBELN (P.O. NO).
Is there any table where MBLNR and BELNR are related to each other??????
Thanks in advance !!!!
Hi Vikas ,
As Harish told BKPF table as BKPF-AWTYP = MKPF and then you can split the AWKEY is a good option. I did this .
Regards,
Madhu.
Check this thread, if this helps.
[url] Link between MKPF table and EKKO or RBKP table [url]
I've done this as well earlier to create a custom document flow for archived documents where from the EBELN i've found all the related documents. Hope this helps.
Add a comment