| 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 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVKO | VKORG | Allow NULL? |
| 3 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVKOV | VTWEG | Allow NULL? |
| 4 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | No | TVTA | SPART | Allow NULL? |
| 5 | ANWBER | Application Area | nvarchar | 10 | 0 | CHAR | (N' ') | No | /BEV1/TSABER | /BEV1/TSABER___D | Allow NULL? |
| 6 | SORTFVBAK | Sort Field for Selection of Order Documents VBAK | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | /BEV1/TSDD03VT_V | /BEV1/TSSFVBAK | Allow NULL? |
| 7 | SASCVBAK | Sort VBAK Ascending | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSSAVBAK | Allow NULL? |
| 8 | SORTFLIKP | Sort Field for Selection of Delivery Documents LIKP | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | /BEV1/TSDD03VT_V | /BEV1/TSSFLIKP | Allow NULL? |
| 9 | SASCLIKP | Sort LIKP Ascending | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSSALIKP | Allow NULL? |
| 10 | SORTFVBRK | Sort Field for Selection of Billing Documents VBRK | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | /BEV1/TSDD03VT_V | /BEV1/TSSFVBRK | Allow NULL? |
| 11 | SASCVBRK | Sort VBRK Ascending | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSSAVBRK | Allow NULL? |
| 12 | ZTYPZUS | Additionally Determime Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSTYPZUS | Allow NULL? |
| 13 | TYPSPBREIT | Width of Column Category | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | /BEV1/TSYPSPBR | Allow NULL? |
| 14 | ZOTYPER | Retain Lines Without Category Assignment | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSOTYPER | Allow NULL? |
| 15 | VRKMEVW | Use Sales Unit | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSVRKMEVW | Allow NULL? |
| 16 | CHARGEBER | Include Batch | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSHARGEB | Allow NULL? |
| 17 | MAXALTAT | Maximum Tolerable Age in Working Days | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /BEV1/TSMAXALT | Allow NULL? |
| 18 | ERLAKTUAL | Update of Statistics Data Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSERLAKT | Allow NULL? |
| 19 | ALTSERH | Retain Old Records | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSALTSERH | Allow NULL? |
| 20 | ANZGEN | Number of Generations | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | /BEV1/TSANZGEN | Allow NULL? |
| 21 | SMEUEB | Transfer Unit of Measure for Statistics Area | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSSMEUEB | Allow NULL? |
| 22 | MATNRANZ | Display Material Number | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSMATNRAZ | Allow NULL? |
| 23 | MAKTXANZ | Display Material Short Text | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSMAKTXAZ | Allow NULL? |
| 24 | MEANZ | Display Unit of Measure | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSMEANZ | Allow NULL? |
| 25 | ZTYPANZ | Display Assignment Category | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSTYPANZ | Allow NULL? |
| 26 | AUTOMAT | Default Fast Entry with Material Column | char | 1 | 0 | CHAR | (N' ') | Yes | | /BEV1/TSAUTOMAT | Allow NULL? |
| 27 | SPNRD | Column Number for Transfer from Statistics to Fast Entry | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | /BEV1/TSSPNRUEB | Allow NULL? |
