SAP ABAP Table JHTTBED (IS-M/AM: OPM - Rate Requirements)

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	TRANSP	Transparent table
Transparent table	JHTTBED	Table Relationship Diagram
Short Description	IS-M/AM: OPM - Rate Requirements

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
4	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
5	TBEDNR	☑	TBEDNR	TBEDNR	CHAR	5	0	IS-M: Rate Requirement Number
6	GUELTIGAB	☐	DATEVALFRM	DATUM	DATS	8	0	IS-M: "Valid From" Date
7	GUELTIGBIS	☐	DATEVALTO	DATUM	DATS	8	0	IS-M: "Valid To" Date
8	XLOESCHVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
9	XLOESCHKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
10	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
11	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
12	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
13	.INCLUDE	☐				0	0	IS-M: Pay Scale Provision - Attributes
14	ZUOFUNKT	☐	JZFKT	JZUORDFUNK	CHAR	1	0	IS-M: Assignment Function (Inclusive, Exclusive)
15	AVMPOS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
16	POSTYP	☐	PSTYV_PAM	PSTYV_PAM	CHAR	4	0	IS-M: Item Category for Sales Document	TJHAP
17	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
18	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
19	XORTSPREIS	☐	XORTSPREIS	XFELD	CHAR	1	0	IS-M/AM: Local Customer Indicator
20	GGSCHFT	☐	GGSCHFT	GGSCHFT	CHAR	2	0	IS-M: Barter Deal
21	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
22	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
23	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
24	AZART_AREA	☐	AZART_AREA	AZART_AREA	CHAR	4	0	IS-M/AM: Fixed Format Proposal /Ad Dimensions	TJJ13
25	AZART_FARB	☐	AZART_FARB	AZART_FARB	CHAR	4	0	IS-M: Color Scheme Ad Type	TJJ11
26	AZART_GEST	☐	AZART_GEST	AZART_GEST	CHAR	4	0	IS-M: Design Ad Type	TJJ19
27	AZART_FORM	☐	AZART_FORM	AZART_FORM	CHAR	4	0	IS-M: Shape Ad Type	TJJ17
28	AZART_PLAZ	☐	AZART_PLAZ	AZART_PLAZ	CHAR	4	0	IS-M: Ad Type with Regard to General Positioning	TJJ15
29	SINSBEARB	☐	SINSBEARB	SIBEAR_ART	CHAR	2	0	IS-M: Ad Insert Processing Type	TJH03
30	SI_TYP	☐	SITYP	SI_TYP	CHAR	2	0	IS-M: Ad Insert Type	TJH29
31	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
32	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
33	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
34	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
35	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
36	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
37	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
38	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
39	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JHTTBED	AVMPOS_ART	TJH17	AVMPOS_ART
2	JHTTBED	AZART_AREA	TJJ13	AZART_AREA
3	JHTTBED	AZART_FARB	TJJ11	AZART_FARB
4	JHTTBED	AZART_FORM	TJJ17	AZART_FORM
5	JHTTBED	AZART_GEST	TJJ19	AZART_GEST
6	JHTTBED	AZART_PLAZ	TJJ15	AZART_PLAZ	REF	1	CN
7	JHTTBED	BELEINH	JJTBE	BELEINH
8	JHTTBED	DIENTYP	TJH71	DIENTYP
9	JHTTBED	INHK_KFM	JJTIKO	INHALTSKOM
10	JHTTBED	INHK_TECH2	JJTIKO	INHALTSKOM
11	JHTTBED	KONDA	T188	KONDA	REF	1	CN
12	JHTTBED	KUKARR	TJJ95	KUKARR	REF	C	CN
13	JHTTBED	MANDT	T000	MANDT	KEY	1	CN
14	JHTTBED	MATNR	JJTDIEN	MATNR
15	JHTTBED	POSTYP	TJHAP	PSTYV	REF	1	CN
16	JHTTBED	SINSBEARB	TJH03	BEARB	REF	C	CN
17	JHTTBED	SI_TYP	TJH29	SI_TYP	REF	1	CN
18	JHTTBED	SPART	TSPA	SPART	KEY	1	CN
19	JHTTBED	VKORG	TVKO	VKORG	KEY	1	CN
20	JHTTBED	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in