SAP ABAP Table NVVP (IS-H: Patient-related insurance relationship)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | NVVP | Table Relationship Diagram |
Short Description | IS-H: Patient-related insurance relationship |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | PATNR | PATNR | PATNR | CHAR | 10 | 0 | IS-H: Patient Number | NPAT | |
3 | LFDNR | LFDVV | LFDVV | NUMC | 3 | 0 | IS-H: Sequence Number of Insurance Relationship | ||
4 | KOSTR | KH_KOSTR | RI_KUNNR | CHAR | 10 | 0 | IS-H: Insurance Provider | NGPA | |
5 | SELKZ | SELBZ_KZ | SELBZ_KZ | CHAR | 1 | 0 | IS-H: Indicator for self-payer/copayer ins.relation. | ||
6 | MGART | MITART_VER | MITART_VER | CHAR | 1 | 0 | IS-H: Type of Insurance Coverage | * | |
7 | UNTGR | UNTGR | UNTGR | CHAR | 2 | 0 | IS-H: Insurance Subgroup | * | |
8 | VERNR | VERSNR | CHAR20 | CHAR | 20 | 0 | IS-H: Patient Health Insurance Number | ||
9 | VERAB | BEGDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-From Date of Insurance Relationship | ||
10 | VERBI | ENDDTVVP | RI_DATUM | DATS | 8 | 0 | IS-H: Valid-to Date of Insurance Relationship | ||
11 | VERGE | VERGE | GSCHL | CHAR | 1 | 0 | IS-H: Sex of Person Insured | ||
12 | VERNN | VERNN | TEXT30 | CHAR | 30 | 0 | Last Name of Insured Person | ||
13 | VERVN | VERVN | TEXT30 | CHAR | 30 | 0 | First Name of Insured Person | ||
14 | VERAN | RI_ANRDS | RI_ANRDS | CHAR | 2 | 0 | IS-H: Form-of-Address Key | * | |
15 | VERTI | VERTI | TITEL | CHAR | 15 | 0 | Title of Insured Person | * | |
16 | VERNZ | VERNZ | TITEL | CHAR | 15 | 0 | Name Affix of Insured Person | * | |
17 | VERVW | VERVW | TITEL | CHAR | 15 | 0 | Name Prefix of Insured Person | * | |
18 | VERGB | VERGB | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Birth of Person Insured | ||
19 | VERLA | VERLA | LAND1 | CHAR | 3 | 0 | Country of Insured Person | T005 | |
20 | VERNA | ISH_NATIO | LAND1 | CHAR | 3 | 0 | IS-H: Nationality of Person | T005 | |
21 | VERPL | VERPLZ | PSTLZ | CHAR | 10 | 0 | Postal Code of Insured Person | ||
22 | VEROR | VERORT | TEXT25 | CHAR | 25 | 0 | City where Insured Person Resides | ||
23 | VERST | VERST | STRAS | CHAR | 30 | 0 | Street and House Number of Insured Person | ||
24 | VERTE | VERTE_D | TEXT16 | CHAR | 16 | 0 | Telephone Number of Insured Person | ||
25 | VERSV | VERSV | ISH_SVNUM | CHAR | 20 | 0 | Social Insurance Number of Insured Person | ||
26 | BERUF | BERUF | TEXT25 | CHAR | 25 | 0 | IS-H: Patient Occupation | ||
27 | AGNUM | KH_ARBGEB | RI_KUNNR | CHAR | 10 | 0 | IS-H: Employer | NGPA | |
28 | AGNAM | VERAGNA | TEXT30 | CHAR | 30 | 0 | Name of Insured Person's Employer | ||
29 | AGLAN | VERAGLA | LAND1 | CHAR | 3 | 0 | Country of Insured Person's Employer | T005 | |
30 | AGPLZ | VERAGPLZ | PSTLZ | CHAR | 10 | 0 | Postal Code of Insured Person's Employer | ||
31 | AGORT | VERAGORT | TEXT25 | CHAR | 25 | 0 | IS-H: City of Insured's Employer | ||
32 | AGSTR | VERAGSTR | STRAS | CHAR | 30 | 0 | IS-H: Street and Number of Insured's Employer | ||
33 | AGTEL | TELEFON_GP | TEXT16 | CHAR | 16 | 0 | IS-H: Telephone Number of Business Partner | ||
34 | SZDEB | SZ_DEBNR | KUNNR | CHAR | 10 | 0 | IS-H: Customer Number of Self-Payer in Financial Accounting | KNA1 | |
35 | KZTXT | TEXT_VVP | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Patient-Related Insurance Relationship | ||
36 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
37 | ERDAT | RI_ERDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date when Record Created | ||
38 | ERUSR | RI_ERNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Employee who Created Record | ||
39 | UPDAT | RI_UPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date of Last Change | ||
40 | UPUSR | RI_UPNAM | USNAM | CHAR | 12 | 0 | IS-H: Name of Person who Last Changed Data | ||
41 | STORN | RI_STORN | XFELD | CHAR | 1 | 0 | IS-H: Cancellation Indicator | ||
42 | STUSR | STORN_USER | USNAM | CHAR | 12 | 0 | IS-H: Name of User who Canceled Data Record | ||
43 | STDAT | STORN_DAT | RI_DATUM | DATS | 8 | 0 | Date of Cancellation | ||
44 | ABREE | ABWREMPF | XFELD | CHAR | 1 | 0 | Indicator Whether Alternative Invoice Recipient Exists | ||
45 | VKVST | ISH_VK_VST | TEXT4 | CHAR | 4 | 0 | Healthcare Smart Card - Status of Insured Person | ||
46 | VKVSE | ISH_VK_VSE | TEXT3 | CHAR | 3 | 0 | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ||
47 | VKNRA | ISH_VK_VKN | TEXT5 | CHAR | 5 | 0 | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ||
48 | RANGP | ISH_RANGP | ISH_RANGF | NUMC | 2 | 0 | IS-H: Ranking Order of Patient-Rel. Insurance Relationship | ||
49 | KVMAN | ISH_KVMAN | XFELD | CHAR | 1 | 0 | IS-H: Indicator that HCSC Data Entered Manually | ||
50 | VTRTY | ISH_VTRTY | ISH_VTRTY | CHAR | 6 | 0 | IS-H: Insurance Contract Scheme | * | |
51 | VKNUM | ISH_VK_KNR | TEXT7 | CHAR | 7 | 0 | Healthcare Smart Card - Health Insurer Number | ||
52 | KVDAT | ISH_KVDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Date Healthcare Smart Card Imported | ||
53 | VCEND | ISH_VK_END | RI_DATUM | DATS | 8 | 0 | IS-H: Healthcare Smart Card - Validity | ||
54 | VERVV | N1HVD | N1HVV | CHAR | 1 | 0 | IS-H: Relationship to Main Insured | TNVVA | |
55 | ADNHV | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | NADR | |
56 | ADOHV | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
57 | ADNAG | ISH_ADRNR | ISH_ADRNR | CHAR | 10 | 0 | IS-H: Address Number | NADR | |
58 | ADOAG | ISH_ADROBJ | ISH_ADROBJ | CHAR | 4 | 0 | IS-H: Address Object | ||
59 | VERGN | VERGN | TEXT30 | CHAR | 30 | 0 | IS-H: Name at Birth of Person Insured | ||
60 | VERSN | STCD1 | STCD1 | CHAR | 16 | 0 | Tax Number 1 | ||
61 | VCODE | ISH_VERSIONCODE | ISH_VERSIONCODE | CHAR | 2 | 0 | IS-H CA: Version Code for OHIP Health Number | ||
62 | XPRA | ISH_ON_OFF | ISH_ON_OFF | CHAR | 1 | 0 | IS-H: Boolscher Datentyp für ON (= 'X') und OFF (=' ') |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | NVVP | ADNAG | NADR | ADRNR | REF | 1 | CN |
2 | NVVP | ADNHV | NADR | ADRNR | REF | 1 | CN |
3 | NVVP | AGLAN | T005 | LAND1 | REF | 1 | CN |
4 | NVVP | AGNUM | NGPA | GPART | REF | 1 | CN |
5 | NVVP | KOSTR | NGPA | GPART | KEY | 1 | CN |
6 | NVVP | MANDT | T000 | MANDT | KEY | 1 | CN |
7 | NVVP | PATNR | NPAT | PATNR | KEY | 1 | CN |
8 | NVVP | SZDEB | KNA1 | KUNNR | REF | 1 | N |
9 | NVVP | VERLA | T005 | LAND1 | REF | 1 | CN |
10 | NVVP | VERNA | T005 | LAND1 | REF | 1 | CN |
11 | NVVP | VERVV | TNVVA | VERVA | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |