| 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 | LNK_GUID | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | No | | GUID | |
| 3 | SCO_VERSION | Routing Component Assignment Version of Planning Scope | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | /PLMB/RTG_RCA_SCO_VERSION | Allow NULL? |
| 4 | QUANTITY | RCA Assigned Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | /PLMB/RTG_RCA_LNK_QUANTITY | |
| 5 | UNIT | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | | UNIT | Allow NULL? |
| 6 | ASSEMBLY_SEQ | RCA Operation Assembly Sequence | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /PLMB/RTG_RCA_LNK_ASS_SEQU | Allow NULL? |
| 7 | PLNTY | Task List Type | char | 1 | 0 | CHAR | (N' ') | Yes | * | PLNTY | Allow NULL? |
| 8 | PLNNR | Key for Task List Group | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PLNNR | Allow NULL? |
| 9 | PLNAL | Group Counter | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PLNAL | Allow NULL? |
| 10 | PLNFL | Sequence | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | PLNFOLGE | Allow NULL? |
| 11 | PLNKN | Number of the task list node | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PLNKN | Allow NULL? |
| 12 | ZUONR | No. for material comp. allocation to task list | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | CIM_ZUORD | Allow NULL? |
| 13 | MARK_DEL_IND | Marked for Deletion at Next Synchronization Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /PLMB/RTG_RCA_LNK_MARK_DEL_IND | Allow NULL? |
| 14 | ALLIGNED_MAT | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | /PLMB/MATNR | Allow NULL? |
| 15 | ALLIGNED_IND | RCA Aligned Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /PLMB/RTG_RCA_LNK_ALLI_IND | Allow NULL? |
| 16 | CREADAT | Date on Which the Object Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /PLMB/RTG_RCA_ANDAT | Allow NULL? |
| 17 | CREABY | User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /PLMB/RTG_RCA_ANNAM | Allow NULL? |
| 18 | CHNGDAT | Date on Which the Object Was Last Changed | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /PLMB/RTG_RCA_AEDAT | Allow NULL? |
| 19 | CHNGBY | User Who Last Changed the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /PLMB/RTG_RCA_AENAM | Allow NULL? |