SAP ABAP View V_CM01_OPT (Selection VBAK, VBUK, VBAP)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       VKM (Package) Application development R/3 credit management
Basic Data
View Type D Database View 
Database View V_CM01_OPT  
Short Description Selection VBAK, VBUK, VBAP    
Root table VBAK   Sales Document: Header Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 VBAK VBAK
2 VBUK  
3 VBAP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 VBAK MANDT JL EQ 0 0
2 VBUK MANDT JR EQ AND 0 0
3 VBAK VBELN JL EQ 0 0
4 VBUK VBELN JR EQ AND 0 0
5 VBAK MANDT JL EQ 0 0
6 VBAP MANDT JR EQ AND 0 0
7 VBAK VBELN JL EQ 0 0
8 VBAP VBELN JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT VBAK MANDT   MANDT Client
2 VBELN VBAK VBELN   VBELN_VA Sales Document
3 ERNAM VBAK ERNAM   ERNAM Name of Person who Created the Object
4 VKORG VBAK VKORG   VKORG Sales Organization
5 VTWEG VBAK VTWEG   VTWEG Distribution Channel
6 SPART VBAK SPART   SPART Division
7 VKGRP VBAK VKGRP   VKGRP Sales group
8 VKBUR VBAK VKBUR   VKBUR Sales office
9 KKBER VBAK KKBER   KKBER Credit control area
10 KNKLI VBAK KNKLI   KNKLI Customer's account number with credit limit reference
11 GRUPP VBAK GRUPP   GRUPP_CM Customer credit group
12 SBGRP VBAK SBGRP   SBGRP_CM Credit Representative Group for Credit Management
13 CTLPC VBAK CTLPC   CTLPC_CM Credit management: Risk category
14 CMNUP VBAK CMNUP   CMNUP Date of next credit check of document
15 CMNGV VBAK CMNGV   CMNGV Next date
16 RPLNR VBAK RPLNR   RPLNR Installment Plan Number
17 GBSTK VBUK GBSTK   GBSTK Overall processing status of document
18 VBOBJ VBUK VBOBJ   VBOBJ SD document object
19 CMGST VBUK CMGST   CMGST Overall status of credit checks
20 POSNR VBAP POSNR   POSNR_VA Sales Document Item
21 MATNR VBAP MATNR   MATNR Material Number
22 MATWA VBAP MATWA   MATWA Material entered
23 PMATN VBAP PMATN   PMATN Pricing Reference Material
24 CHARG VBAP CHARG   CHARG_D Batch Number
25 MATKL VBAP MATKL   MATKL Material Group
26 ARKTX VBAP ARKTX   ARKTX Short text for sales order item
27 PSTYV VBAP PSTYV   PSTYV Sales document item category
28 POSAR VBAP POSAR   POSAR Item type
29 LFREL VBAP LFREL   LFREL_AP Item is relevant for delivery
30 FKREL VBAP FKREL   FKREL Relevant for Billing
31 UEPOS VBAP UEPOS   UEPOS Higher-level item in bill of material structures
32 GRPOS VBAP GRPOS   GRPOS Item for which this item is an alternative
33 ABGRU VBAP ABGRU   ABGRU_VA Reason for rejection of quotations and sales orders
34 PRODH VBAP PRODH   PRODH_D Product Hierarchy
35 ZWERT VBAP ZWERT   DZWERT Target value for outline agreement in document currency
36 ZMENG VBAP ZMENG   DZMENG Target quantity in sales units
37 ZIEME VBAP ZIEME   DZIEME Target quantity UoM
38 UMZIZ VBAP UMZIZ   UMZIZ Factor for converting sales units to base units (target qty)
39 UMZIN VBAP UMZIN   UMZIN Factor for converting sales units to base units (target qty)
40 MEINS VBAP MEINS   MEINS Base Unit of Measure
41 SMENG VBAP SMENG   SMENG Scale quantity in base unit of measure
42 ABLFZ VBAP ABLFZ   ABLFZ Rounding quantity for delivery
43 ABDAT VBAP ABDAT   ABDAT Reconciliation date for agreed cumulative quantity
44 ABSFZ VBAP ABSFZ   ABSFZ Allowed deviation in quantity (absolute)
45 POSEX VBAP POSEX   POSEX Item Number of the Underlying Purchase Order
46 KDMAT VBAP KDMAT   MATNR_KU Customer Material Number
47 KBVER VBAP KBVER   KBVER Allowed deviation in quantity (in percent)
48 KEVER VBAP KEVER   KEVER Days by which the quantity can be shifted
49 VKGRU VBAP VKGRU   VKGRU Repair processing: Classify items
50 VKAUS VBAP VKAUS   ABRVW Usage Indicator
51 GRKOR VBAP GRKOR   GRKOR Delivery group (items are delivered together)
52 FMENG VBAP FMENG   FMENG Quantity is fixed
53 UEBTK VBAP UEBTK   UEBTK_V Unlimited overdelivery allowed
54 UEBTO VBAP UEBTO   UEBTO Overdelivery Tolerance Limit
55 UNTTO VBAP UNTTO   UNTTO Underdelivery Tolerance Limit
56 FAKSP VBAP FAKSP   FAKSP_AP Billing block for item
57 ATPKZ VBAP ATPKZ   ATPKZ Replacement part
58 RKFKF VBAP RKFKF   RKFKF Form of Billing for CO/PPC Orders
59 GSBER VBAP GSBER   GSBER Business Area
60 NETWR VBAP NETWR   NETWR_AP Net value of the order item in document currency
61 WAERK VBAP WAERK   WAERK SD document currency
62 ANTLF VBAP ANTLF   ANTLF Maximum number of partial deliveries allowed per item
63 KZTLF VBAP KZTLF   KZTLF Partial delivery at item level
64 CHSPL VBAP CHSPL   CHSPL Batch split allowed
65 KWMENG VBAP KWMENG   KWMENG Cumulative order quantity in sales units
66 LSMENG VBAP LSMENG   LSMENG Cumulative Target Delivery Qty (all dlv-relev.sched.lines)
67 KBMENG VBAP KBMENG   KBMENG Cumulative confirmed quantity in sales unit
68 KLMENG VBAP KLMENG   KLMENG Cumulative Confirmed Quantity in Base Unit of Measure
69 VRKME VBAP VRKME   VRKME Sales unit
70 UMVKZ VBAP UMVKZ   UMVKZ Numerator (factor) for conversion of sales quantity into SKU
71 UMVKN VBAP UMVKN   UMVKN Denominator (divisor) for conversion of sales qty. into SKU
72 BRGEW VBAP BRGEW   BRGEW_AP Gross weight of item
73 NTGEW VBAP NTGEW   NTGEW_AP Net weight of item
74 GEWEI VBAP GEWEI   GEWEI Weight Unit
75 VOLUM VBAP VOLUM   VOLUM_AP Volume of the item
76 VOLEH VBAP VOLEH   VOLEH Volume unit
77 VBELV VBAP VBELV   VBELV Originating document
78 POSNV VBAP POSNV   POSNV Originating item
79 VGBEL VBAP VGBEL   VGBEL Document number of the reference document
80 VGPOS VBAP VGPOS   VGPOS Item number of the reference item
81 VOREF VBAP VOREF   VOREF Complete reference indicator
82 UPFLU VBAP UPFLU   UPFLV Update indicator for sales document document flow
83 ERLRE VBAP ERLRE   ERLRE Completion rule for quotation / contract
84 LPRIO VBAP LPRIO   LPRIO Delivery priority
85 WERKS VBAP WERKS   WERKS_EXT Plant (Own or External)
86 LGORT VBAP LGORT   LGORT_D Storage location
87 VSTEL VBAP VSTEL   VSTEL Shipping Point/Receiving Point
88 ROUTE VBAP ROUTE   ROUTE Route
89 STKEY VBAP STKEY   STKEY Origin of the bill of material
90 STDAT VBAP STDAT   STDAT Date of Bill of Material
91 STLNR VBAP STLNR   STNUM Bill of Material
92 STPOS VBAP STPOS   STPOS_VBAP Bill of material item number VBAP not used
93 AWAHR VBAP AWAHR   AWAHR Order probability of the item
94 ERDAT VBAP ERDAT   ERDAT Date on which the record was created
95 ERZET VBAP ERZET   ERZET Entry time
96 TAXM1 VBAP TAXM1   TAXMT Tax classification material
97 TAXM2 VBAP TAXM2   TAXMT Tax classification material
98 TAXM3 VBAP TAXM3   TAXMT Tax classification material
99 TAXM4 VBAP TAXM4   TAXMT Tax classification material
100 TAXM5 VBAP TAXM5   TAXMT Tax classification material
101 TAXM6 VBAP TAXM6   TAXMT Tax classification material
102 TAXM7 VBAP TAXM7   TAXMT Tax classification material
103 TAXM8 VBAP TAXM8   TAXMT Tax classification material
104 TAXM9 VBAP TAXM9   TAXMT Tax classification material
105 VBEAF VBAP VBEAF   VBEAF Fixed shipping processing time in days (= setup time)
106 VBEAV VBAP VBEAV   VBEAV Variable shipping processing time in days
107 VGREF VBAP VGREF   VGREF Preceding document has resulted from reference
108 NETPR VBAP NETPR   NETPR Net price
109 KPEIN VBAP KPEIN   KPEIN Condition pricing unit
110 KMEIN VBAP KMEIN   KMEIN Condition Unit
111 SHKZG VBAP SHKZG   SHKZG_VA Returns Item
112 SKTOF VBAP SKTOF   SKTOF Cash discount indicator
113 MTVFP VBAP MTVFP   MTVFP Checking Group for Availability Check
114 SUMBD VBAP SUMBD   SUMBD Summing up of requirements
115 KONDM VBAP KONDM   KONDM Material Pricing Group
116 KTGRM VBAP KTGRM   KTGRM Account assignment group for this material
117 BONUS VBAP BONUS   BONUS Volume rebate group
118 PROVG VBAP PROVG   PROVG Commission group
119 EANNR VBAP EANNR   EANNR European Article Number (EAN) - obsolete!!!!!
120 PRSOK VBAP PRSOK   PRSOK Pricing is OK
121 BWTAR VBAP BWTAR   BWTAR_D Valuation type
122 BWTEX VBAP BWTEX   BWTEX Indicator: Separate valuation
123 XCHPF VBAP XCHPF   XCHPF Batch management requirement indicator
124 XCHAR VBAP XCHAR   XCHAR Batch management indicator (internal)
125 LFMNG VBAP LFMNG   MINLF Minimum delivery quantity in delivery note processing
126 STAFO VBAP STAFO   STAFO Update group for statistics update
127 WAVWR VBAP WAVWR   WAVWR Cost in document currency
128 KZWI1 VBAP KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
129 KZWI2 VBAP KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
130 KZWI3 VBAP KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
131 KZWI4 VBAP KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
132 KZWI5 VBAP KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
133 KZWI6 VBAP KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
134 STCUR VBAP STCUR   STCUR_AP Exchange rate for statistics (Exch.rate at time of creation)
135 AEDAT VBAP AEDAT   AEDAT Last Changed On
136 EAN11 VBAP EAN11   EAN11 International Article Number (EAN/UPC)
137 FIXMG VBAP FIXMG   FIXMG Delivery date and quantity fixed
138 PRCTR VBAP PRCTR   PRCTR Profit Center
139 MVGR1 VBAP MVGR1   MVGR1 Material group 1
140 MVGR2 VBAP MVGR2   MVGR2 Material group 2
141 MVGR3 VBAP MVGR3   MVGR3 Material group 3
142 MVGR4 VBAP MVGR4   MVGR4 Material group 4
143 MVGR5 VBAP MVGR5   MVGR5 Material group 5
144 KMPMG VBAP KMPMG   KMPMG Component Quantity
145 SUGRD VBAP SUGRD   SUGRD Reason for material substitution
146 SOBKZ VBAP SOBKZ   SOBKZ Special Stock Indicator
147 VPZUO VBAP VPZUO   VPZUO Allocation Indicator
148 PAOBJNR VBAP PAOBJNR   RKEOBJNR Profitability Segment Number (CO-PA)
149 PS_PSP_PNR VBAP PS_PSP_PNR   PS_PSP_PNR Work Breakdown Structure Element (WBS Element)
150 AUFNR VBAP AUFNR   AUFNR Order Number
151 VPMAT VBAP VPMAT   VPMAT Planning material
152 VPWRK VBAP VPWRK   VPWRK Planning plant
153 PRBME VBAP PRBME   PRBME Base unit of measure for product group
154 UMREF VBAP UMREF   UMREFF Conversion factor: quantities
155 KNTTP VBAP KNTTP   KNTTP Account assignment category
156 KZVBR VBAP KZVBR   KZVBR Consumption posting
157 SERNR VBAP SERNR   SERNR BOM explosion number
158 OBJNR VBAP OBJNR   OBJPO Object number at item level
159 ABGRS VBAP ABGRS   ABGR_SCHL Results Analysis Key
160 BEDAE VBAP BEDAE   BEDAE Requirements type
161 CMPRE VBAP CMPRE   CMPRE Item credit price
162 CMTFG VBAP CMTFG   CMTFG ID for partial release of order item, credit block
163 CMPNT VBAP CMPNT   CMPNT ID: Item with active credit function / relevant for credit
164 CMKUA VBAP CMKUA   CMKUA Credit data exchange rate for requested delivery date
165 CUOBJ VBAP CUOBJ   CUOBJ_VA Configuration
166 CUOBJ_CH VBAP CUOBJ_CH   CUOBJ_CH Internal object number of the batch classification
167 CEPOK VBAP CEPOK   CEPOK Status expected price
168 KOUPD VBAP KOUPD   KOUPD Condition update
169 SERAIL VBAP SERAIL   SERAIL Serial Number Profile
170 ANZSN VBAP ANZSN   ANZSN Number of serial numbers
171 NACHL VBAP NACHL   NACHL Customer has not posted goods receipt
172 MAGRV VBAP MAGRV   MAGRV Material Group: Packaging Materials
173 MPROK VBAP MPROK   MPROK Status manual price change
174 VGTYP VBAP VGTYP   VBTYP_V Document category of preceding SD document
175 PROSA VBAP PROSA   PROSA ID for material selection - active
176 UEPVW VBAP UEPVW   UEPVW ID for higher-level item usage
177 KALNR VBAP KALNR   CK_KALNR Cost Estimate Number for Cost Est. w/o Qty Structure
178 KLVAR VBAP KLVAR   CK_KLVAR Costing Variant
179 SPOSN VBAP SPOSN   SPOSN BOM Item Number
180 KOWRR VBAP KOWRR   KOWRR Statistical values
181 STADAT VBAP STADAT   STADAT Statistics date
182 EXART VBAP EXART   EXART Business Transaction Type for Foreign Trade
183 PREFE VBAP PREFE   PREFE Preference indicator in export/import
184 KNUMH VBAP KNUMH   KNUMH_CH Number of condition record from batch determination
185 CLINT VBAP CLINT   CLINT Internal Class Number
186 CHMVS VBAP CHMVS   CHMVS Batches: Exit to quantity proposal
187 STLTY VBAP STLTY   STLTY BOM Category
188 STLKN VBAP STLKN   STLKN BOM Item Node Number
189 STPOZ VBAP STPOZ   CIM_COUNT Internal counter
190 STMAN VBAP STMAN   CUINK Inconsistent configuration
191 ZSCHL_K VBAP ZSCHL_K   AUFZSCHL Overhead key
192 KALSM_K VBAP KALSM_K   AUFKALSM Costing Sheet
193 KALVAR VBAP KALVAR   CK_KLVAR Costing Variant
194 KOSCH VBAP KOSCH   KOSCH Product allocation determination procedure
195 UPMAT VBAP UPMAT   UPMAT Pricing reference material of main item
196 UKONM VBAP UKONM   UKONM Material pricing group of main item
197 MFRGR VBAP MFRGR   MFRGR Material freight group
198 PLAVO VBAP PLAVO   PLAVO Planning Release Regulation
199 KANNR VBAP KANNR   KANNR KANBAN/sequence number
200 CMPRE_FLT VBAP CMPRE_FLT   CMPRE_FLT Item credit price
201 ABFOR VBAP ABFOR   ABSFORM_CM Form of payment guarantee
202 ABGES VBAP ABGES   ABGES_CM Guaranteed (factor between 0 and 1)
203 J_1BCFOP VBAP J_1BCFOP   J_1BCFOP CFOP code and extension
204 J_1BTAXLW1 VBAP J_1BTAXLW1   J_1BTAXLW1 Tax law: ICMS
205 J_1BTAXLW2 VBAP J_1BTAXLW2   J_1BTAXLW2 Tax law: IPI
206 J_1BTXSDC VBAP J_1BTXSDC   J_1BTXSDC_ SD tax code
207 WKTNR VBAP WKTNR   WKTNR Value contract no.
208 WKTPS VBAP WKTPS   WKTPS Value contract item
209 SKOPF VBAP SKOPF   W_SORTK Assortment Module
210 KZBWS VBAP KZBWS   KZBWS Valuation of Special Stock
211 WGRU1 VBAP WGRU1   WGRU_HIE1 Material group hierarchy 1
212 WGRU2 VBAP WGRU2   WGRU_HIE2 Material group hierarchy 2
213 KNUMA_PI VBAP KNUMA_PI   KNUMA_PI Promotion
214 KNUMA_AG VBAP KNUMA_AG   KNUMA_AG Sales deal
215 KZFME VBAP KZFME   KZFME ID: Leading unit of measure for completing a transaction
216 LSTANR VBAP LSTANR   LSTANR Free goods delivery control
217 TECHS VBAP TECHS   TECHS Parameter Variant/Standard Variant
218 MWSBP VBAP MWSBP   MWSBP Tax amount in document currency
219 BERID VBAP BERID   BERID MRP Area
220 PCTRF VBAP PCTRF   PCTRF Profit Center for Billing
221 LOGSYS_EXT VBAP LOGSYS_EXT   LOGSYS Logical system
222 J_1BTAXLW3 VBAP J_1BTAXLW3   J_1BTAXLW3 Tax law: ISS
223 J_1BTAXLW4 VBAP J_1BTAXLW4   J_1BTAXLW4 COFINS Tax Law
224 J_1BTAXLW5 VBAP J_1BTAXLW5   J_1BTAXLW5 PIS Tax Law
225 STOCKLOC VBAP STOCKLOC   STOCKLOC First Inventory-Managing Location
226 SLOCTYPE VBAP SLOCTYPE   SLOCTYPE Type of First Inventory-Managing Location
227 MSR_RET_REASON VBAP MSR_RET_REASON   MSR_RETURNS_REASON Return Reason
228 MSR_REFUND_CODE VBAP MSR_REFUND_CODE   MSR_RETURNS_REFUND_CODE Returns Refund Code
229 MSR_APPROV_BLOCK VBAP MSR_APPROV_BLOCK   MSR_APPROVAL_BLOCK Approval Block
230 NRAB_KNUMH VBAP NRAB_KNUMH   KNUMH Condition record number
231 TRMRISK_RELEVANT VBAP TRMRISK_RELEVANT   SLS_TRM_RISK_RELEVANCY Risk Relevancy in Sales
232 IUID_RELEVANT VBAP IUID_RELEVANT   IUID_RELEVANT_CUST IUID Relevant for Customer
233 PRS_OBJNR VBAP PRS_OBJNR   PRS_OBJNR Engagement mgmt: Object number
234 PRS_SD_SPSNR VBAP PRS_SD_SPSNR   PRS_SD_SPSNR Standard WBS Element for Project Inception via SD
235 PRS_WORK_PERIOD VBAP PRS_WORK_PERIOD   PRS_WORK_PERIOD Work Period (Internal Representation)
236 PARGB VBAP PARGB   PARGB Trading partner's business area
237 AUFPL_OAA VBAP AUFPL_OAA   CO_AUFPL Routing number of operations in the order
238 APLZL_OAA VBAP APLZL_OAA   CIM_COUNT Internal counter
239 WAERK_VBAK VBAK WAERK   WAERK SD document currency
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20140121 
SAP Release Created in 616