P_BG_SAFTANALYSISTYPEITEM

DDL: P_BG_SAFTANALYSISTYPEITEM Type: view_entity CONSUMPTION
51 Fields 5 Data Sources

P_BG_SAFTANALYSISTYPEITEM is a Consumption CDS View in SAP S/4HANA. It reads from 5 data sources (I_JournalEntryItem, I_JournalEntryItem, I_JournalEntryItem, I_JournalEntryItem, I_JournalEntryItem) and exposes 51 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (5)

SourceAliasJoin Type
I_JournalEntryItem JournalEntry from
I_JournalEntryItem JournalEntry union_all
I_JournalEntryItem JournalEntry union_all
I_JournalEntryItem JournalEntry union_all
I_JournalEntryItem JournalEntry union_all

Parameters (1)

NameTypeDefault
P_FromPostingDate dats

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_JournalEntryItem SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger Ledger
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 AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
KEY PostingDate I_JournalEntryItem PostingDate Posting Date for GR
KEY BG_SAFTAnalysisType
BG_SAFTAnalysisEntry Order ID
SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger Ledger
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 AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
KEY PostingDate I_JournalEntryItem PostingDate Posting Date for GR
KEY BG_SAFTAnalysisType
BG_SAFTAnalysisEntry I_JournalEntryItem CostCenter Order ID
SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger Ledger
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 AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
KEY PostingDate I_JournalEntryItem PostingDate Posting Date for GR
KEY BG_SAFTAnalysisType
BG_SAFTAnalysisEntry I_JournalEntryItem Segment Order ID
SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger Ledger
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 AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
KEY PostingDate I_JournalEntryItem PostingDate Posting Date for GR
KEY BG_SAFTAnalysisType
BG_SAFTAnalysisEntry I_JournalEntryItem WBSElement Order ID
SourceLedger Source Ledger
KEY Ledger I_JournalEntryItem Ledger Ledger
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 AccountingDocumentType I_JournalEntryItem AccountingDocumentType Journal Entry Type
KEY PostingDate I_JournalEntryItem PostingDate Posting Date for GR
KEY BG_SAFTAnalysisType
BG_SAFTAnalysisEntry I_JournalEntryItem OrderID Order ID
BG_SAFTAnalysisEntryDesc

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_BG_SAFTANALYSISTYPEITEM.
-- 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.
-- Parameters: P_FromPostingDate : dats

CREATE VIEW P_BG_SAFTANALYSISTYPEITEM AS
SELECT
  JournalEntry.SourceLedger AS SourceLedger,
  JournalEntry.Ledger AS Ledger,
  JournalEntry.CompanyCode AS CompanyCode,
  JournalEntry.FiscalYear AS FiscalYear,
  JournalEntry.AccountingDocument AS AccountingDocument,
  JournalEntry.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  JournalEntry.PostingDate AS PostingDate,
  cast('PC' as bgsaft_analysistype) AS BG_SAFTAnalysisType,
  cast(JournalEntry.ProfitCenter as bgsaft_analysis_id) AS BG_SAFTAnalysisEntry,
  cast(JournalEntry._Order.OrderDescription as bgsaft_anals_type_desc) AS BG_SAFTAnalysisEntryDesc
FROM I_JournalEntryItem AS JournalEntry
-- UNION ALL with additional select branch(es): I_JournalEntryItem
;

Learn More