I_TrdgContrFieldCatalogData

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_TrdgContrFieldCatalogData.
-- 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: ICONTFLDCATALOG

CREATE VIEW I_TrdgContrFieldCatalogData AS
SELECT
  ContractItem.tkonn AS ContractNum,
  ContractItem.tposn AS TradingContractItem,
  case GenericDocInfo.side when 'P' then Business.inco1_mm when 'S' then Business.inco1_sd else '' end as Incoterms AS inco1_sdelseendasIncoterms,
  Header.company_code AS CompanyCode,
  ContractItem.prctr AS ProfitCenter,
  Header.vkorg AS SalesOrganization,
  Header.vtweg AS DistributionChannel,
  Header.spart AS Division,
  Business.ekorg AS PurchasingOrganization,
  Business.ekgrp AS PurchasingGroup,
  ContractItem.werks AS ContractPlant,
  ContractItem.matnr AS ContractMaterial,
  Header.tctyp AS TradingContractType,
  nom_hdr.vktra AS ModeOfTransport,
  case GenericDocInfo.side when 'S' then Header.kunnr when 'P' then Business.elifn else '' end as Counterparty AS elifnelseendasCounterparty,
  Material.commodity AS Commodity,
  ContractItem.matkl AS MaterialGroup
FROM wbhk AS Header
INNER JOIN wbhi AS ContractItem ON /* join condition not captured in parsed metadata */
INNER JOIN wbgt AS GenericDocInfo ON /* join condition not captured in parsed metadata */
INNER JOIN wbhd AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN mara AS Material ON /* join condition not captured in parsed metadata */
;