C_CADocumentClearedItem

DDL: C_CADOCUMENTCLEAREDITEM Type: view_entity CONSUMPTION
214 Fields 1 Data Sources

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 214 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

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

Fields (214)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
BusinessPlace BusinessPlace Business place
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
Division Division Internal Division ID
PersonnelNumber PersonnelNumber Personnel No.
PartnerCompany PartnerCompany Trading Partner
BusinessPartner BusinessPartner Issuing Authority
CAContract CAContract Contract
CAProviderContractItemNumber CAProviderContractItemNumber Contract Item
CAAdditionalContract CAAdditionalContract Addl. Reference
ContractAccount ContractAccount Contract Acct
CASubApplication CASubApplication Subapplication
AltvContractAcctForCollvBills AltvContractAcctForCollvBills Coll. Bill Acct
CAReconciliationAccount CAReconciliationAccount G/L Account
CAApplicationArea CAApplicationArea ApplicationArea
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
CADoubtfulOrValueAdjmtCode CADoubtfulOrValueAdjmtCode Doubtful item
CAAccountAssignmentCategory CAAccountAssignmentCategory Acct Assgt Cat.
CAAccountAssignment CAAccountAssignment Acct assignment
CADocumentType CADocumentType Document Type
CAIsDownPaymentRequest CAIsDownPaymentRequest Down Payment
CAItemIsOnlyForSettlement CAItemIsOnlyForSettlement Only Clearing
CABPItemText CABPItemText Text
CANumberOfRepetitionItems CANumberOfRepetitionItems No. repetitions
CARepetitionGroup CARepetitionGroup Repetition grp
CAEndDateOfBillingPeriod CAEndDateOfBillingPeriod Bill Period
CAGroupingCodeForBPItems CAGroupingCodeForBPItems Grouping key
CAPeriodCode CAPeriodCode Period Key
CAChangeIsForbidden CAChangeIsForbidden Change lock
CAInterestCode CAInterestCode Interest key
CARoundingItemCode CARoundingItemCode Rndg item
CAReceivingCountry CAReceivingCountry Destination C/R
CAInternalPostingReasonCode CAInternalPostingReasonCode Posting Reason
CAWorkflowCheckReason CAWorkflowCheckReason Check Reason
CAWorkflowCheckProcess CAWorkflowCheckProcess Process
CANegativePostingControlCode CANegativePostingControlCode Negative Pstng
CAPartnerSettlementStatus CAPartnerSettlementStatus Revenue Sharing
CAIsPartOfJointLiability CAIsPartOfJointLiability Collab. Liability
CADocumentOriginCode CADocumentOriginCode Document Origin
CASubstituteDocumentNumber CASubstituteDocumentNumber Sub. Doc.
CASubstituteDocumentCategory CASubstituteDocumentCategory Doc.Cat.
CADocumentNumberOfOriginItem CADocumentNumberOfOriginItem Trig. Document
CAReferenceDocument CAReferenceDocument Reference
DocumentDate DocumentDate Journal Entry Date
CAPostingDate CAPostingDate Posting Date
CANetDueDate CANetDueDate Net Due Date
CADeferralDate CADeferralDate Deferral To
TransactionCurrency TransactionCurrency Transaction Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AdditionalCurrency1 AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 AdditionalCurrency2 Local curr. 3
CAExchangeRate CAExchangeRate Absolute Exchange Rate
ExchRateIsIndirectQuotation ExchRateIsIndirectQuotation Exchange Rate Is Indirect Quotation
CACashDiscountDueDate CACashDiscountDueDate Disct Due Date
CACashDiscountRate CACashDiscountRate Discount rate
TaxCode TaxCode Tax Code
CASupplementaryTaxCode CASupplementaryTaxCode Supplem. Tax
CADownPaymentTaxAccount CADownPaymentTaxAccount Tax Account
CADownPaymentOffsetTaxAccount CADownPaymentOffsetTaxAccount Offset tax acct
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
CATaxDate CATaxDate Tax Date
WithholdingTaxCode WithholdingTaxCode WTax Code
CAWithholdingTaxSupplement CAWithholdingTaxSupplement WT supplmt
CAWithholdingTaxCategory CAWithholdingTaxCategory W/Htx item cat.
CAWithholdingTaxPercentage CAWithholdingTaxPercentage Withholding Tax Pct
WithholdingTaxCertificate WithholdingTaxCertificate WHT Certificate
CAOtherTaxCode CAOtherTaxCode TxCde:Oth.Taxes
CAGroupingCodeForTaxItems CAGroupingCodeForTaxItems Tax Group
CATaxIsCalculatedExternally CATaxIsCalculatedExternally Tax by Document
CATaxAmountIsSetFromExternal CATaxAmountIsSetFromExternal TX Characteris.
CAPaymentMethod CAPaymentMethod Payment Method
CAPaymentCompanyCode CAPaymentCompanyCode Paying Co. Code
CAGroupingForPayment CAGroupingForPayment Pymt Grouping
CAPaymentSpecificationCategory CAPaymentSpecificationCategory Category
CAClearingStatus CAClearingStatus Clearing Status
CAClearingDate CAClearingDate Clearing
CAClearingDocumentNumber CAClearingDocumentNumber Clearing Doc.
CAPostingDateOfClearingDoc CAPostingDateOfClearingDoc Clrg Post. Date
CAClearingReason CAClearingReason Clearing Reason
CAClearingCurrency CAClearingCurrency Clearing Curr.
CAValueDateForClearing CAValueDateForClearing Clear.Val.Date
CAClearingRestrictionCode CAClearingRestrictionCode Restriction
CAClearingPostingIsReset CAClearingPostingIsReset Reverse clrg
CAItemIsWithdrawn CAItemIsWithdrawn Canceled
CAItemIsExcludedFromDunning CAItemIsExcludedFromDunning Cannot Be Dunn.
CADunningProcedure CADunningProcedure Dunning Proc.
CAGrpgCodeForTransfToCollAgcy CAGrpgCodeForTransfToCollAgcy Collection item
CAIsIncludedInCollectionCase CAIsIncludedInCollectionCase Collection Case
CashPlanningGroup CashPlanningGroup Planning Group
PlanningLevel PlanningLevel Planning Level
CAAdditionalDaysForCashMgmt CAAdditionalDaysForCashMgmt CM Extra Days
CAAltvBPForPayment CAAltvBPForPayment Partner
CABankOfAltvBPForPayment CABankOfAltvBPForPayment Bank Details
CAAddressOfAltvBPForPayment CAAddressOfAltvBPForPayment Address Number
CACardOfAltvBPForPayment CACardOfAltvBPForPayment Card ID
SEPAMandateCAInternalID SEPAMandateCAInternalID Mandate Ref.
CAGLPostingCurrency CAGLPostingCurrency G/L Currency
CAIsSeparateLineItemInGL CAIsSeparateLineItemInGL Line item
CAIsCashFlowItem CAIsCashFlowItem Cash Flow
CACashFlowAccount CACashFlowAccount Cash Flow Acct
CACashFlowCompanyCode CACashFlowCompanyCode Cash Flow CoCd
CAPaymentPreNotificationCode CAPaymentPreNotificationCode Payment Order
CASEPAPreNotificationNumber CASEPAPreNotificationNumber Pre-Notif.
CASEPAPreNotifOriginCode CASEPAPreNotifOriginCode Mandate Origin
CASEPAPreNotifExecutionDate CASEPAPreNotifExecutionDate Exec.Date
CASEPAPreNotificationRqmtCode CASEPAPreNotificationRqmtCode Requirement
CARevenueDistrFinalRecipient CARevenueDistrFinalRecipient Final Recipient
CARevenueDistrCurrentStatus CARevenueDistrCurrentStatus Current Status
CARevenueDistrLastStatus CARevenueDistrLastStatus Last Status
CACurrentFactoringStatusOfRbl CACurrentFactoringStatusOfRbl Receivable Status
CAFactoringCheckStsForClrgInfo CAFactoringCheckStsForClrgInfo Check Status
CAFactoringItem CAFactoringItem Subitem
ControllingArea ControllingArea Controlling Area
ChartOfAccounts ChartOfAccounts Node Class
Country Country Venue: Ctry/Reg
TaxCalculationProcedure TaxCalculationProcedure Tax Procedure
CAAmountInLocalCurrency CAAmountInLocalCurrency Local Crcy Amt
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
CAAmountInSecondCurrency CAAmountInSecondCurrency Amount in LC 2
CAAmountInThirdCurrency CAAmountInThirdCurrency Amount in LC3
CAEligibleAmountForCshDiscount CAEligibleAmountForCshDiscount Disc. base
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency LC Tax
CATaxAmountInTransCurrency CATaxAmountInTransCurrency Tax Amount
CATaxAmountInSecondCurrency CATaxAmountInSecondCurrency LC 2 Tax
CATaxAmountInThirdCurrency CATaxAmountInThirdCurrency LC 3 tax
CABaseAmountForWithholdingTax CABaseAmountForWithholdingTax Tax base amount
CAWithholdingTaxAmount CAWithholdingTaxAmount Withholding tax
CATaxPortionInLocalCurrency CATaxPortionInLocalCurrency FI-CA Tax Portion
CATaxPortionInTransCurrency CATaxPortionInTransCurrency Tax Portion
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy Clearing Amount
CATaxAmountInClearingCrcy CATaxAmountInClearingCrcy Cl.Crcy Tax Amt
CACashDiscAmountInClearingCrcy CACashDiscAmountInClearingCrcy Discnt/Surchrge
PlannedAmtInTransactionCrcy PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
CAGLPostingAmount CAGLPostingAmount G/L Amount
CAGLPostingTaxAmount CAGLPostingTaxAmount G/L Tax Amount
_AcctAssgmtCat _AcctAssgmtCat
_AcctDetnCode _AcctDetnCode
_AdditionalCurrency1 _AdditionalCurrency1
_AdditionalCurrency2 _AdditionalCurrency2
_AltvBPForPayment _AltvBPForPayment
_ApplArea _ApplArea
_BPItemBusLock _BPItemBusLock
_BPItemUI _BPItemUI
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAHeader _CAHeader
_CAHeaderCollvBills _CAHeaderCollvBills
_CAHeaderFinalRec _CAHeaderFinalRec
_CAPartner _CAPartner
_CARevnDistrCurSts _CARevnDistrCurSts
_CARevnDistrLastSts _CARevnDistrLastSts
_CARoundingItemCode _CARoundingItemCode
_CashFlowAccount _CashFlowAccount
_CASubApplication _CASubApplication
_CAWithholdingTaxCat _CAWithholdingTaxCat
_ChartOfAccounts _ChartOfAccounts
_ClearingCurrency _ClearingCurrency
_ClearingDocHeader _ClearingDocHeader
_ClearingReason _ClearingReason
_ClearingStatus _ClearingStatus
_ClrgRstrcnCode _ClrgRstrcnCode
_CompanyCodeCurrency _CompanyCodeCurrency
_CompCode _CompCode
_CompCodeCashFlow _CompCodeCashFlow
_CompCodePayt _CompCodePayt
_ControllingArea _ControllingArea
_Country _Country
_Currency _Currency
_DbtflOrValAdjmtCode _DbtflOrValAdjmtCode
_Division _Division
_DocHeader _DocHeader
_DocType _DocType
_DunningProcedure _DunningProcedure
_FactoringRblStatus _FactoringRblStatus
_FctrngClrgChkStatus _FctrngClrgChkStatus
_GLPostingCurrency _GLPostingCurrency
_InterestCode _InterestCode
_IntPostingReasonCode _IntPostingReasonCode
_MainTransaction _MainTransaction
_NgtvPostingCtrlCode _NgtvPostingCtrlCode
_OffsetTaxAccount _OffsetTaxAccount
_OriginDocHeader _OriginDocHeader
_OriglStstclItemCode _OriglStstclItemCode
_OtherTaxCode _OtherTaxCode
_PartnerCompany _PartnerCompany
_PaytMethod _PaytMethod
_PaytPreNotifCode _PaytPreNotifCode
_PaytSpecCategory _PaytSpecCategory
_PeriodCode _PeriodCode
_ProfitCenter _ProfitCenter
_ProviderContract _ProviderContract
_PrtnSettlementStatus _PrtnSettlementStatus
_ReceivingCountry _ReceivingCountry
_ReconAccount _ReconAccount
_Segment _Segment
_SEPAPreNotifOrignCd _SEPAPreNotifOrignCd
_SEPAPreNotifRqmtCode _SEPAPreNotifRqmtCode
_StatisticalItemCode _StatisticalItemCode
_SubstitDocCategory _SubstitDocCategory
_SubstitDocHeader _SubstitDocHeader
_SubTransaction _SubTransaction
_TaxAccount _TaxAccount
_WhldgTaxSuplmnt _WhldgTaxSuplmnt
_WithholdingTaxCode _WithholdingTaxCode
_WorkflowCheckProcess _WorkflowCheckProcess
_WorkflowCheckReason _WorkflowCheckReason

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_CADocumentClearedItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_CADocumentClearedItem AS
SELECT
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  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,
  CABPItemText,
  CANumberOfRepetitionItems,
  CARepetitionGroup,
  CAEndDateOfBillingPeriod,
  CAGroupingCodeForBPItems,
  CAPeriodCode,
  CAChangeIsForbidden,
  CAInterestCode,
  CARoundingItemCode,
  CAReceivingCountry,
  CAInternalPostingReasonCode,
  CAWorkflowCheckReason,
  CAWorkflowCheckProcess,
  CANegativePostingControlCode,
  CAPartnerSettlementStatus,
  CAIsPartOfJointLiability,
  CADocumentOriginCode,
  CASubstituteDocumentNumber,
  CASubstituteDocumentCategory,
  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,
  CAAmountInLocalCurrency,
  CAAmountInTransactionCurrency,
  CAAmountInSecondCurrency,
  CAAmountInThirdCurrency,
  CAEligibleAmountForCshDiscount,
  CATaxAmountInLocalCurrency,
  CATaxAmountInTransCurrency,
  CATaxAmountInSecondCurrency,
  CATaxAmountInThirdCurrency,
  CABaseAmountForWithholdingTax,
  CAWithholdingTaxAmount,
  CATaxPortionInLocalCurrency,
  CATaxPortionInTransCurrency,
  CAClearingAmountInClearingCrcy,
  CATaxAmountInClearingCrcy,
  CACashDiscAmountInClearingCrcy,
  PlannedAmtInTransactionCrcy,
  CAGLPostingAmount,
  CAGLPostingTaxAmount
FROM R_CADocumentBPItemTP AS ContrAcctgDocumentClearedItem
;

Learn More