SAP ABAP Table ISH_NREDO (IS-H: Renewable Documents - View via DRAW, NDOC, NREDOMA)
Hierarchy
☛
IS-H (Software Component) SAP Healthcare
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ N_OUTPATIENT (Package) IS-H: SAP Ambulatory Care Management
⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
⤷ N_OUTPATIENT (Package) IS-H: SAP Ambulatory Care Management
Basic Data
Table Category | INTTAB | Structure |
Structure | ISH_NREDO | Table Relationship Diagram |
Short Description | IS-H: Renewable Documents - View via DRAW, NDOC, NREDOMA |
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 | DOKAR | DOKAR | DOKAR | CHAR | 3 | 0 | Document Type | * | |
2 | DOKNR | DOKNR | DOKNR | CHAR | 25 | 0 | Document number | * | |
3 | DOKVR | DOKVR | DOKVR | CHAR | 2 | 0 | Document version | ||
4 | DOKTL | DOKTL_D | DOKTL | CHAR | 3 | 0 | Document part | ||
5 | LFDDOK | LFDDOK | INT4_NOS | INT4 | 10 | 0 | Sequence Number of Document | ||
6 | .INCLUDE | 0 | 0 | IS-h: Renewable Documents Header Data | |||||
7 | PLAN_DURAT | ISH_REDO_PLANDUR | RI_DATUM | DATS | 8 | 0 | IS-H: Renewable Documents - Planned End | ||
8 | PLAN_DAYS | ISH_REDO_PLDAYS | INT4 | INT4 | 10 | 0 | IS-H: Renewable Documents - Planned Duration (Days) | ||
9 | PLAN_MONTHS | ISH_REDO_PLMONTHS | INT4 | INT4 | 10 | 0 | IS-H: Renewable Documents - Planned Duration (Months) | ||
10 | START_DATE | ISH_REDO_START_DATE | RI_DATUM | DATS | 8 | 0 | IS-H: Renewable Documents - Start Date | ||
11 | END_DATE | ISH_REDO_END_DATE | RI_DATUM | DATS | 8 | 0 | IS-H: Renewable Documents - End Date | ||
12 | CREA_DATE | ISH_REDO_CREA_DATE | RI_DATUM | DATS | 8 | 0 | IS-H: Renewable Documents - Determination Date | ||
13 | RESP_PERS | ISH_REDOMA_PERS | RI_KUNNR | CHAR | 10 | 0 | IS-H: Renewable Documents - Person Responsible | NGPA | |
14 | INITIAL_DOC | ISH_REDO_INITDOC | XFELD | CHAR | 1 | 0 | IS-H: Renewable Documents - Indicator for Initial Document | ||
15 | RENEWED_DOC | ISH_REDO_RENEWDOC | XFELD | CHAR | 1 | 0 | IS-H: Renewable Documents - Indicator for Renewed Document | ||
16 | END_DOC | ISH_REDO_ENDDOC | XFELD | CHAR | 1 | 0 | IS-H: Renewable Documents - Indicator for Final Document | ||
17 | KZTXT | ISH_REDO_KZTXT | ISH_REDO_KZTXT | CHAR | 40 | 0 | IS-H: Renewable Documents - Short Text | ||
18 | LGTXT | LANGU | SPRAS | LANG | 1 | 0 | Language Key | * | |
19 | DIAG_EXIST | ISH_REDO_DIAGEXIST | XFELD | CHAR | 1 | 0 | IS-H: Renewable Documents - Diagnoses Exist for WI | ||
20 | PLAN_KZ | ISH_REDO_PLANKZ | CHAR1 | CHAR | 1 | 0 | IS-H: Renewable Documents - Plan Indicator | ||
21 | .INCLUDE | 0 | 0 | IS-H: Renewable Documents - Patient Data | |||||
22 | NNAME | NNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Last Name | ||
23 | VNAME | VNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient First Name | ||
24 | GBDAT | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
25 | GBNAM | GBNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Birthname | ||
26 | ADRNR | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | * | |
27 | ADROB | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
28 | .INCLUDE | 0 | 0 | IS-H: Renewable Documents Insurance Relationship | |||||
29 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | * | |
30 | PATKZ | ISH_PATKZ | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Self-Payer Insurance Relationship | ||
31 | VERAB | BEGDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Insurance Relationship | ||
32 | VERNR | VERSNR | CHAR20 | CHAR | 20 | 0 | IS-H: Patient Health Insurance Number | ||
33 | VKNUM | ISH_VK_KNR | TEXT7 | CHAR | 7 | 0 | Healthcare Smart Card - Health Insurer Number | ||
34 | VKNRA | ISH_VK_VKN | TEXT5 | CHAR | 5 | 0 | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ||
35 | VKVST | ISH_VK_VST | TEXT4 | CHAR | 4 | 0 | Healthcare Smart Card - Status of Insured Person | ||
36 | VKVSE | ISH_VK_VSE | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ||
37 | VCEND | ISH_VK_END | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Validity | ||
38 | VERSV | VERSV | ISH_SVNUM | CHAR | 20 | 0 | Social Insurance Number of Insured Person | ||
39 | VERBI | ENDDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-to Date of Insurance Relationship | ||
40 | .INCLUDE | 0 | 0 | IS-H: Renewable Documents - Field Selection from DRAW | |||||
41 | DWNAM | DWNAM | DWNAM | CHAR | 12 | 0 | Name of person responsible | ||
42 | DOKST | DOKST | DOKST | CHAR | 2 | 0 | Document Status | * | |
43 | LOEDK | LOEDK | XFELD | CHAR | 1 | 0 | Deletion indicator | ||
44 | DTTRG | DTTRG | DTTRG | CHAR | 10 | 0 | Name of Data Carrier | * | |
45 | DAPPL | DAPPL | DAPPL | CHAR | 3 | 0 | Application | * | |
46 | DTTRG1 | DTTRG | DTTRG | CHAR | 10 | 0 | Name of Data Carrier | * | |
47 | VRLDAT | VRLDAT | DATUM | DATS | 8 | 0 | Due Date | ||
48 | RES1 | RESDRAW | CHAR14 | CHAR | 14 | 0 | Reserve field DRAW | ||
49 | RES2 | RESDRAW | CHAR14 | CHAR | 14 | 0 | Reserve field DRAW | ||
50 | RES3 | RESDRAW | CHAR14 | CHAR | 14 | 0 | Reserve field DRAW | ||
51 | RES4 | RESDRAW | CHAR14 | CHAR | 14 | 0 | Reserve field DRAW | ||
52 | .INCLUDE | 0 | 0 | IS-H: Fields of the NDOC Table | |||||
53 | ORGFORM | ORGFORM | ORGFORM | CHAR | 1 | 0 | IS-H: Organization Form for Medical Record Management | ||
54 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
55 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
56 | FALNR | FALNR | FALNR | CHAR | 10 | 0 | IS-H: Case Number | NFAL | |
57 | FALAR | FALLART | FALLART | CHAR | 1 | 0 | IS-H: Case Type | ||
58 | ORGFA | NZUWFA | ORGID | CHAR | 8 | 0 | IS-H: OU with Departmental Responsibility for Case | NORG | |
59 | ORGPF | NZUWPF | ORGID | CHAR | 8 | 0 | Organizational Unit Assigned to Case | NORG | |
60 | ORGLE | ERBOE | ORGID | CHAR | 8 | 0 | IS-H: Organizational Unit that Performs the Service | NORG | |
61 | ORGLA | ANPOE | ORGID | CHAR | 8 | 0 | IS-H: Nursing Org. Unit Requesting Service | NORG | |
62 | ANFID | ANFID | ANFID | NUMC | 8 | 0 | Identification of a Request (Number) | N1ANF | |
63 | ORGDO | ORGDO | ORGID | CHAR | 8 | 0 | Documenting Organizational Unit | NORG | |
64 | LEIST | TARLS | TARLS | CHAR | 10 | 0 | IS-H: Service in Service Catalog | NLEI | |
65 | LNRLS | LNRLS | LNRLS | CHAR | 10 | 0 | IS-H: Service Sequence Number | ||
66 | LFDBEW | LFDBEW | LFDBEW | NUMC | 5 | 0 | IS-H: Sequence Number of Movement | NBEW | |
67 | MITARB | N1MITARB | RI_KUNNR | CHAR | 10 | 0 | Employee Responsible | NGPA | |
68 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
69 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
70 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
71 | DTID | N2_DTID | N2_DTID | CHAR | 10 | 0 | Document Category ID | N2DT | |
72 | DTVERS | N2_VERS | N2_VERS | NUMC | 3 | 0 | Version Number | ||
73 | BERST | N2_BERST | NUMC01 | NUMC | 1 | 0 | Authorization level | ||
74 | BEZEB | BEZEB | BEZEB | CHAR | 1 | 0 | Reference Level of a Document | ||
75 | MEDOK | MEDOK | XFELD | CHAR | 1 | 0 | Indicator for a Medical Document | ||
76 | PCODE | N2_PCODE | CHAR4 | CHAR | 4 | 0 | Special Indicator (Presentation Code) | TN2FLAG | |
77 | DODAT | N2_DODAT | RI_DATUM | DATS | 8 | 0 | Document Date | ||
78 | DOTIM | N2_DOTIM | UHRZT | TIMS | 6 | 0 | Document Time | ||
79 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
80 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
81 | ERTIM | RI_ERTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time Record Created | ||
82 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
83 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
84 | UPTIM | RI_UPTIM | UHRZT | TIMS | 6 | 0 | IS-H: Time of Last Change | ||
85 | LOEKZ | RI_LOEKZ | XFELD | CHAR | 1 | 0 | Deletion Flag/Indicator | ||
86 | LOUSR | RI_LOUSR | USNAM | CHAR | 12 | 0 | IS-H: User who Deleted Record | ||
87 | LODAT | RI_LODAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Deletion | ||
88 | LOTIM | RI_LOTIM | UHRZT | TIMS | 6 | 0 | Deletion Time | ||
89 | STORELOC | N2_STORELOC | N2_STORELOC | CHAR | 1 | 0 | Storage Location / Archive | ||
90 | STORELOC2 | N2_STORELOC2 | N2_STORELOC2 | CHAR | 1 | 0 | Storage Location (Only Used Internally) | ||
91 | ARCHIV | ARCHIV_ID | ORGID | CHAR | 8 | 0 | IS-H: Organizational ID of the medical record archive | NORG | |
92 | STANDORT | ISH_ARCHST | BAUID | CHAR | 8 | 0 | IS-H: Building ID of building unit in the 'archive' OU | NBAU | |
93 | ROLLNO | ISH_ROLLNO | CHAR10 | CHAR | 10 | 0 | IS-H: Roll Number of a Micro Film | ||
94 | MICROF | ISH_MICROF | XFELD | CHAR | 1 | 0 | IS-H: Patient's medical record is microfilmed | ||
95 | EXTNR | ISH_DOCEXT | CHAR15 | CHAR | 15 | 0 | IS-H: External Medical Record/Document ID | ||
96 | INFOMR | ISH_INFOMR | TEXT50 | CHAR | 50 | 0 | IS-H: Informational Text for Medical Record | ||
97 | TEMPMR | ISH_TEMPMR | XFELD | CHAR | 1 | 0 | IS-H: Flags a Medical Record as Temporary Medical Record | ||
98 | ALBUM | ISH_ALBUM | CHAR10 | CHAR | 10 | 0 | IS-H: Album Id for microfilm | ||
99 | MFYEAR | ISH_MFYEAR | NUMC4 | NUMC | 4 | 0 | IS-H: Year Until when Data Archived on Microfilm | ||
100 | REDO_TYPE | ISH_REDO_TYPE | ISH_REDO_TYPE | CHAR | 10 | 0 | Renewable Document - Category of Renewable Document | ||
101 | REDO_KZ | ISH_REDO_KZ | XFELD | CHAR | 1 | 0 | IS-H: Indicator for Renewable Document Management | ||
102 | CASE_ARCHIVED | N2DOC_CASE_ARCHIVED | ISH_ON_OFF | CHAR | 1 | 0 | Case Archived | ||
103 | .INCLUDE | 0 | 0 | IS-H: Attribute Fields Address | |||||
104 | PSTLZ | ISH_PSTLZO | PSTLZ | CHAR | 10 | 0 | IS-H: Postal Code of City | ||
105 | LAND | ISH_LAND | LAND1 | CHAR | 3 | 0 | IS-H: Country | * | |
106 | REGIO | ISH_REGION | REGIO | CHAR | 3 | 0 | IS-H: Region (Federal State, Province, County) | * | |
107 | ORT | ISH_CITY1 | TEXT40 | CHAR | 40 | 0 | IS-H: City | ||
108 | ORT2 | ISH_CITY2 | TEXT40 | CHAR | 40 | 0 | IS-H: District | ||
109 | STRAS | ISH_STRASS | TEXT40 | CHAR | 40 | 0 | IS-H: Street | ||
110 | STRAZ | ISH_STRASZ | TEXT40 | CHAR | 40 | 0 | IS-H: Other Designation Qualifying the Address | ||
111 | EINZG | EINZGEBIET | EINZGEBIET | CHAR | 9 | 0 | IS-H: Geographical Area | ||
112 | PSTLP | ISH_PSTLZP | PSTLZ | CHAR | 10 | 0 | IS-H: Postal Code of P.O. Box | ||
113 | PFACH | ISH_POBOX | ISH_PFACH | CHAR | 10 | 0 | IS-H: Post Office Box | ||
114 | LANPF | ISH_LANDPB | LAND1 | CHAR | 3 | 0 | IS-H: Country of Post Office Box | * | |
115 | ORTPF | ISH_CITYPB | TEXT40 | CHAR | 40 | 0 | IS-H: PO Box City | ||
116 | PSTLF | ISH_PSTLZF | PSTLZ | CHAR | 10 | 0 | IS-H: Postal Code of Company (for Major Accounts) | ||
117 | TELNO | RNADR_TELEPHONE_TAB | TTYP | 0 | 0 | ||||
118 | FAXNR | ISH_FAXNR | CHAR30 | CHAR | 30 | 0 | Fax Number | ||
119 | FAXXT | ISH_FAXEXT | CHAR10 | CHAR | 10 | 0 | IS-H: Fax Number - Extension | ||
120 | TEXNR | ISH_TELETX | TEXT30 | CHAR | 30 | 0 | IS-H: Telex Number | ||
121 | BUILD | ISH_BUILD | TEXT10 | CHAR | 10 | 0 | IS-H: Block/House | ||
122 | FLOOR | ISH_FLOOR | TEXT10 | CHAR | 10 | 0 | IS-H: Block/House Level | ||
123 | ROOM | ISH_ROOM | TEXT10 | CHAR | 10 | 0 | IS-H: Unit Number | ||
124 | ISH_SMTPADR | AD_SMTPADR | CHAR | 241 | 0 | IS-H: Internet Mail (SMTP) Address |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ISH_NREDO | ANFID | N1ANF | ANFID | KEY | 1 | CN |
2 | ISH_NREDO | ARCHIV | NORG | ORGID | 1 | CN | |
3 | ISH_NREDO | DTID | N2DT | DTID | KEY | 1 | CN |
4 | ISH_NREDO | EINRI | TN01 | EINRI | KEY | 1 | CN |
5 | ISH_NREDO | FALNR | NFAL | FALNR | KEY | 1 | CN |
6 | ISH_NREDO | LEIST | NLEI | LEIST | KEY | 1 | CN |
7 | ISH_NREDO | LFDBEW | NBEW | LFDNR | KEY | 1 | CN |
8 | ISH_NREDO | MITARB | NGPA | GPART | KEY | 1 | CN |
9 | ISH_NREDO | ORGDO | NORG | ORGID | KEY | 1 | CN |
10 | ISH_NREDO | ORGFA | NORG | ORGID | KEY | 1 | CN |
11 | ISH_NREDO | ORGLA | NORG | ORGID | KEY | 1 | CN |
12 | ISH_NREDO | ORGLE | NORG | ORGID | KEY | 1 | CN |
13 | ISH_NREDO | ORGPF | NORG | ORGID | KEY | 1 | CN |
14 | ISH_NREDO | PATNR | NPAT | PATNR | KEY | 1 | CN |
15 | ISH_NREDO | PCODE | TN2FLAG | FLAGID | KEY | 1 | CN |
16 | ISH_NREDO | RESP_PERS | NGPA | GPART | KEY | 1 | CN |
17 | ISH_NREDO | STANDORT | NBAU | BAUID | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |