Join of CUIT and CORREF

[former_member1360003]

Hello Gurus,

Needed a help in Join of Tables CUIT and CORREF

There is a business scenario, where we are creating 2 POs, 2 deliveries, but combining them into a single Proforma Invoice in ECC thereby creating an Export Declaration document in GTS

Now, in the Output, we require delivery# against each line item of the declaration document.

Can someone help us here ?

Which tables should I join to get the same ?

We thought of joining /SAPSLL/CUIT and /SAPSLL/CORREF but I am not getting any primary key.

Tried using Table /SAPSLL/CORFLO as well.

Any suggestions ?

Regards,

VK

[former_member215181 · Accepted solution]

Hi Vineet,

At the item level, the feeder system references reside in table /SAPSLL/LEGREF.  You will need to consider qualifier QALREF = 'DLNR'

Regards,

Dave

[former_member1360003 · Accepted solution]

Thanks Dave. This helped

Regards,

VK