P_PurchaseContract

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_PurchaseContract.
-- 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: PPURCTR

CREATE VIEW P_PurchaseContract AS
SELECT
  Document.PurchaseContract AS PurchaseContract,
  Document.PurchaseContract AS PurchaseContractForEdit,
  Document.PurchaseContractType AS PurchaseContractType,
  Document.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  Document.CreationDate AS CreationDate,
  Document.Supplier AS Supplier,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.PaymentTerms AS PaymentTerms,
  Document.CashDiscount1Days AS CashDiscount1Days,
  Document.CashDiscount2Days AS CashDiscount2Days,
  Document.NetPaymentDays AS NetPaymentDays,
  Document.CashDiscount1Percent AS CashDiscount1Percent,
  Document.CashDiscount2Percent AS CashDiscount2Percent,
  Document.PurchaseContractTargetAmount AS PurchaseContractTargetAmount,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.ReleaseCode AS ReleaseCode,
  Document.CreatedByUser AS CreatedByUser,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.SupplierAddressID AS SupplierAddressID,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.InvoicingParty AS InvoicingParty,
  Document.ExchangeRate AS ExchangeRate,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.QuotationSubmissionDate AS QuotationSubmissionDate,
  Document.SupplierQuotation AS SupplierQuotation,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.CorrespncExternalReference AS CorrespncExternalReference,
  Document.CorrespncInternalReference AS CorrespncInternalReference,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.IncotermsSupChnLoc1AddlUUID AS IncotermsSupChnLoc1AddlUUID,
  Document.IncotermsSupChnLoc2AddlUUID AS IncotermsSupChnLoc2AddlUUID,
  Document.IncotermsSupChnDvtgLocAddlUUID AS IncotermsSupChnDvtgLocAddlUUID,
  Document.PurchasingDocumentName AS PurchasingDocumentName,
  Document.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  cast('X' as sdraft_is_active preserving type ) AS IsActiveEntity,
  Document.PurgAggrgdProdCmplncSuplrSts AS PurgAggrgdProdCmplncSuplrSts,
  Document.PurgAggrgdProdMarketabilitySts AS PurgAggrgdProdMarketabilitySts,
  Document.PurgAggrgdSftyDataSheetStatus AS PurgAggrgdSftyDataSheetStatus,
  Document.PurgProdCmplncTotDngrsGoodsSts AS PurgProdCmplncTotDngrsGoodsSts
FROM I_PurchaseContract AS Document
;