I_SAFTJournalHeader

DDL: I_SAFTJOURNALHEADER SQL: IJRNLHDR Type: view COMPOSITE
26 Fields 2 Data Sources

SAF-T Journal Header

I_SAFTJournalHeader is a Composite CDS View that provides data about "SAF-T Journal Header" in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, P_SAFTSumJournalLineItem) and exposes 26 fields with key fields CompanyCode, FiscalYear, AccountingDocument, Ledger.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry JournalHeader from
P_SAFTSumJournalLineItem SumJournalLineItem inner

Parameters (1)

NameTypeDefault
P_Ledger fins_ledger

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJRNLHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Journal Header view

Fields (26)

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 P_SAFTSumJournalLineItem Ledger Ledger
AccountingDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
AccountingDocumentTypeName
AccountingDocumentHeaderText I_JournalEntry AccountingDocumentHeaderText Doc.Header Text
FiscalPeriod I_JournalEntry FiscalPeriod Tax period
PostingDate I_JournalEntry PostingDate Posting Date for GR
CompanyCodeCurrency P_SAFTSumJournalLineItem CompanyCodeCurrency Local Currency
TotalGrossAmountInCoCodeCrcy P_SAFTSumJournalLineItem TotalGrossAmountInCoCodeCrcy Amount in LC
AccountingDocumentCreationDate I_JournalEntry AccountingDocumentCreationDate Journal Entry Date
AccountingDocCreatedByUser I_JournalEntry AccountingDocCreatedByUser User which created overhead document
ExchangeRate I_JournalEntry ExchangeRate Exchange rate
DocumentDate I_JournalEntry DocumentDate Journal Entry Date
TransactionCurrency I_JournalEntry TransactionCurrency Transaction Currency
SourceLedger P_SAFTSumJournalLineItem SourceLedger Source Ledger
AccountingDocumentCategory I_JournalEntry AccountingDocumentCategory Journal Entry Category
OriginalReferenceDocument
ReferenceDocumentType I_JournalEntry ReferenceDocumentType Reference Document Type
_CompanyCode I_JournalEntry _CompanyCode
_FiscalYear I_JournalEntry _FiscalYear
_FiscalPeriod I_JournalEntry _FiscalPeriod
_AccountingDocumentType I_JournalEntry _AccountingDocumentType
_Ledger
_CompanyCodeCurrency P_SAFTSumJournalLineItem _CompanyCodeCurrency

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_SAFTJournalHeader.
-- 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: IJRNLHDR
-- Parameters: P_Ledger : fins_ledger

CREATE VIEW I_SAFTJournalHeader AS
SELECT
  JournalHeader.CompanyCode AS CompanyCode,
  JournalHeader.FiscalYear AS FiscalYear,
  JournalHeader.AccountingDocument AS AccountingDocument,
  SumJournalLineItem.Ledger AS Ledger,
  JournalHeader.AccountingDocumentType AS AccountingDocumentType,
  coalesce(_AccountingDocumentTypeText[1: Language = $session.system_language].AccountingDocumentTypeName,' ') AS AccountingDocumentTypeName,
  JournalHeader.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  JournalHeader.FiscalPeriod AS FiscalPeriod,
  JournalHeader.PostingDate AS PostingDate,
  SumJournalLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  SumJournalLineItem.TotalGrossAmountInCoCodeCrcy AS TotalGrossAmountInCoCodeCrcy,
  JournalHeader.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  JournalHeader.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  JournalHeader.ExchangeRate AS ExchangeRate,
  JournalHeader.DocumentDate AS DocumentDate,
  JournalHeader.TransactionCurrency AS TransactionCurrency,
  SumJournalLineItem.SourceLedger AS SourceLedger,
  JournalHeader.AccountingDocumentCategory AS AccountingDocumentCategory,
  JournalHeader.ReferenceDocumentType AS ReferenceDocumentType,
  JournalHeader._CompanyCode AS _CompanyCode,
  JournalHeader._FiscalYear AS _FiscalYear,
  JournalHeader._FiscalPeriod AS _FiscalPeriod,
  JournalHeader._AccountingDocumentType AS _AccountingDocumentType,
  SumJournalLineItem._CompanyCodeCurrency AS _CompanyCodeCurrency
FROM I_JournalEntry AS JournalHeader
INNER JOIN P_SAFTSumJournalLineItem AS SumJournalLineItem ON /* join condition not captured in parsed metadata */
;

Learn More