I_BPAddlSuplrCompanyCodeTP

@AbapCatalog.sqlViewName: 'IBPADDSCCTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'BO view for Company Code for Suppliers'
@ObjectModel.writeEnabled: true
@ObjectModel.createEnabled
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.updateEnabled
@ObjectModel.semanticKey: ['BusinessPartner', 'Supplier', 'CompanyCode']
@ObjectModel.writeDraftPersistence: 'BPADDSCC_D'
@ObjectModel.draftEnabled:true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL

define view I_BPAddlSuplrCompanyCodeTP as 
  select from I_SupplierCompany as BusinessPartnerSupplierCo 
              inner join I_BPMultipleAssignment as BPMultipleAssignment on BusinessPartnerSupplierCo.Supplier = BPMultipleAssignment.BPObjectID
              left outer join t047 as CompanyCodeDunningControl on BusinessPartnerSupplierCo.CompanyCode = CompanyCodeDunningControl.bukrs

  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on  $projection.BusinessPartner = _BusinessPartner.BusinessPartner

  association [1..1] to I_BPAdditionalSupplierTP as _BPAdditionalSupplier on $projection.BusinessPartner = _BPAdditionalSupplier.BusinessPartner
                                                                         and $projection.Supplier = _BPAdditionalSupplier.Supplier 
                                                                         
  association [1..*] to I_BPAddlSuplrWhldgTaxTP as _BPAddlSuplrWhldgTax on $projection.BusinessPartner = _BPAddlSuplrWhldgTax.BusinessPartner
                                                                         and $projection.Supplier = _BPAddlSuplrWhldgTax.Supplier
                                                                         and $projection.CompanyCode = _BPAddlSuplrWhldgTax.CompanyCode
                                                                         
  association [1..*] to I_BPAddlSuplrDunningTP as _BPAddlSuplrDunning on $projection.BusinessPartner = _BPAddlSuplrDunning.BusinessPartner
                                                                         and $projection.Supplier = _BPAddlSuplrDunning.Supplier
                                                                         and $projection.CompanyCode = _BPAddlSuplrDunning.CompanyCode
                                                                         
  association [1..1] to I_CompanyCode as _Country on $projection.CompanyCode = _Country.CompanyCode

  
{
  
      key BPMultipleAssignment.BusinessPartner,
      key BusinessPartnerSupplierCo.Supplier,
      key BusinessPartnerSupplierCo.CompanyCode,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.CompanyCode     as CompanyCodeForEdit,
      BusinessPartnerSupplierCo.Supplier as SupplierForEdit,
      BPMultipleAssignment.BusinessPartner as BusinessPartnerForEdit,
      BusinessPartnerSupplierCo.SupplierIsBlockedForPosting,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.AccountingClerk,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.SupplierClerk,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.AccountingClerkPhoneNumber,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.AccountingClerkFaxNumber,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.AccountingClerkInternetAddress,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.SupplierClerkIDBySupplier,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.IsToBeLocallyProcessed,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.SupplierAccountNote,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.PaymentTerms,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.APARToleranceGroup,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.CheckPaidDurationInDays,  
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'  
      BusinessPartnerSupplierCo.IsDoubleInvoice,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.CustomerSupplierClearingIsUsed,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.ReconciliationAccount,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.SupplierHeadOffice,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.LayoutSortingRule,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.SupplierCertificationDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.PaymentMethodsList,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.PaymentBlockingReason,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.AlternativePayee,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.HouseBank,
      @Semantics.amount.currencyCode: 'Currency'
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.BillOfExchLmtAmtInCoCodeCrcy,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.ItemIsToBePaidSeparately,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.PaymentIsToBeSentByEDI,    
      BusinessPartnerSupplierCo.AuthorizationGroup,   
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.CashPlanningGroup,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.WithholdingTaxCountry,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.InterestCalculationCode,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.InterestCalculationDate,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.IntrstCalcFrequencyInMonths,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.LastInterestCalcRunDate,  
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      BusinessPartnerSupplierCo.MinorityGroup,         
      _Country.Country, // country field to filter payment methods based on company code   

      _Country.CompanyCodeName,   
      @Semantics.currencyCode: true
      _CompanyCode.Currency as Currency,
      CompanyCodeDunningControl.xmabe as CompanyCodeDunningIsByDunArea,
      
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BusinessPartner,     
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BPAdditionalSupplier,    
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlSuplrWhldgTax,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BPAddlSuplrDunning
      
}
where BPMultipleAssignment.IsStandardAssignment <> 'X' and BPMultipleAssignment.BPAssignmentCategory = 'SUPPL'

  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPMULTIPLEASSIGNMENT",
"I_COMPANYCODE",
"I_SUPPLIERCOMPANY",
"T047"
],
"ASSOCIATED":
[
"I_BPADDITIONALSUPPLIERTP",
"I_BPADDLSUPLRDUNNINGTP",
"I_BPADDLSUPLRWHLDGTAXTP",
"I_BUSINESSPARTNERTP",
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/