1. Home
  2. Resources
  3. SAP Tables
  4. TJHAP - IS-M/AM: Order-Publishing-Media: Item Categories

SAP Table TJHAP

IS-M/AM: Order-Publishing-Media: Item Categories

TJHAP (IS-M/AM: Order-Publishing-Media: Item Categories) 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 TJHAP to other SAP tables.

TJHAP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PSTYV IS-M: Item Category for Sales Document PSTYV_PAM CHAR 4 0
VBTYP IS-M/AM: Sales Document Category ISPVBTYP CHAR 1 0
A Inquiry
B Offer
C Order
K Credit Memo Request
M Invoice
N Reverse Invoice
O Credit Memo
P Debit Memo
S Reverse Credit Memo
U Pro Forma Invoice (Not Used)
2 External Transaction
FK_REL IS-M: Relevance to Billing ISP_FKREL CHAR 1 0
X Yes
NULL No
PR_REL IS-M: Perform Pricing ISM_PRSFD CHAR 1 0
NULL Pricing is inactive
X Pricing active in the order and billing
1 Pricing only active in the order
XABSCHLREL IS-M: Contract Relevance XABSCHLREL CHAR 1 0
NULL No Contract Determination or Manual Assignments
X Contract Determination and Manual Assignments
Y Manual Assignments Only
XGE_GESCH IS-M: Barter Deal Indicator XGE_GESCH CHAR 1 0
X Yes
NULL No
XERLOESREL IS-M: "Relevant for Revenue Distribution" Indicator XERLOESREL CHAR 1 0
X Yes
NULL No
XPROV_REL Relevant To Sales Agent Commission Assignment Indicator XPROV_REL CHAR 1 0
X Yes
NULL No
XVABEINTER Only Calculate Commission Once All Schd.Lines Published Ind. XVABEINTER CHAR 1 0
X Yes
NULL No
VASPEINTER Block Sales Agent Settlmnt, if Not All sched.Lines Published VASPEINTER TVFS CHAR 2 0
XNOFIND IS-M/AM: Control Sales Agent Determination (Item Category) JHTAPVFIND CHAR 1 0
NULL Agent determination active in the order and billing
X Agent determination inactive
1 Agent determination only active in the order
XFORTSCHR IS-M: Relevant for Contract Update Indicator XFORTSCHR CHAR 1 0
X Yes
NULL No
XPROD_REL IS-M: Ad is Relevant to Production Indicator XPROD_REL CHAR 1 0
X Yes
NULL No
XPRODRELWS IS-M: Relevance to production of commercial indicator XPRODRELWS CHAR 1 0
X Yes
NULL No
XPRODRELSI IS-M: AI Relevant to Production Indicator XPRODRELSI CHAR 1 0
X Yes
NULL No
XPRODRELVT IS-M/AM: Distribution item relevant to production indicator XPRODRELVT CHAR 1 0
X Yes
NULL No
XPRODRELOL IS-M/AM: Relevance of online item to production XPRODRELOL CHAR 1 0
X Yes
NULL No
XDISPO_REL IS-M: Planning-Relevant Ads Indicator XDISPO_REL CHAR 1 0
X Yes
NULL No
XDSPREL_WS IS-M: Commercial Planning Relevance Indicator XDSPREL_WS CHAR 1 0
X Yes
NULL No
XDSPREL_SI IS-M: Ad Insert Planning Relevance Indicator XDSPREL_SI CHAR 1 0
X Yes
NULL No
XDSPREL_OL IS-M: Online Planning Relevance Indicator XDSPREL_OL CHAR 1 0
X Yes
NULL No
XSIDMNG_V IS-M/AM: Leading Sign for Ad Insert Planning XSIDMNG_V CHAR 1 0
NULL Count positively
X Count negatively
0 Counts as zero
XVTDMNG_V IS-M/AM: Leading Sign for Distribution Planning XVTDMNG_V CHAR 1 0
NULL Count positively
X Count negatively
0 Counts as zero
XFAKEINTER IS-M: Only Billable if all Schedule Lines Published XFAKEINTER CHAR 1 0
X Yes
NULL No
FASPEINTER IS-M: Billing Block if not all Schedule Lines Published FASPEINTER TVFS CHAR 2 0
XMENGE_N IS-M/AM: Quantity Sign for Contract Update XMENGE_N CHAR 1 0
NULL Count positively
X Count negatively
0 Counts as zero
XBETRG_N IS-M: Value amount negatively indicator XBETRG_N CHAR 1 0
X Yes
NULL No
XMAL_N IS-M: Number Leading Sign for Contract Update XMAL_N CHAR 1 0
NULL Count positively
X Count negatively
0 Counts as zero
XTEILGUTBE IS-M: Partial Credit Memo For A Basic Booking Unit Indicator XTEILGUTBE CHAR 1 0
X Yes
NULL No
PTYP_SEPAE IS-M: Item category for separate agency commission PTYP_SEPAE TJHAP CHAR 4 0
XUPOS_EDIT IS-M: Sub-Items Can Be Maintained Indicator XUPOS_EDIT CHAR 1 0
X Yes
NULL No
FAKSP IS-M: Billing Block PAM_FAKSP TVFS CHAR 2 0
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
XNOSIZE IS-M: Ad spec size is obsolete, only amount is relevant ind. XNOSIZE CHAR 1 0
X Yes
NULL No
KLIMP Check credit limit KLIMP CHAR 1 0
NULL No credit limit check
A Run simple credit limit check and warning message
B Rund simple redit limit check and error message
C Run simple credit limit check and delivery block
D Credit management: Automatic credit control
CMGRA Credit group sales order CMGRA T691D CHAR 2 0
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
XNOT_FOR_PTYP IS-M/AM: Do Not Use for Create with Item Category Indicator XNOT_FOR_PTYP CHAR 1 0
X Yes
NULL No
RRREL IS-M/AM: Revenue Recognition Category ISMRR_RELTYP CHAR 1 0
NULL Standard - No Revenue Recognition Process
B Service-Related, Order-Dependent Revenue Recognition
F Order-Dependent Revenue Recognition by Periods
E Service-Related, Billing-Dependent Revenue Recognition
INS_SERIES_ACTIV IS-M/AM: Series Creation Active Indicator ISM_INSERTION_SERIES_ACTIVE CHAR 1 0
X Yes
NULL No
PK_PSTYV_DET Type of Package Element Item Category Determination ISM_PK_PSTVY_DET CHAR 1 0
A Item Categories from the Package Configurator
B Item Categories from Customizing
NULL Package Element Item Category = Package Item Category
DEADLINE_RELV Relevant for Deadlines /NAM/XDEADLINE_RELEVANT CHAR 1 0
X Yes
NULL No

TJHAP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TJHAP CMGRA TJHAP MANDT T691D Credit groups for document types MANDT
TJHAP CMGRA TJHAP CMGRA T691D Credit groups for document types CRMGR_CM
TJHAP FAKSP TJHAP MANDT TVFS Billing: Reasons for Blocking MANDT
TJHAP FAKSP TJHAP FAKSP TVFS Billing: Reasons for Blocking FAKSP
TJHAP FASPEINTER TJHAP MANDT TVFS Billing: Reasons for Blocking MANDT
TJHAP FASPEINTER TJHAP FASPEINTER TVFS Billing: Reasons for Blocking FAKSP
TJHAP MANDT TJHAP MANDT T000 Clients MANDT
TJHAP PTYP_SEPAE TJHAP PTYP_SEPAE TJHAP IS-M/AM: Order-Publishing-Media: Item Categories PSTYV
TJHAP PTYP_SEPAE TJHAP MANDT TJHAP IS-M/AM: Order-Publishing-Media: Item Categories MANDT
TJHAP VASPEINTER TJHAP MANDT TVFS Billing: Reasons for Blocking MANDT
TJHAP VASPEINTER TJHAP VASPEINTER TVFS Billing: Reasons for Blocking FAKSP