SAP ABAP Table ROXAVV0042 (Generated Table for View /BEV3/CHVBW_CTR1)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ BVCH_DSOURCE (Package) Contract Handling - Data Sources

Basic Data

Table Category	INTTAB	Structure
Structure	ROXAVV0042	Table Relationship Diagram
Short Description	Generated Table for View /BEV3/CHVBW_CTR1

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	*
2	YVWDNR	☑	/BEV3/CHDTWDNR	/BEV3/CHDOWDNR	NUMC	13	0	CHD Contract Number
3	DATETO	☑	DATBI	DATUM	DATS	8	0	Valid To Date
4	DATEFROM	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
5	CHORG	☐	/BEV3/CHOE	/BEV3/CHDOVORGE	NUMC	4	0	CH Organizational Unit	/BEV3/CHTBVORGE
6	VWDART	☐	/BEV3/CHDTVWDART	/BEV3/CHDOVWDART	NUMC	4	0	Contract Handling Document Type	/BEV3/CHTVWDART
7	MUSTER	☐	/BEV3/CHMUSTER	/BEV3/CHTXT01	CHAR	1	0	Model Indicator
8	CTR_BUKRS	☐	/BEV3/CHCTR_BUKRS	BUKRS	CHAR	4	0	CH: Contract Company Code	T001
9	CTR_VIEW	☐	/BEV3/CHERTSI	/BEV3/CHERTSI	CHAR	1	0	Contract view
10	CLASS1	☐	/BEV3/CHCTR_CLASS1	/BEV3/CHKLASS	NUMC	5	0	CH: Classification 1 for Contract	/BEV3/CHCTKLAS1
11	CLASS2	☐	/BEV3/CHCTR_CLASS2	/BEV3/CHKLASS	NUMC	5	0	CH: Classification 2 for Contract	/BEV3/CHCTKLAS2
12	CLASS3	☐	/BEV3/CHCTR_CLASS3	/BEV3/CHKLASS	NUMC	5	0	CH: Classification 3 for Contract	/BEV3/CHCTKLAS3
13	CLASS4	☐	/BEV3/CHCTR_CLASS4	/BEV3/CHKLASS	NUMC	5	0	CH: Classification 4 for Contract	/BEV3/CHCTKLAS4
14	CLASS5	☐	/BEV3/CHCTR_CLASS5	/BEV3/CHKLASS	NUMC	5	0	CH: Classification 5 for Contract	/BEV3/CHCTKLAS5
15	LANGU_ORIGINAL	☐	/BEV3/CHCTR_LANGU_ORIGINAL	SPRAS	LANG	1	0	CH: Original Language of Contract	T002
16	OLD_CONTRACT	☐	/BEV3/CHWDNRALT	/BEV3/CHWDNRALT	CHAR	18	0	CHD number from existing system or reference number
17	PERIOD_FROM	☐	/BEV3/CHCTR_PERIOD_FROM		DATS	8	0	CH: Start of Contract
18	PERIOD_TO	☐	/BEV3/CHCTR_PERIOD_TO		DATS	8	0	CH: End of Contract
19	FLAG_PERIODEND	☐	/BEV3/CHFLAG_PERIODEND	/BEV3/CHANKREUZ	CHAR	1	0	CH: Flag Fixed-Term Contract
20	CTR_CURRENCY	☐	/BEV3/CHCTR_CURRENCY	WAERS	CUKY	5	0	CH: Contract Currency	TCURC
21	CTR_ACC_PARTY	☐	/BEV3/CHCTR_PARTY_R	KUNNR	CHAR	10	0	Ch: Contract Partner (Contractee)	*
22	VKORG_RG	☐	/BEV3/CHKORG_RG	VKORG	CHAR	4	0	Post Sales Organzation	TVKO
23	VTWEG_RG	☐	/BEV3/CHTWEG_RG	VTWEG	CHAR	2	0	Distribution Channel Post	TVTW
24	SPART_RG	☐	/BEV3/CHSPART_RG	SPART	CHAR	2	0	Division Post	TSPA
25	CTR_OBJECT	☐	/BEV3/CH_OBJECT	KUNNR	CHAR	10	0	CH: Object Number (Sales Outlet)	*
26	VKORG_WE	☐	/BEV3/CHKORG_WE	VKORG	CHAR	4	0	Sales Organization Performance	TVKO
27	VTWEG_WE	☐	/BEV3/CHTWEG_WE	VTWEG	CHAR	2	0	Distribution Channel Performance	TVTW
28	SPART_WE	☐	/BEV3/CHSPART_WE	SPART	CHAR	2	0	Division Performance	TSPA
29	DEBITOR	☐	/BEV3/CHKUNNR_FI	KUNNR	CHAR	10	0	Customer	*
30	BUKRS_DEBITOR	☐	/BEV3/CHBUKRS	BUKRS	CHAR	4	0	Company Code	T001
31	WHOLESALER1	☐	/BEV3/CHKUNVE	KUNNR	CHAR	10	0	Distributor	*
32	WHOLESALER2	☐	/BEV3/CHKUNVE	KUNNR	CHAR	10	0	Distributor	*
33	WHOLESALER3	☐	/BEV3/CHKUNVE	KUNNR	CHAR	10	0	Distributor	*
34	DEPEND_CTR1	☐	/BEV3/CHWDNR_ABW	/BEV3/CHDOWDNR	NUMC	13	0	Deviating contract number
35	DEPEND_CTR2	☐	/BEV3/CHWDNR_ABW	/BEV3/CHDOWDNR	NUMC	13	0	Deviating contract number
36	DEPEND_CTR3	☐	/BEV3/CHWDNR_ABW	/BEV3/CHDOWDNR	NUMC	13	0	Deviating contract number
37	DEPEND_CTR4	☐	/BEV3/CHWDNR_ABW	/BEV3/CHDOWDNR	NUMC	13	0	Deviating contract number
38	AUS_DATE_FROM	☐	/BEV3/CHAUS_DATE_FROM		DATS	8	0	CH: Suspension From-Date
39	AUS_DATE_TO	☐	/BEV3/CHAUS_DATE_TO		DATS	8	0	CH: Suspension To Date
40	AUS_PERIOD_MON	☐	/BEV3/CHAUS_PERIOD_MONTH	/BEV3/CHMONTH	NUMC	3	0	CH: Suspension Period in Months
41	AUS_COUNT	☐	/BEV3/CHAUS_COUNT		NUMC	3	0	CH: Number of Suspensions
42	AUS_FLAG_PERIOD	☐	/BEV3/CHAUS_FLAG	/BEV3/CHANKREUZ	CHAR	1	0	CH: Periodic Suspension Flag
43	OPT_NEXT_DATE	☐	/BEV3/CHOPTION_DATE		DATS	8	0	CH: Option Date
44	OPT_PERIOD_MON	☐	/BEV3/CHOPT_PERIOD_MONTH	/BEV3/CHMONTH	NUMC	3	0	CH: Option Period in Months
45	OPT_COUNT	☐	/BEV3/CHOPT_COUNT		NUMC	3	0	CH: Number of Options
46	PROLONG_PERIOD	☐	/BEV3/CHPROLONG_PERIOD_MONTH	/BEV3/CHMONTH	NUMC	3	0	CH: Prolongation Period in Months
47	NOTICE_DATE	☐	/BEV3/CHNOTICE_DATE		DATS	8	0	CH: Notice Date
48	NOTICE_TO_DATE	☐	/BEV3/CHNOTICE_TO_DATE		DATS	8	0	CH: Contract Termination Date:
49	NOTICE_PER_MON	☐	/BEV3/CHNOTICE_PERIOD_MONTH	/BEV3/CHMONTH	NUMC	3	0	CH: Notice Period in Months
50	NOTICE_PERIOD	☐	/BEV3/CHNOTICE_PERIOD	/BEV3/CHMONTH	NUMC	3	0	CH: Notice Period
51	SEC_COUNT	☐	/BEV3/CHSECURITY_COUNT		NUMC	3	0	CH: Number of Collaterals
52	SEC_GRDPFD	☐	/BEV3/CHSECURITY_FLAG_GRDPFD	/BEV3/CHANKREUZ	CHAR	1	0	CH: Flag Mortgage Collateral
53	SEC_IMPORTANT	☐	/BEV3/CHSECURITY_FLAG	/BEV3/CHANKREUZ	CHAR	1	0	CH: Flag Important Collateral
54	REC_TIMESTAMP	☐	/BEV3/CHTIMESTAMP	TIMESTAMP	CHAR	14	0	CH: Time Stamp

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXAVV0042	BUKRS_DEBITOR	T001	BUKRS		1	CN
2	ROXAVV0042	CHORG	/BEV3/CHTBVORGE	YVORGE	KEY	1	1
3	ROXAVV0042	CLASS1	/BEV3/CHCTKLAS1	KLASS1	KEY	1	N
4	ROXAVV0042	CLASS2	/BEV3/CHCTKLAS2	KLASS2	KEY	1	N
5	ROXAVV0042	CLASS3	/BEV3/CHCTKLAS3	KLASS3	KEY	1	N
6	ROXAVV0042	CLASS4	/BEV3/CHCTKLAS4	KLASS4	KEY	1	N
7	ROXAVV0042	CLASS5	/BEV3/CHCTKLAS5	KLASS5	KEY	1	N
8	ROXAVV0042	CTR_BUKRS	T001	BUKRS	KEY	1	N
9	ROXAVV0042	CTR_CURRENCY	TCURC	WAERS		1	CN
10	ROXAVV0042	LANGU_ORIGINAL	T002	SPRAS	KEY	1	N
11	ROXAVV0042	SPART_RG	TSPA	SPART		1	CN
12	ROXAVV0042	SPART_WE	TSPA	SPART		1	CN
13	ROXAVV0042	VKORG_RG	TVKO	VKORG		1	CN
14	ROXAVV0042	VKORG_WE	TVKO	VKORG		1	CN
15	ROXAVV0042	VTWEG_RG	TVTW	VTWEG		1	CN
16	ROXAVV0042	VTWEG_WE	TVTW	VTWEG		1	CN
17	ROXAVV0042	VWDART	/BEV3/CHTVWDART	VWDART	KEY	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	461