I_CentralPurchaseOrderTP

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 I_CentralPurchaseOrderTP.
-- 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: ICPURORDTP

CREATE VIEW I_CentralPurchaseOrderTP AS
SELECT
  Document.PurchaseOrder AS PurchaseOrder,
  Document.ExtSourceSystem AS ExtSourceSystem,
  PurchasingDocumentCategory,
  Document.PurchaseOrderType AS PurchaseOrderType,
  Document.PurchaseOrderSubtype AS PurchaseOrderSubtype,
  Document.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  Document.CreatedByUser AS CreatedByUser,
  Document.CreatedByUserName AS CreatedByUserFullName,
  Document.CreationDate AS CreationDate,
  Document.PurchaseOrderDate AS PurchaseOrderDate,
  Document.ValidityStartDate AS ValidityStartDate,
  Document.ValidityEndDate AS ValidityEndDate,
  Document.Language AS Language,
  Document.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Document.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  Document.PurchasingProcessingStatus AS PurchasingProcessingStatus,
  Document.PurchasingCompletenessStatus AS PurchasingCompletenessStatus,
  Document.CompanyCode AS CompanyCode,
  Document.CompanyCodeCountry AS CompanyCodeCountry,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingGroup AS PurchasingGroup,
  Document.Supplier AS Supplier,
  Document.SupplierRespSalesPersonName AS SupplierRespSalesPersonName,
  Document.SupplierPhoneNumber AS SupplierPhoneNumber,
  Document.SupplyingSupplier AS SupplyingSupplier,
  Document.SupplyingPlant AS SupplyingPlant,
  Document.InvoicingParty AS InvoicingParty,
  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.IncotermsClassification AS IncotermsClassification,
  Document.IncotermsTransferLocation AS IncotermsTransferLocation,
  Document.IncotermsVersion AS IncotermsVersion,
  Document.IncotermsLocation1 AS IncotermsLocation1,
  Document.IncotermsLocation2 AS IncotermsLocation2,
  Document.IsIntrastatReportingRelevant AS IsIntrastatReportingRelevant,
  Document.IsIntrastatReportingExcluded AS IsIntrastatReportingExcluded,
  Document.DeliveryDocumentCondition AS DeliveryDocumentCondition,
  Document.PricingProcedure AS PricingProcedure,
  Document.DocumentCurrency AS DocumentCurrency,
  Document.ExchangeRate AS ExchangeRate,
  Document.AbsoluteExchangeRate AS AbsoluteExchangeRate,
  Document.ExchRateIsIndirectQuotation AS ExchRateIsIndirectQuotation,
  Document.EffectiveExchangeRate AS EffectiveExchangeRate,
  cast(Document.ExchangeRate as abap.char( 12 )) AS ExchangeRateForEdit,
  Document.ExchangeRateIsFixed AS ExchangeRateIsFixed,
  Document.LastChangeDateTime AS LastChangeDateTime,
  Document.ProcmtHubLastExtractionTime AS ProcmtHubLastExtractionTime,
  Document.ManualSupplierAddressID AS ManualSupplierAddressID,
  Document.HasNote AS HasNote,
  Document.HasAttachment AS HasAttachment,
  Document.NumberOfOverduePurOrders AS NumberOfOverduePurOrders,
  Document.NumberOfOverduePurOrdItm AS NumberOfOverduePurOrdItm,
  Document.PurchaseOrderStatus AS PurchaseOrderStatus,
  Document.PurchaseOrderStatusName AS PurchaseOrderStatusName,
  Document.ApproverUser AS ApproverUser,
  Document.ApproverName AS ApproverName,
  Document.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  Document.PurOrdOutputCtrlType AS PurOrdOutputCtrlType,
  Document.PurchaseOrderOutputStatus AS PurchaseOrderOutputStatus,
  Document.PurchaseOrderOutputStatusName AS PurchaseOrderOutputStatusName,
  Document.PurchaseOrderOutputDateTime AS PurchaseOrderOutputDateTime,
  Document.WeightedRelevance AS WeightedRelevance,
  Document.PurchaseOrderOutputIndCode AS PurchaseOrderOutputIndCode,
  Document.PurchaseOrderOutputIndDesc AS PurchaseOrderOutputIndDesc,
  IsEndOfPurposeBlocked
FROM I_CentralPurchaseOrder AS Document
LEFT OUTER JOIN I_CentralPurchaseOrderItemTP AS _PurchaseOrderItemTP ON _PurchaseOrderItemTP.PurchaseOrder = PurchaseOrder AND _PurchaseOrderItemTP.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_User AS _User ON _User.UserID = CreatedByUser  -- association [0..1]
;