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