C_CADocumentClearedItem

@AbapCatalog.viewEnhancementCategory: [#NONE]

@EndUserText.label: 'Cleared Item of a CA Document'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #C

@VDM.viewType: #CONSUMPTION
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]

@Metadata.allowExtensions: true
define view entity C_CADocumentClearedItem
  as select from R_CADocumentBPItemTP
{

  key CADocumentNumber,
  key CARepetitionItemNumber,
  key CABPItemNumber,
  key CASubItemNumber,

      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      Division,
      PersonnelNumber,
      PartnerCompany,
      BusinessPartner,
      CAContract,
      CAProviderContractItemNumber,
      CAAdditionalContract,
      ContractAccount,
      CASubApplication,
      AltvContractAcctForCollvBills,
      CAReconciliationAccount,
      CAApplicationArea,
      CAMainTransaction,
      CASubTransaction,
      CAAccountDeterminationCode,
      CADoubtfulOrValueAdjmtCode,
      CAAccountAssignmentCategory,
      CAAccountAssignment,
      CADocumentType,
      CAIsDownPaymentRequest,
      CAItemIsOnlyForSettlement,
      CAStatisticalItemCode,
      CABPItemText,
      CANumberOfRepetitionItems,
      CARepetitionGroup,
      CAStartDateOfBillingPeriod,
      CAEndDateOfBillingPeriod,
      CAGroupingCodeForBPItems,
      CAPeriodCode,
      CAChangeIsForbidden,
      CAInterestCode,
      CARoundingItemCode,
      CAReceivingCountry,
      CAInternalPostingReasonCode,
      CAWorkflowCheckReason,
      CAWorkflowCheckProcess,
      CANegativePostingControlCode,
      CAPartnerSettlementStatus,
      CAIsPartOfJointLiability,
      CADocumentOriginCode,
      CASubstituteDocumentNumber,
      CASubstituteDocumentCategory,
      CAStatisticalCodeOfOriginItem,
      CADocumentNumberOfOriginItem,
      CAReferenceDocument,
      DocumentDate,
      CAPostingDate,
      CANetDueDate,
      CADeferralDate,
      TransactionCurrency,
      CompanyCodeCurrency,
      AdditionalCurrency1,
      AdditionalCurrency2,
      CAExchangeRate,
      ExchRateIsIndirectQuotation,
      CACashDiscountDueDate,
      CACashDiscountRate,
      TaxCode,
      CASupplementaryTaxCode,
      CADownPaymentTaxAccount,
      CADownPaymentOffsetTaxAccount,
      TaxJurisdiction,
      CATaxDate,
      WithholdingTaxCode,
      CAWithholdingTaxSupplement,
      CAWithholdingTaxCategory,
      CAWithholdingTaxPercentage,
      WithholdingTaxCertificate,
      CAOtherTaxCode,
      CAGroupingCodeForTaxItems,
      CATaxIsCalculatedExternally,
      CATaxAmountIsSetFromExternal,
      CAPaymentMethod,
      CAPaymentCompanyCode,
      CAGroupingForPayment,
      CAPaymentSpecificationCategory,
      CAClearingStatus,
      CAClearingDate,
      CAClearingDocumentNumber,
      CAPostingDateOfClearingDoc,
      CAClearingReason,
      CAClearingCurrency,
      CAValueDateForClearing,
      CAClearingRestrictionCode,
      CAClearingPostingIsReset,
      CAItemIsWithdrawn,
      CAItemIsExcludedFromDunning,
      CADunningProcedure,
      CAGrpgCodeForTransfToCollAgcy,
      CAIsIncludedInCollectionCase,
      CashPlanningGroup,
      PlanningLevel,
      CAAdditionalDaysForCashMgmt,
      CAAltvBPForPayment,
      CABankOfAltvBPForPayment,
      CAAddressOfAltvBPForPayment,
      CACardOfAltvBPForPayment,
      SEPAMandateCAInternalID,
      CAGLPostingCurrency,
      CAIsSeparateLineItemInGL,
      CAIsCashFlowItem,
      CACashFlowAccount,
      CACashFlowCompanyCode,
      CAPaymentPreNotificationCode,
      CASEPAPreNotificationNumber,
      CASEPAPreNotifOriginCode,
      CASEPAPreNotifExecutionDate,
      CASEPAPreNotificationRqmtCode,
      CARevenueDistrFinalRecipient,
      CARevenueDistrCurrentStatus,
      CARevenueDistrLastStatus,
      CACurrentFactoringStatusOfRbl,
      CAFactoringCheckStsForClrgInfo,
      CAFactoringItem,
      ControllingArea,
      ChartOfAccounts,
      Country,
      TaxCalculationProcedure,


      //Amounts

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAAmountInTransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CAAmountInThirdCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAEligibleAmountForCshDiscount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxAmountInTransCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInSecondCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxAmountInThirdCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CABaseAmountForWithholdingTax,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CAWithholdingTaxAmount,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      CATaxPortionInLocalCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      CATaxPortionInTransCurrency,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CAClearingAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CATaxAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'CAClearingCurrency'
      CACashDiscAmountInClearingCrcy,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      PlannedAmtInTransactionCrcy,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingAmount,
      @Semantics.amount.currencyCode: 'CAGLPostingCurrency'
      CAGLPostingTaxAmount,


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



}
where
  CAClearingDocumentNumber <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CADOCUMENTBPITEMTP"
],
"ASSOCIATED":
[
"I_BUSINESSAREA",
"I_BUSINESSPARTNER",
"I_CAACCOUNTASSIGNMENTCATEGORY",
"I_CAACCOUNTDETNCODE",
"I_CAAPPLICATIONAREA",
"I_CACLEARINGREASON",
"I_CACLEARINGRESTRICTIONCODE",
"I_CACLEARINGSTATUS",
"I_CADBTFLORVALUEADJMTCODE",
"I_CADOCUMENTBPITEMUI",
"I_CADOCUMENTHEADER",
"I_CADOCUMENTTYPE",
"I_CADUNNINGPROCEDURE",
"I_CAFACTORINGCLRGCHECKSTATUS",
"I_CAFACTORINGRECEIVABLESTATUS",
"I_CAINTERESTCODE",
"I_CAINTPOSTINGREASONCODE",
"I_CAMAINTRANSACTION",
"I_CANEGATIVEPOSTINGCTRLCODE",
"I_CAORIGLSTSTCLITEMCODE",
"I_CAOTHERTAXCODE",
"I_CAPARTNERSETTLEMENTSTATUS",
"I_CAPAYMENTMETHOD",
"I_CAPAYTPRENOTIFICATIONCODE",
"I_CAPAYTSPECIFICATIONCAT",
"I_CAPERIODCODE",
"I_CAPROVIDERCONTRACTHEADER",
"I_CAREVENUEDISTRSTATUS",
"I_CAROUNDINGITEMCODE",
"I_CASEPAPRENOTIFORIGINCODE",
"I_CASEPAPRENOTIFRQMTCODE",
"I_CASTATISTICALITEMCODE",
"I_CASUBAPPLICATION",
"I_CASUBSTITUTEDOCCATEGORY",
"I_CASUBTRANSACTION",
"I_CAWITHHOLDINGTAXCAT",
"I_CAWITHHOLDINGTAXSUPPLEMENT",
"I_CAWORKFLOWCHECKPROCESS",
"I_CAWORKFLOWCHECKREASON",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER",
"I_CONTROLLINGAREA",
"I_COUNTRY",
"I_CURRENCY",
"I_DIVISION",
"I_GLACCOUNTINCHARTOFACCOUNTS",
"I_PARTNERCOMPANY",
"I_PROFITCENTER",
"I_SEGMENT",
"I_WITHHOLDINGTAXCODE",
"R_CADOCUMENTBPITEMBUSLOCKTP",
"R_CADOCUMENTTP"
],
"BASE":
[
"R_CADOCUMENTBPITEMTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/