I_PurContrVersionHistory

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_PurContrVersionHistory.
-- 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: ICONTRVERSHIST

CREATE VIEW I_PurContrVersionHistory AS
SELECT
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.Supplier AS Supplier,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.ReleaseCode AS ReleaseCode,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.InvoicingParty AS InvoicingParty,
  cast( Document.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.CorrespncExternalReference AS CorrespncExternalReference,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.PurchasingDocumentName AS PurchasingDocumentName,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.ActivePurchasingDocument AS ActivePurchasingDocument,
  Document.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  Document.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  Document.PurgDocIsChgVers AS PurgDocIsChgVers,
  Document.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  VersionHistory.ernam AS CreatedByUser,
  VersionHistory.erdat AS CreationDate,
  VersionHistory.eruhr AS CreationTime,
  VersionHistory.rscod AS PurchasingDocVersionReasonCode,
  VersionHistory.strev AS PurchasingDocVersionStatus,
  cast ('' as mm_oa_approver_id) AS AccWorkflowApprover,
  cast ('' as mm_oa_approver_name) AS AccWorkflowApproverFirstName,
  cast( '' as val_text ) AS ApprovalStatusName,
  cast( '' as sww_aagent ) AS ApproverUser,
  cast('' as boolean ) AS PurgContractIsInPreparation,
  cast('' as mmpur_doc_status) AS PurchasingDocumentStatus,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentOrigin,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  PurgHasCatalogRelevantItems,
  Document._DocumentCurrency AS _DocumentCurrency
FROM erev AS VersionHistory
INNER JOIN R_PurchaseContract AS Document ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _UserDetails ON CreatedByUser = _UserDetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_PurContrVersionType AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms AND _PaymentTermsText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON _PurchasingGroup.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _DocumentCurrencyText ON _DocumentCurrencyText.Language = $session.system_language AND _DocumentCurrencyText.Currency = DocumentCurrency  -- association [1..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassificationText ON _IncotermsClassificationText.IncotermsClassification = IncotermsClassification AND _IncotermsClassificationText.IncotermsClassificationName = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON _IncotermsClassification.IncotermsClassification = IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
;