I_BusinessPartnerTP_2

DDL: I_BUSINESSPARTNERTP_2 SQL: IBUPATP2 Type: view_entity TRANSACTIONAL

View for Business Partner

I_BusinessPartnerTP_2 is a Transactional CDS View that provides data about "View for Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 137 fields with key field BusinessPartner. It has 44 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner BusinessPartner from

Associations (44)

CardinalityTargetAliasCondition
[0..1] I_BusPartAllowedRoleCategoryTP _RoleAllowList $projection.BusinessPartner = _RoleAllowList.BusinessPartner
[0..1] I_BusinessPartnerAddressTP_2 _BusinessPartnerStandardAddr $projection.BusinessPartner = _BusinessPartnerStandardAddr.BusinessPartner and _BusinessPartnerStandardAddr.StandardUsage = 'X'
[0..1] I_BusinessPartnerGrouping _BusinessPartnerGrouping $projection.BusinessPartnerGrouping = _BusinessPartnerGrouping.BusinessPartnerGrouping
[0..1] I_BusPartCategory _BusinessPartnerCategory $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory
[0..1] I_BusinessPartnerLegalForm _BusinessPartnerLegalForm $projection.LegalForm = _BusinessPartnerLegalForm.LegalForm
[0..1] I_BuPaLegalEntity _BusinessPartnerLegalEntity $projection.LegalEntityOfOrganization = _BusinessPartnerLegalEntity.BPOrganisationLegalEntity
[0..1] I_BusPartAuthorizationGroup _AuthorizationGroup $projection.AuthorizationGroup = _AuthorizationGroup.AuthorizationGroup and _AuthorizationGroup.AuthorizationObject = 'BUPA'
[0..1] I_BusinessPartnerType _BusinessPartnerType $projection.BusinessPartnerType = _BusinessPartnerType.BusinessPartnerType
[0..1] I_BusinessPartnerPrintFormat _PrintFormat $projection.BusinessPartnerPrintFormat = _PrintFormat.BusinessPartnerPrintFormat
[0..1] I_BusPartDataOriginType _DataOriginType $projection.BusinessPartnerDataOriginType = _DataOriginType.BusinessPartnerDataOriginType
[0..1] I_BusPartContactPermission _ContactPermission $projection.ContactPermission = _ContactPermission.ContactPermission
[0..1] I_BusinessPartnerFormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress and $projection.BusinessPartnerCategory = _FormOfAddress.BusinessPartnerCategory
[0..1] I_BusinessPartnerGroupType _GroupType $projection.BusinessPartnerGroupType = _GroupType.BusinessPartnerGroupType
[0..1] I_BusPartAcademicTitle _AcademicTitle2 $projection.AcademicTitle2 = _AcademicTitle2.AcademicTitle
[0..1] I_BPGenderValueHelp _BusinessPartnerGender $projection.GenderCodeName = _BusinessPartnerGender.GenderCodeName
[0..1] I_BusPartPrefixName _BusPartPrefixName $projection.LastNamePrefix = _BusPartPrefixName.LastNamePrefix
[0..1] I_BusPartPrefixName _LastNameSecondPrefixName $projection.LastNameSecondPrefix = _LastNameSecondPrefixName.LastNamePrefix
[0..1] I_LanguageText _Language $projection.Language = _Language.LanguageCode and _Language.Language = $session.system_language
[0..1] I_LanguageText _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.LanguageCode and _CorrespondenceLanguage.Language = $session.system_language
[0..1] I_Country _NameCountry $projection.NameCountry = _NameCountry.Country
[0..1] I_Country _Nationality $projection.BusPartNationality = _Nationality.Country
[0..1] I_Country _NonResidentCompOriginCntry $projection.NonResidentCompanyOriginCntry = _NonResidentCompOriginCntry.Country
[0..1] I_BusPartNameFormat _NameFormat $projection.NameFormat = _NameFormat.NameFormat and $projection.NameCountry = _NameFormat.Country
[0..1] I_BusPartSupplementName _BusPartSupplementName $projection.BusinessPartnerSupplementName = _BusPartSupplementName.BusinessPartnerSupplementName
[0..1] I_BusPartMaritalStatus _MaritalStatus $projection.BusPartMaritalStatus = _MaritalStatus.MaritalStatus
[0..1] I_BusinessPartnerOccupation _Occupation $projection.BusinessPartnerOccupation = _Occupation.BusinessPartnerOccupation
[0..1] I_BusPartBirthDateStatus _BusPartBirthDateStatus $projection.BusinessPartnerBirthDateStatus = _BusPartBirthDateStatus.BusinessPartnerBirthDateStatus
[0..1] I_BusPartPersonFullName _BusPartPersonFullName $projection.PersonNumber = _BusPartPersonFullName.PersonNumber and _BusPartPersonFullName.AddressRepresentationCode = ' ' and _BusPartPersonFullName.ValidityStartDateTime = '00010101'
[0..1] E_BP_D _BusinessPartnerExt $projection.BusinessPartner = _BusinessPartnerExt.BusinessPartner
[0..*] I_BusinessPartnerRoleTP_2 _BusinessPartnerRole
[0..*] I_BusinessPartnerAddressTP_2 _BusinessPartnerAddress
[0..*] I_BusinessPartnerTaxNumberTP_2 _BusinessPartnerTaxNumber
[0..*] I_BusPartIdentificationTP_2 _BusinessPartnerIdentification
[0..*] I_BusinessPartnerIndustryTP_2 _BusinessPartnerIndustry
[0..*] I_BusinessPartnerBankTP_2 _BusinessPartnerBank
[0..*] I_BusPartRelationshipTmpTP _BusPartRelationship
[0..*] I_BPRelshpContactPersonTmpTP _BusPartContactPerson
[0..*] I_PaymentCardTP_2 _BusinessPartnerPaymentCards
[0..*] I_BPAddrIndependentPhoneTP_2 _BPAddrIndependentPhone
[0..*] I_BPAddrIndependentMobileTP_2 _BPAddrIndependentMobile
[0..*] I_BPAddrIndependentEmailTP_2 _BPAddrIndependentEmail
[0..*] I_BPAddIndependentWebsiteTP _BPAddIndependentWebsite
[0..*] I_BPAddIndependentFaxTP _BPAddIndependentFax
[0..*] I_BPDataControllerTP_2 _BPDataController

