SAP Table TJH29

IS-M/AM: Ad Insert Type

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

TJH29 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SI_TYP IS-M: Ad Insert Type SITYP CHAR 2 0
XDRERZ IS-M: Ad insert type is a publication X_DRERZ CHAR 1 0
X Yes
NULL No
ISM_MTART IS-M: Material Type for Ad Inserts ISM_MTART T134 CHAR 4 0
ISM_MBRSH IS-M: Industry Sector for Ad Inserts ISM_MBRSH T137 CHAR 1 0
ISMPOSTALFORMAT Postal format of publication/postcard/other object KZPOSTFORM CHAR 1 0
B Bound insert (obsolete)
C Bound insert (no charge) (obsolete)
D Publication
E Electronic data carrier
P Postcard
S Object
T Object (3-5 mm)
U Object (6-10 mm)
V Object (11-20 mm)
W Object (21-30 mm)
Z Invoice, payment medium
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
ISMEXTENTUNIT Unit of Measure for Extent ISMEXTENTUNIT TJPEXTUNI UNIT 3 0

TJH29 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TJH29 ISMEXTENTUNIT TJH29 MANDT TJPEXTUNI Units of Measurement for Size MANDT
TJH29 ISMEXTENTUNIT TJH29 ISMEXTENTUNIT TJPEXTUNI Units of Measurement for Size ISMEXTENTUNIT
TJH29 ISM_MBRSH TJH29 MANDT T137 Industries for materials MANDT
TJH29 ISM_MBRSH TJH29 ISM_MBRSH T137 Industries for materials MBRSH
TJH29 ISM_MTART TJH29 MANDT T134 Material Types MANDT
TJH29 ISM_MTART TJH29 ISM_MTART T134 Material Types MTART
TJH29 MANDT TJH29 MANDT T000 Clients MANDT
TJH29 MEINS TJH29 MEINS T006 Units of Measurement MSEHI
TJH29 MEINS TJH29 MANDT T006 Units of Measurement MANDT