I_WBSElementWithCodingMaskVH

DDL: I_WBSELEMENTWITHCODINGMASKVH SQL: IWBSWITHCMASKVH Type: view COMPOSITE

Value help for WBS Element with coding mask

I_WBSElementWithCodingMaskVH is a Composite CDS View that provides data about "Value help for WBS Element with coding mask" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 25 fields with key field WBSElement.

Data Sources (1)

SourceAliasJoin Type
I_WBSElement WBSElement from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IWBSWITHCMASKVH view
EndUserText.label Value help for WBS Element with coding mask view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey WBSElement view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Search.searchable true view
Consumption.ranked true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElement WBSElementWithCodingMask WBS Element
WBSDescription I_WBSElement WBSDescription WBS Element Name
WBSElementLangBsdDescription WBS Element Language-Dependent Short Text
Project
ProjectDescription
ResponsiblePerson I_WBSElement ResponsiblePerson Processor
ResponsiblePersonName I_WBSElement ResponsiblePersonName User
WBSElementIsBillingElement I_WBSElement WBSElementIsBillingElement Billing elem.
WBSIsAccountAssignmentElement I_WBSElement WBSIsAccountAssignmentElement
WBSElementIsPlanningElement I_WBSElement WBSElementIsPlanningElement
ProjectType I_WBSElement ProjectType Project Type
ControllingArea I_WBSElement ControllingArea Controlling Area
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea CA (resp.)
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter Responsible Cost Center
ProfitCenter I_WBSElement ProfitCenter Profit Center
FreeDefinedAttribute01 I_WBSElement FreeDefinedAttribute01 Attribute 1
FreeDefinedAttribute02 I_WBSElement FreeDefinedAttribute02 Attribute 2
FreeDefinedAttribute03 I_WBSElement FreeDefinedAttribute03 Attribute 3
FreeDefinedAttribute04 I_WBSElement FreeDefinedAttribute04 Attribute 4
FreeDefinedIndicator1 I_WBSElement FreeDefinedIndicator1
FreeDefinedIndicator2 I_WBSElement FreeDefinedIndicator2
_ResponsiblePerson I_WBSElement _ResponsiblePerson
ApplicantCode I_WBSElement ApplicantCode
WBSElementObject I_WBSElement WBSElementObject Object number
_ProjectApplicant I_WBSElement _ProjectApplicant

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_WBSElementWithCodingMaskVH.
-- 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: IWBSWITHCMASKVH

CREATE VIEW I_WBSElementWithCodingMaskVH AS
SELECT
  WBSElement.WBSElementWithCodingMask AS WBSElement,
  WBSElement.WBSDescription AS WBSDescription,
  WBSElement._WBSElementShortText.LanguageBasedShortText AS WBSElementLangBsdDescription,
  WBSElement._Project.ProjectWithCodingMask AS Project,
  WBSElement._Project.ProjectDescription AS ProjectDescription,
  WBSElement.ResponsiblePerson AS ResponsiblePerson,
  WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  WBSElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  WBSElement.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  WBSElement.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  WBSElement.ProjectType AS ProjectType,
  WBSElement.ControllingArea AS ControllingArea,
  WBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  WBSElement.ProfitCenter AS ProfitCenter,
  WBSElement.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  WBSElement.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  WBSElement.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  WBSElement.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  WBSElement.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  WBSElement.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  WBSElement._ResponsiblePerson AS _ResponsiblePerson,
  WBSElement.ApplicantCode AS ApplicantCode,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement._ProjectApplicant AS _ProjectApplicant
FROM I_WBSElement AS WBSElement
;