SAP ABAP Table /SPE/V_CRM_CP (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /SPE/V_CRM_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 MANDT MANDT MANDT CLNT 3   0   Client T000
2 BERID BERID BERID CHAR 10   0   MRP Area  
3 BERTX BERTX BERTX CHAR 40   0   MRP area text  
4 WERZG WERKS_D WERKS CHAR 4   0   Plant T001W
5 ORTZG ORTZG LGORT CHAR 4   0   Receiving storage location T001L
6 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
7 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
8 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
9 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
10 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
11 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
12 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
13 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
14 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
15 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
16 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
17 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
18 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
19 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
20 STREET AD_STREET TEXT60 CHAR 60   0   Street  
21 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
22 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
23 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
24 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
25 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
26 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
27 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
28 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
29 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
30 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
31 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
32 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
33 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
34 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
35 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SPE/V_CRM_CP COUNTRY T005 LAND1 REF 1 CN
2 /SPE/V_CRM_CP LANGU T002 SPRAS REF C CN
3 /SPE/V_CRM_CP MANDT T000 MANDT 1 CN
4 /SPE/V_CRM_CP ORTZG T001L LGORT C CN
5 /SPE/V_CRM_CP REGION T005S BLAND REF C CN
6 /SPE/V_CRM_CP STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
7 /SPE/V_CRM_CP STREETCODE ADRSTREET STRT_CODE REF C CN
8 /SPE/V_CRM_CP WERZG T001W WERKS 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in