Skip to Content
Author's profile photo Former Member

A step by step guide for Invoicing Extraction (FI-CA)

This document will guide through the steps to implement for extraction of invoice in FI-CA.

Introduction to FI-CA flow

There are 3 main areas in FI-CA, Invoicing, Posting and Payment. Below is a small diagram illustrating the overall data flow of the SD & FI-CA, FI-CO.

Scheduling - 1.jpg

Explanation above illustration:

After SD billing has taken into place then the document created is Invoice. When Invoice is saved at the same time Posting document is also generated. Invoice is related to AR accounting where as Posting is related to GL Accounting.

Then afterwards when customer does the payment then Payment document is generated when payment is done via payment run or payment transaction (FPCJ, Cash journal, T-code).

BW Part:

As highlighted in red box in the above screen, I will go through extractors which are used for FI-CA data extraction.

Below are the extractors for each area:

Invoice – 0FC_INVDOC_00 (FICA Extraction of Invoicing Document Data)

Posting – 0FC_BP_ITEMS (FI-CA Business Partner Items) or 0FC_CI_01 (FICA Cleared Items for Interval) or 0FC_OP_01 (FI-CA Open Items at Key Date)

Payment – 0FC_PAY (Payments)

 

Invoice Extraction (FI-CA)

Below are the brief steps for Invoicing  Extraction:

  1. Datasource name has to be maintained in each invoicing processes (step1)
  2. Required invoice source document category and invoice source item category in the custom FM.
  3. The reconciliation key should be always closed.

Without satisfying any of the above conditions datasource cannot pull data for that particular invoicing process.

STEPS

There are few major steps which have to be carried out in source system before we extract data into BW.

Step 1> Maintain Datasource field in each invoicing processes in SPRO (IMG Customization)  in the below path

SPRO–>Financial Management (New) –>Contract Accounts Receivable and Payable–>Integration–>Invoicing in Contract Accounts Receivable and Payable–>Invoicing–>Invoicing processes

/wp-content/uploads/2014/04/3_443304.jpg

Below is the little introduction from help.sap.com on event 2710

/wp-content/uploads/2014/04/4_443305.jpg

 

Step 2> SPRO–>Financial Management (New) –>Contract Accounts Receivable and PayableàProgram EnhancementsàDefine Customer-Specific Function Modules


/wp-content/uploads/2014/04/5_443318.jpg

Copy the sample FM given by SAP “FKK_SAMPLE_2710” and make changes as per your requirement for example to pull different type of invoice source document category and invoice source item category (maintained in DFKKINVDOC_I table).

Even though if datasource is maintained in SPRO in each invoicing processes (look in Step 1) these changes in the custom FM can impact in extraction of data to BW.

For EX: I’ve added the below code in the custom FM “Y_BIFKK_SAMPLE_2710” to extract “C1” Collective invoices.

/wp-content/uploads/2014/04/6_443319.jpg

 

Step 3> Run the t-code “FKKINV_BW_MON” to check the relevant documents which are ready to extract into BW.

/wp-content/uploads/2014/04/7_443320.jpg

/wp-content/uploads/2014/04/8_443321.jpg

In the above screen lock symbol beside RECONCIL. KEY is OPEN those are not posted into BW.

For EX: Scenario 1 take the below record:

/wp-content/uploads/2014/04/9_443324.jpg

As per SAP standard invoicing process “C1” is not pulled into BW. But after I added my code in custom FM and maintained this custom FM in EVENT 2710 then this “C1” invoice document is pulled into BW.

Another condition for extraction reconciliation key is to be closed.

After the simulation, log will show whether the documents are able to pull into bw or any issues

/wp-content/uploads/2014/04/10_443325.jpg

/wp-content/uploads/2014/04/11_443326.jpg

Scenario 2 take the below record:

/wp-content/uploads/2014/04/12_443336.jpg

The above record shouldn’t be pulled as the reconciliation key is not closed.

After simulation:

/wp-content/uploads/2014/04/13_443337.jpg

/wp-content/uploads/2014/04/14_443338.jpg

