I_BPCustomerCompanyGov

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'BP Customer Company Governance'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity I_BPCustomerCompanyGov
  as select from I_BPCustomerCompanyProcess
  association [1..1] to I_BPCustomerGov           as _Customer                on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                              and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                              and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                              and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
  
  association [0..1] to I_MasterDataChangeProcess as _MasterDataChangeProcess on  $projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key CompanyCode,
      BPAssignmentID,
      Customer,
      PersonnelNumber,
      PhysicalInventoryBlockInd,
      DeletionIndicator,
      LayoutSortingRule,
      AccountingClerk,
      ReconciliationAccount,
      AuthorizationGroup,
      CustomerHeadOffice,
      AlternativePayerAccount,
      PaymentMethodsList,
      CustomerSupplierClearingIsUsed,
      PaymentBlockingReason,
      PaymentTerms,
      BillExchChargePaymentTerms,
      InterestCalculationCode,
      InterestCalculationDate,
      IntrstCalcFrequencyInMonths,
      AccountByCustomer,
      UserAtCustomer,
      CustomerAccountNote,
      CashPlanningGroup,
      CollectiveInvoiceVariant,
      IsToBeLocallyProcessed,
      BPPeriodicAccountStatement,
      LastInterestCalcRunDate,
      RecordPaymentHistoryIndicator,
      APARToleranceGroup,
      CheckPaidDurationInDays,
      HouseBank,
      ItemIsToBePaidSeparately,
      CustPreviousMasterRecordNumber,
      KnownOrNegotiatedLeave,
      DunningNoticeGroup,
      LockboxInternalID,
      PaymentMethodSupplement,
      BuyingGroupAccountNumber,
      PaytAdviceIsSentbyEDI,
      SupplierReleaseGroup,
      AccountingClerkFaxNumber,
      AccountingClerkInternetAddress,
      CreditMemoPaymentTerms,
      ValueAdjustmentKey,
      DeletionIsBlocked,
      AccountingClerkPhoneNumber,
      AcctsReceivablePledgingCode,
//      WithholdingTaxCountry,

//      @Semantics.booleanIndicator

//      IsBusinessPurposeCompleted,

//      PaymentClearingGroup,

      PaymentReason,
      cast(
      case when MDChgProcessStep = _MasterDataChangeProcess.MDChgProcessCurrentStepNumber and _MasterDataChangeProcess.MDChgProcessCurrentStepNumber <> '0000' or
          MDChgProcessStep = '0001' and  _MasterDataChangeProcess.MDChgProcessCurrentStepNumber = '0000' then 'X'
      else ' '
      end as abap_boolean preserving type
      ) as MasterDataIsCurrent,
      
      _Customer
} where MDChgProcessSourceModified <> 'D'

union all select from I_CustomerCompany
association [1..1] to I_BPCustomerGov             as _Customer                  on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                                and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject

association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on  $projection.Customer = _CustomerToBusinessPartner.Customer
{
  key '000000000000'                                              as MasterDataChangeProcess,
  key '0000'                                                      as MDChgProcessStep,
  key ''                                                          as MDChgProcessSrceSystem,
  key _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as MDChgProcessSrceObject,
  key CompanyCode,
      '000000000002'                                              as BPAssignmentID,
      Customer,
      PersonnelNumber,
      PhysicalInventoryBlockInd,
      DeletionIndicator,
      LayoutSortingRule,
      AccountingClerk,
      ReconciliationAccount,
      AuthorizationGroup,
      CustomerHeadOffice,
      AlternativePayerAccount,
      PaymentMethodsList,
      CustomerSupplierClearingIsUsed,
      PaymentBlockingReason,
      PaymentTerms,
      BillExchChargePaymentTerms,
      InterestCalculationCode,
      InterestCalculationDate,
      IntrstCalcFrequencyInMonths,
      AccountByCustomer,
      UserAtCustomer,
      CustomerAccountNote,
      CashPlanningGroup,
      CollectiveInvoiceVariant,
      IsToBeLocallyProcessed,
      BPPeriodicAccountStatement,
      LastInterestCalcRunDate,
      RecordPaymentHistoryIndicator,
      APARToleranceGroup,
      CheckPaidDurationInDays,
      HouseBank,
      ItemIsToBePaidSeparately,
      CustPreviousMasterRecordNumber,
      KnownOrNegotiatedLeave,
      DunningNoticeGroup,
      LockboxInternalID,
      PaymentMethodSupplement,
      BuyingGroupAccountNumber,
      PaytAdviceIsSentbyEDI,
      SupplierReleaseGroup,
      AccountingClerkFaxNumber,
      AccountingClerkInternetAddress,
      CreditMemoPaymentTerms,
      ValueAdjustmentKey,
      DeletionIsBlocked,
      AccountingClerkPhoneNumber,
      AcctsReceivablePledgingCode,
//      WithholdingTaxCountry,

//      IsBusinessPurposeCompleted,

//      PaymentClearingGroup,

      PaymentReason,
      cast( 'X' as abap_boolean preserving type )                 as MasterDataIsCurrent,
      /* Associations */
      _Customer
}
where 
  _CustomerToBusinessPartner._BusinessPartner.BusinessPartner is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCUSTOMERCOMPANYPROCESS",
"I_BUSINESSPARTNER",
"I_CUSTOMERCOMPANY",
"I_CUSTOMERTOBUSINESSPARTNER",
"I_MASTERDATACHANGEPROCESS"
],
"ASSOCIATED":
[
"I_BPCUSTOMERGOV"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/