C_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_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.
-- SQL view name: CPURCTRVERSHIST

CREATE VIEW C_PurContrVersionHistory AS
SELECT
  PurchaseContract,
  ActivePurchasingDocument,
  PurchaseContractType,
  PurchasingDocumentVersion,
  PurchasingProcessingStatus,
  _VersionType.ChangeRequestNote AS ChangeRequestNote,
  CreatedByUser,
  _UserDetails.UserDescription AS CreatedByUserDescription,
  CreationDate,
  _VersionReasonVH.PurchasingDocVersionReasonText AS PurchasingDocVersionReasonText,
  cast( '' as abap.char( 20 ) ) AS PurchasingDocVersionStatusText,
  PurchasingDocumentCategory,
  _PurchaseContractTypeVH.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  Supplier,
  CompanyCode,
  _CompanyCodeValueHelp.CompanyCodeName AS CompanyCodeName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  DocumentCurrency,
  DocumentCurrency AS Currency,
  IncotermsClassification,
  _IncotermsClassificationText.IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsTransferLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseContractTargetAmount,
  ValidityStartDate,
  ValidityEndDate,
  ReleaseCode,
  PurchasingDocVersionReasonCode,
  PurchasingDocumentDeletionCode,
  SupplierAddressID,
  SupplyingSupplier,
  InvoicingParty,
  ExchangeRate,
  ExchangeRateIsFixed,
  QuotationSubmissionDate,
  SupplierQuotation,
  CorrespncExternalReference,
  CorrespncInternalReference,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  IncotermsVersion,
  _PurCtrTermVersion.IncotermsVersionName AS IncotermsVersionName,
  IncotermsLocation1,
  cast( ' ' as tminco_loc_1_id ) AS IncotermsLocation1Identifier,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsLocation2,
  cast( ' ' as tminco_loc_2_id ) AS IncotermsLocation2Identifier,
  IncotermsSupChnLoc2AddlUUID,
  cast( ' ' as tminco_loc_d_descr ) AS IncotermsDvtgLocDescription,
  cast( ' ' as tminco_loc_d_id ) AS IncotermsDvtgLocIdentifier,
  IncotermsSupChnDvtgLocAddlUUID,
  PurchasingDocumentName,
  PurchasingDocumentOrigin,
  ReleaseIsNotCompleted,
  _PurchaseContractStatus.PurchasingProcessingStatusName AS PurchasingProcessingStatusName,
  cast( '' as mm_approver_name ) AS ApproverName,
  cast( 0 as mmpur_approver_count ) AS PurchaseContrNumberOfApprovers,
  CreatedByUserName,
  _PurchaseContractExtReference.PurgDocExternalReference AS PurgDocExternalReference,
  _PurchaseContractExtReference.PurgOutlineAgrmtExtSystID AS PurgOutlineAgrmtExtSystID,
  cast( '' as boolean) AS IsLglTransIntegEnabled,
  _PaymentTermsText[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  IsEndOfPurposeBlocked,
  _DocumentCurrencyText.CurrencyName AS CurrencyName,
  _PurgTotProdCmplncSuplrStsT.PurgTotProdCmplncSuplrStsName AS PurgTotProdCmplncSuplrStsName,
  PurgAggrgdProdCmplncSuplrSts,
  cast ('' as abap.char( 1 ) ) AS UICT_PurgAggrgdCmplncSuplrSts,
  cast ('' as ehfnd_boolean) AS ProductComplianceIsActive,
  cast ('' as ehfnd_bf_pcs_is_active) AS BusFtreProdCmplncSuplrIsActive,
  cast( '' as matnr ) AS Material,
  cast( '' as matkl ) AS MaterialGroup,
  cast( '' as producttype ) AS ProductType,
  cast( '' as mmpur_ctr_d_rework_ind ) AS PurContrIsApplicableForRework,
  cast ('' as boolean) AS SrvcProcmtItmHierIsEnbld,
  cast ('' as boolean) AS PurContrCatalogItemIsEnbld,
  PurgHasCatalogRelevantItems,
  PurgDocChangeRequestStatus,
  _PurContrCnsmpnInPercentage.ContractConsumptionInPct AS ContractConsumptionInPct,
  PurgDocIsChgVers,
  cast( ' ' as boolean) AS PurchasingItemHasHierarchy
FROM I_PurContrVersionHistory AS VersionHistory
LEFT OUTER JOIN I_Purchasecontracttype_Vh AS _PurchaseContractTypeVH ON PurchaseContractType = _PurchaseContractTypeVH.PurchasingDocumentType  -- association [1..1]
LEFT OUTER JOIN I_PurchaseContractStatus AS _PurchaseContractStatus ON PurchasingProcessingStatus = _PurchaseContractStatus.PurchasingProcessingStatus  -- association [1..*]
LEFT OUTER JOIN I_PurchaseContractExtReference AS _PurchaseContractExtReference ON PurchaseContract = _PurchaseContractExtReference.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurgTotProdCmplncSuplrStsT AS _PurgTotProdCmplncSuplrStsT ON PurgAggrgdProdCmplncSuplrSts = _PurgTotProdCmplncSuplrStsT.PurgAggrgdProdCmplncSuplrSts AND _PurgTotProdCmplncSuplrStsT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_SupplierPurchOrgVH AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_MM_CompanyCodeValueHelp AS _CompanyCodeValueHelp ON _CompanyCodeValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurCtrIncoVersion AS _PurCtrTermVersion ON IncotermsVersion = _PurCtrTermVersion.IncotermsVersion  -- association [1..1]
LEFT OUTER JOIN C_PurContrHdrCndnValdtyTP AS _PurContrHdrCndnValdtyTP ON PurchaseContract = _PurContrHdrCndnValdtyTP.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_ContractMaintainItem AS _PurchaseContractItemTP ON PurchaseContract = _PurchaseContractItemTP.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN C_LegalTransactionIntegFacet AS _LegalTransaction ON _LegalTransaction.LglCntntMLinkdObj = PurchaseContract AND _LegalTransaction.LglCntntMIntegrationLink = 'PC'  -- association [0..*]
LEFT OUTER JOIN C_PurgDocVersionReasonValHelp AS _VersionReasonVH ON PurchasingDocVersionReasonCode = _VersionReasonVH.PurchasingDocVersionReasonCode  -- association [0..1]
LEFT OUTER JOIN C_Contractnotes AS _PurCtrNotesWD ON PurchaseContract = _PurCtrNotesWD.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PurCtrPartners AS _PurCtrPartnersWithDraft ON PurchaseContract = _PurCtrPartnersWithDraft.PurchaseContract  -- association [0..*]
LEFT OUTER JOIN C_PurchaseContrItemHierarchyTP AS _PurchaseContrItemHierarchyTP ON PurchaseContract = _PurchaseContrItemHierarchyTP.PurchaseContract  -- association [1..*]
LEFT OUTER JOIN I_PurContrCnsmpnInPercentage AS _PurContrCnsmpnInPercentage ON ActivePurchasingDocument = _PurContrCnsmpnInPercentage.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseContractExten ON PurchaseContract = _PurchaseContractExten.PurchasingDocument  -- association [1..1]
;