I_ACMContractBusiness

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_ACMContractBusiness.
-- 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: IACMCTRBUSNS

CREATE VIEW I_ACMContractBusiness AS
SELECT
  tkonn AS TradingContractNumber,
  elifn AS PurchaseOrderSupplier,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  waers_purch AS TradingContractCurrency,
  incov_sd AS TrdgContrSalesIncotermsVersion,
  inco2_l_sd AS TrdgContrSlsIncotermsLoc1Text,
  inco3_l_sd AS TrdgContrSlsIncotermsLoc2Text,
  incov_mm AS TrdgContrPurgIncotermsVersion,
  inco2_l_mm AS TrdgContrPurgIncotermsLoc1Text,
  knumv_mm AS PricingDocument,
  inco1_mm AS ACMPurgIncotermsPart1,
  inco1_sd AS ACMSlsIncotermsPart1,
  zterm AS TrdgContrPurgPaymentTerms,
  zterm_sales AS TrdgContrSalesPaymentTerms,
  reswk AS ACMSupplyingPlant,
  ihrez AS ACMYourReference,
  bstkd AS ACMCustomerReference
FROM wbhd
;