Which tables does P_RU_FINSTMNTCASHFLOWLOGITEM read from?

P_RU_FINSTMNTCASHFLOWLOGITEM reads data from: P_RU_FINSTMNTCASHFLOWLOGITEM2.

What VDM layer is P_RU_FINSTMNTCASHFLOWLOGITEM?

P_RU_FINSTMNTCASHFLOWLOGITEM is classified as a Composite view that combines data from multiple basic views.

P_RU_FINSTMNTCASHFLOWLOGITEM

Q: What is P_RU_FINSTMNTCASHFLOWLOGITEM in SAP S/4HANA?

P_RU_FINSTMNTCASHFLOWLOGITEM is a composite CDS view in SAP S/4HANA. It contains 89 fields.

DDL: P_RU_FINSTMNTCASHFLOWLOGITEM SQL: PRUFS_LOGITEM_CF Type: view COMPOSITE

89 Fields 1 Data Sources 1 Associations

P_RU_FINSTMNTCASHFLOWLOGITEM is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_FINSTMNTCASHFLOWLOGITEM2) and exposes 89 fields with key fields FinancialStatementLeafItem, StatryRptgEntity, StatryRptCategory, StatryRptRunID, CashFlowStatementHierVersion. It has 1 association to related views.

Data Sources (1)

Source	Alias	Join Type
P_RU_FINSTMNTCASHFLOWLOGITEM2	P_RU_FINSTMNTCASHFLOWLOGITEM2	from

Parameters (5)

Name	Type	Default
P_StatryRptRunID	srf_report_run_id
P_StatryRptgEntity	srf_reporting_entity
P_StatryRptCategory	srf_rep_cat_id
P_FinancialStatementHierarchy	firu_cf_version
P_SourceLedger	fins_ledger_pers

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_OperationalAcctgDocItem	_OperationalAcctgDocItem	`_OperationalAcctgDocItem.AccountingDocument = FIRUD.AccountingDocument and _OperationalAcctgDocItem.FiscalYear = FIRUD.FiscalYear and _OperationalAcctgDocItem.CompanyCode = FIRUD.CompanyCode and _OperationalAcctgDocItem.AccountingDocumentItem = FIRUD.AccountingDocumentItem`

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PRUFS_LOGITEM_CF	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCK_DATA_INCLUDED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.lifecycle.status	#DEPRECATED	view
VDM.lifecycle.successor	I_RU_FinStmntCashFlowLogItem	view

Fields (89)

Key	Field	Source Table	Source Field	Description
KEY	FinancialStatementLeafItem		FinancialStatementLeafItem	Node
KEY	StatryRptgEntity		StatryRptgEntity	Reporting Entity
KEY	StatryRptCategory		StatryRptCategory	Report ID
KEY	StatryRptRunID		StatryRptRunID	Report Run ID
KEY	CashFlowStatementHierVersion		CashFlowStatementHierVersion
KEY	CompanyCode		CompanyCode	Receiver Company Code
KEY	AccountingDocument		AccountingDocument	Journal Entry
KEY	LedgerGLLineItem		LedgerGLLineItem	Journal Entry Item
KEY	FiscalYear		FiscalYear	G/L Fiscal Year
KEY	ClearedInvoiceNumber		ClearedInvoiceNumber
KEY	ClearedInvoiceYear		ClearedInvoiceYear
KEY	CashFlowStmntReportingPeriod			Single-Character Flag
	CalendarYear
	Currency		Currency	Valuation Crcy
	PeriodBalAmtInDspCrcy		PeriodBalAmtInDspCrcy
	DocumentDate		DocumentDate	Journal Entry Date
	PostingDate		PostingDate	Posting Date for GR
	BusinessArea		BusinessArea	Business Area
	ControllingArea		ControllingArea	Controlling Area
	FunctionalArea		FunctionalArea	Sendr Fctl Area
	ValuationArea		ValuationArea	Valuation Area
	InventoryValuationType		InventoryValuationType	Valuation Type
	CostCenter		CostCenter	Cost Center
	ProfitCenter		ProfitCenter	Profit Center
	Segment		Segment	Segment number
	WBSElement		WBSElement	WBS Internal ID
	WBSElementInternalID		WBSElementInternalID	WBS Internal ID
	WBSElementExternalID		WBSElementExternalID	WBS Element External ID
	AlternativeGLAccount		AlternativeGLAccount	Group Account
	GLAccount		GLAccount	General Ledger
	FundsCenter		FundsCenter	Funds Center
	AssignmentReference		AssignmentReference	Assignment Reference
	AssetClass		AssetClass	Asset Class
	MasterFixedAsset		MasterFixedAsset	Fixed Asset
	FixedAsset		FixedAsset	Sub-number
	Customer		Customer	Sold-to Party
	Supplier		Supplier	Supplier
	Plant		Plant	Valuation Area
	Material		Material	Vehicle Model
	Product		Product	Product Sold
	AccountingDocumentItem		AccountingDocumentItem	Posting View Item
	AccountingDocumentType		AccountingDocumentType	Journal Entry Type
	CountryChartOfAccounts		CountryChartOfAccounts	Chart of Accts
	ChartOfAccounts		ChartOfAccounts	Node Class
	FinancialManagementArea		FinancialManagementArea	FM Area
	CompanyCode2		CompanyCode2	Receiver Company Code
	SourceLedger		SourceLedger	Source Ledger
	FiscalPeriod		FiscalPeriod	Tax period
	Item		Item	Task ID
	ParentItem		ParentItem
	ItemType		ItemType	Object Type
	FinancialStmntCashFlowItemMode		FinancialStmntCashFlowItemMode
	ItemSignIsReversed		ItemSignIsReversed	Change Item Sign
	ItemIsHiddenInReporting		ItemIsHiddenInReporting
	CommitmentItem	_OperationalAcctgDocItem	CommitmentItem	Commitment item
	DocumentReferenceID		DocumentReferenceID	Reference
	AccountingDocumentHeaderText		AccountingDocumentHeaderText	Doc.Header Text
	JrnlEntryCntrySpecificRef4		JrnlEntryCntrySpecificRef4	Country/Region Specific Reference 4
	JrnlEntryCntrySpecificDate4		JrnlEntryCntrySpecificDate4	Country/Region Specific Date 4
	_AccountingDocumentType		_AccountingDocumentType
	_AlternativeGLAccount		_AlternativeGLAccount
	_BusinessArea		_BusinessArea
	_ChartOfAccounts		_ChartOfAccounts
	_CompanyCode		_CompanyCode
	_ControllingArea		_ControllingArea
	_CostCenter		_CostCenter
	_CountryChartOfAccounts		_CountryChartOfAccounts
	_Customer	FIRUD	_Customer
	_FinancialManagementArea		_FinancialManagementArea
	_FunctionalArea		_FunctionalArea
	_FundsCenter		_FundsCenter
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_GLAccountLineItem		_GLAccountLineItem
	_InventoryValuationType		_InventoryValuationType
	_Item		_Item
	_Version		_Version
	_MasterFixedAsset		_MasterFixedAsset
	_Material		_Material
	_Plant		_Plant
	_ProfitCenter		_ProfitCenter
	_PurReqValuationArea		_PurReqValuationArea
	_Segment		_Segment
	_Supplier	FIRUD	_Supplier
	_WBSElement		_WBSElement
	SpecialGLCode	_OperationalAcctgDocItem	SpecialGLCode	Special G/L Ind
	Reference1IDByBusinessPartner	_OperationalAcctgDocItem	Reference1IDByBusinessPartner	Reference Key 1
	Reference2IDByBusinessPartner	_OperationalAcctgDocItem	Reference2IDByBusinessPartner	Reference Key 2
	Reference3IDByBusinessPartner	_OperationalAcctgDocItem	Reference3IDByBusinessPartner	Reference Key 3
	BusinessPlace	_OperationalAcctgDocItem	BusinessPlace	Business place

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_RU_FINSTMNTCASHFLOWLOGITEM.
-- 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: PRUFS_LOGITEM_CF
-- Parameters: P_StatryRptRunID : srf_report_run_id, P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_FinancialStatementHierarchy : firu_cf_version, P_SourceLedger : fins_ledger_pers

