I_SalesOrderRequestItem

DDL: I_SALESORDERREQUESTITEM SQL: ISORI Type: view BASIC Package: VDM_SD_SLS_SOR
13 Fields 1 Data Sources 5 Associations

Sales Order Request Item

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

Data Sources (1)

SourceAliasJoin Type
sdsls_sori SalesOrderRequestItem from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_SalesOrderRequest _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
[0..*] I_SalesOrderRequestDerivedItem _SalesOrderRequestDerivedItem $projection.SalesOrderRequest = _SalesOrderRequestDerivedItem.SalesOrderRequest and $projection.SalesOrderRequestItem = _SalesOrderRequestDerivedItem.SalesOrderRequestItem
[0..1] I_SalesOrderRequestItemSource _SalesOrderRequestItemSource $projection.SalesOrderRequest = _SalesOrderRequestItemSource.SalesOrderRequest and $projection.SalesOrderRequestItem = _SalesOrderRequestItemSource.SalesOrderRequestItem
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_UnitOfMeasure _RequestedQuantityUnit $projection.RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISORI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Item view
ObjectModel.representativeKey SalesOrderRequestItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest sdsls_sori salesorderrequest Sales Order Request
KEY SalesOrderRequestItem sdsls_sori salesorderrequestitem Item
Product sdsls_sori product Product Sold
RequestedQuantity sdsls_sori requestedquantity Requested Quantity
RequestedQuantityUnit sdsls_sori requestedquantityunit Requested Quantity Unit
RequestedDeliveryDate sdsls_sori requesteddeliverydate Requested Delivery Date
UnderlyingPurchaseOrderItem sdsls_sori underlyingpurchaseorderitem PO Item
MaterialByCustomer sdsls_sori materialbycustomer Customer Mat.
_SalesOrderRequest _SalesOrderRequest
_SalesOrderRequestDerivedItem _SalesOrderRequestDerivedItem
_SalesOrderRequestItemSource _SalesOrderRequestItemSource
_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 I_SalesOrderRequestItem.
-- 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: ISORI

CREATE VIEW I_SalesOrderRequestItem AS
SELECT
  SalesOrderRequestItem.salesorderrequest AS SalesOrderRequest,
  SalesOrderRequestItem.salesorderrequestitem AS SalesOrderRequestItem,
  SalesOrderRequestItem.product AS Product,
  SalesOrderRequestItem.requestedquantity AS RequestedQuantity,
  SalesOrderRequestItem.requestedquantityunit AS RequestedQuantityUnit,
  SalesOrderRequestItem.requesteddeliverydate AS RequestedDeliveryDate,
  SalesOrderRequestItem.underlyingpurchaseorderitem AS UnderlyingPurchaseOrderItem,
  SalesOrderRequestItem.materialbycustomer AS MaterialByCustomer
FROM sdsls_sori AS SalesOrderRequestItem
LEFT OUTER JOIN I_SalesOrderRequest AS _SalesOrderRequest ON SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderRequestDerivedItem AS _SalesOrderRequestDerivedItem ON SalesOrderRequest = _SalesOrderRequestDerivedItem.SalesOrderRequest AND SalesOrderRequestItem = _SalesOrderRequestDerivedItem.SalesOrderRequestItem  -- association [0..*]
LEFT OUTER JOIN I_SalesOrderRequestItemSource AS _SalesOrderRequestItemSource ON SalesOrderRequest = _SalesOrderRequestItemSource.SalesOrderRequest AND SalesOrderRequestItem = _SalesOrderRequestItemSource.SalesOrderRequestItem  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
;

Learn More