Skip to Content
author's profile photo Former Member
Former Member

About Loading 0FI_AP_4 every hour

Hi everyone,

i have full load datasource 0FI_AP_4 to ODS 0FI_O03 and from the ODS to Cube 0FI_C03 in BW. The full load was successful.

But i have read the SAP help and we can load delta for 0FI_AP_4 only once a day. to load more times a day, we need to adjust some thing in BWOM_SETTING. i would like to ask some questions:

  1. i enter transaction: SE16 but the table BWOM_SETTING is not active in dictionary. How can i find and change the setting of the table?Its very nice if you can send me some steps to change the setting of the table.
  2. as what i understand, i have to create 2 info packages: initial and delta info packages. Do we need to create 2 new transformation from the Datasource and DSO to run initial and delta load or can we use the current transformation, which has been used for full load ?
  3. About the Process chain: i still don't understand how we can design the Process chain to load delta data. in my thought, the Process Chain should looks like this

  • start process Chain
  • Delete PSA Request
  • Load delta data (run delta info package)
  • create Index
  • Data transferprocess between datasource and ODS
  • Data transferprocess between ODS and Cube
  • Create Index

is it correct Process Chain for loading delta?

Thankyou very much!

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jun 28, 2016 at 02:14 PM

    1. table is called BWOM_SETTINGS and you can find it in the source system

    2. you can use the same transformation

    3. looks ok. But you could hold on to your psa data for a week or so, in case of issues

    M.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2016 at 02:27 PM

    Hi,

    Please check the SAP Note: 991429 - Minute Based extraction enhancement for 0FI_*_4 extractors

    It clearly explains what need to be done in terms of settings of table BWOM_SETTINGS. (notice the S in the end of table name as M Tibollo has already pointed out)

    Follow the manual activities in the note if your system version is greater than what mentioned in SAP.

    Also please research on more related SAP notes.

    Thanks

    Amit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.