How to find the bill to party value

[Former Member]

Hi Experts,

Now I am sending the invoices to CSV file. in this CSV file I am receiving the Sold to party number.

Now i need to replace the sold to party value to Bill to party.

How can i replace this with bill to party.

What is the table name and field name for bill to party.

Thanks.

[adithya_velide]

Thank you  Shashi. In that case,

Nagireddy you first check for the partner function vbpa- parvw = bp ,

then we take the vp no. Vbpa- kunnr..

thank an you for your help shashi.

regards,

ADITHYA.

[adithya_velide]

HI nagireddy,

        In the invoices if you want to find the bill to party the table name and field name is (vbrk-kunnr).

you ou have to change the field name and field name from vbrk- Kunag.

hope it's helpful.

Regards,

Adithya.

[shashi_thakur]

Hi Adithya,

VBRK does not have a field called KUNNR. It has the following two fields

KUNAG-Sold to Party

KUNRG-Payer.

Regards,

Shashi Thakur

Message was edited by: Shashi Thakur

[shashi_thakur]

Hi Nagireddy,

The Invoices that you are sending as CSV files-does it contain line item level details or only header level details?

The Bill to party is a line item level partner detail and can be different for each line item. You can fetch the same from VBPA table passing the Partner Function, Billing document number and posnr = '000000' and if not found then by passing the Partner Function, Billing document number and posnr = invoice posnr (vbrp-posnr).

Regards,

Shashi Thakur