SAP ABAP Table ISMAM_TXW_JJTBE (DART 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	INTTAB	Structure
Structure	ISMAM_TXW_JJTBE	Table Relationship Diagram
Short Description	DART IS-M/AM: Booking Units

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

Foreign Keys

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

History

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