SAP Table TJHVBER

IS-M/AM: General Settings for Specific Sales Areas

TJHVBER (IS-M/AM: General Settings for Specific Sales Areas) 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 TJHVBER to other SAP tables.

TJHVBER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VKORG Sales Organization VKORG TVTA CHAR 4 0
VTWEG Distribution Channel VTWEG TVTA CHAR 2 0
SPART Division SPART TVTA CHAR 2 0
XGP_ZAHLW IS-M: Only Payment Methods From BP Master Data Permitted XGP_ZAHLW CHAR 1 0
X Yes
NULL No
TERM_TYP IS-M: Default Value for Date Category in Order Item TERMTYP_DF TJH55 CHAR 1 0
PERFK_DEF IS-M: Default Billing Schedules (Calendar Ident.) JPERFK_DEF TFACD CHAR 2 0
OFFSET_DEF IS-M: Default Offset in Days for Advance Payment OFFSET_DEF NUMC 2 0
ISPEINH_PR Unit of Measure for Ad Dimensions (Qty-Dependent Prices) ISPEINH_PR TJH51 UNIT 3 0
HOEHE_DEH IS-M/AM: Default Setting for Height Unit of Measure HOEHE_DEH TJH61 UNIT 3 0
AZART_RECH IS-M: Default Setting for Calculation Ad Type AZ_RECHDEF TJH79 CHAR 2 0
XIKOHI_EXP IS-M: Ind. Present cont.comp.hierarchy in exploded form XIKOHI_EXP CHAR 1 0
X Yes
NULL No
XHIDE_SVO IS-M: Give Preference to Cont.Comps in Ad Section Indicator XHIDE_SVO CHAR 1 0
X Yes
NULL No
XALLIKO_SV IS-M: No Plausibility Check for Special Publication XALLIKO_SV CHAR 1 0
X Yes
NULL No
XNOFLTR_BE IS-M/AM: Indicator Do not filter dates for additional BUs XNOFLTR_BE CHAR 1 0
X Yes
NULL No
XDELCOL_GB Deduct Gutter Bleed Column for Calculation of Technical Size XDELCOL_GB CHAR 1 0
X Yes
NULL No
SI_ABRMNGE IS-M: Ad insert quantity for settlement ISM_SI_ABRMNGE CHAR 1 0
1 Amount available (planned quantity updated if required)
2 Calculation quantity from order item details
3 Delivery quantity
4 CAO qty
SI_SHIPP_CHECK IS-M/AM: Check M/SD Shipping Preps when Creating AI Item JSI_SHIPP_CHECK CHAR 2 0
NULL No check
MS Success message
MI Message information
PR Display log
VT_ABRMNGE IS-M/AM: Distribution quantity for settlement ISM_VT_ABRMNGE CHAR 1 0
1 Amount available (planned quantity updated if required)
2 Calculation quantity from order item details
3 Delivery quantity (planned quantity + extra)
VT_SHIPP_CHECK IS-M/AM: Check M/SD shipping preps when creating DT item JVT_SHIPP_CHECK CHAR 2 0
NULL No check
MS Success message
MI Message information
PR Display log
XKONKAUSAZ IS-M: Competitor Exclusion Active for Ad Items? XKONKAUSAZ CHAR 1 0
X Yes
NULL No
XKONKAUSDI IS-M: Competitor Exclusion Active for Service Item? XKONKAUSDI CHAR 1 0
X Yes
NULL No
XKONKAUSSI IS-M: Competitor Exclusion Active for AI Item? XKONKAUSSI CHAR 1 0
X Yes
NULL No
XKONKAUSWS IS-M: Competitor Exclusion Active for Commercial Item? XKONKAUSWS CHAR 1 0
X Yes
NULL No
XKONKAUSVT IS-M/AM: Competitor Exclusion is Active for DT Item XKONKAUSVT CHAR 1 0
X Yes
NULL No
XVZ_GLEICH IS-M: Equal Distribution Of Sales Agent Commission XVZ_GLEICH CHAR 1 0
X Yes
NULL No
XVZ_PBAS Divide Commission Basis For Sales Agent Commission Indicator XVZ_PBAS CHAR 1 0
X Yes
NULL No
XVZ_BETRAG IS-M: Amount for Sales Agent Commission Division Indicator XVZ_BETRAG CHAR 1 0
X Yes
NULL No
BE_POPUP IS-M/AM: Control Voucher Copy Recipient Selection BE_POPUP CHAR 1 0
NULL Dialog box is always displayed
1 Dialog box for more than one voucher copy recipient per item
2 Dialog box for more than one BU and for agency order
3 Dialog box is never displayed
CHTYPE_AVM IS-M/AM: Order Change Type CHTYPE_AVM TJHCHTYPE_AVM CHAR 2 0
OFF_WVL IS-M: Responses resubmission date (days after publ.date) OFF_WVL NUMC 2 0
XAAZUL_OUT IS-M: Deactivate ad type admissibility check XAAZUL_OUT CHAR 1 0
X Yes
NULL No
XPRDIAL_AZ IS-M: Pricing Dialog in Display Mode Only Indicator XPRDIAL_AZ CHAR 1 0
X Yes
NULL No
XVALUE_CHK IS-M: Check Value of Credit and Debit Memos XVALUE_CHK CHAR 1 0
X Yes
NULL No
BB_LADEN IS-M: Indicator Load Requirement Elements BB_LADEN CHAR 1 0
NULL Do not load
1 Only load for order maintenance
2 Only load for billing
3 Load for order maintenance and billing
XVFND_FAKT_EE IS-M: Sales Agent Determination for Billed Billing Datasets XVFND_FAKT_EE CHAR 1 0
X Yes
NULL No
KOVAR_BLGHNW IS-M/AM: Copying Variants for Insert Note KOVAR_BLGHNW TJHAKO CHAR 4 0
WKTYP_BLGHNW IS-M/AM: Combination Sale Type for Insert Note WKTYP_BLGHNW TJH91 CHAR 2 0
KOVAR_TRGANZ IS-M: Copying Variant for Carrier Ad KOVAR_TRGANZ TJHAKO CHAR 4 0
WKTYP_TRGANZ IS-M/AM: Combination Sale Type for Carrying Ad WKTYP_TRGANZ TJH91 CHAR 2 0
AVM_MOTHLP IS-M: Select Ad Spec Number in the Order AVM_MOTHLP CHAR 1 0
NULL Ad spec + note
1 Ad spec + key word
2 Ad spec + text header
BRANCHE_POPUP IS-M/AM: Industry Sector Dialog Box Required Indicator BRANCHE_POPUP CHAR 1 0
X Yes
NULL No
BRANCHE_GRPFKT IS-M/AM: Item Industry Sector Indicator for Billing Dataset BRANCHE_GRPFKT CHAR 1 0
X Yes
NULL No
XREKLBEARB_USR IS-M/AM: Complaint Processor Must Be User Indicator XREKLBEARB_USR CHAR 1 0
X Yes
NULL No
ERSTER_WOCHENTAG IS-M: First Day of the Week ISM_ERSTER_WOCHENTAG NUMC 1 0
0 Monday
1 Tuesday
2 Wednesday
3 Thursday
4 Friday
5 Saturday
6 Sunday
SPLIT_MSG_TYPE Message Type for Ad Size Check /NAM/SPLIT_MSG_TYPE CHAR 1 0
1 Error
2 Warning
NULL No Action
XPRGRP_ADV Pull Price Group from Advertiser /NAM/ISM_XPRGRP_ADV CHAR 1 0
X Yes
NULL No
XSRTWD_ADSP_LEV Store Sortword at Ad Spec Level /NAM/ISM_XSRTWD_ADSP_LEV CHAR 1 0
X Yes
NULL No

