- Load all the Mapping tables that are part of the DTO changes in BW.
2. DSO that needs to be updated are below with flat files.
ADPFIAPM0 - DTO Integrated Accounting Doc Numbers and CC.
ADPFIAPM2- DTO Integrated Profit center Mappings
ADPFIAPM3- DTO Integrated WBS element Mappings
ADPFIAPM4- DTO Integrated Plant Mappings
ADPFIAPM5- DTO Integrated Order Mappings
ADPFIAPM6- DTO Integrated PO Number Mappings
ADPFIAPM7- DTO Integrated Recontract
ADFIAPSNP-DTO Snap Shot of DBFIAP01
All the above DSO’s except for the Snap shot (ADFIAPSNP) are loaded using the flat files.
3. ADFIAPSNP – Snap shot is a full back up of ZFR3 documents loaded on date 22nd
4. Before Start performing the data loads from DPFIAP01 to DBFIAP01 for the impacted Accounting document numbers below are sequence of activities to carried out.
- A) Delete all the incorrect Accounting Documents that are to be fixed through the mapping tables are to be deleted from DSO DSO_FI11.
- B) Take a backup of the Accounting Document numbers (documents required to be reloaded) related to 6422 CC to DSO ADSFIWCBK and delete the same from the DSO ODS_FIWC
- C) Perform the load from DPFIAP01 à DBFIAP01 for all the selected document numbers using full DTP and confirm the request is activated successfully.
- D) Load all the entries from ADSFIWCBK à ODS_FIWC back and activate the request after the step 4.C is completed successfully.
4 E.) Above all manual steps will require around 2 hours for completion.
5) Propagation of the request from DBFIAP01 will be performed by the regular process chain which are scheduled at 06:00 or 12:00 or 18:00hrs.
6) All the above activity needs an approximately 3 to 4 hours.
7) Perform the Complete drop and reload for the below Info cubes related to 6422.
CRFIAP01
CRFIAP05
CRFIPA08
CR_PUAP1 – (Selective deletion based on CC 6422).
CRFIAP06
CRFIPA06
CRFIPA01
Once the above activities are completed. Go to the next step of data loads related to 6440 and 2232.
Perform second data loads before 1st daily run is completed.
1.Perform the PI data load for Company Codes based on 2232 and 6440.
2.Run manual full load on company 2232 & 6440 with selections as Fiscal year 2023:
Check the regular Delta DTP and confirm any additional filters are there. The same filter criteria will be used while loading the selective full.
DPFIWC03 -> DBFIGL20
DPFIWC03 -> DPFIAR03
DPFIWC03 -> DPFIAP03
DPFIWC03 -> DPFIGL03
3.Empty the following cubes with compression:
CRFIAP03
CRFIAP05
CRFIPA04
CRFIPA05
CRFIPA08
CRFIAP06
CRFIPA09
CRFIGL08
CRFIGL20
CRFIGL21
CRFIGL22
4.Wait for the process chains of the 2nd daily run is completed. All the above dropped cubes will be updated with records in the regular process chain as single delta request.