SAP ABAP Table V_CM07_OPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CM07_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_VL	VBELN	CHAR	10	0	Delivery	VBUK
3	GBSTK	☑	GBSTK	STATV	CHAR	1	0	Overall processing status of document
4	CMGST	☑	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
5	VBOBJ	☑	VBOBJ	VBOBJ	CHAR	1	0	SD document object
6	KKBER	☑	KKBER	KKBER	CHAR	4	0	Credit control area	T014
7	KNKLI	☑	KNKLI	KUNNR	CHAR	10	0	Customer's account number with credit limit reference	KNA1
8	GRUPP	☑	GRUPP_CM	GRUPP_CM	CHAR	4	0	Customer credit group
9	SBGRP	☑	SBGRP_CM	SBGRP_CM	CHAR	3	0	Credit Representative Group for Credit Management	T024B
10	CTLPC	☑	CTLPC_CM	CTLPC_CM	CHAR	3	0	Credit management: Risk category	T691A
11	CMNGV	☑	CMNGV	DATUM	DATS	8	0	Next date
12	VKBUR	☑	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
13	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
14	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
15	VBTYP	☑	VBTYP	VBTYP	CHAR	1	0	SD document category
16	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document
17	RFSTA	☐	RFSTA	STATV	CHAR	1	0	Reference status
18	RFGSA	☐	RFGSA	STATV	CHAR	1	0	Overall Status of Reference
19	BESTA	☐	BESTA	STATV	CHAR	1	0	Confirmation status of the document item
20	LFSTA	☐	LFSTA	STATV	CHAR	1	0	Delivery status
21	LFGSA	☐	LFGSA	STATV	CHAR	1	0	Overall Delivery Status of the Item
22	WBSTA	☐	WBSTA	STATV	CHAR	1	0	Goods movement status
23	FKSTA	☐	FKSTA	STATV	CHAR	1	0	Billing status of delivery-related billing documents
24	FKSAA	☐	FKSAA	STATV	CHAR	1	0	Billing Status for Order-Related Billing Documents
25	ABSTA	☐	ABSTA_VB	STATV	CHAR	1	0	Rejection status for SD item
26	GBSTA	☐	GBSTA	STATV	CHAR	1	0	Overall Processing Status of the SD Document Item
27	KOSTA	☐	KOSTA	STATV	CHAR	1	0	Picking Status/Putaway Status
28	LVSTA	☐	LVSTA	STATV	CHAR	1	0	Status of warehouse management activities
29	UVALL	☐	UVALL_UP	STATV	CHAR	1	0	General Incompletion Status of the Item
30	UVVLK	☐	UVVLK_UP	STATV	CHAR	1	0	Incompletion Status of the Item with Regard to Delivery
31	UVFAK	☐	UVFAK_UP	STATV	CHAR	1	0	Item incompletion status with respect to billing
32	UVPRS	☐	UVPRS_UP	STATV	CHAR	1	0	Item is incomplete with respect to pricing
33	FKIVP	☐	FKIVP	STATV	CHAR	1	0	Intercompany billing status
34	UVP01	☐	UVP01	STATV	CHAR	1	0	Customer reserves 1: Item status
35	UVP02	☐	UVP02	STATV	CHAR	1	0	Customer reserves 2: Item status
36	UVP03	☐	UVP03	STATV	CHAR	1	0	Item reserves 3: Item status
37	UVP04	☐	UVP04	STATV	CHAR	1	0	Item reserves 4: Item status
38	UVP05	☐	UVP05	STATV	CHAR	1	0	Customer reserves 5: Item status
39	PKSTA	☐	PKSTA	STATV	CHAR	1	0	Packing status of item
40	KOQUA	☐	KOQUA	STATV	CHAR	1	0	Confirmation status of picking/putaway
41	COSTA	☐	COSTA_D	COSTA	CHAR	1	0	Confirmation status for ALE
42	CMPPI	☐	CMPSI	CMPSZ	CHAR	1	0	Status of credit check against financial document
43	CMPPJ	☐	CMPSJ	CMPSZ	CHAR	1	0	Status of credit check against export credit insurance
44	UVPIK	☐	UVPIP_UP	STATV	CHAR	1	0	Incomplete status of item for picking/putaway
45	UVPAK	☐	UVPAP_UP	STATV	CHAR	1	0	Incomplete status of item for packaging
46	UVWAK	☐	UVWAP_UP	STATV	CHAR	1	0	Incomplete status of item regarding goods issue
47	DCSTA	☐	DCSTA	STATV	CHAR	1	0	Delay status
48	RRSTA	☐	RR_STATUS	STATV	CHAR	1	0	Revenue determination status
49	VLSTP	☐	VLSTP	STATV	CHAR	1	0	Decentralized whse processing
50	FSSTA	☐	FSSTA	STATV	CHAR	1	0	Billing block status for items
51	LSSTA	☐	LSSTA	STATV	CHAR	1	0	Delivery block status for item
52	PDSTA	☐	PDSTA	STATV	CHAR	1	0	POD status on item level
53	MANEK	☐	MANEK	MANEK	CHAR	1	0	Manual Completion of Contract
54	HDALL	☐	/SPE/INB_HDALL_ITM	XFELD	CHAR	1	0	Inbound Delivery Item Not Yet Complete (on Hold)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CM07_OPT	CTLPC	T691A	CTLPC	REF	C	CN
2	V_CM07_OPT	KKBER	T014	KKBER	REF	C	CN
3	V_CM07_OPT	KNKLI	KNA1	KUNNR	REF	C	CN
4	V_CM07_OPT	MANDT	T000	MANDT	KEY	1	CN
5	V_CM07_OPT	SBGRP	T024B	SBGRP	REF	C	CN
6	V_CM07_OPT	VBELN	VBUK	VBELN	KEY	1	C
7	V_CM07_OPT	VKBUR	TVBUR	VKBUR	REF	C	CN
8	V_CM07_OPT	VKORG	TVKO	VKORG	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in