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
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
Access
  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