I_ACMTrdgContrItemForPrcgOvw_1

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_ACMTrdgContrItemForPrcgOvw_1.
-- 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: IACMTCITMPRCOVW1

CREATE VIEW I_ACMTrdgContrItemForPrcgOvw_1 AS
SELECT
  Item.TradingContractItem AS TradingContractItem,
  Item.ContractPlant AS ContractPlant,
  Item.ContractMaterial AS ContractMaterial,
  ItemAddl.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  ItemAddl.ValuationPoint AS ValuationPoint,
  Comsub.TrdgContractCreditSalesToDate AS CmmdtyDealDetEffectiveToDate,
  Comsub.ACMPricingCancellationQuantity AS ACMPricingItemQuantity,
  Comsub.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  TolHdrData.UnitOfMeasure AS UnitOfMeasure,
  TolHdrData.ACMToleranceDeliveryQuantity AS ACMToleranceDeliveryQuantity,
  Comsub.Side AS Side,
  ItemAddl.ACMPrcgCmmdtyOrdSubAccountID AS ACMPrcgCmmdtyOrdSubAccountID,
  ItemAddl.ACMTrdgContrSubAccountName AS ACMTrdgContrSubAccountName
FROM I_ACMTradingContractItemData AS Item
INNER JOIN I_ACMTrdgContrItemAddlDets AS ItemAddl ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContractCommoditySubitem AS Comsub ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContrToleranceHeader AS TolHdrData ON /* join condition not captured in parsed metadata */
;