cic_supplierdata

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Proj. on Supplier (Industry Cloud Solutions)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity cic_supplierdata
  as select distinct from I_Supplier             as Supplier

//    inner join   I_BPMultipleAssignment as _SupplierBPAssoc on _SupplierBPAssoc.BPObjectID = Supplier.Supplier

//                                                            and _SupplierBPAssoc.BPAssignmentCategory = 'SUPPL'

//                                                            and _SupplierBPAssoc.IsStandardAssignment = 'X'

    inner join I_Supplier_to_BusinessPartner as _SupplierBPAssoc on _SupplierBPAssoc.Supplier = Supplier.Supplier
    inner join   I_BusinessPartner      as _BusinessPartner on _BusinessPartner.BusinessPartnerUUID = _SupplierBPAssoc.BusinessPartnerUUID
    association [0..1] to CIC_LanguageRegion     as _Language    on $projection.BPLanguage = _Language.Language
    association [0..1] to CIC_LanguageRegion     as _CorresLanguage    on $projection.BPCorrespondenceLanguage = _CorresLanguage.Language
{
  key Supplier.Supplier,
      Supplier.DeletionIndicator,
      _BusinessPartner.BusinessPartner,
      _BusinessPartner.BusinessPartnerCategory,  //Person or Organization

      _BusinessPartner.FirstName,
      _BusinessPartner.LastName,
      _BusinessPartner.MiddleName,
      _BusinessPartner.Language as BPLanguage,
      _BusinessPartner.GenderCodeName,
      _BusinessPartner.BusinessPartnerName, //BP Full Name for Person and Organization

      _BusinessPartner.CorrespondenceLanguage as BPCorrespondenceLanguage,
      _BusinessPartner.BirthDate,
      _BusinessPartner.AcademicTitle,


      // Organization fields

      _BusinessPartner.OrganizationBPName1,
      _BusinessPartner.OrganizationBPName2,
      _BusinessPartner.OrganizationBPName3,
      _BusinessPartner.OrganizationBPName4,

      Supplier.IsBusinessPurposeCompleted,

      _Language.iso2_country as Language,
      _CorresLanguage.iso2_country as CorrespondenceLanguage

//      _BusinessPartner.AdditionalLastName,

//      _BusinessPartner.Initials,

//      _BusinessPartner.FormOfAddress,

//      _BusinessPartner.AcademicTitle,

//      _BusinessPartner.AcademicTitle2,

//      _BusinessPartner.LastNamePrefix,

//      _BusinessPartner.LastNameSecondPrefix,

//      _BusinessPartner.BusinessPartnerSupplementName,

//      _BusinessPartner.BusinessPartnerBirthName,

//      _BusinessPartner.BusinessPartnerNicknameLabel,

//      _BusinessPartner.BusPartMaritalStatus,

//      _BusinessPartner.NaturalPersonEmployerName,

//      _BusinessPartner.BusinessPartnerOccupation,

//      _BusinessPartner.BusinessPartnerBirthplaceName,

//      _BusinessPartner.BusinessPartnerDeathDate,

//      _BusinessPartner.NameCountry,

//      _BusinessPartner.NameFormat,

//      _BusinessPartner.BusinessPartnerSalutation,



}