C_ACMMntnTradingContractOvw

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 C_ACMMntnTradingContractOvw.
-- 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: CMNTNTRDGCTROVW

CREATE VIEW C_ACMMntnTradingContractOvw AS
SELECT
  TradingContractNumber AS SalesContract,
  TradingContractNumber,
  TradingContractType,
  TradingContractTypeName,
  Side,
  DocumentSide,
  TradingContrCreatedOnDate,
  ContractStatus,
  TrdgContrApplStsName,
  upper(_UniqueItem.ContractMaterial) AS ContractMaterial,
  _UniqueItem.Commodity AS Commodity,
  _Item.CommodityName AS CommodityName,
  _UniqueItem.ContractPlant AS ContractPlant,
  _Item.PlantName AS PlantName,
  TradgContrOvw.TradingContractCurrency AS TradingContractCurrency,
  TradgContrOvw.SalesOrganization AS SalesOrganization,
  TradgContrOvw._SalesOrganizationText.SalesOrganizationText AS SalesOrganizationText,
  TradgContrOvw.DistributionChannel AS DistributionChannel,
  TradgContrOvw._DistributionChannelText.DistributionChannelText AS DistributionChannelText,
  TradgContrOvw.Division AS Division,
  TradgContrOvw._OrganizationDivisionName.DivisionName AS DivisionName,
  PurchasingOrganization,
  TradgContrOvw._PurchasingOrganizationName.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  TradgContrOvw._PurchasingGroupName.PurchasingGroupName AS PurchasingGroupName,
  Counterparty,
  CounterpartyFullName,
  ACMCounterpartyFirstName,
  ACMCounterpartyLastName,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  CustomerName,
  Incoterms,
  IncotermsLocation1,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  TradgContrOvw.TradingContractExternalID AS TradingContractExternalID,
  TradgContrOvw.TrdgContrPersonResponsible AS TrdgContrPersonResponsible,
  TradgContrOvw._PersonResponsibleDetails.UserDescription AS TrdgContrPersonResponsibleName,
  TradgContrOvw.DocumentDate AS DocumentDate,
  TradgContrOvw.TradingContractCreatedBy AS TradingContractCreatedBy,
  TradgContrOvw._CreatedByDetails.UserDescription AS TradingContractCreatedByName,
  case when TradgContrOvw._ChangedByDetails.UserName is null then TradgContrOvw._CreatedByDetails.UserName else TradgContrOvw._ChangedByDetails.UserName end as TradingContractChangedBy AS UserNameendasTradingContractChangedBy,
  TradingContractChangedOnDate,
  IncotermsClassificationName,
  TradgContrOvw.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ACMSemanticColor,
  cast(1 as abap.int4) AS ConditionCount,
  TradgContrOvw._ContractHeadAddl.ACMOriginalTraderID AS ACMOriginalTraderID,
  TradgContrOvw._ContractHeadAddl.ACMOriginalTraderIDText AS ACMOriginalTraderIDText,
  TradgContrOvw._ContractHeadAddl.ACMAmendingTraderID AS ACMAmendingTraderID,
  ACMAmendingTraderIDText,
  TradgContrOvw._TradeOffice.TradingContractTradeOffice AS TradingContractTradeOffice,
  TradgContrOvw._ContractHeadAddl.TradingContractCreditSales AS TradingContractCreditSales,
  ACMSignedStatus,
  ACMCustomerReference,
  ACMYourReference,
  TradgContrOvw._TransactingCounterparty.TransactingCtpty AS TransactingCtpty,
  TradgContrOvw._TransactingCounterparty.ACMTransactingCustomerName AS ACMTransactingCustomerName,
  TradgContrOvw._TransactingCounterparty.ACMTransCounterpartyFullName AS ACMTransCounterpartyFullName,
  TradgContrOvw._TransactingCounterparty.ACMTransCounterpartyFirstName AS ACMTransCounterpartyFirstName,
  TradgContrOvw._TransactingCounterparty.ACMTransCounterpartyLastName AS ACMTransCounterpartyLastName,
  TradgContrOvw._TransactingCounterparty.DebtorName AS DebtorName,
  TradgContrOvw._TransactingCounterparty.PriorSupplierName AS PriorSupplierName,
  AlternatePaymentTerm,
  cast('' as abap.char(1000)) AS PaymentTermsDescription,
  TradgContrOvw._TargetContractType.ACMTrdgContrPurgControlGroup AS ACMTrdgContrPurgControlGroup,
  TradgContrOvw._ContractHeadAddl.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  TradgContrOvw._ContractHeadAddl.ACMTrdgContrQuotesValidDate AS ACMTrdgContrQuotesValidDate,
  TradgContrOvw._ContractHeadAddl.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  TradgContrOvw._TargetContractType.ACMTradingContractCategory AS ACMTradingContractCategory,
  TradgContrOvw._ContractHeadAddl.ACMTrdgContrIsStatusClosed AS ACMTrdgContrIsStatusClosed,
  TradgContrOvw.ACMRelevantContractStatus AS ACMRelevantContractStatus,
  _Item.ACMTrdgContrActualStartDate AS ACMTrdgContrActualStartDate,
  _Item.ActualStartDateTo AS ActualStartDateTo,
  ACMTrdgContractOutputProcess,
  ACMTrdgContrOutpProcText,
  ACMTrdgContrSignatureStatus,
  ACMTrdgContrSgntrStsText
FROM I_ACMMntnTradingContractOvw AS TradgContrOvw
LEFT OUTER JOIN C_ACMTradingContractItemOvw AS _Item ON TradingContractNumber = _Item.TradingContractNumber  -- association [1..*]
LEFT OUTER JOIN C_ACMTradingContractHdrFeeDet AS _TradingContractFee ON TradingContractNumber = _TradingContractFee.ACMFeeFrameworkRefDocID  -- association [1..*]
LEFT OUTER JOIN C_ACMTrdgContrHdrPartDetails AS _TrdgContrHdrPartDetails ON TradingContractNumber = _TrdgContrHdrPartDetails.TradingContractNumber  -- association [1..*]
LEFT OUTER JOIN I_ACMCompanyCodeStdVH AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ACMMntnContrItem AS _UniqueItem ON TradingContractNumber = _UniqueItem.TradingContractNumber  -- association [1..1]
;