C_PPS_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 C_PPS_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.

CREATE VIEW C_PPS_PurContrVersionHistory AS
SELECT
  PurchaseContract,
  PurchaseContractType,
  PurchasingDocumentCategory,
  Supplier,
  _PurchaseContract._Supplier.SupplierName AS SupplierName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  PurContractConsumptionInPct,
  ContractConsumptionInPct,
  PurContrConsumptionUnit,
  PurContrHasAdvncdUsrInterface,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  DocumentCurrency,
  IncotermsClassification,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  PurchasingDocumentDeletionCode,
  SupplierAddressID,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  ReleaseIsNotCompleted,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  _PurchaseContractTypeVH.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingDocumentName,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  LastChangeDateTime,
  PurchasingProcessingStatus,
  _PurchaseContractStatus.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  IsEndOfPurposeBlocked,
  ActivePurchasingDocument,
  PurgDocChangeRequestStatus,
  PurchasingDocumentVersion,
  PurgDocIsChgVers,
  PurgAggrgdProdCmplncSuplrSts,
  CreatedByUser,
  _UserDetails.PersonFullName AS UserDescription,
  CreationDate,
  CreationTime,
  cast( ( dats_tims_to_tstmp( CreationDate, CreationTime, 'UTC', $session.client, 'NULL' ) ) as timestamp ) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  PurchasingDocVersionReasonCode,
  _VersionReasonVH.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  PurchasingDocVersionStatus,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentOrigin,
  CreatedByUserName,
  _PurchaseContract.PPSDocumentIsNovated AS PPSDocumentIsNovated,
  _PurchaseContractHdrExtension.PPSRevisionComment AS PPSRevisionComment,
  PurgHasCatalogRelevantItems,
  ProcessingStatusCriticality,
  _PurchaseContractHdrExtension.PPSModificationType AS PPSModificationType,
  _PurchaseContractHdrExtension.PPSNumberOfModification AS PPSNumberOfModification,
  _PurchaseContract.PPSPurgDocClassfctnCode AS PPSPurgDocClassfctnCode,
  _PurchaseContract._Classification.PPSPurgDocClassfctnTxt AS PPSPurgDocClassfctnTxt,
  _PurchaseContractHdrExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseContractHdrExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  PPSPurgDocApprovalStatusText,
  PPSPurContractApprovalDate,
  _PurchaseContractHdrExtension.PPSPricingArrangementType AS PPSPricingArrangementType,
  _PurchaseContractHdrExtension._PriceArrangementText.PPSPricingArrangementTypeText AS PPSPricingArrangementTypeText,
  _PurchaseContract._InterestCalCodeText.InterestCalculationCodeName AS InterestCalculationCodeName,
  _PurchaseContract.InterestCalculationCode AS InterestCalculationCode,
  _PurchaseContract.DownPaymentAmount AS DownPaymentAmount,
  _PurchaseContract.DownPaymentDueDate AS DownPaymentDueDate,
  _PurchaseContract.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  _PurchaseContract.DownPaymentType AS DownPaymentType,
  _PurchaseContract.PPSPurContrHasDwnPaytInAmt AS PPSPurContrHasDwnPaytInAmt,
  _PurchaseContract.RetentionType AS RetentionType,
  _PurchaseContract.PurgDocHdrInvcRtntnPct AS PurgDocHdrInvcRtntnPct,
  _PurchaseContractHdrExtension.PPSPurContrHierRelOrdLimitAmt AS PPSPurContrHierRelOrdLimitAmt,
  _PurchaseContractHdrExtension.PPSPurContrHierCnsmpnThldPct AS PPSPurContrHierCnsmpnThldPct,
  cast( '' as ebeln ) AS PPSChangeVersionDocumentNumber,
  cast( '' as boolean_flg) AS PPSChgVersionIsAvailable,
  PPSPurContrHeaderStatus,
  _PurContrStatusText.PurchasingDocumentStatusName AS PPSPurContrHeaderStatusText,
  cast ( '' as mmpur_bool ) AS PurContrIsConfidential,
  cast ( '' as pps_e_version_type_text ) AS PPSVersionTypeText,
  cast( '' as mmpur_bool) AS UICT_HideModificationType,
  cast( '' as boolean) AS UICT_HideSmartNumberHeader,
  cast ( 0 as abap.int4) AS NumberOfPurContrItm,
  cast( '' as mmpur_bool) AS UICT_HideVersionReasonCode,
  cast( '' as boolean) AS UICT_isNovated,
  cast( '' as vzskz) AS UICT_InterestCalculationCode,
  cast( '' as mmpur_bool) AS UICT_HideRetentionhdrpct,
  cast( '' as mmpur_bool) AS UICT_IsRetentionEnabled,
  cast( '' as mmpur_bool) AS UICT_HideHdrDownPaymentAmount,
  cast( ' ' as mmpur_bool) AS UICT_HideHdrDownPaymentPct,
  cast( ' ' as mmpur_bool) AS UICT_HideDownPaymentFields,
  cast( ' ' as mmpur_bool) AS UICT_HideHdrDownPaymentFacet,
  _PurchaseContract._Classification AS _Classification
FROM R_PPS_PurContrVersionHistory
LEFT OUTER JOIN C_PPS_PurContrVersionHistory AS _VersionHistory ON ActivePurchasingDocument = _VersionHistory.ActivePurchasingDocument  -- association [1..*]
LEFT OUTER JOIN R_PPS_PurchaseContractTP AS _PurchaseContract ON ActivePurchasingDocument = _PurchaseContract.ActivePurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_Purchasecontracttype_Vh AS _PurchaseContractTypeVH ON PurchaseContractType = _PurchaseContractTypeVH.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserVH AS _UserDetails ON CreatedByUser = _UserDetails.UserID  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractStatus AS _PurchaseContractStatus ON PurchasingProcessingStatus = _PurchaseContractStatus.PurchasingProcessingStatus AND _PurchaseContractStatus.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_PPS_PurContrHdrCndnValdtyTP AS _PurchaseContractHeaderPricing ON PurchaseContract = _PurchaseContractHeaderPricing.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_PPS_PurContrHdrCndnAmtTP AS _PurchaseContractAmount ON PurchaseContract = _PurchaseContractAmount.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_PPS_PurContractItemHierTP AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurContractContactTP AS _PurchaseContractContact ON PurchaseContract = _PurchaseContractContact.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurContractPartnerTP AS _PurContrPartner ON PurchaseContract = _PurContrPartner.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PPS_PurgDocVersionReasonVH AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN I_PurContrVersionType AS _VersionType ON PurgDocChangeRequestStatus = _VersionType.PurgDocChangeRequestStatus  -- association [1..1]
LEFT OUTER JOIN C_PPS_PaymentTerm AS _PaymentTerm ON PaymentTerms = _PaymentTerm.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurContrDocTotOptnl AS _OptionalDocumentTotal ON PurchaseContract = _OptionalDocumentTotal.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PPS_SupplierDetail AS _SupplierData ON Supplier = _SupplierData.Supplier  -- association [0..1]
LEFT OUTER JOIN C_PPS_PurContrHdrNvtnPartnerTP AS _PurContrPartnerExtension ON PurchaseContract = _PurContrPartnerExtension.PurchaseContract  -- association [0..*]
;