SAP ABAP Table S264BIW2 (S264BIW2 * SD - Quotation)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-IS-DC (Application Component) Data Collection
     ⤷ MCSD (Package) Developments for SD BW Extractions
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S264BIW2   Table Relationship Diagram
Short Description S264BIW2 * SD - Quotation    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
9 POSNR POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
10 ETENR ETENR ETENR NUMC 4   0   Schedule line VBEP
11 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
12 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
13 .INCLUDE       0   0   SIS Characteristics: Quotation Header  
14 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
15 HWAER HWAER WAERS CUKY 5   0   Local Currency *
16 STWAE STWAE WAERS CUKY 5   0   Statistics currency *
17 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
18 AUART AUART AUART CHAR 4   0   Sales Document Type *
19 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
20 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
21 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
22 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
23 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 *
24 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 *
25 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 *
26 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 *
27 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 *
28 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
29 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
30 SPARA SPART_AK SPART CHAR 2   0   Division for order header *
31 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) *
32 FAKSK FAKSK FAKSP CHAR 2   0   Billing block in SD document *
33 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) *
34 VGTYP_AK MC_VBTYPAK VBTYP CHAR 1   0   Sales Document Category of Reference Doc. in Order Header  
35 ANGDT ANGDT DATUM DATS 8   0   Quotation Validity Date  
36 BNDDT BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
37 .INCLUDE       0   0   SIS Characteristics: Quotation Item  
38 PSTYV PSTYV PSTYV CHAR 4   0   Sales document item category *
39 MATNR MATNR MATNR CHAR 18   0   Material Number *
40 PRODH PRODH_D PRODH CHAR 18   0   Product Hierarchy *
41 MATKL MATKL MATKL CHAR 9   0   Material Group *
42 CHARG CHARG_D CHARG CHAR 10   0   Batch Number *
43 FAKSP FAKSP_AP FAKSP CHAR 2   0   Billing block for item *
44 WERKS WERKS_D WERKS CHAR 4   0   Plant *
45 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
46 VSTEL VSTEL VSTEL CHAR 4   0   Shipping Point/Receiving Point *
47 ROUTE ROUTE ROUTE CHAR 6   0   Route *
48 SPART SPART SPART CHAR 2   0   Division *
49 PKUNWE KUNWE KUNNR CHAR 10   0   Ship-to party *
50 PKUNRE KUNRE KUNNR CHAR 10   0   Bill-to party *
51 PKUNRG KUNRG KUNNR CHAR 10   0   Payer *
52 PSPDNR SPDNR LIFNR CHAR 10   0   Carrier *
53 PVRTNR VRTNR PERNR NUMC 8   0   Sales employee  
54 PABLA PABLA TEXT25 CHAR 25   0   Unloading point of the ship-to party  
55 MVGR1 MVGR1 MVGR1 CHAR 3   0   Material group 1 *
56 MVGR2 MVGR2 MVGR2 CHAR 3   0   Material group 2 *
57 MVGR3 MVGR3 MVGR3 CHAR 3   0   Material group 3 *
58 MVGR4 MVGR4 MVGR4 CHAR 3   0   Material group 4 *
59 MVGR5 MVGR5 MVGR5 CHAR 3   0   Material group 5 *
60 ABGRU ABGRU_VA ABGRU_VA CHAR 2   0   Reason for rejection of quotations and sales orders *
61 ABSTA ABSTA_VB STATV CHAR 1   0   Rejection status for SD item  
62 UVALL UVALL_UP STATV CHAR 1   0   General Incompletion Status of the Item  
63 UVVLK UVVLK_UP STATV CHAR 1   0   Incompletion Status of the Item with Regard to Delivery  
64 UVFAK UVFAK_UP STATV CHAR 1   0   Item incompletion status with respect to billing  
65 UVPRS UVPRS_UP STATV CHAR 1   0   Item is incomplete with respect to pricing  
66 KDGRP KDGRP KDGRP CHAR 2   0   Customer group *
67 BZIRK BZIRK BZIRK CHAR 6   0   Sales district *
68 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) *
69 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
70 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer *
71 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
72 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
73 PRSDT PRSDT DATUM DATS 8   0   Date for pricing and exchange rate  
74 FKDAT FKDAT DATUM DATS 8   0   Billing date for billing index and printout  
75 FBUDA FBUDA DATUM DATS 8   0   Date When Services Rendered  
76 STADAT STADAT DATUM DATS 8   0   Statistics date  
77 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
78 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
79 ZIEME DZIEME MEINS UNIT 3   0   Target quantity UoM *
80 GEWEI GEWEI MEINS UNIT 3   0   Weight Unit *
81 VOLEH VOLEH MEINS UNIT 3   0   Volume unit *
82 UMVKZ UMVKZ UMBSZ DEC 5   0   Numerator (factor) for conversion of sales quantity into SKU  
83 UMVKN UMVKN UMBSN DEC 5   0   Denominator (divisor) for conversion of sales qty. into SKU  
84 UMZIZ UMZIZ UMBSZ DEC 5   0   Factor for converting sales units to base units (target qty)  
85 UMZIN UMZIN UMBSN DEC 5   0   Factor for converting sales units to base units (target qty)  
86 CMKUA CMKUA KURRF DEC 9   5   Credit data exchange rate for requested delivery date  
87 KURSK KURSK KURRF DEC 9   5   Exchange Rate for Pricing and Statistics  
88 STCUR STCUR KURRF DEC 9   5   Exchange rate for statistics  
89 NETPR NETPR WERTV6 CURR 11   2   Net price  
90 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
91 AWAHR AWAHR AWAHR NUMC 3   0   Order probability of the item  
92 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
93 ERZET ERZET UZEIT TIMS 6   0   Entry time  
94 PS_POSID PS_POSID PS_POSID CHAR 24   0   Work Breakdown Structure Element (WBS Element)  
95 .INCLUDE       0   0   SIS Key Figures: Quotation Item  
96 NETWR NETWR_AP WERTV8 CURR 15   2   Net value of the order item in document currency  
97 WAVWR WAVWR WERTV7 CURR 13   2   Cost in document currency  
98 KZWI1 KZWI1 WERTV7 CURR 13   2   Subtotal 1 from pricing procedure for condition  
99 KZWI2 KZWI2 WERTV7 CURR 13   2   Subtotal 2 from pricing procedure for condition  
100 KZWI3 KZWI3 WERTV7 CURR 13   2   Subtotal 3 from pricing procedure for condition  
101 KZWI4 KZWI4 WERTV7 CURR 13   2   Subtotal 4 from pricing procedure for condition  
102 KZWI5 KZWI5 WERTV7 CURR 13   2   Subtotal 5 from pricing procedure for condition  
103 KZWI6 KZWI6 WERTV7 CURR 13   2   Subtotal 6 from pricing procedure for condition  
104 ZWERT DZWERT WERT7 CURR 13   2   Target value for outline agreement in document currency  
105 ZMENG DZMENG MENG13 QUAN 13   3   Target quantity in sales units  
106 KWMENG KWMENG MENG15 QUAN 15   3   Cumulative order quantity in sales units  
107 LSMENG LSMENG MENG15 QUAN 15   3   Cumulative Target Delivery Qty (all dlv-relev.sched.lines)  
108 KBMENG KBMENG MENG15 QUAN 15   3   Cumulative confirmed quantity in sales unit  
109 KLMENG KLMENG MENG15 QUAN 15   3   Cumulative Confirmed Quantity in Base Unit of Measure  
110 LFMNG MINLF MENG13 QUAN 13   3   Minimum delivery quantity in delivery note processing  
111 BRGEW BRGEW_AP MENG15 QUAN 15   3   Gross weight of item  
112 NTGEW NTGEW_AP MENG15 QUAN 15   3   Net weight of item  
113 VOLUM VOLUM_AP MENG15 QUAN 15   3   Volume of the item  
114 ANZAG MC_ANZAG MCZAEHLER DEC 9   0   Number of offers  
115 ANZAGPOS MC_ANZAGPO MCZAEHLER DEC 9   0   Number of quotation items  
116 .INCLUDE       0   0   SIS Characteristics: Quotation Schedule Line  
117 ETTYP ETTYP ETTYP CHAR 2   0   Item Cat. in Schedule Line *
118 LIFSP LIFSP_EP LIFSP CHAR 2   0   Schedule line blocked for delivery *
119 LDDAT LDDAT DATUM DATS 8   0   Loading Date  
120 TDDAT TDDAT_D DATUM DATS 8   0   Transportation Planning Date  
121 EDATU EDATU DATUM DATS 8   0   Schedule line date  
122 WADAT WADAT DATUM DATS 8   0   Goods Issue Date  
123 MBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
124 WLDATBE WLDATBE DATUM DATS 8   0   Desired del. date in confirmed schedule lines  
125 .INCLUDE       0   0   SIS Key Figures: Quotation Schedule Line  
126 WMENG WMENG MENG13 QUAN 13   3   Order quantity in sales units  
127 LMENG LMENG MENG13 QUAN 13   3   Required quantity for mat.management in stockkeeping units  
128 BMENG BMENG MENG13 QUAN 13   3   Confirmed quantity  
129 CMENG CMENG MENG13 QUAN 13   3   Corrected quantity in sales unit  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S264BIW2 ETENR VBEP ETENR    
2 S264BIW2 KUNNR KNA1 KUNNR    
3 S264BIW2 MANDT T000 MANDT    
4 S264BIW2 POSNR VBUP POSNR    
5 S264BIW2 VBELN VBUK VBELN    
6 S264BIW2 VRKME T006 MSEHI    
7 S264BIW2 WAERK TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in