R_SourcingProjectItemTP

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_SourcingProjectItemTP.
-- 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_SourcingProjectItemTP 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,
  SourcingProjectItemParent,
  SourcingProjectItemParentUUID,
  HierarchyNodeLevel,
  AlternativeItemID,
  FormattedItemID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  DocumentCurrency,
  SourcingProjectType,
  ProcmtHubPlantUniqueID,
  SrcgProjItemDemandConfCode,
  SrcgProjItemUnconfdDemandRsn,
  ProcmtPlanningBundleItemUUID,
  SourcingOrigin,
  SourcingScenario,
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  SourceSourcingProjectItemUUID,
  SrcgProjAttchsAreForbidden,
  SrcgProjectItemSettledStatus,
  SrcgProjItmTargetAmountIsFixed,
  SrcgProjItmTgtAmtQtyIsFixed,
  SPItmTotTgtAmtHasOverflowError,
  ItemWeightUnit,
  ItemVolumeUnit,
  cast( '' as abap.char( 50 ) ) AS HierarchyNode,
  cast( '' as abap.sstring(1333) ) AS HierarchyParentNode,
  cast( 0 as abap.int4 ) AS HierarchyDistanceFromRoot,
  cast( 0 as abap.int4 ) AS HierarchyDescendantCount,
  cast( '' as abap.char(22) ) AS HierarchyDrillState,
  cast( 0 as hum_hierarchy_rank ) AS HierarchyRank,
  cast( 0 as abap.int4 ) AS HierarchyLevel,
  RequestedDeliveryDateIsChanged,
  cast( '' as boolean ) AS PlantIsChanged,
  SupplierCostBreakdownIsEnabled,
  SuplrCostBreakdownTemplateUUID,
  _SuplrCostBreakdownTemplate.SupplierCostBreakdownTemplate AS SupplierCostBreakdownTemplate,
  _SuplrCostBreakdownTemplate.SuplrCostBrkdwnTemplateVersion AS SuplrCostBrkdwnTemplateVersion,
  CostBrkdwnAttchCrtnIsRequired,
  _SuplrCostBreakdownTemplate.SupCosBrkTmplActiveVersion AS SupCosBrkTmplActiveVersion
FROM R_SourcingProjectItem
LEFT OUTER JOIN R_SourcingProjectItemTP AS _SrcgProjItemParentToItemChild ON SourcingProjectItemUUID = _SrcgProjItemParentToItemChild.SourcingProjectItemParentUUID  -- association [0..*]
LEFT OUTER JOIN I_BackendCoCodeForPurg AS _BackendCoCodeForPurg ON ProcurementHubSourceSystem = _BackendCoCodeForPurg.ProcurementHubSourceSystem AND CompanyCode = _BackendCoCodeForPurg.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON RequestedQuantityUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON SrcgProjFollowOnDocumentCat = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_BackendPlantForPurg AS _BackendPlantForPurg ON Plant = _BackendPlantForPurg.Plant AND CompanyCode = _BackendPlantForPurg.CompanyCode AND ProcurementHubSourceSystem = _BackendPlantForPurg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubPurgOrg AS _ProcmtHubPurgOrg ON PurchasingOrganization = _ProcmtHubPurgOrg.ProcmtHubPurchasingOrg AND ProcurementHubSourceSystem = _ProcmtHubPurgOrg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectItemTypeText AS _SourcingProjectItemTypeText ON SourcingProjectItemType = _SourcingProjectItemTypeText.SourcingProjectItemType  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItemClassfctnText AS _SrcgProjItemClassfctnText ON SrcgProjItemClassification = _SrcgProjItemClassfctnText.SrcgProjItemClassification AND SourcingProjectItemType = _SrcgProjItemClassfctnText.SourcingProjectItemType  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON ProductType = _ProductTypeCodeText.ProductTypeCode  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON SrcgProjFollowOnDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND SrcgProjFollowOnDocumentCat = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItemDmndConfCodeText AS _SrcgProjItemDmndConfCodeText ON SrcgProjItemDemandConfCode = _SrcgProjItemDmndConfCodeText.SrcgProjItemDemandConfCode  -- association [0..*]
LEFT OUTER JOIN I_ProductSourcingReasonText AS _SourcingProjectReasonText ON SrcgProjItemUnconfdDemandRsn = _SourcingProjectReasonText.ProductSourcingReason  -- association [0..*]
LEFT OUTER JOIN R_SrcgProjItemQuotationCount AS _SrcgProjItmQuotationCount ON SourcingProjectItemUUID = _SrcgProjItmQuotationCount.SourcingProjectItemUUID  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjItemAwardedDetails AS _SrcgProjItmAwardedDetails ON SourcingProjectItemUUID = _SrcgProjItmAwardedDetails.SourcingProjectItemUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjItmSettledStatusText AS _SrcgProjItmSettledStatusText ON SrcgProjectItemSettledStatus = _SrcgProjItmSettledStatusText.SrcgProjectItemSettledStatus  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingScenarioText AS _SrcgProjSourcingScenarioText ON SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingOriginText AS _SrcgProjSourcingOriginText ON SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin  -- association [0..*]
LEFT OUTER JOIN R_SuplrCostBreakdownTemplate AS _SuplrCostBreakdownTemplate ON SuplrCostBreakdownTemplateUUID = _SuplrCostBreakdownTemplate.SuplrCostBreakdownTemplateUUID  -- association [0..1]
LEFT OUTER JOIN I_NoteBasicTP AS _NoteBasic ON SrcgProjItemUUIDAsCharacter = _NoteBasic.NoteBasicObject AND _NoteBasic.NoteBasicObjectNodeType = 'SourcingProjectItem'  -- association [0..*]
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON _HDMRelation.LinkedSAPObjectKey = SrcgProjItemAttachmentKey AND _HDMRelation.SAPObjectNodeType = SourceSAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN E_SourcingProjectItem AS _Extension ON SourcingProjectItemUUID = _Extension.SourcingProjectItemUUID  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjItmShipgInstrnTP AS _SrcgProjItmShipgInstrn ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItemPaymentTermsTP AS _SrcgProjItemPaymentTerms ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItemIncotermsTP AS _SrcgProjItemIncoterms ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItmDemandDistrTP AS _SrcgProjDemandDistribution ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SourcingProjectItemLinkageTP AS _SourcingProjectItemLinkage ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItmDeliveryAddressTP AS _SrcgProjItmDeliveryAddress ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjItmCndnValidityTP AS _SrcgProjItmCndnValidity ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItmCmmdtyQuantityTP AS _SrcgProjItmCmmdtyQuantity ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SourcingProjectItemNoteTP AS _SourcingProjectItemNote ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjItmProdFootprintTP AS _SrcgProjItmProdFootprint ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SPItmCndnAmountHierarchyTP AS _SPItmCndnAmountHierarchy ON /* condition not available in parsed metadata */  -- association [*]
;