I_CADocumentBPItemCube

@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #CHECK
 @Metadata.allowExtensions:true

@EndUserText.label: 'Document Business Partner Item - Cube'

@Analytics: {
    dataCategory: #CUBE,
    internalName: #LOCAL,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
            mapping:[ {
                        table           : 'dfkkop',role: #MAIN,
                        viewElement     : ['CADocumentNumber','CARepetitionItemNumber', 'CABPItemNumber' , 'CASubItemNumber'],
                        tableElement    : ['opbel','opupw','opupk' ,'opupz' ]
                      }
                    ]
       }
    }
}

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
    supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                             #SQL_DATA_SOURCE,
                             #CDS_MODELING_DATA_SOURCE,
                             #EXTRACTION_DATA_SOURCE,
                             #ANALYTICAL_PROVIDER  ],
     usageType:{
         serviceQuality: #C,
         sizeCategory: #XXL,
         dataClass: #TRANSACTIONAL
     },
     modelingPattern:#ANALYTICAL_CUBE
}

@VDM.viewType: #COMPOSITE

define view entity I_CADocumentBPItemCube
  as select from I_CADocumentBPItem
{
  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,
      @ObjectModel.foreignKey.association: '_CompCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      BusinessArea,
      BusinessPlace,
      @ObjectModel.foreignKey.association: '_Segment'
      Segment,
      ProfitCenter,
      @ObjectModel.foreignKey.association: '_Division'
      Division,
      PersonnelNumber,
      @ObjectModel.foreignKey.association: '_PartnerCompany'
      PartnerCompany,
      @ObjectModel.foreignKey.association: '_BusinessPartner'
      BusinessPartner,
      CAContract,
      CAProviderContractItemNumber,
      CAAdditionalContract,
      @ObjectModel.foreignKey.association: '_CAHeader'
      ContractAccount,
      @ObjectModel.foreignKey.association: '_CASubApplication'
      CASubApplication,
      @ObjectModel.foreignKey.association: '_CAHeaderCollvBills'
      AltvContractAcctForCollvBills,
      CAReconciliationAccount,
      @ObjectModel.foreignKey.association: '_ApplArea'
      CAApplicationArea,
      @ObjectModel.foreignKey.association: '_MainTransaction'
      CAMainTransaction,
      @ObjectModel.foreignKey.association: '_SubTransaction'
      CASubTransaction,
      CAAccountDeterminationCode,
      CADoubtfulOrValueAdjmtCode,
      @ObjectModel.foreignKey.association: '_AcctAssgmtCat'
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      @ObjectModel.foreignKey.association: '_DocType'
      CADocumentType,
      CAIsDownPaymentRequest,
      @Semantics.booleanIndicator
      CAItemIsOnlyForSettlement,
      CAStatisticalItemCode,
      CABPItemText,
      CANumberOfRepetitionItems,
      CARepetitionGroup,
      CAStartDateOfBillingPeriod,
      CAEndDateOfBillingPeriod,
      CAGroupingCodeForBPItems,
      @ObjectModel.foreignKey.association: '_PeriodCode'
      CAPeriodCode,
      CAChangeIsForbidden,
      @ObjectModel.foreignKey.association: '_InterestCode'
      CAInterestCode,
      CARoundingItemCode,
      @ObjectModel.foreignKey.association: '_ReceivingCountry'
      CAReceivingCountry,
      CAInternalPostingReasonCode,
      @ObjectModel.foreignKey.association: '_WorkflowCheckReason'
      CAWorkflowCheckReason,
      @ObjectModel.foreignKey.association: '_WorkflowCheckProcess'
      CAWorkflowCheckProcess,
      CANegativePostingControlCode,
      CAPartnerSettlementStatus,
      @Semantics.booleanIndicator
      CAIsPartOfJointLiability,  
      CADocumentOriginCode,
      @ObjectModel.foreignKey.association: '_SubstitDocHeader'
      CASubstituteDocumentNumber,
      CASubstituteDocumentCategory,
      CAStatisticalCodeOfOriginItem,
      @ObjectModel.foreignKey.association: '_OriginDocHeader'
      CADocumentNumberOfOriginItem,
      CAReferenceDocument,
      DocumentDate,
      CAPostingDate,
      CANetDueDate,
      CADeferralDate,
      @ObjectModel.foreignKey.association: '_Currency'
      TransactionCurrency,
      @ObjectModel.foreignKey.association: '_CompanyCodeCurrency'
      CompanyCodeCurrency,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInThirdCurrency,
      CACashDiscountDueDate,
      CACashDiscountRate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'

      CAEligibleAmountForCshDiscount,
      TaxCode,
      CASupplementaryTaxCode,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxAmountInTransCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInThirdCurrency,
      CADownPaymentTaxAccount,
      CADownPaymentOffsetTaxAccount,
      TaxJurisdiction,
      CATaxDate,
      WithholdingTaxCode,
      CAWithholdingTaxSupplement,
      CAWithholdingTaxCategory,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CABaseAmountForWithholdingTax,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAWithholdingTaxAmount,
      CAWithholdingTaxPercentage,
      WithholdingTaxCertificate,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,
      CATaxIsCalculatedExternally,
      CATaxAmountIsSetFromExternal,
      CAPaymentMethod,
      @ObjectModel.foreignKey.association: '_CompCodePayt'
      CAPaymentCompanyCode,
      CAGroupingForPayment,
      CAPaymentSpecificationCategory,
      CAClearingStatus,
      CAClearingDate,
      @ObjectModel.foreignKey.association: '_ClearingDocHeader'
      CAClearingDocumentNumber,
      CAPostingDateOfClearingDoc,
      @ObjectModel.foreignKey.association: '_ClearingReason'
      CAClearingReason,
      @ObjectModel.foreignKey.association: '_ClearingCurrency'
      CAClearingCurrency,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CAClearingAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CATaxAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CACashDiscAmountInClearingCrcy,
      CAValueDateForClearing,
      @ObjectModel.foreignKey.association: '_ClrgRstrcnCode'
      CAClearingRestrictionCode,
      CAClearingPostingIsReset,
      CAItemIsWithdrawn,
      CAItemIsExcludedFromDunning,
      @ObjectModel.foreignKey.association: '_DunningProcedure'
      CADunningProcedure,
      CAGrpgCodeForTransfToCollAgcy,
      CAIsIncludedInCollectionCase,
      CashPlanningGroup,
      PlanningLevel,
      CAAdditionalDaysForCashMgmt,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      PlannedAmtInTransactionCrcy,
      @ObjectModel.foreignKey.association: '_AltvBPForPayment'
      CAAltvBPForPayment,
      CABankOfAltvBPForPayment,
      CAAddressOfAltvBPForPayment,
      CACardOfAltvBPForPayment,
      SEPAMandateCAInternalID,
      CAGLPostingCurrency,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingAmount,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingTaxAmount,
      CAIsSeparateLineItemInGL,
      CAIsCashFlowItem,
      CACashFlowAccount,
      @ObjectModel.foreignKey.association: '_CompCodeCashFlow'
      CACashFlowCompanyCode,
      CAPaymentPreNotificationCode,
      CASEPAPreNotificationNumber,
      CASEPAPreNotifOriginCode,
      CASEPAPreNotifExecutionDate,
      CASEPAPreNotificationRqmtCode,
      @ObjectModel.foreignKey.association: '_CAHeaderFinalRec'
      CARevenueDistrFinalRecipient,
      CARevenueDistrCurrentStatus,
      CARevenueDistrLastStatus,
      CACurrentFactoringStatusOfRbl,
      CAFactoringCheckStsForClrgInfo,
      CAFactoringItem,

      /* Associations */
      _AcctAssgmtCat,
      _AltvBPForPayment,
      _ApplArea,
      _BusinessArea,
      _BusinessPartner,
      _CAHeader,
      _CAHeaderCollvBills,
      _CAHeaderFinalRec,
      _CAPartner,
      _CASubApplication,
      _ClearingCurrency,
      _ClearingDocHeader,
      _ClearingReason,
      _ClrgRstrcnCode,
      _CompanyCodeCurrency,
      _CompCode,
      _CompCodeCashFlow,
      _CompCodePayt,
      _Currency,
      _Division,
      _DocHeader,
      _DocType,
      _DunningProcedure,
      _GLPostingCurrency,
      _InterestCode,
      _MainTransaction,
      _OriginDocHeader,
      _PartnerCompany,
      _PeriodCode,
      _ProviderContract,
      _ReceivingCountry,
      _Segment,
      _SubstitDocHeader,
      _SubTransaction,
      _WorkflowCheckProcess,
      _WorkflowCheckReason

}