R_CAValueAdjustmentPostingTP

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 R_CAValueAdjustmentPostingTP.
-- 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 R_CAValueAdjustmentPostingTP AS
SELECT
  CADocument,
  CARepetitionItemNumber,
  CABPItemNumber,
  CAPostingDate,
  CAValuationArea,
  CAValueAdjmtSequenceNumber,
  cast('%' as percentageunit_kk ) AS CAPercentageUnit,
  CompanyCode,
  BusinessPartner,
  ContractAccount,
  CAReconciliationKey,
  CAMassRunDate,
  CAMassRunID,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  ValueAdjustmentTransferDate,
  DoubtfulReceivableTransferDate,
  DoubtfulRblOrValueAdjmtDate,
  CAReceivableAdjustmentReason,
  CAValueAdjmtReversalStatus,
  CreditRiskClass,
  ExpectedCreditLossPercent,
  ValueAdjustmentShareInPercent,
  CADbtflRblValAdjmtResetReason,
  DoubtfulRblValAdjmtResetDate,
  GeneralLedgerAgingScope,
  GeneralLedgerAgingIncrement,
  ValueAdjustmentPurpose,
  GLAccount,
  DoubtfulReceivableGLAccount,
  ValueAdjustmentAccount,
  DoubtfulRblAdjustmentAccount,
  ResetValAdjmtWriteOffGLAccount,
  ResetValAdjmtPaymentGLAccount,
  ResetValAdjmtChangeGLAccount,
  ResetValAdjmtSaleGLAccount,
  ResetValAdjmtReversalGLAccount,
  ValueAdjustmentTaxAccount,
  DocumentCurrency,
  SpecifiedValueAdjmtAmountInTC,
  ValAdjmtRsetDueToWrtOffAmt,
  ValAdjmtRsetDueToWrtOffTotAmt,
  ValAdjmtRsetDueToPaytAmt,
  ValAdjmtRsetDueToPaytTotAmt,
  ValAdjmtRsetDueToChgAmt,
  ValAdjmtRsetDueToChgTotAmt,
  ValAdjmtRsetDueToSaleAmt,
  ValAdjmtRsetDueToSaleTotAmt,
  ValAdjmtRsetDueToRvslAmt,
  ValAdjmtRsetDueToRvslTotAmt,
  CATotalValueAdjmtAmountInTC,
  ValueAdjmtPostedAmountInTC,
  DoubtfulRblPostedAmountInTC,
  DoubtfulRblTotalAmountInTC,
  ValueAdjustmentNetAmountInTC,
  CATaxAdjustmentAmountInTC,
  CATotalTaxAdjustmentAmountInTC
FROM I_CAPostedValueAdjustmentHist
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON BusinessPartner = _ContractAccountPartner.BusinessPartner AND ContractAccount = _ContractAccountPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CAReceivableAdjReasonText AS _ReceivableAdjustmentReason ON CAReceivableAdjustmentReason = _ReceivableAdjustmentReason.CAReceivableAdjustmentReason AND _ReceivableAdjustmentReason.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CAValAdjmtResetReasonText AS _ValAdjmtResetReasonText ON CADbtflRblValAdjmtResetReason = _ValAdjmtResetReasonText.CADbtflRblValAdjmtResetReason AND _ValAdjmtResetReasonText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CAValueAdjmtReversalStatus AS _ValueAdjmtReversalStatus ON CAValueAdjmtReversalStatus = _ValueAdjmtReversalStatus.CAValueAdjmtReversalStatus  -- association [0..1]
LEFT OUTER JOIN I_CreditRiskClassText AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass AND _CreditRiskClass.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_LossAllowanceAgingIncrementT AS _LossAllowanceAgingIncrementT ON GeneralLedgerAgingIncrement = _LossAllowanceAgingIncrementT.GeneralLedgerAgingIncrement AND GeneralLedgerAgingScope = _LossAllowanceAgingIncrementT.GeneralLedgerAgingScope AND _LossAllowanceAgingIncrementT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CAValueAdjustmentTypeVH AS _ValueAdjustmentType ON CAValueAdjustmentType = _ValueAdjustmentType.CAValueAdjustmentType  -- association [1..1]
LEFT OUTER JOIN I_CAValuationAreaVH AS _ValuationArea ON CAValuationArea = _ValuationArea.CAValuationArea AND _ValuationArea.CAApplicationArea = 'C'  -- association [0..1]
LEFT OUTER JOIN I_GeneralLedgerAgingScope AS _AgingScope ON GeneralLedgerAgingScope = _AgingScope.GeneralLedgerAgingScope  -- association [0..1]
;