SAP Table NICP

IS-H: Surgical Procedure Codes Performed

NICP (IS-H: Surgical Procedure Codes Performed) 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 NICP to other SAP tables.

NICP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LNRIC IS-H: Sequence Number of Surgical Procedure Code ISH_LNRIC CHAR 10 0
LFDBEW IS-H: Sequence Number of Movement LFDBEW NBEW NUMC 5 0
ICPMK IS-H: Identification of Surgical Procedure Coding Catalog ICPM_ID TNK01 CHAR 2 0
ICPML IS-H: Surgical Procedure Code (Service) ICPM_LS NTPK CHAR 10 0
ICPHC IS-H: Main Surgical Procedure Code ICPM_HCODE CHAR 1 0
X Yes
NULL No
ANZOP IS-H: Number of Additional Surgeries ISH_ANZOP NUMC 3 0
BGDOP IS-H: Date when Surgical Procedure Code Performed ISH_BEGDT_ICP DATS 8 0
BZTOP IS-H: Time when Surg. Procedure Code Performance Begins ISH_BEGZT_ICP TIMS 6 0
EZTOP IS-H: Time when Surgical Procedure was Completed ISH_ENDZT_ICP TIMS 6 0
LSLOK IS-H: Localization of a Procedure ISH_PROC_LOC TN26E CHAR 2 0
IDENT Identification from External System ISH_IDENT CHAR 20 0
OPART IS-H: Type of Surgery ISH_OPART TN14O CHAR 2 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
STORN IS-H: Cancellation Indicator RI_STORN CHAR 1 0
X Yes
NULL No
STUSR IS-H: Name of User who Canceled Data Record STORN_USER CHAR 12 0
STDAT Date of Cancellation STORN_DAT DATS 8 0
TCODE IS-H: Report Control: Transaction Code for Application ISH_TCODE CHAR 20 0
EINRI Institution EINRI TN01 CHAR 4 0
FALNR IS-H: Case Number FALNR NFAL CHAR 10 0
BTEXT IS-H: User-Defined Comment on Procedure ISH_PROCTEXT CHAR 50 0
EVENT IS-H: Event that Triggers Creation of Procedure PROC_EVENT NUMC 2 0
01 Manual Entry in Surgical Data Maintenance
02 Created by ISH_CASEPROCEDURE_CREATEMULTIP
03 Generated by ISHMED Service
04 Manual Entry in Case-Related Procedure Entry
05 Manual Entry in DRG Data Maintenance
06 Generated by Case-Related Material
07 Generated by Quantity-Based Single Procedures
08 Created by Action
90 Reserved for Customer
91 Reserved for Customer
92 Reserved for Customer
93 Reserved for Customer
94 Reserved for Customer
95 Reserved for Customer
96 Reserved for Customer
97 Reserved for Customer
98 Reserved for Customer
99 Reserved for Customer
OBJCT IS-H: Object that Created the Procedure PROC_OBJECT CHAR 10 0
DRG_SEQNO IS-H: Entry Sequence of DRG-Relevant Procedure ISH_DRG_PROC_SEQNO NUMC 3 0
DRG_CATEGORY IS-H: Category of DRG Procedure (Principal, Secondary) ISH_DRG_PROC_CATEGORY CHAR 1 0
P Principal Procedure
S Secondary procedure
NULL Not a DRG Procedure
DRG_RELEVANT IS-H: Indicator "Used to Determine DRG" ISH_DRG_PROC_RELEVANT CHAR 1 0
X On
NULL Off
BEMKZ Language Key SPRAS LANG 1 0
ORGFA IS-H: Departmental Organizational Unit of Procedure ISH_FACHOE_PROC CHAR 8 0
ORGPF IS-H: Date when Surgical Procedure Code Was Completed ISH_ERBOE_PROC CHAR 8 0
ENDOP IS-H: Date when Surgical Procedure Code Was Completed ISH_ENDDT_ICP DATS 8 0
PRTYP IS-H: Procedure Type ISH_PROC_TYPE CHAR 2 0
81 Quantity-Based OPS Codes
73 Mechanical Ventilation Duration
01 Entered after Final Billing
NULL Standard
EVTUP IS-H: Event that Caused Procedure to Be Modified PROC_EVTUP NUMC 2 0
01 Modified by ISH_CASEPROCEDURE_CHANGEMULTIP
02 Canceled by ISH_CASEPROCEDURE_CANCELMULTIP
06 Changed by Case-Related Material
07 Changed by Quantity-Based Single Procedure(s)
08 Changed by Action (Object Contains Rule Type)
90 Reserved for Customer
91 Reserved for Customer
92 Reserved for Customer
93 Reserved for Customer
94 Reserved for Customer
95 Reserved for Customer
96 Reserved for Customer
97 Reserved for Customer
98 Reserved for Customer
99 Reserved for Customer
OBJUP IS-H: Object That Caused Procedure to Be Modified PROC_OBJUP CHAR 10 0
TIMESTAMP Timestamp in Short Form (YYYYMMDDhhmmss) ISH_TIMESTAMP DEC 15 0
QUANTITY Procedure Quantity ISH_PROC_QUANTITY QUAN 20 8
UNIT Unit of Measure for Procedure ISH_PROC_UNIT T006 UNIT 3 0
LNRIC_REF Sequence Number of Reference Surgical Procedure Code ISH_LNRIC_REF CHAR 10 0
LNRLM IS-H MM: Sequence Number of Material Consumption ISH_LNRLP CHAR 10 0
DRG_IMPACT Impact of Procedure on DRG Determination ISH_PROC_DRG_IMPACT CHAR 2 0
CCL Complication Level of Procedure (for DRGs) ISH_CCL_PROC NUMC 3 0
000 No Severity
001 Minor Severity
002 Moderate Severity
003 Major Severity
004 Catastrophic Severity
OPLEBSPEN OPS Living Donor Transplantation ISH_OPLEBSPEN CHAR 1 0
X Yes
NULL No

NICP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NICP EINRI NICP MANDT TN01 IS-H: Institutions MANDT
NICP EINRI NICP EINRI TN01 IS-H: Institutions EINRI
NICP FALNR NICP MANDT NFAL IS-H: Cases MANDT
NICP FALNR NICP EINRI NFAL IS-H: Cases EINRI
NICP FALNR NICP FALNR NFAL IS-H: Cases FALNR
NICP ICPMK NICP ICPMK TNK01 IS-H: Service Catalog Types KATID
NICP ICPMK NICP MANDT TNK01 IS-H: Service Catalog Types MANDT
NICP ICPMK NICP EINRI TNK01 IS-H: Service Catalog Types EINRI
NICP ICPML NICP EINRI NTPK IS-H: Header Data of Service Item EINRI
NICP ICPML NICP ICPMK NTPK IS-H: Header Data of Service Item TARIF
NICP ICPML NICP ICPML NTPK IS-H: Header Data of Service Item TALST
NICP ICPML NICP MANDT NTPK IS-H: Header Data of Service Item MANDT
NICP LFDBEW NICP LFDBEW NBEW IS-H: Movements for Case LFDNR
NICP LFDBEW NICP MANDT NBEW IS-H: Movements for Case MANDT
NICP LFDBEW NICP EINRI NBEW IS-H: Movements for Case EINRI
NICP LFDBEW NICP FALNR NBEW IS-H: Movements for Case FALNR
NICP LSLOK NICP MANDT TN26E IS-H: Definition of Medical Localizations MANDT
NICP LSLOK NICP EINRI TN26E IS-H: Definition of Medical Localizations EINRI
NICP LSLOK NICP LSLOK TN26E IS-H: Definition of Medical Localizations DIALO
NICP MANDT NICP MANDT T000 Clients MANDT
NICP OPART NICP MANDT TN14O IS-H: Surgery Types MANDT
NICP OPART NICP EINRI TN14O IS-H: Surgery Types EINRI
NICP OPART NICP OPART TN14O IS-H: Surgery Types OPART
NICP UNIT NICP MANDT T006 Units of Measurement MANDT
NICP UNIT NICP UNIT T006 Units of Measurement MSEHI