Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Seperating Shipping address from Invoice Table

Ship Address gets stored in one field address in OINV or ORDR Table

any way to link that to master Address table to get address separated by address1,address2,city,state and zip

or any other thoughts

Former Member


The example below will give you the link between the Sales Order Shipping Address and and BP Master Address table

SELECT DISTINCT T1.Address AS 'Address Name', T1.Street AS 'Street', T1.Block AS 'Block', 
T1.City AS 'City', T1.State AS 'State', T1.ZipCode AS 'Zip Code', T1.CardCode AS 'BP Code' 
FROM  [dbo].[ORDR] T0 INNER JOIN [dbo].[CRD1] T1  ON T0.CardCode = T1.CardCode
WHERE T0.ShipToCode = T1.Address  AND  T1.AdresType = 'S'   

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question