SAP ABAP Table BAPIBUSISM012_REQ (IS-M: BAPI Structure for Contract Requirement)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIBUSISM012_REQ	Table Relationship Diagram
Short Description	IS-M: BAPI Structure for Contract 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	COA_NUMBER	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	*
2	REQ_NO	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
3	EXCLUSIVE	☐	XAUSSCHL	XFELD	CHAR	1	0	IS-M: Exclusion Requirement
4	EXCL_REQ_NO1	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
5	EXCL_REQ_NO2	☐	ISM_BUS012_REQ_NO	ABS_POSNR	NUMC	4	0	IS-M: Sequence Number of a Requirement	*
6	COA_ITEM_NO	☐	ABS_POSNR	ABS_POSNR	NUMC	4	0	IS-M: Contract, Item Number	*
7	REQ_KEY	☐	ABS_BEDNR	ABS_BEDNR	CHAR	10	0	IS-M/AM: Key for a Requirement in the Contract	JHTVB
8	REQ_KEY_TEXT	☐	ABS_BEDNR_TEXT	TEXT50	CHAR	50	0	IS-M/AM: Text for Requirement Key in Contract
9	REQ_ELEMENT_NO	☐	BED_POSNR	NUM03	NUMC	3	0	IS-M: Requirement Element Number
10	QUAL_FOR_DISCOUNT	☐	XRABATT	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Discount
11	QUAL_FOR_BONUS	☐	XBONUS	XFELD	CHAR	1	0	IS-M: Assignment Qualifies for Bonus
12	CNTS_TWD_DISCOUNT	☐	XMITZRAB	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Discount Fulfillment
13	CNTS_TWD_BONUS	☐	XMITZBON	XFELD	CHAR	1	0	IS-M: Assignment Counts Towards Bonus Fulfillment
14	ITEM_TYPE_AD	☐	XAVMPOS_AZ	XFELD	CHAR	1	0	IS-M: Validity for Order of the Ad Item Type
15	ITEM_TYPE_AI	☐	XAVMPOS_SI	XFELD	CHAR	1	0	IS-M: Validity for Ad Insert Order Item Type
16	ITEM_TYPE_SV	☐	XAVMPOS_DL	XFELD	CHAR	1	0	IS-M: Validity for Service Order Item Type
17	ITEM_TYPE_CM	☐	XAVMPOS_WS	XFELD	CHAR	1	0	IS-M: Validity for Commercial Order Item Type
18	ITEM_TYPE_DT	☐	XAVMPOS_VT	XFELD	CHAR	1	0	IS-M: Validity for Distribution Order Item Type
19	ITEM_TYPE_OL	☐	XAVMPOS_OL	XFELD	CHAR	1	0	IS-M: Validity for Online Item Type
20	SALESORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVTA
21	SALESORG_TEXT	☐	VKORG_BEZ	TEXT20	CHAR	20	0	Description of sales organization
22	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTA
23	DISTR_CHAN_TEXT	☐	VTWEG_BEZ	TEXT20	CHAR	20	0	Description of distribution channel
24	DIVISION	☐	SPART	SPART	CHAR	2	0	Division	TVTA
25	DIVISION_TEXT	☐	SPART_BEZ	TEXT20	CHAR	20	0	Description of division
26	ITEM_CATEGORY	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	*
27	ITEM_CATEGORY_TEXT	☐	PSTYV_PAM_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Sales Document Item Category
28	AD_FIXED_FORMAT	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
29	AD_FIXED_FORMAT_TEXT	☐	AZART_AREA_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Fixed Format Proposal / Ad Size
30	AD_SHAPE	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
31	AD_SHAPE_TEXT	☐	AZART_FORM_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Shape Ad Type
32	AD_COLOR_SCHEMA	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
33	AD_COLOR_SCHEMA_TEXT	☐	AZART_FARB_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Color Scheme Ad Type
34	AD_DESIGN_TYPE	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
35	AD_DESIGN_TYPE_TEXT	☐	AZART_GEST_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Design Ad Type
36	AD_CALCULATION_TYPE	☐	AZART_RECH	AZART_RECH	CHAR	2	0	IS-M: Calculation Ad Type	TJH79
37	AD_CALCULATION_TYPE_TEXT	☐	AZART_RECH_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Calculation Ad Type
38	BUSINESS_CONTENT_COMPONENT	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
39	SPECIAL_PUBLICATION_CONT_COMP	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
40	BOOKING_UNIT	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
41	BOOKING_UNIT_TEXT	☐	BELEGEINH_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Booking Unit Text
42	PRICE_GRP	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
43	PRICE_GRP_TEXT	☐	ISM_KONDA_TEXT	TEXT20	CHAR	20	0	IS-M: Text for Customer Price Group
44	AD_INSERT_PROC_TYPE	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
45	AD_INSERT_PROC_TYPE_TEXT	☐	ISM_SINSBEARB_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Processing Type
46	AD_INSERT_CATEGORY_AI	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
47	AD_INSERT_CATEGORY_AI_TEXT	☐	SITYP_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Type
48	DELTA_COVERAGE	☐	JHRHHABD	JHRHHABD	CHAR	1	0	IS-M: Total Market Coverage Indicator
49	SELECTIVE_BOOKING_AI	☐	JHTEILBEL	JHTEILBEL	CHAR	1	0	IS-M: Selective/Full Booking Indicator
50	MIN_COVERAGE	☐	MIN_BELEG	PRZ22	DEC	4	2	IS-M: Minimum Booking in Percent
51	SERVICE_TYPE	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
52	SERVICE_TYPE_TEXT	☐	DIENTYP_TEXT	TEXT15	CHAR	15	0	IS-M: Service Type Text
53	COMMERCIAL_TYPE	☐	WSPOT_ART	WSPOT_ART	CHAR	4	0	IS-M: Commercial Type	TJJ41
54	COMMERCIAL_TYPE_TEXT	☐	WSPOT_ART_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Commercial Type
55	PRODUCT_HIERARCHY	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
56	PRODUCT_HIERARCHY_TEXT	☐	J_PRODH_TEXT	TEXT20	CHAR	20	0	IS-M/AM: Text for Product Hierarchy
57	CAMPAIGN	☐	KAMPAGNE	KAMPAGNE	CHAR	6	0	IS-M: Campaign (customer)	TJJKAMP
58	AD_INSERT_CATEGORY_DT	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
59	AD_INSERT_CATEGORY_DT_TEXT	☐	SITYP_TEXT	TEXT15	CHAR	15	0	IS-M: Text for Ad Insert Type
60	PLANNED_QTY_TYPE_DT	☐	JVTBEPMART	JVTBEPMART	CHAR	4	0	IS-M/AM: Distribution Planned Quantity Types	TJJBEVTPA
61	PLANNED_QTY_TYPE_DT_TEXT	☐	JVTBEPMART_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Text for Distribution Planned Quantity Types
62	SELECTIVE_BOOKING_DT	☐	JHTEILBEL	JHTEILBEL	CHAR	1	0	IS-M: Selective/Full Booking Indicator
63	BOOKING_TYPE_OL	☐	ISM_BOOK_OL	ISM_BOOK_OL	CHAR	4	0	IS-M/AM: Booking Type for Online Advertising	TJHBOOKOL
64	BOOKING_TYPE_OL_TEXT	☐	ISM_BOOK_OL_TEXT	TEXT15	CHAR	15	0	IS-M/AM: Text for Online Advertising Booking Type
65	FORMAT_OL	☐	FORMAT_ONL	FORMAT_ONL	CHAR	4	0	IS-M/AM: Format Proposal (Online)	TJHOLFMT
66	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	BAPIBUSISM012_REQ	AD_CALCULATION_TYPE	TJH79	AZART_RECH	REF	C	CN
2	BAPIBUSISM012_REQ	AD_COLOR_SCHEMA	TJJ11	AZART_FARB	REF	C	CN
3	BAPIBUSISM012_REQ	AD_DESIGN_TYPE	TJJ19	AZART_GEST	REF	C	CN
4	BAPIBUSISM012_REQ	AD_FIXED_FORMAT	TJJ13	AZART_AREA	REF	C	CN
5	BAPIBUSISM012_REQ	AD_INSERT_CATEGORY_AI	TJH29	SI_TYP	REF	C	CN
6	BAPIBUSISM012_REQ	AD_INSERT_CATEGORY_DT	TJH29	SI_TYP	REF	C	CN
7	BAPIBUSISM012_REQ	AD_INSERT_PROC_TYPE	TJH03	BEARB	REF	C	CN
8	BAPIBUSISM012_REQ	AD_SHAPE	TJJ17	AZART_FORM	REF	C	CN
9	BAPIBUSISM012_REQ	BOOKING_TYPE_OL	TJHBOOKOL	BOOK_OL	REF	C	CN
10	BAPIBUSISM012_REQ	BOOKING_UNIT	JJTBE	BELEINH	REF	C	CN
11	BAPIBUSISM012_REQ	BUSINESS_CONTENT_COMPONENT	JJTIKO	INHALTSKOM	REF	C	CN
12	BAPIBUSISM012_REQ	CAMPAIGN	TJJKAMP	KAMPAGNE	REF	C	CN
13	BAPIBUSISM012_REQ	COMMERCIAL_TYPE	TJJ41	WSPOT_ART	REF	C	CN
14	BAPIBUSISM012_REQ	DISTR_CHAN	TVTA	VTWEG	REF	C	CN
15	BAPIBUSISM012_REQ	DIVISION	TVTA	SPART	REF	C	CN
16	BAPIBUSISM012_REQ	FORMAT_OL	TJHOLFMT	FORMAT_ONL	REF	C	CN
17	BAPIBUSISM012_REQ	PLANNED_QTY_TYPE_DT	TJJBEVTPA	JVTBEPMART	REF	C	CN
18	BAPIBUSISM012_REQ	PRICE_GRP	T188	KONDA	REF	C	CN
19	BAPIBUSISM012_REQ	PRODUCT_HIERARCHY	JJT179	PRODH	REF	C	CN
20	BAPIBUSISM012_REQ	REQ_KEY	JHTVB	BEDNR	REF	C	CN
21	BAPIBUSISM012_REQ	SALESORG	TVTA	VKORG	REF	C	CN
22	BAPIBUSISM012_REQ	SERVICE_TYPE	TJH71	DIENTYP	REF	C	CN
23	BAPIBUSISM012_REQ	SPECIAL_PUBLICATION_CONT_COMP	JJTIKO	INHALTSKOM	REF	C	CN

History

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