I have created a resident table pulling some information from the sales tables VBAK, VBAP and a few of the status tables. This is working fine, my resident table is RET_1.
My issue is I know want to pull in the Delivery Number and Delivery Qty if there has been a delivery. So I need to change VBELV and POSNV with the Document Number and Document Item from RET_1 and where vbtyp_n ='T'.
Can I do this using the resident table joining to VBFA or do I have to have a separate process that pulls the VBFA data into a resident table?
Thanks for you assistance
Diane