C_SPQtnItmPlntProdFprntCompare

DDL: C_SPQTNITMPLNTPRODFPRNTCOMPARE Type: view_entity CONSUMPTION
23 Fields 2 Data Sources 1 Associations

SPQtn Item Prod Footprint Compare

C_SPQtnItmPlntProdFprntCompare is a Consumption CDS View that provides data about "SPQtn Item Prod Footprint Compare" in SAP S/4HANA. It reads from 2 data sources (R_SrcgProjQtnItemProdFprnt, R_SPQtnItemProdFprntPlant) and exposes 23 fields with key field SPQtnItemProdFprntPlantUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
R_SrcgProjQtnItemProdFprnt _ProductFootprint right_outer
R_SPQtnItemProdFprntPlant _ProductFootprintPlant from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PFMFootprintBndryCndnText _PFMFootprintBndryCndnText $projection.PFMFootprintBndryCndn = _PFMFootprintBndryCndnText.PFMFootprintBndryCndn

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SPQtnItemProdFprntPlantUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label SPQtn Item Prod Footprint Compare view
Feature SW:PROD_SRCG_PROD_FPRNT view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SPQtnItemProdFprntPlantUUID R_SPQtnItemProdFprntPlant SPQtnItemProdFprntPlantUUID Product Footprint Plant UUID
SourcingProjectQuotationUUID R_SrcgProjQtnItemProdFprnt SourcingProjectQuotationUUID Supplier Quotation UUID
SrcgProjQtnItemProdFprntUUID R_SrcgProjQtnItemProdFprnt SrcgProjQtnItemProdFprntUUID Product Footprint UUID
SrcgProjQtnItemUUID R_SrcgProjQtnItemProdFprnt SrcgProjQtnItemUUID Supplier Quotation Item UUID
CompanyCode R_SPQtnItemProdFprntPlant CompanyCode Receiver Company Code
ProcurementHubSourceSystem R_SPQtnItemProdFprntPlant ProcurementHubSourceSystem Connected System ID
ProcmtHubPlantUniqueID R_SPQtnItemProdFprntPlant ProcmtHubPlantUniqueID Plant Unique ID
PFMFootprintBndryCndn R_SrcgProjQtnItemProdFprnt PFMFootprintBndryCndn Boundary Condition
PFMFootprintAccountingStd R_SrcgProjQtnItemProdFprnt PFMFootprintAccountingStd Accounting Standard
PFMFootprintFxdPtDcmlQuantity R_SrcgProjQtnItemProdFprnt PFMFootprintFxdPtDcmlQuantity Quantity
PFMFootprintUnit R_SrcgProjQtnItemProdFprnt PFMFootprintUnit Unit
SPQtnItmCrbnFpQtyPrimShrPctUnt R_SrcgProjQtnItemProdFprnt SPQtnItmCrbnFpQtyPrimShrPctUnt Share of Primary Emissions Unit
PFMFootprintQtyPrimaryShrPct R_SrcgProjQtnItemProdFprnt PFMFootprintQtyPrimaryShrPct Share of Primary Emissions
PFMFprntEmissionFctrSrceDesc R_SrcgProjQtnItemProdFprnt PFMFprntEmissionFctrSrceDesc Source of Emission Factor
PFMFootprintPeriodStartDate R_SrcgProjQtnItemProdFprnt PFMFootprintPeriodStartDate Period Start Date
PFMFootprintPeriodEndDate R_SrcgProjQtnItemProdFprnt PFMFootprintPeriodEndDate Period End Date
PFMFootprintBndryCndnName Boundary Condition
BaseUnit R_SrcgProjQtnItemProdFprnt BaseUnit Unit of Measure
Plant R_SPQtnItemProdFprntPlant Plant Valuation Area
SPQtnItemProdFprntPlantName R_SrcgProjQtnItemProdFprnt SPQtnItemProdFprntPlantName Supplier Plant
SrcgProjQtnItmProdFprntCountry R_SrcgProjQtnItemProdFprnt SrcgProjQtnItmProdFprntCountry Country/Region of Supplier Plant
SrcgProjQtnItemProdFprntRegion R_SrcgProjQtnItemProdFprnt SrcgProjQtnItemProdFprntRegion Region of Supplier Plant
_SourcingProjectQuotation R_SrcgProjQtnItemProdFprnt _SourcingProjectQuotation

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_SPQtnItmPlntProdFprntCompare.
-- 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_SPQtnItmPlntProdFprntCompare AS
SELECT
  _ProductFootprintPlant.SPQtnItemProdFprntPlantUUID AS SPQtnItemProdFprntPlantUUID,
  _ProductFootprint.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID,
  _ProductFootprint.SrcgProjQtnItemProdFprntUUID AS SrcgProjQtnItemProdFprntUUID,
  _ProductFootprint.SrcgProjQtnItemUUID AS SrcgProjQtnItemUUID,
  _ProductFootprintPlant.CompanyCode AS CompanyCode,
  _ProductFootprintPlant.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  _ProductFootprintPlant.ProcmtHubPlantUniqueID AS ProcmtHubPlantUniqueID,
  _ProductFootprint.PFMFootprintBndryCndn AS PFMFootprintBndryCndn,
  _ProductFootprint.PFMFootprintAccountingStd AS PFMFootprintAccountingStd,
  _ProductFootprint.PFMFootprintFxdPtDcmlQuantity AS PFMFootprintFxdPtDcmlQuantity,
  _ProductFootprint.PFMFootprintUnit AS PFMFootprintUnit,
  _ProductFootprint.SPQtnItmCrbnFpQtyPrimShrPctUnt AS SPQtnItmCrbnFpQtyPrimShrPctUnt,
  _ProductFootprint.PFMFootprintQtyPrimaryShrPct AS PFMFootprintQtyPrimaryShrPct,
  _ProductFootprint.PFMFprntEmissionFctrSrceDesc AS PFMFprntEmissionFctrSrceDesc,
  _ProductFootprint.PFMFootprintPeriodStartDate AS PFMFootprintPeriodStartDate,
  _ProductFootprint.PFMFootprintPeriodEndDate AS PFMFootprintPeriodEndDate,
  _PFMFootprintBndryCndnText[1:Language = $session.system_language ].PFMFootprintBndryCndnName AS PFMFootprintBndryCndnName,
  _ProductFootprint.BaseUnit AS BaseUnit,
  _ProductFootprintPlant.Plant AS Plant,
  _ProductFootprint.SPQtnItemProdFprntPlantName AS SPQtnItemProdFprntPlantName,
  _ProductFootprint.SrcgProjQtnItmProdFprntCountry AS SrcgProjQtnItmProdFprntCountry,
  _ProductFootprint.SrcgProjQtnItemProdFprntRegion AS SrcgProjQtnItemProdFprntRegion,
  _ProductFootprint._SourcingProjectQuotation AS _SourcingProjectQuotation
FROM R_SPQtnItemProdFprntPlant AS _ProductFootprintPlant
RIGHT OUTER JOIN R_SrcgProjQtnItemProdFprnt AS _ProductFootprint ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PFMFootprintBndryCndnText AS _PFMFootprintBndryCndnText ON PFMFootprintBndryCndn = _PFMFootprintBndryCndnText.PFMFootprintBndryCndn  -- association [0..*]
;

Learn More