| 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 | SIMID | WFM Planning Version (UID) | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_SIMVERSION | Allow NULL? |
| 3 | ASSIGNUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | No | | /SAPAPO/LRP_GUID | Allow NULL? |
| 4 | DEMANDUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 5 | RESUID | GUID of a Persistent Object | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_GUID | Allow NULL? |
| 6 | BEG_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 7 | END_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 8 | CAPA_REQ | Capacity of Resource/Duration of Requirement | int | 10 | 0 | INT4 | ((0)) | Yes | | /SAPAPO/LRP_CAPACITY | Allow NULL? |
| 9 | ROOT_UID | GUID of a Root Node | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_ROOT_UID | Allow NULL? |
| 10 | PARENT_UID | GUID of Parent Node | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_PARENT_UID | Allow NULL? |
| 11 | BOOKING_TYPE | Assignment Booking Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_ASSGN_BOOKING_TYPE | Allow NULL? |
| 12 | CONCRETE | Concrete Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_ASSGN_IS_CONCRETE | Allow NULL? |
| 13 | REFINED | Flag for Refinement | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_FLAG_REFINED | Allow NULL? |
| 14 | WTIME_BASED | WFM Core: ID for Working-Time-Based Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_WTIME_BASED | Allow NULL? |
| 15 | TIME_RULE_UID | WFM: Internal UID of Time Rule | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_TIME_RULE_UID | Allow NULL? |
| 16 | APPL_STATUS | WFD Server Application Status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_APPL_STATUS | Allow NULL? |
| 17 | DISP_STATUS | WFM LRP Dispatcher Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_DISPATCHER_STATUS | Allow NULL? |
| 18 | CREATED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 19 | CREATED_AWTYP | WFM Application Category | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/LRP_AWTYP | Allow NULL? |
| 20 | CREATED_LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 21 | CREATED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 22 | CHANGED_BY | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 23 | CHANGED | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 24 | CHANGED_AWTYP | WFM Application Category | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | /SAPAPO/LRP_AWTYP | Allow NULL? |
| 25 | CHANGED_LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 26 | RES_UTIL_RATIO | Resource Capacity Level | float | 15 | 16 | FLTP | ((0)) | Yes | | /SAPAPO/LRP_RES_UTIL_RATIO | |
| 27 | RES_UTIL_RATIO_O | Origin of Resource Capacity Level | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPAPO/LRP_RUR_ORIGIN | Allow NULL? |
| 28 | LONG_DESCRIPTION | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | char | 1 | 0 | CHAR | (N' ') | Yes | | BOOLE_D | Allow NULL? |
| 29 | DESCRIPTION | Assignment Description | nvarchar | 255 | 0 | | (N'') | Yes | | /SAPAPO/LRP_ASSGN_DESCR | Allow NULL? |
