I_BusinessPartnerTP_2

//@AbapCatalog.sqlViewName: 'IBUPATP2'

@AccessControl.personalData.blocking: #REQUIRED
//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
//@ClientHandling.algorithm : #SESSION_VARIABLE

//@AccessControl.privilegedAssociations:  [ '_BPDataControllerUsage' ]

@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@EndUserText.label: 'View for Business Partner'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.sapObjectNodeType.name: 'BusinessPartner'
@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_LASTCHANGEDBYUSER' ]
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define root view entity I_BusinessPartnerTP_2
  as select from I_BusinessPartner as BusinessPartner

    composition [0..*] of I_BusinessPartnerRoleTP_2      as _BusinessPartnerRole
    composition [0..*] of I_BusinessPartnerAddressTP_2   as _BusinessPartnerAddress
    composition [0..*] of I_BusinessPartnerTaxNumberTP_2 as _BusinessPartnerTaxNumber
    composition [0..*] of I_BusPartIdentificationTP_2    as _BusinessPartnerIdentification
    composition [0..*] of I_BusinessPartnerIndustryTP_2  as _BusinessPartnerIndustry
    composition [0..*] of I_BusinessPartnerBankTP_2      as _BusinessPartnerBank
    composition [0..*] of I_BusPartRelationshipTmpTP     as _BusPartRelationship
    composition [0..*] of I_BPRelshpContactPersonTmpTP   as _BusPartContactPerson
  //composition [0..*] of I_PaymentCardMasterTmpTP       as _PaymentCardMaster 

  composition [0..*] of I_PaymentCardTP_2              as _BusinessPartnerPaymentCards
//  composition [0..*] of I_BPAddressIndependntPhoneTP_2 as _BPAddressIndependentPhone

//  composition [0..*] of I_BPAddressIndependntMobTP_2   as _BPAddressIndependentMobile

