C_PPS_PurOrdVersionHistory_2

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_2.
-- 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_2 AS
SELECT
  PurchaseOrder,
  PurchaseOrderType,
  _PurchaseOrderTypeText.PurchasingDocumentTypeName AS PurchaseOrderTypeName,
  PurchaseOrderDate,
  Supplier,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  DocumentCurrency,
  PaymentTerms,
  _PaymentTerms._Text[ 1: Language = $session.system_language ].PaymentTermsName AS PaymentTermsName,
  _InterestCalCode._Text[1: Language = $session.system_language].InterestCalculationCodeName AS InterestCalculationCodeName,
  InterestCalculationCode,
  cast( DownPaymentType as pps_e_po_downpaymenttype preserving type ) AS DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  PPSDocumentCurrency,
  cast( DownPaymentDueDate as pps_e_po_downpaymentduedate preserving type ) AS DownPaymentDueDate,
  _DownPaymentIndicatorText.DownPaymentTypeName AS DownPaymentTypeName,
  RetentionType,
  _RetentionType.PPSHdrRetentionTypeText AS PPSHdrRetentionTypeText,
  PurgDocHdrInvcRtntnPct,
  QuotationSubmissionDate,
  SupplierQuotationExternalID,
  LastChangeDateTime,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  IncotermsClassification,
  IncotermsLocation1,
  ActivePurchasingDocument,
  PurgDocChangeRequestStatus,
  PurchasingDocumentVersion,
  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,
  PurchasingDocVersionReasonCode,
  _VersionReasonValHelp.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  _Supplier.SupplierName AS SupplierName,
  cast( _SupplierCurrency.PurchaseOrderCurrency as pps_e_po_source_currency preserving type ) AS PPSSupplierCurrency,
  cast( PPSSmartNumberHeaderIsManual as pps_e_is_smart_number_manual preserving type ) AS PPSSmartNumberHeaderIsManual,
  cast( PPSPurchaseOrderDescription as pps_e_purchase_order_desc preserving type ) AS PPSPurchaseOrderDescription,
  _Classification.PPSPurgDocClassfctnTxt AS PPSPurgDocClassfctnTxt,
  PPSFuturePostingDate,
  Language,
  / _WorkflowDetail.PPSPurgDocApprovalStatusText AS PPSPurgDocApprovalStatusText,
  _WorkflowDetail.PPSPurgDocApprovalStatus AS PPSPurgDocApprovalStatus,
  cast( _WorkflowDetail.PPSPurgDocApprovalDate as pps_e_purch_doc_approval_date preserving type ) AS PPSPurOrderApprovalDate,
  cast( 0 as mm_pur_order_tot_net_amount ) AS PurchaseOrderNetAmount,
  cast ( '' as pps_e_version_type_text ) 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_HideOptValHeaderFacet,
  cast( '' as boolean_flg) AS UICT_HidePartnerExt,
  cast( '' as boolean_flg) AS UICT_HideItmPrtnRef,
  cast( '' as boolean_flg) AS UICT_PPSIsInterestEnabled,
  cast( '' as boolean_flg) AS UICT_HideDirectOrder,
  cast( '' as boolean_flg) AS UICT_HidePriceArrngButton,
  cast( '' as boolean_flg) AS UICT_HideDownpaymentfields,
  cast( '' as boolean_flg) AS UICT_HideRetentionhdrpct,
  cast( '' as boolean_flg) AS UICT_HideRetention,
  cast( '' as boolean_flg) AS UICT_PPSExtPubgSystIsHidden,
  cast( '' as boolean_flg) AS UICT_PPSExtPubgSystIsEnabled,
  cast( '' as boolean_flg) AS PPSPurOrdNvtnPartnerFacetIsHdn,
  cast('' as boolean_flg) AS PPSRevisionCommentIsHidden
FROM R_PPS_PurOrdVersionHistory
LEFT OUTER JOIN C_PPS_PurOrdVersionHistory_2 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_2 AS _PurOrdDocTotalOptional ON PurchaseOrder = _PurOrdDocTotalOptional.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurOrdItemHierarchy AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurchaseOrderPartnerTP_2 AS _PurchaseOrderPartner ON PurchaseOrder = _PurchaseOrderPartner.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurchaseOrderContactTP_2 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_PurOrdHdrNvtnPartnerTP_2 AS _PurOrdPartnerExtension ON ActivePurchasingDocument = _PurOrdPartnerExtension.PurchasingDocument  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurOrdVersHistItmPrtnRef AS _PurOrdVersHistItmPrtnRef ON PurchaseOrder = _PurOrdVersHistItmPrtnRef.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN C_PPS_POVersHistNvtnItmPrtnRef AS _POVersHistItmNvtnPrtnRef ON PurchaseOrder = _POVersHistItmNvtnPrtnRef.PurchasingDocument  -- association [0..*]
;