I_InternalOrderWBSElementVH

DDL: I_INTERNALORDERWBSELEMENTVH Type: view_entity COMPOSITE
13 Fields 1 Data Sources

WBS Element

I_InternalOrderWBSElementVH is a Composite CDS View that provides data about "WBS Element" in SAP S/4HANA. It reads from 1 data source (I_WBSElementBasicData) and exposes 13 fields with key field WBSElementInternalID.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData I_WBSElementBasicData from

Annotations (12)

NameValueLevelField
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WBS Element view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
Search.searchable true view
Consumption.ranked true view
UI.textArrangement #TEXT_LAST view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSDescription WBSDescription WBS Element Name
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
FunctionalArea FunctionalArea Sendr Fctl Area
ProfitCenter ProfitCenter Profit Center
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
Plant Plant Valuation Area
CostingSheet CostingSheet Costing Sheet
ProjectType ProjectType Project Type
ProjectInternalID
_Project _Project

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_InternalOrderWBSElementVH.
-- 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_InternalOrderWBSElementVH AS
SELECT
  WBSElementInternalID,
  WBSElementExternalID,
  WBSDescription,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ResponsibleCostCenter,
  Plant,
  CostingSheet,
  ProjectType,
  cast( I_WBSElementBasicData.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID
FROM I_WBSElementBasicData
;

Learn More