P_CAAnalyzeReceivables

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

P_CAAnalyzeReceivables is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CADocumentBPItemLogical) and exposes 29 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber.

Data Sources (1)

SourceAliasJoin Type
I_CADocumentBPItemLogical 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_CADocumentBPItemLogical CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemLogical CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemLogical CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemLogical CASubItemNumber Subitem
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
PostalCode
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
TransactionCurrency I_CADocumentBPItemLogical TransactionCurrency Transaction Currency
CAValueDateForClearing I_CADocumentBPItemLogical CAValueDateForClearing Clear.Val.Date
CAPostingDateOfClearingDoc I_CADocumentBPItemLogical CAPostingDateOfClearingDoc Clrg Post. Date
CAClearingStatus I_CADocumentBPItemLogical CAClearingStatus Clearing Status
CAAmountInTransactionCurrency I_CADocumentBPItemLogical CAAmountInTransactionCurrency Amount
datsendasExchangeRateDate
CAAuthorizationGroup _CAPartner CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup _ProviderContract 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,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADocumentBPItemLogical AS op
;

Learn More