I_ACMTrdgContrHdrItmForPrcgOvw

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_ACMTrdgContrHdrItmForPrcgOvw.
-- 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: IACMTCHDRITMPRC

CREATE VIEW I_ACMTrdgContrHdrItmForPrcgOvw AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Item.TradingContractItem AS TradingContractItem,
  Header.TradingContractType AS TradingContractType,
  Header.TradingContractTypeName AS TradingContractTypeName,
  Header.ContractStatus AS ContractStatus,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.TradingContractChangedOnDate AS TradingContrChangedOnDate,
  Header.TrdgContrApplStsName AS TrdgContrApplStsName,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.Division AS Division,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.DocumentDate AS DocumentDate,
  Header.PersonResponsible AS PersonResponsible,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.CompanyCode AS CompanyCode,
  Header.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  Header.ACMContractStatusIsPosRelevant AS ACMContractStatusIsPosRelevant,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  Business.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Business.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  case Header.PricingDocument when '' then Business.PricingDocument else Header.PricingDocument end as PricingDocument AS PricingDocumentendasPricingDocument,
  Header.TrdgContrGoodsSupplier AS TrdgContrGoodsSupplier,
  Business.PurchaseOrderSupplier AS PurchaseOrderSupplier,
  Item.ACMPrcgCmmdtyOrdSubAccountID AS ACMPrcgCmmdtyOrdSubAccountID,
  Item.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  Item.ACMPricingItemQuantity AS ACMPricingItemQuantity,
  Item.ACMTrdgContrSubAccountName AS ACMTrdgContrSubAccountName,
  Item.CmmdtyDealDetEffectiveFromDate AS CmmdtyDealDetEffectiveFromDate,
  Item.CmmdtyDealDetEffectiveToDate AS CmmdtyDealDetEffectiveToDate,
  Item.ContractMaterial AS ContractMaterial,
  Item.ContractPlant AS ContractPlant,
  Item.PricingApproach AS PricingApproach,
  Item.Side AS Side,
  Item.TrdgContractItemUnitOfMeasure AS TrdgContractItemUnitOfMeasure,
  Item.ValuationPoint AS ValuationPoint,
  Item.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  Item.ACMNumberOfVehicles AS ACMNumberOfVehicles,
  Item.UnitOfMeasure AS UnitOfMeasure,
  Item.ACMToleranceDeliveryQuantity AS ACMToleranceDeliveryQuantity
FROM I_ACMTrdgContrHdrDet AS Header
INNER JOIN I_ACMTrdgContrItemForPrcgOvw_1 AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrBusDataDet AS Business ON /* join condition not captured in parsed metadata */
;