General presentation

Objective of the application

Functional Specification Document:

Tool Leader + IT leader of the application: 

Usage information

History

Roles & Access

Roles and access

List of application role + menu role  and explanation if we have several applications role with specials rules.

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

Main steps:

1. Extract quantity total stock from ADSO ABMMIC01 in ADSO APCOMS01 with help of query BW_QRY_ABMMIC01_0001.
   

   The principal thing to know here it's about the way to extract the data.

   The goal is to extract and stock in APCOMS01 "Quantity Total Stock" 0TOTALSTCK from ABMMIC01. Info object 0TOTALSTCK is not physically stored in invenotry DSO. The only way to extract the key figure is to use a query as datasource (BW_QRY_ABMMIC01_0001).

   In query BW_QRY_ABMMIC01_0001 we used a variable "V_CALMONTH11" based on class ZCL_BIU001_V_0CALMONTH_0031.

   The class determine the month to load from current date and more or less x month(s). To know the number of months to add or removre from current date, the class read master data global filter (C_GLBFILT) on stream "STOCK_LOG":

   

   Normally, by default the month to load in ADSO APCOMS01 is current month - 1. To load other month it's necessary to change fields "low" and / or "hight" in master data.
   It's in ADSO APCOMS01 where we define by default C_SOURCE = LOGISTIC. We will use this field in filters to extract data from caclulation views to separate LOGISTIC data and WORKING CAPITAL (equal TRANSIT) data.

2. Use calculation views to consolidate the different data sources.
   
   1. See details on calculation views here.
      To use calculation views to load ADSO APCOMS04 we have two infopackages:
      
   • • IP: DTS_CV_FMCO_CO_MS_IM_FINAL - Full -Logistic-Prev Month → filter on calmonth to have by default current month - 1 and filter on field C_SOURCE to have only "LOGISTIC" data (from APCOMS01).
     • IP: DTS_CV_FMCO_CO_MS_IM_FINAL - Full -WC-LastDayPrevMonth → filter on posting date to have by default the last day of previous month and filter on C_SOURCE to have only "WORKING CAPITAL" data (equal TRANSIT data, from DBFIGL13).
   
   

3. Load ADSO ABCOMS01 and calculate key figuress for Model S.
   Last step is to caculate all key figures for Model S report, It's done in transformation TRSF: APCOMS04 -> ADSO ABCOMS01.
   
   In start routine, we delete some lines according to their company code or plant. Company code and plant to exclude are defined in master data global filter (C_GLBFILT) in stream "MODEL S" and rule "PLANT" or "COMPCDE":
   
   
   During the loading, the transformation will convert the unit and currencies key figures with help of conversion type UOM_MATNR2 (units) and CTK_MODELS (currencies).
   
   In end routine, we use key figures previously converted to create new ones:

   
   

Dependencies with other applications

Mains data sources:

Logistic data: ADSO ABMMIC01 - "Material stock".

Transit data: DBFIGL13 - "IM from FIGL: Line Items for G/L Acct (S) - Rhodia Level 2".

Integrated Margin data: ODS_PCP4 - "CCR: Integrated margin".

Data loadings

Info providers and objects loaded

Loading frequency

The loading is done after the process chain PC_INT_MARGIN - "Integrated Margin 2" normally once a month in the 3th workday.

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

BW_QRY_ABMMIC01_0001 - BW - Material Stock for extract model S (Core Query)

BW_QRY_CPCOMS01_0001 - Stock margin elimination report (Core Query)

BW_QRY_CPCOMS01_0002 - Stock Margin Elimination report 2 (Core Query)

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

Planned Evolution

• Replace query BW_QRY_ABMMIC01_0001 with new one based on composite provider CPMMIC02 and find a way to improve the loading time.