Skip to Content
Author's profile photo Former Member

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

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.

Assigned Tags

      21 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      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

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for the suggestion Raman. Will change it as per your advice. 🙂

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Pretty good.  Really useful blog and thanks for sharing. 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Krishna.. 🙂

      Author's profile photo Former Member
      Former Member

      Nice blog.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Giri

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Short and sweet.. 😛 informative blog Poornachandra Anjaneya.

      Regards,

      Harish

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Harish

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Former Member
      Former Member
      Blog 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

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Useful information..keep it up 🙂 .

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Ganesh.

      Author's profile photo Former Member
      Former Member

      Good Info Poorna 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Aravind... 🙂

      Author's profile photo Former Member
      Former Member

      Hi Poornachandra,

      Really useful and good one 🙂

      Thanks,

      Purushotham.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks for your feedback Purushotham.... 🙂

      Author's profile photo Former Member
      Former Member

      Nice work on the blogs

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Rahul

      Author's profile photo Former Member
      Former Member

      Thanks for sharing this useful information

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Emily... 🙂

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Useful information..Thanks for the write up.

      Regards,

      AL