R_PurchaseOrderItem

DDL: R_PURCHASEORDERITEM SQL: RMMPURCHORDRITEM Type: view BASIC
1 Data Sources 7 Associations

Purchase Order Item Internal View

R_PurchaseOrderItem is a Basic CDS View that provides data about "Purchase Order Item Internal View" in SAP S/4HANA. It reads from 1 data source (R_PurchasingDocumentItem). It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchasingDocumentItem R_PurchasingDocumentItem from

Associations (7)

CardinalityTargetAliasCondition
[1..1] R_PurchaseOrder _PurchaseOrder $projection.PurchaseOrder = _PurchaseOrder.PurchaseOrder
[0..*] R_PurOrderItemDeliveryAddress _DeliveryAddress $projection.ManualDeliveryAddressID = _DeliveryAddress.DeliveryAddressID
[1..*] I_PurOrdPricingElement _PurchaseOrderPricingElement $projection.PurchaseOrder = _PurchaseOrderPricingElement.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderPricingElement.PurchaseOrderItem
[1..1] I_PurchaseOrderItemCalcFields _PurchaseOrderItemCalcFields $projection.PurchaseOrder = _PurchaseOrderItemCalcFields.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderItemCalcFields.PurchaseOrderItem
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..*] I_PurchaseOrderHistoryBasic _PurchaseOrderHistory $projection.PurchaseOrder = _PurchaseOrderHistory.PurchaseOrder and $projection.PurchaseOrderItem = _PurchaseOrderHistory.PurchaseOrderItem
[0..*] I_PurOrdAccountAssignment _PurOrdAccountAssignment $projection.PurchaseOrder = _PurOrdAccountAssignment.PurchaseOrder and $projection.PurchaseOrderItem = _PurOrdAccountAssignment.PurchaseOrderItem

Annotations (14)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Order Item Internal View view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName RMMPURCHORDRITEM view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey PurchaseOrderItem view
ObjectModel.uniqueIdField PurchaseOrderItemUniqueID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

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_PurchaseOrderItem.
-- 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: RMMPURCHORDRITEM

CREATE VIEW R_PurchaseOrderItem AS
SELECT *  -- field list not available in parsed metadata
FROM R_PurchasingDocumentItem
LEFT OUTER JOIN R_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN R_PurOrderItemDeliveryAddress AS _DeliveryAddress ON ManualDeliveryAddressID = _DeliveryAddress.DeliveryAddressID  -- association [0..*]
LEFT OUTER JOIN I_PurOrdPricingElement AS _PurchaseOrderPricingElement ON PurchaseOrder = _PurchaseOrderPricingElement.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderPricingElement.PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN I_PurchaseOrderItemCalcFields AS _PurchaseOrderItemCalcFields ON PurchaseOrder = _PurchaseOrderItemCalcFields.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItemCalcFields.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderHistoryBasic AS _PurchaseOrderHistory ON PurchaseOrder = _PurchaseOrderHistory.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderHistory.PurchaseOrderItem  -- association [0..*]
LEFT OUTER JOIN I_PurOrdAccountAssignment AS _PurOrdAccountAssignment ON PurchaseOrder = _PurOrdAccountAssignment.PurchaseOrder AND PurchaseOrderItem = _PurOrdAccountAssignment.PurchaseOrderItem  -- association [0..*]
;

Learn More