Fi Extractors (Data loading)

[Former Member]

Hi All,

I am working FI(Payables(Vendor), Receivables (Customer), General Ledger), I please to know more information from you all most important point to be considered while working on Fi.

There are few question to be answered:

1. Is it required to lock posting during loading full loads (loading for first time)

2. In which way Update modes to be followed for loading (Full Update --> Int with out data >Init Delta)

3. What are recommended settings to be checked and made in (ECC/BW) while performing loads maunaully.

4.What are the areas to be noticed where we may uncertainty during loadings.

5. What are instruction to be given to basis guy during loading process.

6. Should we go for text data loading after master data & heirarchy else after maste, heirarchy, transaction data.

Please suggest.

Thanks

Taniya

[RamanKorrapati · Accepted solution]

Hi,

1. Not mandatory. in case of FI, for full loads data pulls from base tables.

so no issue. but chance to miss less records. mean if any record was created during your full load and saved after the full load, that would be missed.

better to do init with data transfer and later you can do repair full load with selection.

After the init newly created records will be captured in delta.

2. Above answer

3. check the system conditions and server loads schedules.

Available application servers is enough to process your loads or not. T code - SM50.

4. Major one is source system SM58 and keep on monitor your info pack,refresh

5.Ask him to check on TRFs SM58

6. Master data attributes, text and hierrachy, next transaction data loads.

Thanks

[Former Member · Accepted solution]

Hi Raman,

How are you, I really Appreciate your quick reply as always.

Thanks alot for detail answer for time being I put it helpful.

1. Not mandatory. in case of FI, for full loads data pulls from base tables.

so no issue. but chance to miss less records. mean if any record was created during your full load and saved after the full load, that would be missed.

better to do init with data transfer and later you can do repair full load with selection.

After the init newly created records will be captured in delta.

After INIT

> if I missed records how I would know?

> if I do full repair after INIT with Data then selection I have to be give.

(Here I have only two selcetion Company code, FisYr Per)

>Do I require to add Special period as well during loading.

3.Available application servers is enough to process your loads or not. T code - SM50

Currently There 10 DIA -  4 UPD - 4 BGD - 2 ENQ - UP2 Process started and only 1 DIA is running all are waiting state with my user id.

Hope for more.

Thanks alot again.

[RamanKorrapati · Accepted solution]

Hi,

Missed records information you will get thru report users or if you do the validation in that case you may find missing records.

1. if you do full load init with data, after the completion of this load only delta pointer will set. here you don't need selections.

2. if you do  init without data transfer, next you need do full load then in that case you need use repair full request with proper selections. about selections we can made required settings at source side RSA6 - here we can do Selection(check box)

About application servers - no issues. we have enough servers to process your load.

Thanks

[Former Member · Accepted solution]

Not clear about loading part.

You missed below point.

Do I require to add Special period as well during loading.

Thanks

[RamanKorrapati · Accepted solution]

Hi,

First of all what way  you want load.

init without data and repair full load  or  full load with init data.

About selections - its depend the way you loading.

Thanks

[Former Member · Accepted solution]

I suppose to follow

Init without data tranfer--> full load (based on company code or fis period or fis year)

About selections - its depend the way you loading.

Generally I am asking, do we consider special periods if we are loading based on periods.

Thanks

[RamanKorrapati · Accepted solution]

Hi,

You can use compcode or fiscperiod.

if you have huge data for full loads, in that case you can use fiscperiods or calmonth

about special periods - you can consider and load it. if source have data  then it will pulls.

Major point here you need load all records without missing single one.

Other wise do one thing.

1. Do full loads with any selections

2. run info pack init without data

3. you can run delta info pack pas per needs.

if possible try to load at weekends where there is no business.

Thanks

[Former Member · Accepted solution]

Thanks alot.

And final question.

if load based on fis period.Then how about the current month load?

If i mentioned 004.2014 from current month then what will be impact on delta records?

Thanks in advance.

[RamanKorrapati · Accepted solution]

if your using  present fiscperiod you may get the present month data also.

Upto today's date. if you seen duplicates in your loads you can delete them at cube level.

After the completion load, you can cross check the how many records are exist for todays date(changed/created) at source side and bw side.that will give the exact count for this to day.

[Former Member · Accepted solution]

Thanks Alot.