topic Re: TABLES, in Application Development and Automation Discussions

TABLES,

Former Member — Wed, 01 Nov 2006 10:41:57 GMT

CAN ANYBODY TELL ME THE TABLES NAMES WHICH HAVE 'SHIP TO ADDRESS' AND 'DELIVERY NO.' AND 'SALES OFFICE NAME' IN IT??

Re: TABLES,

Former Member — Wed, 01 Nov 2006 15:37:26 GMT

LIKP-VBELN -> Delivery no

TVKBT-BEZEI -> Sales Office Text

Ship to party on the delivery can be found in VBPA. In VBPA you will likely find a value for ADRNR as well. If so, the address can be found in ADRC where ADDRNUMBER = VBPA-ADRNR.

If VBPA-ADRNR is blank, get the address from KNA1 where KUNNR = VBPA-KUNNR.

Re: TABLES,

Former Member — Thu, 02 Nov 2006 14:35:17 GMT

Hi,

Go thru this link.

http://www.sapfans.com/sapfans/repos/saptips.htm

Thanks

Sunil