VNPIR SAP (Change Document Structure; Generated by RSSCD000) Structure details
Description: Change Document Structure; Generated by RSSCD000
Structure field list including key, data, relationships and ABAP select examples
VNPIR is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Change Document Structure; Generated by RSSCD000" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_VNPIR TYPE VNPIR.
The VNPIR table consists of various fields, each holding specific information or linking keys about Change Document Structure; Generated by RSSCD000 data available in SAP. These include MANDT (Client), PATNR (IS-H: Patient Number), LFDNR (IS-H: Sequence Number of Insurance Relationship), KOSTR (IS-H: Insurance Provider).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP VNPIR structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
LFDNR | IS-H: Sequence Number of Insurance Relationship | LFDVV | NUMC | 3 | LFDVV | ||||
KOSTR | IS-H: Insurance Provider | KH_KOSTR | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | KOT | |
PATKZ | IS-H: Indicator for Self-Payer Insurance Relationship | ISH_PATKZ | CHAR | 1 | XFELD | ||||
MGART | IS-H: Type of Insurance Coverage | MITART_VER | CHAR | 1 | TN16M | MITART_VER | |||
UNTGR | IS-H: Insurance Subgroup | UNTGR | CHAR | 2 | TN16C | ALPHA | UNTGR | ||
VERAB | IS-H: Valid-From Date of Insurance Relationship | BEGDTVVP | DATS | 8 | RI_DATUM | ||||
VERBI | IS-H: Valid-to Date of Insurance Relationship | ENDDTVVP | DATS | 8 | RI_DATUM | ||||
RANGF | IS-H: Ranking Order of Case-Rel. Insurance Relationships | ISH_RANGF | NUMC | 2 | RANGF | ISH_RANGF | |||
VKVST | Healthcare Smart Card - Status of Insured Person | ISH_VK_VST | CHAR | 4 | TEXT4 | ||||
VKVSE | IS-H: Healthcare Smart Card - Health Ins. Status Supplement | ISH_VK_VSE | CHAR | 3 | TEXT3 | ||||
VKNRA | IS-H: Healthcare Smart Card - Directory of Health Ins. No's | ISH_VK_VKN | CHAR | 5 | TEXT5 | ||||
VKNUM | Healthcare Smart Card - Health Insurer Number | ISH_VK_KNR | CHAR | 7 | TEXT7 | ||||
KVDAT | IS-H: Date Healthcare Smart Card Imported | ISH_KVDAT | DATS | 8 | RI_DATUM | ||||
VKMAN | IS-H: Indicator that HCSC Data Entered Manually | ISH_KVMAN | CHAR | 1 | XFELD | ||||
VCEND | IS-H: Healthcare Smart Card - Validity | ISH_VK_END | DATS | 8 | RI_DATUM | ||||
PCARD | IS-H: HC smart card - private card indicator (CfP) | ISH_VK_PKV | CHAR | 1 | XFELD | ||||
VERNR | IS-H: Patient Health Insurance Number | VERSNR | CHAR | 20 | CHAR20 | ||||
VERGE | IS-H: Sex of Person Insured | VERGE | CHAR | 1 | GSCHL | ||||
VERNN | Last Name of Insured Person | VERNN | CHAR | 30 | TEXT30 | ||||
VERVN | First Name of Insured Person | VERVN | CHAR | 30 | TEXT30 | ||||
VERAN | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | TN17U | RI_ANRDS | |||
VERTI | Title of Insured Person | VERTI | CHAR | 15 | T535N | TITEL | |||
VERNZ | Name Affix of Insured Person | VERNZ | CHAR | 15 | T535N | TITEL | |||
VERVW | Name Prefix of Insured Person | VERVW | CHAR | 15 | T535N | TITEL | |||
VERGB | IS-H: Date of Birth of Person Insured | VERGB | DATS | 8 | RI_DATUM | ||||
VERNA | IS-H: Nationality of Person | ISH_NATIO | CHAR | 3 | T005 | LAND1 | |||
VERSV | Social Insurance Number of Insured Person | VERSV | CHAR | 20 | ISH_SVNUM | ||||
VERVV | IS-H: Relationship to Main Insured | N1HVD | CHAR | 1 | TNVVA | N1HVV | |||
VERGN | IS-H: Name at Birth of Person Insured | VERGN | CHAR | 30 | TEXT30 | ||||
VERSN | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
ADNHV | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADOHV | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
BERUF | IS-H: Patient Occupation | BERUF | CHAR | 25 | TEXT25 | ||||
AGNUM | IS-H: Employer | KH_ARBGEB | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ABG | |
AGNAM | Name of Insured Person's Employer | VERAGNA | CHAR | 30 | TEXT30 | ||||
ADNAG | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ISH_ADRNR | ||
ADOAG | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
SZDEB | IS-H: Customer Number of Self-Payer in Financial Accounting | SZ_DEBNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEB | |
ABREE | Indicator Whether Alternative Invoice Recipient Exists | ABWREMPF | CHAR | 1 | XFELD | ||||
KZTXT | IS-H: Comment on Patient-Related Insurance Relationship | TEXT_VVP | CHAR | 50 | TEXT50 | ||||
LGTXT | Language Key | LANGU | LANG | 1 | T002 | ISOLA | SPRAS | ||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
VTRTY | IS-H: Insurance Contract Scheme | ISH_VTRTY | CHAR | 6 | TN16 | ALPHA | ISH_VTRTY | ||
VSCOD | IS-H CA: Version Code for OHIP Health Number | ISH_VERSIONCODE | CHAR | 2 | ISH_VERSIONCODE | ||||
ADRNR | IS-H: Number of Address in General Address Management | ISH_CADRNR | CHAR | 10 | Assigned to domain | ALPHA | CADRNR | ||
CPDKT | IS-H: One-Time Account for Alternative Invoice Recipient | ISH_CPDKTO | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
VKZML | IS-H: Health Insurance Card - Mobile Card Reader License No. | ISH_VK_ZML | NUMC | 3 | NUM3 | ||||
VAL_QUARTER | IS-H: Validity Quarter Start Date | ISH_VAL_QUARTER_BEGIN | DATS | 8 | |||||
VKTITEL | IS-H: Healthcare smart card - title | ISH_VK_TIT | CHAR | 15 | TEXT15 | ||||
VKVNAM | Healthcare Smart Card - First Name | ISH_VK_VNM | CHAR | 28 | TEXT28 | ||||
VKNZU | IS-H: Healthcare Smart Card - Name Affix | ISH_VK_NZU | CHAR | 15 | TEXT15 | ||||
VKNNAM | IS-H: Healthcare smart card - last name | ISH_VK_NAM | CHAR | 28 | TEXT28 | ||||
VKGBDAT | IS-H: Healthcare Smart Card - Date of Birth | ISH_VK_GBD | DATS | 8 | RI_DATUM | ||||
VKSTRAS | IS-H: Healthcare smart card - street | ISH_VK_STR | CHAR | 28 | TEXT28 | ||||
VKLAND | IS-H: Healthcare Smart Card - Country | ISH_VK_LAN | CHAR | 3 | TEXT3 | ||||
VKPLZ | IS-H: Healthcare Smart Card - Postal Code | ISH_VK_PLZ | CHAR | 7 | TEXT7 | ||||
VKORT | IS-H: Healthcare Smart Card - City | ISH_VK_ORT | CHAR | 23 | TEXT23 | ||||
LNCRD | Sequence Number of Health Insurance Card | ISH_LNCARD | NUMC | 10 | ISH_LNCARD | ||||
LNCRD_PAT | Sequence Number of Details for Health Insurance Card | ISH_LNCARD_DET | NUMC | 5 | |||||
LNCRD_INS | Sequence Number of Details for Health Insurance Card | ISH_LNCARD_DET | NUMC | 5 | |||||
VKUNKNOWN_GBDAT | Healthcare Smart Card: Exact Birthdate Unknown | ISH_VK_UNKNOWN_GBDAT | CHAR | 1 | ISH_UNKNOWN_GBDAT | ||||
VERNR_KVK | Insurance Number PPA Card | ISH_VERNR_KVK | CHAR | 20 | CHAR20 | ||||
/ISHFR/ELSASS | IS-H FR: Insurance Provider ALSACE | /ISHFR/ELSASS | CHAR | 1 | ISH_ON_OFF | ||||
/ISHFR/BAMO | IS-H FR: Case Can Be Billed to Social Insurance | /ISHFR/ISH_BAMO_EXT | CHAR | 2 | /ISHFR/TNWFR_BAO | /ISHFR/ISH_BAMO_EXT | |||
/ISHFR/IPCAT | IS-H FR: Special Coverage | /ISHFR/IPCAT | CHAR | 4 | /ISHFR/IPCAT | ||||
PFINV | NWCH_PROFORMA | CHAR | 1 | XFELD | |||||
MCDKZ | NWCH_MCDKZ | CHAR | 1 | NWCH_MCDKZ | |||||
IV_AU_LOCK | NWCH_IV_AUTOUPDATE_LOCK | CHAR | 1 | NWCH_IV_AUTOUPDATE_LOCK | |||||
IV_AU_LDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
IV_AU_LUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
CURNT | IS-H: Insurance Relationship is Proposal for New Case | ISH_NPIR_CURNT | CHAR | 1 | ISH_ON_OFF | ||||
KZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND |
Key field | Non-key field |
How do I retrieve data from SAP structure VNPIR using ABAP code?
As VNPIR is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VNPIR as there is no data to select.How to access SAP table VNPIR
Within an ECC or HANA version of SAP you can also view further information about VNPIR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects