| 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 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 3 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR | Allow NULL? |
| 4 | SHIPTO | IS-M: Retailer | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | EWKUN | Allow NULL? |
| 5 | SHIPTO_NAME | IS-M: Name and Address of Ship-to Party | nvarchar | 35 | 0 | CHAR | (N' ') | No | | JWE_NAME | Allow NULL? |
| 6 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 7 | KDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDGRP | Allow NULL? |
| 8 | EVKSTART | IS-M: Point of Sale Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | EVKSTART | Allow NULL? |
| 9 | EVKSTBEZ | POS Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | EVKSTBEZ | Allow NULL? |
| 10 | EVKFLAECHE | IS-M: POS Area Key | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | EVKFLAECHE | Allow NULL? |
| 11 | ISMGEOKATEGORIE | Geography Category (Geographical Location) for Point of Sale | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ISMGEOKATEGORIE | Allow NULL? |
| 12 | EUMSEINFL | External Sales Influence at POS (Primary) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | EUMSEINFL | Allow NULL? |
| 13 | SEGMENT | Segment for Dividing Up a Segmentation Group | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | JKSDFCSEGMENT | Allow NULL? |
| 14 | VARIANT_ID | Segmentation Variant in Forecast Planning | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | JSEG_VARIANT_ID | Allow NULL? |