I_ACMTrdgContrHdrForPrcgOvw

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_ACMTrdgContrHdrForPrcgOvw.
-- 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: IACMTCHDRPRCOVW

CREATE VIEW I_ACMTrdgContrHdrForPrcgOvw AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  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
FROM I_ACMTrdgContrHdrDet AS Header
INNER JOIN I_ACMTrdgContrBusDataDet AS Business ON /* join condition not captured in parsed metadata */
;