I_PurchaseContract

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_PurchaseContract.
-- 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: IPURCHASECTR

CREATE VIEW I_PurchaseContract AS
SELECT
  PurchaseContract,
  PurchaseContractType,
  PurchasingDocumentCategory,
  LastChangeDateTime,
  CreationDate,
  Supplier,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  CreatedByUser,
  PurchasingDocumentDeletionCode,
  SupplyingSupplier,
  InvoicingParty,
  cast( ExchangeRate as wkurs) AS ExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentName,
  PurchasingDocumentOrigin,
  ReleaseIsNotCompleted,
  PurchasingProcessingStatus,
  IsEndOfPurposeBlocked,
  PurgDocExternalReference,
  PurgAggrgdProdCmplncSuplrSts,
  PurgAggrgdProdMarketabilitySts,
  PurgAggrgdSftyDataSheetStatus,
  PurgProdCmplncTotDngrsGoodsSts,
  PurgHasCatalogRelevantItems,
  ActivePurchasingDocument,
  PurchasingDocumentVersion,
  PurgDocChangeRequestStatus,
  PurgDocIsChgVers,
  cast( '' as rscod ) AS PurchasingDocVersionReasonCode,
  _VersionRelevance.VersionIsEnabled AS VersionIsEnabled,
  PurDocHasChgVers
FROM R_PurchaseContract
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurchaseContractHistory AS _PurchaseContractHistory ON PurchaseContract = _PurchaseContractHistory.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_ReleaseCode AS _ReleaseCode ON ReleaseCode = _ReleaseCode.ReleaseCode  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_Purctrnotes AS _Purctrnotes ON PurchaseContract = _Purctrnotes.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_Purctrpartners AS _PurCtrPartners ON PurchaseContract = _PurCtrPartners.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN I_PurContrVersionType AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchasingDocument ON PurchaseContract = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurgDocVersionReasonValHelp AS _VersionReasonValHelp ON PurchasingDocVersionReasonCode = _VersionReasonValHelp.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN I_PurContrVersRelevance AS _VersionRelevance ON PurchaseContract = _VersionRelevance.PurchaseContract  -- association [0..1]
;