| 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 | TDTPV | Trading Contract: Purchasing Group | nvarchar | 4 | 0 | CHAR | (N' ') | No | | TDTPV | Allow NULL? |
| 3 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP_TC | Allow NULL? |
| 4 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T161 | BSART | Allow NULL? |
| 5 | DEFWAERS | Trading Contract: Default Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | DEFWAERS | Allow NULL? |
| 6 | DEFKURST | Trading Contract: Default Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | DEFKURST | Allow NULL? |
| 7 | FTACTIVE | Trading Contract: Foreign Trade Data Active | char | 1 | 0 | CHAR | (N' ') | Yes | | FTACTIVE | Allow NULL? |
| 8 | PUINRE | Trading Contract: Read Purchasing Info Record | char | 1 | 0 | CHAR | (N' ') | Yes | | PUINRE | Allow NULL? |
| 9 | EKERV | Purchase price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TWEV | EKERV_M | Allow NULL? |
| 10 | HKLA | Trading Contract: Delivery Address Origin | char | 1 | 0 | CHAR | (N' ') | Yes | | HKLA | Allow NULL? |
| 11 | KALSMK_MM | Trading Contract: Message Schema for Vendor Messages | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMB_MM | Allow NULL? |
| 12 | KALSMP_MM | Message Schema for Vendor Messages at Item Level | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | KALSMBP_MM | Allow NULL? |
| 13 | PRICING_TYPE_PO | Pricing Type for Purchase Order Item Creation | char | 1 | 0 | CHAR | (N' ') | Yes | | PRICING_TYPE_PO | Allow NULL? |
| 14 | SYNC_STATUS | Transfer Item Complete status to PO Item | char | 1 | 0 | CHAR | (N' ') | Yes | | WB2_SYNC_STATUS | Allow NULL? |
| 15 | LOP_GROUP | Logistical Option Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | LOP_C_GRP | LOP_GROUP | Allow NULL? |
| 16 | PRICING_COPY_TO_PO | Price Copy to Purchasing-Side Follow-On Documents | char | 1 | 0 | CHAR | (N' ') | Yes | | WB2_COPY_TC_PRICING_TO_PO | Allow NULL? |
