C_CostElementTP

DDL: C_COSTELEMENTTP SQL: CCOELTP Type: view CONSUMPTION
23 Fields 1 Data Sources 1 Associations

Consumption View: Cost Element

C_CostElementTP is a Consumption CDS View that provides data about "Consumption View: Cost Element" in SAP S/4HANA. It reads from 1 data source (I_CostElementTP) and exposes 23 fields with key fields ChartOfAccounts, GLAccount, ControllingArea. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CostElementTP tpview from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_GLAcctInChtAcctsTP _GLAcctInChtAcctsTP $projection.ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts and $projection.GLAccount = _GLAcctInChtAcctsTP.GLAccount

Annotations (12)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CCOELTP view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Consumption View: Cost Element view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts I_CostElementTP ChartOfAccounts Node Class
KEY GLAccount I_CostElementTP GLAccount General Ledger
KEY ControllingArea I_CostElementTP ControllingArea Controlling Area
ControllingAreaForEdit I_CostElementTP ControllingAreaForEdit Controlling Area
ChartOfAccountsForEdit I_CostElementTP ChartOfAccountsForEdit Chart of Accts
GLAccountForEdit I_CostElementTP GLAccountForEdit G/L Account
ValidityStartDate I_CostElementTP ValidityStartDate Validity Start Date
ValidityEndDate I_CostElementTP ValidityEndDate ValidTo
CostElementCategory I_CostElementTP CostElementCategory
CostElementCategoryName
ConsumptionQtyIsRecorded I_CostElementTP ConsumptionQtyIsRecorded Record Quantity
UnitOfMeasure I_CostElementTP UnitOfMeasure Unit Protected Qty
UnitOfMeasureName
CreationDate I_CostElementTP CreationDate Time Stamp
CreatedByUser I_CostElementTP CreatedByUser User Name
FunctionalArea I_CostElementTP FunctionalArea Sendr Fctl Area
AcctAssignmentIsStatistical I_CostElementTP AcctAssignmentIsStatistical
AccountIsMarkedForDeletion I_CostElementTP AccountIsMarkedForDeletion Deletion Flag
_ControllingArea I_CostElementTP _ControllingArea
_CostElementCategory I_CostElementTP _CostElementCategory
_FunctionalArea I_CostElementTP _FunctionalArea
_GLAcctInChtAcctsTP _GLAcctInChtAcctsTP
_UnitOfMeasure I_CostElementTP _UnitOfMeasure

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 C_CostElementTP.
-- 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: CCOELTP

CREATE VIEW C_CostElementTP AS
SELECT
  tpview.ChartOfAccounts AS ChartOfAccounts,
  tpview.GLAccount AS GLAccount,
  tpview.ControllingArea AS ControllingArea,
  tpview.ControllingAreaForEdit AS ControllingAreaForEdit,
  tpview.ChartOfAccountsForEdit AS ChartOfAccountsForEdit,
  tpview.GLAccountForEdit AS GLAccountForEdit,
  tpview.ValidityStartDate AS ValidityStartDate,
  tpview.ValidityEndDate AS ValidityEndDate,
  tpview.CostElementCategory AS CostElementCategory,
  _CostElementCategory._Text[1:Language = $session.system_language].CostElementCategoryName AS CostElementCategoryName,
  tpview.ConsumptionQtyIsRecorded AS ConsumptionQtyIsRecorded,
  tpview.UnitOfMeasure AS UnitOfMeasure,
  _UnitOfMeasure._Text[1:Language = $session.system_language].UnitOfMeasureName AS UnitOfMeasureName,
  tpview.CreationDate AS CreationDate,
  tpview.CreatedByUser AS CreatedByUser,
  tpview.FunctionalArea AS FunctionalArea,
  tpview.AcctAssignmentIsStatistical AS AcctAssignmentIsStatistical,
  tpview.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  tpview._ControllingArea AS _ControllingArea,
  tpview._CostElementCategory AS _CostElementCategory,
  tpview._FunctionalArea AS _FunctionalArea,
  tpview._UnitOfMeasure AS _UnitOfMeasure
FROM I_CostElementTP AS tpview
LEFT OUTER JOIN C_GLAcctInChtAcctsTP AS _GLAcctInChtAcctsTP ON ChartOfAccounts = _GLAcctInChtAcctsTP.ChartOfAccounts AND GLAccount = _GLAcctInChtAcctsTP.GLAccount  -- association [1..1]
;

Learn More