P_CAAnalyzeReceivables

DDL: P_CAANALYZERECEIVABLES SQL: PCAANLYZRCVBLS Type: view CONSUMPTION Package: ODATA_O2C_FICA_ANALYZE_RCV
29 Fields 1 Data Sources

Analyse Receivables

P_CAAnalyzeReceivables is a Consumption CDS View that provides data about "Analyse Receivables" in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItem) and exposes 29 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber. Part of development package ODATA_O2C_FICA_ANALYZE_RCV.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItem op from

Parameters (1)

NameTypeDefault
P_Date syst_datum

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCAANLYZRCVBLS view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber I_CADocumentBPItem CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItem CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItem CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItem CASubItemNumber Subitem
CADeferralDateendasCANetDueDate
CAPostingDate I_CADocumentBPItem CAPostingDate Posting Date
CAClearingReason I_CADocumentBPItem CAClearingReason Clearing Reason
CompanyCode I_CADocumentBPItem CompanyCode Receiver Company Code
BusinessArea I_CADocumentBPItem BusinessArea Business Area
Segment I_CADocumentBPItem Segment Segment number
BusinessPartner I_CADocumentBPItem BusinessPartner Issuing Authority
PostalCode
ContractAccount I_CADocumentBPItem ContractAccount Contract Acct
CAContract I_CADocumentBPItem CAContract Contract
CASubApplication I_CADocumentBPItem CASubApplication Subapplication
CADocumentType I_CADocumentBPItem CADocumentType Document Type
CAPaymentMethod I_CADocumentBPItem CAPaymentMethod Payment Method
CAAccountDeterminationCode I_CADocumentBPItem CAAccountDeterminationCode Acct Determ. ID
Division I_CADocumentBPItem Division Internal Division ID
CAMainTransaction I_CADocumentBPItem CAMainTransaction Main Trans.
CASubTransaction I_CADocumentBPItem CASubTransaction Subtransaction
TransactionCurrency I_CADocumentBPItem TransactionCurrency Transaction Currency
CAValueDateForClearing I_CADocumentBPItem CAValueDateForClearing Clear.Val.Date
CAPostingDateOfClearingDoc I_CADocumentBPItem CAPostingDateOfClearingDoc Clrg Post. Date
CAClearingStatus I_CADocumentBPItem CAClearingStatus Clearing Status
CAAmountInTransactionCurrency I_CADocumentBPItem CAAmountInTransactionCurrency Amount
datsendasExchangeRateDate
CAAuthorizationGroup _ContractAccountPartner CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup _CAProviderContract CAAuthorizationGroup AuthorizGroup

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_CAAnalyzeReceivables.
-- 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.
-- SQL view name: PCAANLYZRCVBLS
-- Parameters: P_Date : syst_datum

CREATE VIEW P_CAAnalyzeReceivables AS
SELECT
  op.CADocumentNumber AS CADocumentNumber,
  op.CARepetitionItemNumber AS CARepetitionItemNumber,
  op.CABPItemNumber AS CABPItemNumber,
  op.CASubItemNumber AS CASubItemNumber,
  case when op.CADeferralDate = '00000000' then op.CANetDueDate else op.CADeferralDate end as CANetDueDate AS CADeferralDateendasCANetDueDate,
  op.CAPostingDate AS CAPostingDate,
  op.CAClearingReason AS CAClearingReason,
  op.CompanyCode AS CompanyCode,
  op.BusinessArea AS BusinessArea,
  op.Segment AS Segment,
  op.BusinessPartner AS BusinessPartner,
  op._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  op.ContractAccount AS ContractAccount,
  op.CAContract AS CAContract,
  op.CASubApplication AS CASubApplication,
  op.CADocumentType AS CADocumentType,
  op.CAPaymentMethod AS CAPaymentMethod,
  op.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  op.Division AS Division,
  op.CAMainTransaction AS CAMainTransaction,
  op.CASubTransaction AS CASubTransaction,
  op.TransactionCurrency AS TransactionCurrency,
  op.CAValueDateForClearing AS CAValueDateForClearing,
  op.CAPostingDateOfClearingDoc AS CAPostingDateOfClearingDoc,
  op.CAClearingStatus AS CAClearingStatus,
  op.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  case op.CAClearingStatus when '9' then case when op.CAValueDateForClearing <> '00000000' then op.CAValueDateForClearing when op.CAPostingDateOfClearingDoc <> '00000000' then op.CAPostingDateOfClearingDoc else cast( concat(:P_Date, '') as abap.dats) end else cast( concat(:P_Date, '') as abap.dats) end as ExchangeRateDate AS datsendasExchangeRateDate,
  _ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CAProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADocumentBPItem AS op
;

Learn More