R_SrcgProjQtnItemTP

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_SrcgProjQtnItemTP.
-- 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_SrcgProjQtnItemTP AS
SELECT
  SrcgProjQtnItemUUID,
  SourcingProjectQuotationUUID,
  SourcingProjectQuotationItem,
  SourcingProjectQuotation,
  SrcgProjQuotationVersion,
  SrcgProjQuotationItemType,
  SrcgProjQtnItemClassification,
  SourcingProjectItemStableUUID,
  SrcgProjQtnItemDescription,
  SourcingProjectItemUUID,
  Plant,
  Material,
  ProductType,
  MaterialGroup,
  NetPriceAmount,
  NetPriceQuantity,
  SrcgProjQtnItemTotNetAmt,
  SPQtnItemPriceMeasure1Amount,
  SPQtnItemPriceMeasure1Quantity,
  SPQtnItemPriceMeasure2Amount,
  SPQtnItemPriceMeasure2Quantity,
  SPQtnItemPriceMeasure3Amount,
  SPQtnItemPriceMeasure3Quantity,
  RequestedQuantity,
  SrcgProjQtnOfferedQuantity,
  RequestedQuantityUnit,
  RequestedDeliveryDate,
  ProposedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderPriceUnit,
  OrderPriceUnitToOrderUnitNmrtr,
  OrdPriceUnitToOrderUnitDnmntr,
  SrcgProjQuotationItemParent,
  HierarchyNodeLevel,
  AlternativeItemID,
  FormattedItemID,
  HierarchyNodeSubTreeSize,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  ProcurementHubSourceSystem,
  SrcgProjQtnOfferCurrency,
  SrcgProjQtnItemOfferingCode,
  SrcgProjNegttnQtanItemUUID,
  SrcgProjNegttnItmInclusionType,
  ProcmtHubPlantUniqueID,
  SrcgProjQtnItemExcludingRsn,
  SrcgProjQtnItemSuitability,
  SrcgProjQtnItemPricingOrigin,
  SrcgProjItemProdFprntIsReqd,
  SPQtnItemProdFprntCollCode,
  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,
  SupplierCostBreakdownIsEnabled
FROM R_SrcgProjQtnItem
LEFT OUTER JOIN I_SrcgProjItemClassfctnText AS _SrcgProjItemClassfctnText ON SrcgProjQuotationItemType = _SrcgProjItemClassfctnText.SourcingProjectItemType AND SrcgProjQtnItemClassification = _SrcgProjItemClassfctnText.SrcgProjItemClassification  -- association [0..*]
LEFT OUTER JOIN I_BackendPlantForPurg AS _Plant ON _Plant.Plant = Plant AND _Plant.CompanyCode = CompanyCode AND _Plant.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_BackendCoCodeForPurg AS _ProcmtHubCompanyCode ON CompanyCode = _ProcmtHubCompanyCode.CompanyCode AND ProcurementHubSourceSystem = _ProcmtHubCompanyCode.ProcurementHubSourceSystem  -- association [0..1]
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_SourcingProjectItemTypeText AS _SourcingProjectItemTypeText ON SrcgProjQuotationItemType = _SourcingProjectItemTypeText.SourcingProjectItemType  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON ProductType = _ProductTypeCodeText.ProductTypeCode  -- association [0..*]
LEFT OUTER JOIN R_SrcgProjNegttnQtanItemTP AS _SourceNegotiationItem ON SrcgProjQtnItemUUID = _SourceNegotiationItem.SrcgProjQtnItemUUID  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjNegttnQtanItemTP AS _NegotiationItem ON SrcgProjNegttnQtanItemUUID = _NegotiationItem.SrcgProjNegttnQtanItemUUID  -- association [0..1]
LEFT OUTER JOIN I_ProductSourcingReasonText AS _SourcingProjectReasonText ON SrcgProjQtnItemExcludingRsn = _SourcingProjectReasonText.ProductSourcingReason  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjQtnSuitabilityTxt AS _SrcgProjQtnSuitabilityTxt ON SrcgProjQtnItemSuitability = _SrcgProjQtnSuitabilityTxt.SrcgProjQtnSuitability  -- association [0..*]
LEFT OUTER JOIN I_SPNegttnQtnItemInclsnText AS _SPNegttnQtnItemInclsnText ON SrcgProjNegttnItmInclusionType = _SPNegttnQtnItemInclsnText.SrcgProjNegttnItmInclusionType  -- association [0..*]
LEFT OUTER JOIN R_SrcgProjItmDeliveryAddressTP AS _SrcgProjItmDeliveryAddress ON SourcingProjectItemUUID = _SrcgProjItmDeliveryAddress.SourcingProjectItemUUID  -- association [0..1]
LEFT OUTER JOIN I_SPQtnItmProdFprntCollCodeTxt AS _SPQtnItmProdFprntCollCodeTxt ON SPQtnItemProdFprntCollCode = _SPQtnItmProdFprntCollCodeTxt.SPQtnItemProdFprntCollCode  -- association [0..*]
LEFT OUTER JOIN E_SrcgProjQtnItem AS _Extension ON SrcgProjQtnItemUUID = _Extension.SrcgProjQtnItemUUID  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjQtnItmCndnValidityTP AS _SrcgProjQtnItmCndnValidity ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItmDmndDistrTP AS _SrcgProjQtnDmndDistr ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItmPaymentTermsTP AS _SrcgProjQtnItemPaymentTerms ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItemIncotermsTP AS _SrcgProjQtnItemIncoterms ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItmShipgInstrnTP AS _SrcgProjQtnItemShipgInstrn ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItemLinkageTP AS _SrcgProjQtnItemLinkage ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItmCmmdtyQtyTP AS _SrcgProjQtnItmCmmdtyQty ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SrcgProjQtnItemProdFprntTP AS _SrcgProjQtnItemProdFprnt ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_SPQtnItemAllwdProdFprntTP AS _SPQtnItemAllwdProdFprnt ON /* condition not available in parsed metadata */  -- association [*]
;