The new wiki link for this data flow is here:
Technical Documentation - PAPM/CBS invoicing
Please update the new doc there and no longer here.
Table of Contents
General presentation
...
Link about the specifications :
CBS Database - support for inter-company invoicing
Roles & Access
Roles and access
...
| Global Filter Stream (Application) | Global Filter Rule | Global Filter | Global Filter Description | Global Filter Sign | Global Filter Option | Global Filter Low Value | Global Filter Hight Value | Global Filter Active |
| PAPM | AMNT | 1 | FILE NAME | CBS-PAPM-Driver1-Amount.xls | Y | |||
| PAPM | AMNT | 2 | DELTA QUEUE | 0 | Y | |||
| PAPM | AMNT | 3 | COUNTER OF LOADING | 19 | Y | |||
| PAPM | AUTHGR | 1 | Authorization | I | EQ | ZR_CBS_PAPM_FILE_UPLOAD | Y | |
| PAPM | AUTHGR | 2 | Authorization | I | EQ | ZR_CBS_PAPM_FILE_UPLOAD_TCODE | Y | |
| PAPM | CADR | 1 | FILE NAME | CBS-PAPM-Driver3-CADRE.xls | Y | |||
| PAPM | CADR | 2 | DELTA QUEUE | 0 | Y | |||
| PAPM | CADR | 3 | COUNTER OF LOADING | 9 | Y | |||
| PAPM | COAREA | 1 | Controlling area | I | EQ | ZCYT | Y | |
| PAPM | COMPCDE | 1 | Company Code | I | EQ | 7008 | USD | Y |
| PAPM | COMPCDE | 2 | Company Code | I | EQ | 7764 | EUR | Y |
| PAPM | HDCN | 1 | FILE NAME | CBS-PAPM-Driver2-HC.xls | Y | |||
| PAPM | HDCN | 2 | DELTA QUEUE | 0 | Y | |||
| PAPM | HDCN | 3 | COUNTER OF LOADING | 17 | Y | |||
| PAPM | LOGSYS | 1 | Source System | I | EQ | ZCBSPAPMUPLD | Y | |
| PAPM | PAPM_RUN | 1 | Identify current run for CY process chain (11,...,15) | I | EQ | 12 | Y | |
| PAPM | PAPM_STIME | 1 | START TIME ALLOWED for PAPM Loading | I | EQ | 11 | LOAD | Y |
| PAPM | PAPM_STIME | 2 | START TIME ALLOWED for PAPM Loading | I | EQ | 15 | LOAD | Y |
| PAPM | SENDMAIL | 1 | Send email | I | EQ | Thanga.Muthu-ext@solvay.com | Y | |
| PAPM | TIME | 1 | REFERENCE TIME FOR PAPM LOAD | I | EQ | 12 | Y | |
| PAPM | TYPE | 1 | REFERENCE TYPE FOR PAPM LOAD | I | EQ | NO_LOAD | Y | |
| PAPM | UNIXAMNT | 1 | Unix for Driver 1- Amount | I | EQ | /exploit/BW/PaPM/Driver_1_Amount | Y | |
| PAPM | UNIXCADR | 1 | Unix for Driver 3 for cadre | I | EQ | /exploit/BW/PaPM/Driver_3_Cadre | Y | |
| PAPM | UNIXHDCN | 1 | Unix for Driver 2 for HeadCount | I | EQ | /exploit/BW/PaPM/Driver_2_HeadCount | Y | |
There is an ABAP condition ZBW_UPDATE_GLB_FILTER used to define the hours that the process should be executed based on global filter rule PAPM_STIME, twice a day @11 Hours and 15 Hours.
Lay-out of files
CBS-PAPM-Driver 1-Amount
...
Flat file driver 02 structure : Advanced DSO APCOPA02
| Info-Object | Description | Type | Size | Key | Business rules and Comment |
|---|---|---|---|---|---|
0FISCVARNT | Fiscal year variant | CHAR | 2 | Y | Always K4 |
0FISCPER | Fiscal year / period | NUMC | 7 | Y | YYYYMMM |
0LOGSYS | source system | CHAR | 10 | N | check against global filter |
C_COMPCDE | Company code | CHAR | 4 | N | check with C_COMPCDE |
C_SITEDR2 | PAPM Site driver 2 | CHAR | 250 | N | Free Description |
C_CCDR02 | PAPM Company code Driver 02 | CHAR | 250 | N | Free Description |
K_HCDR02 | PAPM Nb Headcount per company Driver 02 | NUMB | 23 | N | length 16, decimals 16,'.' for decimals, with sign |
...
Flat file driver 03 structure : Advanced DSO APCOPA03
| Info-Object | Description | Type | Size | Key | Business rules and Comment |
|---|---|---|---|---|---|
0FISCVARNT | Fiscal year variant | CHAR | 2 | Y | Always K4 |
0FISCPER | Fiscal year / period | NUMC | 7 | Y | YYYYMMM |
0LOGSYS | source system | CHAR | 10 | N | check against global filter |
C_COMPCDE | Company code | CHAR | 4 | N | check with C_COMPCDE |
K_CDDR03 | PAPM Value Company code driver 03 | NUMB | 23 | N | length 16, decimals 16,'.' for decimals, with sign |
K_ALLDR03 | PAPM All Head count cadre and no cadre diver 03 | NUMB | 23 | N | length 16, decimals 16,'.' for decimals, with sign |
...
2. PC_CBS_PAPM_002A - PC CBS PaPM - Driver 2 Head Count Del PSA - Event Trigerred - PC_CBS_PAPM_002A
3.PC_CBS_PAPM_003A - PC CBS PaPM - Driver 3 Cadre Del PSA - Event Trigerred - PC_CBS_PAPM_003A
...
6. PC_CBS_PAPM_003 - PC CBS PaPM - Driver 3 Cadre - run in main Process chain
Main Chain
Data-loading Layers
Transformations
1.DTS_FF_PAPM_002 PC_FILE -> ADSO APCBSI01
2. DTS_FF_PAPM_003 PC_FILE -> ADSO APCBSI02
3. DTS_FF_PAPM_004 PC_FILE -> ADSO APCBSI03
Average performance
| Key Figure | Estimation |
|---|---|
| ~ Average Process Chain Runtime | |
| ~ Average nb of rows loaded per load | |
| ~ Total nb of rows loaded (if full) | |
| ~ Average Runtime for 10k lines |
...