I_CAValueAdjmtInactiveValnArea

DDL: I_CAVALUEADJMTINACTIVEVALNAREA SQL: CAVALADJMTPST1 Type: view BASIC Package: ODATA_O2C_FICA_POSTDVALADJ_DIS
59 Fields 2 Data Sources

View for DFKKZW and DFKKZW2

I_CAValueAdjmtInactiveValnArea is a Basic CDS View that provides data about "View for DFKKZW and DFKKZW2" in SAP S/4HANA. It reads from 2 data sources (dfkkzw, dfkkzw2) and exposes 59 fields with key fields CADocument, CARepetitionItemNumber, CABPItemNumber, CAPostingDate, CAValuationArea. Part of development package ODATA_O2C_FICA_POSTDVALADJ_DIS.

Data Sources (2)

SourceAliasJoin Type
dfkkzw dfkkzw from
dfkkzw2 dfkkzw2 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CAVALADJMTPST1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label View for DFKKZW and DFKKZW2 view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CADocument dfkkzw opbel Reopen
KEY CARepetitionItemNumber dfkkzw opupw Repetition Item
KEY CABPItemNumber dfkkzw opupk Item
KEY CAPostingDate dfkkzw2 budat Posting Date
KEY CAValuationArea bwber Valuation Area
KEY CAValueAdjmtSequenceNumber lfdnr Tax sequence
ValueAdjustmentPurpose
CompanyCode dfkkzw2 bukrs Value
BusinessPartner dfkkzw2 gpart Tech. BPartner
ContractAccount dfkkzw2 vkont Tech. CtrAcct
CAReconciliationKey dfkkzw2 fikey Reconcil. Key
CAMassRunDate dfkkzw2 laufd Run On
CAMassRunID dfkkzw2 laufi Settlement ID
LastChangedByUser dfkkzw2 aenam User Name
LastChangeDate dfkkzw2 acpdt Changed On
LastChangeTime dfkkzw2 acptm Changed At
ValueAdjustmentTransferDate dfkkzw2 wbudt ValAdjTransDate
DoubtfulReceivableTransferDate dfkkzw2 wzudt TrDateDoubtEn
DoubtfulRblOrValueAdjmtDate dfkkzw2 bfbdt DoubtEntryDate
CAReceivableAdjustmentReason dfkkzw2 grund Reason for mvt.
CAValueAdjmtReversalStatus dfkkzw2 stozw Rev adj rec
CreditRiskClass dfkkzw2 risk_class Risk Class
ExpectedCreditLossPercent dfkkzw2 ecl_rate ECL Rate (%)
ValueAdjustmentShareInPercent dfkkzw2 prozt Share
CADbtflRblValAdjmtResetReason dfkkzw2 rgrnd Reset Reason
DoubtfulRblValAdjmtResetDate dfkkzw2 redat Reset date
DbtflRblValAdjmtTrggrResetDate dfkkzw redat Reset date
GeneralLedgerAgingScope dfkkzw2 aging Aging
GeneralLedgerAgingIncrement dfkkzw2 incrmnt Increment
GLAccount dfkkzw2 wbako ExpAccValAdjust
DoubtfulReceivableGLAccount dfkkzw2 wzkon DoubtEntryAcct
ValueAdjustmentAccount dfkkzw2 wbkko AdjAcct:ValAdj.
DoubtfulRblAdjustmentAccount dfkkzw2 wzkko Adjustmnt acct
ResetValAdjmtWriteOffGLAccount dfkkzw2 wbrak Reset/Write-Off
ResetValAdjmtPaymentGLAccount dfkkzw2 wbrzk Reset/Payment
ResetValAdjmtChangeGLAccount dfkkzw2 wbrwk AcctResetVAChange
ResetValAdjmtSaleGLAccount dfkkzw2 wbrvk AcctResetVASale
ResetValAdjmtReversalGLAccount dfkkzw2 wbrsk AcctResetVARev
ValueAdjustmentTaxAccount dfkkzw2 wbsko Tax A/c Ind.Val.Adj.
DocumentCurrency dfkkzw2 waers Transaction Currency
CAValueAdjustmentOpenAmtInTC dfkkzw offbt Open amount
SpecifiedValueAdjmtAmountInTC dfkkzw2 wbbtr Spec. Val.Adj.Amt
ValAdjmtRsetDueToWrtOffAmt dfkkzw2 gbrab Val. Adj. Reset
ValAdjmtRsetDueToWrtOffTotAmt dfkkzw2 gsrab ValAdjResetAmt
ValAdjmtRsetDueToPaytAmt dfkkzw2 gbrzb Val. Adj. Reset
ValAdjmtRsetDueToPaytTotAmt dfkkzw2 gsrzb Adj.ResetAmount
ValAdjmtRsetDueToChgAmt dfkkzw2 gbrwb AmtPstdVAResetChng
ValAdjmtRsetDueToChgTotAmt dfkkzw2 gsrwb TtlAmtVAResetChng
ValAdjmtRsetDueToSaleAmt dfkkzw2 gbrvb AmtPstdVAResetS
ValAdjmtRsetDueToSaleTotAmt dfkkzw2 gsrvb TtlAmtVAResetSale
ValAdjmtRsetDueToRvslAmt dfkkzw2 gbrsb AmtPstdVAResetR
ValAdjmtRsetDueToRvslTotAmt dfkkzw2 gsrsb TtlAmtVAResetRev.
CATotalValueAdjmtAmountInTC dfkkzw2 ewbbt ValAdj Amt
ValueAdjmtPostedAmountInTC dfkkzw2 wbubt Vl.Aj Postd Amt
DoubtfulRblPostedAmountInTC dfkkzw2 wzubt Doubt.post. amt
DoubtfulRblTotalAmountInTC dfkkzw2 wfzbt Doubtful Amount
ValueAdjustmentNetAmountInTC dfkkzw2 wbnet Net Amount
CATaxAdjustmentAmountInTC dfkkzw2 sbetu Posted tax amt
CATotalTaxAdjustmentAmountInTC dfkkzw2 sbetw Tax Amount

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_CAValueAdjmtInactiveValnArea.
-- 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: CAVALADJMTPST1

