SAP ABAP View N_VGPAPER (IS-H: DB view containing only persons from NGPA and NPER)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NBAS (Package) Appl. development Hospital System master data, catalogs
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NBAS (Package) Appl. development Hospital System master data, catalogs
Basic Data
View Type | D | Database View |
Database View | N_VGPAPER | |
Short Description | IS-H: DB view containing only persons from NGPA and NPER | |
Root table | NGPA | IS-H: Business Partners |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | NGPA | NGPA | ||
2 | NPER |
Join Conditions
# | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
---|---|---|---|---|---|---|---|---|---|---|
1 | NGPA | MANDT | JL | EQ | 0 | 0 | ||||
2 | NPER | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | NGPA | GPART | JL | EQ | 0 | 0 | ||||
4 | NPER | PERNR | JR | EQ | AND | 0 | 0 | |||
5 | NGPA | PERS | NE | ' ' | 0 | 0 | ||||
View Fields
# | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
---|---|---|---|---|---|---|---|---|
1 | MANDT | NGPA | MANDT | MANDT | Client | |||
2 | GPART | NGPA | GPART | GPARTNER | IS-H: Business Partner | |||
3 | NAME1 | NGPA | NAME1 | GPNAM1 | IS-H: Last Name/ 1st Name | |||
4 | NAME2 | NGPA | NAME2 | GPNAM2 | IS-H: First Name / 2nd Name | |||
5 | PSTLZ | NGPA | PSTLZ | PSTLZ_GP | IS-H: Postal Code of Business Partner | |||
6 | ORT | NGPA | ORT | ORT_GP | IS-H: City of Business Partner | |||
7 | GSCHL | NGPA | GSCHL | GSCHL | IS-H: Sex Indicator - Internal | |||
8 | GPAR | NGPA | GPAR | GPART | IS-H: Text Designating the General Business Partner Function | |||
9 | PERS | NGPA | PERS | PERS_D | IS-H: Text Designating the EMPLOYEE Function | |||
10 | KOSTR | NGPA | KOSTR | KOSTR | IS-H: Text Designating the INSURANCE PROVIDER Function | |||
11 | DEBIT | NGPA | DEBIT | DEBIT | Text Designating the CUSTOMER Function | |||
12 | ARBTG | NGPA | ARBTG | ARBTG | IS-H: Text Designating the EMPLOYER Function | |||
13 | KRKHS | NGPA | KRKHS | KRKHS | IS-H: Text Designating the HOSPITAL Function | |||
14 | ARZT | NPER | ARZT | ARZT | IS-H: Indicator that Person Is Physician | |||
15 | MAKZ | NPER | MAKZ | MAKZ_D | Is-H: Person is Employee | |||
16 | RPPKZ | NPER | RPPKZ | RPPKZ | IS-H: Personal Data Originates in HR System | |||
17 | PFLEG | NPER | PFLEG | PFLEG | IS-H: Indicator that Person is Nurse | |||
18 | BARZT | NPER | BARZT | BARZT | IS-H: Indicator that Person is External Physician | |||
19 | GBDAT | NPER | GBDAT | RI_GBDAT | IS-H: Birthdate | |||
20 | STRAS | NGPA | STRAS | STRASSE_GP | IS-H: Street Name and Street Number of Business Partner | |||
21 | LOEGP | NGPA | LOEKZ | RI_LOEKZ | Deletion Flag/Indicator | |||
22 | LOEPE | NPER | LOEKZ | RI_LOEKZ | Deletion Flag/Indicator | |||
23 | KNAME | NGPA | KNAME | KZNAME | IS-H: Short Name of Business Partner | |||
24 | NAM1S | NGPA | NAM1S | GPNAM1S | IS-H: Standardized Last Name of Business Partner | |||
25 | NAM2S | NGPA | NAM2S | GPNAM2S | Standardized First Name/2nd Name of Business Partner | |||
26 | ORTS | NGPA | ORTS | ORTS_GP | Standardized Name of City where Business Partner is Located | |||
27 | ORT2 | NGPA | ORT2 | ORT2_GP | District of Business Partner | |||
28 | SPVON | NGPA | SPVON | ISH_SPERRV | IS-H: Blocking Date from (Entry Block) | |||
29 | SPBIS | NGPA | SPBIS | ISH_SPERRB | IS-H: Blocking Date To (Entry Block To) | |||
30 | ARZTN | NPER | ARZTN | ARZTNR | IS-H: Identifier for a Physician | |||
31 | KNAMS | NGPA | KNAMS | KZNAMS | Standard Short Name for Search | |||
32 | ADRNR | NGPA | ADRNR | ISH_ADRNR | IS-H: Address Number | |||
33 | EXPNR | NPER | EXPNR | ISH_PERNR | IS-H: External Personnel Number | |||
34 | KVZUL | NPER | KVZUL | KV_ZULASS | IS-H: Physician Has External Accreditation | |||
35 | LIQBE | NPER | LIQBE | LIQ_BERECH | IS-H: Indicator that physician has internal accreditation | |||
36 | NIFNR | NPER | NIFNR | ISH_NIFNR | IS-H CH: NIF number | |||
37 | PNUMB | NGPA | PNUMB | ISH_PNUMB | IS-H: External Partner Number | |||
38 | PARTNER_GUID | NGPA | PARTNER_GUID | ISH_PARTNER_GUID | IS-H: GUID of Business Partner | |||
39 | FIXLANR | NPER | FIXLANR | ISH_LANR_FIX | Fixer Anteil der lebenslangen Arztnummer (Stellen 1-7) | |||
Maintenance Status
read only |
read and change |
Time-dependent views: like U, validity data like ' ' |
read, change, delete and insert |
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |