topic finding Line VAT code in SAP table in Application Development and Automation Discussions

finding Line VAT code in SAP table

former_member445510 — Fri, 12 Jul 2013 09:14:44 GMT

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 — Fri, 12 Jul 2013 09:40:05 GMT

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 — Fri, 12 Jul 2013 10:12:03 GMT

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:

</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