Access Management
List of application role + menu role and explanation if we have several applications role with specials rules.
|
List of authorization objects mandatory for the application.
|
DataFlow
Overview
Technical Rules on Workbench
MPR_IC001 - Material stock / movement
CUB_IC001 - Material stock
Transformation: ODS_IC01 -> CUB_IC001
Key figures rules explained in document "Inventory Management - documentation" in sheet "stock quantities/values".
0GL_ACCOUNT is defined in function of 0VAL_CLASS:
C_MATPUVT (Material Plant Unit Price by Valuation Type): concatenation between PLANT - MATERIAL - VALUATION TYPE.
DTP: filter to exclude materials 102283, 104123, 104740, 105984, 105985, 105986, 107266, 111400, 120707, 139210.
TRCS IFS_2LIS_03_BF -> ODSO ODS_IC01
0VAL_TYPE / 0SHIP_TO / C_EXIDV / : remove strange characters with module function "ZF_INVALID_CHARACTERS".
RSDS 2LIS_03_BF WP1_400 -> TRCS IFS_2LIS_03_BF
0VENDOR comes from master data 0PLANT (field LIFNR) in function of BWART (movement type), SHKZG (Debit/Credit) and SOBKZ (Receiving plant). For more detail check the routines.
Transformation: ODS_IC02 -> CUB_IC001
Sames rules as Transformation: ODS_IC01 -> CUB_IC001
TRCS IFS_2LIS_03_UM -> ODSO ODS_IC02
Delete records whene STOCKCAT = V or STOCKTYPE = V.
CUB_PP02 - Production Planning In/Out Material
TRSF: DTS_SCM_MD04 -> CUB_PP02 (ECC6)
C_PRODORD: equal field DEL12 (MRP element number) if DELKZ (MRP elmnt ind.) equal 'BR' or 'FE' or 'AR'.
0VENDOR: if DELKZ (MRP elmnt ind.) equal 'PA' or 'BA' or 'BE' and if field PLUMI (Plus/minus) = '+' and field WERKS (Plant) <> field WRK02 (Producing plant) then read master data PLANT and take field LFINR.
0COMP_CODE: if field werks (plant) is not empty, reand master data PLANT and take the field BURKS associated.
0SOLD_TO: if DELKZ (MRP elmnt ind.) equal 'U1' or 'U2' or 'U3' or 'U4' and if field PLUMI (Plus/minus) = '-' read master data PLANT with field WRK02 (Producing plant) and take field KUNNR associated.
When DELKZ (MRP elmnt ind.) equal 'VJ' and if PLUMI (Plus/minus) = '-' 0SOLD_TO equal source field KUNWE (Ship-To Party).
C_RESWK (Supplying (issuing) plant in case of stock transport order): if DELKZ (MRP elmnt ind.) equal 'PA' or 'BA' or 'BE' and if field PLUMI (Plus/minus) = '+' then C_RESWK = source field WRK02 (Producing plant).
0MOVE_PLANT (Receiving Plant/Issuing Plant): if DELKZ (MRP elmnt ind.) equal 'U1' or 'U2' or 'U3' or 'U4' and if field PLUMI (Plus/minus) = '-' read master data PLANT with field WRK02 (Producing plant) and take field KUNNR associated.
When DELKZ (MRP elmnt ind.) equal 'VJ' and if PLUMI (Plus/minus) = '-' → read master data PLANT with source field ZZVKORG (Sales Org.) or KUNWE (Ship-To Party) and take the plant associated from master data.
DTP: filter to exclude materials 102283, 104123, 104740, 105984, 105985, 105986, 107266, 111400, 120707, 139210. Snapshot = DAY or DAY_AP or SOIP1 or SOIP2.
CUB_PP01 - Production Planning MAD
TRSF: DTS_SCM_MD04 -> CUB_PP01 (ECC6)
For C_PRODORD, 0COMP_CODE, 0MOVE_PLANT, 0SOLD_TO and C_RESWK → same tules as TRSF: DTS_SCM_MD04 -> CUB_PP02 (ECC6).
C_NEWMON (GR Month) & C_NEWDATE (Goods Receipt Date):
- If field PLUMI = '+', module function DATE_CONVERT_TO_FACTORYDATE is used to convert the source field date DAT00 (Planned date) with calendar 'BE'. Then date after conversion minus source field WEBAZ (GR proc. time). Then we use again a module fonction FACTORYDATE_CONVERT_TO_DATE (with alendar BE).
- If field PLUMI <> '+' we just use the result of module function DATE_CONVERT_TO_FACTORYDATE is used to convert the source field date DAT00 (Planned date) with calendar 'BE'.
DTP: filter to exclude materials 102283, 104123, 104740, 105984, 105985, 105986, 107266, 111400, 120707, 139210. Snapshot = DAY or DAY_AP or SOIP1 or SOIP2.
CUB_IC002 - Material movements
Transformation: ODS_IC01 -> CUB_IC002
Start routine: delete records where company code is liste in master data global filter:
C_BAUGR (Material number of higher-level assembly): if C_BAUGR is empty and C_PRODORD (Manufacturing Order) is not empty, take the C_MATNR from master data C_PRODORD.
C_LIP01S (Product line 01 Higher Level): if C_PRODORD (Manufacturing Order) is not empty, take the C_LIP01 (Product line 01) from master data C_PRODORD.
C_LPRODS (Product Line 00 Higher Level): if C_PRODORD (Manufacturing Order) is not empty, take the C_LIPROD (Product line 00) from master data C_PRODORD.
C_PRODS (Commercial Product higher level): if C_PRODORD (Manufacturing Order) is not empty, take the C_PROD (Commercial Product / Material Group) from master data C_PRODORD.
DTP: filter to exclude materials 102283, 104123, 104740, 105984, 105985, 105986, 107266, 111400, 120707, 139210.
CUB_COPC1 - Material Prices
Transformation: 0COPC_O01 -> CUB_COPC1
BASE_UOM comes from master data C_MATNR.
DTP: filter to include materials 102283, 104123, 104740, 105984, 105985, 105986, 107266, 111400, 120707, 139210 and currency type not equal 10. Group semantic on MATERIAL / PLANT / VAL_TYPE / FISCPER3 / FISCYEAR / PRICE_TYPE / FISCVARNT / VAL_CLASS / VALUATION / STLMT_CTRL / PRICE_CTRL / COMP_CODE / MAT_PLANT
CUB_CAP - Capacity Planning - Weekly & CUB_CAPM - Capacity Planning - Monthly
RSDS DTS_DPS_CAPACITY WP1_400 -> CUBE CUB_CAP & RSDS DTS_DPS_CAPACITY WP1_400 -> CUBE CUB_CAPM
Delete data where:
- KBEASOLL (Proc. Schd.) is empty
- FSTAD (Earliest start) is lower than date of loading.
C_MATNR = 'DUMMY' for each week / workcenter
k_capav is calculated in end routine in function of the calweek and also the date, plant and workcenter (with module function "Z_WBW_READ_KAZY").
DTP: filter on snapshot = LTP or DAY (depends of DTP) + group semantic on WERKS and MDV01.
Reporting
| Query | Description |
|---|---|
| BW_QRY_APD_MPR_IC001_0037 | BW - EHS - Movement Production to APD for SVT RO (Core Query |
| BW_QRY_APD_MPR_IC001_0037_JBA | BW - EHS - Movement Production Check |
| BW_QRY_CUB_IC002_6001 | BW - Inventory Movements Report |
| BW_QRY_CUB_IC002_VS_0001 | BW - Production by Materials As is - Detail Analysis (Core) |
| BW_QRY_CUB_PP02_0001 | BW - MRP Elements in the past (Core Query) |
| BW_QRY_CUB_PP02_0002 | BW - Production Planning (8 weeks) (Core Query) |
| BW_QRY_CUB_PP02_QVRCSKPI_0002 | BW - Production Planning (8 weeks) (QV) |
| BW_QRY_MPR_IC001_0001 | BW - Inventory Aging Report (Core Query) |
| BW_QRY_MPR_IC001_0001_BIN | BW - Inventory Aging Report Storage bin |
| BW_QRY_MPR_IC001_0001_POLAND | BW - Inventory Aging Report (JMALBORSKA) |
| BW_QRY_MPR_IC001_0002 | BW - Projected Stocks 60 days (Core Query) |
| BW_QRY_MPR_IC001_0003 | BW - Assistance cleaning of the material (Core Query) |
| BW_QRY_MPR_IC001_0006 | BW - DYNASYS - Stock evolution (APD Export Query) |
| BW_QRY_MPR_IC001_0013 | BW - Stock Movement Production (Core query) |
| BW_QRY_MPR_IC001_0013_EHS | BW - Stock Movement Production (EHS query) |
| BW_QRY_MPR_IC001_0013_JHILAIRE | BW_QRY_MPR_IC001_0013_JHILAIRE |
| BW_QRY_MPR_IC001_0013_JHILAIRE | BW - Stock Movement Production-JHILAIRE(Core query) |
| BW_QRY_MPR_IC001_0013B | BW - Stock Movement Production - Comm Choice (Core) |
| BW_QRY_MPR_IC001_0014 | BW - Stock Movement All Types (Core query) |
| BW_QRY_MPR_IC001_0014_EHS | BW - Stock Movement All Types (EHS query) |
| BW_QRY_MPR_IC001_0016 | BW - Stock Movement Production Neutralized by zone (Core que |
| BW_QRY_MPR_IC001_0017 | BW - Stock and Planning report (Core query) |
| BW_QRY_MPR_IC001_0017B | BW - Stock and Planning Month Snapshot (Core query) |
| BW_QRY_MPR_IC001_0017B_GR01 | BW - Stock and Planning Month Snapshot (Core query) - GR |
| BW_QRY_MPR_IC001_0018 | BW - Stock and Planning Month Snapshot (Core query) - GR |
| BW_QRY_MPR_IC001_0020 | BW - Stocks by Profit Center (Core Query) |
| BW_QRY_MPR_IC001_0026 | BW - Movements value/qty evolution (Core Query) |
| BW_QRY_MPR_IC001_0026_EP | BW - Stocks Evolution EP (Specific) |
| BW_QRY_MPR_IC001_0026_EP2 | BW - Stocks Evolution EP (Specific 2) |
| BW_QRY_MPR_IC001_0026_GSV | BW_QRY_MPR_IC001_0026_GSV |
| BW_QRY_MPR_IC001_0027 | BW - Average Turn - 3 month (Core Query) |
| BW_QRY_MPR_IC001_0028 | BW - Turn Evolution - 3 month (Core Query) |
| BW_QRY_MPR_IC001_0029 | BW - Turn - 91 days (Core Query) |
| BW_QRY_MPR_IC001_0031 | BW - Stock evolution (Core Query) |
| BW_QRY_MPR_IC001_0031_BCAST | BW - Stock evolution (BROADCAST) |
| BW_QRY_MPR_IC001_0031_BCAST02 | BW - Stock evolution M-1 (BCAST02) |
| BW_QRY_MPR_IC001_0031_BCAST03 | BW - Stock evolution 12 last months (BCAST03) |
| BW_QRY_MPR_IC001_0031_BCAST04 | BW - Stock evolution current month (BCAST04) |
| BW_QRY_MPR_IC001_0031_BCASTM | BW - Stock evolution M M-1 (BROADCAST) |
| BW_QRY_MPR_IC001_0031FRANCO | BW - Stock evolution |
| BW_QRY_MPR_IC001_0033 | BW - Actual stock VS Safety stock Comparaison (Core Query) |
| BW_QRY_MPR_IC001_0034 | BW - Inventory level for AROMA dashboard - SCREEN (QV Query) |
| BW_QRY_MPR_IC001_0035 | BW - Movement Prodution to APD (Core Query) |
| BW_QRY_MPR_IC001_0036 | BW - Movement Production to APD for REACH (Core Query) |
| BW_QRY_MPR_IC001_0051 | BW - Stock Values and Quantities (Core Query) |
| BW_QRY_MPR_IC001_0059 | BW - Homogation Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0060 | BW - Consignment Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0061 | BW - Blocked Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0062 | BW - Stock evolution with conversion (Core Query) |
| BW_QRY_MPR_IC001_0062_BCAST | BW - Stock evolution with conversion (BROADCAST) |
| BW_QRY_MPR_IC001_0062_BH | BW - Stock evolution with conversion light (spec BH) |
| BW_QRY_MPR_IC001_0062_BH2 | BW - Stock evolution with conversion light (spec BH BATCH) |
| BW_QRY_MPR_IC001_0062_BH3 | BW - Stock evolution with conversion light (spec BH INVENTOR |
| BW_QRY_MPR_IC001_0062_NA | BW - Stock evolution with conversion (NA) |
| BW_QRY_MPR_IC001_0062_NA | BW - Stock evolution with conversion (NA) (Core query) |
| BW_QRY_MPR_IC001_0062_NA2 | BW - Stock evolution with conversion (NA) (Core query) |
| BW_QRY_MPR_IC001_0063 | BW - Stock Mmvt with conversion (Core query) |
| BW_QRY_MPR_IC001_0065 | BW - Value stream production (Core query) |
| BW_QRY_MPR_IC001_0066 | BW - Stock Mmvt in base/prompt/active unit (Core Query) |
| BW_QRY_MPR_IC001_0067 | BW - Turn Evolution - 1 year (Core Query) |
| BW_QRY_MPR_IC001_0068 | BW - Stock and Planning report by week (Core query) |
| BW_QRY_MPR_IC001_0072 | BW - Vendor Consignment Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0073 | BW - Restricted Use Stock (Dynasys Extract) |
| BW_QRY_MPR_IC001_0074 | BW - Inventory End of Month RCS (Dynasys Extract) |
| BW_QRY_MPR_IC001_0128 | BW - Physical inventory coverage rate - MPR_IC001 |
| BW_QRY_MPR_IC001_063 | BW - EHS - Neutralized Production Other data for EHS |
| BW_QRY_MPR_IC001_064 | BW - EHS - Neutralized Production Japan data for EHS |
| BW_QRY_MPR_IC001_065 | BW - EHS - Neutralized Production Australia data for EHS |
| BW_QRY_MPR_IC001_066 | BW - EHS - Neutralized Production data for EHS (Hana Flow) |
| BW_QRY_MPR_IC001_6068 | Rhodia UK Stock Report (Core Query) |
| BW_QRY_MPR_IC001_75 | BW - Customer Inventory End of Month RCS (Dynasys Extract) |
| BW_QRY_MPR_IC001_76 | BW - Unrestricted Stock RCS in the future (Dynasys Extract) |
| BW_QRY_MPR_IC001_9000 | BW - Inventory Value (Core query) |
| BW_QRY_MPR_IC001_9003 | BW - Spare Parts Movements AVG (LA Specific) |
| BW_QRY_MPR_IC001_9003_KWC | BW - Spare Parts Movements AVG (LA Sp kwc) |
| BW_QRY_MPR_IC001_9004 | BW - Spare Parts Free Stocks (LA Specific) |
| BW_QRY_MPR_IC001_9005 | BW - Spare Parts Unit Price (LA Specific) |
| BW_QRY_MPR_IC001_9099 | BW - Inventory Value (BROADCAST) |
| BW_QRY_MPR_IC001_BCAST_001 | BW_QRY_MPR_IC001_BCAST_001 |
| BW_QRY_MPR_IC001_SYNTH_0273 | Prod Ventes Stocks - Valence (core query) |
| BW_QRY_MPR_IC001_VS_0001 | BW - Production by Materials As is - Detail Analysis (Core) |
| QV_BW_QRY_MPR_IC001_0013 | QV-BW- Stock Movement Production (QV) |
| QVEPSC_BW_QRY_MPR_IC001_0062 | BW - Stock Evolution with Conversion (QV-EP-SC) |
| QVNVSC_BW_QRY_MPR_IC001_0001 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0001B | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002 | BW - Inventory Aging Report (QV Query) |
| QVNVSC_BW_QRY_MPR_IC001_0002DZ | LDZ - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0003 | BW - Inventory Aging Report (QVNVSC Core Query) |
| QVNVSC_BW_QRY_MPR_IC001_0016 | BW - Stock Movement Production Neutralized by zone (Core que |
| QVNVSC_BW_QRY_MPR_IC001_0026 | BW - Movements value/qty evolution (QV Query) |
| QVNVSC_BW_QRY_MPR_IC001_0063 | BW - Stock Mmvt with conversion (QV) |
| QVNVSC_BW_QRY_MPR_IC001_0065 | BW - Value stream production (QV query) |
| QVNVSC_BW_QRY_MPR_IC001_0071 | BW - Stock evolution with conversion (Core Query) for Qlikvi |
| QVSBS_BW_QRY_MPR_IC001_0001 | BW - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0002 | BW - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0003 | QV - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0004 | QV - Stock Movement All Types (Core query) Qlik |
| QVSBS_BW_QRY_MPR_IC001_0014 | BW - Stock Movement All Types (Core query) Qlick |
| QVSBS_BW_QRY_MPR_IC001_0051 | BW - Stock Values and Quantities (Core Query) |
Dependencies with other applications
We should have the information where the application is sending or receiving information (e.g. APD open hub)
Data Loading
Info Providers and objects loaded
Detail of process chain, list + link between or special event done for the loading
| Main Process Chain | Final Provider Loading | Frequency | Time start | Duration |
|---|---|---|---|---|
Production Planning - Monthly PC_PP_01 | CUB_PP01 & CUB_PP02 | 1 time per month (3th day of the month) | Arround 01:00 am | 10 mins |
Production Planning - Daily PC_PP_01 | CUB_PP01 & CUB_PP02 | Daily (not weekend) | Arround 00:30 am | 12 mins |
RCP_MMIC 03a IC Complete Transactional FI_IC_DELTA_EXTR_HOURLY 03b IC Minimun Transactional | CUB_IC001 & CUB_IC002 | Daily (not weekend) | Arround 6:30 am Arround 12:30 pm and 6:30 pm | 10 mins |
Chaîne PMP PMP_VAR | CUB_COPC1 | Scheduled by RSP_DAILY Daily (not weekend) | Arround 0:00 am | 10 mins |
Capacity Planning ZPC_CAPACITY | CUB_CAP CUB_CAPM | Scheduled by RSP_DAILY_02 Daily (not weekend) | Arround 1:00 am | |
Data Quality Control
Operational Documentation
Procedures
<Describe the recurring procedures needed to operate the application (eg. start/pause/terminate/restart the app processes, data preparation, data ingestion, ETL, data visualization, data export, other manual activities)>
Scheduling
<Describe the scheduling in place for the application (eg. existing jobs, trigger time/event based, dependencies)>
Monitoring
<Describe the monitoring checks to confirm the application is performing well (eg. check the overall status, check performance metrics like runtime/data volume/memory/disk/CPU, maintain and react to alerts/notifications)>
Error Handling
<Describe how to handle errors (eg. error codes, description and respective resolution, alert users)>
Known Bugs
<List the existing bugs, its criticity, workarounds and resolution plan.>
Roadmap
<List past & future evolutions for the application (including links to MED/FSD/TSD)>