I_ACMTrdgContrHdrDet

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_ACMTrdgContrHdrDet.
-- 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: IACMTCHDRDET

CREATE VIEW I_ACMTrdgContrHdrDet AS
SELECT
  Header.TradingContractNumber AS TradingContractNumber,
  Header.TrdgContrGoodsSupplier AS TrdgContrGoodsSupplier,
  Header.Division AS Division,
  Header.TradingContractType AS TradingContractType,
  Header.ContractStatus AS ContractStatus,
  Header.TradingContrCreatedOnDate AS TradingContrCreatedOnDate,
  Header.SalesOrganization AS SalesOrganization,
  Header.DistributionChannel AS DistributionChannel,
  Header.TradingContractExternalID AS TradingContractExternalID,
  Header.DocumentDate AS DocumentDate,
  Header.PersonResponsible AS PersonResponsible,
  Header.TradingContractCreatedBy AS TradingContractCreatedBy,
  Header.TradingContractChangedBy AS TradingContractChangedBy,
  Header.TradingContractChangedOnDate AS TradingContractChangedOnDate,
  Header.TradingContractSalesCurrency AS TradingContractSalesCurrency,
  Header.CompanyCode AS CompanyCode,
  Header.PricingDocument AS PricingDocument,
  Header.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  Header.ACMContractStatusIsPosRelevant AS ACMContractStatusIsPosRelevant,
  Status.TrdgContrApplStsName AS TrdgContrApplStsName,
  ContractType.TradingContractTypeName AS TradingContractTypeName
FROM I_ACMTrdgContrHdrFltrDet AS Header
INNER JOIN I_ACMTradingContractTypeVH AS ContractType ON /* join condition not captured in parsed metadata */
;