P_CAClearingReasonAnalysis

DDL: P_CACLEARINGREASONANALYSIS Type: view_entity COMPOSITE
55 Fields 2 Data Sources

Prepare the data for clearing reason

P_CAClearingReasonAnalysis is a Composite CDS View that provides data about "Prepare the data for clearing reason" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItemLogical, I_CADocumentBPItemLogical) and exposes 55 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber, CAClearingReasonGroup.

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItemLogical _BPItem from
I_CADocumentBPItemLogical _BPItem union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Prepare the data for clearing reason view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItemLogical CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemLogical CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemLogical CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemLogical CASubItemNumber Subitem
KEY CAClearingReasonGroup _ClearingReasonAssgmnt CAClearingReasonGroup
CADeferralDateendasCANetDueDate
CAPostingDate I_CADocumentBPItemLogical CAPostingDate Posting Date
CAClearingReason I_CADocumentBPItemLogical CAClearingReason Clearing Reason
CompanyCode I_CADocumentBPItemLogical CompanyCode Receiver Company Code
BusinessArea I_CADocumentBPItemLogical BusinessArea Business Area
Segment I_CADocumentBPItemLogical Segment Segment number
BusinessPartner I_CADocumentBPItemLogical BusinessPartner Issuing Authority
ContractAccount I_CADocumentBPItemLogical ContractAccount Contract Acct
CAContract I_CADocumentBPItemLogical CAContract Contract
CASubApplication I_CADocumentBPItemLogical CASubApplication Subapplication
CADocumentType I_CADocumentBPItemLogical CADocumentType Document Type
CAPaymentMethod I_CADocumentBPItemLogical CAPaymentMethod Payment Method
CAAccountDeterminationCode I_CADocumentBPItemLogical CAAccountDeterminationCode Acct Determ. ID
Division I_CADocumentBPItemLogical Division Internal Division ID
CAMainTransaction I_CADocumentBPItemLogical CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItemLogical CASubTransaction Subtransaction
CAApplicationArea I_CADocumentBPItemLogical CAApplicationArea ApplicationArea
CAValueDateForClearing I_CADocumentBPItemLogical CAValueDateForClearing Clear.Val.Date
CAPostingDateOfClearingDoc I_CADocumentBPItemLogical CAPostingDateOfClearingDoc Clrg Post. Date
CAClearingStatus I_CADocumentBPItemLogical CAClearingStatus Clearing Status
Country I_CADocumentBPItemLogical Country Venue: Ctry/Reg
CAAmountInTransactionCurrency
CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemLogical CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemLogical CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemLogical CASubItemNumber Subitem
KEY CAClearingReasonGroup
CADeferralDateendasCANetDueDate
CAPostingDate I_CADocumentBPItemLogical CAPostingDate Posting Date
CAClearingReason I_CADocumentBPItemLogical CAClearingReason Clearing Reason
CompanyCode I_CADocumentBPItemLogical CompanyCode Receiver Company Code
BusinessArea I_CADocumentBPItemLogical BusinessArea Business Area
Segment I_CADocumentBPItemLogical Segment Segment number
BusinessPartner I_CADocumentBPItemLogical BusinessPartner Issuing Authority
ContractAccount I_CADocumentBPItemLogical ContractAccount Contract Acct
CAContract I_CADocumentBPItemLogical CAContract Contract
CASubApplication I_CADocumentBPItemLogical CASubApplication Subapplication
CADocumentType I_CADocumentBPItemLogical CADocumentType Document Type
CAPaymentMethod I_CADocumentBPItemLogical CAPaymentMethod Payment Method
CAAccountDeterminationCode I_CADocumentBPItemLogical CAAccountDeterminationCode Acct Determ. ID
Division I_CADocumentBPItemLogical Division Internal Division ID
CAMainTransaction I_CADocumentBPItemLogical CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItemLogical CASubTransaction Subtransaction
CAApplicationArea I_CADocumentBPItemLogical CAApplicationArea ApplicationArea
CAValueDateForClearing I_CADocumentBPItemLogical CAValueDateForClearing Clear.Val.Date
CAPostingDateOfClearingDoc I_CADocumentBPItemLogical CAPostingDateOfClearingDoc Clrg Post. Date
CAClearingStatus I_CADocumentBPItemLogical CAClearingStatus Clearing Status
Country I_CADocumentBPItemLogical Country Venue: Ctry/Reg
CAAmountInTransactionCurrency
TransactionCurrency I_CADocumentBPItemLogical TransactionCurrency Transaction Currency

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 P_CAClearingReasonAnalysis.
-- 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 P_CAClearingReasonAnalysis AS
SELECT
  _BPItem.CADocumentNumber AS CADocumentNumber,
  _BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  _BPItem.CABPItemNumber AS CABPItemNumber,
  _BPItem.CASubItemNumber AS CASubItemNumber,
  _ClearingReasonAssgmnt.CAClearingReasonGroup AS CAClearingReasonGroup,
  case when _BPItem.CADeferralDate = '00000000' then _BPItem.CANetDueDate when _BPItem.CADeferralDate != '00000000' then _BPItem.CADeferralDate end as CANetDueDate AS CADeferralDateendasCANetDueDate,
  _BPItem.CAPostingDate AS CAPostingDate,
  _BPItem.CAClearingReason AS CAClearingReason,
  _BPItem.CompanyCode AS CompanyCode,
  _BPItem.BusinessArea AS BusinessArea,
  _BPItem.Segment AS Segment,
  _BPItem.BusinessPartner AS BusinessPartner,
  _BPItem.ContractAccount AS ContractAccount,
  _BPItem.CAContract AS CAContract,
  _BPItem.CASubApplication AS CASubApplication,
  _BPItem.CADocumentType AS CADocumentType,
  _BPItem.CAPaymentMethod AS CAPaymentMethod,
  _BPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _BPItem.Division AS Division,
  _BPItem.CAMainTransaction AS CAMainTransaction,
  _BPItem.CASubTransaction AS CASubTransaction,
  _BPItem.CAApplicationArea AS CAApplicationArea,
  _BPItem.CAValueDateForClearing AS CAValueDateForClearing,
  _BPItem.CAPostingDateOfClearingDoc AS CAPostingDateOfClearingDoc,
  _BPItem.CAClearingStatus AS CAClearingStatus,
  _BPItem.Country AS Country,
  cast (_BPItem.CAAmountInTransactionCurrency as abap.curr(23,2)) AS CAAmountInTransactionCurrency,
  _BPItem.TransactionCurrency AS TransactionCurrency
FROM I_CADocumentBPItemLogical AS _BPItem
-- UNION ALL with additional select branch(es): I_CADocumentBPItemLogical
;

Learn More