I tried connecting it via standard key fields (MANDT, VBELN, POSNR) but they seem to be shipment/delivery numbers and not sales order ones, so I tried connecting it to delivery/shipment tables but that doesn't seem to be working properly either.
The goal is to get the carrier number from VTPA table and corresponding sales orders numbers.
Hi Ewa,
Try connecting with VTPA and VBPA(Sales Doc/Delivery Partner)
Thanks Everybody for replying,
it worked with following joins:
FROM VTTP AS VTTP
JOIN VTPA AS VTPA ON 1=1
AND VTTP.TKNUM = VTPA.VBELN
AND VTTP.MANDT = VTPA.MANDT
LEFT JOIN LIKP AS LIKP ON 1=1
AND LIKP.VBELN = VTTP.VBELN
AND "LIKP"."MANDT"="VTTP"."MANDT"
LEFT JOIN VBFA as VBFA ON 1=1
AND VBFA.VBELN = "LIKP"."VBELN"
LEFT JOIN VBAP AS VBAP ON 1=1
AND VBAP.VBELN = VBFA.VBELV
AND VBAP.MANDT = VBFA.MANDT
AND VBAP.VBELN IS NOT NULL
LEFT JOIN LFA1 AS LFA1 ON 1=1
AND LFA1.MANDT="VTPA"."MANDT"
AND LFA1.LIFNR=VTPA.LIFNR
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
