I_ProcurementBusinessUser

@AbapCatalog.sqlViewName: 'IPROCBUSUSER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Businessuser in procurement'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ClientHandling.algorithm: #SESSION_VARIABLE 
define view I_ProcurementBusinessUser
  as select from I_BusinessPartner as bp
    inner join   I_User            as user on bp.BusinessPartnerUUID = user.BusinessPartnerUUID
  association [0..1] to I_BusinessPartner_to_BP_Role as _businesspartner_to_bprole on $projection.BusinessPartner = _businesspartner_to_bprole.BusinessPartner
{
  key bp.BusinessPartner,
      bp.BusinessPartnerCategory,
      bp.AuthorizationGroup,
      bp.BusinessPartnerUUID,
      bp.PersonNumber,
      bp.ETag,
      bp.BusinessPartnerName,
      bp.BusinessPartnerFullName,
      bp.CreatedByUser,
      bp.CreationDate,
      bp.CreationTime,
      bp.LastChangedByUser,
      bp.LastChangeDate,
      bp.LastChangeTime,
      bp.BusinessPartnerIsBlocked,
      bp.IsBusinessPurposeCompleted,
      bp.FirstName,
      bp.LastName,
      bp.PersonFullName,
      bp.OrganizationBPName1,
      bp.OrganizationBPName2,
      bp.OrganizationBPName3,
      bp.OrganizationBPName4,
      bp.InternationalLocationNumber1,
      bp.InternationalLocationNumber2,
      bp.InternationalLocationNumber3,
      bp.LegalForm,
      bp.OrganizationFoundationDate,
      bp.OrganizationLiquidationDate,
      bp.Industry,
      bp.IsNaturalPerson,
//      bp.IsFemale,

//      bp.IsMale,

//      bp.IsSexUnknown,

      bp.FormOfAddress,
      bp.AcademicTitle,
      bp.NameFormat,
      bp.NameCountry,
      bp.BusinessPartnerGrouping,
      bp.BusinessPartnerType,
      bp.MiddleName,
      bp.AdditionalLastName,
      bp.GroupBusinessPartnerName1,
      bp.GroupBusinessPartnerName2,
      bp.CorrespondenceLanguage,
      bp.Language,
      bp.SearchTerm1,
      bp.SearchTerm2,
      bp.BPLastNameSearchHelp,
      bp.BPFirstNameSearchHelp,
      bp.IndependentAddressID,
      bp.IsActiveEntity,
      bp.BirthDate,
      bp.IsMarkedForArchiving,
      bp.ContactPermission,
      bp.BusinessPartnerIDByExtSystem,
      bp.LegalEntityOfOrganization,
      bp.TrdCmplncLicenseIsMilitarySctr,
      bp.TrdCmplncLicenseIsNuclearSctr,
      bp.BusinessPartnerPrintFormat,
      bp.BusinessPartnerDataOriginType,
      bp.BusinessPartnerIsNotReleased,
      bp._AcademicTitleText,
      bp._AcademicTitleValueHelp,
      bp._AddressIndependentEmail,
      bp._AddressIndependentFax,
      bp._AddressIndependentMobile,
      bp._AddressIndependentPhone,
      bp._BusinessPartnerIndustry,
      bp._BusinessPartnerRole,
      bp._CreatedByUser,
      bp._CurrentDefaultAddress,
      bp._DefaultAddress,
      bp._Industries,
      bp._LastChangedByUser,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController1,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController2,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController3,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController4,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController5,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController6,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController7,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController8,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController9,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataController10,
       @Consumption.hidden:true
        @UI.hidden:true
      bp.DataControllerSet,

      user.UserID,
      user.UserDescription,
      user.IsTechnicalUser
}
where
  _businesspartner_to_bprole.BusinessPartnerRole = 'BUP003'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNER_TO_BP_ROLE",
"I_USER"
],
"ASSOCIATED":
[
"I_ACADEMICTITLE",
"I_ACADEMICTITLETEXT",
"I_ADDRESSINDEPENDENTEMAIL",
"I_ADDRESSINDEPENDENTFAX",
"I_ADDRESSINDEPENDENTMOBILE",
"I_ADDRESSINDEPENDENTPHONE",
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNERDEFAULTADDR",
"I_BUSINESSPARTNERINDUSTRY",
"I_BUSINESSPARTNER_TO_BP_ROLE",
"I_INDUSTRIES",
"I_USER"
],
"BASE":
[
"I_BUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/