R_PurOrdHistoryDeliveryCost

DDL: R_PURORDHISTORYDELIVERYCOST SQL: RMMPURPOHISTDLVC Type: view COMPOSITE Package: VDM_MM_PUR_PO
37 Fields 2 Data Sources 2 Associations

Purchase Order History Delivery Cost

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

Data Sources (2)

SourceAliasJoin Type
R_PurgDocHistoryDeliveryCost HistoryDeliveryCost from
R_PurchaseOrder PurchaseOrder inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrder _PurchaseOrder HistoryDeliveryCost.PurchasingDocument = _PurchaseOrder.PurchaseOrder
[1..1] R_PurchaseOrderItem _PurchaseOrderItem HistoryDeliveryCost.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder and HistoryDeliveryCost.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem

Annotations (12)

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

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder R_PurgDocHistoryDeliveryCost PurchasingDocument Purchasing Document
KEY PurchaseOrderItem R_PurgDocHistoryDeliveryCost PurchasingDocumentItem Purchasing Doc. Item
KEY PricingProcedureStep R_PurgDocHistoryDeliveryCost PricingProcedureStep Step Number
KEY PricingProcedureCounter R_PurgDocHistoryDeliveryCost PricingProcedureCounter Pricing Procedure Counter
KEY PurchasingHistoryDocumentType R_PurgDocHistoryDeliveryCost PurchasingHistoryDocumentType
KEY PurchasingHistoryDocumentYear R_PurgDocHistoryDeliveryCost PurchasingHistoryDocumentYear
KEY PurchasingHistoryDocument R_PurgDocHistoryDeliveryCost PurchasingHistoryDocument
KEY PurchasingHistoryDocumentItem R_PurgDocHistoryDeliveryCost PurchasingHistoryDocumentItem
PurchasingHistoryCategory R_PurgDocHistoryDeliveryCost PurchasingHistoryCategory
PostingDate R_PurgDocHistoryDeliveryCost PostingDate Posting Date for GR
Quantity R_PurgDocHistoryDeliveryCost Quantity Value
PurOrdAmountInCompanyCodeCrcy R_PurgDocHistoryDeliveryCost PurOrdAmountInCompanyCodeCrcy
PurchaseOrderAmount R_PurgDocHistoryDeliveryCost PurchaseOrderAmount
Currency R_PurgDocHistoryDeliveryCost Currency Valuation Crcy
GRIRAcctClrgAmtInCoCodeCrcy R_PurgDocHistoryDeliveryCost GRIRAcctClrgAmtInCoCodeCrcy
DebitCreditCode R_PurgDocHistoryDeliveryCost DebitCreditCode Single-Character Flag
DocumentReferenceID R_PurgDocHistoryDeliveryCost DocumentReferenceID Reference
Supplier R_PurgDocHistoryDeliveryCost Supplier Supplier
PurgHistDocumentCreationDate R_PurgDocHistoryDeliveryCost PurgHistDocumentCreationDate
PurgHistDocumentCreationTime R_PurgDocHistoryDeliveryCost PurgHistDocumentCreationTime
InvoiceAmtInCoCodeCrcy R_PurgDocHistoryDeliveryCost InvoiceAmtInCoCodeCrcy
InvoiceAmountInFrgnCurrency R_PurgDocHistoryDeliveryCost InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
InventoryValuationType R_PurgDocHistoryDeliveryCost InventoryValuationType Valuation Type
ConditionType R_PurgDocHistoryDeliveryCost ConditionType Condition type
QtyInPurchaseOrderPriceUnit R_PurgDocHistoryDeliveryCost QtyInPurchaseOrderPriceUnit Qty in OPUn
GRIRAcctClrgAmtInTransacCrcy R_PurgDocHistoryDeliveryCost GRIRAcctClrgAmtInTransacCrcy
CreatedByUser R_PurgDocHistoryDeliveryCost CreatedByUser User Name
GRIRAcctClrgAmtInOrdTrnsacCrcy R_PurgDocHistoryDeliveryCost GRIRAcctClrgAmtInOrdTrnsacCrcy
InvoiceAmtInPurOrdTransacCrcy R_PurgDocHistoryDeliveryCost InvoiceAmtInPurOrdTransacCrcy
ExchangeRateDifferenceAmount R_PurgDocHistoryDeliveryCost ExchangeRateDifferenceAmount
ExchangeRate R_PurgDocHistoryDeliveryCost ExchangeRate Exchange rate
OrderPriceUnit R_PurgDocHistoryDeliveryCost OrderPriceUnit Order Price Un.
OrderQuantityUnit R_PurgDocHistoryDeliveryCost OrderQuantityUnit Sales Unit
DocumentCurrency R_PurgDocHistoryDeliveryCost DocumentCurrency Document Currency
CompanyCodeCurrency R_PurgDocHistoryDeliveryCost 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 R_PurOrdHistoryDeliveryCost.
-- 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: RMMPURPOHISTDLVC

