C_MPPurchaseOrderItemHistory

DDL: C_MPPURCHASEORDERITEMHISTORY SQL: CMPPOH Type: view CONSUMPTION Package: VDM_CPM_WS
24 Fields 1 Data Sources 1 Associations

Master Proj Pur Order History

C_MPPurchaseOrderItemHistory is a Consumption CDS View that provides data about "Master Proj Pur Order History" in SAP S/4HANA. It reads from 1 data source (I_Mppurchaseorderitemhistory) and exposes 24 fields with key fields PurchaseOrder, PurchaseOrderItem, MaterialDocument, MaterialDocumentItem, MaterialDocumentYear. It has 1 association to related views. Part of development package VDM_CPM_WS.

Data Sources (1)

SourceAliasJoin Type
I_Mppurchaseorderitemhistory I_Mppurchaseorderitemhistory from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocument _Extension $projection.PurchaseOrder = _Extension.PurchasingDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMPPOH view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Proj Pur Order History view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentItem MaterialDocumentItem Material Document Item
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
Material Material Vehicle Model
GoodsMovementType GoodsMovementType Movement Type
DebitCreditCode DebitCreditCode Single-Character Flag
PurchaseOrderHistCategory PurchaseOrderHistCategory
PurchaseOrderHistCategName
PostingDate PostingDate Posting Date for GR
Quantity Quantity Value
DeliveryQuantityUnit DeliveryQuantityUnit Unit of measure
PurchaseOrderStatus PurchaseOrderStatus Doc. Status
OrderStatusText OrderStatusText
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceAmtInCoCodeCrcy InvoiceAmtInCoCodeCrcy
PurOrdAmountInCompanyCodeCrcy PurOrdAmountInCompanyCodeCrcy
Currency Currency Valuation Crcy
PurchaseOrderType PurchaseOrderType PO Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
_PurchaseOrderHistCategory _PurchaseOrderHistCategory

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 C_MPPurchaseOrderItemHistory.
-- 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: CMPPOH

CREATE VIEW C_MPPurchaseOrderItemHistory AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  MaterialDocument,
  MaterialDocumentItem,
  MaterialDocumentYear,
  Material,
  GoodsMovementType,
  DebitCreditCode,
  PurchaseOrderHistCategory,
  _PurchaseOrderHistCategory._PurchaseOrderHistCategName[1:Language = $session.system_language].PurchaseOrderHistCategName AS PurchaseOrderHistCategName,
  PostingDate,
  Quantity,
  DeliveryQuantityUnit,
  PurchaseOrderStatus,
  OrderStatusText,
  InvoiceReferenceFiscalYear,
  InvoiceAmtInCoCodeCrcy,
  PurOrdAmountInCompanyCodeCrcy,
  Currency,
  PurchaseOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM I_Mppurchaseorderitemhistory
LEFT OUTER JOIN E_PurchasingDocument AS _Extension ON PurchaseOrder = _Extension.PurchasingDocument  -- association [0..1]
;

Learn More