I_CAValueAdjmtActiveValnArea

DDL: I_CAVALUEADJMTACTIVEVALNAREA SQL: CAVALADJMTPST2 Type: view BASIC
57 Fields 1 Data Sources

View for DFKKZWFP

I_CAValueAdjmtActiveValnArea is a Basic CDS View that provides data about "View for DFKKZWFP" in SAP S/4HANA. It reads from 1 data source (dfkkzwfp) and exposes 57 fields with key fields CADocument, CARepetitionItemNumber, CABPItemNumber, CAPostingDate, CAValuationArea.

Data Sources (1)

SourceAliasJoin Type
dfkkzwfp dfkkzwfp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CAVALADJMTPST2 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 DFKKZWFP view

Fields (57)

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

CREATE VIEW I_CAValueAdjmtActiveValnArea 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 LastChangeDate,
  acptm AS LastChangeTime,
  wbudt AS ValueAdjustmentTransferDate,
  wzudt AS DoubtfulReceivableTransferDate,
  bfbdt AS DoubtfulRblOrValueAdjmtDate,
  grund AS CAReceivableAdjustmentReason,
  stozw AS CAValueAdjmtReversalStatus,
  risk_class AS CreditRiskClass,
  ecl_rate AS ExpectedCreditLossPercent,
  prozt AS ValueAdjustmentShareInPercent,
  rgrnd AS CADbtflRblValAdjmtResetReason,
  redat AS DoubtfulRblValAdjmtResetDate,
  aging AS GeneralLedgerAgingScope,
  incrmnt AS GeneralLedgerAgingIncrement,
  va_purpose AS ValueAdjustmentPurpose,
  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 CATotalValueAdjmtAmountInTC,
  wbubt AS ValueAdjmtPostedAmountInTC,
  wzubt AS DoubtfulRblPostedAmountInTC,
  wfzbt AS DoubtfulRblTotalAmountInTC,
  wbnet AS ValueAdjustmentNetAmountInTC,
  sbetu AS CATaxAdjustmentAmountInTC,
  sbetw AS CATotalTaxAdjustmentAmountInTC
FROM dfkkzwfp
;

Learn More