P_CAValueAdjustmentReporting

DDL: P_CAVALUEADJUSTMENTREPORTING SQL: PCAVALADJMTRPTG Type: view COMPOSITE
30 Fields 1 Data Sources

P_CAValueAdjustmentReporting is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CAValueAdjustmentPosting) and exposes 30 fields with key fields CADocument, CARepetitionItemNumber, CABPItemNumber, CAPostingDate, CAValuationArea.

Data Sources (1)

SourceAliasJoin Type
I_CAValueAdjustmentPosting a from

Parameters (1)

NameTypeDefault
P_Application_Area applk_kk

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCAVALADJMTRPTG view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CADocument I_CAValueAdjustmentPosting CADocument CA Document No.
KEY CARepetitionItemNumber I_CAValueAdjustmentPosting CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CAValueAdjustmentPosting CABPItemNumber Item
KEY CAPostingDate b CAPostingDate Posting Date
KEY CAValuationArea I_CAValueAdjustmentPosting CAValuationArea Valuation Area
KEY CAValueAdjmtSequenceNumber I_CAValueAdjustmentPosting CAValueAdjmtSequenceNumber Tax sequence
CompanyCode I_CAValueAdjustmentPosting CompanyCode Receiver Company Code
BusinessPartner I_CAValueAdjustmentPosting BusinessPartner Issuing Authority
CreditRiskClass I_CAValueAdjustmentPosting CreditRiskClass Credit Risk Class
AccountingPrinciple ValuationArea AccountingPrinciple AP Ledger/CoCode
CAApplicationArea
GLAccount I_CAValueAdjustmentPosting GLAccount General Ledger
ProfitCenter bp_item ProfitCenter Profit Center
Segment bp_item Segment Segment number
Division bp_item Division Internal Division ID
CAAccountDeterminationCode bp_item CAAccountDeterminationCode Acct Determ. ID
CAMainTransaction bp_item CAMainTransaction Main Trans.
CASubTransaction bp_item CASubTransaction Subtransaction
GeneralLedgerAgingScope I_CAValueAdjustmentPosting GeneralLedgerAgingScope Aging
GeneralLedgerAgingIncrement I_CAValueAdjustmentPosting GeneralLedgerAgingIncrement Increment
DocumentCurrency I_CAValueAdjustmentPosting DocumentCurrency Document Currency
curr95endasCurrency1ExchangeRate
Currency2ExchangeRate
Currency3ExchangeRate
RealizedAmountInDocCrcy
ChangeAmountInDocCrcy
NewAmtForValueAdjmtInDocCrcy NewIndividualValueAdjmtAmount ValAdj Amt
NewValueAdjmtAmtInDocCrcy NewIndividualValueAdjmtAmount ValAdj Amt
ReleasedAmountInDocCrcy ValAdjmtRsetDueToPaytTotAmt Adj.ResetAmount
CAAuthorizationGroup

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_CAValueAdjustmentReporting.
-- 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: PCAVALADJMTRPTG
-- Parameters: P_Application_Area : applk_kk

CREATE VIEW P_CAValueAdjustmentReporting AS
SELECT
  a.CADocument AS CADocument,
  a.CARepetitionItemNumber AS CARepetitionItemNumber,
  a.CABPItemNumber AS CABPItemNumber,
  b.CAPostingDate AS CAPostingDate,
  a.CAValuationArea AS CAValuationArea,
  a.CAValueAdjmtSequenceNumber AS CAValueAdjmtSequenceNumber,
  a.CompanyCode AS CompanyCode,
  a.BusinessPartner AS BusinessPartner,
  a.CreditRiskClass AS CreditRiskClass,
  ValuationArea.AccountingPrinciple AS AccountingPrinciple,
  :P_Application_Area AS CAApplicationArea,
  a.GLAccount AS GLAccount,
  bp_item.ProfitCenter AS ProfitCenter,
  bp_item.Segment AS Segment,
  bp_item.Division AS Division,
  bp_item.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  bp_item.CAMainTransaction AS CAMainTransaction,
  bp_item.CASubTransaction AS CASubTransaction,
  a.GeneralLedgerAgingScope AS GeneralLedgerAgingScope,
  a.GeneralLedgerAgingIncrement AS GeneralLedgerAgingIncrement,
  a.DocumentCurrency AS DocumentCurrency,
  case when bp_item.CAExchangeRate is not initial then bp_item.CAExchangeRate else cast( division( bp_item.CAAmountInLocalCurrency, bp_item.CAAmountInTransactionCurrency, 5 ) as abap.curr( 9, 5 ) ) end as Currency1ExchangeRate AS curr95endasCurrency1ExchangeRate,
  cast( division( bp_item.CAAmountInSecondCurrency, bp_item.CAAmountInTransactionCurrency, 5 ) as abap.curr( 9, 5 ) ) AS Currency2ExchangeRate,
  cast( division( bp_item.CAAmountInThirdCurrency, bp_item.CAAmountInTransactionCurrency, 5 ) as abap.curr( 9, 5 ) ) AS Currency3ExchangeRate,
  ( ValAdjmtRsetDueToWrtOffTotAmt + ValAdjmtRsetDueToSaleTotAmt ) AS RealizedAmountInDocCrcy,
  ( ValAdjmtRsetDueToChgTotAmt + ValAdjmtRsetDueToRvslTotAmt ) AS ChangeAmountInDocCrcy,
  NewIndividualValueAdjmtAmount AS NewAmtForValueAdjmtInDocCrcy,
  NewIndividualValueAdjmtAmount AS NewValueAdjmtAmtInDocCrcy,
  ValAdjmtRsetDueToPaytTotAmt AS ReleasedAmountInDocCrcy,
  bp_item._CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup
FROM I_CAValueAdjustmentPosting AS a
;

Learn More