I_ACMTrdgContrBusForMntnContr

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_ACMTrdgContrBusForMntnContr.
-- 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: IACMTCBUSMNTNAPP

CREATE VIEW I_ACMTrdgContrBusForMntnContr AS
SELECT
  Business.TKONN AS TradingContractNumber,
  Business.ELIFN AS PurchaseOrderSupplier,
  Business.ZTERM AS PaymentTerms,
  Business.EKORG AS PurchasingOrganization,
  Business.EKGRP AS PurchasingGroup,
  Business.WAERS_PURCH AS TradingContractCurrency,
  Business.INCOV_SD AS TrdgContrSalesIncotermsVersion,
  Business.INCO2_L_SD AS TrdgContrSlsIncotermsLoc1Text,
  Business.INCO3_L_SD AS TrdgContrSlsIncotermsLoc2Text,
  Business.INCOV_MM AS TrdgContrPurgIncotermsVersion,
  Business.INCO2_L_MM AS TrdgContrPurgIncotermsLoc1Text,
  Business.KNUMV_MM AS PricingDocument,
  Business.IHREZ AS ACMYourReference,
  Business.BSTKD AS ACMCustomerReference,
  Business.ZTERM_SALES AS TrdgContrSalesPaymentTerms,
  Business.INCO1_MM AS ACMPurgIncotermsPart1,
  Business.INCO1_SD AS ACMSlsIncotermsPart1,
  Shadow.DocumentSide AS DocumentSide,
  case Shadow.DocumentSide when 'M' then Business.INCO2_L_MM else Business.INCO2_L_SD end as IncotermsLocation1 AS INCO2_L_SDendasIncotermsLocation1,
  case Shadow.DocumentSide when 'M' then Business.ZTERM else Business.ZTERM_SALES end as AlternatePaymentTerm AS ZTERM_SALESendasAlternatePaymentTerm
FROM P_ContSubItem AS Business
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
;