| 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 | ORIGINAL_ART_NR | Original Material | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | ORIGINAL_ART_NR | Allow NULL? |
| 3 | FOLUP_ART_NR | Follow-Up/Replacement Material | nvarchar | 18 | 0 | CHAR | (N' ') | No | MARA | FOLUP_ART_NR | Allow NULL? |
| 4 | ASORT | Assortment | nvarchar | 10 | 0 | CHAR | (N' ') | No | WRS1 | ASORT | Allow NULL? |
| 5 | FOLLOWUP_TYP_NR | Follow-Up Category Number | nvarchar | 2 | 0 | CHAR | (N' ') | No | WRF_FOLUP_TYP | FOLLOWUP_TYP_NR | Allow NULL? |
| 6 | DATE_FROM | Follow-Up/Replacement Material Relationships Valid From | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATE_FROM_FOLUP | Allow NULL? |
| 7 | DATE_TO | Follow-Up/Replacement Material Relationships Valid To | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATE_TO_FOLUP | Allow NULL? |
| 8 | PRIORITY_A | Priority of Assignment: FU/Repl. Mat. to Original Material | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PRIORITY_A | Allow NULL? |
| 9 | FOLLOWUP_ACTION | Follow-Up Action | char | 1 | 0 | CHAR | (N' ') | Yes | | FOLLOWUP_ACTION | Allow NULL? |
| 10 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 11 | CREATE_TIMESTAMP | Creation Time in UTC | decimal | 15 | 0 | DEC | ((0)) | Yes | | CREATE_TIMESTAMP | |
| 12 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 13 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 14 | ORG_ART_FACTOR | Factor for Conversion of Units of Measure | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | UOMFACTOR | Allow NULL? |
| 15 | SUBST_ART_FACTOR | Factor for Conversion of Units of Measure | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | UOMFACTOR | Allow NULL? |