1. Home
  2. Resources
  3. SAP Tables
  4. NTSI - IS-H: Service catalog column information

SAP Table NTSI

IS-H: Service catalog column information

NTSI (IS-H: Service catalog column information) 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 NTSI to other SAP tables.

NTSI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
TARIF IS-H: Service Catalog Identification Key TARID TNK01 CHAR 2 0
TASPA IS-H: Column in Service Catalog TARSP CHAR 2 0
ENDDT IS-H: Valid-To Date of Record RI_ENDDT DATS 8 0
BEGDT IS-H: Valid-From Date of Record RI_BEGDT DATS 8 0
WAERKZ IS-H: Currency Field Indicator KZ_WAERS CHAR 1 0
X Yes
NULL No
SPTYP IS-H: Data Type for Service Catalog Column TASPATYP CHAR 1 0
C Alphanumerical column values
N Numerical column values
SPLEN IS-H: Length of the Column Value (Inc. Dec. Places) TASPALEN INT1 3 0
SPKOM IS-H: Number of Decimal Places for Service Catalog Column TASPAKOM INT1 3 0
RREGL Reference to the Rounding Rule (Compare T6W15 RV) RREGEL CHAR 2 0
MWST IS-H: Value-Added Tax Indicator (Empty: no Value-Added Tax) TASPA_MWST CHAR 2 0
LOEKZ Deletion Flag/Indicator RI_LOEKZ CHAR 1 0
X Yes
NULL No
LOUSR User Who Deleted Record RI_LOUSR CHAR 12 0
LODAT Date of Deletion RI_LODAT DATS 8 0
ERDAT IS-H: Date when Record Created RI_ERDAT DATS 8 0
ERUSR IS-H: Name of Employee who Created Record RI_ERNAM CHAR 12 0
UPDAT IS-H: Date of Last Change RI_UPDAT DATS 8 0
UPUSR IS-H: Name of Person who Last Changed Data RI_UPNAM CHAR 12 0

NTSI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NTSI EINRI NTSI MANDT TN01 IS-H: Institutions MANDT
NTSI EINRI NTSI EINRI TN01 IS-H: Institutions EINRI
NTSI MANDT NTSI MANDT T000 Clients MANDT
NTSI TARIF NTSI EINRI TNK01 IS-H: Service Catalog Types EINRI
NTSI TARIF NTSI TARIF TNK01 IS-H: Service Catalog Types KATID
NTSI TARIF NTSI MANDT TNK01 IS-H: Service Catalog Types MANDT