SAP ABAP View CRMH_BUAG_SEARCH (CRM: Search Help View for CRM_BUAG Business Agreements)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MD-BP-BAG (Application Component) Business Agreements
     CRM_BUPA_FRG0130 (Package) CRM Business Agreements for Business Partner
Basic Data
View Type D Database View 
Database View CRMH_BUAG_SEARCH  
Short Description CRM: Search Help View for CRM_BUAG Business Agreements    
Root table CRMM_BUAG   Business Partner: Business Agreement Set (Header) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CRMM_BUAG CRMM_BUAG
2 CRMM_BUAG_H CRMM_BUAG_H
3 CRMM_BUAG_L_FICA  
4 BUT000  
5 BUT020  
6 BUT100  
7 ADRC  
8 CRMC_BUAG_ACTV  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT000 CLIENT JL EQ 0 0
2 BUT020 CLIENT JR EQ AND 0 0
3 BUT000 PARTNER JL EQ 0 0
4 BUT020 PARTNER JR EQ AND 0 0
5 BUT000 CLIENT JL EQ 0 0
6 BUT100 MANDT JR EQ AND 0 0
7 BUT000 PARTNER JL EQ 0 0
8 BUT100 PARTNER JR EQ AND 0 0
9 BUT100 MANDT JL EQ 0 0
10 BUT020 CLIENT JR EQ AND 0 0
11 BUT100 PARTNER JL EQ 0 0
12 BUT020 PARTNER JR EQ AND 0 0
13 BUT020 CLIENT JL EQ 0 0
14 ADRC CLIENT JR EQ AND 0 0
15 BUT020 ADDRNUMBER JL EQ 0 0
16 ADRC ADDRNUMBER JR EQ AND 0 0
17 BUT020 DATE_FROM JL EQ 0 0
18 ADRC DATE_FROM JR EQ AND 0 0
19 BUT020 NATION JL EQ 0 0
20 ADRC NATION JR EQ AND 0 0
21 CRMM_BUAG_L_FICA CLIENT JL EQ 0 0
22 BUT000 CLIENT JR EQ AND 0 0
23 CRMM_BUAG_L_FICA BUPA_GUID JL EQ 0 0
24 BUT000 PARTNER_GUID JR EQ AND 0 0
25 CRMM_BUAG_H CLIENT JL EQ 0 0
26 BUT000 CLIENT JR EQ AND 0 0
27 CRMM_BUAG_H BUAG_GUID JL EQ 0 0
28 CRMM_BUAG_L_FICA BUAG_GUID JR EQ AND 0 0
29 CRMM_BUAG CLIENT JL EQ 0 0
30 CRMM_BUAG_H CLIENT JR EQ AND 0 0
31 CRMM_BUAG BUAG_GUID JL EQ 0 0
32 CRMM_BUAG_L_FICA BUAG_GUID JR EQ AND 0 0
33 CRMC_BUAG_ACTV CLIENT JL EQ 0 0
34 BUT000 CLIENT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT ADRC CLIENT   MANDT Client
2 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
3 BUAG_ID CRMM_BUAG BUAG_ID   CRMT_BUAG_ID Number of Business Agreement
4 BUAG_GUID CRMM_BUAG BUAG_GUID   CRMT_BUAG_GUID GUID of the Business Agreement
5 BUAG_DEFAULT CRMM_BUAG_H BUAG_DEFAULT   CRMT_BUAG_DEFAULT Standard Business Agreement
6 BUAG_TEXT CRMM_BUAG BUAG_TEXT   CRMT_BUAG_TEXT Text for Business Agreement
7 DFVAL BUT100 DFVAL   BU_DFVAL BP: Differentiation type value
8 ADDRNUMBER BUT020 ADDRNUMBER   AD_ADDRNUM Address number
9 ADDR_DATE_FROM ADRC DATE_FROM   AD_DATE_FR Valid-from date - in current Release only 00010101 possible
10 NATION ADRC NATION   AD_NATION Version ID for International Addresses
11 MC_NAME1 BUT000 MC_NAME1   BU_MCNAME1 Search Help Field 1 (Name 1/Last Name)
12 MC_NAME2 BUT000 MC_NAME2   BU_MCNAME2 Search Help Field 2 (Name 2/First Name)
13 CITY1 ADRC MC_CITY1   AD_MC_CITY City name in upper case for search help
14 POST_CODE1 ADRC POST_CODE1   AD_PSTCD1 City postal code
15 STREET ADRC MC_STREET   AD_MC_STRT Street name in upper case for search help
16 HOUSE_NUM1 ADRC HOUSE_NUM1   AD_HSNM1 House Number
17 COUNTRY ADRC COUNTRY   LAND1 Country Key
18 TEL_NUMBER ADRC TEL_NUMBER   AD_TLNMBR1 First telephone no.: dialling code+number
19 TEL_EXTENS ADRC TEL_EXTENS   AD_TLXTNS1 First Telephone No.: Extension
20 PO_BOX ADRC PO_BOX   AD_POBX PO Box
21 RLTYP BUT100 RLTYP   BU_PARTNERROLE BP Role
                 
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  20141013 
SAP Release Created in 30A