I_RU_RecnclnRptExcludeAccount

DDL: I_RU_RECNCLNRPTEXCLUDEACCOUNT SQL: IRURECNRPEXACC Type: view BASIC

Reconciliation Report exclude by account

I_RU_RecnclnRptExcludeAccount is a Basic CDS View that provides data about "Reconciliation Report exclude by account" in SAP S/4HANA. It reads from 1 data source (firuc_recon_rep4) and exposes 4 fields with key fields StatryRptgEntity, ChartOfAccounts, FromGLAccount, ToGLAccount.

Data Sources (1)

SourceAliasJoin Type
firuc_recon_rep4 firuc_recon_rep4 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRURECNRPEXACC view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
EndUserText.label Reconciliation Report exclude by account view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY StatryRptgEntity report_entity Reporting Entity
KEY ChartOfAccounts chart_of_account Chart of Accts
KEY FromGLAccount account Std. Account
KEY ToGLAccount account_to Up to Account No.

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_RU_RecnclnRptExcludeAccount.
-- 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: IRURECNRPEXACC

CREATE VIEW I_RU_RecnclnRptExcludeAccount AS
SELECT
  report_entity AS StatryRptgEntity,
  chart_of_account AS ChartOfAccounts,
  account AS FromGLAccount,
  account_to AS ToGLAccount
FROM firuc_recon_rep4
;