C_PurchaseContractDEX

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_PurchaseContractDEX.
-- 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: CMMPURCONTRDEX

CREATE VIEW C_PurchaseContractDEX AS
SELECT
  PurchaseContract,
  PurchaseContractType,
  PurchasingGroup,
  PurchasingOrganization,
  ValidityStartDate,
  ValidityEndDate,
  Supplier,
  InvoicingParty,
  SupplyingSupplier,
  CreationDate,
  LastChangeDateTime,
  DocumentCurrency,
  cast ( ExchangeRate as fis_exchange_rate preserving type) AS ExchangeRate,
  PurchasingDocumentCategory,
  CompanyCode,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ReleaseCode,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  ReleaseIsNotCompleted,
  SupplierAddressID
FROM I_PurchaseContractAPI01
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseContract = _HeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN C_PurchaseContractItemDEX AS _PurchaseContractItemDEX ON PurchaseContract = _PurchaseContractItemDEX.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurchaseContractType AS _PurchasingContractType ON PurchaseContractType = _PurchasingContractType.PurchaseContractType  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SupplyingSupplier ON SupplyingSupplier = _SupplyingSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON DocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_IncotermsVersion AS _IncotermsVersion ON IncotermsVersion = _IncotermsVersion.IncotermsVersion  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _Address ON SupplierAddressID = _Address.AddressID AND _Address.AddressPersonID = '' AND _Address.AddressRepresentationCode = ''  -- association [0..1]
;