| 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 | LFART | Delivery Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVLK | LFART | Allow NULL? |
| 3 | MTPOS | Item category group from material master | nvarchar | 4 | 0 | CHAR | (N' ') | No | TPTM | MTPOS | Allow NULL? |
| 4 | VWPOS | Item usage | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | VWPOS | Allow NULL? |
| 5 | UEPST | Item category of the higher-level item | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVPT | UEPST_VL | Allow NULL? |
| 6 | PSTYV | Default item category for delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYD_VL | Allow NULL? |
| 7 | PSTY1 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 8 | PSTY2 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 9 | PSTY3 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 10 | PSTY4 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 11 | PSTY5 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 12 | PSTY6 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 13 | PSTY7 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 14 | PSTY8 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 15 | PSTY9 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 16 | PSTY10 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 17 | PSTY11 | Manual entries allowed for item category in the delivery | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVPT | PSTYM_VL | Allow NULL? |
| 18 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |