| 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 | 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 | TVKOS | SPART | Allow NULL? |
| 5 | VTWKU | Reference distrib.channel for cust.and material masters | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWKU | Allow NULL? |
| 6 | SPAKU | Reference division for customers | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPAKU | Allow NULL? |
| 7 | VTWKO | Reference distribution channel for conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWKO | Allow NULL? |
| 8 | SPAKO | Reference division for conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPAKO | Allow NULL? |
| 9 | MABER | Dunning Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T047M | MABER | Allow NULL? |
| 10 | VKOAU | Reference sales org.for sales doc.types (by sales area) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKOAU | Allow NULL? |
| 11 | VTWAU | Distribution channel for sales doc types | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWAU | Allow NULL? |
| 12 | SPAAU | Reference division for document types (by sales area) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPAAU | Allow NULL? |
| 13 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 14 | REGGB | Rule for determining the business area | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | REGGB | Allow NULL? |
| 15 | REVFP | Rule for transferring the results of the availability check | char | 1 | 0 | CHAR | (N' ') | Yes | | REVFP | Allow NULL? |
| 16 | FIXMG | Delivery date and quantity fixed | char | 1 | 0 | CHAR | (N' ') | Yes | | FIXMG | Allow NULL? |
| 17 | AFIND | Promo determination | char | 1 | 0 | CHAR | (N' ') | Yes | | AFIND | Allow NULL? |
| 18 | KKBER | Credit control area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T014 | KKBER | Allow NULL? |
| 19 | J_1ASNR | Branch for domestic operations | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BBRANCH | J_1ADBRNCH | Allow NULL? |
| 20 | J_1AESNR | Branch for export operations | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | J_1BBRANCH | J_1AEBRNCH | Allow NULL? |
| 21 | ISP_VB | IS-M: Distribution Zone | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | JVTBEZIRK | VERBBEZ | Allow NULL? |
| 22 | ISM_BP_VTB_GROUP | IS-M: Sales Area Group for Business Partner Selection | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJH_GR_SALESAREA | GROUP_SALESAREA | Allow NULL? |
| 23 | J_3GKBAUL | ETM-Relevant Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | J_3GKBAUL | Allow NULL? |
| 24 | OID_CHECKC | Check customer ship-to/sold-to warning/error/information | char | 1 | 0 | CHAR | (N' ') | Yes | | OID_CHECKC | Allow NULL? |
