SAP NTSI Table in S/4 HANA - Service Catalog Column Information
NTSI is a standard SAP Table which is used to store Service Catalog Column Information data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NTSI table(ECC)
Delivery Class: S - System table, maint. only by SAP, change = modification
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: NTSI
NTSI table structure field list
Below is the full NTSI field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
EINRI | Institution | EINRI | CHAR | 4(0) | TNPA_INSTN | ALPHA | EINRI | EIN | ||
TARIF | Catalog Identification Key | TARID | CHAR | 12(0) | TNK01 | ALPHA | TARID | TAK | ||
TASPA | Column in Catalog | TARSP | CHAR | 2(0) | ALPHA | TARSP | ||||
ENDDT | Valid-To Date of Record | RI_ENDDT | DATS | 8(0) | RI_DATUM | |||||
BEGDT | Valid-From Date of Record | RI_BEGDT | DATS | 8(0) | RI_DATUM | |||||
WAERKZ | Currency Field Indicator | KZ_WAERS | CHAR | 1(0) | XFELD | |||||
SPTYP | Data Type for Service Catalog Column | TASPATYP | CHAR | 1(0) | TASPATYP | |||||
SPLEN | Length of the Column Value (Inc. Dec. Places) | TASPALEN | INT1 | 3(0) | INT1 | |||||
SPKOM | Number of Decimal Places for Service Catalog Column | TASPAKOM | INT1 | 3(0) | INT1 | |||||
RREGL | Reference to the Rounding Rule (Compare T6W15 RV) | RREGEL | CHAR | 2(0) | ALPHA | RREGEL | ||||
MWST | Value-Added Tax Indicator (Empty: no Value-Added Tax) | TASPA_MWST | CHAR | 2(0) | MWSKZ | |||||
LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1(0) | XFELD | |||||
LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12(0) | USNAM | |||||
LODAT | Date of Deletion | RI_LODAT | DATS | 8(0) | RI_DATUM | |||||
ERDAT | Date when Record Created | RI_ERDAT | DATS | 8(0) | RI_DATUM | |||||
ERUSR | Name of Employee who Created Record | RI_ERNAM | CHAR | 12(0) | USNAM | |||||
UPDAT | Date of Last Change | RI_UPDAT | DATS | 8(0) | RI_DATUM | |||||
UPUSR | Name of Person Who Last Changed Data | RI_UPNAM | CHAR | 12(0) | USNAM |
Search for further information about these or an SAP related objects