| 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 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | No | | BSTYP | Allow NULL? |
| 3 | BSART | Purchasing Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ESART | Allow NULL? |
| 4 | BSAKZ | Control indicator for purchasing document type | char | 1 | 0 | CHAR | (N' ') | No | | BSAKZ | Allow NULL? |
| 5 | PINCR | Item Number Interval | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | PINCR | Allow NULL? |
| 6 | NUMKI | Number range in the case of internal number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKI | Allow NULL? |
| 7 | NUMKE | Number range in the case of external number assignment | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKE | Allow NULL? |
| 8 | BREFN | Field Selection Key | nvarchar | 20 | 0 | CHAR | (N' ') | No | T162 | BREFN | Allow NULL? |
| 9 | REFBA | Reference document type | nvarchar | 4 | 0 | CHAR | (N' ') | No | T161 | RFBSA | Allow NULL? |
| 10 | ABVOR | Prepopulate Standard Release Order Quantity in Contract | char | 1 | 0 | CHAR | (N' ') | No | | ABVOR | Allow NULL? |
| 11 | STAFO | Update group for statistics update | nvarchar | 6 | 0 | CHAR | (N' ') | No | TMCB | STAFO | Allow NULL? |
| 12 | UPINC | Item Number Interval for Subitems | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | UPINC | Allow NULL? |
| 13 | STAKO | Document with time-dependent conditions | char | 1 | 0 | CHAR | (N' ') | No | | STAKO | Allow NULL? |
| 14 | PARGR | Partner Determination Procedure | nvarchar | 4 | 0 | CHAR | (N' ') | No | TVPG | PARGR | Allow NULL? |
| 15 | NUMKA | Number range in case of internal number assignment for ALE | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKA | Allow NULL? |
| 16 | HITYP | Hierarchy category: vendor hierarchy | char | 1 | 0 | CHAR | (N' ') | Yes | TLHIT | HITYP_LH | Allow NULL? |
| 17 | LPHIS | Indicator for scheduling agreement release documentation | char | 1 | 0 | CHAR | (N' ') | Yes | | LPHIS | Allow NULL? |
| 18 | GSFRG | Overall release of purchase requisitions | char | 1 | 0 | CHAR | (N' ') | Yes | | GSFRG | Allow NULL? |
| 19 | VARIANTE | Layout | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TC_VAR | Allow NULL? |
| 20 | SHENQ | Only shared lock in case of contract release order | char | 1 | 0 | CHAR | (N' ') | Yes | | SHENQ | Allow NULL? |
| 21 | KZALE | Distributed contract (ALE) | char | 1 | 0 | CHAR | (N' ') | Yes | | KZALE | Allow NULL? |
| 22 | ABGEBOT | Competitive bidding procedure using global percentage bids | char | 1 | 0 | CHAR | (N' ') | Yes | | ABGEBOT | Allow NULL? |
| 23 | KORNR | Correction of miscellaneous provisions | char | 1 | 0 | CHAR | (N' ') | Yes | | KORNR | Allow NULL? |
| 24 | UMLIF | Stock transfer: Take vendor data into account | char | 1 | 0 | CHAR | (N' ') | Yes | | UMLIF | Allow NULL? |
| 25 | KOETT | Contract with delivery schedule | char | 1 | 0 | CHAR | (N' ') | Yes | | KOETT | Allow NULL? |
| 26 | AR_OBJECT | Document type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TOADV | SAEOBJART | Allow NULL? |
| 27 | KOAKO | Contract allowed as release order against contract | char | 1 | 0 | CHAR | (N' ') | Yes | | KOAKO | Allow NULL? |
| 28 | OICSEGI | Quantity schedule creation permitted | char | 1 | 0 | CHAR | (N' ') | Yes | | OIA_CSEGI | Allow NULL? |
| 29 | OIRFQREQ | Precedence for RFQ or default requisition for TDP PO | char | 1 | 0 | CHAR | (N' ') | Yes | | OIH_RFQREQ | Allow NULL? |
| 30 | WVVKZ | Indicator for Further Processing of Summarized Documents | char | 1 | 0 | CHAR | (N' ') | Yes | | WVVKZ | Allow NULL? |
| 31 | XLOKZ | Cross-System Transit | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOKZ | Allow NULL? |
| 32 | CP_AKTIVE | Commitment Plan is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | CP_ACTIVE | Allow NULL? |
| 33 | CPTYPE | Category of Commitment Plan | char | 1 | 0 | CHAR | (N' ') | Yes | | CP_TYPE | Allow NULL? |
| 34 | FLS_RSTO | Store Return with Inbound and Outbound Delivery | char | 1 | 0 | CHAR | (N' ') | Yes | | FLS_RSTO | Allow NULL? |
| 35 | MSR_ACTIVE | Advanced Returns Management Active | char | 1 | 0 | CHAR | (N' ') | Yes | | MSR_ACTIVE | Allow NULL? |
| 36 | RDP_PROFILE | Risk Distribution Plan Profile | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | L2TC_RDP_PROFILE | LOGTRM_RDP_PROFILE | Allow NULL? |
| 37 | NUMKC | Number Range for SRM Central Contract | nvarchar | 2 | 0 | CHAR | (N' ') | No | | NUMKC | Allow NULL? |
| 38 | /SAPMP/CEACT | Fast Data Entry of Characteristics Is Active | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/CEACT | Allow NULL? |
| 39 | /SAPMP/PDACT | Activate Inheritance | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/PDACT | Allow NULL? |
| 40 | /SAPMP/PPROT | Log of Characteristic Value Inheritance | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/PPROT | Allow NULL? |
| 41 | /SAPMP/PUSER | Inheritance: Overwrite User Values | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/PUSER | Allow NULL? |
| 42 | /SAPMP/PAUSW | Inheritance of Characteristics Selection List | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/PAUSW | Allow NULL? |
| 43 | /SAPMP/ATNAM | Characteristic name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | MILL_SE_ATNAM1 | Allow NULL? |
| 44 | /SAPMP/GAUF | Global/Local Group May Be Undone | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPMP/GAUF | Allow NULL? |
| 45 | TOLSL | Tolerance Key for Overdraw Tolerance | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TME_TOLS | METOLSL | Allow NULL? |
| 46 | MILL_OMKZ | Mill: Use reference characteristics in Purchasing | char | 1 | 0 | CHAR | (N' ') | Yes | | MILL_MM_OMKZ | Allow NULL? |
| 47 | WRF_ENABLE_DATELINE | Enable Dateline | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_ENABLE_DATELINE | Allow NULL? |
