| 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 | KBELN | Number of pricing document | nvarchar | 10 | 0 | CHAR | (N' ') | No | WKBK | KBELN | Allow NULL? |
| 3 | KBELP | Item Number of Pricing Document | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | KBELP | Allow NULL? |
| 4 | EKKAB | Purchase price conditions valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EKKAB | Allow NULL? |
| 5 | EKKBI | Purchase price conditions valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EKKBI | Allow NULL? |
| 6 | VKKAB | Sales conditions valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VKKAB | Allow NULL? |
| 7 | VKKBI | Sales conditions valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VKKBI | Allow NULL? |
| 8 | EKNUM | SP: Key for Transaction Conditions in Purchase Pricing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | EKNUM | Allow NULL? |
| 9 | VKNUM | SP: Key for Transaction Conditions in Purchase Pricing | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VKNUM | Allow NULL? |
| 10 | EKAPP | Application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | KAPPL | Allow NULL? |
| 11 | EKALS | Sales Pricing: Purchase Price Calculation Schema | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | EKALS | Allow NULL? |
| 12 | VKALS | Sales Pricing: Sales Price Calculation Schema | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | VKALS | Allow NULL? |
| 13 | MATKL | Material Group | nvarchar | 9 | 0 | CHAR | (N' ') | Yes | T023 | MATKL | Allow NULL? |
| 14 | MATNR | Material Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | MARA | MATNR | Allow NULL? |
| 15 | VRKPE | Sales price unit | decimal | 5 | 0 | DEC | ((0)) | Yes | | VRKPE | |
| 16 | VRKME | Sales unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | VRKME | Allow NULL? |
| 17 | EAN11 | International Article Number (EAN/UPC) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | EAN11 | Allow NULL? |
| 18 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 19 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 20 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 21 | EKORG | Purchasing Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T024E | EKORG | Allow NULL? |
| 22 | HWAER | Local Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | HWAER | Allow NULL? |
| 23 | LIFNR | Account Number of Vendor or Creditor | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | LFA1 | LIFNR | Allow NULL? |
| 24 | LTSNR | Vendor Subrange | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | WYT1 | LTSNR | Allow NULL? |
| 25 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 26 | EKPGR | Purchase Price Calculation: (Basic Purchase Price) | decimal | 11 | 2 | CURR | ((0)) | Yes | | EKPGR | |
| 27 | EKPNN | Sales Pricing: Purchase Price (Net/Net) | decimal | 11 | 2 | CURR | ((0)) | Yes | | EKPNN | |
| 28 | AUFSG | Actual Markup in Sales Price Calculation | decimal | 11 | 2 | CURR | ((0)) | Yes | | AUFSG | |
| 29 | PAUFS | Planned markup | decimal | 11 | 2 | CURR | ((0)) | Yes | | PAUFS | |
| 30 | PENDP | SP calculation: Planned sales pr. w/o price point rounding | decimal | 11 | 2 | CURR | ((0)) | Yes | | PENDP | |
| 31 | VKPNE | Sales price (net) | decimal | 11 | 2 | CURR | ((0)) | Yes | | VKPNE | |
| 32 | VKPBR | Sales price (gross) | decimal | 11 | 2 | CURR | ((0)) | Yes | | VKPBR | |
| 33 | KWAER | Sales Pricing: Pricing Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | KAWAER | Allow NULL? |
| 34 | ENDPR | Final price | decimal | 11 | 2 | CURR | ((0)) | Yes | | ENDPR | |
| 35 | SPANE | Margin (net) in sales price calculation | decimal | 11 | 2 | CURR | ((0)) | Yes | | SPANE | |
| 36 | SPABR | Margin (gross) in sales price calculation | decimal | 11 | 2 | CURR | ((0)) | Yes | | SPABR | |
| 37 | ENDPA | Current Final Price | decimal | 11 | 2 | CURR | ((0)) | Yes | | ENDPA | |
| 38 | SPANA | Current margin (net) | decimal | 11 | 2 | CURR | ((0)) | Yes | | SPANA | |
| 39 | SPABA | Current margin (gross) | decimal | 11 | 2 | CURR | ((0)) | Yes | | SPABA | |
| 40 | ROTPR | Reduced-from price | decimal | 11 | 2 | CURR | ((0)) | Yes | | ROTPR | |
| 41 | MITPR | Cash price | decimal | 11 | 2 | CURR | ((0)) | Yes | | MITPR | |
| 42 | EMPPR | Recommended price | decimal | 11 | 2 | CURR | ((0)) | Yes | | EMPPR | |
| 43 | VORPR | Sales Pricing: Suggested Price | decimal | 11 | 2 | CURR | ((0)) | Yes | | W_VORPR | |
| 44 | VKP01 | Variable sales price | decimal | 11 | 2 | CURR | ((0)) | Yes | | VKPZW | |
| 45 | VKP02 | Variable sales price | decimal | 11 | 2 | CURR | ((0)) | Yes | | VKPZW | |
| 46 | VKP03 | Variable sales price | decimal | 11 | 2 | CURR | ((0)) | Yes | | VKPZW | |
| 47 | PROZ1 | Sales Price Calculation: (general) percentage-based factor | decimal | 11 | 2 | CURR | ((0)) | Yes | | W_PROZ | |
| 48 | PROZ2 | Sales Price Calculation: (general) percentage-based factor | decimal | 11 | 2 | CURR | ((0)) | Yes | | W_PROZ | |
| 49 | EVAUF | Sales Pricing: Markup for Determining the Retail Price | decimal | 11 | 2 | CURR | ((0)) | Yes | | EVAUF | |
| 50 | EVPRS | Sales Pricing: Retail Price | decimal | 11 | 2 | CURR | ((0)) | Yes | | EVPRS | |
| 51 | EVSPA | Sales Pricing: Retail Price Margin | decimal | 11 | 2 | CURR | ((0)) | Yes | | EVSPA | |
| 52 | BPSTA | Pricing: Status of Item in Pricing Document | char | 1 | 0 | CHAR | (N' ') | Yes | | BPSTA | Allow NULL? |
| 53 | PLTYP | Price list type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T189 | PLTYP | Allow NULL? |
| 54 | VKABA | Sales conditions valid from | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VKKAB | Allow NULL? |
| 55 | VKBIA | Sales conditions valid to | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VKKBI | Allow NULL? |
| 56 | INFWK | Info record at plant level | char | 1 | 0 | CHAR | (N' ') | Yes | | INFWK | Allow NULL? |
| 57 | ESOKZ | Purchasing info record category | char | 1 | 0 | CHAR | (N' ') | Yes | | ESOKZ | Allow NULL? |
| 58 | EVPAU | Planned markup for determining the retail price | decimal | 11 | 2 | CURR | ((0)) | Yes | | EVPAU | |
| 59 | CKNUM | Sales Price: Key for Transaction Conditions in Master Conds. | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CKNUM | Allow NULL? |
| 60 | VWAER | Sales currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | VWAER | Allow NULL? |
| 61 | EVWRS | Sales currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | VWAER | Allow NULL? |
| 62 | EGKAL | Data held when basic purchase price changes | char | 1 | 0 | CHAR | (N' ') | Yes | | EGKAL | Allow NULL? |
| 63 | INIPR | Final price | decimal | 11 | 2 | CURR | ((0)) | Yes | | ENDPR | |
| 64 | KNUMH_V | Number of the sales price condition record | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KNUMH_V | Allow NULL? |
| 65 | EKERV | Purchase price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | EKERV_M | Allow NULL? |
| 66 | BWERA | Source determination type | char | 1 | 0 | CHAR | (N' ') | Yes | | BWERA | Allow NULL? |
| 67 | EKERA | Purchase price determination type | char | 1 | 0 | CHAR | (N' ') | Yes | | EKERA | Allow NULL? |
| 68 | EFNAM | Name of the Function Module in PP Determination Type C | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | EFNAM | Allow NULL? |
| 69 | VKERV | Sales price determination sequence | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | EKERV_V | Allow NULL? |
| 70 | VKERA | Sales price determination type | char | 1 | 0 | CHAR | (N' ') | Yes | | VKERA | Allow NULL? |
| 71 | LIFEL | Sales Pricing: List Field for Determining Sales Price | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | LIFELD | Allow NULL? |
| 72 | ECKKZ | SP calc.: price point rounding for suggested final price | char | 1 | 0 | CHAR | (N' ') | Yes | | ECKKZ | Allow NULL? |
| 73 | PVGRD | Reason for retail price change | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PV_GRUND | Allow NULL? |
| 74 | FAMNR | Identification Number for Price Family | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WPF_FAMNR | Allow NULL? |
| 75 | GRP01 | Number of a Family Group in a Price Family | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | WPF_GROUP | Allow NULL? |
| 76 | FMTYP | Type of Family Member | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WPF_FMTYP | Allow NULL? |
| 77 | SMATN | Master Material of a Price Family | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | * | WPF_SMATN | Allow NULL? |
| 78 | FCHAL | Price Change Allowed (_=No, 1=Group, 2=Group and Article) | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_FCHAL | Allow NULL? |
| 79 | FHIDE | Pricing Item Hidden for Family Member (X = Yes) | char | 1 | 0 | CHAR | (N' ') | Yes | | WPF_FHIDE | Allow NULL? |
| 80 | EPRGR | Price point group | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | EPRGR | Allow NULL? |
| 81 | EPRG2 | Price point group for retail price | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | EPRG2 | Allow NULL? |
| 82 | NEPGR | Indicator: No Price Point Group | char | 1 | 0 | CHAR | (N' ') | Yes | | NEPGR | Allow NULL? |
| 83 | NEPG2 | Indicator: No Price Point Group | char | 1 | 0 | CHAR | (N' ') | Yes | | NEPGR | Allow NULL? |
| 84 | INIAM | Sales price calculations: key date for initial price | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | W_INIAM | Allow NULL? |
| 85 | EPTYP | Price Point Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | EPTYP | Allow NULL? |
| 86 | EPTY2 | Price Point Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | EPTYP | Allow NULL? |
| 87 | RKTYP | Price Point Groups: Ranking Type | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_RPC_RKTYP | Allow NULL? |
| 88 | RKTY2 | Price Point Groups: Ranking Type | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_RPC_RKTYP | Allow NULL? |
| 89 | BGINT | Internal Class Number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | * | CLINT | Allow NULL? |
| 90 | STPLGR | Status of Plant Group | char | 1 | 0 | CHAR | (N' ') | Yes | | WRF_STPLGR | Allow NULL? |
| 91 | VLGWK | Sales Pricing: Reference Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | VLGWK | Allow NULL? |
| 92 | KALEB | Sales Pricing: Pricing level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KALEB | Allow NULL? |
| 93 | VKSCH | Sales Pricing: Condition Type for the Sales Price | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | W_VKSCH_KALP | Allow NULL? |
| 94 | VKOTABN | Sales Pricing: Condition Table for the Sales Price | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | W_VKOTABN_KALP | Allow NULL? |
| 95 | KALEA | Pricing Level of Current Final Price | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | KALEA | Allow NULL? |
| 96 | VKSCA | SP Calculation: Condition Type for Current Sales Price | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | W_VKSCA_KALP | Allow NULL? |
| 97 | VKOTABA | Sales Pricing: Condition Table for the Current Sales Price | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | W_VKOTABA_KALP | Allow NULL? |
