P_PrepaymentDocumentFixedVal

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_PrepaymentDocumentFixedVal.
-- 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: PPPMGDOCFXDVAL

CREATE VIEW P_PrepaymentDocumentFixedVal AS
SELECT
  Contract.TradingContract AS TradingContract,
  ContractItem.TradingContractItem AS TradingContractItem,
  Contract.PrepaymentRefDocCondition AS PrepaymentRefDocCondition,
  PricingVal.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  in Document Currency PricingVal.PrepaymentRefDocFixedPrice AS PrepaymentRefDocFixedPrice,
  PricingVal.PrepaymentRefDocFixedPriceCrcy AS PrepaymentRefDocFixedPriceCrcy,
  PricingVal.PrcgCndnTermFixationOptnStatus AS PrcgCndnTermFixationOptnStatus,
  PricingVal.PrepaymentDocCmmdtyMktQtyUnit AS PrepaymentDocCmmdtyMktQtyUnit,
  PricingVal.PrepaymentRefDocMarketPrcCrcy AS PrepaymentRefDocMarketPrcCrcy,
  uncoverted PricingVal.ConditionTermRate AS ConditionTermRate,
  PricingVal.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  F = Future PricingVal.MTMCalculationGroup AS MTMCalculationGroup,
  PricingVal.PrepaymentWrkCtrDocPricingOptn AS PrepaymentWrkCtrDocPricingOptn
FROM I_PreAgrmtTradingContract AS Contract
INNER JOIN I_PreAgrmtTradingContractStat AS ContractApplicationStatus ON /* join condition not captured in parsed metadata */
INNER JOIN I_PreAgrmtTradingContractItem AS ContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrepaymentDocFixedValData AS PricingVal ON /* join condition not captured in parsed metadata */
;