CREATE VIEW P_RU_FINSTMNTCASHFLOWLOGITEM AS
SELECT
  FinancialStatementLeafItem,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CashFlowStatementHierVersion,
  CompanyCode,
  AccountingDocument,
  LedgerGLLineItem,
  FiscalYear,
  ClearedInvoiceNumber,
  ClearedInvoiceYear,
  cast( ReportingPeriod as firu_cf_reportperiod ) AS CashFlowStmntReportingPeriod,
  cast(substring(PostingDate, 1, 4) as calendaryear) AS CalendarYear,
  Currency,
  PeriodBalAmtInDspCrcy,
  DocumentDate,
  PostingDate,
  BusinessArea,
  ControllingArea,
  FunctionalArea,
  ValuationArea,
  InventoryValuationType,
  CostCenter,
  ProfitCenter,
  Segment,
  WBSElement,
  WBSElementInternalID,
  WBSElementExternalID,
  AlternativeGLAccount,
  GLAccount,
  FundsCenter,
  AssignmentReference,
  AssetClass,
  MasterFixedAsset,
  FixedAsset,
  Customer,
  Supplier,
  Plant,
  Material,
  Product,
  AccountingDocumentItem,
  AccountingDocumentType,
  CountryChartOfAccounts,
  ChartOfAccounts,
  FinancialManagementArea,
  CompanyCode2,
  SourceLedger,
  FiscalPeriod,
  Item,
  ParentItem,
  ItemType,
  FinancialStmntCashFlowItemMode,
  ItemSignIsReversed,
  ItemIsHiddenInReporting,
  _OperationalAcctgDocItem.CommitmentItem AS CommitmentItem,
  DocumentReferenceID,
  AccountingDocumentHeaderText,
  JrnlEntryCntrySpecificRef4,
  JrnlEntryCntrySpecificDate4,
  FIRUD._Customer AS _Customer,
  FIRUD._Supplier AS _Supplier,
  _OperationalAcctgDocItem.SpecialGLCode AS SpecialGLCode,
  _OperationalAcctgDocItem.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  _OperationalAcctgDocItem.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  _OperationalAcctgDocItem.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  _OperationalAcctgDocItem.BusinessPlace AS BusinessPlace
FROM P_RU_FINSTMNTCASHFLOWLOGITEM2
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _OperationalAcctgDocItem ON _OperationalAcctgDocItem.AccountingDocument = FIRUD.AccountingDocument AND _OperationalAcctgDocItem.FiscalYear = FIRUD.FiscalYear AND _OperationalAcctgDocItem.CompanyCode = FIRUD.CompanyCode AND _OperationalAcctgDocItem.AccountingDocumentItem = FIRUD.AccountingDocumentItem  -- association [1..1]
;

Depth:

P_RU_FINSTMNTCASHFLOWLOGITEM view

P_RU_FINSTMNTCASHFLOWLOGITEM2 view