R_PurchaseContractTP

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 R_PurchaseContractTP.
-- 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.

CREATE VIEW R_PurchaseContractTP 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(abs(ExchangeRate) as fis_absolute_exchangerate preserving type) AS AbsoluteExchangeRate,
  cast(case when ExchangeRate < 0 then 'X' else '' end as fis_indirect_quotation preserving type) AS ExchRateIsIndirectQuotation,
  cast(case when ExchangeRate < 0 then division(1,abs(ExchangeRate),5) else ExchangeRate end as fis_effective_exchangerate) AS EffectiveExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  PurchasingDocumentName,
  PurchasingDocumentOrigin,
  ReleaseIsNotCompleted,
  PurchasingProcessingStatus,
  PurgAggrgdProdCmplncSuplrSts,
  SupplierAddressID,
  PurgHasCatalogRelevantItems,
  IsEndOfPurposeBlocked,
  cast ('' as boolean) AS PurgContractIsInPreparation,
  cast (VersionIsEnabled as boolean ) AS VersionIsEnabled,
  PurDocHasChgVers,
  PurchasingDocumentVersion,
  PurchasingDocVersionReasonCode
FROM I_PurchaseContract
LEFT OUTER JOIN E_PurchasingDocument AS _PurchasingDocument ON PurchaseContract = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN R_PurchaseContractItemTP AS _PurchaseContractItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_PurContrPartnersTP AS _PurCtrPartners ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_PurContrHeaderNotesTP AS _PurCtrNotes ON /* condition not available in parsed metadata */  -- association [0..*]
;