RECLASSUPDATECURRENCYBASE

DDL: RECLASSUPDATECURRENCYBASE Type: view_entity

RECLASSUPDATECURRENCYBASE is a CDS View in SAP S/4HANA. It reads from 2 data sources (ReclassPostNaviToDoc, ReclassPostNaviToDoc) and exposes 20 fields with key fields Jrnlperdendclsgrunresultuuid, Curtp, Curtp.

Data Sources (2)

SourceAliasJoin Type
ReclassPostNaviToDoc document from
ReclassPostNaviToDoc document union

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Jrnlperdendclsgrunresultuuid amounts jrnlperdendclsgrunresultuuid Result List UUID
KEY Curtp amounts curtp Valuation Area
FinClosingLineItemDetailStatus ReclassPostNaviToDoc FinClosingLineItemDetailStatus Status Detail
Prdcssrperdendclsgrunrsltuuid ReclassPostNaviToDoc Prdcssrperdendclsgrunrsltuuid Predecessor Result List UUID
Jrnlperiodendclosingrunloguuid ReclassPostNaviToDoc Jrnlperiodendclosingrunloguuid Closing Run UUID
Currency
NominalValue
RemainingAmount
ValnAdjmtExcludeImprmt
ImpairmentAdjustment
KEY Curtp Valuation Area
FinClosingLineItemDetailStatus ReclassPostNaviToDoc FinClosingLineItemDetailStatus Status Detail
Prdcssrperdendclsgrunrsltuuid ReclassPostNaviToDoc Prdcssrperdendclsgrunrsltuuid Predecessor Result List UUID
Jrnlperiodendclosingrunloguuid ReclassPostNaviToDoc Jrnlperiodendclosingrunloguuid Closing Run UUID
Currency
NominalValue
RemainingAmount
ValnAdjmtExcludeImprmt
ImpairmentAdjustment
Adjustment

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 RECLASSUPDATECURRENCYBASE.
-- 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 RECLASSUPDATECURRENCYBASE AS
SELECT
  amounts.jrnlperdendclsgrunresultuuid AS Jrnlperdendclsgrunresultuuid,
  amounts.curtp AS Curtp,
  document.FinClosingLineItemDetailStatus AS FinClosingLineItemDetailStatus,
  document.Prdcssrperdendclsgrunrsltuuid AS Prdcssrperdendclsgrunrsltuuid,
  document.Jrnlperiodendclosingrunloguuid AS Jrnlperiodendclosingrunloguuid,
  cast ( amounts.result_list_curr1 as targetcurrency preserving type ) AS Currency,
  cast ( amounts.result_list_amnt1 as cls_rec_nominal_value preserving type ) AS NominalValue,
  cast( amounts.result_list_amnt2 as cls_rec_remaining_amount preserving type ) AS RemainingAmount,
  cast ( amounts.result_list_amnt3 as cls_rec_valuation_adjustments preserving type ) AS ValnAdjmtExcludeImprmt,
  cast ( amounts.result_list_amnt4 as cls_rec_impairment_adjustments preserving type ) AS ImpairmentAdjustment,
  cast ( document.finclsgrunrsltamtinfdcrcy5 as cls_rec_adjustments preserving type ) AS Adjustment
FROM ReclassPostNaviToDoc AS document
-- UNION with additional select branch(es): ReclassPostNaviToDoc
;