1. Home
  2. Resources
  3. SAP Tables
  4. JHAPS - IS-M/AM: OPM Ad Insert Item

SAP Table JHAPS

IS-M/AM: OPM Ad Insert Item

JHAPS (IS-M/AM: OPM Ad Insert Item) 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 JHAPS to other SAP tables.

JHAPS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
AVM_NR IS-M/AM: Sales Document Number AVM_NR JHAK CHAR 10 0
POS_NR IS-M: Order Item Number POS_NR JHAP NUMC 3 0
BEARB IS-M: Ad Insert Processing Type SINSBEARB TJH03 CHAR 2 0
BLGMENGE IS-M: Delivery Quantity for Ad Insert BLGMGE_PAM DEC 9 0
TZUSMENGE IS-M: Additional Tech.Quantity in % (Ad Insert) TZUSMENGE DEC 5 2
DISPMENGE IS-M: Planning Quantity for Ad Inserts DSPMGE_PAM DEC 9 0
BERMENGE IS-M: Calculation Quantity (Ad Insert) BERMENGE DEC 9 0
XBERMENGE_FIX IS-M/AM: Calculation Quantity is Fixed indicator JXBERMENGE_FIX CHAR 1 0
X Yes
NULL No
POSTMENGE IS-M: Postal Circulation Quantity POSTMENGE DEC 9 0
SIMENGE_RH IS-M: Non-Reader Circulation for TMC DSPMGE_RH DEC 9 0
MUSTER_T IS-M: Number of Samples (Technical) MUSTER_T NUMC 4 0
MUSTER_P IS-M: Number of Samples for Trial Runs (Ad Insert) MUSTER_P NUMC 4 0
XFREMDBEIL IS-M: Indicator - subject to postal charges (ad insert) XFREMDBEIL CHAR 1 0
X Yes
NULL No
XBEILAGHW IS-M: Insert Note Required Indicator XBLGHINW CHAR 1 0
X Yes
NULL No
XRESTHSHLT IS-M: Total Market Coverage XRESTHSHLT CHAR 1 0
X Yes
NULL No
RESTHSHLT_DATUM IS-M: Alternative Date for Total Market Coverage ISM_DELTA_COVERAGE_DATE DATS 8 0
XTRANZ IS-M: Carrier Ad Required Indicator XTRANZEIGE CHAR 1 0
X Yes
NULL No
XTBEL_SI IS-M: Selective Booking of an AI BU XTBEL_SI CHAR 1 0
X Yes
NULL No
SI_TYP IS-M: Ad Insert Type SITYP TJH29 CHAR 2 0
SI_GEWICHT IS-M: Ad Insert Weight ISM_SI_GEWICHT QUAN 9 3
MEINHGEWBL IS-M: Unit of Weight for Ad Insert MEINHGEWBL T006 UNIT 3 0
SI_ENTSPFL IS-M: Waste Disposal Required Indicator ISM_SI_ENTSPFL CHAR 1 0
X Yes
NULL No
SI_VERBWER IS-M: Tie-In Ads Indicator ISM_SI_VERBWER CHAR 1 0
X Yes
NULL No
ANZSEITEN Number of Pages in Issue ANZSEITEN NUMC 8 0
TERM_TYP IS-M/AM: Date Category Copy Number/Publication Date TERMINTYP TJH55 CHAR 1 0
ANFANG_PER IS-M: Start of Copy/Publication Date Period ANFANG_PER CHAR 14 0
ENDE_PER IS-M: End of Period - Issue/Publication Date ENDE_PER CHAR 14 0
SELDAT_VON IS-M: Start Date for Item SELDAT_VON DATS 8 0
SELDAT_BIS IS-M: End Date for Items SELDAT_BIS DATS 8 0
BIS_PLUS IS-M: Indicates a Period ("-") or 2 Dates ("+") BIS_PLUS CHAR 1 0
- Period
+ Individual dates
ANZ_SCHALT IS-M: Number of Placements ANZ_SCHALT NUMC 3 0
TERM_ZYKL IS-M: Frequency for Ad Publication ANZ_ZYKLUS TJJ57 CHAR 4 0
TERMINART IS-M/AM: Type of Publication Date TERMINART CHAR 1 0
S Standby Date
R Moveable Date
W Till Forbid
ERSCH_T IS-M: Publication Date ERSCH_T DATS 8 0
WUNSCH_T IS-M/AM: Date Required WUNSCH_T DATS 8 0
X_MONTAG IS-M: Date Field Indicator - Monday JHT_MONTAG CHAR 1 0
X Yes
NULL No
X_DIENSTAG IS-M: Date Field Indicator - Tuesday JHT_DIENSTAG CHAR 1 0
X Yes
NULL No
X_MITTWOCH IS-M: Date Field Indicator - Wednesday JHT_MITTWOCH CHAR 1 0
X Yes
NULL No
X_DONNERST IS-M: Date Field Indicator - Thursday JHT_DONNERST CHAR 1 0
X Yes
NULL No
X_FREITAG IS-M: Date Field Indicator - Friday JHT_FREITAG CHAR 1 0
X Yes
NULL No
X_SAMSTAG IS-M: Date Field Indicator - Saturday JHT_SAMSTAG CHAR 1 0
X Yes
NULL No
X_SONNTAG IS-M: Date Field Indicator - Sunday JHT_SONNTAG CHAR 1 0
X Yes
NULL No
XUVSI IS-M: Ad Insert Data Incomplete Indicator XUVSI CHAR 1 0
X Yes
NULL No
XSI_WARTET IS-M: Ad Insert Is On The Waiting List Indicator XSI_WARTET CHAR 1 0
X Yes
NULL No
XDISPOSITI IS-M: Planning Has Taken Place Indicator XDISPOSITI CHAR 1 0
X Yes
NULL No
XSI_PLAZ IS-M: Ad insert "positioned" indicator XSI_PLAZ CHAR 1 0
X Yes
NULL No
XMUSTER_OK IS-M: Sample Received and Checked Indicator XMUSTER_OK CHAR 1 0
X Yes
NULL No
XSI_VORH IS-M: AI Copies Exist XSI_VORH CHAR 1 0
X Yes
NULL No
XUVTECH IS-M: Incomplete Regarding Technical System (Gen.) XUVTECH CHAR 1 0
X Yes
NULL No
XTECH_MIN1 IS-M: Tech.process.started (for at least 1 schedule line) XTECH_MIN1 CHAR 1 0
X Yes
NULL No
XTECH_EE IS-M: Tech.Complete (All Schedule Lines Fully Processed) XTECH_EE CHAR 1 0
X Yes
NULL No
MERKMAL0 IS-M: Characteristic 0 for Individual Use (Ad Insert Item) MERK0_PS CHAR 1 0
X Yes
NULL No
MERKMAL1 IS-M: Characteristic 1 for Individual Use (Ad Insert Item) MERK1_PS CHAR 1 0
X Yes
NULL No
MERKMAL2 IS-M: Characteristic 2 for Individual Use (Ad Insert Item) MERK2_PS CHAR 1 0
X Yes
NULL No
MERKMAL3 IS-M: Characteristic 3 for Individual Use (Ad Insert Item) MERK3_PS CHAR 1 0
X Yes
NULL No
MERKMAL4 IS-M: Characteristic 4 for Individual Use (Ad Insert Item) MERK4_PS CHAR 1 0
X Yes
NULL No
MERKMAL5 IS-M: Characteristic 5 for Individual Use (Ad Insert Item) MERK5_PS CHAR 1 0
X Yes
NULL No
MERKMAL6 IS-M: Characteristic 6 for Individual Use (Ad Insert Item) MERK6_PS CHAR 1 0
X Yes
NULL No
MERKMAL7 IS-M: Characteristic 7 for Individual Use (Ad Insert Item) MERK7_PS CHAR 1 0
X Yes
NULL No
MERKMAL8 IS-M: Characteristic 8 for Individual Use (Ad Insert Item) MERK8_PS CHAR 1 0
X Yes
NULL No
MERKMAL9 IS-M: Characteristic 9 for Individual Use (Ad Insert Item) MERK9_PS CHAR 1 0
X Yes
NULL No
KONKAUS IS-M: Competitor exclusion KONKAUS TJH89 CHAR 2 0
KONKAUSKOM IS-M: Comment on competitor exclusion KONKAUSKOM CHAR 35 0
PRODH IS-M/AM: Product Hierarchy J_PRODH JJT179 CHAR 18 0
SORTWORT IS-M: Sort Word SORTWORT CHAR 10 0
STICHW IS-M: Keyword STICHW CHAR 40 0
INHK_KFM IS-M: Business Content Component INHK_KFM JJTIKO CHAR 8 0
XTEXT_INT IS-M: Internal positioning comment indicator XTEXT_INT CHAR 1 0
X Yes
NULL No
XTEXT_EXT IS-M: External positioning comment exists indicator XTEXT_EXT CHAR 1 0
X Yes
NULL No

