What is I_RECostSettlementRelevantItm in SAP S/4HANA?

I_RECostSettlementRelevantItm is a composite CDS view in SAP S/4HANA. RE Cost Settlement Relevant Items It contains 61 fields.

Which tables does I_RECostSettlementRelevantItm read from?

I_RECostSettlementRelevantItm reads data from: I_RECostSettlmtCostObjPerObj, I_RECostSettlmtRlvtGLAccount.

What VDM layer is I_RECostSettlementRelevantItm?

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

I_RECostSettlementRelevantItm

DDL: I_RECOSTSETTLEMENTRELEVANTITM Type: view_entity COMPOSITE

61 Fields 2 Data Sources 1 Associations

RE Cost Settlement Relevant Items

I_RECostSettlementRelevantItm is a Composite CDS View that provides data about "RE Cost Settlement Relevant Items" in SAP S/4HANA. It reads from 2 data sources (I_RECostSettlmtCostObjPerObj, I_RECostSettlmtRlvtGLAccount) and exposes 61 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_RECostSettlmtCostObjPerObj	_RECostSettlmtCostObjPerObj	inner
I_RECostSettlmtRlvtGLAccount	_RECostSettlmtRlvtGLAccount	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_JournalEntryItem	_SupplierJournalEntryItem	`_JournalEntryItem.SourceLedger = _SupplierJournalEntryItem.Ledger and _JournalEntryItem.CompanyCode = _SupplierJournalEntryItem.CompanyCode and _JournalEntryItem.FiscalYear = _SupplierJournalEntryItem.FiscalYear and _JournalEntryItem.AccountingDocument = _SupplierJournalEntryItem.AccountingDocument and _JournalEntryItem.LedgerGLLineItem <> _SupplierJournalEntryItem.LedgerGLLineItem and _SupplierJournalEntryItem.FinancialAccountType = 'K' and _SupplierJournalEntryItem.Supplier <> ''`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	RE Cost Settlement Relevant Items	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	CompanyCode	_JournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	_JournalEntryItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	_JournalEntryItem	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	_JournalEntryItem	LedgerGLLineItem	Journal Entry Item
	Ledger	_JournalEntryItem	SourceLedger	Source Ledger
	IsReversed	_JournalEntryItem	IsReversed	Reversed?
	IsReversal	_JournalEntryItem	IsReversal	Reversal doc.
	REServiceGroupParentUUID	I_RECostSettlmtCostObjPerObj	REServiceGroupParentUUID
	REAccountingObject	I_RECostSettlmtCostObjPerObj	REAccountingObject	Object Number Account Assignment
	ReferenceDocumentType	_JournalEntryItem	ReferenceDocumentType	Reference Document Type
	ReferenceDocument	_JournalEntryItem	ReferenceDocument	Reference Document
	ReferenceDocumentContext	_JournalEntryItem	ReferenceDocumentContext	Reference Document Context
	AccountingDocumentType	_JournalEntryItem	AccountingDocumentType	Journal Entry Type
	PostingDate	_JournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	_JournalEntryItem	DocumentDate	Journal Entry Date
	DocumentItemText	_JournalEntryItem	DocumentItemText	Text
	GLAccount	_JournalEntryItem	GLAccount	General Ledger
	AssignmentReference	_JournalEntryItem	AssignmentReference	Assignment Reference
	CreationDate	_JournalEntryItem	CreationDate	Time Stamp
	Supplier	_JournalEntryItem	Supplier	Supplier
	ControllingArea	_JournalEntryItem	ControllingArea	Controlling Area
	BusinessArea	_JournalEntryItem	BusinessArea	Business Area
	FunctionalArea	_JournalEntryItem	FunctionalArea	Sendr Fctl Area
	Segment	_JournalEntryItem	Segment	Segment number
	CostCenter	_JournalEntryItem	CostCenter	Cost Center
	ProfitCenter	_JournalEntryItem	ProfitCenter	Profit Center
	WBSElementExternalID
	WBSDescription
	OrderID	_JournalEntryItem	OrderID	Order ID
	TransactionCurrency	_JournalEntryItem	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	_JournalEntryItem	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	_JournalEntryItem	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	_JournalEntryItem	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	_JournalEntryItem	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	_JournalEntryItem	AmountInGlobalCurrency	Amount in Global Currency
	FreeDefinedCurrency1	_JournalEntryItem	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	_JournalEntryItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	_JournalEntryItem	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	_JournalEntryItem	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	_JournalEntryItem	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	_JournalEntryItem	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	_JournalEntryItem	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	_JournalEntryItem	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	_JournalEntryItem	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	_JournalEntryItem	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	_JournalEntryItem	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	_JournalEntryItem	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	_JournalEntryItem	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	_JournalEntryItem	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	_JournalEntryItem	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	_JournalEntryItem	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	_REArchitectureObject	I_RECostSettlmtCostObjPerObj	_REArchitectureObject
	_GLAccountInCompanyCode	_JournalEntryItem	_GLAccountInCompanyCode
	_AccountingDocumentType	_JournalEntryItem	_AccountingDocumentType
	_CostCenter	_JournalEntryItem	_CostCenter
	_ProfitCenter	_JournalEntryItem	_ProfitCenter
	_Order	_JournalEntryItem	_Order
	_ControllingArea	_JournalEntryItem	_ControllingArea
	_GlobalCurrency	_JournalEntryItem	_GlobalCurrency
	_TransactionCurrency	_JournalEntryItem	_TransactionCurrency
	_SupplierJournalEntryItem		_SupplierJournalEntryItem

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_RECostSettlementRelevantItm.
-- 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.

