1.0 Access Management 

2.0 DataFlow

2.1 Overview

Use the google presentation below as a template. This google presentation must be saved in the Reporting GDrive folder under the corresponding application. Then post the link to the document here.

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

Exemple of dataflow overview :

Template Application name DataFlow

2.2 Technical Rules on Workbench

6DB_GL_COST_PURCHASE DW2 → DSO_PCP2

Fields routines

There are 3 individual rountines in this transformation to divide the following key figure values that are of currencies Korean Won (KRW) and Japanese Yen (JPY) by 100.

• C_AMT_CP

• C_AMT_CNP

• C_AMT_AMO

DSO_PCP1

1) DTS_KEKO_CKIS → IFS_KEKO_CKIS

Fields routines

Fiscal Variant 0FISCVARNT is fixed to K4.

Cost Component Structure 0CCOMPSTRUC is fixed to Z1.

Fiscal Year/Period required some ABAP codings to convert the incoming data into the correct format to be updated.

For the key figure Variable Amount, abap code is required to take the total amount minus the fixed amount to get just the variable amount.  (WRTFW_KPF - WRTFW_KFX). 

2) FS_KEKO_CKIS → ODS_PCP1

A select is done on master data global filter in internal table  ITB_PLANT_REPLACE_PLANT

A select is done to take all records from ODS_PCP2 into table  gt_matrix.

Delete all records where the amount and quantity is equal to zero.

Fields routines

0COSTCOMP (Cost Component):

If source record for 0COSTCOMP is equal to ' ' (space = null / empty), we make a loop on gt_matrix (Else we keep 0COSTCOMP from source).

If gs_matrix-/BIC/C_COSTEL1 <= SOURCE_FIELDS-COSTELMNT and gs_matrix-/BIC/C_COSTEL2 >= SOURCE_FIELDS-COSTELMNT, we take the COSTCOMP from gt_matrix (ODS_PCP2).

In all cases, if 0COSTCOMP from source or from ODS_PCP2 is equal to ' ', the defaul value = 100.

0PLANT_COMP (Issuing Plant):

If C_MATNR = C_COMPNT and PLANT = PLANT_COMP and PCPITEMCAT = 'L' and VENDOR is not empty.

Read table ITB_PLANT_REPLACE_PLANT with help of field VENDOR (VENDOR from source = C_LOW from master data C_GLBFILT).

If something is found, the PLANT_COMP = PLANT from ITB_PLANT_REPLACE_PLANT (field C_HIGH from master data global filter).

Else, keep source PLANT_COMP.

ODS_PCP1 → ODS_PCP1

Collect into ITB_REF_DATE value from master data global filter (C_GLBFILT) for STREAM = F_COPC and RULE = ODS_PCP1

COSTDATE = low value from ITB_REF_DATE.

DTS_KEKO_CKIS → DSO_PCP1

Start routine

A select is done to take all records from ODS_PCP2 into table  gt_matrix.

Delete all records where the amount and quantity is equal to zero.

Delete records with Valuation variants ( BWVAR ) not equal to ZFO, Z25 and ZEP.

Fields routines

Fiscal Variant 0FISCVARNT is fixed to K4.

Cost Component Structure 0CCOMPSTRUC is fixed to Z1.

Costing Variant (0COSTVAR) is fixed to ZIP.

Fiscal Year/Period required some ABAP codings to convert the incoming data into the correct format to be updated.

For the key figure Variable Amount, abap code is required to take the total amount minus the fixed amount to get just the variable amount.  (WRTFW_KPF - WRTFW_KFX). 

DSO_PCP1 → DSO_PCP1

Start routine

1. Load DSO_PCP1 into itself with a look-up at DSO_PCP2 for matching records of the month with the following field value assigments:
   1. Generic Fields:
      • DSO_PCP1-C_PRODVER = ''.
      • DSO_PCP1-ACTTYPE = ''.
      • DSO_PCP1-C_COSTCTR = ''.
      • DSO_PCP1-PCP_RES = ''.
      • DSO_PCP1-WORKCENTER = ''.
      • DSO_PCP1-C_BOMNUM = ''.
      • DSO_PCP1-C_BOMUSAG = ''.
      • DSO_PCP1-C_BOMALT = ''.
      • DSO_PCP1-PLANT_COMP = DSO_PCP2-PLANT.
      • DSO_PCP1-C_COMPNT = DSO_PCP2-/BIC/C_MATPLNT.
      • DSO_PCP1-LOTSIZE_IT = DSO_PCP2-LOTSIZE.
      • DSO_PCP1-CURRENCY = DSO_PCP2-CURRENCY.
      • DSO_PCP1-UNIT = DSO_PCP2-UNIT.
      • DSO_PCP1-BASE_UOM = DSO_PCP1-UNIT.
      • DSO_PCP1-OI_MENGE = DSO_PCP1-LOTSIZE_IT.
      • DSO_PCP1-PRICE_UNIT = DSO_PCP1-LOTSIZE_IT.
   2. Variable Amount (CP):
      • DSO_PCP1-C_KAPOSNR = '1'.
      • DSO_PCP1-AMOUNT = DSO_PCP2-C_AMT_CP.
      • DSO_PCP1-AMOUNTVR = DSO_PCP1-AMOUNT.
      • DSO_PCP1-AMOUNTFX = 0.
      • DSO_PCP1-COSTELMNT = '0098150974'.
      • DSO_PCP1-COSTCOMP = '100'.
   3. Fixed Amount (CNP):
      • DSO_PCP1-C_KAPOSNR = '2'.
      • DSO_PCP1-AMOUNT = DSO_PCP2-C_AMT_CNP.
      • DSO_PCP1-AMOUNTVR = 0.
      • DSO_PCP1-AMOUNTFX = DSO_PCP1-AMOUNT.
      • DSO_PCP1-COSTELMNT = '0099430120'.
      • DSO_PCP1-COSTCOMP = '220'.
      • DSO_PCP1-PCPITEMCAT = 'E'.
      • DSO_PCP1-C_COMPNT = ''.
   4. Depreciation Amount (AMO):
      • DSO_PCP1-C_KAPOSNR = '3'.
      • DSO_PCP1-AMOUNT = LV_DSO_PCP2-C_AMT_AMO.
      • DSO_PCP1-AMOUNTVR = 0.
      • DSO_PCP1-AMOUNTFX = WA_PCP1_SP-AMOUNT.
      • DSO_PCP1-COSTELMNT = '0099438000'.
      • DSO_PCP1-COSTCOMP = '300'.
      • DSO_PCP1-PCPITEMCAT = 'E'.
      • DSO_PCP1-C_COMPNT = ''.

DSO_PCP3

a

2.2 Dependencies with other applications

We should have the information where the application is sending or receiving information (e.g. APD open hub) 

3.0 Data Loading

3.1 Info Providers and objects loaded 

Detail of process chain, list + link between or special event done for the loading