SAP ABAP View BBPV_BUPA_PLANT (View for Business Partner Search in Role: Plant)
Hierarchy
BBPCRM (Software Component) BBPCRM
   SRM-EBP (Application Component) Enterprise Buyer
     BBP_BUPA (Package) Business Partner
Basic Data
View Type D Database View 
Database View BBPV_BUPA_PLANT  
Short Description View for Business Partner Search in Role: Plant    
Root table BUT000   BP: General data I 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT000 BUT000
2 BUT100  
3 BUT020  
4 ADRC  
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 BUT100 MANDT JR EQ AND 0 0
3 BUT000 PARTNER JL EQ 0 0
4 BUT100 PARTNER JR EQ AND 0 0
5 BUT000 CLIENT JL EQ 0 0
6 BUT020 CLIENT JR EQ AND 0 0
7 BUT000 PARTNER JL EQ 0 0
8 BUT020 PARTNER JR EQ AND 0 0
9 BUT020 CLIENT JL EQ 0 0
10 ADRC CLIENT JR EQ AND 0 0
11 BUT020 ADDRNUMBER JL EQ 0 0
12 ADRC ADDRNUMBER JR EQ AND 0 0
13 BUT100 RLTYP EQ 'BBP003' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT BUT000 CLIENT   MANDT Client
2 PARTNER BUT000 PARTNER   BU_PARTNER Business Partner Number
3 RLTYP BUT100 RLTYP   BU_PARTNERROLE BP Role
4 DFVAL BUT100 DFVAL   BU_DFVAL BP: Differentiation type value
5 ADDRNUMBER ADRC ADDRNUMBER   AD_ADDRNUM Address number
6 DATE_FROM ADRC DATE_FROM   AD_DATE_FR Valid-from date - in current Release only 00010101 possible
7 NATION ADRC NATION   AD_NATION Version ID for International Addresses
8 PARTNER_GUID BUT000 PARTNER_GUID   BU_PARTNER_GUID Business Partner GUID
9 MC_NAME1 BUT000 MC_NAME1   BU_MCNAME1 Search Help Field 1 (Name 1/Last Name)
10 MC_NAME2 BUT000 MC_NAME2   BU_MCNAME2 Search Help Field 2 (Name 2/First Name)
11 MC_STREET ADRC MC_STREET   AD_MC_STRT Street name in upper case for search help
12 POST_CODE ADRC POST_CODE1   AD_PSTCD1 City postal code
13 MC_CITY ADRC MC_CITY1   AD_MC_CITY City name in upper case for search help
14 COUNTRY ADRC COUNTRY   LAND1 Country Key
15 NAME_ORG BUT000 NAME_ORG1   BU_NAMEOR1 Name 1 of organization
16 STREET ADRC STREET   AD_STREET Street
17 CITY ADRC CITY1   AD_CITY1 City
                 
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 20C