CREATE VIEW I_CAValueAdjmtInactiveValnArea AS
SELECT
  dfkkzw.opbel AS CADocument,
  dfkkzw.opupw AS CARepetitionItemNumber,
  dfkkzw.opupk AS CABPItemNumber,
  dfkkzw2.budat AS CAPostingDate,
  bwber AS CAValuationArea,
  lfdnr AS CAValueAdjmtSequenceNumber,
  cast( '' as va_purpose_kk) AS ValueAdjustmentPurpose,
  dfkkzw2.bukrs AS CompanyCode,
  dfkkzw2.gpart AS BusinessPartner,
  dfkkzw2.vkont AS ContractAccount,
  dfkkzw2.fikey AS CAReconciliationKey,
  dfkkzw2.laufd AS CAMassRunDate,
  dfkkzw2.laufi AS CAMassRunID,
  dfkkzw2.aenam AS LastChangedByUser,
  dfkkzw2.acpdt AS LastChangeDate,
  dfkkzw2.acptm AS LastChangeTime,
  dfkkzw2.wbudt AS ValueAdjustmentTransferDate,
  dfkkzw2.wzudt AS DoubtfulReceivableTransferDate,
  dfkkzw2.bfbdt AS DoubtfulRblOrValueAdjmtDate,
  dfkkzw2.grund AS CAReceivableAdjustmentReason,
  dfkkzw2.stozw AS CAValueAdjmtReversalStatus,
  dfkkzw2.risk_class AS CreditRiskClass,
  dfkkzw2.ecl_rate AS ExpectedCreditLossPercent,
  dfkkzw2.prozt AS ValueAdjustmentShareInPercent,
  dfkkzw2.rgrnd AS CADbtflRblValAdjmtResetReason,
  dfkkzw2.redat AS DoubtfulRblValAdjmtResetDate,
  dfkkzw.redat AS DbtflRblValAdjmtTrggrResetDate,
  dfkkzw2.aging AS GeneralLedgerAgingScope,
  dfkkzw2.incrmnt AS GeneralLedgerAgingIncrement,
  dfkkzw2.wbako AS GLAccount,
  dfkkzw2.wzkon AS DoubtfulReceivableGLAccount,
  dfkkzw2.wbkko AS ValueAdjustmentAccount,
  dfkkzw2.wzkko AS DoubtfulRblAdjustmentAccount,
  dfkkzw2.wbrak AS ResetValAdjmtWriteOffGLAccount,
  dfkkzw2.wbrzk AS ResetValAdjmtPaymentGLAccount,
  dfkkzw2.wbrwk AS ResetValAdjmtChangeGLAccount,
  dfkkzw2.wbrvk AS ResetValAdjmtSaleGLAccount,
  dfkkzw2.wbrsk AS ResetValAdjmtReversalGLAccount,
  dfkkzw2.wbsko AS ValueAdjustmentTaxAccount,
  dfkkzw2.waers AS DocumentCurrency,
  dfkkzw.offbt AS CAValueAdjustmentOpenAmtInTC,
  dfkkzw2.wbbtr AS SpecifiedValueAdjmtAmountInTC,
  dfkkzw2.gbrab AS ValAdjmtRsetDueToWrtOffAmt,
  dfkkzw2.gsrab AS ValAdjmtRsetDueToWrtOffTotAmt,
  dfkkzw2.gbrzb AS ValAdjmtRsetDueToPaytAmt,
  dfkkzw2.gsrzb AS ValAdjmtRsetDueToPaytTotAmt,
  dfkkzw2.gbrwb AS ValAdjmtRsetDueToChgAmt,
  dfkkzw2.gsrwb AS ValAdjmtRsetDueToChgTotAmt,
  dfkkzw2.gbrvb AS ValAdjmtRsetDueToSaleAmt,
  dfkkzw2.gsrvb AS ValAdjmtRsetDueToSaleTotAmt,
  dfkkzw2.gbrsb AS ValAdjmtRsetDueToRvslAmt,
  dfkkzw2.gsrsb AS ValAdjmtRsetDueToRvslTotAmt,
  dfkkzw2.ewbbt AS CATotalValueAdjmtAmountInTC,
  dfkkzw2.wbubt AS ValueAdjmtPostedAmountInTC,
  dfkkzw2.wzubt AS DoubtfulRblPostedAmountInTC,
  dfkkzw2.wfzbt AS DoubtfulRblTotalAmountInTC,
  dfkkzw2.wbnet AS ValueAdjustmentNetAmountInTC,
  dfkkzw2.sbetu AS CATaxAdjustmentAmountInTC,
  dfkkzw2.sbetw AS CATotalTaxAdjustmentAmountInTC
FROM dfkkzw
INNER JOIN dfkkzw2 ON /* join condition not captured in parsed metadata */
;

Learn More