//  composition [0..*] of I_BPAddressIndependntEmailTP_2 as _BPAddressIndependentEmail

  composition [0..*] of I_BPAddrIndependentPhoneTP_2   as _BPAddrIndependentPhone
  composition [0..*] of I_BPAddrIndependentMobileTP_2  as _BPAddrIndependentMobile
  composition [0..*] of I_BPAddrIndependentEmailTP_2   as _BPAddrIndependentEmail
  composition [0..*] of I_BPAddIndependentWebsiteTP    as _BPAddIndependentWebsite
  composition [0..*] of I_BPAddIndependentFaxTP        as _BPAddIndependentFax
  composition [0..*] of I_BPDataControllerTP_2         as _BPDataController
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [0..1] to I_BusPartAllowedRoleCategoryTP as _RoleAllowList               on  $projection.BusinessPartner = _RoleAllowList.BusinessPartner
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
  association [0..1] to I_BusinessPartnerAddressTP_2   as _BusinessPartnerStandardAddr on  $projection.BusinessPartner                = _BusinessPartnerStandardAddr.BusinessPartner
                                                                              //         and $projection.BPDrftUUID = _BusinessPartnerStandardAddr.BPDrftUUID

                                                                                       and _BusinessPartnerStandardAddr.StandardUsage = 'X'
  association [0..1] to I_BusinessPartnerGrouping      as _BusinessPartnerGrouping     on  $projection.BusinessPartnerGrouping = _BusinessPartnerGrouping.BusinessPartnerGrouping
  association [0..1] to I_BusPartCategory              as _BusinessPartnerCategory     on  $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory
  association [0..1] to I_BusinessPartnerLegalForm     as _BusinessPartnerLegalForm    on  $projection.LegalForm = _BusinessPartnerLegalForm.LegalForm
  association [0..1] to I_BuPaLegalEntity              as _BusinessPartnerLegalEntity  on  $projection.LegalEntityOfOrganization = _BusinessPartnerLegalEntity.BPOrganisationLegalEntity
  association [0..1] to I_BusPartAuthorizationGroup    as _AuthorizationGroup          on  $projection.AuthorizationGroup               = _AuthorizationGroup.AuthorizationGroup
                                                                                       and _AuthorizationGroup.AuthorizationObject = 'BUPA'
  association [0..1] to I_BusinessPartnerType          as _BusinessPartnerType         on  $projection.BusinessPartnerType = _BusinessPartnerType.BusinessPartnerType
  association [0..1] to I_BusinessPartnerPrintFormat   as _PrintFormat                 on  $projection.BusinessPartnerPrintFormat = _PrintFormat.BusinessPartnerPrintFormat
  association [0..1] to I_BusPartDataOriginType        as _DataOriginType              on  $projection.BusinessPartnerDataOriginType = _DataOriginType.BusinessPartnerDataOriginType
  association [0..1] to I_BusPartContactPermission     as _ContactPermission           on  $projection.ContactPermission = _ContactPermission.ContactPermission
  association [0..1] to I_BusinessPartnerFormOfAddress as _FormOfAddress               on  $projection.FormOfAddress           = _FormOfAddress.FormOfAddress
                                                                                       and $projection.BusinessPartnerCategory = _FormOfAddress.BusinessPartnerCategory
  association [0..1] to I_BusinessPartnerGroupType     as _GroupType                   on  $projection.BusinessPartnerGroupType = _GroupType.BusinessPartnerGroupType
  association [0..1] to I_BusPartAcademicTitle         as _AcademicTitle2              on  $projection.AcademicTitle2 = _AcademicTitle2.AcademicTitle
  association [0..1] to I_BPGenderValueHelp            as _BusinessPartnerGender       on  $projection.GenderCodeName = _BusinessPartnerGender.GenderCodeName
  association [0..1] to I_BusPartPrefixName            as _BusPartPrefixName           on  $projection.LastNamePrefix = _BusPartPrefixName.LastNamePrefix
  association [0..1] to I_BusPartPrefixName            as _LastNameSecondPrefixName    on  $projection.LastNameSecondPrefix = _LastNameSecondPrefixName.LastNamePrefix
  association [0..1] to I_LanguageText                 as _Language                    on  $projection.Language = _Language.LanguageCode
                                                                                       and _Language.Language   = $session.system_language
  association [0..1] to I_LanguageText                 as _CorrespondenceLanguage      on  $projection.CorrespondenceLanguage = _CorrespondenceLanguage.LanguageCode
                                                                                       and _CorrespondenceLanguage.Language   = $session.system_language
  association [0..1] to I_Country                      as _NameCountry                 on  $projection.NameCountry = _NameCountry.Country
  association [0..1] to I_Country                      as _Nationality                 on  $projection.BusPartNationality = _Nationality.Country
  association [0..1] to I_Country                      as _NonResidentCompOriginCntry  on  $projection.NonResidentCompanyOriginCntry = _NonResidentCompOriginCntry.Country
  association [0..1] to I_BusPartNameFormat            as _NameFormat                  on  $projection.NameFormat  = _NameFormat.NameFormat
                                                                                       and $projection.NameCountry = _NameFormat.Country
  association [0..1] to I_BusPartSupplementName        as _BusPartSupplementName       on  $projection.BusinessPartnerSupplementName = _BusPartSupplementName.BusinessPartnerSupplementName
  association [0..1] to I_BusPartMaritalStatus         as _MaritalStatus               on  $projection.BusPartMaritalStatus = _MaritalStatus.MaritalStatus
  association [0..1] to I_BusinessPartnerOccupation    as _Occupation                  on  $projection.BusinessPartnerOccupation = _Occupation.BusinessPartnerOccupation
  association [0..1] to I_BusPartBirthDateStatus       as _BusPartBirthDateStatus      on  $projection.BusinessPartnerBirthDateStatus = _BusPartBirthDateStatus.BusinessPartnerBirthDateStatus
  association [0..1] to I_BusPartPersonFullName        as _BusPartPersonFullName       on  $projection.PersonNumber                         = _BusPartPersonFullName.PersonNumber
                                                                                       and _BusPartPersonFullName.AddressRepresentationCode = ' '
                                                                                       and _BusPartPersonFullName.ValidityStartDateTime     = '00010101'
//  association [0..*] to I_BusPartRelationshipTP        as _BusPartRelationship         on ( $projection.BusinessPartner = _BusPartRelationship.BusinessPartner1

//                                                                                            and _BusPartRelationship.RelationshipCategory != 'BUR001' )

