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
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |