Very urgent : Table and field names of tax condition types and tax percentage

[former_member202418]

Hi all,

Can anybody help me in which table the tax condition type and tax percentage is stored. This tax condition type and tax percentage is at PO screen inside taxes button in invoice tab beside tax code field.

[jai1231]

Hello

Please following Tcodes to create complete tax producer .......

T code : OBYZ ......> Create table, access sequence, tax producer

Or

T code : OBQ3 : Create tax procedure

T code : OBQ2 : condition table

T code : OBCN..... Creat Accounts transction keys of Input & out tax

T code : OB40 - assign GL account to transction keys

T code : FTXP : Create Tax input & out put codes

T code : OBBG : assign our country to your tax procedure

Tcode : OBCL : assign tax codes to your company code.

Thanks

Jay

[anti-matter · Accepted solution]

please follow the below steps then:

T.code M/03

find the relevant condition table code

let's say if your tax code in the system is 999.. then your table name : A999

Whatever the number is you add 'A' at the beginning

now let's get the condition table number

then goto se16 and retrieve it in the table A999

please don't forget the topic when it's OK for you.

[former_member202418 · Accepted solution]

Hi Franck,

This tax code is FI not MM. Can not find in M/03. In fi tcodes where can I find the condition table code in FI.

Thanks,

Sairam

[FredericGirod · Accepted solution]

Click on the field F1 // Technical information

--> double click on the structure

--> third tab : Control table

--> T007A

Trans SM30

enter T007A

click on button Search Dialog view( I choose V_T007A_DEF)

click on button customizing

[former_member202418 · Accepted solution]

Hi Franck,

My issue was solved by going to OBQ2 tcode and picking the condition table and adding A to the table and from se16n passing the condition table number I got condition record number. And from there in konp table by passing the condition record number I fetched the tax condition type and tax percentage value.

[anti-matter]

Hello,

EKKO-KNUMV and go to -----> EKPO-EBELP

pass to KONV-KNUMV and KONV-KPOSN and use the condition types (KSCHL) and take the KWERT amount fields for taxes.

Please make a check the following tables A003 or A012 in which the Taxes and its Condition types (KNUMH) are stored linked to your POs.

Go with KNUMH field and pass into KONP table

the KSCHL field from there, you will get the Amounts for taxes.

in resume, you need to check the followings:

KONH Conditions (Header)

KONP Conditions (Item)

KONV Conditions (Transaction Data).

in case of you might need something much more clean, check the following the codage:

https://answers.sap.com/questions/1872372/purchase-order.html?childToView=1872400#answer-1872400

[former_member202418]

Hi Franck,

Thanks for your answer. Bu the challenge is we did not maintain tax rate percentage in FTXP. we maintained condition records in fv11 with the combination of destination country/region/plntRegion/GST class./Tax Ind./Ctrl code. Can you please help me in which table these key combinations are stored.

Thanks,

Sairam

[Prasoon]

Hi,

The tax values in PO - Taxes window is dynamically calculated and you cant get it directly from any table as its not stored against PO number at PO stage. However, you can use the FM: CALCULATE_TAX_ITEM , which can do the dynamic calculation and provide you the details. Refer the thread: CALCULATE_TAX_ITEM how to use it and https://answers.sap.com/questions/3464186/fm-calculatetaxitem.html

If you want to get the condition record details, you need to check the corresponding condition tables for the required condition types.

Regards,

[anti-matter]

Could you please check the following table?

[former_member202418]

Hi Franck,

After execute i got the entries.nothing more.please see the attachment.

Thanks,

Sairamt007a.png

[former_member202418]

Hi Franck,

Also please see the screenshot in which i want tables and fields.me23n-taxes-screen.png