Annotations (11)

NameValueLevelField
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label View for Business Partner view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BusinessPartner view

Fields (137)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerUUID I_BusinessPartner BusinessPartnerUUID
BusinessPartnerForEdit I_BusinessPartner BusinessPartner
BusinessPartnerCategory I_BusinessPartner BusinessPartnerCategory
CreatedByUser I_BusinessPartner CreatedByUser
CreationDate I_BusinessPartner CreationDate
CreationTime I_BusinessPartner CreationTime
LastChangedByUser I_BusinessPartner LastChangedByUser
LastChangeDate I_BusinessPartner LastChangeDate
LastChangeTime I_BusinessPartner LastChangeTime
BusinessPartnerIsBlocked I_BusinessPartner BusinessPartnerIsBlocked
IsMarkedForArchiving I_BusinessPartner IsMarkedForArchiving
BusinessPartnerIsNotReleased I_BusinessPartner BusinessPartnerIsNotReleased
ContactPermission I_BusinessPartner ContactPermission
OrganizationBPName1 I_BusinessPartner OrganizationBPName1
OrganizationBPName2 I_BusinessPartner OrganizationBPName2
OrganizationBPName3 I_BusinessPartner OrganizationBPName3
OrganizationBPName4 I_BusinessPartner OrganizationBPName4
LegalForm I_BusinessPartner LegalForm
LegalEntityOfOrganization I_BusinessPartner LegalEntityOfOrganization
OrganizationFoundationDate I_BusinessPartner OrganizationFoundationDate
OrganizationLiquidationDate I_BusinessPartner OrganizationLiquidationDate
Industry I_BusinessPartner Industry
FormOfAddress I_BusinessPartner FormOfAddress
FormOfAddressPerson I_BusinessPartner FormOfAddress
FormOfAddressOrganization I_BusinessPartner FormOfAddress
FormOfAddressGroup I_BusinessPartner FormOfAddress
ETag I_BusinessPartner ETag
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted
AuthorizationGroup I_BusinessPartner AuthorizationGroup
BusinessPartnerType I_BusinessPartner BusinessPartnerType
BusinessPartnerPrintFormat I_BusinessPartner BusinessPartnerPrintFormat
BusinessPartnerDataOriginType I_BusinessPartner BusinessPartnerDataOriginType
BusinessPartnerGrouping I_BusinessPartner BusinessPartnerGrouping
AddressID
OrganizationBPName1endasName
OrganizationBPName2endasAdditionalName
PersonNumber I_BusinessPartner PersonNumber
IsFemale I_BusinessPartner IsFemale
IsMale I_BusinessPartner IsMale
IsSexUnknown I_BusinessPartner IsSexUnknown
GenderCodeName I_BusinessPartner GenderCodeName
FirstName I_BusinessPartner FirstName
LastName I_BusinessPartner LastName
AdditionalLastName I_BusinessPartner AdditionalLastName
BusinessPartnerBirthName I_BusinessPartner BusinessPartnerBirthName
MiddleName I_BusinessPartner MiddleName
AcademicTitle I_BusinessPartner AcademicTitle
AcademicTitle2 I_BusinessPartner AcademicTitle2
BusinessPartnerSupplementName I_BusinessPartner BusinessPartnerSupplementName
LastNamePrefix I_BusinessPartner LastNamePrefix
LastNameSecondPrefix I_BusinessPartner LastNameSecondPrefix
PersonFullName I_BusinessPartner PersonFullName
BusinessPartnerNicknameLabel I_BusinessPartner BusinessPartnerNicknameLabel
Initials I_BusinessPartner Initials
NameFormat I_BusinessPartner NameFormat
NameCountry I_BusinessPartner NameCountry
NaturalPersonEmployerName I_BusinessPartner NaturalPersonEmployerName
Language I_BusinessPartner Language
CorrespondenceLanguage I_BusinessPartner CorrespondenceLanguage
IsNaturalPerson I_BusinessPartner IsNaturalPerson
BirthDate I_BusinessPartner BirthDate
BusinessPartnerBirthplaceName I_BusinessPartner BusinessPartnerBirthplaceName
BusinessPartnerBirthDateStatus I_BusinessPartner BusinessPartnerBirthDateStatus
BusinessPartnerDeathDate I_BusinessPartner BusinessPartnerDeathDate
BusinessPartnerOccupation I_BusinessPartner BusinessPartnerOccupation
BusPartNationality I_BusinessPartner BusPartNationality
BusPartMaritalStatus I_BusinessPartner BusPartMaritalStatus
BusinessPartnerIDByExtSystem I_BusinessPartner BusinessPartnerIDByExtSystem
NonResidentCompanyOriginCntry I_BusinessPartner NonResidentCompanyOriginCntry
BusinessPartnerSalutation I_BusinessPartner BusinessPartnerSalutation
GroupBusinessPartnerName1 I_BusinessPartner GroupBusinessPartnerName1
GroupBusinessPartnerName2 I_BusinessPartner GroupBusinessPartnerName2
BusinessPartnerGroupType I_BusinessPartner BusinessPartnerGroupType
SearchTerm1 I_BusinessPartner SearchTerm1
SearchTerm2 I_BusinessPartner SearchTerm2
BPFirstNameSearchHelp I_BusinessPartner BPFirstNameSearchHelp
BPLastNameSearchHelp I_BusinessPartner BPLastNameSearchHelp
IndependentAddressID I_BusinessPartner IndependentAddressID
_BusinessPartnerRole _BusinessPartnerRole
_BusinessPartnerTaxNumber _BusinessPartnerTaxNumber
_BusinessPartnerIdentification _BusinessPartnerIdentification
_BusinessPartnerAddress _BusinessPartnerAddress
_BusinessPartnerIndustry _BusinessPartnerIndustry
_BusinessPartnerBank _BusinessPartnerBank
_BusPartRelationship _BusPartRelationship
_BusPartContactPerson _BusPartContactPerson
_BPDataController _BPDataController
DataControllerSet I_BusinessPartner DataControllerSet
DataController1 I_BusinessPartner DataController1
DataController2 I_BusinessPartner DataController2
DataController3 I_BusinessPartner DataController3
DataController4 I_BusinessPartner DataController4
DataController5 I_BusinessPartner DataController5
DataController6 I_BusinessPartner DataController6
DataController7 I_BusinessPartner DataController7
DataController8 I_BusinessPartner DataController8
DataController9 I_BusinessPartner DataController9
DataController10 I_BusinessPartner DataController10
_BusinessPartnerStandardAddr _BusinessPartnerStandardAddr
_CurrentDefaultAddress _CurrentDefaultAddress
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_BusinessPartnerGrouping _BusinessPartnerGrouping
_BusinessPartnerCategory _BusinessPartnerCategory
_BusinessPartnerLegalForm _BusinessPartnerLegalForm
_BusinessPartnerLegalEntity _BusinessPartnerLegalEntity
_AuthorizationGroup _AuthorizationGroup
_BusinessPartnerType _BusinessPartnerType
_PrintFormat _PrintFormat
_DataOriginType _DataOriginType
_ContactPermission _ContactPermission
_FormOfAddress _FormOfAddress
_GroupType _GroupType
_AcademicTitleText _AcademicTitleText
_AcademicTitleValueHelp _AcademicTitleValueHelp
_AcademicTitle2 _AcademicTitle2
_BusinessPartnerGender _BusinessPartnerGender
_BusPartPrefixName _BusPartPrefixName
_LastNameSecondPrefixName _LastNameSecondPrefixName
_Language _Language
_CorrespondenceLanguage _CorrespondenceLanguage
_BusPartSupplementName _BusPartSupplementName
_NameCountry _NameCountry
_Nationality _Nationality
_NonResidentCompOriginCntry _NonResidentCompOriginCntry
_NameFormat _NameFormat
_MaritalStatus _MaritalStatus
_Occupation _Occupation
_BusPartBirthDateStatus _BusPartBirthDateStatus
_BusPartPersonFullName _BusPartPersonFullName
_BusinessPartnerPaymentCards _BusinessPartnerPaymentCards
_BPAddrIndependentPhone _BPAddrIndependentPhone
_BPAddrIndependentMobile _BPAddrIndependentMobile
_BPAddrIndependentEmail _BPAddrIndependentEmail
_BPAddIndependentWebsite _BPAddIndependentWebsite
_BPAddIndependentFax _BPAddIndependentFax
//@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" ]  } */
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
  association [0..1] to I_BusPartAllowedRoleCategoryTP as _RoleAllowList               on  $projection.BusinessPartner = _RoleAllowList.BusinessPartner
  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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNER",