CREATE VIEW R_PurOrdHistoryDeliveryCost AS
SELECT
  HistoryDeliveryCost.PurchasingDocument AS PurchaseOrder,
  HistoryDeliveryCost.PurchasingDocumentItem AS PurchaseOrderItem,
  HistoryDeliveryCost.PricingProcedureStep AS PricingProcedureStep,
  HistoryDeliveryCost.PricingProcedureCounter AS PricingProcedureCounter,
  HistoryDeliveryCost.PurchasingHistoryDocumentType AS PurchasingHistoryDocumentType,
  HistoryDeliveryCost.PurchasingHistoryDocumentYear AS PurchasingHistoryDocumentYear,
  HistoryDeliveryCost.PurchasingHistoryDocument AS PurchasingHistoryDocument,
  HistoryDeliveryCost.PurchasingHistoryDocumentItem AS PurchasingHistoryDocumentItem,
  HistoryDeliveryCost.PurchasingHistoryCategory AS PurchasingHistoryCategory,
  HistoryDeliveryCost.PostingDate AS PostingDate,
  HistoryDeliveryCost.Quantity AS Quantity,
  HistoryDeliveryCost.PurOrdAmountInCompanyCodeCrcy AS PurOrdAmountInCompanyCodeCrcy,
  HistoryDeliveryCost.PurchaseOrderAmount AS PurchaseOrderAmount,
  HistoryDeliveryCost.Currency AS Currency,
  HistoryDeliveryCost.GRIRAcctClrgAmtInCoCodeCrcy AS GRIRAcctClrgAmtInCoCodeCrcy,
  HistoryDeliveryCost.DebitCreditCode AS DebitCreditCode,
  HistoryDeliveryCost.DocumentReferenceID AS DocumentReferenceID,
  HistoryDeliveryCost.Supplier AS Supplier,
  HistoryDeliveryCost.PurgHistDocumentCreationDate AS PurgHistDocumentCreationDate,
  HistoryDeliveryCost.PurgHistDocumentCreationTime AS PurgHistDocumentCreationTime,
  HistoryDeliveryCost.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  HistoryDeliveryCost.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  HistoryDeliveryCost.InventoryValuationType AS InventoryValuationType,
  HistoryDeliveryCost.ConditionType AS ConditionType,
  HistoryDeliveryCost.QtyInPurchaseOrderPriceUnit AS QtyInPurchaseOrderPriceUnit,
  HistoryDeliveryCost.GRIRAcctClrgAmtInTransacCrcy AS GRIRAcctClrgAmtInTransacCrcy,
  HistoryDeliveryCost.CreatedByUser AS CreatedByUser,
  HistoryDeliveryCost.GRIRAcctClrgAmtInOrdTrnsacCrcy AS GRIRAcctClrgAmtInOrdTrnsacCrcy,
  HistoryDeliveryCost.InvoiceAmtInPurOrdTransacCrcy AS InvoiceAmtInPurOrdTransacCrcy,
  HistoryDeliveryCost.ExchangeRateDifferenceAmount AS ExchangeRateDifferenceAmount,
  HistoryDeliveryCost.ExchangeRate AS ExchangeRate,
  HistoryDeliveryCost.OrderPriceUnit AS OrderPriceUnit,
  HistoryDeliveryCost.OrderQuantityUnit AS OrderQuantityUnit,
  HistoryDeliveryCost.DocumentCurrency AS DocumentCurrency,
  HistoryDeliveryCost.CompanyCodeCurrency AS CompanyCodeCurrency
FROM R_PurgDocHistoryDeliveryCost AS HistoryDeliveryCost
INNER JOIN R_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON HistoryDeliveryCost.PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON HistoryDeliveryCost.PurchasingDocument = _PurchaseOrderItem.PurchaseOrder AND HistoryDeliveryCost.PurchasingDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
;

Learn More