I_ACMTrdgContrPrcLotDet

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_ACMTrdgContrPrcLotDet.
-- 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 I_ACMTrdgContrPrcLotDet AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Item.TradingContractItem AS TradingContractItem,
  Header.TradingContractType AS TradingContractType,
  Header.TradingContractTypeName AS TradingContractTypeName,
  Header.ContractStatus AS ContractStatus,
  Header.TrdgContrApplStsName AS TrdgContrApplStsName,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.Division AS Division,
  Header.PurchasingOrganization AS PurchasingOrganization,
  Header.PurchasingGroup AS PurchasingGroup,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.DocumentDate AS DocumentDate,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.PersonResponsible AS PersonResponsible,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Header.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  Header.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  Header.ACMContractStatusIsPosRelevant AS ACMContractStatusIsPosRelevant,
  Header.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Header.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  Header.AlternatePaymentTerm AS AlternatePaymentTerm,
  Header.CompanyCode AS CompanyCode,
  Header.ACMYourReference AS ACMYourReference,
  Header.ACMCustomerReference AS ACMCustomerReference,
  Header.TrdgContrGoodsSupplier AS TrdgContrGoodsSupplier,
  Header.PurchaseOrderSupplier AS PurchaseOrderSupplier,
  Header.PricingDocument AS PricingDocument,
  Item.ContractPlant AS ContractPlant,
  ltrim( Item.ContractMaterial,'0' ) AS ContractMaterial,
  Item.ContractMaterial AS Material,
  Item.PricingApproach AS PricingApproach,
  case Item.Side when 'M' then Header.ACMPurgIncotermsPart1 else Header.ACMSlsIncotermsPart1 end as Incoterms AS ACMSlsIncotermsPart1endasIncoterms,
  Item.CmmdtyDealDetEffectiveFromDate AS CmmdtyDealDetEffectiveFromDate,
  Item.CmmdtyDealDetEffectiveToDate AS CmmdtyDealDetEffectiveToDate,
  Item.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  Item.ACMPricingItemQuantity AS ACMPricingItemQuantity,
  Item.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  Item.ValuationPoint AS ValuationPoint,
  Item.ACMPrcgCmmdtyOrdSubAccountID AS ACMPrcgCmmdtyOrdSubAccountID,
  Item.ACMTrdgContrSubAccountName AS ACMTrdgContrSubAccountName,
  PricingAspect.ContractTradeUnit AS ContractTradeUnit,
  PricingAspect.ContractTradeQuantity AS ContractTradeQuantity,
  PriceFixation.ACMConditionTermNumber AS PricingConditionTerm,
  PricingAspect.ACMPrcgCndnFlatPrice AS ACMPrcgCndnTotalNonHedgePrice,
  case PricingAspect.ACMPricingAspect when 'NONE' then PricingAspect.MaturityKeyDate else PriceFixation.MaturityKeyDate end as MaturityKeyDate AS MaturityKeyDateendasMaturityKeyDate,
  cast(PriceFixation.DerivativeContractMaturityCode as tba_contract_code ) AS DerivativeContractMaturityCode,
  PriceFixation.CommodityProductSymbol AS CommodityProductSymbol,
  cast( substring(PriceFixation.MaturityKeyDate, 1, 4) as cmmfdof_aif_maturity_mon_yr ) AS CmmdtyMaturityMonthYear,
  PricingAspect.ContractTradeUnit AS UnitOfMeasure,
  PricingAspect.ContractTradeQuantity AS Quantity,
  PricingAspect.ACMTrdgContrPrcgStatusText AS ACMTrdgContrPrcgStatusText,
  PricingAspect.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
  PriceFixation.ACMFormulaUoM AS ACMFormulaUoM,
  PriceFixation.ACMPricingRate AS ACMPricingRate,
  PriceFixation.ConditionTermUnit AS ConditionTermUnit,
  PricingAspect.ACMIsOverfillPricingLot AS ACMIsOverfillPricingLot,
  PricingAspect.ACMPricingAspect AS ACMPricingAspect
FROM I_ACMMntnContrPrcgAspect AS PricingAspect
INNER JOIN I_ACMTrdgContrItemForPrcgOvw AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrHdrForPrcgOvw AS Header ON /* join condition not captured in parsed metadata */
;