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