SAP Table NLOP
IS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis
NLOP (IS-H:INACTIVE Assignment Table Service - SP Code - Diagnosis) 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 NLOP to other SAP tables.
NLOP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| EINRI | Institution | EINRI | TN01 | CHAR | 4 | 0 | ||||||
| FALNR | IS-H: Case Number | FALNR | NFAL | CHAR | 10 | 0 | ||||||
| LNRLS | IS-H: Service Sequence Number | LNRLS | CHAR | 10 | 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 | ||||||
| LNRDI | IS-H: Sequence Number of Diagnosis | LFDDIA | NUMC | 3 | 0 | |||||||
| ICDKT | IS-H: Identification Key of Diagnosis Coding Catalog | DIAKAT | TNK00 | CHAR | 2 | 0 | ||||||
| ICDKY | IS-H: Diagnosis Code | DIAID | NKDI | CHAR | 30 | 0 | ||||||
| ICPHC | IS-H: Main Surgical Procedure Code | ICPM_HCODE | CHAR | 1 | 0 |
Possible values
|
||||||
| ANZOP | IS-H: Number of Additional Surgeries | ISH_ANZOP | NUMC | 3 | 0 | |||||||
| LEIST | Service in Service Catalog | TARLS | CHAR | 10 | 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 | |||||||
| LSLOK | IS-H: Localization of Service | N1LSLOK | CHAR | 2 | 0 | |||||||
| IDENT | Ident Number from External Coding Procedure | N2_IDENT | CHAR | 8 | 0 | |||||||
| MIGKZ | IS-H: Checkbox to Select a Row | RI_MARK | CHAR | 1 | 0 |
Possible values
|
||||||
| MEDMIGKZ | IS-H: Checkbox to Select a Row | RI_MARK | CHAR | 1 | 0 |
Possible values
|
||||||
NLOP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| NLOP | EINRI | NLOP | MANDT | TN01 | IS-H: Institutions | MANDT |
| NLOP | EINRI | NLOP | EINRI | TN01 | IS-H: Institutions | EINRI |
| NLOP | FALNR | NLOP | MANDT | NFAL | IS-H: Cases | MANDT |
| NLOP | FALNR | NLOP | EINRI | NFAL | IS-H: Cases | EINRI |
| NLOP | FALNR | NLOP | FALNR | NFAL | IS-H: Cases | FALNR |
| NLOP | ICDKT | NLOP | MANDT | TNK00 | IS-H: Diagnosis Coding Catalog Categories | MANDT |
| NLOP | ICDKT | NLOP | ICDKT | TNK00 | IS-H: Diagnosis Coding Catalog Categories | KATID |
| NLOP | ICDKY | NLOP | ICDKY | NKDI | IS-H: Diagnosis Coding Catalogs | DKEY |
| NLOP | ICDKY | NLOP | MANDT | NKDI | IS-H: Diagnosis Coding Catalogs | MANDT |
| NLOP | ICDKY | SY | LANGU | NKDI | IS-H: Diagnosis Coding Catalogs | SPRAS |
| NLOP | ICDKY | NLOP | ICDKT | NKDI | IS-H: Diagnosis Coding Catalogs | DKAT |
| NLOP | ICPMK | NLOP | MANDT | TNK01 | IS-H: Service Catalog Types | MANDT |
| NLOP | ICPMK | NLOP | EINRI | TNK01 | IS-H: Service Catalog Types | EINRI |
| NLOP | ICPMK | NLOP | ICPMK | TNK01 | IS-H: Service Catalog Types | KATID |
| NLOP | ICPML | NLOP | MANDT | NTPK | IS-H: Header Data of Service Item | MANDT |
| NLOP | ICPML | NLOP | EINRI | NTPK | IS-H: Header Data of Service Item | EINRI |
| NLOP | ICPML | NLOP | ICPMK | NTPK | IS-H: Header Data of Service Item | TARIF |
| NLOP | ICPML | NLOP | ICPML | NTPK | IS-H: Header Data of Service Item | TALST |
| NLOP | MANDT | NLOP | MANDT | T000 | Clients | MANDT |
