I_WBSElementByInternalKey

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_WBSElementByInternalKey.
-- 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: IWBSELEBYINTKEY

CREATE VIEW I_WBSElementByInternalKey AS
SELECT
  I_WBSElement.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElement.WBSElementWithCodingMask AS WBSElementExternalID,
  I_WBSElement.ProjectInternalID AS ProjectInternalID,
  I_WBSElement.WBSElement AS WBSElement,
  I_WBSElement.WBSDescription AS WBSDescription,
  I_WBSElement.WBSElementObject AS WBSElementObject,
  I_WBSElement.CreatedByUser AS CreatedByUser,
  I_WBSElement.CreationDate AS CreationDate,
  I_WBSElement.LastChangedByUser AS LastChangedByUser,
  I_WBSElement.LastChangeDate AS LastChangeDate,
  I_WBSElement.ResponsiblePerson AS ResponsiblePerson,
  I_WBSElement.ResponsiblePersonName AS ResponsiblePersonName,
  I_WBSElement.ApplicantCode AS ApplicantCode,
  I_WBSElement.ApplicantName AS ApplicantName,
  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.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  I_WBSElement.WBSIsAccountAssignmentElement AS WBSIsAccountAssignmentElement,
  I_WBSElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  I_WBSElement.CostingSheet AS CostingSheet,
  I_WBSElement.RequestingCostCenter AS RequestingCostCenter,
  I_WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  I_WBSElement.FactoryCalendar AS FactoryCalendar,
  I_WBSElement.PriorityCode AS PriorityCode,
  I_WBSElement.Currency AS Currency,
  I_WBSElement.Plant AS Plant,
  I_WBSElement.FreeDefinedTableFieldSemantic AS FreeDefinedTableFieldSemantic,
  I_WBSElement.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  I_WBSElement.TaxJurisdiction AS TaxJurisdiction,
  I_WBSElement.WBSIsMarkedForIntegratedPlng AS WBSIsMarkedForIntegratedPlng,
  I_WBSElement.FunctionalArea AS FunctionalArea,
  I_WBSElement.Location AS Location,
  I_WBSElement.Equipment AS Equipment,
  I_WBSElement.FunctionalLocation AS FunctionalLocation,
  I_WBSElement.ProjectObjectChangeNumber AS ProjectObjectChangeNumber,
  I_WBSElement.ProjectObjectReferenceElement AS ProjectObjectReferenceElement,
  I_WBSElement.ProjInterestCalcProfile AS ProjInterestCalcProfile,
  I_WBSElement.InvestmentProfile AS InvestmentProfile,
  I_WBSElement.BasicStartDate AS BasicStartDate,
  I_WBSElement.ActualStartDate AS ActualStartDate,
  I_WBSElement.BasicEndDate AS BasicEndDate,
  I_WBSElement.ActualEndDate AS ActualEndDate,
  I_WBSElement.ActualDurationUnit AS ActualDurationUnit,
  I_WBSElement.BasicDurationUnit AS BasicDurationUnit,
  I_WBSElement.BasicDuration AS BasicDuration,
  I_WBSElement.ActualDuration AS ActualDuration,
  I_WBSElement.SchedldBasicEarliestStartDate AS SchedldBasicEarliestStartDate,
  I_WBSElement.ScheduledBasicLatestEndDate AS ScheduledBasicLatestEndDate,
  I_WBSElement.SchedldFcstdEarliestStartDate AS SchedldFcstdEarliestStartDate,
  I_WBSElement.LatestSchedldFcstdEndDate AS LatestSchedldFcstdEndDate,
  I_WBSElement.TentativeActualStartDate AS TentativeActualStartDate,
  I_WBSElement.TentativeActualEndDate AS TentativeActualEndDate,
  I_WBSElement.SchedldBasicLatestStartDate AS SchedldBasicLatestStartDate,
  I_WBSElement.SchedldBasicEarliestEndDate AS SchedldBasicEarliestEndDate,
  I_WBSElement.LatestSchedldFcstdStartDate AS LatestSchedldFcstdStartDate,
  I_WBSElement.SchedldFcstdEarliestEndDate AS SchedldFcstdEarliestEndDate,
  I_WBSElement.WBSElementHierarchyLevel AS WBSElementHierarchyLevel,
  I_WBSElement.OverheadCode AS OverheadCode,
  I_WBSElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  I_WBSElement.ProgressAnlysAggregationWeight AS ProgressAnlysAggregationWeight,
  I_WBSElement.WBSElementShortID AS WBSElementShortID,
  I_WBSElement.ReqgCostCenterControllingArea AS ReqgCostCenterControllingArea,
  I_WBSElement.RespCostCenterControllingArea AS RespCostCenterControllingArea,
  I_WBSElement.Language AS Language,
  I_WBSElement.CostCenter AS CostCenter,
  I_WBSElement.CostObject AS CostObject,
  I_WBSElement.WBSElementIsUsedInProjSmmry AS WBSElementIsUsedInProjSmmry,
  I_WBSElement.IsMarkedForDeletion AS IsMarkedForDeletion,
  I_WBSElement.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  I_WBSElement.BillingPlan AS BillingPlan,
  I_WBSElement.WBSElementIsGroupingWBSElement AS WBSElementIsGroupingWBSElement,
  I_WBSElement.CostingVariant AS CostingVariant,
  I_WBSElement.JointVenture AS JointVenture,
  I_WBSElement.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_WBSElement.JointVentureEquityType AS JointVentureEquityType,
  I_WBSElement.JointVentureObjectType AS JointVentureObjectType,
  I_WBSElement.JointVentureClass AS JointVentureClass,
  I_WBSElement.JointVentureSubClass AS JointVentureSubClass,
  I_WBSElement.WBSElementHasActivities AS WBSElementHasActivities,
  I_WBSElement.WBSHasFcstdDateFromActivity AS WBSHasFcstdDateFromActivity,
  I_WBSElement.WBSHasFcstdDateSetManually AS WBSHasFcstdDateSetManually,
  I_WBSElement.WBSHasBasicDateManuallySet AS WBSHasBasicDateManuallySet,
  I_WBSElement.WBSHasActualDateSetManually AS WBSHasActualDateSetManually,
  I_WBSElement.WBSElmntHasActualDateFromActy AS WBSElmntHasActualDateFromActy,
  I_WBSElement.ControllingObjectClass AS ControllingObjectClass,
  I_WBSElement.FreeDefinedAttribute01 AS FreeDefinedAttribute01,
  I_WBSElement.FreeDefinedAttribute02 AS FreeDefinedAttribute02,
  I_WBSElement.FreeDefinedAttribute03 AS FreeDefinedAttribute03,
  I_WBSElement.FreeDefinedAttribute04 AS FreeDefinedAttribute04,
  I_WBSElement.FreeDefinedQuantity1 AS FreeDefinedQuantity1,
  I_WBSElement.FreeDefinedQuantity1Unit AS FreeDefinedQuantity1Unit,
  I_WBSElement.FreeDefinedQuantity2 AS FreeDefinedQuantity2,
  I_WBSElement.FreeDefinedQuantity2Unit AS FreeDefinedQuantity2Unit,
  I_WBSElement.FreeDefinedAmount1 AS FreeDefinedAmount1,
  I_WBSElement.FreeDefinedAmount1Currency AS FreeDefinedAmount1Currency,
  I_WBSElement.FreeDefinedAmount2 AS FreeDefinedAmount2,
  I_WBSElement.FreeDefinedAmount2Currency AS FreeDefinedAmount2Currency,
  I_WBSElement.FreeDefinedDate1 AS FreeDefinedDate1,
  I_WBSElement.FreeDefinedDate2 AS FreeDefinedDate2,
  I_WBSElement.FreeDefinedIndicator1 AS FreeDefinedIndicator1,
  I_WBSElement.FreeDefinedIndicator2 AS FreeDefinedIndicator2,
  I_WBSElement.ObjBasedAuthorizationIsActive AS ObjBasedAuthorizationIsActive,
  I_WBSElement._ActualDurationUnit AS _ActualDurationUnit,
  I_WBSElement._BasicDurationUnit AS _BasicDurationUnit,
  I_WBSElement._BusinessArea AS _BusinessArea,
  I_WBSElement._CompanyCode AS _CompanyCode,
  I_WBSElement._ControllingArea AS _ControllingArea,
  I_WBSElement._ControllingObjectClass AS _ControllingObjectClass,
  I_WBSElement._CostCenter AS _CostCenter,
  I_WBSElement._Equipment AS _Equipment,
  I_WBSElement._FactoryCalendar AS _FactoryCalendar,
  I_WBSElement._FunctionalArea AS _FunctionalArea,
  I_WBSElement._FunctionalLocation AS _FunctionalLocation,
  I_WBSElement._Interestcalculationprofile AS _Interestcalculationprofile,
  I_WBSElement._Location AS _Location,
  I_WBSElement._Plant AS _Plant,
  I_WBSElement._PriorityCode AS _PriorityCode,
  I_WBSElement._ProfitCenter AS _ProfitCenter,
  I_WBSElement._Project AS _Project,
  I_WBSElement._ProjectType AS _ProjectType,
  I_WBSElement._TaxJurisdiction AS _TaxJurisdiction,
  I_WBSElement._ResponsiblePerson AS _ResponsiblePerson,
  I_WBSElement._ProjectApplicant AS _ProjectApplicant,
  I_WBSElement._WBSElementShortText AS _WBSElementShortText
FROM I_WBSElement
;