I_PurOrdHistDeliveryCostAPI01

DDL: I_PURORDHISTDELIVERYCOSTAPI01 SQL: IMMPURORDHDCAP01 Type: view COMPOSITE

Purchase Order History Delivery Cost

I_PurOrdHistDeliveryCostAPI01 (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

I_PurOrdHistDeliveryCostAPI01 is a Composite CDS View that provides data about "Purchase Order History Delivery Cost" in SAP S/4HANA. It reads from 1 data source (R_PurOrdHistoryDeliveryCost) and exposes 37 fields with key fields PurchaseOrder, PurchaseOrderItem, PricingProcedureStep, PricingProcedureCounter, PurchasingHistoryDocumentType. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Purchase Orders
Purpose
This CDS view helps retrieve the transactions that have occurred referring to the delivery costs of a purchase order. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: Purchasing Document Type Purchasing Organization Purchasing Group Plant You can use the Display Restriction Types app to find out in which business catalogs these restriction types are included.

Structure
Important fields in this view include the following: Field Name Description PurchaseOrder Purchase order number PurchaseOrderItem Item number in purchase order PricingProcedureStep Step number PricingProcedureCounter Condition counter PurchasingHistoryDocumentType Transaction/event type, purchase order history PurchasingHistoryDocumentYear Fiscal year PurchasingHistoryDocument Document number of an accounting document PurchasingHistoryDocumentItem Item in material document PurchasingHistoryCategory Purchase order history category PostingDate Posting date in the document Quantity Quantity PurOrdAmountInCompanyCodeCrcy Amount in local (company code)currency PurchaseOrderAmount Amount in document currency Currency Currency key (purchase order currency) GRIRAcctClrgAmtInCoCodeCrcy GR/IR account clearing value in local currency DebitCreditCode Debit/credit indicator DocumentReferenceID Reference document number Supplier Supplier PurgHistDocumentCreationDate Day on which accounting document was entered PurgHistDocumentCreationTime Time of entry InvoiceAmtInCoCodeCrcy Invoice value entered (in local -company code- currency) InvoiceAmountInFrgnCurrency Invoice value in foreign currency InventoryValuationType Valuation type ConditionType Condition type QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit GRIRAcctClrgAmtInTransacCrcy Clearing value on GR/IR clearing account (transactional currency) CreatedByUser Name of person responsible for creating the object GRIRAcctClrgAmtInOrdTrnsacCrcy Clearing value on GR/IR account in purchase order currency InvoiceAmtInPurOrdTransacCrcy Invoice amount in purchase order currency ExchangeRateDifferenceAmount Exchange rate difference amount ExchangeRate Exchange rate OrderPriceUnit Order price unit (purchasing) OderQuantityUnit Purchase order unit of measure DocumentCurrency Currency key (document currency) CompanyCodeCurrency Currency key (company code - local currency) Note Depending on your configuration, some of the fields included in this CDS view may not expose any data.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-PO
CapabilitiesData Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
R_PurOrdHistoryDeliveryCost HistoryDeliveryCost from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderAPI01 _PurchaseOrder HistoryDeliveryCost.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[1..1] I_PurchaseOrderItemAPI01 _PurchaseOrderItem HistoryDeliveryCost.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder and HistoryDeliveryCost.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (14)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IMMPURORDHDCAP01 view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #NONE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Purchase Order History Delivery Cost view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document Number
KEY PurchaseOrderItem PurchaseOrderItem Item Number of Purchasing Document
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
KEY PurchasingHistoryDocumentType PurchasingHistoryDocumentType Transaction/event type, purchase order history
KEY PurchasingHistoryDocumentYear PurchasingHistoryDocumentYear Fiscal Year
KEY PurchasingHistoryDocument PurchasingHistoryDocument Document Number of an Accounting Document
KEY PurchasingHistoryDocumentItem PurchasingHistoryDocumentItem Item in Material Document
PurchasingHistoryCategory PurchasingHistoryCategory Purchase Order History Category
PostingDate PostingDate Posting Date in the Document
Quantity Quantity Quantity
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
PurchaseOrderAmount PurchaseOrderAmount Amount in Document Currency
Currency Currency Valuation Crcy
GRIRAcctClrgAmtInCoCodeCrcy GRIRAcctClrgAmtInCoCodeCrcy GR/IR account clearing value in local currency
DebitCreditCode DebitCreditCode Debit/Credit Indicator
DocumentReferenceID DocumentReferenceID Reference Document Number
Supplier R_PurOrdHistoryDeliveryCost Supplier Supplier
PurgHistDocumentCreationDate PurgHistDocumentCreationDate Day On Which Accounting Document Was Entered
PurgHistDocumentCreationTime PurgHistDocumentCreationTime Time of Entry
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
InvoiceAmountInFrgnCurrency InvoiceAmountInFrgnCurrency Invoice Value in Foreign Currency
InventoryValuationType InventoryValuationType Valuation Type
ConditionType ConditionType Condition type
QtyInPurchaseOrderPriceUnit QtyInPurchaseOrderPriceUnit Quantity in Purchase Order Price Unit
GRIRAcctClrgAmtInTransacCrcy GRIRAcctClrgAmtInTransacCrcy Clearing value on GR/IR clearing account (transac. currency)
CreatedByUser CreatedByUser Name of Person Responsible for Creating the Object
GRIRAcctClrgAmtInOrdTrnsacCrcy GRIRAcctClrgAmtInOrdTrnsacCrcy Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy InvoiceAmtInPurOrdTransacCrcy Invoice Amount in PO Currency
ExchangeRateDifferenceAmount ExchangeRateDifferenceAmount Exchange Rate Difference Amount
ExchangeRate ExchangeRate Exchange rate
OrderPriceUnit OrderPriceUnit Order Price Unit (Purchasing)
OrderQuantityUnit OrderQuantityUnit Purchase Order Unit of Measure
DocumentCurrency DocumentCurrency Document Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
_PurchaseOrder _PurchaseOrder
_PurchaseOrderItem _PurchaseOrderItem

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_PurOrdHistDeliveryCostAPI01.
-- 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: IMMPURORDHDCAP01

CREATE VIEW I_PurOrdHistDeliveryCostAPI01 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  PurchasingHistoryDocumentType,
  PurchasingHistoryDocumentYear,
  PurchasingHistoryDocument,
  PurchasingHistoryDocumentItem,
  PurchasingHistoryCategory,
  PostingDate,
  Quantity,
  PurOrdAmountInCompanyCodeCrcy,
  PurchaseOrderAmount,
  Currency,
  GRIRAcctClrgAmtInCoCodeCrcy,
  DebitCreditCode,
  DocumentReferenceID,
  HistoryDeliveryCost.Supplier AS Supplier,
  PurgHistDocumentCreationDate,
  PurgHistDocumentCreationTime,
  InvoiceAmtInCoCodeCrcy,
  InvoiceAmountInFrgnCurrency,
  InventoryValuationType,
  ConditionType,
  QtyInPurchaseOrderPriceUnit,
  GRIRAcctClrgAmtInTransacCrcy,
  CreatedByUser,
  GRIRAcctClrgAmtInOrdTrnsacCrcy,
  InvoiceAmtInPurOrdTransacCrcy,
  ExchangeRateDifferenceAmount,
  ExchangeRate,
  OrderPriceUnit,
  OrderQuantityUnit,
  DocumentCurrency,
  CompanyCodeCurrency
FROM R_PurOrdHistoryDeliveryCost AS HistoryDeliveryCost
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON HistoryDeliveryCost.PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON HistoryDeliveryCost.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND HistoryDeliveryCost.PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;