//                                                                                       or $projection.BusinessPartner = _BusPartRelationship.BusinessPartner2


  association [0..1] to E_BP_D                         as _BusinessPartnerExt          on  $projection.BusinessPartner = _BusinessPartnerExt.BusinessPartner
{
 // key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

  key BusinessPartner,
      //      @ObjectModel.readOnly: true

      BusinessPartner.BusinessPartnerUUID,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      BusinessPartner.BusinessPartner                  as BusinessPartnerForEdit,

      @ObjectModel.foreignKey.association: '_BusinessPartnerCategory'
      BusinessPartner.BusinessPartnerCategory,

      //@ObjectModel.readOnly: true

      //_CategoryTextHelp.BusinessPartnerCategoryText,


      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      //      @ObjectModel.readOnly: true

      @Semantics.user.createdBy: true
      BusinessPartner.CreatedByUser, //CreatedByUser,


      BusinessPartner.CreationDate,
      BusinessPartner.CreationTime,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      //      @ObjectModel.readOnly: true

      @Semantics.user.lastChangedBy: true
      BusinessPartner.LastChangedByUser, //LastChangedByUser,


      BusinessPartner.LastChangeDate,
      BusinessPartner.LastChangeTime,

      BusinessPartner.BusinessPartnerIsBlocked,
      BusinessPartner.IsMarkedForArchiving,
      BusinessPartner.BusinessPartnerIsNotReleased,
      @ObjectModel.foreignKey.association: '_ContactPermission'
      BusinessPartner.ContactPermission,

      BusinessPartner.OrganizationBPName1,

      BusinessPartner.OrganizationBPName2,

      BusinessPartner.OrganizationBPName3,

      BusinessPartner.OrganizationBPName4,

      @ObjectModel.foreignKey.association: '_BusinessPartnerLegalForm'
      BusinessPartner.LegalForm,
      @ObjectModel.foreignKey.association: '_BusinessPartnerLegalEntity'
      BusinessPartner.LegalEntityOfOrganization,

      BusinessPartner.OrganizationFoundationDate,

      BusinessPartner.OrganizationLiquidationDate,

      BusinessPartner.Industry,

      //     @ObjectModel.foreignKey.association: '_FormOfAddress'

      BusinessPartner.FormOfAddress,
      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      BusinessPartner.FormOfAddress                    as FormOfAddressPerson,

      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      BusinessPartner.FormOfAddress                    as FormOfAddressOrganization,

      //      @ObjectModel.foreignKey.association: '_FormOfAddress'

      BusinessPartner.FormOfAddress                    as FormOfAddressGroup,

      cast(
        case when BusinessPartner.InternationalLocationNumber1='0000000'
              and BusinessPartner.InternationalLocationNumber2='00000'
              and BusinessPartner.InternationalLocationNumber3='0'
        then '       '
        else BusinessPartner.InternationalLocationNumber1
      end as bu_location1str )                         as InternationalLocationNumber1,
      cast(
        case when BusinessPartner.InternationalLocationNumber1='0000000'
              and BusinessPartner.InternationalLocationNumber2='00000'
              and BusinessPartner.InternationalLocationNumber3='0'
        then '       '
        else BusinessPartner.InternationalLocationNumber2
      end as bu_location2str )                         as InternationalLocationNumber2,
      cast(
        case when BusinessPartner.InternationalLocationNumber1='0000000'
              and BusinessPartner.InternationalLocationNumber2='00000'
              and BusinessPartner.InternationalLocationNumber3='0'
        then ''
        else BusinessPartner.InternationalLocationNumber3
      end as bu_location3str )                         as InternationalLocationNumber3,

      BusinessPartner.ETag,
      @Semantics.booleanIndicator
      BusinessPartner.IsBusinessPurposeCompleted,

      @ObjectModel.foreignKey.association: '_AuthorizationGroup'
      BusinessPartner.AuthorizationGroup,

      @ObjectModel.foreignKey.association: '_BusinessPartnerType'
      BusinessPartner.BusinessPartnerType,
      @ObjectModel.foreignKey.association: '_PrintFormat'
      BusinessPartner.BusinessPartnerPrintFormat,
      @ObjectModel.foreignKey.association: '_DataOriginType'
      BusinessPartner.BusinessPartnerDataOriginType,

      //      cast( 'S/4HANA' as char30 )                                                                     as  MDQualityDataProvider,


      //BusinessPartner.Gender,


      ////      BusinessPartner.GenderCodeName,


      @ObjectModel.foreignKey.association: '_BusinessPartnerGrouping'
      BusinessPartner.BusinessPartnerGrouping,
      //  BusinessPartner.IsActiveEntity,

      ////      BusinessPartner.HasActiveEntity,

      ////      BusinessPartner.HasDraftEntity,


      //adding correspondence language field for 1611


      //Current standard Address fields

      ////      _BusinessPartnerAddrFilter.CityName,

      ////      _BusinessPartnerAddrFilter.StreetName,

      ////      _BusinessPartnerAddrFilter.PostalCode,


      //NEWLY ADDED

      ////      BusinessPartner.DraftAdministrativeDataUUID,

      BusinessPartner._CurrentDefaultAddress.AddressID as AddressID,

      case when BusinessPartner.BusinessPartnerCategory = '1'
          then BusinessPartner.LastName
          else BusinessPartner.OrganizationBPName1
          end                                          as Name,

      case when BusinessPartner.BusinessPartnerCategory = '1'
      then BusinessPartner.FirstName
      else BusinessPartner.OrganizationBPName2
      end                                              as AdditionalName,

      case
        when BusinessPartner.BusinessPartnerCategory = '1'
          then _BusPartPersonFullName.PersonFullName
        when BusinessPartner.BusinessPartnerCategory = '3'
          then concat_with_space(GroupBusinessPartnerName1,GroupBusinessPartnerName2,1)
        else concat_with_space(concat_with_space(concat_with_space(OrganizationBPName1,OrganizationBPName2,1),OrganizationBPName3,1),OrganizationBPName4,1)
      end                                              as FullName,

      //concat_with_space(concat_with_space(FullName,'-',1),BusinessPartnerForEdit,1) as BusinessPartnerName,

      /*  case when BusinessPartner.BusinessPartnerCategory = '1'
        then concat_with_space(concat(concat('(',BusinessPartnerForEdit),')'),concat_with_space(FirstName,LastName,1),1)
        else concat_with_space(concat(concat('(',BusinessPartnerForEdit),')'),concat_with_space(concat_with_space(concat_with_space(OrganizationBPName1,OrganizationBPName2,1),OrganizationBPName3,1),OrganizationBPName4,1),1)
        end  as BusinessPartnerName,
        */

      case
        when BusinessPartner.BusinessPartnerCategory = '1' and BusinessPartner.BusinessPartner <> ''
         then _BusPartPersonFullName.PersonFullName
        when BusinessPartner.BusinessPartnerCategory = '3' and BusinessPartner.BusinessPartner <> ''
         then concat_with_space(GroupBusinessPartnerName1,GroupBusinessPartnerName2,1)
      else case
        when BusinessPartner.BusinessPartnerCategory = '2' and BusinessPartner.BusinessPartner <> ''
         then concat_with_space(concat_with_space(concat_with_space(OrganizationBPName1,OrganizationBPName2,1),OrganizationBPName3,1),OrganizationBPName4,1)            end
      end                                              as BusinessPartnerName,

      //      _BusinessPartnerSupplier.PostingIsBlocked,

      //      _BusinessPartnerSupplier.PaymentIsBlockedForSupplier,

      //      _BusinessPartnerSupplier.PurchasingIsBlocked,

      //      _BusinessPartnerCustomer.DeliveryIsBlocked,

      //      _BusinessPartnerCustomer.BillingIsBlockedForCustomer,

      //      _BusinessPartnerCustomer.PostingIsBlocked                         as PostingIsBlockedForCustomer,


      ////      _BusinessPartnerAddrFilter.FormattedAddress,

      ////      _BusinessPartnerAddrFilter.CompleteAddress,

      ////      _BusinessPartnerAddrFilter.AddressLine1Text,

      ////      _BusinessPartnerAddrFilter.AddressLine2Text,

      ////      _BusinessPartnerAddrFilter.Country,


      ////      _BusinessPartnerAddrFilter.PhoneNumber,

      ////      _BusinessPartnerAddrFilter.EmailAddress,


      /*cast(
      case
        when BusinessPartner.BusinessPartnerCategory = '1'
        then ' '
        else 'X'
        end  as boole_d)                                                                        as BusinessPartnerType,*/
      //_BusinessPartnerAddrFilter.URLFieldLength,

      //_BusinessPartnerAddrFilter.WebsiteURL,

      ////////////


      //      @ObjectModel.readOnly: true

      //      case

      //        when _BPWithEmployeeRoles.BusinessPartner is not null

      //          then

      //            cast('X' as boole_d)

      //          else

      //            cast(' ' as boole_d)

      //      end                                              as BPHasEmployeeRoles,

      //

      //      //For ATC

      //      cast ('' as bu_istype )                          as IndustrySystemType,

      //

      //

      cast(
        case
          when BusinessPartnerCategory = '1' then ''
        else 'X'
      end as abap_boolean preserving type)             as BusPartPersonDataIsHidden,
      cast(
        case
          when BusinessPartnerCategory = '2' then ''
        else 'X'
      end as abap_boolean preserving type)             as BusPartOrgDataIsHidden,
      cast(
        case
          when BusinessPartnerCategory = '3' then ''
        else 'X'
      end as abap_boolean preserving type)             as BusPartGroupDataIsHidden,
      cast(
        case
          when BusinessPartnerCategory = '1' then 'X'
        else ''
      end as abap_boolean preserving type)             as BusPartAddrLanguageIsHidden,

      /* Person Data */
      BusinessPartner.PersonNumber,
      BusinessPartner.IsFemale,
      BusinessPartner.IsMale,
      BusinessPartner.IsSexUnknown,
      BusinessPartner.GenderCodeName,
      BusinessPartner.FirstName,
      BusinessPartner.LastName,
      BusinessPartner.AdditionalLastName,
      BusinessPartner.BusinessPartnerBirthName,
      BusinessPartner.MiddleName,
      @ObjectModel: {
                foreignKey.association: '_AcademicTitleValueHelp'
      }
      BusinessPartner.AcademicTitle,
      BusinessPartner.AcademicTitle2,
      BusinessPartner.BusinessPartnerSupplementName,
      //      @ObjectModel.foreignKey.association: '_BusPartPrefixName'

      BusinessPartner.LastNamePrefix,
      BusinessPartner.LastNameSecondPrefix,
      BusinessPartner.PersonFullName,
      BusinessPartner.BusinessPartnerNicknameLabel, //Known as ?

      BusinessPartner.Initials,
      BusinessPartner.NameFormat,
      BusinessPartner.NameCountry,
      BusinessPartner.NaturalPersonEmployerName,
      BusinessPartner.Language,
      BusinessPartner.CorrespondenceLanguage,
      @Semantics.booleanIndicator
      BusinessPartner.IsNaturalPerson,
      BusinessPartner.BirthDate,
      BusinessPartner.BusinessPartnerBirthplaceName,
      BusinessPartner.BusinessPartnerBirthDateStatus,
      BusinessPartner.BusinessPartnerDeathDate,
      BusinessPartner.BusinessPartnerOccupation,
      BusinessPartner.BusPartNationality,
      BusinessPartner.BusPartMaritalStatus,
      BusinessPartner.BusinessPartnerIDByExtSystem,
      BusinessPartner.NonResidentCompanyOriginCntry,
      BusinessPartner.BusinessPartnerSalutation,
      /* Group Data */
      BusinessPartner.GroupBusinessPartnerName1,
      BusinessPartner.GroupBusinessPartnerName2,
      BusinessPartner.BusinessPartnerGroupType,

      BusinessPartner.SearchTerm1,
      BusinessPartner.SearchTerm2,
      BusinessPartner.BPFirstNameSearchHelp,
      BusinessPartner.BPLastNameSearchHelp,
      BusinessPartner.IndependentAddressID,
      /* Compositions */
       _BusinessPartnerRole,
       _BusinessPartnerTaxNumber, 
       _BusinessPartnerIdentification,
       _BusinessPartnerAddress,
       _BusinessPartnerIndustry,
       _BusinessPartnerBank,
      
       _BusPartRelationship,
       _BusPartContactPerson, 
       _BPDataController,
       
             
  /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////      

        
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataControllerSet                            as DataControllerSet,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController1                              as DataController1,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController2                              as DataController2,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController3                              as DataController3,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController4                              as DataController4,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController5                              as DataController5,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController6                              as DataController6,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController7                              as DataController7,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController8                              as DataController8,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController9                              as DataController9,
        @Consumption.hidden:true
        @UI.hidden:true
        BusinessPartner.DataController10                             as DataController10,
        
 ////////////// End of Datacontroller 10+1 fields//////////      

     
      /* Associations */
      _BusinessPartnerStandardAddr,
      _CurrentDefaultAddress,
      _CreatedByUser,
      _LastChangedByUser,
      _BusinessPartnerGrouping,
      _BusinessPartnerCategory,
      _BusinessPartnerLegalForm,
      _BusinessPartnerLegalEntity,
       _AuthorizationGroup,
      _BusinessPartnerType,
      _PrintFormat,
      _DataOriginType,
      _ContactPermission,
      _FormOfAddress,
      _GroupType,
      _AcademicTitleText,
      _AcademicTitleValueHelp,
      _AcademicTitle2,
      _BusinessPartnerGender,
      _BusPartPrefixName,
      _LastNameSecondPrefixName,
      _Language,
      _CorrespondenceLanguage,
      _BusPartSupplementName,
      _NameCountry,
      _Nationality,
      _NonResidentCompOriginCntry,
      _NameFormat,
      _MaritalStatus,
      _Occupation,
      _BusPartBirthDateStatus,
      _BusPartPersonFullName,
      //_PaymentCardMaster,

      _BusinessPartnerPaymentCards,
//      _BPAddressIndependentPhone,

//      _BPAddressIndependentMobile,

//      _BPAddressIndependentEmail,

      _BPAddrIndependentPhone,
      _BPAddrIndependentMobile,
      _BPAddrIndependentEmail,
      _BPAddIndependentWebsite,
      _BPAddIndependentFax
//      _BPDataControllerUsage

}