I_CADocumentBPItemPhysical

@AbapCatalog: { preserveKey: true,
                sqlViewName: 'ICADOCBPITEMPHYS' }

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Document Physical Business Partner Item'

@Metadata.ignorePropagatedAnnotations: true

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

@Search.searchable: true

@VDM.viewType: #COMPOSITE


define view I_CADocumentBPItemPhysical
  as select from I_CADocumentBPItem as CADocBPItem

  association [1..1] to E_CADocumentBPItemPhysical as _Extension on  $projection.CADocumentNumber       = _Extension.CADocumentNumber
                                                                 and $projection.CARepetitionItemNumber = _Extension.CARepetitionItemNumber
                                                                 and $projection.CABPItemNumber         = _Extension.CABPItemNumber
                                                                 and $projection.CASubItemNumber        = _Extension.CASubItemNumber
{
      /* business partner item identification */
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
  key CADocBPItem.CADocumentNumber,
  key CADocBPItem.CARepetitionItemNumber,
  key CADocBPItem.CABPItemNumber,
  key CADocBPItem.CASubItemNumber,

      CADocBPItem.CompanyCode,
      CADocBPItem.BusinessArea,
      CADocBPItem.BusinessPlace,
      CADocBPItem.Segment,
      CADocBPItem.ProfitCenter,
      CADocBPItem.Division,
      CADocBPItem.PersonnelNumber,
      CADocBPItem.PartnerCompany,
      CADocBPItem.BusinessPartner,
      CADocBPItem.CAContract,
      CADocBPItem.CAProviderContractItemNumber,
      CADocBPItem.CAAdditionalContract,
      CADocBPItem.ContractAccount,
      CADocBPItem.CASubApplication,
      CADocBPItem.AltvContractAcctForCollvBills,
      CADocBPItem.CAReconciliationAccount,

      /* posting attributes */
      CADocBPItem.CAApplicationArea,
      CADocBPItem.CAMainTransaction,
      CADocBPItem.CASubTransaction,
      CADocBPItem.CAAccountDeterminationCode,
      CADocBPItem.CADoubtfulOrValueAdjmtCode,
      CADocBPItem.CAAccountAssignmentCategory,
      CADocBPItem.CAAccountAssignment,
      CADocBPItem.CADocumentType,
      CADocBPItem.CAIsDownPaymentRequest,
      CADocBPItem.CAItemIsOnlyForSettlement,
      CADocBPItem.CAStatisticalItemCode,
      CADocBPItem.CABPItemText,
      CADocBPItem.CANumberOfRepetitionItems,
      CADocBPItem.CARepetitionGroup,
      CADocBPItem.CAStartDateOfBillingPeriod,
      CADocBPItem.CAEndDateOfBillingPeriod,
      CADocBPItem.CAGroupingCodeForBPItems,
      CADocBPItem.CAPeriodCode,
      CADocBPItem.CAChangeIsForbidden,
      CADocBPItem.CAInterestCode,
      CADocBPItem.CARoundingItemCode,
      CADocBPItem.CAReceivingCountry,
      CADocBPItem.CAInternalPostingReasonCode,
      CADocBPItem.CAWorkflowCheckReason,
      CADocBPItem.CAWorkflowCheckProcess,
      CADocBPItem.CANegativePostingControlCode,
      CADocBPItem.CAPartnerSettlementStatus,
      CADocBPItem.CAIsPartOfJointLiability,
      CADocBPItem.CADocumentOriginCode,

      /* document references */
      CADocBPItem.CASubstituteDocumentNumber,
      CADocBPItem.CASubstituteDocumentCategory,
      CADocBPItem.CAStatisticalCodeOfOriginItem,
      CADocBPItem.CADocumentNumberOfOriginItem,
      CADocBPItem.CAReferenceDocument,

      /* dates and amounts */
      CADocBPItem.DocumentDate,
      CADocBPItem.CAPostingDate,
      CADocBPItem.CANetDueDate,
      CADocBPItem.CADeferralDate,
      CADocBPItem.TransactionCurrency,
      CADocBPItem.CompanyCodeCurrency,

      //kursf                                                                                                                                                                                                                                                                                                           as  CAExchangeRate,  ////replace due to conversion exit EXCRT

      CADocBPItem.CAExchangeRate,
      CADocBPItem.ExchRateIsIndirectQuotation,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CAAmountInThirdCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CADocBPItemTotalAmountInTC,

      /* cash discount */
      CADocBPItem.CACashDiscountDueDate,
      CADocBPItem.CACashDiscountRate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CAEligibleAmountForCshDiscount,

      /* tax data */
      CADocBPItem.TaxCode,
      CADocBPItem.CASupplementaryTaxCode,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CATaxAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CATaxAmountInTransCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CATaxAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CATaxAmountInThirdCurrency,
      CADocBPItem.CADownPaymentTaxAccount,
      CADocBPItem.CADownPaymentOffsetTaxAccount,
      CADocBPItem.TaxJurisdiction,
      CADocBPItem.CATaxDate,
      CADocBPItem.WithholdingTaxCode,
      CADocBPItem.CAWithholdingTaxSupplement,
      CADocBPItem.CAWithholdingTaxCategory,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CABaseAmountForWithholdingTax,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CAWithholdingTaxAmount,
      CADocBPItem.CAWithholdingTaxPercentage,
      CADocBPItem.WithholdingTaxCertificate,
      CADocBPItem.CAOtherTaxCode,
      CADocBPItem.CAGroupingCodeForTaxItems,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CADocBPItem.CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.CATaxPortionInTransCurrency,
      CADocBPItem.CATaxIsCalculatedExternally,
      CADocBPItem.CATaxAmountIsSetFromExternal,

      /* payment data */
      CADocBPItem.CAPaymentMethod,
      CADocBPItem.CAPaymentCompanyCode,
      CADocBPItem.CAGroupingForPayment,
      CADocBPItem.CAPaymentSpecificationCategory,

      /* clearing data */
      CADocBPItem.CAClearingStatus,
      CADocBPItem.CAClearingDate,
      CADocBPItem.CAClearingDocumentNumber,
      CADocBPItem.CAPostingDateOfClearingDoc,
      CADocBPItem.CAClearingReason,
      CADocBPItem.CAClearingCurrency,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CADocBPItem.CAClearingAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CADocBPItem.CATaxAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CADocBPItem.CACashDiscAmountInClearingCrcy,
      CADocBPItem.CAValueDateForClearing,
      CADocBPItem.CAClearingRestrictionCode,
      CADocBPItem.CAClearingPostingIsReset,
      CADocBPItem.CAItemIsWithdrawn,

      /* dunning and collections */
      CADocBPItem.CAItemIsExcludedFromDunning,
      CADocBPItem.CADunningProcedure,
      CADocBPItem.CAGrpgCodeForTransfToCollAgcy,
      CADocBPItem.CAIsIncludedInCollectionCase,

      /* cash management data */
      CADocBPItem.CashPlanningGroup,
      CADocBPItem.PlanningLevel,
      CADocBPItem.CAAdditionalDaysForCashMgmt,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CADocBPItem.PlannedAmtInTransactionCrcy,

      /* alternative business partner for payment */
      CADocBPItem.CAAltvBPForPayment,
      CADocBPItem.CABankOfAltvBPForPayment,
      CADocBPItem.CAAddressOfAltvBPForPayment,
      CADocBPItem.CACardOfAltvBPForPayment,
      CADocBPItem.SEPAMandateCAInternalID,

      /* GL data */
      CADocBPItem.CAGLPostingCurrency,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CADocBPItem.CAGLPostingAmount,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CADocBPItem.CAGLPostingTaxAmount,
      CADocBPItem.CAIsSeparateLineItemInGL,

      /* cash flow data */
      CADocBPItem.CAIsCashFlowItem,
      CADocBPItem.CACashFlowAccount,
      CADocBPItem.CACashFlowCompanyCode,

      /* pre notification data */
      CADocBPItem.CAPaymentPreNotificationCode,
      CADocBPItem.CASEPAPreNotificationNumber,
      CADocBPItem.CASEPAPreNotifOriginCode,
      CADocBPItem.CASEPAPreNotifExecutionDate,
      CADocBPItem.CASEPAPreNotificationRqmtCode,

      /* revenue distribution data */
      CADocBPItem.CARevenueDistrFinalRecipient,
      CADocBPItem.CARevenueDistrCurrentStatus,
      CADocBPItem.CARevenueDistrLastStatus,

      /* Factoring */
      CADocBPItem.CACurrentFactoringStatusOfRbl,
      CADocBPItem.CAFactoringCheckStsForClrgInfo,
      CADocBPItem.CAFactoringItem,

      /* additional data */
      CADocBPItem.ControllingArea,
      CADocBPItem.ChartOfAccounts,
      CADocBPItem.Country,
      CADocBPItem._Country.TaxCalculationProcedure as TaxCalculationProcedure,


      /* associations from I_CADocumentBPItem */
      CADocBPItem._AcctAssgmtCat,
      CADocBPItem._AcctDetnCode,
      CADocBPItem._AltvBPForPayment,
      CADocBPItem._ApplArea,
      CADocBPItem._BusinessArea,
      CADocBPItem._BusinessPartner,
      CADocBPItem._CAHeader,
      CADocBPItem._CAHeaderCollvBills,
      CADocBPItem._CAHeaderFinalRec,
      CADocBPItem._CAPartner,
      CADocBPItem._CARevnDistrCurSts,
      CADocBPItem._CARevnDistrLastSts,
      CADocBPItem._CARoundingItemCode,
      CADocBPItem._SEPAPreNotifOrignCd,
      CADocBPItem._SEPAPreNotifRqmtCode,
      CADocBPItem._CashFlowAccount,
      CADocBPItem._CASubApplication,
      CADocBPItem._ClearingCurrency,
      CADocBPItem._ClearingDocHeader,
      CADocBPItem._ClearingReason,
      CADocBPItem._ClearingStatus,
      CADocBPItem._ClrgRstrcnCode,
      CADocBPItem._Currency,
      CADocBPItem._CompanyCodeCurrency,
      CADocBPItem._CompCode,
      CADocBPItem._CompCodeCashFlow,
      CADocBPItem._CompCodePayt,
      CADocBPItem._ControllingArea,
      CADocBPItem._ChartOfAccounts,
      CADocBPItem._Country,
      CADocBPItem._DbtflOrValAdjmtCode,
      CADocBPItem._Division,
      CADocBPItem._DocHeader,
      CADocBPItem._DocType,
      CADocBPItem._DunningProcedure,
      CADocBPItem._FactoringRblStatus,
      CADocBPItem._FctrngClrgChkStatus,
      CADocBPItem._GLPostingCurrency,
      CADocBPItem._InterestCode,
      CADocBPItem._IntPostingReasonCode,
      CADocBPItem._MainTransaction,
      CADocBPItem._NgtvPostingCtrlCode,
      CADocBPItem._OffsetTaxAccount,
      CADocBPItem._OriginDocHeader,
      CADocBPItem._OriglStstclItemCode,
      CADocBPItem._OtherTaxCode,
      CADocBPItem._PartnerCompany,
      CADocBPItem._PaytMethod,
      CADocBPItem._PaytPreNotifCode,
      CADocBPItem._PaytSpecCategory,
      CADocBPItem._PeriodCode,
      CADocBPItem._ProfitCenter,
      CADocBPItem._ProviderContract,
      CADocBPItem._PrtnSettlementStatus,
      CADocBPItem._ReceivingCountry,
      CADocBPItem._ReconAccount,
      CADocBPItem._Segment,
      CADocBPItem._StatisticalItemCode,
      CADocBPItem._SubstitDocCategory,
      CADocBPItem._SubstitDocHeader,
      CADocBPItem._SubTransaction,
      CADocBPItem._TaxAccount,
      CADocBPItem._WhldgTaxSuplmnt,
      CADocBPItem._CAWithholdingTaxCat,
      CADocBPItem._WithholdingTaxCode,
      CADocBPItem._WorkflowCheckProcess,
      CADocBPItem._WorkflowCheckReason
}

// don't append/show budget billing requests with clearing restrictions 1 and 6

where
         not(
           CAApplicationArea              = 'R'
           and(
                CAStatisticalItemCode     = 'P'
             or CAStatisticalItemCode     = 'Z'
           )
           and(
                CAClearingRestrictionCode = '1'
             or CAClearingRestrictionCode = '6'
           )
         )