SAP ABAP Table V_CM03_OPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CM03_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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
13	VKBUR	☑	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
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	VBUP
17	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
18	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
19	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
20	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
21	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
22	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
23	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
24	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
25	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
26	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
27	HITYP	☐	HITYP_KH	HITYP	CHAR	1	0	Customer Hierarchy Category	THIT
28	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
29	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
30	HISTUNR	☐	HISTUNR	NUM2	NUMC	2	0	Level number within hierarchy
31	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
32	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
33	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
34	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
35	PARVW_FF	☐	PARTNER_FF	XFELD	CHAR	1	0	Indicator 'Further Partners in this Function' (VBPA2)
36	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
37	KALE	☐	KALE	KALE	CHAR	1	0	Maintain appointments in calendar

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CM03_OPT	ADRNP	ADRP	PERSNUMBER	REF	1	CN
2	V_CM03_OPT	CTLPC	T691A	CTLPC	REF	C	CN
3	V_CM03_OPT	HITYP	THIT	HITYP	REF	C	CN
4	V_CM03_OPT	KKBER	T014	KKBER	REF	C	CN
5	V_CM03_OPT	KNKLI	KNA1	KUNNR	REF	C	CN
6	V_CM03_OPT	KUNNR	KNA1	KUNNR	REF	C	CN
7	V_CM03_OPT	LAND1	T005	LAND1	REF	C	CN
8	V_CM03_OPT	LIFNR	LFA1	LIFNR	REF	C	CN
9	V_CM03_OPT	MANDT	T000	MANDT	KEY	1	CN
10	V_CM03_OPT	PARVW	TPAR	PARVW	KEY	1	CN
11	V_CM03_OPT	POSNR	VBUP	POSNR	KEY	1	CN
12	V_CM03_OPT	SBGRP	T024B	SBGRP	REF	C	CN
13	V_CM03_OPT	VBELN	VBUK	VBELN	KEY	1	C
14	V_CM03_OPT	VKBUR	TVBUR	VKBUR	REF	C	CN
15	V_CM03_OPT	VKORG	TVKO	VKORG	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in