SAP ABAP Table JJTBE (IS-M/AM: Booking Units)

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	JJTBE	Table Relationship Diagram
Short Description	IS-M/AM: Booking Units

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	BELEINH	☑	BELEGEINH	BELEINH	CHAR	10	0	IS-M/AM: Booking Unit
3	.INCLUDE	☐				0	0	IS-M: Short and Long Texts
4	KURZTEXT	☐	BEZEICHN15	TEXT15	CHAR	15	0	IS-M: Short Text
5	LANGTEXT	☐	BEZEICHN50	TEXT50	CHAR	50	0	IS-M: Long Text
6	BE_GRP	☐	BE_GRP	BE_GRP	CHAR	4	0	IS-M: Booking Unit Group	TJJ61
7	REF_BASIS	☐	REF_BASIS	BELEINH	CHAR	10	0	IS-M: "Leading" Basic Book.Unit in a Combined Booking Unit	JJTBE
8	REF_DRERZ	☐	REF_DRERZ	DRERZ	CHAR	8	0	IS-M: Reference publication for a basic BU	JDTDRER
9	REF_PVA	☐	REF_PVA	PVA	CHAR	8	0	IS-M: Reference edition for basic booking unit	JDTPVA
10	XAVMPOS_AZ	☐	XAVMPOS_AZ	XFELD	CHAR	1	0	IS-M: Validity for Order of the Ad Item Type
11	XAVMPOS_WS	☐	XAVMPOS_WS	XFELD	CHAR	1	0	IS-M: Validity for Commercial Order Item Type
12	XAVMPOS_SI	☐	XAVMPOS_SI	XFELD	CHAR	1	0	IS-M: Validity for Ad Insert Order Item Type
13	XAVMPOS_VT	☐	XAVMPOS_VT	XFELD	CHAR	1	0	IS-M: Validity for Distribution Order Item Type
14	XAVMPOS_OL	☐	XAVMPOS_OL	XFELD	CHAR	1	0	IS-M: Validity for Online Item Type
15	XBASIS_BE	☐	XBASIS_BE	XFELD	CHAR	1	0	IS-M: Basic Booking Unit (Sales View) Indicator
16	MEDIA_ART	☐	MEDIA_ART	MEDIA_ART	CHAR	2	0	IS-M: Media type (print media/radio)
17	XKOMBI_BE	☐	XKOMBI_BE	XFELD	CHAR	1	0	IS-M: Indicator: BU consists of other BUs
18	XSPERR_BE	☐	XSPERR_BE	XFELD	CHAR	1	0	IS-M/AM: BU Is Blocked For Sale Indicator
19	VERKAUFBIS	☐	VERKAUFBIS	DATUM	DATS	8	0	IS-M: Date Until Which Sale is Allowed
20	VERKAUFVON	☐	VERKAUFVON	DATUM	DATS	8	0	IS-M: Date from When Sale is Admissible
21	X_ALLVB	☐	X_ALLVB	XFELD	CHAR	1	0	IS-M: "No Restriction Regarding Sales Areas" Indicator
22	XIKOSUBSET	☐	XIKOSUBSET	XFELD	CHAR	1	0	IS-M: Restriction Regarding Saleable CCs Indicator
23	BEGRP_INH	☐	BEGRP_INH	BEGRP_INH	CHAR	4	0	IS-M: Booking Unit Content Grouping	TJJ87
24	GRP_LOCWIN	☐	GRP_LOCWIN	GRP_LOCWIN	CHAR	4	0	IS-M: "Local Window" Grouping	TJJLF
25	BEGRP_STAT	☐	BEGRP_STAT	BEGRP_STAT	CHAR	4	0	IS-M: BU Grouping for Statistics	TJJ67
26	KTGRB	☐	KTGRB	KTGRB	CHAR	2	0	IS-M: Booking Unit Account Assignment Group	TJJ39
27	VERKAUF_BM	☐	VERKAUF_BM	TEXT50	CHAR	50	0	IS-M: Comment for Sales Help (Freely Definable Text)
28	XVARTYP_VA	☐	XVARTYP_VA	XFELD	CHAR	1	0	IS-M: Content by issue type indicator
29	XVARTYP_PE	☐	XVARTYP_PE	XFELD	CHAR	1	0	IS-M: CC assignment by PU variant type indicator
30	PREIS_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
31	PREIS_HVAR	☐	PREIS_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Hierarchy Variant for Pricing	TJJ55
32	STRUK_HTYP	☐	IKO_HIETYP	IKO_HIETYP	CHAR	2	0	IS-M: Content Component Hierarchy Type	TJJ51
33	STRUK_HVAR	☐	STRUK_HVAR	IKO_HIEVAR	CHAR	6	0	IS-M: Content Component Structural Hierarchy Variant	TJJ55
34	XAND_KOMBI	☐	XAND_KOMBI	XFELD	CHAR	1	0	IS-M: Combined Booking Unit is Regional and Combined
35	XXOR_KOMBI	☐	XXOR_KOMBI	XFELD	CHAR	1	0	IS-M: Combined Booking Unit Divided By Content Indicator
36	XAUFTKOMBI	☐	XAUFTKOMBI	XFELD	CHAR	1	0	IS-M: Separate Settlement for Lower-Level BUs Indicator
37	XAUFT_MOT	☐	XAUFT_MOT	XFELD	CHAR	1	0	IS-M: Division for Settlement (Ad Spec-Dependent) Indicator
38	XAUFT_EINT	☐	XAUFT_EINT	XFELD	CHAR	1	0	IS-M: Division for Settlement (Schedule Line-Dep.) Indicator
39	OFFSET_FAK	☐	OFFSET_FAK	OFFSET_FAK	NUMC	2	0	IS-M: Offset in days for billing date
40	WAEHRG	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
41	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
42	DISPO_PLAZ	☐	PLZ_AVM	PLZ_TECH	CHAR	2	0	IS-M: BU Grouping for Positioning Systems	TJHPLZ
43	TERM_TYP	☐	TERM_TYP_A	TERMINTYP	CHAR	1	0	IS-M: Default date type in order	TJH55
44	SIBE_ANZ	☐	SIBE_ANZ	BELEINH	CHAR	10	0	IS-M: Assigned Ad Booking Unit for AI BUs	JJTBE
45	XTYPO_AUFT	☐	XTEC_MOSPL	XFELD	CHAR	1	0	IS-M: Local Ad Spec Split for Technical Reasons
46	XLOEVM	☐	LOEVM_ISP	XFELD	CHAR	1	0	Deletion Flag for Master Data in Media Sales & Distribution
47	XLOEKZ	☐	LOEKZ_ISP	XFELD	CHAR	1	0	Deletion Indicator for Master Data in Media Sales & Dist.
48	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
49	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
50	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
51	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
52	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
53	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
54	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
55	ANZ_QUART	☐	ANZ_QUART	ANZ_QUART	NUMC	1	0	IS-M: Default Values for No.of Quarters for Cal.Display
56	BEGRP_PR	☐	BEGRP_PR	BEGRP_PR	CHAR	2	0	IS-M: BU Grouping for Pricing	TJHBEGRPR
57	OFFSET_VZ	☐	OFFSET_VZ	PAM_VZ	CHAR	1	0	IS-M: Billing offset sign
58	SFSP_ABR	☐	SFSP_ABR	SEITE_FSP	CHAR	4	0	IS-M: Column Format for Settlement	TJJ47
59	XEPVA	☐	JHXEBEPVA	XFELD	CHAR	1	0	IS-M: Revenue Distribution at Edition Level Indicator
60	.INCLUDE	☐				0	0	IS-PAM: Fields relevant to acct assigmt from master data
61	CO_AUFNR	☐	JHCO_AUFNR	AUFNR	CHAR	12	0	IS-M: Order No.of Internal CO Order for Account Assignment	AUFK
62	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
63	RK_AUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
64	RK_POSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
65	KOSTL_R2	☐	KOSTL_R2	KOSTL_R2	CHAR	8	0	Cost center in R/2
66	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
67	DRUERZART	☐	DRUERZART	DRUERZART	CHAR	1	0	Publication Type	*
68	DRERZ	☐	ISM_SI_DRERZ	DRERZ	CHAR	8	0	IS-M: AI Publication Elements for a Basic BU	*
69	PVA	☐	ISM_SI_PVA	PVA	CHAR	8	0	IS-M: AI edition elements for basic BU	*
70	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	T001W
71	XSFSP_AUFT	☐	XSFSP_MOSPL	XFELD	CHAR	1	0	IS-M/AM: Ad Spec Split Due to Page Column Format
72	XGRP_FPLZ_OL	☐	ISM_XGRP_FPLZ_OL	XFELD	CHAR	1	0	IS-M: Fixed Space Grouping Indicator
73	KNTKTZHL_VERTEIL	☐	ISM_KNTKTZHL_VERTEIL	ISM_KNTKTZHL_VERTEIL	NUMC	2	0	IS-M: Distribution Rule for Gross Impressions
74	XADVSLSZ_PROD	☐	ISM_XADVSLSZ_PROD	XFELD	CHAR	1	0	IS-M/AM: Booking Unit for Advertising Sales Zones

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JJTBE	BEGRP_INH	TJJ87	BEGRP_INH	REF	1	CN
2	JJTBE	BEGRP_PR	TJHBEGRPR	BEGRP_PR		1	CN
3	JJTBE	BEGRP_STAT	TJJ67	BEGRP_STAT	REF	C	CN
4	JJTBE	BE_GRP	TJJ61	BE_GRP	KEY	1	CN
5	JJTBE	CO_AUFNR	AUFK	AUFNR	REF	1	CN
6	JJTBE	DISPO_PLAZ	TJHPLZ	PLZ_AVM	REF	1	CN
7	JJTBE	DRUCKEREI	T001W	WERKS
8	JJTBE	GRP_LOCWIN	TJJLF	GRP_LOCWIN	REF	1	CN
9	JJTBE	KOSTL	CSKS	KOSTL
10	JJTBE	KTGRB	TJJ39	KTGRB	REF	C	CN
11	JJTBE	KURST	TCURV	KURST	REF	1	CN
12	JJTBE	MANDT	T000	MANDT	KEY	1	CN
13	JJTBE	PRCTR	CEPC	PRCTR
14	JJTBE	PREIS_HTYP	TJJ51	IKO_HIETYP	REF	1	CN
15	JJTBE	PREIS_HVAR	TJJ55	IKO_HIEVAR	REF	1	CN
16	JJTBE	REF_BASIS	JJTBE	BELEINH	REF	C	CN
17	JJTBE	REF_DRERZ	JDTDRER	DRERZ	KEY	1	CN
18	JJTBE	REF_PVA	JDTPVA	PVA	KEY	1	CN
19	JJTBE	SFSP_ABR	TJJ47	SEITE_FSP	REF	1	CN
20	JJTBE	SIBE_ANZ	JJTBE	BELEINH	REF	C	CN
21	JJTBE	STRUK_HTYP	TJJ51	IKO_HIETYP	REF	1	CN
22	JJTBE	STRUK_HVAR	TJJ55	IKO_HIEVAR	REF	1	CN
23	JJTBE	TERM_TYP	TJH55	TERM_TYP	REF	1	CN
24	JJTBE	WAEHRG	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in