SAP ABAP View N_VGPADEB (IS-H: DB view containing only customers from NGPA and NDEB)
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_VGPADEB | |
Short Description | IS-H: DB view containing only customers from NGPA and NDEB | |
Root table | NGPA | IS-H: Business Partners |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | NGPA | NGPA | ||
2 | NDEB |
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 | NDEB | MANDT | JR | EQ | AND | 0 | 0 | |||
3 | NGPA | GPART | JL | EQ | 0 | 0 | ||||
4 | NDEB | DEBNR | JR | EQ | AND | 0 | 0 | |||
5 | NGPA | DEBIT | 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 | BUKRS | NDEB | BUKRS | BUKRS | Company Code | |||
4 | NAME1 | NGPA | NAME1 | GPNAM1 | IS-H: Last Name/ 1st Name | |||
5 | NAME2 | NGPA | NAME2 | GPNAM2 | IS-H: First Name / 2nd Name | |||
6 | PSTLZ | NGPA | PSTLZ | PSTLZ_GP | IS-H: Postal Code of Business Partner | |||
7 | ORT | NGPA | ORT | ORT_GP | IS-H: City of Business Partner | |||
8 | STRAS | NGPA | STRAS | STRASSE_GP | IS-H: Street Name and Street Number of Business Partner | |||
9 | GSCHL | NGPA | GSCHL | GSCHL | IS-H: Sex Indicator - Internal | |||
10 | GPAR | NGPA | GPAR | GPART | IS-H: Text Designating the General Business Partner Function | |||
11 | PERS | NGPA | PERS | PERS_D | IS-H: Text Designating the EMPLOYEE Function | |||
12 | KOSTR | NGPA | KOSTR | KOSTR | IS-H: Text Designating the INSURANCE PROVIDER Function | |||
13 | DEBIT | NGPA | DEBIT | DEBIT | Text Designating the CUSTOMER Function | |||
14 | ARBTG | NGPA | ARBTG | ARBTG | IS-H: Text Designating the EMPLOYER Function | |||
15 | KRKHS | NGPA | KRKHS | KRKHS | IS-H: Text Designating the HOSPITAL Function | |||
16 | RFDEB | NDEB | RFDEB | RF_KUNNR | Customer Number of FI Customer | |||
17 | LOEGP | NGPA | LOEKZ | RI_LOEKZ | Deletion Flag/Indicator | |||
18 | LOEDE | NDEB | LOEKZ | RI_LOEKZ | Deletion Flag/Indicator | |||
19 | NAM1S | NGPA | NAM1S | GPNAM1S | IS-H: Standardized Last Name of Business Partner | |||
20 | NAM2S | NGPA | NAM2S | GPNAM2S | Standardized First Name/2nd Name of Business Partner | |||
21 | KNAME | NGPA | KNAME | KZNAME | IS-H: Short Name of Business Partner | |||
22 | PFACH | NGPA | PFACH | PFACH_GP | IS-H: PO Box of Business Partner | |||
23 | PLZPF | NGPA | PLZPF | PLZPF_GP | IS-H: Postal Code for PO Box of Business Partner | |||
24 | ORTS | NGPA | ORTS | ORTS_GP | Standardized Name of City where Business Partner is Located | |||
25 | ORT2 | NGPA | ORT2 | ORT2_GP | District of Business Partner | |||
26 | SPVON | NGPA | SPVON | ISH_SPERRV | IS-H: Blocking Date from (Entry Block) | |||
27 | SPBIS | NGPA | SPBIS | ISH_SPERRB | IS-H: Blocking Date To (Entry Block To) | |||
28 | KNAMS | NGPA | KNAMS | KZNAMS | Standard Short Name for Search | |||
29 | ADRNR | NGPA | ADRNR | ISH_ADRNR | IS-H: Address Number | |||
30 | PNUMB | NGPA | PNUMB | ISH_PNUMB | IS-H: External Partner Number | |||
31 | PARTNER_GUID | NGPA | PARTNER_GUID | ISH_PARTNER_GUID | IS-H: GUID of Business Partner | |||
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 |