C_NL_SAFTJournalItemRefDoc

DDL: C_NL_SAFTJOURNALITEMREFDOC Type: view_entity CONSUMPTION
13 Fields 1 Data Sources

Audit File NL Journal Item Ref Docs

C_NL_SAFTJournalItemRefDoc is a Consumption CDS View that provides data about "Audit File NL Journal Item Ref Docs" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 13 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem, Ledger.

Data Sources (1)

SourceAliasJoin Type
I_JournalEntryItem JournalEntryItem from

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Audit File NL Journal Item Ref Docs view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
KEY Ledger I_JournalEntryItem Ledger Ledger
ReferenceDocument I_JournalEntryItem ReferenceDocument Reference Document
ReferenceSDDocument CFinBillingDoc ReferenceSDDocument Reference Doc.
ShipmentDocument GoodsMovementDoc MaterialDocument Material Doc.
DeliveryDate DeliveryDoc DeliveryDate Delivery Date
_CompanyCode I_JournalEntryItem _CompanyCode
_FiscalYear I_JournalEntryItem _FiscalYear
_JournalEntry I_JournalEntryItem _JournalEntry
_Ledger I_JournalEntryItem _Ledger

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_SAFTJournalItemRefDoc.
-- 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 C_NL_SAFTJournalItemRefDoc AS
SELECT
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  CFinBillingDoc.ReferenceSDDocument AS ReferenceSDDocument,
  GoodsMovementDoc.MaterialDocument AS ShipmentDocument,
  DeliveryDoc.DeliveryDate AS DeliveryDate,
  JournalEntryItem._CompanyCode AS _CompanyCode,
  JournalEntryItem._FiscalYear AS _FiscalYear,
  JournalEntryItem._JournalEntry AS _JournalEntry,
  JournalEntryItem._Ledger AS _Ledger
FROM I_JournalEntryItem AS JournalEntryItem
;

Learn More