SAP ABAP View N_VMAARZT (IS-H: View containing employees and physicians only)
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_VMAARZT | |
Short Description | IS-H: View containing employees and physicians only | |
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 | ' ' | AND | 0 | 0 | |||
6 | NPER | MAKZ | NE | ' ' | AND | 0 | 0 | |||
7 | NPER | ARZT | 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 | |||
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 |