C_NO_SAFTJournalItemCube
SAF-T Norway Journal Item Cube
C_NO_SAFTJournalItemCube is a Consumption CDS View (Cube) that provides data about "SAF-T Norway Journal Item Cube" in SAP S/4HANA. It reads from 1 data source (I_JournalEntryItem) and exposes 49 fields with key fields CompanyCode, FiscalYear, AccountingDocument, AccountingDocumentItem, Ledger. Part of development package GLO_FIN_IS_SAFT_NO.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_JournalEntryItem | JournalItem | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_FromPostingDate | abap.dats | |
| P_ToPostingDate | abap.dats | |
| P_Ledger | fins_ledger |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CNOSAFTJITMC | 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 | #X | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_INCLUDED | view | |
| Analytics.dataCategory | #CUBE | view | |
| Metadata.allowExtensions | true | view | |
| Analytics.internalName | #LOCAL | view | |
| EndUserText.label | SAF-T Norway Journal Item Cube | view |
Fields (49)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 | AccountingDocumentItem | I_JournalEntryItem | LedgerGLLineItem | Journal Entry Item |
| KEY | Ledger | I_JournalEntryItem | Ledger | Ledger |
| SourceLedger | I_JournalEntryItem | SourceLedger | Source Ledger | |
| PostingDate | I_JournalEntryItem | PostingDate | Posting Date for GR | |
| Customer | I_JournalEntryItem | Customer | Sold-to Party | |
| Supplier | I_JournalEntryItem | Supplier | Supplier | |
| JournalEntryType | ||||
| GLAccount | I_JournalEntryItem | GLAccount | General Ledger | |
| ControllingArea | I_JournalEntryItem | ControllingArea | Controlling Area | |
| CostCenter | I_JournalEntryItem | CostCenter | Cost Center | |
| DocumentTransaction | ||||
| TaxCountry | I_JournalEntryItem | TaxCountry | Tax Ctry/Reg. | |
| OrderID | I_JournalEntryItem | OrderID | Order ID | |
| PersonnelNumber | I_JournalEntryItem | PersonnelNumber | Personnel No. | |
| AmountInTransactionCurrency | I_JournalEntryItem | AmountInTransactionCurrency | Pt Crcy Amt | |
| AmountInCompanyCodeCurrency | I_JournalEntryItem | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| DebitCreditCode | I_JournalEntryItem | DebitCreditCode | Single-Character Flag | |
| WBSElement | I_JournalEntryItem | WBSElement | WBS Internal ID | |
| DocumentItemText | I_JournalEntryItem | DocumentItemText | Text | |
| TaxCode | I_JournalEntryItem | TaxCode | Tax Code | |
| CompanyCodeCurrency | I_JournalEntryItem | CompanyCodeCurrency | Local Currency | |
| TransactionCurrency | I_JournalEntryItem | TransactionCurrency | Transaction Currency | |
| ValueDate | I_JournalEntryItem | ValueDate | Value Date | |
| PaymentReference | AcctDoc | PaymentReference | Payment Reference | |
| AccountingDocumentItemType | AcctDoc | AccountingDocumentItemType | Line Item ID | |
| char30132asLastChangeDateTime | ||||
| TransactionTypeDetermination | I_JournalEntryItem | TransactionTypeDetermination | Transaction Key | |
| FinancialAccountType | I_JournalEntryItem | FinancialAccountType | Fin. Account Type | |
| AccountingDocumentType | I_JournalEntryItem | AccountingDocumentType | Journal Entry Type | |
| NO_SAFTSourceDocument | ||||
| InvoiceReference | I_JournalEntryItem | InvoiceReference | Invoice Reference | |
| InvoiceReferenceFiscalYear | I_JournalEntryItem | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | |
| InvoiceItemReference | I_JournalEntryItem | InvoiceItemReference | Item | |
| SalesDocument | I_JournalEntryItem | SalesDocument | SD Document | |
| SalesDocumentItem | I_JournalEntryItem | SalesDocumentItem | Sales Document Item | |
| ReversalReferenceDocument | I_JournalEntryItem | ReversalReferenceDocument | Reversal Reference Document | |
| IsReversal | I_JournalEntryItem | IsReversal | Reversal doc. | |
| ExchangeRate | ||||
| ExchRateDiffAmtInAddlCrcy1 | ||||
| ExchRateDiffAmtInAddlCrcy2 | ||||
| AccountingDocumentTypeName | ||||
| DocumentReferenceID | ||||
| _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_NO_SAFTJournalItemCube.
-- 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: CNOSAFTJITMC
-- Parameters: P_FromPostingDate : abap.dats, P_ToPostingDate : abap.dats, P_Ledger : fins_ledger
CREATE VIEW C_NO_SAFTJournalItemCube AS
SELECT
JournalItem.CompanyCode AS CompanyCode,
JournalItem.FiscalYear AS FiscalYear,
JournalItem.AccountingDocument AS AccountingDocument,
JournalItem.LedgerGLLineItem AS AccountingDocumentItem,
JournalItem.Ledger AS Ledger,
JournalItem.SourceLedger AS SourceLedger,
JournalItem.PostingDate AS PostingDate,
JournalItem.Customer AS Customer,
JournalItem.Supplier AS Supplier,
'A' AS JournalEntryType,
JournalItem.GLAccount AS GLAccount,
JournalItem.ControllingArea AS ControllingArea,
JournalItem.CostCenter AS CostCenter,
concat(concat(JournalItem.CompanyCode, JournalItem.AccountingDocument), JournalItem.FiscalYear ) AS DocumentTransaction,
JournalItem.TaxCountry AS TaxCountry,
JournalItem.OrderID AS OrderID,
JournalItem.PersonnelNumber AS PersonnelNumber,
JournalItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
JournalItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
JournalItem.DebitCreditCode AS DebitCreditCode,
JournalItem.WBSElement AS WBSElement,
JournalItem.DocumentItemText AS DocumentItemText,
JournalItem.TaxCode AS TaxCode,
JournalItem.CompanyCodeCurrency AS CompanyCodeCurrency,
JournalItem.TransactionCurrency AS TransactionCurrency,
JournalItem.ValueDate AS ValueDate,
AcctDoc.PaymentReference AS PaymentReference,
AcctDoc.AccountingDocumentItemType AS AccountingDocumentItemType,
concat(substring(JournalItem.CreationDate,1,4), concat('-', concat(substring(JournalItem.CreationDate,5,2), concat('-', concat(substring(JournalItem.CreationDate,7,2), concat('T', concat(substring(cast(JournalItem.CreationDateTime as abap.char(30)),09,2), concat(':', concat(substring(cast(JournalItem.CreationDateTime as abap.char(30)),11,2), concat(':', substring(cast(JournalItem.CreationDateTime as abap.char(30)),13,2) ) ) ) ) ) ) ) ) ) ) as LastChangeDateTime AS char30132asLastChangeDateTime,
JournalItem.TransactionTypeDetermination AS TransactionTypeDetermination,
JournalItem.FinancialAccountType AS FinancialAccountType,
JournalItem.AccountingDocumentType AS AccountingDocumentType,
cast( concat(JournalItem.LogicalSystem, concat(JournalItem.ReferenceDocumentContext, JournalItem.ReferenceDocument)) as saftn_no_source_document_id ) AS NO_SAFTSourceDocument,
JournalItem.InvoiceReference AS InvoiceReference,
JournalItem.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
JournalItem.InvoiceItemReference AS InvoiceItemReference,
JournalItem.SalesDocument AS SalesDocument,
JournalItem.SalesDocumentItem AS SalesDocumentItem,
JournalItem.ReversalReferenceDocument AS ReversalReferenceDocument,
JournalItem.IsReversal AS IsReversal,
cast(0 as ukurs_curr) AS ExchangeRate,
cast(0 as rdif2) AS ExchRateDiffAmtInAddlCrcy1,
cast(0 as rdif2) AS ExchRateDiffAmtInAddlCrcy2,
' ' AS AccountingDocumentTypeName,
' ' AS DocumentReferenceID,
JournalItem._CompanyCode AS _CompanyCode,
JournalItem._FiscalYear AS _FiscalYear,
JournalItem._JournalEntry AS _JournalEntry,
JournalItem._Ledger AS _Ledger
FROM I_JournalEntryItem AS JournalItem
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA