P_SrcgProjQtnItem

DDL: P_SRCGPROJQTNITEM Type: view BASIC
57 Fields 4 Data Sources 1 Associations

P_SrcgProjQtnItem is a Basic CDS View in SAP S/4HANA. It reads from 4 data sources (mmsrcgpqtnitem, mmsrcgpqtnitem, P_SPQTN_ITM_SDM_PHASE_AMDP_TF, P_SPQTN_ITM_SDM_PHASE_AMDP_TF) and exposes 57 fields. It has 1 association to related views.

Data Sources (4)

SourceAliasJoin Type
mmsrcgpqtnitem db_item union_all
mmsrcgpqtnitem Item from
P_SPQTN_ITM_SDM_PHASE_AMDP_TF TF inner
P_SPQTN_ITM_SDM_PHASE_AMDP_TF TF inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SourcingProjectQuotation _SourcingProjectQuotation $projection.sourcingprojectquotationuuid = _SourcingProjectQuotation.SourcingProjectQuotationUUID

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName PSPQTNITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (57)

KeyFieldSource TableSource FieldDescription
plant mmsrcgpqtnitem plant Valuation Area
material mmsrcgpqtnitem material Vehicle Model
producttype mmsrcgpqtnitem producttype Product Type Group
companycode mmsrcgpqtnitem companycode Receiver Company Code
SourcingProjectQuotation _SourcingProjectQuotation SourcingProjectQuotation Supplier Quotation
SrcgProjQuotationVersion _SourcingProjectQuotation SrcgProjQuotationVersion Version
srcgprojqtnitemuuidasSrcgProjQtnItemUUID
SourcingProjectQuotationUUID mmsrcgpqtnitem sourcingprojectquotationuuid Supplier Quotation UUID
SourcingProjectQuotationItem mmsrcgpqtnitem sourcingprojectquotationitem Item
SrcgProjQuotationItemType mmsrcgpqtnitem srcgprojquotationitemtype Item Type
SrcgProjQtnItemClassification mmsrcgpqtnitem srcgprojqtnitemclassification Item Classification
SourcingProjectItemStableUUID mmsrcgpqtnitem sourcingprojectitemstableuuid Stable ID
SrcgProjQtnItemDescription mmsrcgpqtnitem srcgprojqtnitemdescription Description
SourcingProjectItemUUID mmsrcgpqtnitem sourcingprojectitemuuid Item UUID
Plant mmsrcgpqtnitem plant Valuation Area
Material mmsrcgpqtnitem material Vehicle Model
ProductType mmsrcgpqtnitem producttype Product Type Group
MaterialGroup mmsrcgpqtnitem materialgroup Product Group
NetPriceAmount mmsrcgpqtnitem netpriceamount Net Price
NetPriceQuantity mmsrcgpqtnitem netpricequantity Price Unit
SrcgProjQtnItemTotNetAmt mmsrcgpqtnitem srcgprojqtnitemtotnetamt Total Amount
SPQtnItemPriceMeasure1Amount mmsrcgpqtnitem spqtnitempricemeasure1amount Price Measure 1
SPQtnItemPriceMeasure1Quantity mmsrcgpqtnitem spqtnitempricemeasure1quantity Price Unit for Price Measure 1
SPQtnItemPriceMeasure2Amount mmsrcgpqtnitem spqtnitempricemeasure2amount Price Measure 2
SPQtnItemPriceMeasure2Quantity mmsrcgpqtnitem spqtnitempricemeasure2quantity Price Unit for Price Measure 2
SPQtnItemPriceMeasure3Amount mmsrcgpqtnitem spqtnitempricemeasure3amount Price Measure 3
SPQtnItemPriceMeasure3Quantity mmsrcgpqtnitem spqtnitempricemeasure3quantity Price Unit for Price Measure 3
RequestedQuantity mmsrcgpqtnitem requestedquantity Requested Quantity
SrcgProjQtnOfferedQuantity mmsrcgpqtnitem srcgprojqtnofferedquantity Offered Quantity
RequestedQuantityUnit mmsrcgpqtnitem requestedquantityunit Requested Quantity Unit
RequestedDeliveryDate mmsrcgpqtnitem requesteddeliverydate Requested Delivery Date
ProposedDeliveryDate mmsrcgpqtnitem proposeddeliverydate Proposed Delivery Date
PerformancePeriodStartDate mmsrcgpqtnitem performanceperiodstartdate Start of Performance Period
PerformancePeriodEndDate mmsrcgpqtnitem performanceperiodenddate End of Performance Period
OrderPriceUnit mmsrcgpqtnitem orderpriceunit Order Price Un.
OrderPriceUnitToOrderUnitNmrtr mmsrcgpqtnitem orderpriceunittoorderunitnmrtr Quantity Conversion Numerator
OrdPriceUnitToOrderUnitDnmntr mmsrcgpqtnitem ordpriceunittoorderunitdnmntr Quantity Conversion Denominator
SrcgProjQuotationItemParent mmsrcgpqtnitem srcgprojquotationitemparent Item Parent
HierarchyNodeLevel mmsrcgpqtnitem hierarchynodelevel Hierarchy Node Level
AlternativeItemID mmsrcgpqtnitem alternativeitemid Alternative Item ID
FormattedItemID mmsrcgpqtnitem formatteditemid Item Number
HierarchyNodeSubTreeSize mmsrcgpqtnitem hierarchynodesubtreesize Descendant Count
CompanyCode mmsrcgpqtnitem companycode Receiver Company Code
PurchasingGroup mmsrcgpqtnitem purchasinggroup Purchasing Group
PurchasingOrganization mmsrcgpqtnitem purchasingorganization Purchasing Organization
ProcurementHubSourceSystem mmsrcgpqtnitem procurementhubsourcesystem Connected System ID
ProcmtHubPlantUniqueID mmsrcgpqtnitem procmthubplantuniqueid Plant Unique ID
SrcgProjQtnItemExcludingRsn mmsrcgpqtnitem srcgprojqtnitemexcludingrsn Reason
SrcgProjQtnItemSuitability mmsrcgpqtnitem srcgprojqtnitemsuitability Suitability
SrcgProjQtnItemPricingOrigin mmsrcgpqtnitem srcgprojqtnitempricingorigin Item Pricing Origin
SourcingProjectQuotation mmsrcgpqtnitem sourcingprojectquotation Supplier Quotation
SrcgProjQuotationVersion mmsrcgpqtnitem srcgprojquotationversion Version
SrcgProjQtnItemOfferingCode mmsrcgpqtnitem srcgprojqtnitemofferingcode Item Offering Code
SrcgProjNegttnQtanItemUUID mmsrcgpqtnitem srcgprojnegttnqtanitemuuid UUID of Quotation Item in Negotiation
SrcgProjNegttnItmInclusionType mmsrcgpqtnitem srcgprojnegttnitminclusiontype Negotiation Item Include Type Code
SrcgProjItemProdFprntIsReqd mmsrcgpqtnitem srcgprojitemprodfprntisreqd Request Product Footprint Data
SPQtnItemProdFprntCollCode mmsrcgpqtnitem spqtnitemprodfprntcollcode Item Product Footprint Collection Code

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 P_SrcgProjQtnItem.
-- 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 P_SrcgProjQtnItem AS
SELECT
  Item.plant AS plant,
  Item.material AS material,
  Item.producttype AS producttype,
  Item.companycode AS companycode,
  _SourcingProjectQuotation.SourcingProjectQuotation AS SourcingProjectQuotation,
  _SourcingProjectQuotation.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
  Item.spqtnitemprodfprntcollcode AS srcgprojqtnitemuuidasSrcgProjQtnItemUUID,
  db_item.sourcingprojectquotationuuid AS SourcingProjectQuotationUUID,
  db_item.sourcingprojectquotationitem AS SourcingProjectQuotationItem,
  db_item.srcgprojquotationitemtype AS SrcgProjQuotationItemType,
  db_item.srcgprojqtnitemclassification AS SrcgProjQtnItemClassification,
  db_item.sourcingprojectitemstableuuid AS SourcingProjectItemStableUUID,
  db_item.srcgprojqtnitemdescription AS SrcgProjQtnItemDescription,
  db_item.sourcingprojectitemuuid AS SourcingProjectItemUUID,
  db_item.materialgroup AS MaterialGroup,
  db_item.netpriceamount AS NetPriceAmount,
  db_item.netpricequantity AS NetPriceQuantity,
  db_item.srcgprojqtnitemtotnetamt AS SrcgProjQtnItemTotNetAmt,
  db_item.spqtnitempricemeasure1amount AS SPQtnItemPriceMeasure1Amount,
  db_item.spqtnitempricemeasure1quantity AS SPQtnItemPriceMeasure1Quantity,
  db_item.spqtnitempricemeasure2amount AS SPQtnItemPriceMeasure2Amount,
  db_item.spqtnitempricemeasure2quantity AS SPQtnItemPriceMeasure2Quantity,
  db_item.spqtnitempricemeasure3amount AS SPQtnItemPriceMeasure3Amount,
  db_item.spqtnitempricemeasure3quantity AS SPQtnItemPriceMeasure3Quantity,
  db_item.requestedquantity AS RequestedQuantity,
  db_item.srcgprojqtnofferedquantity AS SrcgProjQtnOfferedQuantity,
  db_item.requestedquantityunit AS RequestedQuantityUnit,
  db_item.requesteddeliverydate AS RequestedDeliveryDate,
  db_item.proposeddeliverydate AS ProposedDeliveryDate,
  db_item.performanceperiodstartdate AS PerformancePeriodStartDate,
  db_item.performanceperiodenddate AS PerformancePeriodEndDate,
  db_item.orderpriceunit AS OrderPriceUnit,
  db_item.orderpriceunittoorderunitnmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  db_item.ordpriceunittoorderunitdnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  db_item.srcgprojquotationitemparent AS SrcgProjQuotationItemParent,
  db_item.hierarchynodelevel AS HierarchyNodeLevel,
  db_item.alternativeitemid AS AlternativeItemID,
  db_item.formatteditemid AS FormattedItemID,
  db_item.hierarchynodesubtreesize AS HierarchyNodeSubTreeSize,
  db_item.purchasinggroup AS PurchasingGroup,
  db_item.purchasingorganization AS PurchasingOrganization,
  db_item.procurementhubsourcesystem AS ProcurementHubSourceSystem,
  db_item.procmthubplantuniqueid AS ProcmtHubPlantUniqueID,
  db_item.srcgprojqtnitemexcludingrsn AS SrcgProjQtnItemExcludingRsn,
  db_item.srcgprojqtnitemsuitability AS SrcgProjQtnItemSuitability,
  db_item.srcgprojqtnitempricingorigin AS SrcgProjQtnItemPricingOrigin,
  db_item.srcgprojqtnitemofferingcode AS SrcgProjQtnItemOfferingCode,
  db_item.srcgprojnegttnqtanitemuuid AS SrcgProjNegttnQtanItemUUID,
  db_item.srcgprojnegttnitminclusiontype AS SrcgProjNegttnItmInclusionType,
  db_item.srcgprojitemprodfprntisreqd AS SrcgProjItemProdFprntIsReqd,
  db_item.spqtnitemprodfprntcollcode AS SPQtnItemProdFprntCollCode
FROM mmsrcgpqtnitem AS Item
INNER JOIN P_SPQTN_ITM_SDM_PHASE_AMDP_TF AS TF ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SourcingProjectQuotation AS _SourcingProjectQuotation ON sourcingprojectquotationuuid = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): mmsrcgpqtnitem
;

Learn More