P_RO_SAFTJournalEntry

DDL: P_RO_SAFTJOURNALENTRY SQL: PROSAFTJRNLENTRY Type: view CONSUMPTION
19 Fields 1 Data Sources

GL Entry for RO SAFT (intermediary step)

P_RO_SAFTJournalEntry is a Consumption CDS View that provides data about "GL Entry for RO SAFT (intermediary step)" in SAP S/4HANA. It reads from 1 data source (P_RO_SAFTJournalEntryItem) and exposes 19 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, SourceLedger, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
P_RO_SAFTJournalEntryItem P_RO_SAFTJournalEntryItem from

Parameters (2)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag
P_VATRegistration stceg

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PROSAFTJRNLENTRY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label GL Entry for RO SAFT (intermediary step) view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory Item StatryRptCategory Report ID
KEY StatryRptgEntity Item StatryRptgEntity Reporting Entity
KEY StatryRptRunID Item StatryRptRunID Report Run ID
KEY SourceLedger Item SourceLedger Source Ledger
KEY CompanyCode Item CompanyCode Receiver Company Code
KEY FiscalYear Item FiscalYear G/L Fiscal Year
KEY AccountingDocument Item AccountingDocument Journal Entry
KEY Ledger Item Ledger Ledger
AccountingDocumentType Item AccountingDocumentType Journal Entry Type
RO_SAFTJournalTransDescription Item RO_SAFTJournalTransDescription
RO_SAFTJournalTransaction Item RO_SAFTJournalTransaction
RO_SAFTJournalTransactionType Item RO_SAFTJournalTransactionType
RO_SAFTSourceDocument Item RO_SAFTSourceDocument
PostingDate Item PostingDate Posting Date for GR
DocumentDate Item DocumentDate Journal Entry Date
AccountingDocumentCreationDate Item AccountingDocumentCreationDate Journal Entry Date
AccountingDocCreatedByUser Item AccountingDocCreatedByUser User which created overhead document
CustomerTaxID5
SupplierTaxID5

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 P_RO_SAFTJournalEntry.
-- 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: PROSAFTJRNLENTRY
-- Parameters: P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag, P_VATRegistration : stceg

CREATE VIEW P_RO_SAFTJournalEntry AS
SELECT
  Item.StatryRptCategory AS StatryRptCategory,
  Item.StatryRptgEntity AS StatryRptgEntity,
  Item.StatryRptRunID AS StatryRptRunID,
  Item.SourceLedger AS SourceLedger,
  Item.CompanyCode AS CompanyCode,
  Item.FiscalYear AS FiscalYear,
  Item.AccountingDocument AS AccountingDocument,
  Item.Ledger AS Ledger,
  Item.AccountingDocumentType AS AccountingDocumentType,
  Item.RO_SAFTJournalTransDescription AS RO_SAFTJournalTransDescription,
  Item.RO_SAFTJournalTransaction AS RO_SAFTJournalTransaction,
  Item.RO_SAFTJournalTransactionType AS RO_SAFTJournalTransactionType,
  Item.RO_SAFTSourceDocument AS RO_SAFTSourceDocument,
  Item.PostingDate AS PostingDate,
  Item.DocumentDate AS DocumentDate,
  Item.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  max(Item.CustomerTaxID5) AS CustomerTaxID5,
  max(Item.SupplierTaxID5) AS SupplierTaxID5
FROM P_RO_SAFTJournalEntryItem
;

Learn More