SAP ABAP Table V_CM09_OPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_CM09_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	GBSTK	☑	GBSTK	STATV	CHAR	1	0	Overall processing status of document
3	CMGST	☑	CMGST	CMGST	CHAR	1	0	Overall status of credit checks
4	VBOBJ	☑	VBOBJ	VBOBJ	CHAR	1	0	SD document object
5	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
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	POSNR	NUMC	6	0	Item number of the SD document	VBUP
21	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
22	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
23	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
24	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type	T189
25	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
26	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
27	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
28	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
29	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)	TFACD
30	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
31	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
32	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
33	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
34	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
35	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
36	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer	TVKT
37	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
38	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
39	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
40	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
41	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
42	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
43	STCUR	☐	STCUR	KURRF	DEC	9	5	Exchange rate for statistics
44	MSCHL	☐	MSCHL	MSCHL	CHAR	1	0	Dunning key	T040
45	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	T040S
46	FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	FPLA
47	WAKTION	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
48	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure	T691M
49	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
50	J_1AFITP	☐	J_1AFITP_D	J_1AFITP	CHAR	2	0	Tax type	J_1AFITP
51	J_1ARFZ	☐	J_1ARFZVAT	J_1ARFZVAT	CHAR	1	0	Reason for zero VAT	J_1ARFZ
52	J_1AREGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
53	J_1AGICD	☐	J_1AGICD_D	J_1AGICD2	CHAR	2	0	Activity Code for Gross Income Tax	J_1AGICD
54	J_1ADTYP	☐	J_1ADTYP_D	J_1ADTYP	CHAR	2	0	Distribution Type for Employment Tax	J_1ADTYP
55	J_1ATXREL	☐	J_1ATXREL_	J_1ATXREL	CHAR	10	0	Tax relevant classification	J_1ATXREL
56	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
57	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
58	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
59	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
60	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type	T176
61	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
62	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
63	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
64	BSARK_E	☐	BSARK_E	BSARK	CHAR	4	0	Ship-to party purchase order type	T176
65	IHREZ_E	☐	IHREZ_E	TEXT12	CHAR	12	0	Ship-to party character
66	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
67	KURSK_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
68	KURRF_DAT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
69	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
70	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
71	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
72	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
73	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
74	WKWAE	☐	WKWAE	WAERS	CUKY	5	0	Value contract currency	TCURC
75	WKKUR	☐	WKKUR	KURRF	DEC	9	5	Exchange rate in value contract currency
76	AKWAE	☐	AKWAE	WAERS	CUKY	5	0	Currency key for letter-of-credit procg in foreign trade	TCURC
77	AKKUR	☐	AKKUR	KURRF	DEC	9	5	Exchange rate for letter-of-credit procg in foreign trade
78	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
79	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
80	J_1AIDATEP	☐	J_1AIDATES	J_1AUDATEP	DATS	8	0	Indexing base date
81	BSTKD_M	☐	BSTKD_M	CHAR35	CHAR	35	0	Customer PO number as matchcode field
82	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time	TVDC
83	FFPRF	☐	AD01PROFNR	AD01PROFNR	CHAR	8	0	Dynamic Item Processor Profile	AD01C_PROF
84	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
85	FAKTF	☐	FAKTF	FAKTF	CHAR	2	0	Billing Form
86	RRREL	☐	RR_RELTYP	RR_RELTYP	CHAR	1	0	Revenue recognition category
87	ACDATV	☐	RR_ACDATV	RR_ACDATV	CHAR	1	0	Proposed start date for accrual period
88	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
89	TRATY	☐	TRATY	TRATY	CHAR	4	0	Means-of-Transport Type	TVTY
90	TRMTYP	☐	TRMTYP	MATNR	CHAR	18	0	Means of Transportation	MARA
91	SDABW	☐	SDABW	SDABW	CHAR	4	0	Special Processing Indicator	TVSAK
92	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
93	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	TFKB
94	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
95	CAMPAIGN	☐	CGPL_GUID16_R3	SYSUUID	RAW	16	0	Generic project planning: GUID from external R/3 system
96	VKONT	☐	CORR_VKONT_KK	CORR_VKONT_KK	CHAR	12	0	Contract Account Number
97	DPBP_REF_FPLNR	☐	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number
98	DPBP_REF_FPLTR	☐	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards
99	REVSP	☐	RR_REVSP	RR_REVSP	CHAR	1	0	Revenue Distribution Type
100	REVEVTYP	☐	RR_REVEVTYP_CUST	RR_REVEVTYP_CUST	CHAR	1	0	Revenue Event Type (Customizing)
101	VTREF	☐	CORR_VTREF_KK	CORR_VTREF_KK	CHAR	20	0	Reference Specifications from Contract
102	PEROP_BEG	☐	FM_PEROP_SD_LOW	DATUM	DATS	8	0	Period of Performance Start Date
103	PEROP_END	☐	FM_PEROP_SD_HIGH	DATUM	DATS	8	0	Period of Performance End Date
104	STCODE	☐	J_1ISTCODE	J_1ISTCODE	CHAR	3	0	LST CST applicability code
105	FORMC1	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type
106	FORMC2	☐	J_1IFORTYP	J_1IFORTYP	CHAR	3	0	Form Type
107	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade
108	COMPREAS	☐	CMP_COMPREAS_COPY	CMP_COMPREAS_COPY	CHAR	4	0	Abbreviation for Complaints Reason

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_CM09_OPT	ABSSC	T691M	ABSSC	REF	C	CN
2	V_CM09_OPT	ABTNR	TSAB	ABTNR	REF	1	CN
3	V_CM09_OPT	AKWAE	TCURC	WAERS	REF	1	CN
4	V_CM09_OPT	BEMOT	TBMOT	BEMOT	REF	1	CN
5	V_CM09_OPT	BSARK	T176	BSARK	REF	C	CN
6	V_CM09_OPT	BSARK_E	T176	BSARK		C	CN
7	V_CM09_OPT	BZIRK	T171	BZIRK	REF	C	CN
8	V_CM09_OPT	CTLPC	T691A	CTLPC	REF	C	CN
9	V_CM09_OPT	DELCO	TVDC	DELCO	KEY	1	CN
10	V_CM09_OPT	FFPRF	AD01C_PROF	PROFNR		1	CN
11	V_CM09_OPT	FKBER	TFKB	FKBER
12	V_CM09_OPT	FPLNR	FPLA	FPLNR	REF	C	CN
13	V_CM09_OPT	INCO1	TINC	INCO1	REF	C	CN
14	V_CM09_OPT	J_1ADTYP	J_1ADTYP	J_1ADTYP		1	CN
15	V_CM09_OPT	J_1AFITP	J_1AFITP	J_1AFITP		1	CN
16	V_CM09_OPT	J_1AGICD	J_1AGICD	J_1AGICD		1	CN
17	V_CM09_OPT	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
18	V_CM09_OPT	J_1AREGIO	T005S	BLAND		1	CN
19	V_CM09_OPT	J_1ARFZ	J_1ARFZ	J_1ARFZ		1	CN
20	V_CM09_OPT	J_1ATXREL	J_1ATXREL	J_1ATXREL		1	CN
21	V_CM09_OPT	KDGRP	T151	KDGRP	REF	C	CN
22	V_CM09_OPT	KDKG1	TVKGG	KDKGR		C	CN
23	V_CM09_OPT	KDKG2	TVKGG	KDKGR		C	CN
24	V_CM09_OPT	KDKG3	TVKGG	KDKGR		C	CN
25	V_CM09_OPT	KDKG4	TVKGG	KDKGR		C	CN
26	V_CM09_OPT	KDKG5	TVKGG	KDKGR		C	CN
27	V_CM09_OPT	KKBER	T014	KKBER	REF	C	CN
28	V_CM09_OPT	KNKLI	KNA1	KUNNR	REF	C	CN
29	V_CM09_OPT	KONDA	T188	KONDA	REF	C	CN
30	V_CM09_OPT	KTGRD	TVKT	KTGRD	REF	C	CN
31	V_CM09_OPT	LCNUM	AKKP	LCNUM		C	CN
32	V_CM09_OPT	MANDT	T000	MANDT	KEY	1	CN
33	V_CM09_OPT	MANSP	T040S	MANSP	REF	C	CN
34	V_CM09_OPT	MSCHL	T040	MSCHL	REF	C	CN
35	V_CM09_OPT	PERFK	TFACD	IDENT	REF	C	CN
36	V_CM09_OPT	PERRL	TFACD	IDENT	REF	C	CN
37	V_CM09_OPT	PLTYP	T189	PLTYP	REF	C	CN
38	V_CM09_OPT	POSNR	VBUP	POSNR	KEY	1	CN
39	V_CM09_OPT	RPLNR	FPLA	FPLNR	REF	C	1
40	V_CM09_OPT	SBGRP	T024B	SBGRP	REF	C	CN
41	V_CM09_OPT	SDABW	TVSAK	SDABW	KEY	1	CN
42	V_CM09_OPT	SPART	TVTA	SPART	REF	1	CN
43	V_CM09_OPT	TRATY	TVTY	TRATY	KEY	1	CN
44	V_CM09_OPT	TRMTYP	MARA	MATNR	KEY	1	CN
45	V_CM09_OPT	VBELN	VBUK	VBELN	KEY	1	C
46	V_CM09_OPT	VKBUR	TVKBZ	VKBUR	REF	C	CN
47	V_CM09_OPT	VKGRP	TVBVK	VKGRP	REF	C	CN
48	V_CM09_OPT	VKORG	TVKO	VKORG	REF	1	CN
49	V_CM09_OPT	VSART	T173	VSART	KEY	1	CN
50	V_CM09_OPT	VTWEG	TVKOV	VTWEG	REF	1	CN
51	V_CM09_OPT	WAKTION	WAKH	AKTNR	REF	1	CN
52	V_CM09_OPT	WKWAE	TCURC	WAERS		1	CN
53	V_CM09_OPT	WMINR	WWMI	WMINR	REF	1	CN
54	V_CM09_OPT	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in