R_PPS_PurOrdVersionHistory

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_PPS_PurOrdVersionHistory.
-- 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_PPS_PurOrdVersionHistory AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.PurchaseOrderType AS PurchaseOrderType,
  Document.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  Document.PurchaseOrderDate AS PurchaseOrderDate,
  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.PurgReleaseTimeTotalAmount AS PurgReleaseTimeTotalAmount,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.ReleaseCode AS ReleaseCode,
  Document.PurchaseOrderDeletionCode AS PurchaseOrderDeletionCode,
  Document.PurchasingReleaseStrategy AS PurchasingReleaseStrategy,
  Document.PurgReasonForDocCancellation AS PurgReasonForDocCancellation,
  Document.Supplier AS Supplier,
  Document.PurchaseContract AS PurchaseContract,
  cast( Document.ExchangeRate as fis_exchange_rate preserving type ) AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.SupplierQuotationExternalID AS SupplierQuotationExternalID,
  Document.ItemNumberIntervalForSubItems AS ItemNumberIntervalForSubItems,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.CorrespncExternalReference AS CorrespncExternalReference,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  Document.ActivePurchasingDocument AS ActivePurchasingDocument,
  Document.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  Document.PurchasingDocumentVersion AS PurchasingDocumentVersion,
  Document.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  Document.PurgReleaseSequenceStatus AS PurgReleaseSequenceStatus,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.PricingDocument AS PricingDocument,
  Document.PricingProcedure AS PricingProcedure,
  Document.TaxReturnCountry AS TaxReturnCountry,
  Document.VATRegistrationCountry AS VATRegistrationCountry,
  Document._Supplier AS _Supplier,
  Document.Language AS Language,
  Document._Language AS _Language,
  Document._PaymentTerms AS _PaymentTerms,
  Document._CompanyCode AS _CompanyCode,
  Document.DownPaymentType AS DownPaymentType,
  Document.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  cast( _PurchaseOrderHeaderExtension.PPSDocumentCurrency as pps_e_document_currency preserving type ) AS PPSDocumentCurrency,
  Document.DownPaymentAmount AS DownPaymentAmount,
  Document.DownPaymentDueDate AS DownPaymentDueDate,
  Document.RetentionType AS RetentionType,
  Document.PurgDocHdrInvcRtntnPct AS PurgDocHdrInvcRtntnPct,
  VersionHistory.CreatedByUser AS CreatedByUser,
  VersionHistory.CreationDate AS CreationDate,
  VersionHistory.CreationTime AS CreationTime,
  VersionHistory.PurchasingDocVersionStatus AS PurchasingDocVersionStatus,
  _PurchaseOrderHeaderExtension.PurchasingDocVersionReasonCode AS PurchasingDocVersionReasonCode,
  _PurchaseOrderHeaderExtension.PPSSmartNumberHeaderIsManual AS PPSSmartNumberHeaderIsManual,
  _PurchaseOrderHeaderExtension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  _PurchaseOrderHeaderExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  _PurchaseOrderHeaderExtension.PPSPurchaseOrderDescription AS PPSPurchaseOrderDescription,
  _PurchaseOrderHeaderExtension.PPSRevisionComment AS PPSRevisionComment,
  _PurchaseOrderHeaderExtension.PPSNumberOfModification AS PPSNumberOfModification,
  _PurchaseOrderHeaderExtension.PPSModificationType AS PPSModificationType,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseOrderHeaderExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PurchaseOrderHeaderExtension.PPSPurgDocClassfctnCode AS PPSPurgDocClassfctnCode,
  _PurchaseOrderHeaderExtension.PPSFuturePostingDate AS PPSFuturePostingDate,
  _PurchaseOrderHeaderExtension.PPSPricingArrangementType AS PPSPricingArrangementType,
  cast( _PurchaseOrderHeaderExtension.PPSIsDirectPurchaseOrder as pps_e_is_direct_ord preserving type ) AS PPSIsDirectPurchaseOrder,
  _PurchaseOrderHeaderExtension.InterestCalculationCode AS InterestCalculationCode,
  cast ( '' as mm_rework_comment ) AS POReworkCommentText,
  cast ( '' as purchaseorderhascommitmentitem ) AS PurchaseOrderHasCommitmentItem,
  _PurchaseOrderHeaderExtension.PPSPurOrderHeaderStatus AS PPSPurOrderHeaderStatus,
  _PurchaseOrderHeaderExtension.PPSDocumentIsNovated AS PPSDocumentIsNovated,
  Document._SupplierCurrency AS _SupplierCurrency,
  Document._PurchasingOrganization AS _PurchasingOrganization,
  Document._PurchasingGroup AS _PurchasingGroup
FROM I_PPS_PurgDocVersionHistory AS VersionHistory
INNER JOIN R_PPS_PurchaseOrder AS Document ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchaseOrderTypeText ON _PurchaseOrderTypeText.PurchasingDocumentType = PurchaseOrderType AND _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F' AND _PurchaseOrderTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurOrderHeaderExtension AS _PurchaseOrderHeaderExtension ON PurchaseOrder = _PurchaseOrderHeaderExtension.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocModifTypeText AS _ModificationTypeText ON PPSModificationType = _ModificationTypeText.PPSModificationType AND _ModificationTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocVersionReasonVH AS _VersionReasonValHelp ON purchasingdocversionreasoncode = _VersionReasonValHelp.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurgDocClassificationTxt AS _Classification ON PPSPurgDocClassfctnCode = _Classification.DomainValue AND _Classification.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurgDocHdrStatusText AS _PurOrderStatusText ON ppspurorderheaderstatus = _PurOrderStatusText.DomainValue AND _PurOrderStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurOrdWorkflowDetail AS _WorkflowDetail ON PurchaseOrder = _WorkflowDetail.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_InterestCalculationCode AS _InterestCalCode ON interestcalculationcode = _InterestCalCode.InterestCalculationCode  -- association [0..1]
LEFT OUTER JOIN I_PPS_RetentionTypeText AS _RetentionType ON RetentionType = _RetentionType.DomainValue AND _RetentionType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DownPaymentIndicatorText AS _DownPaymentIndicatorText ON DownPaymentType = _DownPaymentIndicatorText.DownPaymentType AND _DownPaymentIndicatorText.Language = $session.system_language  -- association [0..1]
;