SAP ABAP Table CRMH_BUAG_SEARCH (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRMH_BUAG_SEARCH   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 BUAG_ID CRMT_BUAG_ID CRMT_BUAG_ID CHAR 12   0   Number of Business Agreement  
4 BUAG_GUID CRMT_BUAG_GUID SYSUUID RAW 16   0   GUID of the Business Agreement  
5 BUAG_DEFAULT CRMT_BUAG_DEFAULT CRMT_BUAG_DEFAULT CHAR 1   0   Standard Business Agreement  
6 BUAG_TEXT CRMT_BUAG_TEXT CHAR30LOW CHAR 30   0   Text for Business Agreement  
7 DFVAL BU_DFVAL CHAR20 CHAR 20   0   BP: Differentiation type value  
8 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number ADRC
9 ADDR_DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
10 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
11 MC_NAME1 BU_MCNAME1 CHAR35 CHAR 35   0   Search Help Field 1 (Name 1/Last Name)  
12 MC_NAME2 BU_MCNAME2 CHAR35 CHAR 35   0   Search Help Field 2 (Name 2/First Name)  
13 CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
14 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
15 STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
16 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
17 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
18 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
19 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
20 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
21 RLTYP BU_PARTNERROLE BU_ROLE CHAR 6   0   BP Role TB003
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMH_BUAG_SEARCH ADDRNUMBER ADRC ADDRNUMBER KEY 1 C
2 CRMH_BUAG_SEARCH CLIENT T000 MANDT KEY 1 CN
3 CRMH_BUAG_SEARCH COUNTRY T005 LAND1 REF 1 CN
4 CRMH_BUAG_SEARCH NATION TSADV NATION KEY 1 CN
5 CRMH_BUAG_SEARCH RLTYP TB003 ROLE KEY 1 CN
History
Last changed by/on SAP  20141013 
SAP Release Created in