| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | PAGUID | Internal Identification for PVS Objects | varbinary | 16 | 0 | RAW | | No | PALTID | PVS_GUID | |
| 3 | PAMDCNT | Internal Counter for iPPE Objects | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PVS_COUNT | Allow NULL? |
| 4 | PAMCCNT | Internal Counter for iPPE Objects | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | PVS_COUNT | Allow NULL? |
| 5 | PNGUID | Identification of Object Reference in iPPE | varbinary | 16 | 0 | RAW | | Yes | | PPE_PGUID_REF | |
| 6 | RESUID | Internal Key (GUID) of Resource | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | * | PPE_RESUID | Allow NULL? |
| 7 | UNITC | Unit of Capacity Requirements | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PPE_CAPUNIT | Allow NULL? |
| 8 | CRQVAR | Variable Duration | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PPE_CARVAR | |
| 9 | CRQFIX | Duration (Lot Size Fixed) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PPE_CARFIX | |
| 10 | CAPREQ | Capacity Requirements | decimal | 15 | 5 | QUAN | ((0)) | Yes | | PPE_CAPACITY | |
| 11 | CAPREQFIX | Fixed Capacity Requirements | decimal | 15 | 5 | QUAN | ((0)) | Yes | | PPE_CAPACITY_FIX | |
| 12 | SETCALE | Indicator: Calendar Resource | char | 1 | 0 | CHAR | (N' ') | Yes | | PPE_SETCALE | Allow NULL? |
| 13 | BUCKETVAR | Variable Bucket Consumption | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PPE_CAP_BUCKET | |
| 14 | BUCKETFIX | Fixed Bucket Consumption | decimal | 13 | 3 | QUAN | ((0)) | Yes | | PPE_CAP_BUCKET_FIX | |
| 15 | BUCKETUNIT | Unit of Measurement of Bucket Resource Usage | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | PPE_CAP_UNIT_BUCKET | Allow NULL? |
