SAP ABAP Table RJJTBE (IS-M/AM: Booking Unit)

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

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

History

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