I_ProjStkCostElementText

DDL: I_PROJSTKCOSTELEMENTTEXT Type: view_entity COMPOSITE
5 Fields 3 Data Sources

Cost Element - Text

I_ProjStkCostElementText is a Composite CDS View that provides data about "Cost Element - Text" in SAP S/4HANA. It reads from 3 data sources (t001, skb1, ska1) and exposes 5 fields with key fields GLAccount, ChartOfAccounts, CompanyCode, Language.

Data Sources (3)

SourceAliasJoin Type
t001 CompanyCode inner
skb1 GLAcccompanyCode inner
ska1 GLAccMaster from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Cost Element - Text view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #TEXT view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY GLAccount ska1 saknr G/L Account
KEY ChartOfAccounts ska1 ktopl G/L Chart of Accounts
KEY CompanyCode skb1 bukrs Value
KEY Language
CostElementName GLAccMasterDesc txt20 Text 20

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_ProjStkCostElementText.
-- 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_ProjStkCostElementText AS
SELECT
  GLAccMaster.saknr AS GLAccount,
  GLAccMaster.ktopl AS ChartOfAccounts,
  GLAcccompanyCode.bukrs AS CompanyCode,
  $session.system_language AS Language,
  GLAccMasterDesc.txt20 AS CostElementName
FROM ska1 AS GLAccMaster
INNER JOIN t001 AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN skb1 AS GLAcccompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More