C_ReExAssignWBS

DDL: C_REEXASSIGNWBS SQL: CREEXASSIGNWBS Type: view CONSUMPTION
35 Fields 1 Data Sources

WBS Element

C_ReExAssignWBS is a Consumption CDS View that provides data about "WBS Element" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 35 fields with key field WBSElement.

Data Sources (1)

SourceAliasJoin Type
I_WBSElement I_WBSElement from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CREEXASSIGNWBS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label WBS Element view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElement WBSElement WBS Internal ID
WBSElementInternalID I_WBSElement WBSElementInternalID WBS Internal ID
ProjectInternalID I_WBSElement ProjectInternalID Project Def.
Project I_WBSElement Project WBS Element
WBSDescription I_WBSElement WBSDescription WBS Element Name
WBSElementObject I_WBSElement WBSElementObject Object number
CompanyCode I_WBSElement CompanyCode Receiver Company Code
BusinessArea I_WBSElement BusinessArea Business Area
ControllingArea I_WBSElement ControllingArea Controlling Area
ProfitCenter I_WBSElement ProfitCenter Profit Center
ProjectType I_WBSElement ProjectType Project Type
RequestingCostCenter I_WBSElement RequestingCostCenter Req.cost center
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter Responsible Cost Center
Currency I_WBSElement Currency Valuation Crcy
Plant I_WBSElement Plant Valuation Area
FunctionalArea I_WBSElement FunctionalArea Sendr Fctl Area
Location I_WBSElement Location Text
Equipment I_WBSElement Equipment Equipment check
FunctionalLocation I_WBSElement FunctionalLocation Object ID
BasicStartDate I_WBSElement BasicStartDate
ActualStartDate I_WBSElement ActualStartDate Actual Start
BasicEndDate I_WBSElement BasicEndDate
ActualEndDate I_WBSElement ActualEndDate Actual Finish
ActualDurationUnit
BasicDurationUnit
BasicDuration
ActualDuration
WBSElementShortID I_WBSElement WBSElementShortID Short ID
ReqgCostCenterControllingArea I_WBSElement ReqgCostCenterControllingArea CA (requesting)
RespCostCenterControllingArea I_WBSElement RespCostCenterControllingArea CA (resp.)
Language I_WBSElement Language Report Text Language
CostCenter
CostObject I_WBSElement CostObject Cost Object
ResponsiblePersonIsBlocked _ResponsiblePerson ResponsiblePersonIsBlocked
_EntProjectResponsiblePerson _EntProjectResponsiblePerson

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_ReExAssignWBS.
-- 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: CREEXASSIGNWBS

CREATE VIEW C_ReExAssignWBS AS
SELECT
  I_WBSElement.WBSElement AS WBSElement,
  I_WBSElement.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElement.ProjectInternalID AS ProjectInternalID,
  I_WBSElement.Project AS Project,
  I_WBSElement.WBSDescription AS WBSDescription,
  I_WBSElement.WBSElementObject AS WBSElementObject,
  I_WBSElement.CompanyCode AS CompanyCode,
  I_WBSElement.BusinessArea AS BusinessArea,
  I_WBSElement.ControllingArea AS ControllingArea,
  I_WBSElement.ProfitCenter AS ProfitCenter,
  I_WBSElement.ProjectType AS ProjectType,
  I_WBSElement.RequestingCostCenter AS RequestingCostCenter,
  I_WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_WBSElement.Currency AS Currency,
  I_WBSElement.Plant AS Plant,
  I_WBSElement.FunctionalArea AS FunctionalArea,
  I_WBSElement.Location AS Location,
  I_WBSElement.Equipment AS Equipment,
  I_WBSElement.FunctionalLocation AS FunctionalLocation,
  I_WBSElement.BasicStartDate AS BasicStartDate,
  I_WBSElement.ActualStartDate AS ActualStartDate,
  I_WBSElement.BasicEndDate AS BasicEndDate,
  I_WBSElement.ActualEndDate AS ActualEndDate,
  cast ( I_WBSElement.ActualDurationUnit as ps_ieinh preserving type ) AS ActualDurationUnit,
  cast ( I_WBSElement.BasicDurationUnit as ps_s4_peinh preserving type ) AS BasicDurationUnit,
  cast ( I_WBSElement.BasicDuration as ps_s4_pdaur preserving type ) AS BasicDuration,
  cast ( I_WBSElement.ActualDuration as ps_s4_idaur preserving type ) AS ActualDuration,
  I_WBSElement.WBSElementShortID AS WBSElementShortID,
  I_WBSElement.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_WBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  I_WBSElement.Language AS Language,
  cast ( I_WBSElement.CostCenter as ps_kostl preserving type ) AS CostCenter,
  I_WBSElement.CostObject AS CostObject,
  _ResponsiblePerson.ResponsiblePersonIsBlocked AS ResponsiblePersonIsBlocked
FROM I_WBSElement
;

Learn More