I_FrcElmntToWBSElmntDraft

DDL: I_FRCELMNTTOWBSELMNTDRAFT SQL: IFETOWBSELMTASMT Type: view BASIC
30 Fields 1 Data Sources

Interface View for FE to additional WBS Element Draft

I_FrcElmntToWBSElmntDraft is a Basic CDS View that provides data about "Interface View for FE to additional WBS Element Draft" in SAP S/4HANA. It reads from 1 data source (dfs_fetowbse_d) and exposes 30 fields with key fields FrcElmntOrgDraftUUID, ForceElementOrgID, FrcElmntOrgRelatedOrgID, FrcElmntOrgPlngStatus, FrcElmntOrgValdtyStartDate.

Data Sources (1)

SourceAliasJoin Type
dfs_fetowbse_d FrcElmntToWBSElmntDraft from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFETOWBSELMTASMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Interface View for FE to additional WBS Element Draft view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY FrcElmntOrgDraftUUID dfs_fetowbse_d draftuuid UUID
KEY ForceElementOrgID dfs_fetowbse_d forceelementorgid Object ID Processor
KEY FrcElmntOrgRelatedOrgID dfs_fetowbse_d frcelmntorgrelatedorgid ID rel.object
KEY FrcElmntOrgPlngStatus dfs_fetowbse_d frcelmntorgplngstatus Planning status
KEY FrcElmntOrgValdtyStartDate dfs_fetowbse_d frcelmntorgvaldtystartdate Start date
KEY FrcElmntOrgValdtyEndDate dfs_fetowbse_d frcelmntorgvaldtyenddate End Date
FrcElmntOrgType dfs_fetowbse_d frcelmntorgtype Object type
FrcElmntOrgPlanVersion dfs_fetowbse_d frcelmntorgplanversion Plan version
FrcElmntOrgRelshpSpec dfs_fetowbse_d frcelmntorgrelshpspec Relationship
FrcElmntOrgRelshpBtwnObj dfs_fetowbse_d frcelmntorgrelshpbtwnobj Relnship
FrcElmntOrgRelshpPriority dfs_fetowbse_d frcelmntorgrelshppriority Priority
NumberOfForceElementOrg dfs_fetowbse_d numberofforceelementorg IT record no.
FrcElmntOrgInfoType dfs_fetowbse_d frcelmntorginfotype Infotype
FrcElmntOrgSubType dfs_fetowbse_d frcelmntorgsubtype Subtype
FrcElmntOrgPlngStsCritlty dfs_fetowbse_d frcelmntorgplngstscritlty
FrcElmntOrgRelatedOrgType dfs_fetowbse_d frcelmntorgrelatedorgtype Rel.obj.type
FrcElmntOrgLastChgdByUser dfs_fetowbse_d frcelmntorglastchgdbyuser User Name
FrcElmntOrgValdtyStartDateFoEd dfs_fetowbse_d frcelmntorgvaldtystartdatefoed Start date
FrcElmntOrgValdtyEndDateFoEd dfs_fetowbse_d frcelmntorgvaldtyenddatefoed End Date
WBSElementInternalID dfs_fetowbse_d wbselementinternalid WBS Internal ID
WBSElementExternalID dfs_fetowbse_d wbselementexternalid WBS Element External ID
WBSElement dfs_fetowbse_d wbselement WBS Internal ID
WBSDescription dfs_fetowbse_d wbsdescription WBS Element Name
ProjectProfileCode dfs_fetowbse_d projectprofilecode Project Profile
ProjectInternalID dfs_fetowbse_d projectinternalid Project Def.
ProjectExternalID dfs_fetowbse_d projectexternalid Project def.
Project
ProjectDescription dfs_fetowbse_d projectdescription Project Name
ProjectProfileCodeText dfs_fetowbse_d projectprofilecodetext Description
FrcElmntOrgDrftHasActiveEntity dfs_fetowbse_d hasactiveentity TRUE

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_FrcElmntToWBSElmntDraft.
-- 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: IFETOWBSELMTASMT

CREATE VIEW I_FrcElmntToWBSElmntDraft AS
SELECT
  FrcElmntToWBSElmntDraft.draftuuid AS FrcElmntOrgDraftUUID,
  FrcElmntToWBSElmntDraft.forceelementorgid AS ForceElementOrgID,
  FrcElmntToWBSElmntDraft.frcelmntorgrelatedorgid AS FrcElmntOrgRelatedOrgID,
  FrcElmntToWBSElmntDraft.frcelmntorgplngstatus AS FrcElmntOrgPlngStatus,
  FrcElmntToWBSElmntDraft.frcelmntorgvaldtystartdate AS FrcElmntOrgValdtyStartDate,
  FrcElmntToWBSElmntDraft.frcelmntorgvaldtyenddate AS FrcElmntOrgValdtyEndDate,
  FrcElmntToWBSElmntDraft.frcelmntorgtype AS FrcElmntOrgType,
  FrcElmntToWBSElmntDraft.frcelmntorgplanversion AS FrcElmntOrgPlanVersion,
  FrcElmntToWBSElmntDraft.frcelmntorgrelshpspec AS FrcElmntOrgRelshpSpec,
  FrcElmntToWBSElmntDraft.frcelmntorgrelshpbtwnobj AS FrcElmntOrgRelshpBtwnObj,
  FrcElmntToWBSElmntDraft.frcelmntorgrelshppriority AS FrcElmntOrgRelshpPriority,
  FrcElmntToWBSElmntDraft.numberofforceelementorg AS NumberOfForceElementOrg,
  FrcElmntToWBSElmntDraft.frcelmntorginfotype AS FrcElmntOrgInfoType,
  FrcElmntToWBSElmntDraft.frcelmntorgsubtype AS FrcElmntOrgSubType,
  FrcElmntToWBSElmntDraft.frcelmntorgplngstscritlty AS FrcElmntOrgPlngStsCritlty,
  FrcElmntToWBSElmntDraft.frcelmntorgrelatedorgtype AS FrcElmntOrgRelatedOrgType,
  FrcElmntToWBSElmntDraft.frcelmntorglastchgdbyuser AS FrcElmntOrgLastChgdByUser,
  FrcElmntToWBSElmntDraft.frcelmntorgvaldtystartdatefoed AS FrcElmntOrgValdtyStartDateFoEd,
  FrcElmntToWBSElmntDraft.frcelmntorgvaldtyenddatefoed AS FrcElmntOrgValdtyEndDateFoEd,
  FrcElmntToWBSElmntDraft.wbselementinternalid AS WBSElementInternalID,
  FrcElmntToWBSElmntDraft.wbselementexternalid AS WBSElementExternalID,
  FrcElmntToWBSElmntDraft.wbselement AS WBSElement,
  FrcElmntToWBSElmntDraft.wbsdescription AS WBSDescription,
  FrcElmntToWBSElmntDraft.projectprofilecode AS ProjectProfileCode,
  FrcElmntToWBSElmntDraft.projectinternalid AS ProjectInternalID,
  FrcElmntToWBSElmntDraft.projectexternalid AS ProjectExternalID,
  cast ( FrcElmntToWBSElmntDraft.project as ps_pspid_edit preserving type ) AS Project,
  FrcElmntToWBSElmntDraft.projectdescription AS ProjectDescription,
  FrcElmntToWBSElmntDraft.projectprofilecodetext AS ProjectProfileCodeText,
  FrcElmntToWBSElmntDraft.hasactiveentity AS FrcElmntOrgDrftHasActiveEntity
FROM dfs_fetowbse_d AS FrcElmntToWBSElmntDraft
;

Learn More