P_ACMTrdgContrHdrDetsMntnContr

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 P_ACMTrdgContrHdrDetsMntnContr.
-- 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: PACMTCHDRDTS

CREATE VIEW P_ACMTrdgContrHdrDetsMntnContr AS
SELECT
  Header.TradingContractNumber AS tkonn,
  Header.TradingContractType AS tctyp,
  Header.Customer AS kunnr,
  Header.ContractStatus AS btbsta,
  Header.TradingContractCreatedBy AS ernam,
  Header.DocumentDate AS budat,
  Header.TradingContrCreatedOnDate AS erdat,
  Header.TimeOfCreation AS erzeit,
  Header.TradingContractChangedBy AS aenam,
  Header.TradingContractChangedOnDate AS aedat,
  Header.SalesOrganization AS vkorg,
  Header.DistributionChannel AS vtweg,
  Header.Division AS spart,
  Header.PersonResponsible AS tksachb,
  Header.TradingContractCurrency AS sdwrs,
  Header.TradingContractExternalID AS tkonn_ex,
  Header.CompanyCode AS company_code,
  Header.ACMRelevantContractStatus AS ACMRelevantContractStatus,
  Status.TrdgContrApplStsName AS bezei,
  ContractType.TradingContractTypeName AS tctyp_descr,
  Business.DocumentSide AS Side,
  Business.PurchaseOrderSupplier AS PurchaseOrderSupplier,
  Business.PurchasingOrganization AS PurchasingOrganization,
  Business.PurchasingGroup AS PurchasingGroup,
  Business.TradingContractCurrency AS TradingContractCurrency,
  Business.TrdgContrSalesIncotermsVersion AS TrdgContrSalesIncotermsVersion,
  Business.TrdgContrSlsIncotermsLoc1Text AS TrdgContrSlsIncotermsLoc1Text,
  Business.TrdgContrPurgIncotermsVersion AS TrdgContrPurgIncotermsVersion,
  Business.TrdgContrPurgIncotermsLoc1Text AS TrdgContrPurgIncotermsLoc1Text,
  Business.PricingDocument AS PricingDocument,
  Business.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Business.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  Business.ACMYourReference AS ACMYourReference,
  Business.ACMCustomerReference AS ACMCustomerReference,
  Business.IncotermsLocation1 AS IncotermsLocation1,
  Business.AlternatePaymentTerm AS AlternatePaymentTerm
FROM I_ACMTrdgContrHdrForMntnContr AS Header
INNER JOIN I_ACMContrBusDetsForMntnContr AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMContractSubItemDet AS Business ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrShadowItemDets AS Shadow ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescmm ON Business.ACMPurgIncotermsPart1 = _IncoDescmm.IncotermsClassification AND _IncoDescmm.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescsd ON Business.ACMSlsIncotermsPart1 = _IncoDescsd.IncotermsClassification AND _IncoDescsd.Language = $session.system_language  -- association [1..1]
;