SAP ABAP Table V_CM02_OPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CM02_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_VA	VBELN	CHAR	10	0	Sales Document	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	CMNUP	☑	CMNUP	DATUM	DATS	8	0	Date of next credit check of document
13	VKBUR	☑	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
14	VKGRP	☑	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
15	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
16	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
17	SPART	☑	SPART	SPART	CHAR	2	0	Division	TVTA
18	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
19	RPLNR	☑	RPLNR	FPLNR	CHAR	10	0	Installment Plan Number	FPLA
20	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
21	PARVW	☑	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
22	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
23	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
24	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
25	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
26	ADRNR	☐	ADRNR	ADRNR	CHAR	10	0	Address
27	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
28	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
29	ADRDA	☐	ADRDA	ADRDA	CHAR	1	0	Address indicator
30	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
31	HITYP	☐	HITYP_KH	HITYP	CHAR	1	0	Customer Hierarchy Category	THIT
32	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
33	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
34	HISTUNR	☐	HISTUNR	NUM2	NUMC	2	0	Level number within hierarchy
35	KNREF	☐	KNREF	KNREF	CHAR	30	0	Customer description of partner (plant, storage location)
36	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered
37	HZUOR	☐	HZUOR	HZUOR	NUMC	2	0	Assignment to Hierarchy
38	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
39	PARVW_FF	☐	PARTNER_FF	XFELD	CHAR	1	0	Indicator 'Further Partners in this Function' (VBPA2)
40	ADRNP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	ADRP
41	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_CM02_OPT	ADRNP	ADRP	PERSNUMBER	REF	1	CN
2	V_CM02_OPT	CTLPC	T691A	CTLPC	REF	C	CN
3	V_CM02_OPT	HITYP	THIT	HITYP	REF	C	CN
4	V_CM02_OPT	KKBER	T014	KKBER	REF	C	CN
5	V_CM02_OPT	KNKLI	KNA1	KUNNR	REF	C	CN
6	V_CM02_OPT	KUNNR	KNA1	KUNNR	REF	C	CN
7	V_CM02_OPT	LAND1	T005	LAND1	REF	C	CN
8	V_CM02_OPT	LIFNR	LFA1	LIFNR	REF	C	CN
9	V_CM02_OPT	MANDT	T000	MANDT	KEY	1	CN
10	V_CM02_OPT	PARVW	TPAR	PARVW	KEY	1	CN
11	V_CM02_OPT	POSNR	VBUP	POSNR	KEY	1	CN
12	V_CM02_OPT	RPLNR	FPLA	FPLNR	REF	C	1
13	V_CM02_OPT	SBGRP	T024B	SBGRP	REF	C	CN
14	V_CM02_OPT	SPART	TVTA	SPART	REF	1	CN
15	V_CM02_OPT	VBELN	VBUK	VBELN	KEY	1	C
16	V_CM02_OPT	VKBUR	TVKBZ	VKBUR	REF	C	CN
17	V_CM02_OPT	VKGRP	TVBVK	VKGRP	REF	C	CN
18	V_CM02_OPT	VKORG	TVKO	VKORG	REF	1	CN
19	V_CM02_OPT	VTWEG	TVKOV	VTWEG	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in