| 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 | * | MANDT | Allow NULL? |
| 2 | TIMESPECUID | Internal Key (GUID) of a Time Allocation (TimeSpec) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_TIMESPECUID | Allow NULL? |
| 3 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_SIMVERSION | Allow NULL? |
| 4 | CREATED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 5 | CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 6 | CHANGED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 7 | CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 8 | VALID_FROM | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 9 | VALID_TO | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 10 | CAPACITY | Capacity of Resource/Duration of Requirement | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/LRP_CAPACITY | Allow NULL? |
| 11 | TIMEINTUID | GUID of a Time Interval | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_TIMEINTUID | Allow NULL? |
| 12 | DURATIONUID | Internal Key for Duration | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_DURATIONUID | Allow NULL? |
| 13 | TYPE | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 14 | ISPRIVATE | Flag for Private Time Descriptions | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_ISPRIVATE | Allow NULL? |
| 15 | PRIO | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 16 | NAME | External Key of WFM Object (GUID32) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_EXT_KEY | Allow NULL? |
| 17 | INFO | Char 80 | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | CHAR80 | Allow NULL? |
| 18 | TIMEINT_TYPE | Category of Period Description | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_TIME_RANGE_TYPE | Allow NULL? |
| 19 | AWTYP | WFM Application Category | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/LRP_AWTYP | Allow NULL? |
| 20 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 21 | HR_STATE | HR Transfer Status of Time Allocation | char | 1 | 0 | CHAR | (N' ') | Yes | | WFD_HR_STATE | Allow NULL? |
