R_SalesOrderRequestItemTP

DDL: R_SALESORDERREQUESTITEMTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SOR
14 Fields 1 Data Sources 4 Associations

Sales Order Request Item - TP

R_SalesOrderRequestItemTP is a Transactional CDS View that provides data about "Sales Order Request Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderRequestItem) and exposes 14 fields with key fields SalesOrderRequest, SalesOrderRequestItem. It has 4 associations to related views. Part of development package RAP_SD_SLS_SOR.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderRequestItem I_SalesOrderRequestItem from

Associations (4)

CardinalityTargetAliasCondition
[1] E_SalesOrderRequestItem _Extension $projection.SalesOrderRequest = _Extension.SalesOrderRequest and $projection.SalesOrderRequestItem = _Extension.SalesOrderRequestItem
[0..*] R_SalesOrderReqItemPartnerTP _ItemPartner
[0..*] R_SlsOrdReqItmPricingElementTP _ItemPricingElement
[0..1] R_SlsOrderRequestItemSourceTP _SourceItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Item - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest I_SalesOrderRequestItem SalesOrderRequest Sales Order Request
KEY SalesOrderRequestItem I_SalesOrderRequestItem SalesOrderRequestItem Item
Product I_SalesOrderRequestItem Product Product Sold
RequestedQuantity I_SalesOrderRequestItem RequestedQuantity Requested Quantity
RequestedQuantityUnit I_SalesOrderRequestItem RequestedQuantityUnit Requested Quantity Unit
RequestedDeliveryDate I_SalesOrderRequestItem RequestedDeliveryDate Requested Delivery Date
UnderlyingPurchaseOrderItem I_SalesOrderRequestItem UnderlyingPurchaseOrderItem PO Item
MaterialByCustomer I_SalesOrderRequestItem MaterialByCustomer Customer Mat.
_SourceItem _SourceItem
_ItemPartner _ItemPartner
_ItemPricingElement _ItemPricingElement
_SalesOrderRequest _SalesOrderRequest
_Product _Product
_RequestedQuantityUnit _RequestedQuantityUnit

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_SalesOrderRequestItemTP.
-- 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.

CREATE VIEW R_SalesOrderRequestItemTP AS
SELECT
  I_SalesOrderRequestItem.SalesOrderRequest AS SalesOrderRequest,
  I_SalesOrderRequestItem.SalesOrderRequestItem AS SalesOrderRequestItem,
  I_SalesOrderRequestItem.Product AS Product,
  I_SalesOrderRequestItem.RequestedQuantity AS RequestedQuantity,
  I_SalesOrderRequestItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  I_SalesOrderRequestItem.RequestedDeliveryDate AS RequestedDeliveryDate,
  I_SalesOrderRequestItem.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  I_SalesOrderRequestItem.MaterialByCustomer AS MaterialByCustomer
FROM I_SalesOrderRequestItem
LEFT OUTER JOIN E_SalesOrderRequestItem AS _Extension ON SalesOrderRequest = _Extension.SalesOrderRequest AND SalesOrderRequestItem = _Extension.SalesOrderRequestItem  -- association [1]
LEFT OUTER JOIN R_SalesOrderReqItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsOrdReqItmPricingElementTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsOrderRequestItemSourceTP AS _SourceItem ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More