C_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 C_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 C_SourcingProjectItemTP AS
SELECT
  SourcingProjectItemUUID,
  SourcingProjectItem,
  SourcingProjectUUID,
  SourcingProjectItemType,
  _SourcingProjectItemTypeText.SourcingProjectItemTypeName : localized AS SourcingProjectItemTypeNamelocalized,
  SrcgProjItemClassification,
  _SrcgProjItemClassfctnText.SrcgProjItemClassificationName : localized AS SrcgProjItemClassificationNamelocalized,
  SourcingProjectItemStableUUID,
  _SourcingProject.SourcingProject AS SourcingProject,
  _SourcingProject.SrcgProjLifecycleStatus AS SrcgProjLifecycleStatus,
  _SourcingProject.SourcingProjectName AS SourcingProjectName,
  SourcingProjectType,
  _SourcingProject._SourcingProjectTypeText.SourcingProjectTypeText : localized AS SourcingProjectTypeTextlocalized,
  SrcgProjItemDescription,
  Material,
  _MaterialText.MaterialName : localized AS MaterialNamelocalized,
  ProductType,
  _ProductTypeCodeText.Name as ProductTypeName : localized AS NameasProductTypeNamelocalized,
  MaterialGroup,
  SrcgProjItemTargetAmount,
  SrcgProjItmTgtAmtQuantity,
  SrcgProjItemTotalTargetAmount,
  RequestedQuantity,
  MaximumRequestedQuantity,
  RequestedQuantityUnit,
  _UnitOfMeasureText.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  ItemWeightUnit,
  ItemVolumeUnit,
  RequestedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  Plant,
  _BackendPlantForPurg.PlantName AS PlantName,
  CompanyCode,
  _BackendCoCodeForPurg.CompanyCodeName AS CompanyCodeName,
  PurchasingGroup,
  PurchasingOrganization,
  cast( _ProcmtHubPurgOrg.ProcmtHubPurgOrgName as BT_ProcmtHubPurgOrgName preserving type ) AS ProcmtHubPurgOrgName,
  ProcurementHubSourceSystem,
  cast( _BackendCoCodeForPurg.ProcurementHubSourceSystemName as vdm_source_system_name preserving type ) AS ProcurementHubSourceSystemName,
  StorageLocation,
  ProcmtHubPlantUniqueID,
  SourcingProjectItemParent,
  ProcmtPlanningBundleItemUUID,
  SourcingOrigin,
  _SrcgProjSourcingOriginText.SrcgProjSourcingOriginText : localized AS SrcgProjSourcingOriginTextlocalized,
  SourcingScenario,
  _SrcgProjSourcingScenarioText.SrcgProjSourcingScenarioText : localized AS SrcgProjSourcingScenarioTextlocalized,
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  _SrcgProjItemClassification.SourcingProjectItemIconURI AS SourcingProjectItemIconURI,
  AlternativeItemID,
  FormattedItemID,
  HierarchyNodeLevel,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyRank,
  HierarchyLevel,
  SrcgProjAttchsAreForbidden,
  _SrcgProjItmQuotationCount.NumberOfAwardedQuotations AS NumberOfAwardedQuotations,
  _SrcgProjItmQuotationCount.NumberOfSubmittedQuotations AS NumberOfSubmittedQuotations,
  _SrcgProjItmQuotationCount.SrcgProjTotalNumberOfQuotation AS SrcgProjTotalNumberOfQuotation,
  _SrcgProjItmAwardedDetails.SrcgProjItmRemainingQuantity AS SrcgProjItmRemainingQuantity,
  _SrcgProjItmAwardedDetails.SrcgProjQtnOfferedQuantity AS SrcgProjQtnOfferedQuantity,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SrcgProjItemUnconfdDemandRsn,
  _SrcgProjItemDmndConfCodeText.SrcgProjItemDemandConfCodeName : localized AS SrcgProjItemDemandConfCodeNamelocalized,
  SrcgProjItemDemandConfCode,
  SupplierCostBreakdownIsEnabled,
  SuplrCostBreakdownTemplateUUID,
  SupplierCostBreakdownTemplate,
  SuplrCostBrkdwnTemplateVersion,
  SupCosBrkTmplActiveVersion,
  SrcgProjFollowOnDocumentCat,
  _PurgDocumentCategoryText.PurchasingDocumentCategoryName : localized AS PurchasingDocumentCategoryNamelocalized,
  SrcgProjFollowOnDocumentType,
  _PurchasingDocumentTypeText.PurchasingDocumentTypeName : localized AS PurchasingDocumentTypeNamelocalized,
  DocumentCurrency,
  SrcgProjectItemSettledStatus,
  _SrcgProjItmSettledStatusText.SrcgProjItemSettledStatusName : localized AS SrcgProjItemSettledStatusNamelocalized,
  SPItmTotTgtAmtHasOverflowError,
  _SourcingProject.SourcingProjectIsTemplate AS SourcingProjectIsTemplate,
  virtual UICT_ItemIsNotGeneralItem : abap.char( 1 ) AS char1,
  virtual NoteTypeListText : abap.char( 450 ) AS char450,
  virtual DeliveryDateIsHidden : abap_boolean AS virtualDeliveryDateIsHiddenabap_boolean,
  virtual NumberOfNotes : vdm_numberofnotes AS virtualNumberOfNotesvdm_numberofnotes,
  virtual UICT_CBDIsDisabled : abap_boolean AS virtualUICT_CBDIsDisabledabap_boolean,
  virtual UICT_CBDIsSwitchedOn : abap_boolean AS virtualUICT_CBDIsSwitchedOnabap_boolean,
  virtual UICT_CBDIsSwitchedOff : abap_boolean AS virtualUICT_CBDIsSwitchedOffabap_boolean,
  _SourceSourcingProjectItem._SourcingProject.SourcingProject AS SourceSourcingProject,
  _SourceSourcingProjectItem.SourcingProjectItem AS SourceSourcingProjectItem,
  _SourceSourcingProjectItem.FormattedItemID AS SourceFormattedItem
FROM R_SourcingProjectItemTP
LEFT OUTER JOIN C_SrcgProjDmndDistrSummary AS _SrcgProjDmndDistrSummary ON SourcingProjectItemUUID = _SrcgProjDmndDistrSummary.SourcingProjectItemUUID  -- association [1..*]
;