FAC_CDS_UH_WBSElement

DDL: FAC_CDS_UH_WBSELEMENT SQL: FACV_UH_WBSELEM Type: view
47 Fields 1 Data Sources

WBS Element Details

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

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData I_WBSElementBasicData from

Annotations (8)

NameValueLevelField
EndUserText.label WBS Element Details view
AbapCatalog.sqlViewName FACV_UH_WBSELEM view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Element Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElement WBSElement WBS Element
WBSElementShortID WBSElementShortID Short 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
FactoryCalendar FactoryCalendar Factory Calendar
CostingSheet CostingSheet Costing Sheet
CostCenter CostCenter Cost Center
ProjectInternalID ProjectInternalID Project Def.
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
WBSElementObject WBSElementObject Object number
InvestmentProfile InvestmentProfile Investment Measure Profile
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
ProjectType ProjectType Project Type
JointVenture JointVenture Joint venture
JointVentureCostRecoveryCode JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityType JointVentureEquityType Joint Venture Equity Type
JntVntrProjectType JntVntrProjectType JV Object Type
JntIntrstBillgClass JntIntrstBillgClass JIB/JIBE Class
JntIntrstBillgSubClass JntIntrstBillgSubClass JIB/JIBE SbClsA
Location Location Text
ResultAnalysisInternalID ResultAnalysisInternalID Results Analysis Key
Fund Fund Sender Fund
GrantID GrantID Sender Grant
FundIsFixAssigned FundIsFixAssigned Fund Fixed Assignment
FunctionalAreaIsFixAssigned FunctionalAreaIsFixAssigned Functional Area Fixed Assignment
GrantIsFixAssigned GrantIsFixAssigned Grant Fixed Assignment
SponsoredProgram SponsoredProgram Sponsored Program
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
FunctionalLocation FunctionalLocation Object ID
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
RespCostCenterControllingArea RespCostCenterControllingArea CA (resp.)
LeadingSalesOrderItem LeadingSalesOrderItem Item
LeadingSalesOrder LeadingSalesOrder Sales Document
EntProjectSettlementElement EntProjectSettlementElement settlementElement
EntProjIsSettlmtRuleInherited EntProjIsSettlmtRuleInherited Sttle Rule Inherited
ResultAnalysisDescription ResultAnalysisDescription

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 FAC_CDS_UH_WBSElement.
-- 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: FACV_UH_WBSELEM

CREATE VIEW FAC_CDS_UH_WBSElement AS
SELECT
  WBSElementInternalID,
  WBSElementExternalID,
  WBSElement,
  WBSElementShortID,
  WBSDescription,
  CompanyCode,
  ControllingArea,
  FunctionalArea,
  ProfitCenter,
  ResponsibleCostCenter,
  Plant,
  FactoryCalendar,
  CostingSheet,
  CostCenter,
  ProjectInternalID,
  WBSElementIsBillingElement,
  WBSElementObject,
  InvestmentProfile,
  WBSIsStatisticalWBSElement,
  WBSIsAccountAssignmentElement,
  ProjectType,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureEquityType,
  JntVntrProjectType,
  JntIntrstBillgClass,
  JntIntrstBillgSubClass,
  Location,
  ResultAnalysisInternalID,
  Fund,
  GrantID,
  FundIsFixAssigned,
  FunctionalAreaIsFixAssigned,
  GrantIsFixAssigned,
  SponsoredProgram,
  TaxJurisdiction,
  FunctionalLocation,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  RespCostCenterControllingArea,
  LeadingSalesOrderItem,
  LeadingSalesOrder,
  EntProjectSettlementElement,
  EntProjIsSettlmtRuleInherited,
  ResultAnalysisDescription
FROM I_WBSElementBasicData
;

Learn More