C_NO_SAFTJournalEntryCube

DDL: C_NO_SAFTJOURNALENTRYCUBE SQL: CNOSAFTJORENTC Type: view CONSUMPTION
27 Fields 2 Data Sources

SAF-T Norway Journal Entry Cube

C_NO_SAFTJournalEntryCube is a Consumption CDS View (Cube) that provides data about "SAF-T Norway Journal Entry Cube" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_JournalEntryItem) and exposes 27 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry JournalEntry inner
I_JournalEntryItem JournalItem from

Parameters (4)

NameTypeDefault
P_Ledger fins_ledger
P_StartDate dats
P_EndDate dats
P_CompanyCode bukrs

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CNOSAFTJORENTC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Analytics.internalName #LOCAL view
EndUserText.label SAF-T Norway Journal Entry Cube view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntry AccountingDocument Journal Entry
KEY Ledger I_JournalEntryItem Ledger Ledger
LedgerGroup I_JournalEntryItem SourceLedger Source Ledger
PostingDate I_JournalEntry PostingDate Posting Date for GR
JournalEntryType
CreationTime I_JournalEntry CreationTime Time of Change
LastChangeDateTime I_JournalEntryItem LastChangeDateTime Timestamp
LastManualChangeDate I_JournalEntry LastManualChangeDate Manual Change Date
FiscalPeriod I_JournalEntry FiscalPeriod Tax period
DocumentDate I_JournalEntry DocumentDate Journal Entry Date
DocumentReferenceID I_JournalEntry DocumentReferenceID Reference
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName
AccountingDocumentCreationDate I_JournalEntry AccountingDocumentCreationDate Journal Entry Date
AccountingDocCreatedByUser I_JournalEntry AccountingDocCreatedByUser User which created overhead document
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText Doc.Header Text
ExchangeRateelse0endasExchangeRate
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency Local Currency
TransactionCurrency I_JournalEntry TransactionCurrency Transaction Currency
DocumentTransaction
_CompanyCode I_JournalEntry _CompanyCode
_FiscalYear I_JournalEntry _FiscalYear
_FiscalPeriod I_JournalEntry _FiscalPeriod
_AccountingDocumentType I_JournalEntry _AccountingDocumentType
_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_NO_SAFTJournalEntryCube.
-- 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: CNOSAFTJORENTC
-- Parameters: P_Ledger : fins_ledger, P_StartDate : dats, P_EndDate : dats, P_CompanyCode : bukrs

CREATE VIEW C_NO_SAFTJournalEntryCube AS
SELECT
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalItem.Ledger AS Ledger,
  JournalItem.SourceLedger AS LedgerGroup,
  JournalEntry.PostingDate AS PostingDate,
  cast( 'A' as fis_blart ) AS JournalEntryType,
  JournalEntry.CreationTime AS CreationTime,
  JournalItem.LastChangeDateTime AS LastChangeDateTime,
  JournalEntry.LastManualChangeDate AS LastManualChangeDate,
  JournalEntry.FiscalPeriod AS FiscalPeriod,
  JournalEntry.DocumentDate AS DocumentDate,
  JournalEntry.DocumentReferenceID AS DocumentReferenceID,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  coalesce(JournalEntry._AccountingDocumentTypeText[1: Language = $session.system_language].AccountingDocumentTypeName,' ') AS AccountingDocumentTypeName,
  JournalEntry.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalEntry.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  case when JournalEntry.CompanyCodeCurrency <> JournalEntry.TransactionCurrency then JournalEntry.ExchangeRate else 0 end as ExchangeRate AS ExchangeRateelse0endasExchangeRate,
  JournalEntry.CompanyCodeCurrency AS CompanyCodeCurrency,
  JournalEntry.TransactionCurrency AS TransactionCurrency,
  concat(concat(JournalEntry.CompanyCode, JournalEntry.AccountingDocument), JournalEntry.FiscalYear ) AS DocumentTransaction,
  JournalEntry._CompanyCode AS _CompanyCode,
  JournalEntry._FiscalYear AS _FiscalYear,
  JournalEntry._FiscalPeriod AS _FiscalPeriod,
  JournalEntry._AccountingDocumentType AS _AccountingDocumentType,
  JournalItem._Ledger AS _Ledger
FROM I_JournalEntryItem AS JournalItem
INNER JOIN I_JournalEntry AS JournalEntry ON /* join condition not captured in parsed metadata */
;

Learn More