JHAPS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
JHAPS AVM_NR JHAPS MANDT JHAK IS-M/AM: Order-Publishing-Media (Header Data) MANDT
JHAPS AVM_NR JHAPS AVM_NR JHAK IS-M/AM: Order-Publishing-Media (Header Data) AVM_NR
JHAPS BEARB SYST MANDT TJH03 IS-M/AM: Ad Insert Processing Types MANDT
JHAPS BEARB JHAPS BEARB TJH03 IS-M/AM: Ad Insert Processing Types BEARB
JHAPS INHK_KFM JHAPS MANDT JJTIKO IS-M/AM: Content Component MANDT
JHAPS INHK_KFM JHAPS INHK_KFM JJTIKO IS-M/AM: Content Component INHALTSKOM
JHAPS KONKAUS SYST MANDT TJH89 IS-M/AM: Competitor Exclusion MANDT
JHAPS KONKAUS JHAPS KONKAUS TJH89 IS-M/AM: Competitor Exclusion KONKAUS
JHAPS MANDT JHAPS MANDT T000 Clients MANDT
JHAPS MEINHGEWBL SYST MANDT T006 Units of Measurement MANDT
JHAPS MEINHGEWBL JHAPS MEINHGEWBL T006 Units of Measurement MSEHI
JHAPS POS_NR JHAPS POS_NR JHAP IS-M/AM: Order-Publishing-Media Item POS_NR
JHAPS POS_NR JHAPS MANDT JHAP IS-M/AM: Order-Publishing-Media Item MANDT
JHAPS POS_NR JHAPS AVM_NR JHAP IS-M/AM: Order-Publishing-Media Item AVM_NR
JHAPS PRODH JHAPS MANDT JJT179 IS-M/AM: Product Hierarchy MANDT
JHAPS PRODH JHAPS PRODH JJT179 IS-M/AM: Product Hierarchy PRODH
JHAPS SI_TYP SY MANDT TJH29 IS-M/AM: Ad Insert Type MANDT
JHAPS SI_TYP JHAPS SI_TYP TJH29 IS-M/AM: Ad Insert Type SI_TYP
JHAPS TERM_TYP SYST MANDT TJH55 IS-M/AM: Date Types MANDT
JHAPS TERM_TYP JHAPS TERM_TYP TJH55 IS-M/AM: Date Types TERM_TYP
JHAPS TERM_ZYKL SY MANDT TJJ57 IS-M/AM: Frequency Rule MANDT
JHAPS TERM_ZYKL JHAPS TERM_ZYKL TJJ57 IS-M/AM: Frequency Rule RHYTHMUS