I_CntrlPurContrVersionHistory

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_CntrlPurContrVersionHistory.
-- 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: IVERSIONHISTORY

CREATE VIEW I_CntrlPurContrVersionHistory AS
SELECT
  Document.CentralPurchaseContract AS CentralPurchaseContract,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.Supplier AS Supplier,
  Document.PurchasingDocumentSubtype AS PurchasingDocumentSubtype,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.Currency AS Currency,
  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.ManualSupplierAddressID AS ManualSupplierAddressID,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.InvoicingParty AS InvoicingParty,
  Document.ExchangeRate 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.PurchasingParentDocument AS PurchasingParentDocument,
  Document.ProcmtHubCompanyCodeGroupingID AS ProcmtHubCompanyCodeGroupingID,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  Document.ActivePurchasingDocument AS ActivePurchasingDocument,
  Document.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  Document.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  Document.PurgDocIsChgVers AS PurgDocIsChgVers,
  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
FROM erev AS VersionHistory
INNER JOIN R_CentralPurchaseContract 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_CntrlPurContrVersionType 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]
;