SAP ABAP View H_MNDEA (IS-H: Customer by Name and Indicators)
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 | H_MNDEA | |
Short Description | IS-H: Customer by Name and Indicators | |
Root table | NGPA | IS-H: Business Partners |
Table
# | Table Name | Foreign Table | Foreign Field | Foreign DIR |
---|---|---|---|---|
1 | NGPA | NGPA | ||
2 | NDEB | |||
3 | NADR |
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 | NADR | MANDT | JL | EQ | 0 | 0 | ||||
6 | NGPA | MANDT | JR | EQ | AND | 0 | 0 | |||
7 | NADR | ADRNR | JL | EQ | 0 | 0 | ||||
8 | NGPA | ADRNR | JR | EQ | AND | 0 | 0 | |||
9 | NADR | ADROB | JL | EQ | 0 | 0 | ||||
10 | NGPA | ADROB | JR | EQ | AND | 0 | 0 | |||
11 | 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 | NAME3 | NGPA | NAME3 | GPNAM3 | Third Name | |||
7 | GSCHL | NGPA | GSCHL | GSCHL | IS-H: Sex Indicator - Internal | |||
8 | RFDEB | NDEB | RFDEB | RF_KUNNR | Customer Number of FI Customer | |||
9 | LAND | NADR | LAND | ISH_LAND | IS-H: Country | |||
10 | PSTLZ | NADR | PSTLZ | ISH_PSTLZO | IS-H: Postal Code of City | |||
11 | ORT | NADR | ORT | ISH_CITY1 | IS-H: City | |||
12 | ORT2 | NADR | ORT2 | ISH_CITY2 | IS-H: District | |||
13 | STRAS | NADR | STRAS | ISH_STRASS | IS-H: Street | |||
14 | NAM1S | NGPA | NAM1S | GPNAM1S | IS-H: Standardized Last Name of Business Partner | |||
15 | NAM2S | NGPA | NAM2S | GPNAM2S | Standardized First Name/2nd Name 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 | 462 |