0 Replies Latest reply: Jan 26, 2016 9:29 AM by Diane Papia RSS

    Joining SAP Tables after you have created one resident.

      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