| 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 | LOCNR | Customer Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | KNA1 | KUNNR | Allow NULL? |
| 3 | EROED | Opening date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | EROED | Allow NULL? |
| 4 | SCHLD | Closing date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SCHLD | Allow NULL? |
| 5 | SPDAB | Block from | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPDAB | Allow NULL? |
| 6 | SPDBI | Block to | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPDBI | Allow NULL? |
| 7 | AUTOB | Automatic purchase order | char | 1 | 0 | CHAR | (N' ') | No | | AUTOB | Allow NULL? |
| 8 | KOPRO | POS outbound profile | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWPFI | POSKOPRO | Allow NULL? |
| 9 | LAYVR | Layout | nvarchar | 10 | 0 | CHAR | (N' ') | No | TWGV | LAYVAR | Allow NULL? |
| 10 | FLVAR | Area schema | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWGF | FLVAR | Allow NULL? |
| 11 | STFAK | Calendar | nvarchar | 2 | 0 | CHAR | (N' ') | No | TFACD | STKAL | Allow NULL? |
| 12 | WANID | Goods receiving hours ID (default value) | nvarchar | 3 | 0 | CHAR | (N' ') | No | TVWA | WANID | Allow NULL? |
| 13 | MOAB1 | Goods receipt times: Monday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMOAB1 | Allow NULL? |
| 14 | MOBI1 | Goods receiving hours: Monday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMOBI1 | Allow NULL? |
| 15 | MOAB2 | Goods receiving hours: Monday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMOAB2 | Allow NULL? |
| 16 | MOBI2 | Goods receiving hours: Monday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMOBI2 | Allow NULL? |
| 17 | DIAB1 | Goods receiving hours: Tuesday morning from... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADIAB1 | Allow NULL? |
| 18 | DIBI1 | Goods receipt times: Tuesday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADIBI1 | Allow NULL? |
| 19 | DIAB2 | Goods receiving hours: Tuesday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADIAB2 | Allow NULL? |
| 20 | DIBI2 | Goods receiving hours: Tuesday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADIBI2 | Allow NULL? |
| 21 | MIAB1 | Goods receiving hours: Wednesday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMIAB1 | Allow NULL? |
| 22 | MIBI1 | Goods receiving hours: Wednesday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMIBI1 | Allow NULL? |
| 23 | MIAB2 | Goods receiving hours: Wednesday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMIAB2 | Allow NULL? |
| 24 | MIBI2 | Goods receiving hours: Wednesday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAMIBI2 | Allow NULL? |
| 25 | DOAB1 | Goods receiving hours: Thursday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADOAB1 | Allow NULL? |
| 26 | DOBI1 | Goods receiving hours: Thursday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADOBI1 | Allow NULL? |
| 27 | DOAB2 | Goods receiving hours: Thursday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADOAB2 | Allow NULL? |
| 28 | DOBI2 | Goods receiving hours: Thursday afternoon until... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WADOBI2 | Allow NULL? |
| 29 | FRAB1 | Goods receiving hours: Friday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAFRAB1 | Allow NULL? |
| 30 | FRBI1 | Goods receiving hours: Friday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAFRBI1 | Allow NULL? |
| 31 | FRAB2 | Goods receiving hours: Friday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAFRAB2 | Allow NULL? |
| 32 | FRBI2 | Goods receiving hours: Friday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WAFRBI2 | Allow NULL? |
| 33 | SAAB1 | Goods receiving hours: Saturday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASAAB1 | Allow NULL? |
| 34 | SABI1 | Goods receiving hours: Saturday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASABI1 | Allow NULL? |
| 35 | SAAB2 | Goods receiving hours: Saturday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASAAB2 | Allow NULL? |
| 36 | SABI2 | Goods receiving hours: Saturday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASABI2 | Allow NULL? |
| 37 | SOAB1 | Goods receiving hours: Sunday morning from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASOAB1 | Allow NULL? |
| 38 | SOBI1 | Goods receiving hours: Sunday morning until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASOBI1 | Allow NULL? |
| 39 | SOAB2 | Goods receiving hours: Sunday afternoon from ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASOAB2 | Allow NULL? |
| 40 | SOBI2 | Goods receiving hours: Sunday afternoon until ... | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | WASOBI2 | Allow NULL? |
| 41 | VERFL | Sales area (floor space) | decimal | 6 | 0 | QUAN | ((0)) | No | | VERFL_WWS | |
| 42 | VERFE | Sales area (floor space) unit | nvarchar | 3 | 0 | UNIT | (N' ') | No | T006 | VERFE_WWS | Allow NULL? |
| 43 | SPGR1 | Blocking reason | nvarchar | 2 | 0 | CHAR | (N' ') | No | TWRF11 | SPGR1 | Allow NULL? |
| 44 | INPRO | POS inbound profile | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWPIS | POSINTPROF | Allow NULL? |
| 45 | EKOAR | POS outbound: condition type group | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWPPK | POSEKOAR | Allow NULL? |
| 46 | KZLIK | Listing Conditions for Assortments | char | 1 | 0 | CHAR | (N' ') | No | | KZLIK | Allow NULL? |
| 47 | BETRP | Plant profile | nvarchar | 4 | 0 | CHAR | (N' ') | No | TWRF2 | BETRP | Allow NULL? |
| 48 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ERDAT | Allow NULL? |
| 49 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | No | | ERNAM | Allow NULL? |
| 50 | NLMATFB | ID: Carry out subsequent listing | char | 1 | 0 | CHAR | (N' ') | Yes | | NLMATFB | Allow NULL? |
| 51 | BWWRK | Plant for retail price determination | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | BWWRK | Allow NULL? |
| 52 | BWVKO | Sales organization for retail price determination | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | BWVKO | Allow NULL? |
| 53 | BWVTW | Distribution channel for retail price determination | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | BWVTW | Allow NULL? |
| 54 | BBPRO | Assortment list profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TWBP | BBPRO | Allow NULL? |
| 55 | VKBUR_WRK | Sales office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKBUR_WRK | Allow NULL? |
| 56 | VLFKZ | Plant category | char | 1 | 0 | CHAR | (N' ') | Yes | | VLFKZ | Allow NULL? |
| 57 | LSTFL | Listing procedure for store or other assortment categories | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWLV | LSTFL | Allow NULL? |
| 58 | LIGRD | Basic listing rule for assortments | char | 1 | 0 | CHAR | (N' ') | Yes | | WLIGRD | Allow NULL? |
| 59 | VKORG | Sales organization for intercompany billing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKOIV | Allow NULL? |
| 60 | VTWEG | Distribution channel for intercompany billing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWIV | Allow NULL? |
| 61 | DESROI | ROI required | decimal | 5 | 2 | DEC | ((0)) | Yes | | DESROI | |
| 62 | TIMINC | Time increment for investement buying algorithm | decimal | 5 | 0 | DEC | ((0)) | Yes | | TIMINC | |
| 63 | POSWS | Currency of POS systems | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | POSWS | Allow NULL? |
| 64 | SSOPT_PRO | Space management profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TWSSO | SSOPT_PRO | Allow NULL? |
| 65 | WBPRO | Profile for value-based inventory management | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TWPR | WBPRO | Allow NULL? |
| 66 | ORGPRICE | Retail: Original Price for Segment Definition E2WRF1M | char | 1 | 0 | CHAR | (N' ') | Yes | | E2WRF_ORGPRICES | Allow NULL? |
| 67 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 68 | RMA_PROF | Retail: RMA Profile for Segment Definition E2WRF1M | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | E2WRMA_PROF | Allow NULL? |
| 69 | RMA_VKORG | Cost allocation sales organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | WCAT_VKORG | Allow NULL? |
| 70 | RMA_VTWEG | Cost allocation distribution channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | WCAT_VTWEG | Allow NULL? |
