Skip to Content
Personal Insights
Author's profile photo Sahil Grover

TCS Accrual in SAP S/4HANA Cloud for India

Introduction

Customers who are going live in mid of financial year need to upload the TCS accumulation data for invoices posted outside SAP. This is required as when a customer Invoice is posted in SAP S/4HANA Cloud then the total value for considering TCS will be as per Fiscal year which includes invoice created in SAP and Outside SAP.

Process

TCS process and configuration is detailed in the help link https://help.sap.com/docs/SAP_S4HANA_CLOUD/634261119fec4d58970471f2c4a9a740/7ebed77f5e91427ab030eee4dfa5f1a3.html . Customer frequently query on how to accumulate TCS data and view the data in Cloud. Let’s see in this blog post the process for TCS accumulation in SAP S/4HANA Cloud.

Step 1:  Implement BADI “Identify TC Sale Accumulation Badi Call” and activate TCS accumulation

 

 

Step 2:  Accumulate TCS Amount via BADI “Sale Amount determination for TCS – Section 206C(1H)

In this BADI we must fill the amount for each customer. A table can be built or we can add the values in BADI depending on requirement.

This BADI will be called only once when first invoice for customer is called. That’s the most critical part. So, if an invoice is posted then this Badi will not be called. Even cancelling first Invoice and then recreating will not call the BADI.

Step3: TCS accumulated can be checked in “Customer Data Browser” tables J_1IG_ACCUMHDR and J_1IG_ACCUMDTL

 

Conclusion

Hope this blog post will help you in detail on How to accumulate TCS in SAP S/4HANA Cloud for India in mid of fiscal year.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Saumitra Deshmukh
      Saumitra Deshmukh

      Thanks Sahil Grover : A very timely blogpost as multiple customers-partners are looking for this information.

      Thanks,
      Saumi

      Author's profile photo Jayalakshmi N
      Jayalakshmi N

      Thanks Sahil! We can safely assume we almost 'inspired' you to write this post on a weekend what with our desparate calls/messages!! 🙂

      Author's profile photo Sahil Grover
      Sahil Grover
      Blog Post Author

      🙂 .. This was planed based on queries but definitely you helped .

      Author's profile photo Prashant More
      Prashant More

      Hello Sahil Grover ,

       

      Thank you for your detailed solution about TCS Accumulation Data upload. This was very useful for us. I have one query regarding this. Currently we can upload only single customer TCS accumulation data at a time. Do we have any provision to mass upload TCS Accumulation Data like we used to have in SAP S/4 HANA on premise version?. Please suggest if we can do this.

       

      Thanks & Regards,

      Prashant

      Author's profile photo Sahil Grover
      Sahil Grover
      Blog Post Author

      Can you help me which was the way to "Do we have any provision to mass upload TCS Accumulation Data like we used to have in SAP S/4 HANA on premise version?" .

      In cloud its not actually you have to worry if you have written the logic and table is maintained. If BADI is called table will be read and amount will be updated.

      Author's profile photo Jayalakshmi N
      Jayalakshmi N

      Hey Sahil,

      Actually the BADI provided reads values from the populated table. The query is how do we fill the table with the customer wise data? Is there any tool that can help us upload data into a table? This is what Prashant means by the mass upload.

       

      Thanks,

      Jayalakshmi

      (In case you are wondering, Prashant is my colleague - hence we are jointly facing the problem 🙂 )

      Author's profile photo Sahil Grover
      Sahil Grover
      Blog Post Author

      If you are 3SL customer, you can create a program to read excel and upload custom table.

      As a side note if there is any mass functionality that's not available but we have API , we can always build an application to mass upload.

      Author's profile photo Jayalakshmi N
      Jayalakshmi N

      Thanks Sahil.

      Yes, the customer is on 3SL.

      We are slightly lost with the creation of program to read excel and upload table. Do you have any sample code that you can share with us?

       

      Regards,

      Jayalakshmi

      Author's profile photo Bhavneet Singh
      Bhavneet Singh

      Hi Jayalakshmi,

       

      We are also facing the same problem. Have you got any solution to mass update the table?

       

      Thanks and Regards,

      Bhavneet Singh

      Author's profile photo Jayalakshmi N
      Jayalakshmi N

      Hello Bhavneet,

       

      No, we did not. However since the volume of data was low for our customer, we simply manually entered the same in a CBO.

      An SAP colleague pointed us to this blog - do see if this helps you:

      https://answers.sap.com/questions/13244139/how-to-load-data-into-a-custom-business-object-cbo.html

       

      I'll be happy to hear back if you could achieve your results! Best wishes.

       

      Regards,

      Jayalakshmi