BAPI_ACC_DOCUMENT_POST taxable amount

[Former Member]

hi guys,

I am uploading data using BAPI_ACC_DOCUMENT_POST.

Transaction code for manual entry: FB01

I need to upload upload Tax code and taxable amount.

I found TAX code in ACCOUNTTAX (type BAPIACTX09) table of BAPI.

I could not find "Taxable amount." in the BAPI.

When I tried manually trhu FB01, i found "taxable amount" field.

So it must exist in the BAPI.

Please help me how to upload "taxable amount" using the above BAPI.

[Former Member]

Just an extract (much too long, you really sdoul ask customer/boss for an OSS id)

* gl-line expense item
accountgl-itemno_acc = '20'.
accountgl-gl_account = '0000510020'.
accountgl-tax_code   = 'U1'.
accountgl-taxjurcode = '0508525201'.
accountgl-costcenter      = 'US01'.
accountgl-bus_area        = '0001'.
currencyamount-itemno_acc = '20'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '109.00'.
*currencyamount-amt_doccur = '108.25'. "would be correct
APPEND accountgl.
APPEND currencyamount.
*-----------------------------------------------------
*NVV tax line items (Non deductible tax)
CLEAR accounttax.
CLEAR currencyamount.
accounttax-itemno_acc = '30'.
accounttax-tax_code   = 'U1'.
accounttax-acct_key   = 'NVV'.
accounttax-cond_key   = 'XP1I'.
accounttax-tax_rate   = '6.00'.
accounttax-taxjurcode = '0500000000'.
accounttax-taxjurcode_deep = '0508525201'.
accounttax-taxjurcode_level = '1'.
*----------------------------------------------------
* tax line item refers to accountgl-itemno_acc = '20'
* which will be line item bseg-buzei = '002' in the final document
accounttax-itemno_tax =  '002'.
*----------------------------------------------------
*accounttax-stat_con   = 'X'.
currencyamount-itemno_acc = '30'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '6'.
currencyamount-amt_base   = '100'.
APPEND accounttax.
APPEND currencyamount.

CLEAR accounttax.
CLEAR currencyamount.
accounttax-itemno_acc = '40'.
accounttax-tax_code   = 'U1'.
accounttax-acct_key   = 'NVV'.
accounttax-cond_key   = 'XP2I'.
accounttax-tax_rate   = '1.25'.
accounttax-taxjurcode = '0508500000'.
accounttax-taxjurcode_deep = '0508525201'.
accounttax-taxjurcode_level = '2'.
accounttax-itemno_tax =  '002'.
* accounttax-stat_con   = 'X'.
currencyamount-itemno_acc = '40'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '2'.
*currencyamount-amt_doccur = '1.25'. "Would be correct
currencyamount-amt_base   = '100'.
APPEND accounttax.
APPEND currencyamount.

Regards,

Raymond

[Former Member]

HI ,

you have pass the amount in currenc amount Structure and Tax code in account tax structure but maintain same ITEMNO_ACC

in Both The structure.

Regards

Nilesh

[Former Member]

Hi nilesh,

I am already using this currency structure for "local currency", "document currency": and "group currency"..based on type 00/10/30.

again, shall i pass to the same field for taxable amount?(with tax code).

Could you please explain in detail.

[Former Member]

Hi

take a look at code below

CLEAR accounttax.
CLEAR currencyamount.
accounttax-itemno_acc = '01'.
accounttax-tax_code   = 'V1'.
accounttax-acct_key   = 'MW1'.
accounttax-cond_key   = 'XP1U'.
accounttax-tax_rate   = '100-'.
accounttax-taxjurcode = '050000000'.
accounttax-taxjurcode_deep = '0508525201'.
accounttax-taxjurcode_level = '1'.
currencyamount-itemno_acc = '30'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '6-'.
currencyamount-amt_base   = '100-'.

[RaymondGiuseppi]

First read OSS [Note 626235 - Tax postings with accounting BAPIs|https://service.sap.com/sap/support/notes/626235] and analyze the samples provided. (ZF_BAPI_EXTERNAL_TAX_POST.txt and ZF_BAPI_EXTERNAL_TAX_POST_MULT.txt)

Regards,

Raymond

[Former Member]

Raymond,

Thank you for your help.

I am unable to open that OSS notes as I do not have User id and password.

Could you please post that information?

[RaymondGiuseppi]

Just an extract (much too long, you really sdoul ask customer/boss for an OSS id)

* gl-line expense item
accountgl-itemno_acc = '20'.
accountgl-gl_account = '0000510020'.
accountgl-tax_code   = 'U1'.
accountgl-taxjurcode = '0508525201'.
accountgl-costcenter      = 'US01'.
accountgl-bus_area        = '0001'.
currencyamount-itemno_acc = '20'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '109.00'.
*currencyamount-amt_doccur = '108.25'. "would be correct
APPEND accountgl.
APPEND currencyamount.
*-----------------------------------------------------
*NVV tax line items (Non deductible tax)
CLEAR accounttax.
CLEAR currencyamount.
accounttax-itemno_acc = '30'.
accounttax-tax_code   = 'U1'.
accounttax-acct_key   = 'NVV'.
accounttax-cond_key   = 'XP1I'.
accounttax-tax_rate   = '6.00'.
accounttax-taxjurcode = '0500000000'.
accounttax-taxjurcode_deep = '0508525201'.
accounttax-taxjurcode_level = '1'.
*----------------------------------------------------
* tax line item refers to accountgl-itemno_acc = '20'
* which will be line item bseg-buzei = '002' in the final document
accounttax-itemno_tax =  '002'.
*----------------------------------------------------
*accounttax-stat_con   = 'X'.
currencyamount-itemno_acc = '30'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '6'.
currencyamount-amt_base   = '100'.
APPEND accounttax.
APPEND currencyamount.

CLEAR accounttax.
CLEAR currencyamount.
accounttax-itemno_acc = '40'.
accounttax-tax_code   = 'U1'.
accounttax-acct_key   = 'NVV'.
accounttax-cond_key   = 'XP2I'.
accounttax-tax_rate   = '1.25'.
accounttax-taxjurcode = '0508500000'.
accounttax-taxjurcode_deep = '0508525201'.
accounttax-taxjurcode_level = '2'.
accounttax-itemno_tax =  '002'.
* accounttax-stat_con   = 'X'.
currencyamount-itemno_acc = '40'.
currencyamount-curr_type  = '00'.
currencyamount-currency   = 'USD'.
currencyamount-amt_doccur = '2'.
*currencyamount-amt_doccur = '1.25'. "Would be correct
currencyamount-amt_base   = '100'.
APPEND accounttax.
APPEND currencyamount.

Regards,

Raymond

[Former Member]

issue was resolved.