SAP ABAP Table V_OLR3_VBAX_INQ (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_OLR3_VBAX_INQ   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 VBELN VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
3 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
4 ERZET ERZET UZEIT TIMS 6   0   Entry time  
5 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
6 ANGDT ANGDT_V DATUM DATS 8   0   Quotation/Inquiry is valid from  
7 BNDDT BNDDT DATUM DATS 8   0   Date until which bid/quotation is binding (valid-to date)  
8 AUDAT AUDAT DATUM DATS 8   0   Document Date (Date Received/Sent)  
9 VBTYP VBTYP VBTYP CHAR 1   0   SD document category  
10 TRVOG TRVOG TRVOG CHAR 1   0   Transaction group  
11 AUART AUART AUART CHAR 4   0   Sales Document Type TVAK
12 AUGRU AUGRU AUGRU CHAR 3   0   Order reason (reason for the business transaction) TVAU
13 GWLDT GWLDT DATUM DATS 8   0   Guarantee date  
14 SUBMI SUBMI_SD CHAR10 CHAR 10   0   Collective number (SD)  
15 LIFSK LIFSK LIFSP CHAR 2   0   Delivery block (document header) TVLS
16 FAKSK FAKSK FAKSP CHAR 2   0   Billing block in SD document TVFS
17 NETWR NETWR_AK WERTV8 CURR 15   2   Net Value of the Sales Order in Document Currency  
18 WAERK WAERK WAERS CUKY 5   0   SD document currency TCURC
19 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
20 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVKOV
21 SPART SPART SPART CHAR 2   0   Division TVTA
22 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
23 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVKBZ
24 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
25 GSKST GSKST GSBER CHAR 4   0   Business area from cost center TGSB
26 GUEBG GUEBG DATUM DATS 8   0   Valid-from date (outline agreements, product proposals)  
27 GUEEN GUEEN DATUM DATS 8   0   Valid-to date (outline agreements, product proposals)  
28 KNUMV KNUMV KNUMV CHAR 10   0   Number of the document condition  
29 VDATU EDATU_VBAK DATUM DATS 8   0   Requested delivery date  
30 VPRGR PRGRS_VBAK PRGRS CHAR 1   0   Proposed Period for Date  
31 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
32 VBKLA VBKLA CHAR9 CHAR 9   0   unused (sales doocument class)  
33 VBKLT VBKLT VBKLT CHAR 1   0   SD document indicator  
34 KALSM KALSMASD KALSM CHAR 6   0   Sales and Distribution: Pricing Procedure in Pricing T683
35 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
36 FKARA FKARA FKART CHAR 4   0   Proposed billing type for an order-related billing document TVFK
37 AWAHR AWAHR_AK AWAHR NUMC 3   0   Sales Probability  
38 KTEXT KTEXT_V TEXT40 CHAR 40   0   Search term for product proposal  
39 BSTNK BSTNK BSTNK CHAR 20   0   Customer purchase order number  
40 BSARK BSARK BSARK CHAR 4   0   Customer Order Type T176
41 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
42 BSTZD BSTZD BSTZD CHAR 4   0   Customer purchase order number supplement  
43 IHREZ IHREZ TEXT12 CHAR 12   0   Your Reference  
44 BNAME BNAME_V NAME CHAR 35   0   Name of orderer  
45 TELF1 TELF1_VP TELF1 CHAR 16   0   Telephone Number  
46 MAHZA MAHZA PACK2 DEC 3   0   Number of reminder notices, reminders for delivery purchase  
47 MAHDT MAHDT DATUM DATS 8   0   Last Delivery Reminder Notice  
48 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
49 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center  
50 STAFO STAFO STAFO CHAR 6   0   Update group for statistics update  
51 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
52 AEDAT AEDAT DATUM DATS 8   0   Last Changed On  
53 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
54 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
55 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
56 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
57 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
58 KNUMA KNUMA KNUMA CHAR 10   0   Agreement (various conditions grouped together) KONA
59 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
60 PS_PSP_PNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
61 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
62 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
63 KNKLI KNKLI KUNNR CHAR 10   0   Customer's account number with credit limit reference KNA1
64 GRUPP GRUPP_CM GRUPP_CM CHAR 4   0   Customer credit group  
65 SBGRP SBGRP_CM SBGRP_CM CHAR 3   0   Credit Representative Group for Credit Management T024B
66 CTLPC CTLPC_CM CTLPC_CM CHAR 3   0   Credit management: Risk category T691A
67 CMWAE WAERS_CM WAERS CUKY 5   0   Currency key of credit control area TCURC
68 CMFRE CMFRE DATUM DATS 8   0   Release date of the document determined by credit management  
69 CMNUP CMNUP DATUM DATS 8   0   Date of next credit check of document  
70 CMNGV CMNGV DATUM DATS 8   0   Next date  
71 AMTBL AMTBL_CM WERTV8 CURR 15   2   Released credit value of the document  
72 HITYP_PR HITYP_PR HITYP CHAR 1   0   Hierarchy type for pricing THIT
73 ABRVW ABRVW ABRVW CHAR 3   0   Usage Indicator TVLV
74 ABDIS ABDIS ABRAB CHAR 1   0   MRP for Release Types  
75 VGBEL VGBEL VBELN CHAR 10   0   Document number of the reference document VBUK
76 OBJNR OBJKO J_OBJNR CHAR 22   0   Object number at header level ONR00
77 BUKRS_VF BUKRS_VF BUKRS CHAR 4   0   Company code to be billed T001
78 TAXK1 TAXK1_AK TAXKD CHAR 1   0   Alternative tax classification  
79 TAXK2 TAXK2 TAXKD CHAR 1   0   Tax classification 2 for customer  
80 TAXK3 TAXK3 TAXKD CHAR 1   0   Tax classification 3 for customer  
81 TAXK4 TAXK4 TAXKD CHAR 1   0   Tax classification 4 for customer  
82 TAXK5 TAXK5 TAXKD CHAR 1   0   Tax classification 5 for customer  
83 TAXK6 TAXK6 TAXKD CHAR 1   0   Tax classification 6 for customer  
84 TAXK7 TAXK7 TAXKD CHAR 1   0   Tax classification 7 for customer  
85 TAXK8 TAXK8 TAXKD CHAR 1   0   Tax classification 8 for customer  
86 TAXK9 TAXK9 TAXKD CHAR 1   0   Tax classification 9 for customer  
87 XBLNR XBLNR_V1 XBLNR1 CHAR 16   0   Reference Document Number  
88 ZUONR ORDNR_V ZUONR CHAR 18   0   Assignment Number  
89 VGTYP VBTYP_V VBTYP CHAR 1   0   Document category of preceding SD document  
90 KALSM_CH KALSMA_CH KALSM CHAR 6   0   Search procedure for batch determination T683
91 AGRZR AGRZR NUM2 NUMC 2   0   Accrual period for order-related billing docs.to be accrued  
92 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
93 QMNUM QMNUM QMNUM CHAR 12   0   Message Number QMEL
94 VBELN_GRP VBELN_GRP VBELN CHAR 10   0   Group Master Contract  
95 SCHEME_GRP SCHEME_GRP SCHEME_GRP CHAR 4   0   Referencing requirement: Procedure TVGRPS
96 ABRUF_PART ABRUF_PART ABRUF_PART CHAR 1   0   Check partner authorizations  
97 ABHOD ABHOD DATUM DATS 8   0   Pick up date  
98 ABHOV ABHOZ UZEIT TIMS 6   0   Pick up time  
99 ABHOB ABHOZ UZEIT TIMS 6   0   Pick up time  
100 RPLNR RPLNR FPLNR CHAR 10   0   Installment Plan Number FPLA
101 VZEIT EZEIT_VBAK TIME_SAORG TIMS 6   0   Proposed schedule line time (local with ref. to sales org.)  
102 STCEG_L LAND1TX LAND1 CHAR 3   0   Tax Destination Country T005
103 LANDTX LANDTX LAND1 CHAR 3   0   Tax Departure Country T005
104 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
105 ENQUEUE_GRP ENQUEUE_GRP ENQUEUE_GRP CHAR 1   0   Block master contr. until all lower level contracts updated  
106 DAT_FZAU DAT_FZAU DATUM DATS 8   0   Cml delivery order qty date  
107 FMBDAT MBDAT DATUM DATS 8   0   Material Staging/Availability Date  
108 VSNMR_V VSNMR_V VSNMR CHAR 12   0   Sales document version number  
109 HANDLE TSEGGUID_VBAK SYSUUID_22 CHAR 22   0   International unique key for VBAK-VBELN  
110 PROLI ADGE_PROLI ADGD_PROLI CHAR 3   0   Dangerous Goods Management Profile in SD Documents TDGC5
111 CONT_DG ADGE_NCDG X CHAR 1   0   Indicator: Document contains dangerous goods  
112 LOGSYSB LOGSYSB LOGSYS CHAR 10   0   Logical system with which document was created  
113 KALCD KALCD KALSM CHAR 6   0   Procedure for Campaign Determination  
114 RFSTK RFSTK STATV CHAR 1   0   Reference document header status  
115 RFGSK RFGSK STATV CHAR 1   0   Total reference status of all items  
116 BESTK BESTK STATV CHAR 1   0   Confirmation status  
117 LFSTK LFSTK STATV CHAR 1   0   Delivery status  
118 LFGSK LKGSK STATV CHAR 1   0   Overall delivery status for all items  
119 WBSTK WBSTK STATV CHAR 1   0   Total goods movement status  
120 FKSTK FKSTK STATV CHAR 1   0   Billing status  
121 FKSAK FKSAK STATV CHAR 1   0   Billing status (order-related billing document)  
122 BUCHK BUCHK STATV CHAR 1   0   Posting Status of Billing Document  
123 ABSTK ABSTK STATV CHAR 1   0   Overall rejection status of all sales document items  
124 GBSTK GBSTK STATV CHAR 1   0   Overall processing status of document  
125 KOSTK KOSTK STATV CHAR 1   0   Overall picking / putaway status  
126 LVSTK LVSTK STATV CHAR 1   0   Overall status of warehouse management activities  
127 UVALS UVALL_SU STATV CHAR 1   0   Total incompletion status of all items in general  
128 UVVLS UVVLS_SU STATV CHAR 1   0   Total incompletion status of all items: Delivery  
129 UVFAS UVFAK_SU STATV CHAR 1   0   Total incompletion status of all items: Billing  
130 UVALL UVALL_UK STATV CHAR 1   0   General incompletion status of the header  
131 UVVLK UVVLK_UK STATV CHAR 1   0   Header incompletion status concerning delivery  
132 UVFAK UVFAK_UK STATV CHAR 1   0   Header incompletion status with respect to billing  
133 UVPRS UVPRS_UK STATV CHAR 1   0   Document is incomplete with respect to pricing  
134 VBOBJ VBOBJ VBOBJ CHAR 1   0   SD document object  
135 FKIVK FKIVK STATV CHAR 1   0   Billing totals status for intercompany billing  
136 RELIK RELIK STATV CHAR 1   0   Invoice list status of billing document  
137 UVK01 UVK01 STATV CHAR 1   0   Customer reserves 1: Header status  
138 UVK02 UVK02 STATV CHAR 1   0   Customer reserves 2: Header status  
139 UVK03 UVK03 STATV CHAR 1   0   Customer reserves 3: Header status  
140 UVK04 UVK04 STATV CHAR 1   0   Custmer reserves 4: Header status  
141 UVK05 UVK05 STATV CHAR 1   0   Customer reserves 5: Header status  
142 UVS01 UVS01 STATV CHAR 1   0   Customer reserves 1: Sum of all items  
143 UVS02 UVS02 STATV CHAR 1   0   Customer reserves 2: Sum of all items  
144 UVS03 UVS03 STATV CHAR 1   0   Customer reserves 3: Sum of all items  
145 UVS04 UVS04 STATV CHAR 1   0   Customer reserves 4: Sum of all items  
146 UVS05 UVS05 STATV CHAR 1   0   Customer reserves 5: Sum of all items  
147 PKSTK PKSTK STATV_PKST CHAR 1   0   Overall packing status of all items  
148 CMPSA CMPSA CMPSZ CHAR 1   0   Status of static credit limit check  
149 CMPSB CMPSB CMPSZ CHAR 1   0   Status of dynamic credit limit check in the credit horizon  
150 CMPSC CMPSC CMPSZ CHAR 1   0   Status of credit check against maximum document value  
151 CMPSD CMPSD CMPSZ CHAR 1   0   Status of credit check against terms of payment  
152 CMPSE CMPSE CMPSZ CHAR 1   0   Status of credit check against customer review date  
153 CMPSF CMPSF CMPSZ CHAR 1   0   Status of credit check against open items due  
154 CMPSG CMPSG CMPSZ CHAR 1   0   Status of credit check against oldest open items  
155 CMPSH CMPSH CMPSZ CHAR 1   0   Status of credit check against highest dunning level  
156 CMPSI CMPSI CMPSZ CHAR 1   0   Status of credit check against financial document  
157 CMPSJ CMPSJ CMPSZ CHAR 1   0   Status of credit check against export credit insurance  
158 CMPSK CMPSK CMPSZ CHAR 1   0   Status of credit check against payment card authorization  
159 CMPSL CMPSL CMPSZ CHAR 1   0   Status of credit check of reserves 4  
160 CMPS0 CMPS0 CMPSZ CHAR 1   0   Status of credit check for customer reserve 1  
161 CMPS1 CMPS1 CMPSZ CHAR 1   0   Status of credit check for customer reserve 2  
162 CMPS2 CMPS2 CMPSZ CHAR 1   0   Status of credit check for customer reserve 3  
163 CMGST CMGST CMGST CHAR 1   0   Overall status of credit checks  
164 TRSTA TRSTA TRSTA CHAR 1   0   Transportation planning status  
165 KOQUK KOQUK STATV CHAR 1   0   Status of pick confirmation  
166 COSTA COSTA_D COSTA CHAR 1   0   Confirmation status for ALE  
167 SAPRL SAPRL SAPRL CHAR 4   0   SAP Release  
168 UVPAS UVPAK_SU STATV CHAR 1   0   Totals incomplete status for all items: packaging  
169 UVPIS UVPIK_SU STATV CHAR 1   0   Totals incomplete status for all items: Picking  
170 UVWAS UVWAK_SU STATV CHAR 1   0   Total incomplete status of all items: post goods movement  
171 UVPAK UVPAK_UK STATV CHAR 1   0   Header incomplete status for packaging  
172 UVPIK UVPIK_UK STATV CHAR 1   0   Header incomplete status for picking/putaway  
173 UVWAK UVWAK_UK STATV CHAR 1   0   Post header incomplete status for goods movement  
174 UVGEK UVGEK_UK STATV CHAR 1   0   UNUSED  
175 CMPSM CMPSM CMPSZ CHAR 1   0   Credit check data is obsolete  
176 DCSTK DCSTK STATV CHAR 1   0   Delay status  
177 VESTK VESTK VESTK CHAR 1   0   Handling Unit Placed in Stock  
178 VLSTK VLSTK VLSTK CHAR 1   0   Distribution Status (Decentralized Warehouse Processing)  
179 RRSTA RR_STATUS STATV CHAR 1   0   Revenue determination status  
180 BLOCK BLOCK_VB BLOCK_VB CHAR 1   0   Indicator: Document preselected for archiving  
181 FSSTK FSSTK STATV CHAR 1   0   Overall billing block status  
182 LSSTK LSSTK_G STATV CHAR 1   0   Overall delivery block status  
183 SPSTG SPSTG STATV CHAR 1   0   Overall blocked status  
184 PDSTK PDSTK STATV CHAR 1   0   POD status on header level  
185 FMSTK FMSTK STATV CHAR 1   0   Status Funds Management  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_OLR3_VBAX_INQ ABRVW TVLV ABRVW REF C CN
2 V_OLR3_VBAX_INQ AUART TVAK AUART REF 1 CN
3 V_OLR3_VBAX_INQ AUFNR AUFK AUFNR REF C CN
4 V_OLR3_VBAX_INQ AUGRU TVAU AUGRU REF C CN
5 V_OLR3_VBAX_INQ BSARK T176 BSARK REF C CN
6 V_OLR3_VBAX_INQ BUKRS_VF T001 BUKRS REF C CN
7 V_OLR3_VBAX_INQ CMWAE TCURC WAERS REF C CN
8 V_OLR3_VBAX_INQ CTLPC T691A CTLPC REF C CN
9 V_OLR3_VBAX_INQ FAKSK TVFS FAKSP REF C CN
10 V_OLR3_VBAX_INQ FKARA TVFK FKART REF C CN
11 V_OLR3_VBAX_INQ GSBER TGSB GSBER REF C CN
12 V_OLR3_VBAX_INQ GSKST TGSB GSBER REF C CN
13 V_OLR3_VBAX_INQ HITYP_PR THIT HITYP REF C CN
14 V_OLR3_VBAX_INQ KALSM T683 KALSM REF C CN
15 V_OLR3_VBAX_INQ KALSM_CH T683 KALSM REF C CN
16 V_OLR3_VBAX_INQ KKBER T014 KKBER REF C CN
17 V_OLR3_VBAX_INQ KNKLI KNA1 KUNNR REF C CN
18 V_OLR3_VBAX_INQ KNUMA KONA KNUMA KEY 1 CN
19 V_OLR3_VBAX_INQ KOKRS TKA01 KOKRS REF C CN
20 V_OLR3_VBAX_INQ KUNNR KNA1 KUNNR REF C CN
21 V_OLR3_VBAX_INQ KURST TCURV KURST REF C CN
22 V_OLR3_VBAX_INQ KVGR1 TVV1 KVGR1 REF C CN
23 V_OLR3_VBAX_INQ KVGR2 TVV2 KVGR2 REF C CN
24 V_OLR3_VBAX_INQ KVGR3 TVV3 KVGR3 REF C CN
25 V_OLR3_VBAX_INQ KVGR4 TVV4 KVGR4 REF C CN
26 V_OLR3_VBAX_INQ KVGR5 TVV5 KVGR5 REF C CN
27 V_OLR3_VBAX_INQ LANDTX T005 LAND1 C CN
28 V_OLR3_VBAX_INQ LIFSK TVLS LIFSP REF C CN
29 V_OLR3_VBAX_INQ MANDT T000 MANDT KEY 1 CN
30 V_OLR3_VBAX_INQ OBJNR ONR00 OBJNR REF C CN
31 V_OLR3_VBAX_INQ PROLI TDGC5 PROLI    
32 V_OLR3_VBAX_INQ PS_PSP_PNR PRPS PSPNR REF C CN
33 V_OLR3_VBAX_INQ QMNUM QMEL QMNUM REF C CN
34 V_OLR3_VBAX_INQ RPLNR FPLA FPLNR REF C 1
35 V_OLR3_VBAX_INQ SBGRP T024B SBGRP REF C CN
36 V_OLR3_VBAX_INQ SCHEME_GRP TVGRPS SCHEME 1 CN
37 V_OLR3_VBAX_INQ SPART TVTA SPART REF 1 CN
38 V_OLR3_VBAX_INQ STCEG_L T005 LAND1 C CN
39 V_OLR3_VBAX_INQ STWAE TCURC WAERS REF C CN
40 V_OLR3_VBAX_INQ VBELN VBUK VBELN KEY 1 C
41 V_OLR3_VBAX_INQ VGBEL VBUK VBELN REF C CN
42 V_OLR3_VBAX_INQ VKBUR TVKBZ VKBUR REF C CN
43 V_OLR3_VBAX_INQ VKGRP TVBVK VKGRP REF C CN
44 V_OLR3_VBAX_INQ VKORG TVKO VKORG REF 1 CN
45 V_OLR3_VBAX_INQ VSBED TVSB VSBED REF C CN
46 V_OLR3_VBAX_INQ VTWEG TVKOV VTWEG REF 1 CN
47 V_OLR3_VBAX_INQ WAERK TCURC WAERS REF C CN
History
Last changed by/on SAP  20131127 
SAP Release Created in