Skip to main content

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.

Dear Ewa, Thank you for reaching out. For further investigations, could you please send an email to servicedesk@celonis.com with the following information: - Your Team URL - Any screenshots of the actual connection Many thanks and best regards, Tringa

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

 

Community Code of ConductAccessibility statement