"I_BUSPARTPERSONFULLNAME"
],
"ASSOCIATED":
[
"I_ACADEMICTITLE",
"I_ACADEMICTITLETEXT",
"I_BPADDINDEPENDENTFAXTP",
"I_BPADDINDEPENDENTWEBSITETP",
"I_BPADDRINDEPENDENTEMAILTP_2",
"I_BPADDRINDEPENDENTMOBILETP_2",
"I_BPADDRINDEPENDENTPHONETP_2",
"I_BPCURRENTDEFAULTADDRESS",
"I_BPDATACONTROLLERTP_2",
"I_BPGENDERVALUEHELP",
"I_BPRELSHPCONTACTPERSONTMPTP",
"I_BUPALEGALENTITY",
"I_BUSINESSPARTNERADDRESSTP_2",
"I_BUSINESSPARTNERBANKTP_2",
"I_BUSINESSPARTNERFORMOFADDRESS",
"I_BUSINESSPARTNERGROUPING",
"I_BUSINESSPARTNERGROUPTYPE",
"I_BUSINESSPARTNERINDUSTRYTP_2",
"I_BUSINESSPARTNERLEGALFORM",
"I_BUSINESSPARTNEROCCUPATION",
"I_BUSINESSPARTNERPRINTFORMAT",
"I_BUSINESSPARTNERROLETP_2",
"I_BUSINESSPARTNERTAXNUMBERTP_2",
"I_BUSINESSPARTNERTYPE",
"I_BUSPARTACADEMICTITLE",
"I_BUSPARTAUTHORIZATIONGROUP",
"I_BUSPARTBIRTHDATESTATUS",
"I_BUSPARTCATEGORY",
"I_BUSPARTCONTACTPERMISSION",
"I_BUSPARTDATAORIGINTYPE",
"I_BUSPARTIDENTIFICATIONTP_2",
"I_BUSPARTMARITALSTATUS",
"I_BUSPARTNAMEFORMAT",
"I_BUSPARTPERSONFULLNAME",
"I_BUSPARTPREFIXNAME",
"I_BUSPARTRELATIONSHIPTMPTP",
"I_BUSPARTSUPPLEMENTNAME",
"I_COUNTRY",
"I_LANGUAGETEXT",
"I_PAYMENTCARDTP_2",
"I_USER"
],
"BASE":
[
"I_BUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/