PTDW_TIMES_DB - Time Data Extract (Working Times)
Time Data Extract (Working Times) information is stored in SAP table PTDW_TIMES_DB.
It is part of development package PTDW in software component PT. This development package consists of objects that can be grouped under "Time Data Transfer to Business Information Warehouse (BW)".
It is part of development package PTDW in software component PT. This development package consists of objects that can be grouped under "Time Data Transfer to Business Information Warehouse (BW)".
Fields for table PTDW_TIMES_DB
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | * |
DWLFNR | Sequence Number for InfoSources in Time Management | X | DWLFNR | NUMC | 20 | |
.INCLUDE | PTDW_HEADER | 0 | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 16 | ||
KMONTH | Calendar year / month | RSCALMONTH | NUMC | 12 | ||
KDAY | Calendar day | RSCALDAY | DATS | 16 | ||
DWLFNRWP | Pointer to PTDW_WPBP_DB | DWLFNRWP | NUMC | 20 | ||
DWLFNRCO | Pointer to PTDW_COST_DB | DWLFNRCO | NUMC | 20 | ||
DWLFNRAR | Pointer to PTDW_ACTR_DB | DWLFNRAC | NUMC | 20 | ||
DWLFNRAS | Pointer to PTDW_ACTS_DB | DWLFNRAS | NUMC | 20 | ||
.INCLUDE | PTDW_TIMES_BLOCK | 0 | ||||
ALP_POSITION | Alternative position | ALP_POSTN | NUMC | 16 | * | |
ALP_RATE | Alternative valuation basis | ALP_RATE | CURR | 3 | ||
ALP_AMOUNT | Wage Type Amount for Payments | PAD_AMT7S | CURR | 7 | ||
ALP_CURRENCY | Currency Key | WAERS | CUKY | 10 | * | |
REPTT | Reporting Time Type | REPRTT | CHAR | 16 | * | |
DUR_ACTUAL | Actual time | DUR_ACTUAL_Q | QUAN | 5 | ||
DUR_VALUE | Account-Relevant Time | DUR_VALUE_Q | QUAN | 5 | ||
UNIT | Unit of Measure | ROUNIT | UNIT | 6 | * | |
.INCLUDE | CI_PTDW_TIMES | 0 |