SAP ABAP Table JJTBB (IS-M/AM: Requirement Element of Media Sales Agent Contract)

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	JJTBB	Table Relationship Diagram
Short Description	IS-M/AM: Requirement Element of Media Sales Agent Contract

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	VNR	☑	JVMVVNR	JVMVVNR	CHAR	10	0	IS-M: Media Sales Agent Contract Number	JJTVV
3	BEDNR	☑	VM_BEDNR	VM_BEDNR	NUMC	6	0	IS-M: Number of Media Sales Agent Contract Requirement	JJTVB
4	BESNREXT	☑	JBESTNR_EX	JBESTNR_EX	NUMC	6	0	IS-M: Element Number in Media Agent Contract
5	.INCLUDE	☐				0	0	IS-PAM: Requirement elements (data part)
6	.INCLUDE	☐				0	0	IS-M/AM: Requirement Elements (Content)
7	ZUOFUNKT	☐	JZFKT	JZUORDFUNK	CHAR	1	0	IS-M: Assignment Function (Inclusive, Exclusive)
8	BELEINH	☐	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit	JJTBE
9	INHK_TECH2	☐	INHK_SOVER	INHALTSKOM	CHAR	8	0	IS-M: Special Publication Content Component	JJTIKO
10	INHK_KFM	☐	INHK_KFM	INHALTSKOM	CHAR	8	0	IS-M: Business Content Component	JJTIKO
11	AVMPOS_ART	☐	AVMPOS_ART	AVMPOS_ART	CHAR	2	0	IS-M: Order-Publishing-Media - Item Type	TJH17
12	BRAN1	☐	BRAN_PAM	BRACO	CHAR	10	0	IS-M: Industry Sector for Advertiser	TBRC
13	KUKARR	☐	JKUKARR	JKUKARR	CHAR	2	0	IS-M: Customer Profile	TJJ95
14	IN_GPNR	☐	INSERENT	GPNR	CHAR	10	0	IS-M: Advertiser	JJVDB_MK_FK
15	AR_GPNR	☐	AGENTUR	GPNR	CHAR	10	0	IS-M: Agency	JGTGPNR
16	BEZIRK_AG	☐	VERMBEZ_AG	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of the Agency	JVTBEZIRK
17	BEZIRK_IS	☐	VERMBEZ_IS	BEZIRK	CHAR	10	0	IS-M: Sales Agent Zone of Advertiser	JVTBEZIRK
18	PRDHA	☐	J_PRODH	J_PRODH	CHAR	18	0	IS-M/AM: Product Hierarchy	JJT179
19	VTNR	☐	ABS_VTNR	ABS_VTNR	NUMC	6	0	IS-M: Contract Number	JHTVKO
20	MATNR	☐	MATNR_DIEN	MATNR_DIEN	CHAR	18	0	IS-M: Service material number	JJTDIEN
21	DIENTYP	☐	DIENTYP	DIENTYP	CHAR	4	0	IS-M: Service Type	TJH71
22	.INCLUDE	☐				0	0	IS-PAM: Requirement elements (dat part: cust.exist)
23	FATBB1	☐	JJFATBB1	JJFATBB1	CHAR	1	0	IS-M: Free Attribute 1 Requirement Element	TJJFA
24	FATBB2	☐	JJFATBB2	JJFATBB2	CHAR	1	0	IS-M: Free Attribute 2 Requirement Element	TJJFC
25	FATBB3	☐	JJFATBB3	JJFATBB3	CHAR	1	0	IS-M: Free Attribute 3 Requirement Element	TJJFE
26	FATBB4	☐	JJFATBB4	JJFATBB4	CHAR	2	0	IS-M: Free Attribute 4 Requirement Element	TJJFG
27	FATBB5	☐	JJFATBB5	JJFATBB5	CHAR	2	0	IS-M: Free Attribute 5 Requirement Element	TJJFI
28	FATBB6	☐	JJFATBB6	JJFATBB6	CHAR	4	0	IS-M: Free Attribute 6 Requirement Element	TJJFK
29	FATBB7	☐	JJFATBB7	JJFATBB7	CHAR	10	0	IS-M: Free Attribute 7 Requirement Element	TJJFM
30	ABW_GUEAB	☐	DIFFDATEFR	DATUM	DATS	8	0	IS-M: "Valid-From" Date Within Higher-Level Validity Period
31	ABW_GUEBIS	☐	DIFFDATETO	DATUM	DATS	8	0	IS-M: "Valid To" Date Within Higher Level Validity
32	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
33	XLOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
34	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
35	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
36	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
37	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
38	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
39	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
40	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	JJTBB	AR_GPNR	JGTGPNR	GPNR	REF	1	CN
2	JJTBB	AVMPOS_ART	TJH17	AVMPOS_ART	REF	1	CN
3	JJTBB	BEDNR	JJTVB	BEDNR	KEY	1	CN
4	JJTBB	BELEINH	JJTBE	BELEINH	REF	1	CN
5	JJTBB	BEZIRK_AG	JVTBEZIRK	BEZIRK	REF	1	CN
6	JJTBB	BEZIRK_IS	JVTBEZIRK	BEZIRK	REF	1	CN
7	JJTBB	BRAN1	TBRC	BRACO	REF	1	CN
8	JJTBB	DIENTYP	TJH71	DIENTYP	REF	1	CN
9	JJTBB	FATBB1	TJJFA	FATBB1	REF	1	CN
10	JJTBB	FATBB2	TJJFC	FATBB2	REF	1	CN
11	JJTBB	FATBB3	TJJFE	FATBB3	REF	1	CN
12	JJTBB	FATBB4	TJJFG	FATBB4	REF	1	CN
13	JJTBB	FATBB5	TJJFI	FATBB5	REF	1	CN
14	JJTBB	FATBB6	TJJFK	FATBB6	REF	1	CN
15	JJTBB	FATBB7	TJJFM	FATBB7	REF	1	CN
16	JJTBB	INHK_KFM	JJTIKO	INHALTSKOM	REF	1	CN
17	JJTBB	INHK_TECH2	JJTIKO	INHALTSKOM	REF	1	CN
18	JJTBB	IN_GPNR	JJVDB_MK_FK	GPNR	REF	1	CN
19	JJTBB	KUKARR	TJJ95	KUKARR	REF	1	CN
20	JJTBB	MANDT	T000	MANDT	KEY	1	CN
21	JJTBB	MATNR	JJTDIEN	MATNR	REF	1	CN
22	JJTBB	PRDHA	JJT179	PRODH	REF	1	CN
23	JJTBB	VNR	JJTVV	VNR	KEY	1	CN
24	JJTBB	VTNR	JHTVKO	VTNR	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in