I_TravelWBSElementVH

DDL: I_TRAVELWBSELEMENTVH Type: view BASIC
14 Fields 2 Data Sources

Travel Request WBS Element

I_TravelWBSElementVH is a Basic CDS View that provides data about "Travel Request WBS Element" in SAP S/4HANA. It reads from 2 data sources (prps, I_WBSElementData) and exposes 14 fields with key field WBSElement.

Data Sources (2)

SourceAliasJoin Type
prps prps inner
I_WBSElementData WBS from

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Travel Request WBS Element view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ITRVLWBSELMNTVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey WBSElement view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WBSElement
WBSDescription I_WBSElementData WBSDescription WBS Element Name
WBSElementShortID I_WBSElementData WBSElementShortID Short ID
WBSElementInternalID
ResponsiblePerson I_WBSElementData ResponsiblePerson Processor
ApplicantCode I_WBSElementData ApplicantCode
ResponsibleCostCenter I_WBSElementData ResponsibleCostCenter Responsible Cost Center
RespCostCenterControllingArea I_WBSElementData RespCostCenterControllingArea CA (resp.)
ProjectType I_WBSElementData ProjectType Project Type
ControllingArea I_WBSElementData ControllingArea Controlling Area
ResponsiblePersonName I_WBSElementData ResponsiblePersonName User
ProfitCenter I_WBSElementData ProfitCenter Profit Center
ProjectInternalID I_WBSElementData ProjectInternalID Project Def.
_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_TravelWBSElementVH.
-- 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_TravelWBSElementVH AS
SELECT
  cast( WBS.WBSElement as vdm_wbselement ) AS WBSElement,
  WBS.WBSDescription AS WBSDescription,
  WBS.WBSElementShortID AS WBSElementShortID,
  cast ( prps.pspnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  WBS.ResponsiblePerson AS ResponsiblePerson,
  WBS.ApplicantCode AS ApplicantCode,
  WBS.ResponsibleCostCenter AS ResponsibleCostCenter,
  WBS.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  WBS.ProjectType AS ProjectType,
  WBS.ControllingArea AS ControllingArea,
  WBS.ResponsiblePersonName AS ResponsiblePersonName,
  WBS.ProfitCenter AS ProfitCenter,
  WBS.ProjectInternalID AS ProjectInternalID
FROM I_WBSElementData AS WBS
INNER JOIN prps ON /* join condition not captured in parsed metadata */
;

Learn More