logo

Are you need IT Support Engineer? Free Consultant

Use case for Excel upload- Uploading periodic accr…

  • By Sanjay
  • 15/05/2026
  • 2 Views


Configuration Steps:

1. Customizing Accrual Item Type for Periodic Postings:

o Navigate to the SAP IMG (Implementation Guide) menu.

o Go to the following path: Accruals Management -> Basic Settings -> Accrual Item Types -> Define Item Types.

o For the accrual item type (e.g., COSTS_UPL), ensure it is configured to allow periodic postings but not opening postings.

2. Assign Accrual Item Types to Journal Entry Types and Posting Schemas:

o In the IMG, navigate to Accruals Management -> Assign Accrual Item Types to Journal Entry Types and Posting Schemas.

o Assign the transaction type PP (Periodic Posting) to the relevant posting schema.

o Do not assign transaction types IP (Initial Posting) to this posting schema.

Reason for Configuration:

Periodic Postings vs. Opening Postings:

o Periodic Postings (PP): These postings occur regularly over the periods specified and represent the periodic accrual amounts being recognized.

o Opening Postings (IP): These postings are made when the accrual object is initially created or changed, and they typically post the total amount to be accrued as an opening balance.

Handling Pre-calculated Amounts:

o When you upload pre-calculated accrual amounts for specific periods, the total amount to be accrued is effectively zero at the time of accrual object creation. This means no opening posting is required.

o The system assumes that the periodic amounts will be uploaded later, hence it does not perform an opening posting during the creation of the accrual object.

Impact of Configuration:

  • No Opening Posting During Creation: Because the total amount is zero during the creation of the accrual object, the system does not perform an opening posting. This aligns with the approach of uploading pre-calculated periodic amounts later.
  • Flexibility in Accruals Management: This configuration provides flexibility in managing accruals, especially when the amounts are calculated outside the system and need to be uploaded directly for each period.

To upload periodic amounts for an accrual object in S/4HANA, you need to follow a specific sequence of steps, including creating the accrual object and configuring it with the appropriate accrual method. Here's a detailed guide:

Steps to Create the Accrual Object and Upload Periodic Amounts:

1. Create the Accrual Object:

o Navigate to the transaction ACACTREE01/02.

o Create a new accrual object.

o When prompted to enter the accrual method, use the method UPLD_AMNT.

Configuring the Accrual Method:

2. Define or Assign the Accrual Method:

o You can use the predefined accrual method UPLD_AMNT, or you can create your own accrual method.

o If you create your own method, navigate to the IMG menu: Accruals Management -> Accrual Calculation -> Define Accrual Methods.

o Assign your custom accrual method to the ABAP class CL_ACE_CFG_METHOD_ITEM_PER.

KBA 3075507 – ACE_S4027 error during upload via tcode ACACTREE01

Uploading Periodic Amounts from EXCEL:

3. Download the EXCEL Template:

o In transaction ACACTREE01/02, find the option to download the EXCEL template for uploading periodic amounts.

o Download the template to your local machine.

4. Populate the EXCEL Template:

o Open the downloaded EXCEL template.

o Fill in the template with the pre-calculated accrual amounts for each period. Ensure the data is entered correctly for each accrual object.

5. Upload the EXCEL Template:

o Go back to transaction ACACTREE01/02.

o Use the upload function to upload the populated EXCEL template.

o The system will read the template and update the accrual objects with the specified periodic amounts.

Important Notes:

  •  Accrual Method UPLD_AMNT: This method is specifically designed for uploading pre-calculated amounts. Ensure that it is correctly specified when creating the accrual object.
  • Manual Editing: The amounts for the single periods can be uploaded from EXCEL, but they cannot be manually edited directly in transaction ACACTREE02. Any changes must be made in the EXCEL template and then re-uploaded.
  • Custom Accrual Methods: If you create a custom accrual method, ensure it is assigned to the ABAP class CL_ACE_CFG_METHOD_ITEM_PER to function correctly.



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *