| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | MARKFELD | Individual, User-Defined Character | char | 1 | 0 | | | | Allow NULL? |
| 3 | BESTELLT | Individual, User-Defined Character | char | 1 | 0 | | | | Allow NULL? |
| 4 | SATKZ | Individual, User-Defined Character | char | 1 | 0 | | | | Allow NULL? |
| 5 | MATNR | Material Number | nvarchar | 18 | 0 | | | | Allow NULL? |
| 6 | MATKL | Material Group | nvarchar | 9 | 0 | | | | Allow NULL? |
| 7 | MAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 8 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | LNAME1 | Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 10 | UMSMNG | Sales quantity in base unit of measure | decimal | 15 | 3 | | | | |
| 11 | LABST | Valuated Unrestricted-Use Stock | decimal | 13 | 3 | | | | |
| 12 | UAVMNG | Stock transport order 2 (supplying site view), quantity | decimal | 15 | 3 | | | | |
| 13 | BVLMNG | Order volume quantity Retail | decimal | 15 | 3 | | | | |
| 14 | DIFMNG | Order volume quantity Retail | decimal | 15 | 3 | | | | |
| 15 | BASME | Base Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 16 | MENGE | Purchase Order Quantity | decimal | 13 | 3 | | | | |
| 17 | MEINS | Purchase Order Unit of Measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 18 | PEINH | Price Unit | decimal | 5 | 0 | | | | |
| 19 | MWSKZ | Tax on sales/purchases code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | EKGRP | Purchasing Group | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | SATNR | Cross-Plant Configurable Material | nvarchar | 18 | 0 | | | | Allow NULL? |
| 22 | WERKS | Plant for individual capacity | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | FACTR | Conversion factor for order Un to sales Un for astmt. list | nvarchar | 6 | 0 | | | | Allow NULL? |
| 24 | LOCNR | Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 25 | BBTYP | Assortment List Type | char | 1 | 0 | | | | Allow NULL? |
| 26 | VRKME | Sales unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 27 | WAERS | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 28 | KWAER | Controlling area currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 29 | VWAER | Sales currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 30 | HWAER | Sales currency | nvarchar | 5 | 0 | | | | Allow NULL? |
| 31 | VRKPE | Sales price unit | decimal | 5 | 0 | | | | |
| 32 | EKPNN | Sales Pricing: Purchase Price (Net/Net) | decimal | 11 | 2 | | | | |
| 33 | EKPGR | Purchase Price Calculation: (Basic Purchase Price) | decimal | 11 | 2 | | | | |
| 34 | SPABA | Current margin (gross) | decimal | 11 | 2 | | | | |
| 35 | SPANE | Margin (net) in sales price calculation | decimal | 11 | 2 | | | | |
| 36 | ENDPA | Current Final Price | decimal | 11 | 2 | | | | |
| 37 | VKPNE | Sales price (net) | decimal | 11 | 2 | | | | |
| 38 | WBTYP | Default doc. category, store order inbound - replenishment | char | 1 | 0 | | | | Allow NULL? |
| 39 | EKKAM | Key date for purchase price conditions | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | VKKAM | Key date for sales price conditions | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | BESAB | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | BESBI | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | PROAB | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | PROBI | Period to analyze - current date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | SSTUF | Assortment grade | nvarchar | 2 | 0 | | | | Allow NULL? |
| 46 | AKTNR | Promotion | nvarchar | 10 | 0 | | | | Allow NULL? |
| 47 | RELIF | Regular Vendor | char | 1 | 0 | | | | Allow NULL? |
| 48 | SAKTX | Material Description (Short Text) | nvarchar | 40 | 0 | | | | Allow NULL? |
| 49 | KOEIN | Rate unit (currency, sales unit, or %) | nvarchar | 5 | 0 | | | | Allow NULL? |
