S264BIW2 - S264BIW2 * SD - Quotation
S264BIW2 * SD - Quotation information is stored in SAP table S264BIW2.
It is part of development package MCSD in software component SD-IS-DC. This development package consists of objects that can be grouped under "Developments for SD BW Extractions".
It is part of development package MCSD in software component SD-IS-DC. This development package consists of objects that can be grouped under "Developments for SD BW Extractions".
Fields for table S264BIW2
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | |
SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
VBELN | Sales Document | X | VBELN_VA | CHAR | 20 | |
POSNR | Sales Document Item | X | POSNR_VA | NUMC | 12 | |
ETENR | Schedule Line Number | X | ETENR | NUMC | 8 | VBEP |
PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | ||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
.INCLUDE | MCVBACHAR | 0 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
HWAER | Local Currency | HWAER | CUKY | 10 | * | |
STWAE | Statistics Currency | STWAE | CUKY | 10 | * | |
BUKRS | Company Code | BUKRS | CHAR | 8 | ||
AUART | Sales Document Type | AUART | CHAR | 8 | * | |
VBTYP | SD Document Category | VBTYPL | CHAR | 8 | ||
VKORG | Sales Organization | VKORG | CHAR | 8 | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 4 | ||
VKBUR | Sales office | VKBUR | CHAR | 8 | * | |
KVGR1 | Customer Group 1 | KVGR1 | CHAR | 6 | * | |
KVGR2 | Customer Group 2 | KVGR2 | CHAR | 6 | * | |
KVGR3 | Customer Group 3 | KVGR3 | CHAR | 6 | * | |
KVGR4 | Customer Group 4 | KVGR4 | CHAR | 6 | * | |
KVGR5 | Customer Group 5 | KVGR5 | CHAR | 6 | * | |
VKGRP | Sales group | VKGRP | CHAR | 6 | * | |
KUNNR | Sold-to Party | KUNAG | CHAR | 20 | KNA1 | |
SPARA | Division for order header | SPART_AK | CHAR | 4 | * | |
AUGRU | Order Reason (Reason for the Business Transaction) | AUGRU | CHAR | 6 | * | |
FAKSK | Billing Block in SD Document | FAKSK | CHAR | 4 | * | |
LIFSK | Delivery Block (Document Header) | LIFSK | CHAR | 4 | * | |
VGTYP_AK | Sales Document Category of Reference Doc. in Order Header | MC_VBTYPAK | CHAR | 8 | ||
ANGDT | Quotation Validity Date | ANGDT | DATS | 16 | ||
BNDDT | Date Until Which Bid/Quotation is Binding (Valid-To Date) | BNDDT | DATS | 16 | ||
.INCLUDE | MCVBNCHAR | 0 | ||||
PSTYV | Sales document item category | PSTYV | CHAR | 8 | * | |
MATNR | Material Number | MATNR | CHAR | 80 | ||
PRODH | Product hierarchy | PRODH_D | CHAR | 36 | * | |
MATKL | Material Group | MATKL | CHAR | 18 | ||
CHARG | Batch Number | CHARG_D | CHAR | 20 | * | |
FAKSP | Billing Block for Item | FAKSP_AP | CHAR | 4 | * | |
WERKS | Plant | WERKS_D | CHAR | 8 | ||
LGORT | Storage location | LGORT_D | CHAR | 8 | * | |
VSTEL | Shipping Point / Receiving Point | VSTEL | CHAR | 8 | * | |
ROUTE | Route | ROUTE | CHAR | 12 | * | |
SPART | Division | SPART | CHAR | 4 | ||
PKUNWE | Ship-to Party | KUNWE | CHAR | 20 | * | |
PKUNRE | Bill-to Party | KUNRE | CHAR | 20 | * | |
PKUNRG | Payer | KUNRG | CHAR | 20 | * | |
PSPDNR | Forwarding Agent | SPDNR | CHAR | 20 | * | |
PVRTNR | Sales employee | VRTNR | NUMC | 16 | ||
PABLA | Unloading point of the ship-to party | PABLA | CHAR | 50 | ||
MVGR1 | Material Group 1 | MVGR1 | CHAR | 6 | * | |
MVGR2 | Material Group 2 | MVGR2 | CHAR | 6 | * | |
MVGR3 | Material Group 3 | MVGR3 | CHAR | 6 | * | |
MVGR4 | Material Group 4 | MVGR4 | CHAR | 6 | * | |
MVGR5 | Material Group 5 | MVGR5 | CHAR | 6 | * | |
ABGRU | Reason for Rejection of Sales Documents | ABGRU_VA | CHAR | 4 | * | |
ABSTA | Rejection Status (Item) | ABSTA_VB | CHAR | 2 | ||
UVALL | Incompletion Status (Item) | UVALL_UP | CHAR | 2 | ||
UVVLK | Delivery Incompletion Status (Item) | UVVLK_UP | CHAR | 2 | ||
UVFAK | Billing Incompletion Status (Item) | UVFAK_UP | CHAR | 2 | ||
UVPRS | Pricing Incompletion Status (Item) | UVPRS_UP | CHAR | 2 | ||
KDGRP | Customer Group | KDGRP | CHAR | 4 | * | |
BZIRK | Sales District | BZIRK | CHAR | 12 | * | |
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 6 | * | |
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 56 | ||
KTGRD | Account Assignment Group for this Customer | KTGRD | CHAR | 4 | * | |
ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
PRSDT | Date for Pricing and Exchange Rate | PRSDT | DATS | 16 | ||
FKDAT | Billing Date | FKDAT | DATS | 16 | ||
FBUDA | Date on which services are rendered | FBUDA | DATS | 16 | ||
STADAT | Statistics date | STADAT | DATS | 16 | ||
VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
MEINS | Base Unit of Measure | MEINS | UNIT | 6 | * | |
GEWEI | Weight Unit | GEWEI | UNIT | 6 | * | |
VOLEH | Volume unit | VOLEH | UNIT | 6 | * | |
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 3 | ||
UMVKN | Denominator (divisor) for conversion of sales Qty into SKU | UMVKN | DEC | 3 | ||
UMZIZ | Factor for Converting Sales Units to Base Units (Target Qty) | UMZIZ | DEC | 3 | ||
UMZIN | Factor for Converting Sales Units to Base Units (Target Qty) | UMZIN | DEC | 3 | ||
CMKUA | Credit data exchange rate for requested delivery date | CMKUA | DEC | 5 | ||
KURSK | Exchange Rate for Price Determination | KURSK | DEC | 5 | ||
STCUR | Exchange rate for statistics | STCUR | DEC | 5 | ||
NETPR | Net Price | NETPR | CURR | 6 | ||
VGTYP | SD Document Category | VBTYPL | CHAR | 8 | ||
AWAHR | Order Probability of the Item | AWAHR | NUMC | 6 | ||
ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
ERZET | Entry time | ERZET | TIMS | 12 | ||
PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 48 | ||
.INCLUDE | MCVBNKYF | 0 | ||||
NETWR | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 8 | ||
WAVWR | Cost in Document Currency | WAVWR | CURR | 7 | ||
KZWI1 | Subtotal 1 from Pricing Procedure for Price Element | KZWI1 | CURR | 7 | ||
KZWI2 | Subtotal 2 from Pricing Procedure for Price Element | KZWI2 | CURR | 7 | ||
KZWI3 | Subtotal 3 from Pricing Procedure for Price Element | KZWI3 | CURR | 7 | ||
KZWI4 | Subtotal 4 from Pricing Procedure for Price Element | KZWI4 | CURR | 7 | ||
KZWI5 | Subtotal 5 from Pricing Procedure for Price Element | KZWI5 | CURR | 7 | ||
KZWI6 | Subtotal 6 from Pricing Procedure for Price Element | KZWI6 | CURR | 7 | ||
KWMENG | Cumulative order quantity in sales units | KWMENG | QUAN | 8 | ||
LSMENG | Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines) | LSMENG | QUAN | 8 | ||
KBMENG | Cumulative Confirmed Quantity in Sales Unit | KBMENG | QUAN | 8 | ||
KLMENG | Cumulative Confirmed Quantity in Base Unit | KLMENG | QUAN | 8 | ||
LFMNG | Minimum Delivery Quantity in Delivery Note Processing | MINLF | QUAN | 7 | ||
BRGEW | Gross Weight of the Item | BRGEW_AP | QUAN | 8 | ||
NTGEW | Net Weight of the Item | NTGEW_AP | QUAN | 8 | ||
VOLUM | Volume of the item | VOLUM_AP | QUAN | 8 | ||
ANZAG | Number of offers | MC_ANZAG | DEC | 5 | ||
ANZAGPOS | Number of quotation items | MC_ANZAGPO | DEC | 5 | ||
.INCLUDE | MCVBOCHAR | 0 | ||||
ETTYP | Schedule line category | ETTYP | CHAR | 4 | * | |
LIFSP | Schedule Line Blocked for Delivery | LIFSP_EP | CHAR | 4 | * | |
LDDAT | Loading Date | LDDAT | DATS | 16 | ||
TDDAT | Transportation Planning Date | TDDAT_D | DATS | 16 | ||
EDATU | Schedule line date | EDATU | DATS | 16 | ||
WADAT | Goods Issue Date | WADAT | DATS | 16 | ||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 16 | ||
WLDATBE | Desired del. date in confirmed schedule lines | WLDATBE | DATS | 16 | ||
.INCLUDE | MCVBOKYF | 0 | ||||
WMENG | Order Quantity in Sales Units | WMENG | QUAN | 7 | ||
LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 7 | ||
BMENG | Confirmed Quantity | BMENG | QUAN | 7 | ||
CMENG | Corrected quantity in sales unit | CMENG | QUAN | 7 |