SAP ABAP View M_BUPAA_4P (Generated View for Matchcode ID BUPA -A)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-CHM (Application Component) Channel Management
     CRM_CHM_EP_INTEGRATION (Package) Partner Channel Management Integration Enterprise Portal
Basic Data
View Type D Database View 
Database View M_BUPAA_4P  
Short Description Generated View for Matchcode ID BUPA -A    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 BUT020  
3 ADRC  
4 T005T  
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 ADRC CLIENT JL EQ 0 0
6 BUT020 CLIENT JR EQ AND 0 0
7 ADRC ADDRNUMBER JL EQ 0 0
8 BUT020 ADDRNUMBER JR EQ AND 0 0
9 ADRC DATE_FROM JL EQ 0 0
10 BUT020 DATE_FROM JR EQ AND 0 0
11 ADRC NATION JL EQ 0 0
12 BUT020 NATION JR EQ AND 0 0
13 ADRC COUNTRY JL EQ 0 0
14 T005T LAND1 JR EQ AND 0 0
15 ADRC CLIENT JL EQ 0 0
16 T005T MANDT JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT BUT000 CLIENT   MANDT Client
2 MC_NAME1 BUT000 MC_NAME1   BU_MCNAME1 Search Help Field 1 (Name 1/Last Name)
3 MC_NAME2 BUT000 MC_NAME2   BU_MCNAME2 Search Help Field 2 (Name 2/First Name)
4 MC_CITY1 ADRC MC_CITY1   AD_MC_CITY City name in upper case for search help
5 POST_CODE1 ADRC POST_CODE1   AD_PSTCD1 City postal code
6 MC_STREET ADRC MC_STREET   AD_MC_STRT Street name in upper case for search help
7 HOUSE_NUM1 ADRC HOUSE_NUM1   AD_HSNM1 House Number
8 COUNTRY ADRC COUNTRY   LAND1 Country Key
9 BU_SORT1 BUT000 BU_SORT1   BU_SORT1 Search term 1 for business partner
10 BU_SORT2 BUT000 BU_SORT2   BU_SORT2 Search term 2 for business partner
11 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
12 AUGRP BUT000 AUGRP   BU_AUGRP Authorization Group
13 VALID_FROM BUT020 ADDR_VALID_FROM   BU_ADDR_VALID_FROM Validity Start of a Business Partner Address
14 VALID_TO BUT020 ADDR_VALID_TO   BU_ADDR_VALID_TO Validity End of a Business Partner Address
15 BP_VALID_FROM BUT000 VALID_FROM   BU_BP_VALID_FROM Validity Start BUT000 BP Data
16 BP_VALID_TO BUT000 VALID_TO   BU_BP_VALID_TO Validity End BUT000 BP Data
17 PARTNER_GUID BUT000 PARTNER_GUID   BU_PARTNER_GUID Business Partner GUID
18 LANDX T005T LANDX   LANDX Country Name
19 SPRAS T005T SPRAS   SPRAS Language Key
                 
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 600