How to fetch the VAT registration number of the ship to party from billing

[Former Member]

Dear SDN Team

How to fetch the VAT registration number of the ship to party from the billing document. Can you proide some information for fetching the VAT registration number of the ship to party.

Normally only the payer VAT registration number will be displayed in the Invoice. But in my case the Ship to party VAT number is displayed.

I have resolved this problem by doing the customizing setting in order to have the payer vat registration number. But for the Old Billing documents it is more than 30,000 documents where it was printed with the ship to party VAT number. So i need to identify those documents.

Can you please help to resolve this problem.

With Regards,

Jai

[reazuddin_md · Accepted solution]

As you know, VAT registration number can be stored in Table:KNA1_STCEG.

" Ship to party will be available only in Billing item level & VAT registration number available in Billing Header level"-

How this VAT number picked in Invoice print.

- If you have multiple line items with multiple ship to parties, which VAT number is printed on Invoice?

otherwise,

If you have only one Ship to with either single/multiple line items. you can find VAT reg number-

by fetching the Ship to party number from VBPA wrt: Billing doc number & partner function:WE & from KNA1 table, enter the Ship to party number extracted from the VBPA table. in field :STCEG you can find VAT reg number.

[Former Member · Accepted solution]

Dear Team,

Thanks for your information and suggestion and for your quick response.

If it iis for small data is ok. But the data is huge. Initially i have retirieved the data from the VBRK table around 30,000 records. In which it prints some invoices with Payer VAT number and some of the invoices with Ship to Vat number.

Is there any other possible way other then by passing the Invoice number to VBPA and passing customer to KNA1-STCEG. since the data is large. Fetching the data from production system will lead to performance problem.

With Regards,

Jai

[former_member188076 · Accepted solution]

Hi

For already created data follow the tables which is already provided.

And also check the IMG setting at Sales & distribution>Basic Function>Taxes-->Maintain sales Tax Identification No. Determination.

You can do the customising here and maintain your VAT No. accordingly to get the vat no. from Ship to party. (read the F1 help).

Regards

Amitesh Anand

[Former Member]

Hi,

To get VAT from the ship to from Billing, You have to first fetch the BILLING NUMBER from the VBRK and then goto the Document flow in VBFA to get the SALES DOCUMENT NUMBER and with sales document you will get the SHIP TO number from the VBPA with the PARVW = SH

Once you got the SHIP TO , then goto the KNA1 and get the VAT ID in the field STCEG

so the logic will be as follows

VBRK---VBELN and then

VBFA--VBELN with the document Category as C

VBPA-VBELN and get the KUNNR with PARVW =SH

Now with KUNNR ( ship to ) get the VAT ID from KNA1-STCEG

regards,

santosh