I_RECostSettlmtClfnItemDetails

DDL: I_RECOSTSETTLMTCLFNITEMDETAILS Type: view_entity COMPOSITE
58 Fields 3 Data Sources 1 Associations

RE Cost Settlement Details of JEI Clfn

I_RECostSettlmtClfnItemDetails is a Composite CDS View that provides data about "RE Cost Settlement Details of JEI Clfn" in SAP S/4HANA. It reads from 3 data sources (I_RECostSettlmtClassfctnItem, I_RECostSettlmtCostObjPerObj, I_RECostSettlmtRlvtGLAccount) and exposes 58 fields with key fields CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_RECostSettlmtClassfctnItem _RECostSettlmtClassfctnItem inner
I_RECostSettlmtCostObjPerObj _RECostSettlmtCostObjPerObj inner
I_RECostSettlmtRlvtGLAccount _RECostSettlmtRlvtGLAccount inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REArchitectureObject _REArchitectureObject $projection.REArchitectureObjectUUID = _REArchitectureObject.REArchitectureObjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RE Cost Settlement Details of JEI Clfn view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view

Fields (58)

KeyFieldSource TableSource FieldDescription
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
RECostSettlmtClassfctnUUID I_RECostSettlmtClassfctnItem RECostSettlmtClassfctnUUID Classification GUID
REArchitectureObjectUUID I_RECostSettlmtCostObjPerObj REServiceGroupParentUUID
REAccountingObject _JournalEntryItem ControllingObject Object number
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
WBSElementInternalID _JournalEntryItem WBSElementInternalID WBS Internal ID
WBSDescription
OrderID _JournalEntryItem OrderID Order ID
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
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
_GLAccountInCompanyCode _JournalEntryItem _GLAccountInCompanyCode
_AccountingDocumentType _JournalEntryItem _AccountingDocumentType
_CostCenter _JournalEntryItem _CostCenter
_ProfitCenter _JournalEntryItem _ProfitCenter
_Order _JournalEntryItem _Order
_ControllingArea _JournalEntryItem _ControllingArea
_GlobalCurrency _JournalEntryItem _GlobalCurrency
_TransactionCurrency _JournalEntryItem _TransactionCurrency
_REArchitectureObject _REArchitectureObject

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_RECostSettlmtClfnItemDetails.
-- 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_RECostSettlmtClfnItemDetails AS
SELECT
  _JournalEntryItem.CompanyCode AS CompanyCode,
  _JournalEntryItem.FiscalYear AS FiscalYear,
  _JournalEntryItem.AccountingDocument AS AccountingDocument,
  _JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  _RECostSettlmtClassfctnItem.RECostSettlmtClassfctnUUID AS RECostSettlmtClassfctnUUID,
  _RECostSettlmtCostObjPerObj.REServiceGroupParentUUID AS REArchitectureObjectUUID,
  _JournalEntryItem.ControllingObject AS REAccountingObject,
  _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.WBSElementInternalID AS WBSElementInternalID,
  _JournalEntryItem._WBSElementBasicData.WBSDescription AS WBSDescription,
  _JournalEntryItem.OrderID AS OrderID,
  _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.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,
  _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_RECostSettlmtClassfctnItem AS _RECostSettlmtClassfctnItem 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_REArchitectureObject AS _REArchitectureObject ON REArchitectureObjectUUID = _REArchitectureObject.REArchitectureObjectUUID  -- association [1..1]
;

Learn More