SAP ABAP Table V_ADRP_CP (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_ADRP_CP   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT MANDT MANDT CLNT 3   0   Client T000
2 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number  
3 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
4 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
5 MC_NAMEFIR AD_MC_NMFI CHAR25 CHAR 25   0   First name in upper case for search help  
6 MC_NAMELAS AD_MC_NMLA CHAR25 CHAR 25   0   Last name in upper-case for search help  
7 COMP_PERS AD_CMP_PRS AD_CMP_PRS CHAR 1   0   Flag: Person in company (C) or private (P) address  
8 SO_KEY AD_SO_KEY AD_SO_KEY CHAR 10   0   SAP-Office key  
9 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
10 DATE_ADCP AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
11 PERS_GROUP AD_GROUP_P AD_GROUP_P CHAR 4   0   Person Group (Key) (Business Address Services) TSAD8
12 NAME_FIRST AD_NAMEFIR TEXT40 CHAR 40   0   First name  
13 NAME_LAST AD_NAMELAS TEXT40 CHAR 40   0   Last name  
14 NAME_TEXT AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
15 DEPARTMENT AD_DPRTMNT TEXT40 CHAR 40   0   Department  
16 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
17 STREET AD_STREET TEXT60 CHAR 60   0   Street  
18 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
19 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
20 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
21 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
22 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
23 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
24 DATE_ADRC AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_ADRP_CP ADDRNUMBER ADRC ADDRNUMBER REF 1 CN
2 V_ADRP_CP CLIENT T000 MANDT KEY 1 CN
3 V_ADRP_CP NATION TSADV NATION KEY 1 CN
4 V_ADRP_CP PERS_GROUP TSAD8 PERS_GROUP REF C CN
History
Last changed by/on SAP  20141013 
SAP Release Created in