Fins_Rev_Rec_Cons_Check_View

DDL: FINS_REV_REC_CONS_CHECK_VIEW Type: view_entity Package: FINS_REV_REC_UTIL
8 Fields 2 Data Sources

Consistency check of ACDOCA items

Fins_Rev_Rec_Cons_Check_View is a CDS View that provides data about "Consistency check of ACDOCA items" in SAP S/4HANA. It reads from 2 data sources (acdoca, finsc_ld_cmp) and exposes 8 fields. Part of development package FINS_REV_REC_UTIL.

Data Sources (2)

SourceAliasJoin Type
acdoca a from
finsc_ld_cmp v inner

Annotations (5)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Consistency check of ACDOCA items view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
rldnr acdoca rldnr Ledger (Compat.)
bukrs acdoca rbukrs Company Code
docyear acdoca gjahr Settlement Year
belnr acdoca belnr SD Document
poper acdoca poper Posting periods
accas acdoca accas Account Assignment
rhcur acdoca rhcur Local Currency
hsl

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 Fins_Rev_Rec_Cons_Check_View.
-- 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 Fins_Rev_Rec_Cons_Check_View AS
SELECT
  a.rldnr AS rldnr,
  a.rbukrs AS bukrs,
  a.gjahr AS docyear,
  a.belnr AS belnr,
  a.poper AS poper,
  a.accas AS accas,
  a.rhcur AS rhcur,
  sum(a.hsl) AS hsl
FROM acdoca AS a
INNER JOIN finsc_ld_cmp AS v ON /* join condition not captured in parsed metadata */
;

Learn More