SAP Table RNDVV3

IS-H: Screen fields insurance relationship main person insrd

RNDVV3 (IS-H: Screen fields insurance relationship main person insrd) 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 RNDVV3 to other SAP tables.

RNDVV3 table fields

Field Data element Checktable Datatype Length Decimals
VERAN IS-H: Form-of-Address Short Text of Person Insured VERANREX CHAR 5 0
VERNN Last Name of Insured Person VERNN CHAR 30 0
VERTI Title of Insured Person VERTI CHAR 15 0
VERVN First Name of Insured Person VERVN CHAR 30 0
VERNZ Name Affix of Insured Person VERNZ CHAR 15 0
VERGB IS-H: Date of Birth of Person Insured VERGB DATS 8 0
VERVW Name Prefix of Insured Person VERVW CHAR 15 0
VERST Street and House Number of Insured Person VERST CHAR 30 0
GSCHLE IS-H: Sex Indicator - User-Specific GSCHLE CHAR 1 0
GSCHLTXT IS-H: Sex Specification - User-Specific TEXT_GES CHAR 10 0
VERPL Postal Code of Insured Person VERPLZ CHAR 10 0
VEROR City where Insured Person Resides VERORT CHAR 25 0
VERTE Telephone Number of Insured Person VERTE_D CHAR 16 0
VERLA Country of Insured Person VERLA T005 CHAR 3 0
LANDTXT Country Name LANDX CHAR 15 0
VERNA IS-H: Nationality of Person ISH_NATIO T005 CHAR 3 0
NATIO Nationality NATIO CHAR 15 0
VERSV Social Insurance Number of Insured Person VERSV CHAR 20 0
VERVV IS-H: Relationship to Main Insured N1HVD TNVVA CHAR 1 0
VERVV_TXT IS-H: Text for Relationship TEXT_VER CHAR 15 0
AGNUM IS-H: Employer KH_ARBGEB CHAR 10 0
BERUF IS-H: Patient Occupation BERUF CHAR 25 0
AGNAM Name of Insured Person's Employer VERAGNA CHAR 30 0
AGSTR IS-H: Street and Number of Insured's Employer VERAGSTR CHAR 30 0
AGPLZ Postal Code of Insured Person's Employer VERAGPLZ CHAR 10 0
AGORT IS-H: City of Insured's Employer VERAGORT CHAR 25 0
AGLAN Country of Insured Person's Employer VERAGLA T005 CHAR 3 0
AGLANTXT IS-H: Text for Employer's Country ISH_ALTXT CHAR 15 0
AGTEL IS-H: Telephone Number of Business Partner TELEFON_GP CHAR 16 0
ADRNR IS-H: Number of Address in General Address Management ISH_CADRNR CHAR 10 0
CPDKT IS-H: One-Time Account for Alternative Invoice Recipient ISH_CPDKTO CHAR 10 0
STREA IS-H: Address Entered with General Address Management ISH_STRGRA CHAR 1 0
X Yes
NULL No
ADNHV IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADOHV IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
ADNAG IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADOAG IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
VERGN IS-H: Name at Birth of Person Insured VERGN CHAR 30 0
VERSN Tax Number 1 STCD1 CHAR 16 0

RNDVV3 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RNDVV3 ADNAG RNDVV MANDT NADR IS-H: Addresses (Central Address Management) MANDT
RNDVV3 ADNAG RNDVV3 ADNAG NADR IS-H: Addresses (Central Address Management) ADRNR
RNDVV3 ADNAG RNDVV3 ADOHV NADR IS-H: Addresses (Central Address Management) ADROB
RNDVV3 ADNHV RNDVV MANDT NADR IS-H: Addresses (Central Address Management) MANDT
RNDVV3 ADNHV RNDVV3 ADNHV NADR IS-H: Addresses (Central Address Management) ADRNR
RNDVV3 ADNHV RNDVV3 ADOHV NADR IS-H: Addresses (Central Address Management) ADROB
RNDVV3 AGLAN RNDVV MANDT T005 Countries MANDT
RNDVV3 AGLAN RNDVV3 AGLAN T005 Countries LAND1
RNDVV3 VERLA RNDVV MANDT T005 Countries MANDT
RNDVV3 VERLA RNDVV3 VERLA T005 Countries LAND1
RNDVV3 VERNA RNDVV3 VERNA T005 Countries LAND1
RNDVV3 VERNA RNDVV MANDT T005 Countries MANDT
RNDVV3 VERVV RNDVV MANDT TNVVA IS-H: Relationship to main insured MANDT
RNDVV3 VERVV RNDVV3 VERVV TNVVA IS-H: Relationship to main insured VERVA