SAP ABAP Table V_CM08_OPT (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CM08_OPT	AUFNR	AUFK	AUFNR
2	V_CM08_OPT	AULWE	VALW	AULWE
3	V_CM08_OPT	BNFPO	EBAN	BNFPO	REF	C	CN
4	V_CM08_OPT	BSART	T161	BSART	REF	C	CN
5	V_CM08_OPT	BWART	T156	BWART	REF	C	CN
6	V_CM08_OPT	CTLPC	T691A	CTLPC	REF	C	CN
7	V_CM08_OPT	ETART	TVET	ETART	REF	C	CN
8	V_CM08_OPT	ETENE	VBEP	ETENR	REF	C	CN
9	V_CM08_OPT	ETTYP	TVEP	ETTYP	REF	1	CN
10	V_CM08_OPT	KKBER	T014	KKBER	REF	C	CN
11	V_CM08_OPT	KNKLI	KNA1	KUNNR	REF	C	CN
12	V_CM08_OPT	LIFSP	TVLS	LIFSP	REF	C	CN
13	V_CM08_OPT	MANDT	T000	MANDT	KEY	1	CN
14	V_CM08_OPT	MEINS	T006	MSEHI	REF	C	CN
15	V_CM08_OPT	PLNUM	PLAF	PLNUM
16	V_CM08_OPT	POSNE	VBUP	POSNR	REF	C	CN
17	V_CM08_OPT	POSNR	VBUP	POSNR	KEY	1	CN
18	V_CM08_OPT	ROMEI	T006	MSEHI	REF	C	CN
19	V_CM08_OPT	RPLNR	FPLA	FPLNR	REF	C	1
20	V_CM08_OPT	SBGRP	T024B	SBGRP	REF	C	CN
21	V_CM08_OPT	SERNR	SNUM	SERNR	REF	C	CN
22	V_CM08_OPT	SPART	TVTA	SPART	REF	1	CN
23	V_CM08_OPT	VBELE	VBUK	VBELN	REF	C	CN
24	V_CM08_OPT	VKBUR	TVKBZ	VKBUR	REF	C	CN
25	V_CM08_OPT	VKGRP	TVBVK	VKGRP	REF	C	CN
26	V_CM08_OPT	VKORG	TVKO	VKORG	REF	1	CN
27	V_CM08_OPT	VRKME	T006	MSEHI	REF	C	CN
28	V_CM08_OPT	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in