P_ACMQtyReconVlogpPrepareData

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_ACMQtyReconVlogpPrepareData.
-- 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.
-- SQL view name: PACMVLOGPPREPD

CREATE VIEW P_ACMQtyReconVlogpPrepareData AS
SELECT
  PricingKey,
  ACMPricingVersion AS Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  MTMDataSourceType,
  Vlogp.Material AS Material,
  StorageLocation,
  SourceDocument,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  QuotationKeyType,
  ConditionTermRateIsFixed,
  PricingStatus,
  CommodityQuantity,
  CommodityUnit,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  ImplicitFixationIsRelevant,
  ConditionTermFactorNumerator,
  ConditionTermFactorDenominator,
  _Material.BaseUnit AS MaterialBaseUnit,
  cast( ( substring(OriginReferenceDocument, 11, 10) ) as tkonn ) AS OriginReferenceDocumentChar10,
  PhysCmmdty.PhysicalCommodity AS PhysicalCommodity
FROM I_ACMVersionedLogisticDocument AS Vlogp
INNER JOIN I_PhysCmmdtyForMaterial AS PhysCmmdty ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingCndnTypeMapping AS ConditionTypeMapp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [1]
;