/wp-content/uploads/2014/04/15_443339.jpg

Step 4> Go to t-code “FKKINV_BW_MA” to run the extraction job to DELTA tables (like MCEX jobs in LIS).

/wp-content/uploads/2014/04/16_443340.jpg

Look for completed status:

/wp-content/uploads/2014/04/17_443341.jpg

In RSA7:

/wp-content/uploads/2014/04/18_443342.jpg

Step 5>

If you are loading for the first time then run an Infopackage with option “INIT with DATA”. After the run is successfully you won’t get any record but a system record for the datasource.

Then you have run the delta infopackage to get the data into BW.

Run DELTA infopackage in BW to extract those delta invoice documents and look for the invoicing processes in PSA.

After my test changes in custom FM and closing reconciliation key, I could able to pull “C1” and “F4”.

/wp-content/uploads/2014/04/19_443343.jpg

 

The above detailed steps will go through detailed extraction of Invoice.

 

Please find the below help.sap.com links for more information

 

Update of Invoicing Data to SAP NetWeaver BW – Integration with Other Components and Products – SAP Library

  

Kindly provide your valuable feedback.

 

 

Other documents from my knowledge base:

 

Scheduling FI-CA related Delta Extraction

Triggering Process chain after completion of ECC Delta Extraction Job

Golden rules/Tips & Tricks for BW/BI Designing

Automation of the Data Load from SAP R/3 to BI

Design Solutions for BI/BOBJ Reporting (Part 1)

Assigned Tags

      13 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear All,

      Please provide your valuable inputs/comments for betterment of this document.

      If you like this document please give rating.

      Thanks a ton in advance!

      Warm Regards,

      Ravi Kanth

      Author's profile photo Raki R
      Raki R

      Hi Ravi.....thnkx for the detailed explanation...really very useful doc.....keep it up plz..

      Author's profile photo Former Member
      Former Member

      Nice one Ravi.. Informative

      Author's profile photo abilash n
      abilash n

      Ravikanth very nicely done. keep it up. Thanks for your patience in making this document.

      Author's profile photo ARPAN PARNAMI
      ARPAN PARNAMI

      Hi Ravikanth,

      Thanks for document.

      Very informative document, nicely explain.

      Thanks,

      Arpan

      Author's profile photo Former Member
      Former Member

      Thank you one and all!!

      Author's profile photo Former Member
      Former Member

      Ravikanth,

      Very detailed & informative document.

      Thanks,

      Sukadev

      Author's profile photo Former Member
      Former Member

      Thank you Ravi, It is very nice document and Informative 🙂

      Author's profile photo Former Member
      Former Member

      Anna,

      As ppl set it's a detailed information, but didn't understand why didn't u start earlier.

      The few blogs done by you are exceptionally good.

      Once again thx for those

      Author's profile photo Former Member
      Former Member

      Thanks for the Doc Ravi

      Author's profile photo Former Member
      Former Member

      Ravi,

      Very detailed document. Thank you

      Regards/Gouda

      Author's profile photo Former Member
      Former Member

      Great work Ravi.

      Author's profile photo Andrea Costantini
      Andrea Costantini

      Great info Ravi! Thanks a lot!

      Checking the user's requirements, I need to extract invoiced and simulated records created by the
      invoicing process.
      I found a restriction into the event 2710 function module and I comment that line, as follows:

      *  CHECK i_invdoc-invdoc_h-invoiced = 'X'.

      MOVE-CORRESPONDING i_invdoc-invdoc_h TO ls_extract.
      ls_extract-invdoc_crdate  i_invdoc-invdoc_h-crdate.
      ls_extract-invdoc_doctype i_invdoc-invdoc_h-doctype.
      IF NOT i_invdoc-invdoc_h-reverseddoc IS INITIAL.
      ls_extract-xreversal 'X'.
      ENDIF.

      However, when the user executes a simulation process to create simulated records, those records don't be created into the table DFKKINV_BWTRIG.

      Please, any help with this? How can I make the simulation records be created in the table DFKKINV_BWTRIG?

      Thanks in advance!
      Andrea.