SAP ABAP View ESD_ADCPO (EHS: View for table ADCP (SAP office))
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   EHS-SAF (Application Component) Product Safety
     CVDD (Package) EH&S: Report Shipping
Basic Data
View Type D Database View 
Database View ESD_ADCPO  
Short Description EHS: View for table ADCP (SAP office)    
Root table ADCP   Person/Address Assignment (Business Address Services) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 ADCP ADCP
2 ADRP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 ADCP CLIENT JL EQ 0 0
2 ADRP CLIENT JR EQ AND 0 0
3 ADCP PERSNUMBER JL EQ 0 0
4 ADRP PERSNUMBER JR EQ AND 0 0
5 ADRP PERS_GROUP EQ 'BC01' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT ADCP CLIENT   MANDT Client
2 NAME_LAST ADRP NAME_LAST   AD_NAMELAS Last name
3 NAME_FIRST ADRP NAME_FIRST   AD_NAMEFIR First name
4 DEPARTMENT ADCP DEPARTMENT   AD_DPRTMNT Department
5 PERS_GROUP ADRP PERS_GROUP   AD_GROUP_P Person Group (Key) (Business Address Services)
6 SO_KEY ADCP SO_KEY   AD_SO_KEY SAP-Office key
                 
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  20140121 
SAP Release Created in