| 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 | TKONN | Trading Contract: Trading Contract Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | WBHK | TKONN | Allow NULL? |
| 3 | TPOSN | Trading Contract: Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | TPOSN | Allow NULL? |
| 4 | TPOSN_SUB | Trading Contract: Sub-Item Number | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | TPOSN_SUB | Allow NULL? |
| 5 | ELIFN | Vendor Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | ELIFN | Allow NULL? |
| 6 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 7 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T024 | EKGRP | Allow NULL? |
| 8 | IHREZ | Your Reference | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | IHREZ | Allow NULL? |
| 9 | EBDAT | Purchasing Document Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EBDAT | Allow NULL? |
| 10 | EINDT | Trading Contract: Delivery Date for Item Purchasing | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WB2_DELDATE_MM | Allow NULL? |
| 11 | LPEIN_INT | Date type (day, week, month, interval) | char | 1 | 0 | CHAR | (N' ') | Yes | | LPEIN_INT | Allow NULL? |
| 12 | WAERS_PURCH | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 13 | TKRATE_MM | GT Exchange Rate Order Currency / Local Currency | decimal | 9 | 5 | DEC | ((0)) | Yes | | TKRATE_MM | |
| 14 | KURST_MM | Exchange Rate Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | KURST | Allow NULL? |
| 15 | ZTERM | Terms of Payment Key Purchasing | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WB2_DZTERM_MM | Allow NULL? |
| 16 | VALDT | Fixed value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALDT | Allow NULL? |
| 17 | TERMDES_MM | Trading Contract: Description of Terms of Payment | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TERMDES | Allow NULL? |
| 18 | PRSDT_MM | Date for Pricing and Exchange Rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WB2_PRSDT_MM | Allow NULL? |
| 19 | PRSDT_SD | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT | Allow NULL? |
| 20 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 21 | ERDAT | Date on Which Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT | Allow NULL? |
| 22 | ERZET | Entry time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ERZET | Allow NULL? |
| 23 | WERK_MM | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 24 | INCO1_MM | Incoterms Part 1 Purchasing | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TINC | WB2_INCO1_MM | Allow NULL? |
| 25 | INCO2_MM | Incoterms Part 2 Purchasing | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | WB2_INCO2_MM | Allow NULL? |
| 26 | IHRAN | Quotation Submission Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | IHRAN | Allow NULL? |
| 27 | EDATU_VBAK | Trading Contract: Delivery Date for Item Sales | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WB2_DELDATE_SD | Allow NULL? |
| 28 | PRGRS_VBAK | Proposed date type | char | 1 | 0 | CHAR | (N' ') | Yes | | PRGRS_VBAK | Allow NULL? |
| 29 | INCO1_SD | Incoterms Part 1 Sales | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TINC | WB2_INCO1_SD | Allow NULL? |
| 30 | INCO2_SD | Incoterms Part 2 Sales | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | WB2_INCO2_SD | Allow NULL? |
| 31 | ZTERM_SALES | Terms Of Payment Key Sales | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | WB2_DZTERM_SD | Allow NULL? |
| 32 | TERMDES_SD | Trading Contract: Description of Terms of Payment | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | TERMDES | Allow NULL? |
| 33 | VALDTD | Fixed value date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VALDT | Allow NULL? |
| 34 | ZLSCH | Payment Method | char | 1 | 0 | CHAR | (N' ') | Yes | T042Z | SCHZW_BSEG | Allow NULL? |
| 35 | KDATB_MM | Start of Validity Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KDATB | Allow NULL? |
| 36 | KDATE_MM | End of Validity Period | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | KDATE | Allow NULL? |
| 37 | AUSNR_MM | Bid invitation number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | EKKO | AUSCH | Allow NULL? |
| 38 | ANGNR_MM | Quotation Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ANGNR | Allow NULL? |
| 39 | VERKF_MM | Responsible Salesperson at Vendor's Office | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EVERK | Allow NULL? |
| 40 | TELF1_MM | Vendor's Telephone Number | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELF0 | Allow NULL? |
| 41 | LLIEF_MM | Supplying Vendor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LLIEF | Allow NULL? |
| 42 | UNSEZ_MM | Our Reference | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNSEZ | Allow NULL? |
| 43 | EVERS_MM | Shipping Instructions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T027A | EVERS | Allow NULL? |
| 44 | BSTAE_MM | Confirmation Control Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T163L | BSTAE | Allow NULL? |
| 45 | KZABS_MM | Order Acknowledgment Requirement | char | 1 | 0 | CHAR | (N' ') | Yes | | KZABS | Allow NULL? |
| 46 | LABNR | Order Acknowledgment Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | LABNR | Allow NULL? |
| 47 | KZAZU | Order Combination Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | KZAZU_D | Allow NULL? |
| 48 | HKLA | Trading Contract: Delivery Address Origin | char | 1 | 0 | CHAR | (N' ') | Yes | | HKLA | Allow NULL? |
| 49 | LCNUM | Financial doc. processing: Internal financial doc. number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | AKKP | LCNUM | Allow NULL? |
| 50 | ABSSC | Payment guarantee procedure | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T691M | ABSSCHE_CM | Allow NULL? |
| 51 | AKPRZ | Depreciation percentage for financial document processing | decimal | 5 | 2 | DEC | ((0)) | Yes | | AKPRZ | |
| 52 | POSPLIT | Trading Contract: Manual Purchase Order Split | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | POSPLIT | Allow NULL? |
| 53 | KUFIX | Indicator: Fixing of Exchange Rate | char | 1 | 0 | CHAR | (N' ') | Yes | | KUFIX | Allow NULL? |
| 54 | BSTYP | Purchasing Document Category | char | 1 | 0 | CHAR | (N' ') | Yes | | BSTYP_TC | Allow NULL? |
| 55 | BSART | Order Type (Purchasing) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSART | Allow NULL? |
| 56 | VSART | Shipping type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T173 | VSARTTR | Allow NULL? |
| 57 | BSTKD_E | Ship-to Party's Purchase Order Number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD_E | Allow NULL? |
| 58 | POSEX_E | Item Number of the Underlying Purchase Order | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | POSEX_E | Allow NULL? |
| 59 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 60 | BSTDK | Customer purchase order date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDK | Allow NULL? |
| 61 | BSTDK_E | Ship-to party's PO date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDK_E | Allow NULL? |
| 62 | KALSM_MM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
| 63 | KNUMV_MM | Number of the document condition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMV | Allow NULL? |
| 64 | KURSK_SD | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSK | |
| 65 | RESWK | Supplying (Issuing) Plant in Stock Transport Order | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | RESWK | Allow NULL? |
| 66 | RETPC | Retention in Percent | decimal | 5 | 2 | DEC | ((0)) | Yes | | RETPZ | |
| 67 | DPTYP | Down Payment Indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ME_DPTYP | Allow NULL? |
| 68 | DPPCT | Down Payment Percentage | decimal | 5 | 2 | DEC | ((0)) | Yes | | ME_DPPCNT | |
| 69 | DPAMT | Down Payment Amount in Document Currency | decimal | 11 | 2 | CURR | ((0)) | Yes | | ME_DPAMNT | |
| 70 | DPDAT | Due Date for Down Payment | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ME_DPDDAT | Allow NULL? |
| 71 | PODKZ | Relevant for POD processing | char | 1 | 0 | CHAR | (N' ') | Yes | | PODKZ | Allow NULL? |
| 72 | J_1AINDXP | Inflation Index | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | J_1AINFT20 | J_1AINDXP | Allow NULL? |
| 73 | J_1AIDATEP | Indexing base date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | J_1AIDATES | Allow NULL? |
| 74 | J_1AFITP_SD | Tax type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AFITP | J_1AFITP_D | Allow NULL? |
| 75 | J_1ARFZ_SD | Reason for zero VAT | char | 1 | 0 | CHAR | (N' ') | Yes | J_1ARFZ | J_1ARFZVAT | Allow NULL? |
| 76 | J_1AREGIO_SD | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T005S | REGIO | Allow NULL? |
| 77 | J_1AGICD_SD | Activity Code for Gross Income Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1AGICD | J_1AGICD_D | Allow NULL? |
| 78 | J_1ADTYP_SD | Distribution Type for Employment Tax | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | J_1ADTYP | J_1ADTYP_D | Allow NULL? |
| 79 | J_1ATXREL_SD | Tax relevant classification | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | J_1ATXREL | J_1ATXREL_ | Allow NULL? |
| 80 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | SEPA_MNDID | Allow NULL? |
| 81 | SEPA_REL_SD | Sales: SEPA Relevance | char | 1 | 0 | CHAR | (N' ') | Yes | | WB2_SEPA_RELEVANCE | Allow NULL? |
