I_CAValueAdjustmentPosting

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 I_CAValueAdjustmentPosting.
-- 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: ICAVALADJMTPOSTG

CREATE VIEW I_CAValueAdjustmentPosting AS
SELECT
  opbel AS CADocument,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  budat AS CAPostingDate,
  bwber AS CAValuationArea,
  lfdnr AS CAValueAdjmtSequenceNumber,
  bukrs AS CompanyCode,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  fikey AS CAReconciliationKey,
  laufd AS CAMassRunDate,
  laufi AS CAMassRunID,
  aenam AS LastChangedByUser,
  acpdt AS CAChangeDate,
  acptm AS CAChangeTime,
  wbudt AS ValueAdjustmentTransferDate,
  wzudt AS DoubtfulReceivableTransferDate,
  bfbdt AS DoubtfulRblOrValueAdjmtDate,
  grund AS CAReceivableAdjustmentReason,
  va_purpose AS ValueAdjustmentPurpose,
  stozw AS CAValueAdjmtReversalStatus,
  risk_class AS CreditRiskClass,
  cologrp AS CAColocationGroupForBusPartner,
  ecl_rate AS ExpectedCreditLossPercent,
  prozt AS ValueAdjustmentShareInPercent,
  rgrnd AS CADbtflRblValAdjmtResetReason,
  redat AS DoubtfulRblValAdjmtResetDate,
  aging AS GeneralLedgerAgingScope,
  incrmnt AS GeneralLedgerAgingIncrement,
  wbako AS GLAccount,
  wzkon AS DoubtfulReceivableGLAccount,
  wbkko AS ValueAdjustmentAccount,
  wzkko AS DoubtfulRblAdjustmentAccount,
  wbrak AS ResetValAdjmtWriteOffGLAccount,
  wbrzk AS ResetValAdjmtPaymentGLAccount,
  wbrwk AS ResetValAdjmtChangeGLAccount,
  wbrvk AS ResetValAdjmtSaleGLAccount,
  wbrsk AS ResetValAdjmtReversalGLAccount,
  wbsko AS ValueAdjustmentTaxAccount,
  waers AS DocumentCurrency,
  wbbtr AS SpecifiedValueAdjmtAmountInTC,
  gbrab AS ValAdjmtRsetDueToWrtOffAmt,
  gsrab AS ValAdjmtRsetDueToWrtOffTotAmt,
  gbrzb AS ValAdjmtRsetDueToPaytAmt,
  gsrzb AS ValAdjmtRsetDueToPaytTotAmt,
  gbrwb AS ValAdjmtRsetDueToChgAmt,
  gsrwb AS ValAdjmtRsetDueToChgTotAmt,
  gbrvb AS ValAdjmtRsetDueToSaleAmt,
  gsrvb AS ValAdjmtRsetDueToSaleTotAmt,
  gbrsb AS ValAdjmtRsetDueToRvslAmt,
  gsrsb AS ValAdjmtRsetDueToRvslTotAmt,
  ewbbt AS NewIndividualValueAdjmtAmount,
  wbubt AS ValueAdjmtPostedAmountInTC,
  wzubt AS DoubtfulRblPostedAmountInTC,
  wfzbt AS DoubtfulRblTotalAmountInTC,
  wbnet AS ValueAdjustmentNetAmountInTC,
  sbetu AS CATaxAdjustmentAmountInTC,
  sbetw AS CATaxAmountInTransCurrency,
  ewbbt + gsrab + gsrzb + gsrwb + gsrvb + gsrsb AS ActualNewIndivValAdjmtAmtInTC,
  wbubt + gbrab + gbrzb + gbrwb + gbrvb + gbrsb AS ActualValueAdjmtPostedAmtInTC
FROM dfkkzwfp
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_CAValuationAreaVH AS _ValuationArea ON CAValuationArea = _ValuationArea.CAValuationArea AND _ValuationArea.CAApplicationArea = 'C'  -- association [0..1]
;