P_PurchaseContractWithDraft

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 P_PurchaseContractWithDraft.
-- 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: PPURCHASECTRWD

CREATE VIEW P_PurchaseContractWithDraft AS
SELECT
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) AS PurchaseContractDraftUUID,
  ActiveDocument.PurchaseContract AS ActivePurchaseContract,
  ActiveDocument.PurchaseContract AS PurchaseContract,
  ActiveDocument.PurchaseContractType AS PurchaseContractType,
  ActiveDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  ActiveDocument.CreationDate AS CreationDate,
  ActiveDocument.Supplier AS Supplier,
  ActiveDocument.CompanyCode AS CompanyCode,
  ActiveDocument.PurchasingOrganization AS PurchasingOrganization,
  ActiveDocument.PurchasingGroup AS PurchasingGroup,
  ActiveDocument.DocumentCurrency AS DocumentCurrency,
  ActiveDocument.IncotermsClassification AS IncotermsClassification,
  ActiveDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  ActiveDocument.PaymentTerms AS PaymentTerms,
  ActiveDocument.CashDiscount1Days AS CashDiscount1Days,
  ActiveDocument.CashDiscount2Days AS CashDiscount2Days,
  ActiveDocument.NetPaymentDays AS NetPaymentDays,
  ActiveDocument.CashDiscount1Percent AS CashDiscount1Percent,
  ActiveDocument.CashDiscount2Percent AS CashDiscount2Percent,
  ActiveDocument.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  ActiveDocument.ValidityStartDate AS ValidityStartDate,
  ActiveDocument.ValidityEndDate AS ValidityEndDate,
  ActiveDocument.ReleaseCode AS ReleaseCode,
  ActiveDocument.CreatedByUser AS CreatedByUser,
  ActiveDocument.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  ActiveDocument.SupplierAddressID AS SupplierAddressID,
  ActiveDocument.SupplyingSupplier AS SupplyingSupplier,
  ActiveDocument.InvoicingParty AS InvoicingParty,
  ActiveDocument.ExchangeRate AS ExchangeRate,
  ActiveDocument.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  ActiveDocument.QuotationSubmissionDate AS QuotationSubmissionDate,
  ActiveDocument.SupplierQuotation AS SupplierQuotation,
  ActiveDocument.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  ActiveDocument.CorrespncExternalReference AS CorrespncExternalReference,
  ActiveDocument.CorrespncInternalReference AS CorrespncInternalReference,
  ActiveDocument.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  ActiveDocument.SupplierPhoneNumber AS SupplierPhoneNumber,
  ActiveDocument.IncotermsVersion AS IncotermsVersion,
  ActiveDocument.IncotermsLocation1 AS IncotermsLocation1,
  ActiveDocument.IncotermsLocation2 AS IncotermsLocation2,
  ActiveDocument.PurchasingDocumentName AS PurchasingDocumentName,
  DraftDocument.purchasecontractdraftuuid AS DraftAdministrativeDataUUID,
  DraftDocument.ctrtmplrefguid AS ChangeRecordReferenceUUID,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  cast( ' ' as sdraft_has_active preserving type ) AS HasActiveEntity,
  cast( ' ' as sdraft_has_draft preserving type ) AS HasDraftEntity
FROM I_PurchaseContract AS ActiveDocument
LEFT OUTER JOIN purchasectr_d AS DraftDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_DraftAdministrativeData ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): purchasectr_d
;