R_SourcingProjectItemDraft

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 R_SourcingProjectItemDraft.
-- 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 R_SourcingProjectItemDraft AS
SELECT
  SourcingProjectItemUUID,
  SourcingProjectItem,
  cast( bintohex(sourcingprojectitemuuid) as vdm_srcgprojitmuuidascharacter ) AS SrcgProjItemUUIDAsCharacter,
  cast( concat( bintohex(sourcingprojectitemuuid), '01' ) as vdm_srcgprojitemattachmentuuid ) AS SrcgProjItemAttachmentKey,
  cast( 'SourcingProjectItem' as srcesapobjnodetype ) AS SourceSAPObjectNodeType,
  SourcingProjectUUID,
  SourcingProjectItemType,
  SrcgProjItemClassification,
  SourcingProjectItemStableUUID,
  SrcgProjItemDescription,
  Material,
  ProductType,
  MaterialGroup,
  SrcgProjItemTargetAmount,
  SrcgProjItmTgtAmtQuantity,
  SrcgProjItemTotalTargetAmount,
  RequestedQuantity,
  MaximumRequestedQuantity,
  RequestedQuantityUnit,
  RequestedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  Plant,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  ProcurementHubSourceSystem,
  StorageLocation,
  ProcmtHubPlantUniqueID,
  SourcingProjectItemParent,
  SourcingProjectItemParentUUID,
  HierarchyNodeLevel,
  AlternativeItemID,
  FormattedItemID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  SourceSourcingProjectItemUUID,
  DocumentCurrency,
  SourcingProjectType,
  SrcgProjItemDemandConfCode,
  SrcgProjItemUnconfdDemandRsn,
  ProcmtPlanningBundleItemUUID,
  SourcingOrigin,
  SourcingScenario,
  SrcgProjectItemSettledStatus,
  SrcgProjAttchsAreForbidden,
  RequestedDeliveryDateIsChanged,
  SuplrCostBreakdownTemplateUUID,
  SupplierCostBreakdownIsEnabled,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyRank,
  HierarchyLevel,
  PlantIsChanged,
  SupplierCostBreakdownTemplate,
  SuplrCostBrkdwnTemplateVersion,
  SupCosBrkTmplActiveVersion,
  CostBrkdwnAttchCrtnIsRequired,
  SrcgProjItmTargetAmountIsFixed,
  SrcgProjItmTgtAmtQtyIsFixed,
  SPItmTotTgtAmtHasOverflowError,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  ItemWeightUnit,
  ItemVolumeUnit
FROM mmsrcgpitem_d AS SourcingProjectItemDraft
LEFT OUTER JOIN R_SourcingProjectItemDraft AS _SourcingProjectItemParent ON SourcingProjectItemParentUUID = _SourcingProjectItemParent.SourcingProjectItemUUID  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjItmDraftHierNodeRltn AS _Parent ON SourcingProjectItemParent = _Parent.SourcingProjectItem AND SourcingProjectUUID = _Parent.SourcingProjectUUID  -- association [0..*]
LEFT OUTER JOIN R_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [0..1]
LEFT OUTER JOIN E_SourcingProjectItemD AS _Extension ON SourcingProjectItemUUID = _Extension.SourcingProjectItemUUID  -- association [1..1]
;