CREATE VIEW I_RECostSettlementRelevantItm AS
SELECT
  _JournalEntryItem.CompanyCode AS CompanyCode,
  _JournalEntryItem.FiscalYear AS FiscalYear,
  _JournalEntryItem.AccountingDocument AS AccountingDocument,
  _JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  _JournalEntryItem.SourceLedger AS Ledger,
  _JournalEntryItem.IsReversed AS IsReversed,
  _JournalEntryItem.IsReversal AS IsReversal,
  _RECostSettlmtCostObjPerObj.REServiceGroupParentUUID AS REServiceGroupParentUUID,
  _RECostSettlmtCostObjPerObj.REAccountingObject AS REAccountingObject,
  _JournalEntryItem.ReferenceDocumentType AS ReferenceDocumentType,
  _JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  _JournalEntryItem.ReferenceDocumentContext AS ReferenceDocumentContext,
  _JournalEntryItem.AccountingDocumentType AS AccountingDocumentType,
  _JournalEntryItem.PostingDate AS PostingDate,
  _JournalEntryItem.DocumentDate AS DocumentDate,
  _JournalEntryItem.DocumentItemText AS DocumentItemText,
  _JournalEntryItem.GLAccount AS GLAccount,
  _JournalEntryItem.AssignmentReference AS AssignmentReference,
  _JournalEntryItem.CreationDate AS CreationDate,
  _JournalEntryItem.Supplier AS Supplier,
  _JournalEntryItem.ControllingArea AS ControllingArea,
  _JournalEntryItem.BusinessArea AS BusinessArea,
  _JournalEntryItem.FunctionalArea AS FunctionalArea,
  _JournalEntryItem.Segment AS Segment,
  _JournalEntryItem.CostCenter AS CostCenter,
  _JournalEntryItem.ProfitCenter AS ProfitCenter,
  _JournalEntryItem._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  _JournalEntryItem._WBSElementBasicData.WBSDescription AS WBSDescription,
  _JournalEntryItem.OrderID AS OrderID,
  _JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  _JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _JournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _JournalEntryItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _JournalEntryItem.GlobalCurrency AS GlobalCurrency,
  _JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _JournalEntryItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _JournalEntryItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _JournalEntryItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _JournalEntryItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _JournalEntryItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _JournalEntryItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _JournalEntryItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _JournalEntryItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _JournalEntryItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _JournalEntryItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _JournalEntryItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _JournalEntryItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _JournalEntryItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _JournalEntryItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _JournalEntryItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _JournalEntryItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _RECostSettlmtCostObjPerObj._REArchitectureObject AS _REArchitectureObject,
  _JournalEntryItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  _JournalEntryItem._AccountingDocumentType AS _AccountingDocumentType,
  _JournalEntryItem._CostCenter AS _CostCenter,
  _JournalEntryItem._ProfitCenter AS _ProfitCenter,
  _JournalEntryItem._Order AS _Order,
  _JournalEntryItem._ControllingArea AS _ControllingArea,
  _JournalEntryItem._GlobalCurrency AS _GlobalCurrency,
  _JournalEntryItem._TransactionCurrency AS _TransactionCurrency
INNER JOIN I_RECostSettlmtRlvtGLAccount AS _RECostSettlmtRlvtGLAccount ON /* join condition not captured in parsed metadata */
INNER JOIN I_RECostSettlmtCostObjPerObj AS _RECostSettlmtCostObjPerObj ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JournalEntryItem AS _SupplierJournalEntryItem ON _JournalEntryItem.SourceLedger = _SupplierJournalEntryItem.Ledger AND _JournalEntryItem.CompanyCode = _SupplierJournalEntryItem.CompanyCode AND _JournalEntryItem.FiscalYear = _SupplierJournalEntryItem.FiscalYear AND _JournalEntryItem.AccountingDocument = _SupplierJournalEntryItem.AccountingDocument AND _JournalEntryItem.LedgerGLLineItem <> _SupplierJournalEntryItem.LedgerGLLineItem AND _SupplierJournalEntryItem.FinancialAccountType = 'K' AND _SupplierJournalEntryItem.Supplier <> ''  -- association [0..*]
;

Depth:

I_RECostSettlementRelevantItm view_entity

I_RECostSettlmtCostObjPerObj view_entity
I_RECostSettlmtRlvtGLAccount view_entity