SAP ABAP Table USS_BPADRC_VIEW (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure USS_BPADRC_VIEW   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 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number  
3 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
4 ADEXT BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
5 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
6 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
7 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
8 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group TB037
9 MC_NAME1 BU_MCNAME1 CHAR35 CHAR 35   0   Search Help Field 1 (Name 1/Last Name)  
10 MC_NAME2 BU_MCNAME2 CHAR35 CHAR 35   0   Search Help Field 2 (Name 2/First Name)  
11 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
12 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
13 RLTYP BU_PARTNERROLE BU_ROLE CHAR 6   0   BP Role TB003
14 DFVAL BU_DFVAL CHAR20 CHAR 20   0   BP: Differentiation type value  
15 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
16 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
17 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
18 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
19 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
20 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
21 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
22 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 USS_BPADRC_VIEW AUGRP TB037 AUGRP REF 1 CN
2 USS_BPADRC_VIEW CLIENT T000 MANDT KEY 1 CN
3 USS_BPADRC_VIEW COUNTRY T005 LAND1 REF 1 CN
4 USS_BPADRC_VIEW NATION TSADV NATION KEY 1 CN
5 USS_BPADRC_VIEW REGION T005S BLAND REF C CN
6 USS_BPADRC_VIEW RLTYP TB003 ROLE KEY 1 CN
7 USS_BPADRC_VIEW SOURCE TB005 SOURCE KEY 1 CN
History
Last changed by/on DDIC  20141109 
SAP Release Created in