ship to, sold to, invoice/credit number, invoice value

[Former Member]

Hi,

Does anybody know the field name and the table of these items:

ship to, sold to, invoice/credit number, invoice value

Any help is welcome.

thank you,

Roger

[Former Member]

Hi Roger,

You can get customer master data using table KNA1.

You will get the Partner related information from table <b>VBPA</b>.

The field <b>VBPA-PARVW</b>(Businee partner function) conatins all business partner functionn possible values.

SP - Sold-to party

SH - Ship-to-party

If you query with above values in VBPA, you will get respecive Sold-to-party/Ship-to-party customer value into VBPA-KUNNR.

You will get the invoice number and invoice value through table VBRK.VBRK will contain header information about invoice and VBRP will contain line item details.

Invoice number is <b>VBRK-VBELN</b>

Invoice value is <b>VBRK-NETWR</b>

Thanks,

Vinay

[Former Member]

Hi Vinay,

Thanks for the very good hints. However, I still haven't found SHIP-TO table and field name yet.

Regards,

Roger

[Former Member]

hi

best VBRK,VBRP both tables.

[Former Member]

Hi,

For ship to party it is KUNNR.Also see in the table KUAGV for sold to party.

Mohan

Award points if it adds information

[Former Member]

Check table VBPA for partner details like ship to , sold to etc...using the related partner functions.

Table VBRK will give u the invoice number and the invoice net value.

reward points if helpfull.

regards

Biju

[Former Member]

Hi Biju,

Thanks for your tips.

Roger