finding Line VAT code in SAP table

[former_member445510]

Hello,

Can some one help me to file Line VAT code for the invoice in SAP tables.

I'm using the following tables: BSEG, BSET, BKPF.

some one have an idea?

Ouail

[Former Member]

Hi,

Pass the BKPF-BELNR to BSET-BELNR

You will need to know the condition type used for VAT field [KSCHL].

PLEASE NOTE PERCENTAGE YOU WILL GET IN 1 DIGIT EXTRA FORMAT

LIKE 12.5 % YOU WILL GET 125%

Value for field  = FWSTE

tax base amount = HWBAS

Regards

[former_member445510]

Thank you Mohammed,

sorry i did not understand your answer,I'm junior in sap booking.

i want to get a value of Line VAT code like in this XML file:

<ReportingDocumentCollection>

<ReportingDocument>

<CompanyCode>1000</CompanyCode>

<PostingDate>11.07.2005</PostingDate>

<InvoiceProperties>

<Currencies>

<Currency>EUR</Currency>

<Currency>EUR</Currency>

<Currency>EUR</Currency>

</Currencies>

<InvoiceLines>

<LineVATCode>11</LineVATCode>

</InvoiceLines>

<InvoiceLines>

<LineVATCode>22</LineVATCode>

</InvoiceLines>

</InvoiceProperties>

            </ReportingDocument>

</ReportingDocumentCollection>

can you help me to write query for, if that necessary to get this value?

or there is  another solution ???

best regard,

Ouail