SAP ABAP View V_CM08_OPT (Selection VBUK, VBAK, VBEP)

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_CM08_OPT
Short Description	Selection VBUK, VBAK, VBEP
Root table	VBUK	Sales Document: Header Status and Administrative Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	VBUK	VBUK
2	VBAK
3	VBEP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	VBUK	MANDT	JL	EQ				0	0
2	VBAK	MANDT	JR	EQ			AND	0	0
3	VBUK	VBELN	JL	EQ				0	0
4	VBAK	VBELN	JR	EQ			AND	0	0
5	VBUK	MANDT	JL	EQ				0	0
6	VBEP	MANDT	JR	EQ			AND	0	0
7	VBUK	VBELN	JL	EQ				0	0
8	VBEP	VBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	VBUK	MANDT		☐	MANDT	☐	Client
2	VBELN	VBUK	VBELN		☐	VBELN	☐	Sales and Distribution Document Number
3	GBSTK	VBUK	GBSTK		☐	GBSTK	☐	Overall processing status of document
4	VBOBJ	VBUK	VBOBJ		☐	VBOBJ	☐	SD document object
5	CMGST	VBUK	CMGST		☐	CMGST	☐	Overall status of credit checks
6	ERNAM	VBAK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
7	VKORG	VBAK	VKORG		☐	VKORG	☐	Sales Organization
8	VTWEG	VBAK	VTWEG		☐	VTWEG	☐	Distribution Channel
9	SPART	VBAK	SPART		☐	SPART	☐	Division
10	VKGRP	VBAK	VKGRP		☐	VKGRP	☐	Sales group
11	VKBUR	VBAK	VKBUR		☐	VKBUR	☐	Sales office
12	KKBER	VBAK	KKBER		☐	KKBER	☐	Credit control area
13	KNKLI	VBAK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
14	GRUPP	VBAK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
15	SBGRP	VBAK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
16	CTLPC	VBAK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
17	CMNUP	VBAK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
18	CMNGV	VBAK	CMNGV		☐	CMNGV	☐	Next date
19	RPLNR	VBAK	RPLNR		☐	RPLNR	☐	Installment Plan Number
20	POSNR	VBEP	POSNR		☐	POSNR_VA	☐	Sales Document Item
21	ETENR	VBEP	ETENR		☐	ETENR	☐	Schedule line
22	ETTYP	VBEP	ETTYP		☐	ETTYP	☐	Item Cat. in Schedule Line
23	LFREL	VBEP	LFREL		☐	LFREL	☐	Item is Relevant for Delivery
24	EDATU	VBEP	EDATU		☐	EDATU	☐	Schedule line date
25	EZEIT	VBEP	EZEIT		☐	EZEIT_VBEP	☐	Arrival time
26	WMENG	VBEP	WMENG		☐	WMENG	☐	Order quantity in sales units
27	BMENG	VBEP	BMENG		☐	BMENG	☐	Confirmed quantity
28	VRKME	VBEP	VRKME		☐	VRKME	☐	Sales unit
29	LMENG	VBEP	LMENG		☐	LMENG	☐	Required quantity for mat.management in stockkeeping units
30	MEINS	VBEP	MEINS		☐	MEINS	☐	Base Unit of Measure
31	BDDAT	VBEP	BDDAT		☐	BDDAT	☐	Requirement date (deadline for procurement)
32	BDART	VBEP	BDART		☐	BDART	☐	Requirement type
33	PLART	VBEP	PLART		☐	PLART	☐	Planning type
34	VBELE	VBEP	VBELE		☐	VBELE	☐	Business document number
35	POSNE	VBEP	POSNE		☐	POSNE	☐	Business item number
36	ETENE	VBEP	ETENE		☐	ETENE	☐	Schedule line
37	RSDAT	VBEP	RSDAT		☐	RSDAT	☐	Earliest possible reservation date
38	IDNNR	VBEP	IDNNR		☐	IDNNR	☐	Maintenance request
39	BANFN	VBEP	BANFN		☐	BANFN	☐	Purchase requisition number
40	BSART	VBEP	BSART		☐	BSART	☐	Order Type (Purchasing)
41	BSTYP	VBEP	BSTYP		☐	BSTYP	☐	Purchasing document category
42	WEPOS	VBEP	WEPOS		☐	WEPOS_A	☐	Confirmation status of schedule line (incl.ALE)
43	REPOS	VBEP	REPOS		☐	REPOS	☐	Invoice receipt indicator
44	LRGDT	VBEP	LRGDT		☐	LRGDT	☐	Return date for returnable packaging
45	PRGRS	VBEP	PRGRS		☐	PRGRS	☐	Date type (day, week, month, interval)
46	TDDAT	VBEP	TDDAT		☐	TDDAT_D	☐	Transportation Planning Date
47	MBDAT	VBEP	MBDAT		☐	MBDAT	☐	Material Staging/Availability Date
48	LDDAT	VBEP	LDDAT		☐	LDDAT	☐	Loading Date
49	WADAT	VBEP	WADAT		☐	WADAT	☐	Goods Issue Date
50	CMENG	VBEP	CMENG		☐	CMENG	☐	Corrected quantity in sales unit
51	LIFSP	VBEP	LIFSP		☐	LIFSP_EP	☐	Schedule line blocked for delivery
52	GRSTR	VBEP	GRSTR		☐	GRSTR	☐	Group definition for structure data
53	ABART	VBEP	ABART		☐	ABART	☐	Release type
54	ABRUF	VBEP	ABRUF		☐	ABRUF	☐	Forecast Delivery schedule number
55	ROMS1	VBEP	ROMS1		☐	DCQNT	☐	Committed quantity
56	ROMS2	VBEP	ROMS2		☐	ROMS2	☐	Size 2
57	ROMS3	VBEP	ROMS3		☐	ROMS3	☐	Size 3
58	ROMEI	VBEP	ROMEI		☐	ROMEI	☐	Unit of measure for sizes 1 to 3
59	RFORM	VBEP	RFORM		☐	RFORM	☐	Formula Key
60	UMVKZ	VBEP	UMVKZ		☐	UMVKZ	☐	Numerator (factor) for conversion of sales quantity into SKU
61	UMVKN	VBEP	UMVKN		☐	UMVKN	☐	Denominator (divisor) for conversion of sales qty. into SKU
62	VERFP	VBEP	VERFP		☐	VERFP_MAS	☐	Availability confirmed automatically
63	BWART	VBEP	BWART		☐	BWART	☐	Movement type (inventory management)
64	BNFPO	VBEP	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
65	ETART	VBEP	ETART		☐	EDI_ETTYP	☐	Schedule line type EDI
66	AUFNR	VBEP	AUFNR		☐	AUFNR	☐	Order Number
67	PLNUM	VBEP	PLNUM		☐	PLNUM	☐	Planned order number
68	SERNR	VBEP	SERNR		☐	SERNR	☐	BOM explosion number
69	AESKD	VBEP	AESKD		☐	AESKD	☐	Customer Engineering Change Status
70	ABGES	VBEP	ABGES		☐	ABGES_CM	☐	Guaranteed (factor between 0 and 1)
71	MBUHR	VBEP	MBUHR		☐	MBUHR	☐	Material Staging Time (Local, Relating to a Plant)
72	TDUHR	VBEP	TDUHR		☐	TDUHR	☐	Transp. Planning Time (Local, Relating to a Shipping Point)
73	LDUHR	VBEP	LDUHR		☐	LDUHR	☐	Loading Time (Local Time Relating to a Shipping Point)
74	WAUHR	VBEP	WAUHR		☐	WAUHR	☐	Time of Goods Issue (Local, Relating to a Plant)
75	AULWE	VBEP	AULWE		☐	AULWE	☐	Route Schedule
76	MBDAT_DRS	VBEP	MBDAT_DRS		☐	MBDAT_DRS	☐	Material Availability Date Third-Party Order Planning

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	20131127
SAP Release Created in	616