SAP ABAP Table JJVCAMP_AM_TMPL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JJVCAMP_AM_TMPL	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	TEMPL_DOC	☑	ISM_TEMPL_DOC_MAM	AVM_NR	CHAR	10	0	IS-M: Template Document in Advertising Management	JHAK
3	TEMPL_ITEMNO	☑	ISM_TEMPL_ITEMNO_MAM	AVM_PNR	NUMC	3	0	IS-M: Template Document Item in Advertising Management	JHAP
4	DESCR_S	☐	ISM_CMPG_DESCR_S	TEXT20	CHAR	20	0	IS-M: CRM, Description (Short)
5	DESCR_L	☐	ISM_CMPG_DESCR_L	TEXT60	CHAR	60	0	IS-M: CRM, Description (Long)
6	TEMPL_COPY_VAR	☐	KOPIERVAR	KOPIERVAR	CHAR	4	0	IS-M: Copying Variant	TJHAKO
7	TEMPL_VALID_FROM	☐	ISM_TEMPL_VALID_FROM	DATS	DATS	8	0	IS-M: Validity Date of Template Order/Offer
8	TEMPL_VALID_TO	☐	ISM_TEMPL_VALID_TO	DATS	DATS	8	0	IS-M: Validity Date of Template Order/Offer
9	SORT_FIELD	☐	ISM_CMPG_SORTL	CHAR10	CHAR	10	0	IS-M: CRM Campaigns, Search Field for Templates
10	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TJHVBER
11	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TJHVBER
12	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TJHVBER

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJVCAMP_AM_TMPL	DISTR_CHAN	TJHVBER	VTWEG		1	CN
2	JJVCAMP_AM_TMPL	DIVISION	TJHVBER	SPART		1	CN
3	JJVCAMP_AM_TMPL	SALESORG	TJHVBER	VKORG		1	CN
4	JJVCAMP_AM_TMPL	TEMPL_COPY_VAR	TJHAKO	KOPIERVAR
5	JJVCAMP_AM_TMPL	TEMPL_DOC	JHAK	AVM_NR
6	JJVCAMP_AM_TMPL	TEMPL_ITEMNO	JHAP	POS_NR

History

Last changed by/on	SAP	20130529
SAP Release Created in