PTDW_QUOT_DB - Time Data Extract (Quota Transaction)
Time Data Extract (Quota Transaction) information is stored in SAP table PTDW_QUOT_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_QUOT_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 | ||
.INCLUDE | PTDW_QUOT_BLOCK | 0 | ||||
QUOTA | Reporting Quota Type | QUOTAT | CHAR | 16 | * | |
ENTITLE | Available entitlement of a personnel time quota | PTDW_ENTITLE_Q | QUAN | 6 | ||
TAKEN | Deducted Entitlement of a Personnel Time Quota | PTDW_REDUCED_Q | QUAN | 6 | ||
REPAYED | Compensated entitlement of a personnel time quota | PTDW_REPAYED_Q | QUAN | 6 | ||
ACCRUED | Inflow to a personnel time quota | PTDW_ADDED_Q | QUAN | 6 | ||
LAPSED | Forfeited Entitlement of a Personnel Time Quota | PTDW_LEFT_Q | QUAN | 6 | ||
UNIT | Unit of Measure | ROUNIT | UNIT | 6 | * | |
.INCLUDE | CI_PTDW_QUOT | 0 |