SAP ABAP Table RJEP_BUSISM012_VIEW (IS-M - Portal: Contract Header with Requirement)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-PCT-AS (Application Component) Business Package Ad Sales
     ⤷ JASPORTAL (Package) Modules for the IS-M Reps Portal

Basic Data

Table Category	INTTAB	Structure
Structure	RJEP_BUSISM012_VIEW	Table Relationship Diagram
Short Description	IS-M - Portal: Contract Header with Requirement

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	.INCLUDE	☐				0	0	IS-M: BAPI Structure for Contract Header
2	COA_NUMBER	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
3	MEDIAMIX	☐	MM_VTNR	MM_VTNR	CHAR	10	0	IS-M: Contract Number for Media-Mix Contract	JHTMXK
4	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVTA
5	SALESORG_TEXT	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
6	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTA
7	DISTR_CHAN_TEXT	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
8	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TVTA
9	DIVISION_TEXT	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
10	CONTRACT_STATUS	☐	ABRECHK	ABRECHK	CHAR	1	0	IS-M: Settlement Type	*
11	CONTRACT_STATUS_TEXT	☐	ABRECHK_TEXT	TEXT60	CHAR	60	0	IS-M: Text for Settlement Type
12	VALIDITY_START	☐	LFZBEG	DATUM	DATS	8	0	IS-M: Start of Validity Period
13	VALIDITY_END	☐	LFZEND	DATUM	DATS	8	0	IS-M: End of Validity Period
14	TARGET_NUMBER	☐	JH_ZIELMAL	JH_ZIELMAL	DEC	5	0	IS-M/AM: Target Number in the Contract
15	TARGET_UON	☐	AB_MALEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Number in Contract	JJV006DL
16	TARGET_UON_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
17	TARGET_QUANTITY	☐	JH_ZIELMNG	ABS_MENGE	QUAN	12	3	IS-M/AM: Target Quantity in the Contract
18	TARGET_UOM	☐	AB_MNGEINH	MEINS	UNIT	3	0	IS-M/AM: Unit for Target Quantity in the Contract	JJV006
19	TARGET_UOM_ISO	☐	ISOCD_UNIT	ISOCD_UNIT	CHAR	3	0	ISO code for unit of measurement	T006I
20	TARGET_SALESVOL	☐	BAPICURR_D	BAPICURR	DEC	23	4	Currency amount in BAPI interfaces
21	TARGET_CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
22	TARGET_CURRENCY_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
23	COND_VALUE_1	☐	BAPIKBETR1	BAPICUREXT	DEC	28	9	Condition Rate
24	COND_CURRENCY_1	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
25	COND_CURRENCY_1_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
26	COND_P_UNT_1	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
27	COND_UNIT_1	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
28	CD_UNT_1_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
29	COND_VALUE_2	☐	BAPIKBETR1	BAPICUREXT	DEC	28	9	Condition Rate
30	COND_CURRENCY_2	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
31	COND_CURRENCY_2_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
32	COND_P_UNT_2	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
33	COND_UNIT_2	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
34	CD_UNT_2_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	T006I
35	.INCLUDE	☐				0	0	IS-M: BAPI Structure for Contract Requirement
36	REQ_NO	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
37	EXCLUSIVE	☐	XAUSSCHL	XFELD	CHAR	1	0	IS-M: Exclusion Requirement
38	EXCL_REQ_NO1	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
39	EXCL_REQ_NO2	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
40	COA_ITEM_NO	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	*
41	REQ_KEY	☐	ABS_BEDNR	ABS_BEDNR	CHAR	10	0	IS-M/AM: Key for a Requirement in the Contract	JHTVB
42	REQ_KEY_TEXT	☐	ABS_BEDNR_TEXT	TEXT50	CHAR	50	0	IS-M/AM: Text for Requirement Key in Contract
43	REQ_ELEMENT_NO	☐	BED_POSNR	NUM03	NUMC	3	0	IS-M: Requirement Element Number
44	QUAL_FOR_DISCOUNT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
45	QUAL_FOR_BONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
46	CNTS_TWD_DISCOUNT	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
47	CNTS_TWD_BONUS	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
48	ITEM_TYPE_AD	☐	XAVMPOS_AZ	XFELD	CHAR	1	0	IS-M: Validity for Order of the Ad Item Type
49	ITEM_TYPE_AI	☐	XAVMPOS_SI	XFELD	CHAR	1	0	IS-M: Validity for Ad Insert Order Item Type
50	ITEM_TYPE_SV	☐	XAVMPOS_DL	XFELD	CHAR	1	0	IS-M: Validity for Service Order Item Type
51	ITEM_TYPE_CM	☐	XAVMPOS_WS	XFELD	CHAR	1	0	IS-M: Validity for Commercial Order Item Type
52	ITEM_TYPE_DT	☐	XAVMPOS_VT	XFELD	CHAR	1	0	IS-M: Validity for Distribution Order Item Type
53	ITEM_TYPE_OL	☐	XAVMPOS_OL	XFELD	CHAR	1	0	IS-M: Validity for Online Item Type
54	ITEM_CATEGORY	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
55	ITEM_CATEGORY_TEXT	☐	PSTYV_PAM_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Sales Document Item Category
56	AD_FIXED_FORMAT	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
57	AD_FIXED_FORMAT_TEXT	☐	AZART_AREA_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Fixed Format Proposal / Ad Size
58	AD_SHAPE	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
59	AD_SHAPE_TEXT	☐	AZART_FORM_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Shape Ad Type
60	AD_COLOR_SCHEMA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
61	AD_COLOR_SCHEMA_TEXT	☐	AZART_FARB_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Color Scheme Ad Type
62	AD_DESIGN_TYPE	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
63	AD_DESIGN_TYPE_TEXT	☐	AZART_GEST_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Design Ad Type
64	AD_CALCULATION_TYPE	☐	AZART_RECH	AZART_RECH	CHAR	2	0	IS-M: Calculation Ad Type	TJH79
65	AD_CALCULATION_TYPE_TEXT	☐	AZART_RECH_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Calculation Ad Type
66	BUSINESS_CONTENT_COMPONENT	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
67	SPECIAL_PUBLICATION_CONT_COMP	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
68	BOOKING_UNIT	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
69	BOOKING_UNIT_TEXT	☐	BELEGEINH_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Booking Unit Text
70	PRICE_GRP	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
71	PRICE_GRP_TEXT	☐	ISM_KONDA_TEXT	TEXT20	CHAR	20	0	IS-M: Text for Customer Price Group
72	AD_INSERT_PROC_TYPE	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
73	AD_INSERT_PROC_TYPE_TEXT	☐	ISM_SINSBEARB_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Processing Type
74	AD_INSERT_CATEGORY_AI	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
75	AD_INSERT_CATEGORY_AI_TEXT	☐	SITYP_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Type
76	DELTA_COVERAGE	☐	JHRHHABD	JHRHHABD	CHAR	1	0	IS-M: Total Market Coverage Indicator
77	SELECTIVE_BOOKING_AI	☐	JHTEILBEL	JHTEILBEL	CHAR	1	0	IS-M: Selective/Full Booking Indicator
78	MIN_COVERAGE	☐	MIN_BELEG	PRZ22	DEC	4	2	IS-M: Minimum Booking in Percent
79	SERVICE_TYPE	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
80	SERVICE_TYPE_TEXT	☐	DIENTYP_TEXT	TEXT15	CHAR	15	0	IS-M: Service Type Text
81	COMMERCIAL_TYPE	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	TJJ41
82	COMMERCIAL_TYPE_TEXT	☐	WSPOT_ART_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Commercial Type
83	PRODUCT_HIERARCHY	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
84	PRODUCT_HIERARCHY_TEXT	☐	J_PRODH_TEXT	TEXT20	CHAR	20	0	IS-M/AM: Text for Product Hierarchy
85	CAMPAIGN	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
86	AD_INSERT_CATEGORY_DT	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
87	AD_INSERT_CATEGORY_DT_TEXT	☐	SITYP_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Type
88	PLANNED_QTY_TYPE_DT	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	TJJBEVTPA
89	PLANNED_QTY_TYPE_DT_TEXT	☐	JVTBEPMART_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Text for Distribution Planned Quantity Types
90	SELECTIVE_BOOKING_DT	☐	JHTEILBEL	JHTEILBEL	CHAR	1	0	IS-M: Selective/Full Booking Indicator
91	BOOKING_TYPE_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	TJHBOOKOL
92	BOOKING_TYPE_OL_TEXT	☐	ISM_BOOK_OL_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Text for Online Advertising Booking Type
93	FORMAT_OL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	TJHOLFMT
94	FORMAT_OL_TEXT	☐	FORMAT_ONL_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Text for Format Proposal (Online)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RJEP_BUSISM012_VIEW	AD_CALCULATION_TYPE	TJH79	AZART_RECH	REF	C	CN
2	RJEP_BUSISM012_VIEW	AD_COLOR_SCHEMA	TJJ11	AZART_FARB	REF	C	CN
3	RJEP_BUSISM012_VIEW	AD_DESIGN_TYPE	TJJ19	AZART_GEST	REF	C	CN
4	RJEP_BUSISM012_VIEW	AD_FIXED_FORMAT	TJJ13	AZART_AREA	REF	C	CN
5	RJEP_BUSISM012_VIEW	AD_INSERT_CATEGORY_AI	TJH29	SI_TYP	REF	C	CN
6	RJEP_BUSISM012_VIEW	AD_INSERT_CATEGORY_DT	TJH29	SI_TYP	REF	C	CN
7	RJEP_BUSISM012_VIEW	AD_INSERT_PROC_TYPE	TJH03	BEARB	REF	C	CN
8	RJEP_BUSISM012_VIEW	AD_SHAPE	TJJ17	AZART_FORM	REF	C	CN
9	RJEP_BUSISM012_VIEW	BOOKING_TYPE_OL	TJHBOOKOL	BOOK_OL	REF	C	CN
10	RJEP_BUSISM012_VIEW	BOOKING_UNIT	JJTBE	BELEINH	REF	C	CN
11	RJEP_BUSISM012_VIEW	BUSINESS_CONTENT_COMPONENT	JJTIKO	INHALTSKOM	REF	C	CN
12	RJEP_BUSISM012_VIEW	CAMPAIGN	TJJKAMP	KAMPAGNE	REF	C	CN
13	RJEP_BUSISM012_VIEW	CD_UNT_1_ISO	T006I	ISOCODE	REF	C	CN
14	RJEP_BUSISM012_VIEW	CD_UNT_2_ISO	T006I	ISOCODE	REF	C	CN
15	RJEP_BUSISM012_VIEW	COA_NUMBER	JHTVKO	VTNR	KEY	1	CN
16	RJEP_BUSISM012_VIEW	COMMERCIAL_TYPE	TJJ41	WSPOT_ART	REF	C	CN
17	RJEP_BUSISM012_VIEW	COND_CURRENCY_1	TCURC	WAERS	REF	C	CN
18	RJEP_BUSISM012_VIEW	COND_CURRENCY_2	TCURC	WAERS	REF	C	CN
19	RJEP_BUSISM012_VIEW	COND_UNIT_1	T006	MSEHI	REF	C	CN
20	RJEP_BUSISM012_VIEW	COND_UNIT_2	T006	MSEHI	REF	C	CN
21	RJEP_BUSISM012_VIEW	DISTR_CHAN	TVTA	VTWEG	REF	1	CN
22	RJEP_BUSISM012_VIEW	DIVISION	TVTA	SPART	REF	1	CN
23	RJEP_BUSISM012_VIEW	FORMAT_OL	TJHOLFMT	FORMAT_ONL	REF	C	CN
24	RJEP_BUSISM012_VIEW	ITEM_CATEGORY	TJHAP	PSTYV	REF	C	CN
25	RJEP_BUSISM012_VIEW	MEDIAMIX	JHTMXK	VTNR	REF	C	CN
26	RJEP_BUSISM012_VIEW	PLANNED_QTY_TYPE_DT	TJJBEVTPA	JVTBEPMART	REF	C	CN
27	RJEP_BUSISM012_VIEW	PRICE_GRP	T188	KONDA	REF	C	CN
28	RJEP_BUSISM012_VIEW	PRODUCT_HIERARCHY	JJT179	PRODH	REF	C	CN
29	RJEP_BUSISM012_VIEW	REQ_KEY	JHTVB	BEDNR	REF	C	CN
30	RJEP_BUSISM012_VIEW	SALESORG	TVTA	VKORG	REF	1	CN
31	RJEP_BUSISM012_VIEW	SERVICE_TYPE	TJH71	DIENTYP	REF	C	CN
32	RJEP_BUSISM012_VIEW	SPECIAL_PUBLICATION_CONT_COMP	JJTIKO	INHALTSKOM	REF	C	CN
33	RJEP_BUSISM012_VIEW	TARGET_CURRENCY	TCURC	WAERS	REF	C	CN
34	RJEP_BUSISM012_VIEW	TARGET_UOM	JJV006	MSEHI	REF	C	CN
35	RJEP_BUSISM012_VIEW	TARGET_UOM_ISO	T006I	ISOCODE	REF	C	CN
36	RJEP_BUSISM012_VIEW	TARGET_UON	JJV006DL	MSEHI	REF	C	CN
37	RJEP_BUSISM012_VIEW	TARGET_UON_ISO	T006I	ISOCODE	REF	C	CN

History

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