SAP Knowledge Base Article - Public

3576564 - How to upload TAN exemption details using mass upload functionality.

Symptom

Customers are expected to keep their TAN exemption details active for the fiscal year. The validity must be modified every fiscal year, and this applies to all providers. This action should be completed before the start of the new fiscal year. As a result, a mass upload software is used to verify that all supplier values are updated at the same time.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems Any resemblance to real data is purely coincidental."

Environment

  • SAP S/4HANA
  • SAP S/4HANA Finance
  • This pertains to the Country India Version (CIN) or India Localization component.

Resolution

To use the Mass upload program, take the actions listed below:

è Run transaction FIWTIN_TANMASS and download the .xls file by providing file path, company code and supplier (Supplier is optional filed. If you do not provide supplier field, then blank xls file would be generated with header information). No need to provide any file extension, be default file would be generated with .xls format. 

 

 è If Supplier information are available in table FIWTIN_TAN_EXEM, Download the .xls file and add new entries for new FY and keep the old entries as it is.

 

 Here in this case, we have added new entries for FY 2024-2025 and kept the old entries as it is.

 è If supplier information is not avaible in table FIWTIN_TAN_EXEM, then .xls file would be generated with only header information so add new entries in .xls file and save the file.

  

Note: Provide data in format DD-MM-YYYY. Do not change the extension of the file. It is only supported single company code. Provide supplier number and not BP number.

è Upload the updated .xls file using Upload radio button and providing Company code. If company code entered in screen does not match with .xls file’s company code, then those entries would be deleted, and wound be processed further.

è Once it is processed, you can see the details in application log. If there are any error for any of the supplier, then details of the error also can be displayed in the log.

Mass upload functionality for TAN exemption details is only provided in S/4HANA release in the note 3371338 and this functionality will not be down ported to lower releases.

Keywords

TAN exemption, TAN Based exemption, PAN level exemption, note list, group section code, BP, threshold, FIWTIN_TAN_EXEM, accumulation, FIWTIN_ACC_EXEM, mass upload , KBA , FI-LOC-FI-IN , India , How To

Product

SAP S/4HANA Cloud Public Edition 2502

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png