I_ACMMntnContrPrcgAspect

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 I_ACMMntnContrPrcgAspect.
-- 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: IACMPRCGASPCT

CREATE VIEW I_ACMMntnContrPrcgAspect AS
SELECT
  I_ACMContractPricingAspectData.TradingContractNumber AS TradingContractNumber,
  I_ACMContractPricingAspectData.TradingContractItem AS TradingContractItem,
  I_ACMContractPricingAspectData.ACMPricingAspect AS ACMPricingAspect,
  I_ACMContractPricingAspectData.ACMPricingAspectValue AS ACMPricingAspectValue,
  I_ACMContractPricingAspectData.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
  cast( ' ' as /accgo/e_dummy_source_lot_id ) AS TrdgContrPrcgAspectDummyLotID,
  cast( ' ' as cpet_termno ) AS PricingConditionTerm,
  I_ACMContractPricingAspectData.ACMPrcgCndnFlatPrice AS ACMPrcgCndnFlatPrice,
  I_ACMContractPricingAspectData.ACMPrcgCndnCumltvBasisPrice AS ACMPrcgCndnCumltvBasisPrice,
  I_ACMContractPricingAspectData.ACMPrcgCndnBasisPrc AS ACMPrcgCndnBasisPrc,
  I_ACMContractPricingAspectData.ACMPrcgCndnCumltvBasisCrcy AS ACMPrcgCndnCumltvBasisCrcy,
  I_ACMContractPricingAspectData.ContractTradeQuantity AS ContractTradeQuantity,
  I_ACMContractPricingAspectData.ContractTradeUnit AS ContractTradeUnit,
  cast( ' ' as tba_dcsid ) AS DerivativeContrSpecification,
  cast( ' ' as tba_mic ) AS ACMPricingMarketIdentifierCode,
  cast( ' ' as tba_contract_code ) AS DerivativeContractMaturityCode,
  cast( ' ' as tba_keydate ) AS MaturityKeyDate,
  cast( ' ' as konwa ) AS PrcgCndnTradingContrCurrency,
  I_ACMContractPricingAspectData.ACMPrcgCndnCumltvBasisUnit AS ACMPrcgCndnCumltvBasisUnit,
  I_ACMContractPricingAspectData.ACMPrcgCndnCumltvBasisPrUoM AS ACMPrcgCndnCumltvBasisPrUoM,
  dummy_npe.DomainText AS ACMTrdgContrPrcgStatusText,
  cast( ' ' as cpet_formuom ) AS ACMFormulaUoM,
  cast( ' ' as konwa) AS ACMPrcgCndnFormulaRateCrcy,
  cast( ' ' as kmein ) AS ACMPrcgCndnFormulaRateQtyUnit,
  I_ACMContractPricingAspectData.ACMIsOverfillPricingLot AS ACMIsOverfillPricingLot,
  I_ACMContractPricingAspectData.PrcFixGrpUUID AS PrcFixGrpUUID,
  I_ACMContractPricingAspectData.ACMPrcFixGrpID AS ACMPrcFixGrpID,
  cast( 0000 as abap.int4 ) AS ACMNumberOfVehicles
FROM I_ACMContractPricingAspectData
INNER JOIN left ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingCndnTypeMapping AS CondMap ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_ACMContrNonPrcdTmpLotDets
;