| 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 | * | MANDT | Allow NULL? |
| 2 | SSOUR | Statistic(s) origin | nvarchar | 4 | 0 | CHAR | (N' ') | No | | SSOUR | Allow NULL? |
| 3 | VRSIO | Version number in the information structure | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | VRSIO | Allow NULL? |
| 4 | SPMON | Period to analyze - month | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPMON | Allow NULL? |
| 5 | SPTAG | Period to analyze - current date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SPTAG | Allow NULL? |
| 6 | SPWOC | Period to analyze - week | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPWOC | Allow NULL? |
| 7 | SPBUP | Period to analyze - posting period | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SPBUP | Allow NULL? |
| 8 | VBELN | Sales and Distribution Document Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | VBELN | Allow NULL? |
| 9 | POSNR | Item number of the SD document | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | POSNR | Allow NULL? |
| 10 | ETENR | Delivery Schedule Line Number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | VBEP | ETENR | Allow NULL? |
| 11 | FPLNR | Billing plan number / invoicing plan number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | FPLNR | Allow NULL? |
| 12 | FPLTR | Item for billing plan/invoice plan/payment cards | nvarchar | 6 | 0 | NUMC | (N'000000') | No | * | FPLTR | Allow NULL? |
| 13 | KSCHL | Condition type | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | KSCHA | Allow NULL? |
| 14 | STUNR | Step number | nvarchar | 3 | 0 | NUMC | (N'000') | No | * | STUNR | Allow NULL? |
| 15 | ZAEHK | Condition counter | nvarchar | 2 | 0 | NUMC | (N'00') | No | | DZAEHK | Allow NULL? |
| 16 | ALTNEU | Statistics update indicator (post in/post out) | char | 1 | 0 | CHAR | (N' ') | No | | SUPKZ | Allow NULL? |
| 17 | FKART | Billing Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | FKART | Allow NULL? |
| 18 | FKTYP | Billing category | char | 1 | 0 | CHAR | (N' ') | Yes | | FKTYP | Allow NULL? |
| 19 | VBTYP | SD document category | char | 1 | 0 | CHAR | (N' ') | Yes | | VBTYP | Allow NULL? |
| 20 | PERIV | Fiscal Year Variant | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PERIV | Allow NULL? |
| 21 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 22 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | GSBER | Allow NULL? |
| 23 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKORG | Allow NULL? |
| 24 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | VTWEG | Allow NULL? |
| 25 | KUNAG | Sold-to party | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KUNAG | Allow NULL? |
| 26 | ANGDT | Quotation/Inquiry is valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ANGDT_V | Allow NULL? |
| 27 | BNDDT | Date until which bid/quotation is binding (valid-to date) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BNDDT | Allow NULL? |
| 28 | ZTERM | Terms of Payment Key | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DZTERM | Allow NULL? |
| 29 | ZFBDT | Baseline Date for Due Date Calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZFBDT | Allow NULL? |
| 30 | SKFBT | Amount Eligible for Cash Discount in Document Currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | SKFBT | |
| 31 | ABSTA | Release status (current release, old release) | char | 1 | 0 | CHAR | (N' ') | Yes | | ABSTA | Allow NULL? |
| 32 | ERLMENGE_L | Completed quantity (delivery) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERLMENGE_L | |
| 33 | ERLMENGE_F | Invoiced quantity in basic unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERLMENGE_F | |
| 34 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | MATNR | Allow NULL? |
| 35 | FKREL | Relevant for Billing | char | 1 | 0 | CHAR | (N' ') | Yes | | FKREL | Allow NULL? |
| 36 | PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | PRPS | PS_PSP_PNR | Allow NULL? |
| 37 | AUFNR | Order Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AUFK | AUFNR | Allow NULL? |
| 38 | MATWA | Material entered | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATWA | Allow NULL? |
| 39 | PMATN | Pricing Reference Material | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | PMATN | Allow NULL? |
| 40 | KBVER | Allowed deviation in quantity (in percent) | decimal | 3 | 0 | DEC | ((0)) | Yes | | KBVER | |
| 41 | KEVER | Days by which the quantity can be shifted | decimal | 3 | 0 | DEC | ((0)) | Yes | | KEVER | |
| 42 | STDAT | Key date of the bill of material | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STDAT | Allow NULL? |
| 43 | STLNR | Bill of material | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | STNUM | Allow NULL? |
| 44 | STPOS | Bill of material item number | decimal | 4 | 0 | DEC | ((0)) | Yes | | STPOS_D | |
| 45 | AWAHR | Order probability of the item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AWAHR | Allow NULL? |
| 46 | PRSDT | Date for pricing and exchange rate | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PRSDT | Allow NULL? |
| 47 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | SPART | Allow NULL? |
| 48 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 49 | FKDAT | Billing date for billing index and printout | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FKDAT | Allow NULL? |
| 50 | KDGRP | Customer group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KDGRP | Allow NULL? |
| 51 | BZIRK | Sales district | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | BZIRK | Allow NULL? |
| 52 | LAND1 | Country of Destination | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LLAND | Allow NULL? |
| 53 | REGIO | Region (State, Province, County) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | REGIO | Allow NULL? |
| 54 | COUNC | County Code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | COUNC | Allow NULL? |
| 55 | CITYC | City Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CITYC | Allow NULL? |
| 56 | BONUS | Volume rebate group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | BONUS | Allow NULL? |
| 57 | PROVG | Commission group | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PROVG | Allow NULL? |
| 58 | VKGRP | Sales Group | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | VKGRP | Allow NULL? |
| 59 | VKBUR | Sales Office | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VKBUR | Allow NULL? |
| 60 | FBUDA | Date on which services rendered | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | FBUDA | Allow NULL? |
| 61 | BUDAT | Posting Date in the Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BUDAT | Allow NULL? |
| 62 | WADAT | Goods Issue Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WADAT | Allow NULL? |
| 63 | BLDAT | Document Date in Document | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLDAT | Allow NULL? |
| 64 | AUBEL | Sales Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN_VA | Allow NULL? |
| 65 | AUPOS | Sales Document Item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VBUP | POSNR_VA | Allow NULL? |
| 66 | VGBEL | Document number of the reference document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VGBEL | Allow NULL? |
| 67 | VGPOS | Item number of the reference item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | VBUP | VGPOS | Allow NULL? |
| 68 | SHKZG | Debit/Credit Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | SHKZG | Allow NULL? |
| 69 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 70 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | PRCTR | Allow NULL? |
| 71 | UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKZ | |
| 72 | UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMVKN | |
| 73 | KWMENG | Cumulative Order Quantity in Sales Units | decimal | 15 | 3 | QUAN | ((0)) | Yes | | KWMENG | |
| 74 | ZMENG | Target quantity in sales units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | DZMENG | |
| 75 | ZIEME | Target quantity UoM | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | DZIEME | Allow NULL? |
| 76 | UMZIZ | Factor for converting sales units to base units (target qty) | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMZIZ | |
| 77 | UMZIN | Factor for converting sales units to base units (target qty) | decimal | 5 | 0 | DEC | ((0)) | Yes | | UMZIN | |
| 78 | FKIMG | Actual Invoiced Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FKIMG | |
| 79 | LFIMG | Actual quantity delivered (in sales units) | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LFIMG | |
| 80 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | VRKME | Allow NULL? |
| 81 | FKLMG | Billing quantity in stockkeeping unit | decimal | 13 | 3 | QUAN | ((0)) | Yes | | FKLMG | |
| 82 | MEINS | Base Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | MEINS | Allow NULL? |
| 83 | LMENG | Required quantity for mat.management in stockkeeping units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | LMENG | |
| 84 | BDDAT | Requirement date (deadline for procurement) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BDDAT | Allow NULL? |
| 85 | WMENG | Order quantity in sales units | decimal | 13 | 3 | QUAN | ((0)) | Yes | | WMENG | |
| 86 | BMENG | Confirmed Quantity | decimal | 13 | 3 | QUAN | ((0)) | Yes | | BMENG | |
| 87 | KAPPL | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T681A | KAPPL | Allow NULL? |
| 88 | KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | KALSM_D | Allow NULL? |
| 89 | KNTYP | Condition category (examples: tax, freight, price, cost) | char | 1 | 0 | CHAR | (N' ') | Yes | | KNTYP | Allow NULL? |
| 90 | KWERT | Condition value | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERT | |
| 91 | WAERK | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | WAERS | Allow NULL? |
| 92 | KURSK | Exchange Rate for Price Determination | decimal | 9 | 5 | DEC | ((0)) | Yes | | KURSK | |
| 93 | KWERH | Condition value in local currency | decimal | 13 | 2 | CURR | ((0)) | Yes | | KWERH | |
| 94 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | HWAER | Allow NULL? |
| 95 | SAKN1 | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SAKNR | Allow NULL? |
| 96 | KZVBR | Consumption Posting | char | 1 | 0 | CHAR | (N' ') | Yes | | KZVBR | Allow NULL? |
| 97 | OBJNR | Object number at item level | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | * | OBJPO | Allow NULL? |
| 98 | AUART | Sales Document Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | AUART | Allow NULL? |
| 99 | GRPOS | Item for which this item is an alternative | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | GRPOS | Allow NULL? |
| 100 | VBELV | Originating document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VBELV | Allow NULL? |
| 101 | POSNV | Originating item | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | * | POSNV | Allow NULL? |
| 102 | ERLMENGE | Quantity for completion (sales) in basic unit of measure | decimal | 13 | 3 | QUAN | ((0)) | Yes | | ERLMENGE | |
| 103 | FAREG | Rule in billing plan/invoice plan | char | 1 | 0 | CHAR | (N' ') | Yes | | FAREG | Allow NULL? |
| 104 | FPROZ | Percentage of value to be invoiced | decimal | 5 | 2 | DEC | ((0)) | Yes | | FPROZ | |