C_CADocumentClearedItem

DDL: C_CADOCUMENTCLEAREDITEM Type: view_entity CONSUMPTION Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

Cleared Item of a CA Document

C_CADocumentClearedItem is a Consumption CDS View that provides data about "Cleared Item of a CA Document" in SAP S/4HANA. It reads from 1 data source (R_CADocumentBPItemTP) and exposes 215 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. It is exposed through 2 OData services (UI_CAACCOUNTBALANCE_DISPLAY, UI_CADOCUMENT_MNG). Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

1 data source(s) Exposed by 2 service(s) 215 fields

Data Sources (1)

SourceAliasJoin Type
R_CADocumentBPItemTP ContrAcctgDocumentClearedItem from

Annotations (8)

NameValueLevelField
EndUserText.label Cleared Item of a CA Document view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED

Fields (215)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber
KEY CARepetitionItemNumber CARepetitionItemNumber
KEY CABPItemNumber CABPItemNumber
KEY CASubItemNumber CASubItemNumber
CompanyCode CompanyCode
BusinessArea BusinessArea
BusinessPlace BusinessPlace
Segment Segment
ProfitCenter ProfitCenter
Division Division
PersonnelNumber PersonnelNumber
PartnerCompany PartnerCompany
BusinessPartner BusinessPartner
CAContract CAContract
CAProviderContractName
CASubApplication CASubApplication
CASubApplicationText
CAProviderContractItemNumber CAProviderContractItemNumber
CAAdditionalContract CAAdditionalContract
ContractAccount ContractAccount
AltvContractAcctForCollvBills AltvContractAcctForCollvBills
CAReconciliationAccount CAReconciliationAccount
CAApplicationArea CAApplicationArea
CAMainTransaction CAMainTransaction
CASubTransaction CASubTransaction
CAAccountDeterminationCode CAAccountDeterminationCode
CADoubtfulOrValueAdjmtCode CADoubtfulOrValueAdjmtCode
CAAccountAssignmentCategory CAAccountAssignmentCategory
CAAccountAssignment CAAccountAssignment
CADocumentType CADocumentType
CAIsDownPaymentRequest CAIsDownPaymentRequest
CAItemIsOnlyForSettlement CAItemIsOnlyForSettlement
CABPItemText CABPItemText
CANumberOfRepetitionItems CANumberOfRepetitionItems
CARepetitionGroup CARepetitionGroup
CAEndDateOfBillingPeriod CAEndDateOfBillingPeriod
CAGroupingCodeForBPItems CAGroupingCodeForBPItems
CAPeriodCode CAPeriodCode
CAChangeIsForbidden CAChangeIsForbidden
CAInterestCode CAInterestCode
CARoundingItemCode CARoundingItemCode
CAReceivingCountry CAReceivingCountry
CAInternalPostingReasonCode CAInternalPostingReasonCode
CAWorkflowCheckReason CAWorkflowCheckReason
CAWorkflowCheckProcess CAWorkflowCheckProcess
CANegativePostingControlCode CANegativePostingControlCode
CAPartnerSettlementStatus CAPartnerSettlementStatus
CAIsPartOfJointLiability CAIsPartOfJointLiability
CADocumentOriginCode CADocumentOriginCode
CASubstituteDocumentNumber CASubstituteDocumentNumber
CASubstituteDocumentCategory CASubstituteDocumentCategory
CADocumentNumberOfOriginItem CADocumentNumberOfOriginItem
CAReferenceDocument CAReferenceDocument
DocumentDate DocumentDate
CAPostingDate CAPostingDate
CANetDueDate CANetDueDate
CADeferralDate CADeferralDate
TransactionCurrency TransactionCurrency
CompanyCodeCurrency CompanyCodeCurrency
AdditionalCurrency1 AdditionalCurrency1
AdditionalCurrency2 AdditionalCurrency2
CAExchangeRate CAExchangeRate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation
CACashDiscountDueDate CACashDiscountDueDate
CACashDiscountRate CACashDiscountRate
TaxCode TaxCode
CASupplementaryTaxCode CASupplementaryTaxCode
CADownPaymentTaxAccount CADownPaymentTaxAccount
CADownPaymentOffsetTaxAccount CADownPaymentOffsetTaxAccount
TaxJurisdiction TaxJurisdiction
CATaxDate CATaxDate
WithholdingTaxCode WithholdingTaxCode
CAWithholdingTaxSupplement CAWithholdingTaxSupplement
CAWithholdingTaxCategory CAWithholdingTaxCategory
CAWithholdingTaxPercentage CAWithholdingTaxPercentage
WithholdingTaxCertificate WithholdingTaxCertificate
CAOtherTaxCode CAOtherTaxCode
CAGroupingCodeForTaxItems CAGroupingCodeForTaxItems
CATaxIsCalculatedExternally CATaxIsCalculatedExternally
CATaxAmountIsSetFromExternal CATaxAmountIsSetFromExternal
CAPaymentMethod CAPaymentMethod
CAPaymentCompanyCode CAPaymentCompanyCode
CAGroupingForPayment CAGroupingForPayment
CAPaymentSpecificationCategory CAPaymentSpecificationCategory
CAClearingStatus CAClearingStatus
CAClearingDate CAClearingDate
CAClearingDocumentNumber CAClearingDocumentNumber
CAPostingDateOfClearingDoc CAPostingDateOfClearingDoc
CAClearingReason CAClearingReason
CAClearingCurrency CAClearingCurrency
CAValueDateForClearing CAValueDateForClearing
CAClearingRestrictionCode CAClearingRestrictionCode
CAClearingPostingIsReset CAClearingPostingIsReset
CAItemIsWithdrawn CAItemIsWithdrawn
CAItemIsExcludedFromDunning CAItemIsExcludedFromDunning
CADunningProcedure CADunningProcedure
CAGrpgCodeForTransfToCollAgcy CAGrpgCodeForTransfToCollAgcy
CAIsIncludedInCollectionCase CAIsIncludedInCollectionCase
CashPlanningGroup CashPlanningGroup
PlanningLevel PlanningLevel
CAAdditionalDaysForCashMgmt CAAdditionalDaysForCashMgmt
CAAltvBPForPayment CAAltvBPForPayment
CABankOfAltvBPForPayment CABankOfAltvBPForPayment
CAAddressOfAltvBPForPayment CAAddressOfAltvBPForPayment
CACardOfAltvBPForPayment CACardOfAltvBPForPayment
SEPAMandateCAInternalID SEPAMandateCAInternalID
CAGLPostingCurrency CAGLPostingCurrency
CAIsSeparateLineItemInGL CAIsSeparateLineItemInGL
CAIsCashFlowItem CAIsCashFlowItem
CACashFlowAccount CACashFlowAccount
CACashFlowCompanyCode CACashFlowCompanyCode
CAPaymentPreNotificationCode CAPaymentPreNotificationCode
CASEPAPreNotificationNumber CASEPAPreNotificationNumber
CASEPAPreNotifOriginCode CASEPAPreNotifOriginCode
CASEPAPreNotifExecutionDate CASEPAPreNotifExecutionDate
CASEPAPreNotificationRqmtCode CASEPAPreNotificationRqmtCode
CARevenueDistrFinalRecipient CARevenueDistrFinalRecipient
CARevenueDistrCurrentStatus CARevenueDistrCurrentStatus
CARevenueDistrLastStatus CARevenueDistrLastStatus
CACurrentFactoringStatusOfRbl CACurrentFactoringStatusOfRbl
CAFactoringCheckStsForClrgInfo CAFactoringCheckStsForClrgInfo
CAFactoringItem CAFactoringItem
ControllingArea ControllingArea
ChartOfAccounts ChartOfAccounts
Country Country
TaxCalculationProcedure _Country TaxCalculationProcedure
CAAmountInLocalCurrency CAAmountInLocalCurrency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency
CAAmountInSecondCurrency CAAmountInSecondCurrency
CAAmountInThirdCurrency CAAmountInThirdCurrency
CAEligibleAmountForCshDiscount CAEligibleAmountForCshDiscount
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency
CATaxAmountInTransCurrency CATaxAmountInTransCurrency
CATaxAmountInSecondCurrency CATaxAmountInSecondCurrency
CATaxAmountInThirdCurrency CATaxAmountInThirdCurrency
CABaseAmountForWithholdingTax CABaseAmountForWithholdingTax
CAWithholdingTaxAmount CAWithholdingTaxAmount
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency
CATaxPortionInTransCurrency CATaxPortionInTransCurrency
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy
CATaxAmountInClearingCrcy CATaxAmountInClearingCrcy
CACashDiscAmountInClearingCrcy CACashDiscAmountInClearingCrcy
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy
CAGLPostingAmount CAGLPostingAmount
CAGLPostingTaxAmount CAGLPostingTaxAmount
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAAccountAssignmentCategory _CAAccountAssignmentCategory
_CAAccountDeterminationCode _CAAccountDeterminationCode
_CAApplicationArea _CAApplicationArea
_CAClearingDocument _CAClearingDocument
_CAClearingReason _CAClearingReason
_CAClearingRestrictionCode _CAClearingRestrictionCode
_CAClearingStatus _CAClearingStatus
_CADbtflOrValueAdjmtCode _CADbtflOrValueAdjmtCode
_CADocument _CADocument
_CADocumentType _CADocumentType
_CADunningProcedure _CADunningProcedure
_CAFactoringClrgCheckStatus _CAFactoringClrgCheckStatus
_CAFactoringReceivableStatus _CAFactoringReceivableStatus
_CAInterestCode _CAInterestCode
_CAInternalPostingReasonCode _CAInternalPostingReasonCode
_CAMainTransaction _CAMainTransaction
_CANegativePostingControlCode _CANegativePostingControlCode
_CAOriginDocument _CAOriginDocument
_CAOriglStatisticalItemCode _CAOriglStatisticalItemCode
_CAOtherTaxCode _CAOtherTaxCode
_CAPartner _CAPartner
_CAPartnerSettlementStatus _CAPartnerSettlementStatus
_CAPaymentMethod _CAPaymentMethod
_CAPaytPreNotificationCode _CAPaytPreNotificationCode
_CAPaytSpecificationCategory _CAPaytSpecificationCategory
_CAPeriodCode _CAPeriodCode
_CARevenueDistrCurrentStatus _CARevenueDistrCurrentStatus
_CARevenueDistrLastStatus _CARevenueDistrLastStatus
_CARoundingItemCode _CARoundingItemCode
_CASEPAPreNotificationRqmtCode _CASEPAPreNotificationRqmtCode
_CASEPAPreNotifOriginCode _CASEPAPreNotifOriginCode
_CashFlowAccount _CashFlowAccount
_CashFlowCompanyCode _CashFlowCompanyCode
_CashPlanningGroup _CashPlanningGroup
_CASubApplication _CASubApplication
_CASubstituteDocumentCategory _CASubstituteDocumentCategory
_CASubstituteDocument _CASubstituteDocument
_CASubTransaction _CASubTransaction
_CAWithholdingTaxCategory _CAWithholdingTaxCategory
_CAWithholdingTaxSupplement _CAWithholdingTaxSupplement
_CAWorkflowCheckProcess _CAWorkflowCheckProcess
_CAWorkflowCheckReason _CAWorkflowCheckReason
_ClearingCurrency _ClearingCurrency
_CollvBillsAltvContractAccount _CollvBillsAltvContractAccount
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ContractAccount _ContractAccount
_ControllingArea _ControllingArea
_ChartOfAccounts _ChartOfAccounts
_Country _Country
_Division _Division
_DownPaymentOffsetTaxAccount _DownPaymentOffsetTaxAccount
_DownPaymentTaxAccount _DownPaymentTaxAccount
_GLPostingCurrency _GLPostingCurrency
_PartnerCompany _PartnerCompany
_PaytAltvBusinessPartner _PaytAltvBusinessPartner
_PlanningLevel _PlanningLevel
_PaymentCompanyCode _PaymentCompanyCode
_ProfitCenter _ProfitCenter
_ProviderContract _ProviderContract
_ReceivingCountry _ReceivingCountry
_ReconciliationAccount _ReconciliationAccount
_RevnDistrFnlRcpntContrAccount _RevnDistrFnlRcpntContrAccount
_Segment _Segment
_TransactionCurrency _TransactionCurrency
_WithholdingTaxCode _WithholdingTaxCode 
@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 as ContrAcctgDocumentClearedItem
{

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

      CompanyCode,
      BusinessArea,
      BusinessPlace,
      Segment,
      ProfitCenter,
      Division,
      PersonnelNumber,
      PartnerCompany,
      BusinessPartner,
      
      @ObjectModel.text.element: [ 'CAProviderContractName' ]
      CAContract,
      
      @Semantics.text: true
      cast(_ProviderContract.CAProviderContractName as vtref_text_gfn_kk preserving type )   as CAProviderContractName,

      @ObjectModel.text.element: ['CASubApplicationText']
      CASubApplication,

      @Semantics.text: true
      cast(_CASubApplication._CASubApplicationText[1:Language=$session.system_language].CASubApplicationText as subap_text_gfn_kk preserving type ) as CASubApplicationText,
      
      CAProviderContractItemNumber,
      CAAdditionalContract,
      ContractAccount,
      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,
      _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 */
      _AdditionalCurrency1,
      _AdditionalCurrency2,
      _BusinessArea,
      _BusinessPartner,
      _CAAccountAssignmentCategory,
      _CAAccountDeterminationCode,
      _CAApplicationArea,
      _CAClearingDocument,
      _CAClearingReason,
      _CAClearingRestrictionCode,
      _CAClearingStatus,
      _CADbtflOrValueAdjmtCode,
      _CADocument,
      _CADocumentType,
      _CADunningProcedure,
      _CAFactoringClrgCheckStatus,
      _CAFactoringReceivableStatus,
      _CAInterestCode,
      _CAInternalPostingReasonCode,
      _CAMainTransaction,
      _CANegativePostingControlCode,
      _CAOriginDocument,
      _CAOriglStatisticalItemCode,
      _CAOtherTaxCode,
      _CAPartner,
      _CAPartnerSettlementStatus,
      _CAPaymentMethod,
      _CAPaytPreNotificationCode,
      _CAPaytSpecificationCategory,
      _CAPeriodCode,
      _CARevenueDistrCurrentStatus,
      _CARevenueDistrLastStatus,
      _CARoundingItemCode,
      _CASEPAPreNotificationRqmtCode,
      _CASEPAPreNotifOriginCode,
      _CashFlowAccount,
      _CashFlowCompanyCode,
      _CashPlanningGroup,
      _CAStatisticalItemCode,
      _CASubApplication,
      _CASubstituteDocumentCategory,
      _CASubstituteDocument,
      _CASubTransaction,
      _CAWithholdingTaxCategory,
      _CAWithholdingTaxSupplement,
      _CAWorkflowCheckProcess,
      _CAWorkflowCheckReason,
      _ClearingCurrency,
      _CollvBillsAltvContractAccount,
      _CompanyCode,
      _CompanyCodeCurrency,
      _ContractAccount,
      _ControllingArea,
      _ChartOfAccounts,
      _Country,
      _Division,
      _DownPaymentOffsetTaxAccount,
      _DownPaymentTaxAccount,
      _GLPostingCurrency,
      _PartnerCompany,
      _PaytAltvBusinessPartner,
      _PlanningLevel,
      _PaymentCompanyCode,
      _ProfitCenter,
      _ProviderContract,
      _ReceivingCountry,
      _ReconciliationAccount,
      _RevnDistrFnlRcpntContrAccount,
      _Segment,
      _TransactionCurrency,
      _WithholdingTaxCode

}
where
  CAClearingDocumentNumber <> ''

Learn More