SAP NTSP IS-H: Columns in Service Catalog Table data and field list

NTSP is a standard SAP Table which is used to store IS-H: Columns in Service Catalog data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The NTSP table consists of various fields, each holding specific information or linking keys about IS-H: Columns in Service Catalog data available in SAP. These include EINRI (Institution), TARIF (IS-H: Service Catalog Identification Key), TALST (Service in Service Catalog), TASPA (IS-H: Column in Service Catalog)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

NTSP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

SAP NTSP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the NTSP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
EINRI	Institution	EINRI	CHAR	4	TN01	ALPHA	EINRI	EIN
TARIF	IS-H: Service Catalog Identification Key	TARID	CHAR	2	TNK01	ALPHA	TARID	TAK
TALST	Service in Service Catalog	TARLS	CHAR	10	NTPK	ALPHA	TARLS	TAL
TASPA	IS-H: Column in Service Catalog	TARSP	CHAR	2	Assigned to domain	ALPHA	TARSP
ENDDT	IS-H: Valid-To Date of Record	RI_ENDDT	DATS	8			RI_DATUM
TWERT	IS-H: Value of Column in Service Catalog	TASPAWERT	CHAR	12		ALPHA	TASPAWERT
BEGDT	IS-H: Valid-From Date of Record	RI_BEGDT	DATS	8			RI_DATUM
MWST	IS-H: Value-Added Tax Indicator (Empty: no Value-Added Tax)	TASPA_MWST	CHAR	2	Assigned to domain		MWSKZ
LOEKZ	Deletion Flag/Indicator	RI_LOEKZ	CHAR	1			XFELD
LOUSR	User Who Deleted Record	RI_LOUSR	CHAR	12			USNAM
LODAT	Date of Deletion	RI_LODAT	DATS	8			RI_DATUM
ERDAT	IS-H: Date when Record Created	RI_ERDAT	DATS	8			RI_DATUM
ERUSR	IS-H: Name of Employee who Created Record	RI_ERNAM	CHAR	12			USNAM
UPDAT	IS-H: Date of Last Change	RI_UPDAT	DATS	8			RI_DATUM
UPUSR	IS-H: Name of Person who Last Changed Data	RI_UPNAM	CHAR	12			USNAM

Key field

Non-key field

< NTSI_SE_MAP - IS-H: Service Catalog Column Information NTST - IS-H: Text column information charge catalog >

How do I retrieve data from SAP table NTSP using ABAP code

The following ABAP code Example will allow you to do a basic selection on NTSP to SELECT all data from the table
DATA: WA_NTSP TYPE NTSP.

SELECT SINGLE *
FROM NTSP
INTO CORRESPONDING FIELDS OF WA_NTSP
WHERE...

How to access SAP table NTSP

Within an ECC or HANA version of SAP you can also view further information about NTSP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).