The following document provides an overview of AFI postings derivation logic for PEBT (Post External Business Transactions) and USBT (Update Secondary Business Transactions).

In a nutshell, PEBT posts on the suspense account key figure while the following step USBT picks up the amount and posts to the correct Balance Sheet or Income Statement Key Figure.  PEBT does a GAAP neutral processing while the application of additional calculations and/or GAAP dependent procedures happens in the following step, USBT.

Below, I will list separately, the AFI postings derivation logic for PEBT and USBT.

AFI postings derivation logic – PEBT

  1. From the Business Transaction (BT) primary object, for each item of the BT; the Item Type is read.
  2. Next, Derivation of Posting Key Figures from Item Type happens thru a derivation rule.
  3. Next, Derivation of GL Accounts from Posting Key Figures happens thru a derivation rule. Thus, following the above logic, AFI derives the GL postings.

AFI postings derivation logic – USBT

  1. From the Business Transaction (BT) primary object, BT Type is read.
  2. Next, the Calculation Procedure for that BT Type is determined thru a derivation rule which is defined in IMG. 
  3. Next, the Calculation Procedure settings are read to determine what Calculation Steps need to be executed.
  4. Next, the Calculation Procedure Steps are executed in sequence and for each step, Item Type is derived. Assignment of Item Type to Calculation Step is done in IMG.

After execution of each step,

  • If the result is >0; then the credit Item type is derived.
  • If the result is <0; then the debit Item type is derived.
  1. Next, Derivation of Posting Key Figures from Item Type happens thru a derivation rule.
  2. Next, Derivation of GL Accounts from Posting Key Figures happens thru a derivation rule. Thus, following the above logic, AFI derives the GL postings.

Links below lead to documents that provide step by step details with screenshots and IMG paths. You may have to copy the link in your browser.

https://docs.google.com/file/d/0B6cfdyS-QQM_Z2pNRzRUcHdmYm8/edit

https://docs.google.com/file/d/0B6cfdyS-QQM_UDgxUW1JeWt2MmM/edit

Comments are welcome.

Manish

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. Hasan Merchant

    Wonderful document depicting the process of AFI….

    After reading both the documents on PEBT and USBT, the concept of posting derivation is clear… 

    I sincerely appreciate your efforts in elaborating the process, step by step…

    Thanks

    Hasan Merchant

    (0) 
  2. Javier Ramirez

    Thanks for the information Manish.

    I need help, maybe you can help me.

    In this moment  I am trying to perform USBT but I have an error, I appreciate if you have some information about this error: System cannot find financial reporting preprocess.


    I created the legal entity, FT, BT… I performed the SDL process but when I perform the USBT process I see the error.


    I  would appreciate you send me information about the error. I think that can be an error about Legal Entity.


    Thanks.

    (0) 
    1. Srivijaya Gutala

      After PEBT , Have you checked the financial position being created ? Did you also check the RDL ? Check your CVPM process. Before USBT , it msut have been configures a pre process which it expects to be run. Also , check the detail log.

      (0) 
  3. Lahcen Babayi

    Hi Mani,

    Great information, thank you for that.

    I am also interested in the same summary for KDV.

    Could you please help?

    Thank you all

    Lahcen

    (0) 

Leave a Reply