C_NL_SAFTGeneralLedger

DDL: C_NL_SAFTGENERALLEDGER SQL: CNLSAFTGL Type: view CONSUMPTION
5 Fields 3 Data Sources

SAF-T NL General Ledger

C_NL_SAFTGeneralLedger is a Consumption CDS View that provides data about "SAF-T NL General Ledger" in SAP S/4HANA. It reads from 3 data sources (I_GLAccountInChartOfAccounts, I_NL_SAFTGenericSettings, I_GLAccountInCompanyCode) and exposes 5 fields with key fields CompanyCode, GLAccount, ChartOfAccounts.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts GeneralLedger from
I_NL_SAFTGenericSettings GenericSettings inner
I_GLAccountInCompanyCode GLAccountInCompanyCode inner

Parameters (1)

NameTypeDefault
P_FiscalYear gjahr

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNLSAFTGL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label SAF-T NL General Ledger view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_NL_SAFTGenericSettings CompanyCode Receiver Company Code
KEY GLAccount I_GLAccountInChartOfAccounts GLAccount General Ledger
KEY ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts Node Class
GLAccountLongName
_ChartOfAccounts I_GLAccountInChartOfAccounts _ChartOfAccounts

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 C_NL_SAFTGeneralLedger.
-- 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: CNLSAFTGL
-- Parameters: P_FiscalYear : gjahr

CREATE VIEW C_NL_SAFTGeneralLedger AS
SELECT
  GenericSettings.CompanyCode AS CompanyCode,
  GeneralLedger.GLAccount AS GLAccount,
  GeneralLedger.ChartOfAccounts AS ChartOfAccounts,
  coalesce(GeneralLedger._Text[1: Language = $session.system_language].GLAccountLongName, ' ') AS GLAccountLongName,
  GeneralLedger._ChartOfAccounts AS _ChartOfAccounts
FROM I_GLAccountInChartOfAccounts AS GeneralLedger
INNER JOIN I_GLAccountInCompanyCode AS GLAccountInCompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_NL_SAFTGenericSettings AS GenericSettings ON /* join condition not captured in parsed metadata */
;

Learn More