R_SalesOrderRequestDerivdItmTP

DDL: R_SALESORDERREQUESTDERIVDITMTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources

Sales Order Request Derived Item TP

R_SalesOrderRequestDerivdItmTP is a Transactional CDS View that provides data about "Sales Order Request Derived Item TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderRequestDerivedItem) and exposes 21 fields with key fields SalesOrderRequest, SalesOrderRequestItem, SalesOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderRequestDerivedItem I_SalesOrderRequestDerivedItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Derived 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 (21)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest I_SalesOrderRequestDerivedItem SalesOrderRequest Sales Order Request
KEY SalesOrderRequestItem I_SalesOrderRequestDerivedItem SalesOrderRequestItem Item
KEY SalesOrderItem I_SalesOrderRequestDerivedItem SalesOrderItem Sales Order Item
HigherLevelItem I_SalesOrderRequestDerivedItem HigherLevelItem Higher-Lev.Item
Product I_SalesOrderRequestDerivedItem Product Product Sold
RequestedQuantity I_SalesOrderRequestDerivedItem RequestedQuantity Requested Quantity
RequestedQuantityUnit I_SalesOrderRequestDerivedItem RequestedQuantityUnit Requested Quantity Unit
NetAmount I_SalesOrderRequestDerivedItem NetAmount Stated Amount
TransactionCurrency I_SalesOrderRequestDerivedItem TransactionCurrency Transaction Currency
SalesOrderItemCategory I_SalesOrderRequestDerivedItem SalesOrderItemCategory Item Category
MaterialByCustomer I_SalesOrderRequestDerivedItem MaterialByCustomer Customer Mat.
ConfdDelivQtyInOrderQtyUnit I_SalesOrderRequestDerivedItem ConfdDelivQtyInOrderQtyUnit Confd Quantity
ConfirmedDeliveryDate I_SalesOrderRequestDerivedItem ConfirmedDeliveryDate Confirmed Delivery Date
OrderQuantityUnit I_SalesOrderRequestDerivedItem OrderQuantityUnit Sales Unit
RequestedDeliveryDate I_SalesOrderRequestDerivedItem RequestedDeliveryDate Requested Delivery Date
_SalesOrderRequest _SalesOrderRequest
_SalesOrderRequestItem _SalesOrderRequestItem
_Product _Product
_RequestedQuantityUnit _RequestedQuantityUnit
_OrderQuantityUnit _OrderQuantityUnit
_TransactionCurrency _TransactionCurrency

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_SalesOrderRequestDerivdItmTP.
-- 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_SalesOrderRequestDerivdItmTP AS
SELECT
  I_SalesOrderRequestDerivedItem.SalesOrderRequest AS SalesOrderRequest,
  I_SalesOrderRequestDerivedItem.SalesOrderRequestItem AS SalesOrderRequestItem,
  I_SalesOrderRequestDerivedItem.SalesOrderItem AS SalesOrderItem,
  I_SalesOrderRequestDerivedItem.HigherLevelItem AS HigherLevelItem,
  I_SalesOrderRequestDerivedItem.Product AS Product,
  I_SalesOrderRequestDerivedItem.RequestedQuantity AS RequestedQuantity,
  I_SalesOrderRequestDerivedItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  I_SalesOrderRequestDerivedItem.NetAmount AS NetAmount,
  I_SalesOrderRequestDerivedItem.TransactionCurrency AS TransactionCurrency,
  I_SalesOrderRequestDerivedItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  I_SalesOrderRequestDerivedItem.MaterialByCustomer AS MaterialByCustomer,
  I_SalesOrderRequestDerivedItem.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  I_SalesOrderRequestDerivedItem.ConfirmedDeliveryDate AS ConfirmedDeliveryDate,
  I_SalesOrderRequestDerivedItem.OrderQuantityUnit AS OrderQuantityUnit,
  I_SalesOrderRequestDerivedItem.RequestedDeliveryDate AS RequestedDeliveryDate
FROM I_SalesOrderRequestDerivedItem
;

Learn More