Withholding Tax

Hi Bharti Jain,

I have faced the dimilar problem with the BAPI "BAPI_ACC_INVOICE_RECEIPT_POST", I did the below code to achieve the result with the Withholding tax.

Table T059Z will contain the Withholding tax code.

With the given data read the details from T059Z table and pass it to EXTENSION table as below

In my case I have designed the code according to the Thailand country specific, it may differ from country to country.

 CLEAR t059z.
  SELECT SINGLE * FROM t059z WHERE land1 = text-004
                             AND witht = wa_ffile-wt_withcd.
  wt_item_th = wt_item_th + 1.
  wa_extension-field1 = 'Thailand WHT'.          "Identifier
  wa_extension-field2+0(6) = wt_item_th .        "ACCWT-WT_KEY
  wa_extension-field2+6(2) = t059z-witht.        "ACCWT-WITHT
  wa_extension-field2+8(2) = t059z-wt_withcd.    "ACCWT-WT_WITHCD
  wa_extension-field3 = wa_ffile-witht.          "Withholding tax base amount
  APPEND wa_extension TO it_extension.

Then inside the BAPI use any User exit to pas the data feom EXTENSION table to ACCIT table.

In my case ACCIT it table where i have to pass the data, please check for the similar structure and any relevant table from your BAPI and use the below code

LOOP AT extension WHERE field1 EQ 'Thailand WHT'. "Change made specific for our requirement
  MOVE extension-field2+0(6) TO t_accwt-wt_key.
  MOVE extension-field2+6(2) TO t_accwt-witht.
  MOVE extension-field2+8(2) TO t_accwt-wt_withcd.
  MOVE extension-field3 TO t_accwt-wt_qsshb.
*  MOVE extension-field3 TO t_accwt-wt_qbuihb.
  APPEND t_accwt.
ENDLOOP.
DATA l_wtkey  LIKE accit_wt-wt_key.
l_wtkey = '000001'.
*LOOP AT extension WHERE field1 EQ 'WHT_FLAG_TH'.    "WHT flag for the thailand
*  MOVE extension-field2 TO l_wtkey.                  "To decide which line item to be posted
*ENDLOOP.
LOOP AT t_accit WHERE koart = 'K'.
  MOVE l_wtkey TO t_accit-wt_key.
  MODIFY t_accit.
  l_wtkey = l_wtkey + 1.
ENDLOOP.

I have different logic for different countries, it will be good if the above information helps you otherwise let me know so that I will try to give you another logic.

Please give reasonable points if it is useful.

Thanks

Nivash S

Hi Bharti Jain,

You can use EXTENSION1 to pass more than one set of value,

Please use below as a hint to pass data,

For an example you have requirement to pass the values for VALUATION TYPE, DESTINATION COUNTRY and WITHHOLDING TAX.

Table EXTENSION1 has four fields namely FIELD1, FIELD2, FIELD3 and FIELD4.

pass the text VALUATION TYPE in FIELD1 and the rest of data in the remaining fields and append the table

pass the text DESTINATION COUNTRY in FIELD1 and the rest of data in the remaining fields and append the table

pass the test WITHHOLDING TAX in the FIELD1 and the rest of the data in the remaining fields and append the table.

Inside the BAPI using any User Exit read the table EXTENSION1 with the corresponding text to get the required values and pass them to the correct structure.

Regards

Nivash S

Hi Bharti Jain,

Yes still you can use the table EXTENSION1.

but I suggest don't pass the value EBELN to the FIELD.

You can use this FIELD1 as a identification field.

Pass some text like "EBELN"(for the PO history), "WITHHOLDING TAX"(for withholding tax), this will help you in separating the records inside the User Exit.

Inside the user exit you can read the table EXTENSION1 with key "FIELD1 = 'EBELN'" so that you can get the PO history related data. In the same way read the table EXTENSION1 with key "FIELD1= 'WITHHOLDING TAX'" so that you can get the Withholding related data and pass them in a corresponding structures.

Regards

Nivash S