| 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 | AUART | IS-M/SD: Sales Document Types | nvarchar | 4 | 0 | CHAR | (N' ') | No | | AUART_ISP | Allow NULL? |
| 3 | AUARTGRP | IS-M/SD: Sales document type grouping | char | 1 | 0 | CHAR | (N' ') | Yes | | JAUARTGRP | Allow NULL? |
| 4 | KOPGR | Screen Sequence Group for Document Header & Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJHB | BIFGR_ISP | Allow NULL? |
| 5 | FKART | IS-M: Billing/Settlement Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJFK | JFKART | Allow NULL? |
| 6 | NUMKI | Number range for internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKI_ISP | Allow NULL? |
| 7 | NUMKE | Number range for external number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | NUMKE_ISP | Allow NULL? |
| 8 | INCPO | Increment of Purchase Order Item Number in Sales Document | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | INCPO_ISP | Allow NULL? |
| 9 | UEVOR | Default FCODE for first data screen | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | UEVOR_ISP | Allow NULL? |
| 10 | FAKSK | Block | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVFS | FAKSP | Allow NULL? |
| 11 | TRVOG | Transaction Group for IS-M Order Processing | char | 1 | 0 | CHAR | (N' ') | Yes | | TRVOG_ISP | Allow NULL? |
| 12 | SPAPO | Division in sales order item comes from the material | char | 1 | 0 | CHAR | (N' ') | Yes | | SPAPO | Allow NULL? |
| 13 | SPAPR | Check division | char | 1 | 0 | CHAR | (N' ') | Yes | | SPAPR | Allow NULL? |
| 14 | TXN08 | Number of the standard text | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | TXN08 | Allow NULL? |
| 15 | FELDK | Field Selection Group for Header & Item | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJHF | FAWGR_ISP | Allow NULL? |
| 16 | VBTYP | Sales document category, IS-M | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP_ISP | Allow NULL? |
| 17 | TXTGR | Text determination procedure | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TTXG | TXTGR | Allow NULL? |
| 18 | KALVG | Document procedure (for determining pricing procedure) | char | 1 | 0 | CHAR | (N' ') | Yes | TVKV | KALVG | Allow NULL? |
| 19 | KLIMP | Check credit limit | char | 1 | 0 | CHAR | (N' ') | Yes | | KLIMP | Allow NULL? |
| 20 | KALSM | Output determination procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMB | Allow NULL? |
| 21 | KSCHL | Condition Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T685 | KSCHL | Allow NULL? |
| 22 | SPERR | Sales document block | char | 1 | 0 | CHAR | (N' ') | Yes | | SPEVB | Allow NULL? |
| 23 | XPVKANG | Check sales offer | char | 1 | 0 | CHAR | (N' ') | Yes | | XPVKANG | Allow NULL? |
| 24 | XUPDPRVA | Update ad pre-print issues | char | 1 | 0 | CHAR | (N' ') | Yes | | XUPDPRVA | Allow NULL? |
| 25 | XAUARTKORR | Correction sales document type | char | 1 | 0 | CHAR | (N' ') | Yes | | XAUARTKORR | Allow NULL? |
| 26 | ERLDRERZ | Allowed Publications | char | 1 | 0 | CHAR | (N' ') | Yes | | ERLDRERZ | Allow NULL? |
| 27 | EXEMPLART | IS-M: Copy Type | char | 1 | 0 | CHAR | (N' ') | Yes | | EXEMPLART | Allow NULL? |
| 28 | XGPRSE | Partner function social facility allowed as ordering party | char | 1 | 0 | CHAR | (N' ') | Yes | | XGPRSE | Allow NULL? |
| 29 | XGPRVK | Partner function SD customer allowed as ordering party | char | 1 | 0 | CHAR | (N' ') | Yes | | XGPRVK | Allow NULL? |
| 30 | XINTERN | IS-M: Internal Business Partner Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | XINTERN | Allow NULL? |
| 31 | XGPREV | Partner function retailer allowed as ordering party | char | 1 | 0 | CHAR | (N' ') | Yes | | XGPREV | Allow NULL? |
| 32 | XGPRVERLAG | Partner func.SD cust./ext.publ.allowed as ordering party | char | 1 | 0 | CHAR | (N' ') | Yes | | XGPRVERLAG | Allow NULL? |
| 33 | XGPRALLG | Partner role general BP allowed as ordering party | char | 1 | 0 | CHAR | (N' ') | Yes | | XGPRALLG | Allow NULL? |
| 34 | ETVAR | Schedule Line Maintenance Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | ETVAR | Allow NULL? |
| 35 | PRSFD | IS-M: Order is subject to charge | char | 1 | 0 | CHAR | (N' ') | Yes | | XKSTPFLAUF | Allow NULL? |
| 36 | STGVB | IS-M: Statistics group for sales documents | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TJKMC1 | JSTGVB | Allow NULL? |
| 37 | XKOPFEINST | IS-M: Access Order from Basic Header Data | char | 1 | 0 | CHAR | (N' ') | Yes | | XKOPFEINST | Allow NULL? |
| 38 | XPUEBEINST | IS-M: Access order via item overview | char | 1 | 0 | CHAR | (N' ') | Yes | | XPUEBEINST | Allow NULL? |
| 39 | XFKBASAUFT | IS-M: Billing based on order | char | 1 | 0 | CHAR | (N' ') | Yes | | XFKBASAUFT | Allow NULL? |
| 40 | XFKBASLIEF | IS-M: Billing based on delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | XFKBASLIEF | Allow NULL? |
| 41 | AUART_REKL | Sales Document Type for Complaint | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJAK | AUART_REKL | Allow NULL? |
| 42 | AUART_NF | IS-M: Subsequent Sales Document Type for Offers | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TJAK | AUART_NF | Allow NULL? |
| 43 | AENAM | Name of Person Who Changed Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENAM | Allow NULL? |
| 44 | AEDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AEDAT | Allow NULL? |
| 45 | XWBZABO | IS-M: WBZ subscription | char | 1 | 0 | CHAR | (N' ') | Yes | | XWBZABO | Allow NULL? |
| 46 | XRENEWAL | IS-M/SD: Order extended by renewal offer | char | 1 | 0 | CHAR | (N' ') | No | | XRENEWAL | Allow NULL? |
| 47 | AMORTN | IS-M/SD: Use of Liability Account in Order | char | 1 | 0 | CHAR | (N' ') | No | | AMORTN | Allow NULL? |
| 48 | AUART_OF | IS-M/SD: Sales Document Type for Renewal Offer | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJAK | AUART_OF | Allow NULL? |
| 49 | XCCARD | IS-M: Payment cards allowed in order | char | 1 | 0 | CHAR | (N' ') | No | | XJCCARD | Allow NULL? |
| 50 | FKART_TRANSFER | IS-M/SD: Billing Type for Liability Account Transfer | nvarchar | 4 | 0 | CHAR | (N' ') | No | TJFK | FKART_TRANSFER | Allow NULL? |
| 51 | TRANSFERHR | IS-M/SD: Transfer Billing Documents to Human Resources | char | 1 | 0 | CHAR | (N' ') | Yes | | TRANSFERHR | Allow NULL? |
| 52 | XRETRO_BILL | IS-M/SD: Retroactive Billing Possible in Renewals | char | 1 | 0 | CHAR | (N' ') | Yes | | XRETRO_BILL | Allow NULL? |
