Skip to Content
Actions

0FC_OP_01 (FI-CA Open Items on Key Date) DataSource Extraction

December 4, 2013 | 240 Views |
Follow

I would like to share a small information which I experienced couple of days back in my project.


I had a requirement to extract data from 0FC_OP_01 DataSource in my project. I activated the datasource and when checked in RSA3, zero records were extracted. Later when I checked in the DFKKOPBW (OI Extraction) table in SE16, it had no data.


I found the solution to pull data into DFKKOPBW table.


We have to perform the mass run activity from t-code FPBW by giving the Date ID and Identification. It extracts the open items data from base table DFKKOP table to DFKKOPBW table.


Untitled.jpg

Later check the DFKKOPBW table in SE16, it shows records.


Untitled1.jpg



Check in RSA3:


Untitled2.jpg


Later you can follow the basic steps of replicating in BW and designing the flow as per the project demands.


This is how you can extract data into 0FC_OP_01 (FI-CA Open Items on Key Date) DataSource.

To report this post you need to login first.

21 Comments

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

  1. Raman Korrapati

    You Always coming with good information Thanks poorna.

    Request to change doc header line as ” 0FC_OP_01 DataSource Extraction”.its might be easy to search on google by using data source name.

    Thanks

    (0) 
  6. mahesh bondula

    Dear  Anjaneya,

    Nice Blog, Great Job. I have bit doubt, what does “Identification AAA” refers to? I mean is it constant value to supplied for all the cases?  or its differs from module to module?

    Thanks & Regards,

    Mahesh

    (0) 
    1. Poornachandra Anjaneya Post author

      Hi Mahesh,

      Thanks for the nice comment.

      “AAA” is just a notification I used here, You can mention anything, its just like name of the run (for identification).

      Hope you understood.

      Regards

      Poorna

      (0) 

Leave a Reply