SAP Table JJTBE
IS-M/AM: Booking Units
JJTBE (IS-M/AM: Booking Units) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link JJTBE to other SAP tables.
JJTBE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||
| BELEINH | IS-M/AM: Booking Unit | BELEGEINH | CHAR | 10 | 0 | |||||||||||||||||||
| KURZTEXT | IS-M: Short Text | BEZEICHN15 | CHAR | 15 | 0 | |||||||||||||||||||
| LANGTEXT | IS-M: Long Text | BEZEICHN50 | CHAR | 50 | 0 | |||||||||||||||||||
| BE_GRP | IS-M: Booking Unit Group | BE_GRP | TJJ61 | CHAR | 4 | 0 | ||||||||||||||||||
| REF_BASIS | IS-M: "Leading" Basic Book.Unit in a Combined Booking Unit | REF_BASIS | JJTBE | CHAR | 10 | 0 | ||||||||||||||||||
| REF_DRERZ | IS-M: Reference publication for a basic BU | REF_DRERZ | JDTDRER | CHAR | 8 | 0 | ||||||||||||||||||
| REF_PVA | IS-M: Reference edition for basic booking unit | REF_PVA | JDTPVA | CHAR | 8 | 0 | ||||||||||||||||||
| XAVMPOS_AZ | IS-M: Validity for Order of the Ad Item Type | XAVMPOS_AZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAVMPOS_WS | IS-M: Validity for Commercial Order Item Type | XAVMPOS_WS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAVMPOS_SI | IS-M: Validity for Ad Insert Order Item Type | XAVMPOS_SI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAVMPOS_VT | IS-M: Validity for Distribution Order Item Type | XAVMPOS_VT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAVMPOS_OL | IS-M: Validity for Online Item Type | XAVMPOS_OL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XBASIS_BE | IS-M: Basic Booking Unit (Sales View) Indicator | XBASIS_BE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| MEDIA_ART | IS-M: Media type (print media/radio) | MEDIA_ART | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||
| XKOMBI_BE | IS-M: Indicator: BU consists of other BUs | XKOMBI_BE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XSPERR_BE | IS-M/AM: BU Is Blocked For Sale Indicator | XSPERR_BE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| VERKAUFBIS | IS-M: Date Until Which Sale is Allowed | VERKAUFBIS | DATS | 8 | 0 | |||||||||||||||||||
| VERKAUFVON | IS-M: Date from When Sale is Admissible | VERKAUFVON | DATS | 8 | 0 | |||||||||||||||||||
| X_ALLVB | IS-M: "No Restriction Regarding Sales Areas" Indicator | X_ALLVB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XIKOSUBSET | IS-M: Restriction Regarding Saleable CCs Indicator | XIKOSUBSET | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| BEGRP_INH | IS-M: Booking Unit Content Grouping | BEGRP_INH | TJJ87 | CHAR | 4 | 0 | ||||||||||||||||||
| GRP_LOCWIN | IS-M: "Local Window" Grouping | GRP_LOCWIN | TJJLF | CHAR | 4 | 0 | ||||||||||||||||||
| BEGRP_STAT | IS-M: BU Grouping for Statistics | BEGRP_STAT | TJJ67 | CHAR | 4 | 0 | ||||||||||||||||||
| KTGRB | IS-M: Booking Unit Account Assignment Group | KTGRB | TJJ39 | CHAR | 2 | 0 | ||||||||||||||||||
| VERKAUF_BM | IS-M: Comment for Sales Help (Freely Definable Text) | VERKAUF_BM | CHAR | 50 | 0 | |||||||||||||||||||
| XVARTYP_VA | IS-M: Content by issue type indicator | XVARTYP_VA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XVARTYP_PE | IS-M: CC assignment by PU variant type indicator | XVARTYP_PE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| PREIS_HTYP | IS-M: Content Component Hierarchy Type | IKO_HIETYP | TJJ51 | CHAR | 2 | 0 | ||||||||||||||||||
| PREIS_HVAR | IS-M: Content Component Hierarchy Variant for Pricing | PREIS_HVAR | TJJ55 | CHAR | 6 | 0 | ||||||||||||||||||
| STRUK_HTYP | IS-M: Content Component Hierarchy Type | IKO_HIETYP | TJJ51 | CHAR | 2 | 0 | ||||||||||||||||||
| STRUK_HVAR | IS-M: Content Component Structural Hierarchy Variant | STRUK_HVAR | TJJ55 | CHAR | 6 | 0 | ||||||||||||||||||
| XAND_KOMBI | IS-M: Combined Booking Unit is Regional and Combined | XAND_KOMBI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XXOR_KOMBI | IS-M: Combined Booking Unit Divided By Content Indicator | XXOR_KOMBI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAUFTKOMBI | IS-M: Separate Settlement for Lower-Level BUs Indicator | XAUFTKOMBI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAUFT_MOT | IS-M: Division for Settlement (Ad Spec-Dependent) Indicator | XAUFT_MOT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XAUFT_EINT | IS-M: Division for Settlement (Schedule Line-Dep.) Indicator | XAUFT_EINT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| OFFSET_FAK | IS-M: Offset in days for billing date | OFFSET_FAK | NUMC | 2 | 0 | |||||||||||||||||||
| WAEHRG | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||||||
| KURST | Exchange Rate Type | KURST | TCURV | CHAR | 4 | 0 | ||||||||||||||||||
| DISPO_PLAZ | IS-M: BU Grouping for Positioning Systems | PLZ_AVM | TJHPLZ | CHAR | 2 | 0 | ||||||||||||||||||
| TERM_TYP | IS-M: Default date type in order | TERM_TYP_A | TJH55 | CHAR | 1 | 0 | ||||||||||||||||||
| SIBE_ANZ | IS-M: Assigned Ad Booking Unit for AI BUs | SIBE_ANZ | JJTBE | CHAR | 10 | 0 | ||||||||||||||||||
| XTYPO_AUFT | IS-M: Local Ad Spec Split for Technical Reasons | XTEC_MOSPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XLOEVM | Deletion Flag for Master Data in Media Sales & Distribution | LOEVM_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XLOEKZ | Deletion Indicator for Master Data in Media Sales & Dist. | LOEKZ_ISP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| ERFUSER | Created By | ERFUSER | CHAR | 12 | 0 | |||||||||||||||||||
| ERFDATE | Created On | ERFDATE | DATS | 8 | 0 | |||||||||||||||||||
| ERFTIME | Time Created | ERFTIME | TIMS | 6 | 0 | |||||||||||||||||||
| AENUSER | Last Changed By | AENUSER | CHAR | 12 | 0 | |||||||||||||||||||
| AENDATE | Date of Last Change | AENDATE | DATS | 8 | 0 | |||||||||||||||||||
| AENTIME | Time of Last Change | AENTIME | TIMS | 6 | 0 | |||||||||||||||||||
| ANZ_QUART | IS-M: Default Values for No.of Quarters for Cal.Display | ANZ_QUART | NUMC | 1 | 0 |
Possible values
|
||||||||||||||||||
| BEGRP_PR | IS-M: BU Grouping for Pricing | BEGRP_PR | TJHBEGRPR | CHAR | 2 | 0 | ||||||||||||||||||
| OFFSET_VZ | IS-M: Billing offset sign | OFFSET_VZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| SFSP_ABR | IS-M: Column Format for Settlement | SFSP_ABR | TJJ47 | CHAR | 4 | 0 | ||||||||||||||||||
| XEPVA | IS-M: Revenue Distribution at Edition Level Indicator | JHXEBEPVA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| CO_AUFNR | IS-M: Order No.of Internal CO Order for Account Assignment | JHCO_AUFNR | AUFK | CHAR | 12 | 0 | ||||||||||||||||||
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 | 0 | ||||||||||||||||||
| RK_AUFNR | Order Number of RK Order for Account Assignment | J_RK_AUFNR | CHAR | 8 | 0 | |||||||||||||||||||
| RK_POSNR | Item Number of RK Order for Account Assignment | J_RK_POSNR | NUMC | 2 | 0 | |||||||||||||||||||
| KOSTL_R2 | Cost center in R/2 | KOSTL_R2 | CHAR | 8 | 0 | |||||||||||||||||||
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 | 0 | ||||||||||||||||||
| DRUERZART | Publication Type | DRUERZART | CHAR | 1 | 0 | |||||||||||||||||||
| DRERZ | IS-M: AI Publication Elements for a Basic BU | ISM_SI_DRERZ | CHAR | 8 | 0 | |||||||||||||||||||
| PVA | IS-M: AI edition elements for basic BU | ISM_SI_PVA | CHAR | 8 | 0 | |||||||||||||||||||
| DRUCKEREI | Plant | JWERK | T001W | CHAR | 4 | 0 | ||||||||||||||||||
| XSFSP_AUFT | IS-M/AM: Ad Spec Split Due to Page Column Format | XSFSP_MOSPL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| XGRP_FPLZ_OL | IS-M: Fixed Space Grouping Indicator | ISM_XGRP_FPLZ_OL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
| KNTKTZHL_VERTEIL | IS-M: Distribution Rule for Gross Impressions | ISM_KNTKTZHL_VERTEIL | NUMC | 2 | 0 |
Possible values
|
||||||||||||||||||
| XADVSLSZ_PROD | IS-M/AM: Booking Unit for Advertising Sales Zones | ISM_XADVSLSZ_PROD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
JJTBE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| JJTBE | BEGRP_INH | JJTBE | MANDT | TJJ87 | IS-M/AM: Booking Unit Grouping Content | MANDT |
| JJTBE | BEGRP_INH | JJTBE | BEGRP_INH | TJJ87 | IS-M/AM: Booking Unit Grouping Content | BEGRP_INH |
| JJTBE | BEGRP_PR | JJTBE | MANDT | TJHBEGRPR | IS-M/AM: BU Grouping For Pricing | MANDT |
| JJTBE | BEGRP_PR | JJTBE | BEGRP_PR | TJHBEGRPR | IS-M/AM: BU Grouping For Pricing | BEGRP_PR |
| JJTBE | BEGRP_STAT | JJTBE | MANDT | TJJ67 | IS-M/AM: BU Grouping Statistics | MANDT |
| JJTBE | BEGRP_STAT | JJTBE | BEGRP_STAT | TJJ67 | IS-M/AM: BU Grouping Statistics | BEGRP_STAT |
| JJTBE | BE_GRP | JJTBE | MANDT | TJJ61 | IS-M/AM: Booking Unit Group | MANDT |
| JJTBE | BE_GRP | JJTBE | BE_GRP | TJJ61 | IS-M/AM: Booking Unit Group | BE_GRP |
| JJTBE | CO_AUFNR | SYST | MANDT | AUFK | Order master data | MANDT |
| JJTBE | CO_AUFNR | JJTBE | CO_AUFNR | AUFK | Order master data | AUFNR |
| JJTBE | DISPO_PLAZ | JJTBE | MANDT | TJHPLZ | IS-M/AM: BU Grouping For Technical Systems | MANDT |
| JJTBE | DISPO_PLAZ | JJTBE | DISPO_PLAZ | TJHPLZ | IS-M/AM: BU Grouping For Technical Systems | PLZ_AVM |
| JJTBE | DRUCKEREI | JJTBE | MANDT | T001W | Plants/Branches | MANDT |
| JJTBE | DRUCKEREI | JJTBE | DRUCKEREI | T001W | Plants/Branches | WERKS |
| JJTBE | GRP_LOCWIN | JJTBE | MANDT | TJJLF | IS-M/AM: BU Grouping of Local Windows | MANDT |
| JJTBE | GRP_LOCWIN | JJTBE | GRP_LOCWIN | TJJLF | IS-M/AM: BU Grouping of Local Windows | GRP_LOCWIN |
| JJTBE | KOSTL | * | CSKS | Cost Center Master Data | KOKRS | |
| JJTBE | KOSTL | JJTBE | KOSTL | CSKS | Cost Center Master Data | KOSTL |
| JJTBE | KOSTL | * | CSKS | Cost Center Master Data | DATBI | |
| JJTBE | KOSTL | SYST | MANDT | CSKS | Cost Center Master Data | MANDT |
| JJTBE | KTGRB | JJTBE | MANDT | TJJ39 | IS-M/AM: Account Assignment Group for Booking Unit | MANDT |
| JJTBE | KTGRB | JJTBE | KTGRB | TJJ39 | IS-M/AM: Account Assignment Group for Booking Unit | KTGRB |
| JJTBE | KURST | JJTBE | MANDT | TCURV | Exchange rate types for currency translation | MANDT |
| JJTBE | KURST | JJTBE | KURST | TCURV | Exchange rate types for currency translation | KURST |
| JJTBE | MANDT | JJTBE | MANDT | T000 | Clients | MANDT |
| JJTBE | PRCTR | SYST | MANDT | CEPC | Profit Center Master Data Table | MANDT |
| JJTBE | PRCTR | JJTBE | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| JJTBE | PRCTR | * | CEPC | Profit Center Master Data Table | DATBI | |
| JJTBE | PRCTR | * | CEPC | Profit Center Master Data Table | KOKRS | |
| JJTBE | PREIS_HTYP | JJTBE | MANDT | TJJ51 | IS-M/AM: Content Component Hierarchy Types | MANDT |
| JJTBE | PREIS_HTYP | JJTBE | PREIS_HTYP | TJJ51 | IS-M/AM: Content Component Hierarchy Types | IKO_HIETYP |
| JJTBE | PREIS_HVAR | JJTBE | MANDT | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | MANDT |
| JJTBE | PREIS_HVAR | JJTBE | PREIS_HTYP | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | IKO_HIETYP |
| JJTBE | PREIS_HVAR | JJTBE | PREIS_HVAR | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | IKO_HIEVAR |
| JJTBE | REF_BASIS | JJTBE | MANDT | JJTBE | IS-M/AM: Booking Units | MANDT |
| JJTBE | REF_BASIS | JJTBE | REF_BASIS | JJTBE | IS-M/AM: Booking Units | BELEINH |
| JJTBE | REF_DRERZ | JJTBE | MANDT | JDTDRER | IS-M/SD: Publications | MANDT |
| JJTBE | REF_DRERZ | JJTBE | REF_DRERZ | JDTDRER | IS-M/SD: Publications | DRERZ |
| JJTBE | REF_PVA | JJTBE | MANDT | JDTPVA | IS-M/SD: Editions | MANDT |
| JJTBE | REF_PVA | JJTBE | REF_DRERZ | JDTPVA | IS-M/SD: Editions | DRERZ |
| JJTBE | REF_PVA | JJTBE | REF_PVA | JDTPVA | IS-M/SD: Editions | PVA |
| JJTBE | SFSP_ABR | JJTBE | MANDT | TJJ47 | IS-M/AM: Page/Column Format | MANDT |
| JJTBE | SFSP_ABR | JJTBE | SFSP_ABR | TJJ47 | IS-M/AM: Page/Column Format | SEITE_FSP |
| JJTBE | SIBE_ANZ | JJTBE | SIBE_ANZ | JJTBE | IS-M/AM: Booking Units | BELEINH |
| JJTBE | SIBE_ANZ | JJTBE | MANDT | JJTBE | IS-M/AM: Booking Units | MANDT |
| JJTBE | STRUK_HTYP | JJTBE | STRUK_HTYP | TJJ51 | IS-M/AM: Content Component Hierarchy Types | IKO_HIETYP |
| JJTBE | STRUK_HTYP | JJTBE | MANDT | TJJ51 | IS-M/AM: Content Component Hierarchy Types | MANDT |
| JJTBE | STRUK_HVAR | JJTBE | STRUK_HTYP | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | IKO_HIETYP |
| JJTBE | STRUK_HVAR | JJTBE | STRUK_HVAR | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | IKO_HIEVAR |
| JJTBE | STRUK_HVAR | JJTBE | MANDT | TJJ55 | IS-M/AM: Content Cmponents - Hierarchy Variants | MANDT |
| JJTBE | TERM_TYP | JJTBE | MANDT | TJH55 | IS-M/AM: Date Types | MANDT |
| JJTBE | TERM_TYP | JJTBE | TERM_TYP | TJH55 | IS-M/AM: Date Types | TERM_TYP |
| JJTBE | WAEHRG | JJTBE | WAEHRG | TCURC | Currency Codes | WAERS |
| JJTBE | WAEHRG | JJTBE | MANDT | TCURC | Currency Codes | MANDT |
