cancel
Showing results for 
Search instead for 
Did you mean: 

About Loading 0FI_AP_4 every hour

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member186445
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hi Tibollo,

i don't understand why i cant find the table in Se16. there is always Error: table BWOM_SETTING is not active in Directory

Former Member
0 Kudos

Hi,

Please check the table name with BWOM_SETTINGS,there is an 'S' in the name of table.

Thanks

Amit