| 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 | USMDKBPBP_HEADER | Technical Key | int | 10 | 0 | INT4 | ((0)) | No | /1MD/MD______0B4 | USMD_TECH_KEY | Allow NULL? |
| 3 | /1MD/BPPRCH_ORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | EKORG | Allow NULL? |
| 4 | /1MD/BPASSGNM_ID | Multiple Assignment ID (Number) | nvarchar | 12 | 0 | NUMC | (N'000000000000') | No | | MDG_BP_ASSIGNMENT_ID | Allow NULL? |
| 5 | USMD_ACTIVE | Active/Inactive Data Record | char | 1 | 0 | CHAR | (N' ') | No | | USMD_ACTIVE | Allow NULL? |
| 6 | /1MD/BPREF_BPRG | Customs Office: Office of Exit/Entry for Foreign Trade | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | DZOLLS | Allow NULL? |
| 7 | /1MD/BPREF_BPPOR | Mode of Transport for Foreign Trade | char | 1 | 0 | CHAR | (N' ') | Yes | * | EXPVZ | Allow NULL? |
| 8 | /1MD/BPREF_BPORG | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 9 | /1MD/BPRF_BPPORG | Planning cycle | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LFRHY | Allow NULL? |
| 10 | /1MD/BPRF_BPORG | Unit of Measure Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | MEGRU | Allow NULL? |
| 11 | /1MD/BPRF_BPPRG | Alternative Unit of Measure for Stockkeeping Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | LRMEI | Allow NULL? |
| 12 | /1MD/BPREF_BPPRG | Planning calendar | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | MRPPP_W | Allow NULL? |
| 13 | /1MD/BPREF_BPOR1 | Rounding Profile | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RDPRF | Allow NULL? |
| 14 | /1MD/BPREF_BPOR2 | Level in the rounding profile | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | RDZAE | Allow NULL? |
| 15 | /1MD/BPREF_BPPOG | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 16 | USMD_O_BP_PORG | Obsolete Data Record | char | 1 | 0 | CHAR | (N' ') | Yes | | USMD_OBSOLETE | Allow NULL? |
| 17 | /1MD/BPAGREL | Indicator: Relevant for agency business | char | 1 | 0 | CHAR | (N' ') | Yes | | AGREL | Allow NULL? |
| 18 | /1MD/BPBLIND | Indicator: Doc. index compilation active for purchase orders | char | 1 | 0 | CHAR | (N' ') | Yes | | BLIND | Allow NULL? |
| 19 | /1MD/BPBOIND | Indicator: index compilation for subseq. settlement active | char | 1 | 0 | CHAR | (N' ') | Yes | | BOIND | Allow NULL? |
| 20 | /1MD/BPBOLRE | Indicator: vendor subject to subseq. settlement accounting | char | 1 | 0 | CHAR | (N' ') | Yes | | BOLRE | Allow NULL? |
| 21 | /1MD/BPBOPNR | Restriction Profile for PO-Based Load Building | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | BOPNR | Allow NULL? |
| 22 | /1MD/BPBSTAE | Confirmation Control Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BSTAE | Allow NULL? |
| 23 | /1MD/BPEIKTO_M | Our account number with the vendor | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EIKTO_M | Allow NULL? |
| 24 | /1MD/BPEKGRP | Purchasing Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | EKGRP | Allow NULL? |
| 25 | /1MD/BPINCO1 | Incoterms (Part 1) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | INCO1 | Allow NULL? |
| 26 | /1MD/BPINCO2 | Incoterms (Part 2) | nvarchar | 28 | 0 | CHAR | (N' ') | Yes | | INCO2 | Allow NULL? |
| 27 | /1MD/BPKALSK | Group for Calculation Schema (Vendor) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KALSK | Allow NULL? |
| 28 | /1MD/BPKZABS | Order Acknowledgment Requirement | char | 1 | 0 | CHAR | (N' ') | Yes | | KZABS | Allow NULL? |
| 29 | /1MD/BPKZAUT | Automatic Generation of Purchase Order Allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | KZAUT | Allow NULL? |
| 30 | /1MD/BPLEBRE | Indicator for Service-Based Invoice Verification | char | 1 | 0 | CHAR | (N' ') | Yes | | LEBRE | Allow NULL? |
| 31 | /1MD/BPLFABC | ABC indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | LFABC | Allow NULL? |
| 32 | /1MD/BPLIBES | Order entry by vendor | char | 1 | 0 | CHAR | (N' ') | Yes | | LIBES | Allow NULL? |
| 33 | /1MD/BPLIPRE | Price marking, vendor | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | LIPRE | Allow NULL? |
| 34 | /1MD/BPLISER | Rack-jobbing: vendor | char | 1 | 0 | CHAR | (N' ') | Yes | | LISER | Allow NULL? |
| 35 | /1MD/BPLOEVM_M | Delete flag for vendor at purchasing level | char | 1 | 0 | CHAR | (N' ') | Yes | | LOEVM_M | Allow NULL? |
| 36 | /1MD/BPMEPRF | Price Determination (Pricing) Date Control | char | 1 | 0 | CHAR | (N' ') | Yes | | MEPRF | Allow NULL? |
| 37 | /1MD/BPMINBW | Minimum order value | decimal | 13 | 2 | CURR | ((0)) | Yes | | MINBW | |
| 38 | /1MD/BPNRGEW | Indicator whether discount in kind granted | char | 1 | 0 | CHAR | (N' ') | Yes | | NRGEW_MDG | Allow NULL? |
| 39 | /1MD/BPPAPRF | Profile for transferring material data via IDoc PROACT | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WVMI_PAPRF | Allow NULL? |
| 40 | /1MD/BPPLIFZ | Planned Delivery Time in Days | decimal | 3 | 0 | DEC | ((0)) | Yes | | PLIFZ | |
| 41 | /1MD/BPPRFRE | Indicator: "relev. to price determination (vend. hierarchy) | char | 1 | 0 | CHAR | (N' ') | Yes | | PRFRE_LH | Allow NULL? |
| 42 | /1MD/BPSKRIT | Vendor sort criterion for materials | char | 1 | 0 | CHAR | (N' ') | Yes | | SKRIT | Allow NULL? |
| 43 | /1MD/BPSPERM_P | Purchasing block at purchasing organization level | char | 1 | 0 | CHAR | (N' ') | Yes | | SPERM_M | Allow NULL? |
| 44 | /1MD/BPUMSAE | Comparison/agreement of business volumes necessary | char | 1 | 0 | CHAR | (N' ') | Yes | | UMSAE | Allow NULL? |
| 45 | /1MD/BPVENSL | Vendor service level | decimal | 4 | 1 | DEC | ((0)) | Yes | | VENSL | |
| 46 | /1MD/BPVERKF | Responsible Salesperson at Vendor's Office | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | EVERK | Allow NULL? |
| 47 | /1MD/BPVSBED | Shipping Conditions | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VSBED | Allow NULL? |
| 48 | /1MD/BPWAERS | Purchase order currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | BSTWA | Allow NULL? |
| 49 | /1MD/BPWEBRE | Indicator: GR-Based Invoice Verification | char | 1 | 0 | CHAR | (N' ') | Yes | | WEBRE | Allow NULL? |
| 50 | /1MD/BPXERSR | Automatic evaluated receipt settlement for return items | char | 1 | 0 | CHAR | (N' ') | Yes | | XERSR | Allow NULL? |
| 51 | /1MD/BPXERSY | Evaluated Receipt Settlement (ERS) | char | 1 | 0 | CHAR | (N' ') | Yes | | XERSY | Allow NULL? |
| 52 | /1MD/BPXNBWY | Revaluation allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | XNBWY | Allow NULL? |
| 53 | /1MD/BPZTERM_M | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
