SAP ABAP Table RN2OPCD (IS-H*MED: Screen fields, surgical documentation)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NMED (Package) R/3MED: Medical documentation GSD
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NMED (Package) R/3MED: Medical documentation GSD
Basic Data
Table Category | INTTAB | Structure |
Structure | RN2OPCD | Table Relationship Diagram |
Short Description | IS-H*MED: Screen fields, surgical documentation |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
3 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
4 | FALAR | FALLART | FALLART | CHAR | 1 | 0 | IS-H: Case Type | ||
5 | PNAME | RI_NAME | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Name | ||
6 | GBDAT | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
7 | ALTERP | N2_ALTERP | N2_ANZUANZ | NUMC | 3 | 0 | Patient Age | ||
8 | ALTEINH | N2_ALTEINH | N2_ALTEINH | CHAR | 1 | 0 | Unit of Age | ||
9 | GSCHLE | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | TN17G | |
10 | OPDAT | N2_OPDATUM | N2_DATUM | DATS | 8 | 0 | OR: Operation Date | ||
11 | OPNR | N2_OPNR | N2_CHAR10 | CHAR | 10 | 0 | Surgery Number | ||
12 | ANFOE | ANFOE | ORGID | CHAR | 8 | 0 | IS-H: Departmental Org. Unit Requesting Service | * | |
13 | ANPOE | ANPOE | ORGID | CHAR | 8 | 0 | IS-H: Nursing Org. Unit Requesting Service | * | |
14 | ERBOE | ERBOE | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit that Performs the Service | * | |
15 | ERBOE1 | ERBOE | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit that Performs the Service | * | |
16 | OPINFO1 | N2_CHAR115 | N2_CHAR115 | CHAR | 115 | 0 | Character Field (Length 115) | ||
17 | OPINFO2 | N2_CHAR115 | N2_CHAR115 | CHAR | 115 | 0 | Character Field (Length 115) | ||
18 | DKAT | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | TNK00 | |
19 | DKEY | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
20 | DKAT1 | DIAKAT | KATID | CHAR | 2 | 0 | IS-H: Identification Key of Diagnosis Coding Catalog | TNK00 | |
21 | DKEY1 | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
22 | HDIA | N2_HOPDIA | XFELD | CHAR | 1 | 0 | Principal Diagnosis of a Surgery | ||
23 | DITXT | ISH_DITEXT | TEXT50 | CHAR | 50 | 0 | IS-H: Free-Text Diagnosis | ||
24 | DITXT1 | ISH_DITEXT | TEXT50 | CHAR | 50 | 0 | IS-H: Free-Text Diagnosis | ||
25 | DILTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
26 | DILTX1 | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
27 | DIALO | N2_DIALO | N2_DIALO | CHAR | 2 | 0 | IS-H: Localization of Diagnosis | * | |
28 | DIALO1 | N2_DIALO | N2_DIALO | CHAR | 2 | 0 | IS-H: Localization of Diagnosis | * | |
29 | DIAGW | N2_DIASI | N2_DIASI | CHAR | 2 | 0 | Diagnostic Certainty | * | |
30 | DIAGW1 | N2_DIASI | N2_DIASI | CHAR | 2 | 0 | Diagnostic Certainty | * | |
31 | DIAZS | N2_DIAZS | N2_DIAZS | CHAR | 2 | 0 | Diagnostic Suppl. | * | |
32 | DIAZS1 | N2_DIAZS | N2_DIAZS | CHAR | 2 | 0 | Diagnostic Suppl. | * | |
33 | DTYP | ISH_ICD10_DIATYP | ISH_DIATYP | CHAR | 1 | 0 | Type for ICD-10 Diagnoses | ||
34 | DTYP1 | ISH_ICD10_DIATYP | ISH_DIATYP | CHAR | 1 | 0 | Type for ICD-10 Diagnoses | ||
35 | DLGTX | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
36 | ZUOPR | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
37 | DLGTX1 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
38 | DIA_DRG_SEQNO | ISH_DRG_DIA_NB | LFD_NR_DRG_DIA | NUMC | 6 | 0 | IS-H: Consecutive Numbering of DRG Diagnosis | ||
39 | DIA_DRG_SEQNO1 | ISH_DRG_DIA_NB | LFD_NR_DRG_DIA | NUMC | 6 | 0 | IS-H: Consecutive Numbering of DRG Diagnosis | ||
40 | DIA_DRG_CAT | ISH_DRG_DIA_CATEGORY | ISH_DRG_DIA_CAT_TYPE | CHAR | 1 | 0 | IS-H: Category of DRG Diagnosis (Principal, Secondary) | ||
41 | DIA_DRG_CAT1 | ISH_DRG_DIA_CATEGORY | ISH_DRG_DIA_CAT_TYPE | CHAR | 1 | 0 | IS-H: Category of DRG Diagnosis (Principal, Secondary) | ||
42 | DIA_DRG_CC | ISH_DRG_DIA_CC | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Comorbidity and Complication (DRG Diagnosis) | ||
43 | DIA_DRG_CC1 | ISH_DRG_DIA_CC | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Comorbidity and Complication (DRG Diagnosis) | ||
44 | DIA_DRG_REL | ISH_DRG_DIA_RELEVANT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Used to Determine DRG | ||
45 | DIA_DRG_REL1 | ISH_DRG_DIA_RELEVANT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Used to Determine DRG | ||
46 | DIA_CCL | ISH_CCL | ISH_CCL_TYPE | NUMC | 3 | 0 | IS-H: Complication Level of Diagnoses (for DRGs) | ||
47 | DIA_CCL1 | ISH_CCL | ISH_CCL_TYPE | NUMC | 3 | 0 | IS-H: Complication Level of Diagnoses (for DRGs) | ||
48 | ICD10_INFO | ISH_ICD10_INFO | TEXT50 | CHAR | 50 | 0 | IS-H: Output Field for Identifying Linked Diagnoses | ||
49 | DIA_ANZOP | ANZOP | NUM02 | NUMC | 2 | 0 | IS-H: Number of Surgeries Occasioned by Dept. Main Diagnosis | ||
50 | ICPML | ICPM_LS | TARLS | CHAR | 10 | 0 | IS-H: Surgical Procedure Code (Service) | * | |
51 | IDENT | N2_IDENT | CHAR08 | CHAR | 8 | 0 | Ident Number from External Coding Procedure | ||
52 | LSLOK | ISH_PROC_LOC | N2_DIALO | CHAR | 2 | 0 | IS-H: Localization of a Procedure | * | |
53 | LSLOK1 | ISH_PROC_LOC | N2_DIALO | CHAR | 2 | 0 | IS-H: Localization of a Procedure | * | |
54 | ICPMK | ICPM_ID | TARID | CHAR | 2 | 0 | IS-H: Identification of Surgical Procedure Coding Catalog | TNK01 | |
55 | ICPMK1 | ICPM_ID | TARID | CHAR | 2 | 0 | IS-H: Identification of Surgical Procedure Coding Catalog | * | |
56 | ICPML1 | ICPM_LS | TARLS | CHAR | 10 | 0 | IS-H: Surgical Procedure Code (Service) | * | |
57 | HAUST | TARID | TARID | CHAR | 2 | 0 | IS-H: Service Catalog Identification Key | * | |
58 | LEIST | TARLS | TARLS | CHAR | 10 | 0 | IS-H: Service in Service Catalog | * | |
59 | LEIST1 | TARLS | TARLS | CHAR | 10 | 0 | IS-H: Service in Service Catalog | * | |
60 | LEITX | ISH_PROCTEXT | ISH_CHAR50 | CHAR | 50 | 0 | IS-H: User-Defined Comment on Procedure | ||
61 | LEITX1 | ISH_PROCTEXT | ISH_CHAR50 | CHAR | 50 | 0 | IS-H: User-Defined Comment on Procedure | ||
62 | PRTXT | ISH_PROCTEXT | ISH_CHAR50 | CHAR | 50 | 0 | IS-H: User-Defined Comment on Procedure | ||
63 | PRTXT1 | ISH_PROCTEXT | ISH_CHAR50 | CHAR | 50 | 0 | IS-H: User-Defined Comment on Procedure | ||
64 | PRLTX | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
65 | PRLTX1 | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
66 | PLGTX | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
67 | PLGTX1 | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
68 | LSSTAE | N1LSSTAE | N1LSSTAE | CHAR | 3 | 0 | Service Status - User-Specific | * | |
69 | LSSTAE1 | N1LSSTAE | N1LSSTAE | CHAR | 3 | 0 | Service Status - User-Specific | * | |
70 | ICPHC | ICPM_HCODE | XFELD | CHAR | 1 | 0 | IS-H: Main Surgical Procedure Code | ||
71 | ANZOP | ISH_ANZOP | NUMC3 | NUMC | 3 | 0 | IS-H: Number of Additional Surgeries | ||
72 | PR_DRG_SEQNO | ISH_DRG_PROC_SEQNO | ISH_SEQNO | NUMC | 3 | 0 | IS-H: Entry Sequence of DRG-Relevant Procedure | ||
73 | PR_DRG_SEQNO1 | ISH_DRG_PROC_SEQNO | ISH_SEQNO | NUMC | 3 | 0 | IS-H: Entry Sequence of DRG-Relevant Procedure | ||
74 | PR_DRG_CAT | ISH_DRG_PROC_CATEGORY | ISH_DRG_PROC_CATEGORY | CHAR | 1 | 0 | IS-H: Category of DRG Procedure (Principal, Secondary) | ||
75 | PR_DRG_CAT1 | ISH_DRG_PROC_CATEGORY | ISH_DRG_PROC_CATEGORY | CHAR | 1 | 0 | IS-H: Category of DRG Procedure (Principal, Secondary) | ||
76 | PR_DRG_REL | ISH_DRG_PROC_RELEVANT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Indicator "Used to Determine DRG" | ||
77 | PR_DRG_REL1 | ISH_DRG_PROC_RELEVANT | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Indicator "Used to Determine DRG" | ||
78 | ZUODIA | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
79 | ZUOFPSE | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
80 | GPART | N1GPART | RI_KUNNR | CHAR | 10 | 0 | Person Performing Service | NGPA | |
81 | NAME | GPNAM1 | NAME | CHAR | 35 | 0 | IS-H: Last Name/ 1st Name | ||
82 | VORNAME | GPNAM2 | NAME | CHAR | 35 | 0 | IS-H: First Name / 2nd Name | ||
83 | GESNAME | TEXT_GPA | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Business Partner | ||
84 | TLGTX | ISH_LGTX03 | ISH_ICON | CHAR | 30 | 0 | Screen Field for Displaying Dynamic Icon | ||
85 | AUFGABE | N1VORGANG | N1VORGANG | CHAR | 4 | 0 | Task | N1AUFGA | |
86 | TEXT | N1TXT30 | N1C030 | CHAR | 30 | 0 | Task Name | ||
87 | BEGDT | RI_BEGDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Record | ||
88 | ENDDT | RI_ENDDT | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-To Date of Record | ||
89 | BEGZT | N1BZT_LSMA | UHRZT | TIMS | 6 | 0 | Service Start Time/Employee Assignment | ||
90 | ENDZT | N1EZT_LSMA | UHRZT | TIMS | 6 | 0 | Completion Time of Service/Employee Assignment | ||
91 | ZUOOPL | CHAR30 | CHAR30 | CHAR | 30 | 0 | 30 Characters | ||
92 | AVBNA | N2_SKOMPL | N2_SKOMPL | CHAR | 4 | 0 | Complication code | N2KOK | |
93 | AVBS | N2_GRADAVD | N2_STUFEKO | CHAR | 3 | 0 | Severity of the Complications | ||
94 | AVBZP | N2_ZTKOMP | N2_ZTKOMP | CHAR | 2 | 0 | Time when Complication Occurred | ||
95 | AVBTEXT | N2_KOMPLTX | TEXT50 | CHAR | 50 | 0 | Description of Complication | ||
96 | AVBD | N2_DATE | AS4DATE | DATS | 8 | 0 | Application Storage Date | ||
97 | AVBU | N2_TIME | AS4TIME | TIMS | 6 | 0 | Time at Which Last Change Was Saved | ||
98 | ICDKY | DIAID | DIAID | CHAR | 30 | 0 | IS-H: Diagnosis Code | ||
99 | MARK1 | MARK | XFELD | CHAR | 1 | 0 | Indicator: posting line selected? | ||
100 | MARK2 | MARK | XFELD | CHAR | 1 | 0 | Indicator: posting line selected? | ||
101 | MARK3 | MARK | XFELD | CHAR | 1 | 0 | Indicator: posting line selected? | ||
102 | PR_ICPML_REF | ICPML_REF | TARLS | CHAR | 10 | 0 | IS-H: ID of Official Surgical Procedure Code | * | |
103 | PR_ENTGA | ENTGART | ENTGART | CHAR | 2 | 0 | IS-H: Charge Type for Service | ||
104 | PR_OPLEBSPEN | ISH_OPLEBSPEN | XFELD | CHAR | 1 | 0 | OPS Living Donor Transplantation |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RN2OPCD | AUFGABE | N1AUFGA | VORGANG | |||
2 | RN2OPCD | AVBNA | N2KOK | ISHM_KOMSC | 1 | CN | |
3 | RN2OPCD | DKAT | TNK00 | KATID | REF | 1 | CN |
4 | RN2OPCD | DKAT1 | TNK00 | KATID | REF | 1 | CN |
5 | RN2OPCD | EINRI | TN01 | EINRI | |||
6 | RN2OPCD | FALNR | NFAL | FALNR | |||
7 | RN2OPCD | GPART | NGPA | GPART | |||
8 | RN2OPCD | GSCHLE | TN17G | GSCHLE | |||
9 | RN2OPCD | ICPMK | TNK01 | KATID | REF | C | CN |
10 | RN2OPCD | MANDT | T000 | MANDT |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |