C_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 C_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 C_PPS_PurOrdVersionHistory AS
SELECT
  PurchaseOrder,
  PurchaseOrderType,
  _PurchaseOrderTypeText.PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  PurchaseOrderSubtype,
  PurchaseOrderDate,
  Supplier,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  PurchasingGroup,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  _PaymentTerms._Text[ 1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurgReleaseTimeTotalAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  PurchasingReleaseStrategy,
  PurgReasonForDocCancellation,
  PurchaseOrderDeletionCode,
  ExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotationExternalID,
  ReleaseIsNotCompleted,
  CorrespncExternalReference,
  CorrespncInternalReference,
  PricingDocument,
  PricingProcedure,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  LastChangeDateTime,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  PurgReleaseSequenceStatus,
  ActivePurchasingDocument,
  PurgDocChangeRequestStatus,
  PurchasingDocumentVersion,
  PurgAggrgdProdCmplncSuplrSts,
  CreatedByUser,
  CreationDate,
  CreationTime,
  cast( PPSSmartNumberHeader as pps_e_smt_smart_number preserving type ) AS PPSSmartNumberHeader,
  cast( PPSSmartDocumentNumber as pps_e_smt_doc_number preserving type ) AS PPSSmartDocumentNumber,
  _PurchaseOrderHeaderExtension.PPSModificationType AS PPSModificationType,
  _PurchaseOrderHeaderExtension.PPSNumberOfModification AS PPSNumberOfModification,
  _ModificationTypeText.PPSModificationTypeText AS PPSModificationTypeText,
  _PurchaseOrderHeaderExtension.PPSModificationIdentifierCode AS PPSModificationIdentifierCode,
  PPSRevisionComment,
  TaxReturnCountry,
  VATRegistrationCountry,
  PurchasingDocVersionReasonCode,
  _VersionReasonValHelp.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  _Supplier.SupplierName AS SupplierName,
  cast( PPSSmartNumberHeaderIsManual as pps_e_is_smart_number_manual preserving type ) AS PPSSmartNumberHeaderIsManual,
  cast( PPSPurchaseOrderDescription as pps_e_po_description preserving type ) AS PPSPurchaseOrderDescription,
  PPSPurgDocClassfctnCode,
  _Classification.PPSPurgDocClassfctnTxt AS PPSPurgDocClassfctnTxt,
  PPSFuturePostingDate,
  Language,
  / _WorkflowDetail.PPSPurgDocApprovalStatusText AS PPSPurgDocApprovalStatusText,
  _WorkflowDetail.PPSPurgDocApprovalStatus AS PPSPurgDocApprovalStatus,
  _WorkflowDetail.PPSPurgDocApprovalDate AS PPSPurOrderApprovalDate,
  cast( 0 as mm_pur_order_tot_net_amount ) AS PurchaseOrderNetAmount,
  cast ( '' as abap.char( 256 ) ) AS PPSVersionTypeText,
  cast ( 0 as abap.int4 ) AS NumberOfPurchaseOrderItems,
  cast( '' as ebeln ) AS PPSChangeVersionDocumentNumber,
  cast( '' as boolean_flg) AS PPSChgVersionIsAvailable,
  cast( '' as boolean_flg) AS UICT_HideExchangeRate,
  cast( '' as boolean_flg) AS UICT_HideFixedExchangeRate,
  cast( '' as boolean_flg) AS UICT_HideOptValHeaderFacet,
  cast( '' as boolean_flg) AS UICT_HidePartnerExt
FROM R_PPS_PurOrdVersionHistory
LEFT OUTER JOIN C_PPS_PurOrdVersionHistory AS _VersionHistory ON ActivePurchasingDocument = _VersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN I_PurContrVersionType AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
LEFT OUTER JOIN C_PPS_PurOrdDocTotalOptional AS _OptionalDocumentTotal ON PurchaseOrder = _OptionalDocumentTotal.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurOrderItemHierarchyTP AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurchaseOrderPartnerTP AS _PurchaseOrderPartner ON PurchaseOrder = _PurchaseOrderPartner.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurchaseOrderContactTP AS _PurchaseOrderContact ON PurchaseOrder = _PurchaseOrderContact.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PaymentTerm AS _PaymentTerm ON PaymentTerms = _PaymentTerm.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_PPS_SupplierDetail AS _SupplierDetail ON Supplier = _SupplierDetail.Supplier  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurOrderHdrNvtnPartnerTP AS _PurOrdPartnerExtension ON ActivePurchasingDocument = _PurOrdPartnerExtension.PurchasingDocument  -- association [0..*]
;