TJHVBER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TJHVBER AZART_RECH TJHVBER MANDT TJH79 IS-M/AM: Calculation Ad Type MANDT
TJHVBER AZART_RECH TJHVBER AZART_RECH TJH79 IS-M/AM: Calculation Ad Type AZART_RECH
TJHVBER CHTYPE_AVM TJHVBER MANDT TJHCHTYPE_AVM IS-M/AM: Order Change Type MANDT
TJHVBER CHTYPE_AVM TJHVBER CHTYPE_AVM TJHCHTYPE_AVM IS-M/AM: Order Change Type CHTYPE_AVM
TJHVBER HOEHE_DEH TJHVBER MANDT TJH61 IS-M/AM: Unit of Measure for Height MANDT
TJHVBER HOEHE_DEH TJHVBER HOEHE_DEH TJH61 IS-M/AM: Unit of Measure for Height ISPEINH_H
TJHVBER ISPEINH_PR TJHVBER MANDT TJH51 IS-M: Units of Measure for Ad Size (Quant.Dependnt Prices) MANDT
TJHVBER ISPEINH_PR TJHVBER ISPEINH_PR TJH51 IS-M: Units of Measure for Ad Size (Quant.Dependnt Prices) ISPEINH_PR
TJHVBER KOVAR_BLGHNW TJHVBER MANDT TJHAKO IS-M/AM: Copying Variants for Order Item with Template MANDT
TJHVBER KOVAR_BLGHNW TJHVBER KOVAR_BLGHNW TJHAKO IS-M/AM: Copying Variants for Order Item with Template KOPIERVAR
TJHVBER KOVAR_TRGANZ TJHVBER MANDT TJHAKO IS-M/AM: Copying Variants for Order Item with Template MANDT
TJHVBER KOVAR_TRGANZ TJHVBER KOVAR_TRGANZ TJHAKO IS-M/AM: Copying Variants for Order Item with Template KOPIERVAR
TJHVBER MANDT TJHVBER MANDT T000 Clients MANDT
TJHVBER PERFK_DEF TJHVBER PERFK_DEF TFACD Factory calendar definition IDENT
TJHVBER SPART TJHVBER VKORG TVTA Organizational Unit: Sales Area(s) VKORG
TJHVBER SPART TJHVBER VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
TJHVBER SPART TJHVBER SPART TVTA Organizational Unit: Sales Area(s) SPART
TJHVBER SPART TJHVBER MANDT TVTA Organizational Unit: Sales Area(s) MANDT
TJHVBER TERM_TYP TJHVBER TERM_TYP TJH55 IS-M/AM: Date Types TERM_TYP
TJHVBER TERM_TYP TJHVBER MANDT TJH55 IS-M/AM: Date Types MANDT
TJHVBER VKORG TJHVBER VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
TJHVBER VKORG TJHVBER SPART TVTA Organizational Unit: Sales Area(s) SPART
TJHVBER VKORG TJHVBER MANDT TVTA Organizational Unit: Sales Area(s) MANDT
TJHVBER VKORG TJHVBER VKORG TVTA Organizational Unit: Sales Area(s) VKORG
TJHVBER VTWEG TJHVBER MANDT TVTA Organizational Unit: Sales Area(s) MANDT
TJHVBER VTWEG TJHVBER VKORG TVTA Organizational Unit: Sales Area(s) VKORG
TJHVBER VTWEG TJHVBER VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
TJHVBER VTWEG TJHVBER SPART TVTA Organizational Unit: Sales Area(s) SPART
TJHVBER WKTYP_BLGHNW TJHVBER MANDT TJH91 IS-M/AM: Combination Sale Type MANDT
TJHVBER WKTYP_BLGHNW TJHVBER WKTYP_BLGHNW TJH91 IS-M/AM: Combination Sale Type WKOMBI_TYP
TJHVBER WKTYP_TRGANZ TJHVBER MANDT TJH91 IS-M/AM: Combination Sale Type MANDT
TJHVBER WKTYP_TRGANZ TJHVBER WKTYP_TRGANZ TJH91 IS-M/AM: Combination Sale Type WKOMBI_TYP