R_SlsOrderRequestItemSourceTP

DDL: R_SLSORDERREQUESTITEMSOURCETP SQL: RSORSITP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Sales Order Request Source Item Transactional Processing

R_SlsOrderRequestItemSourceTP is a Transactional CDS View that provides data about "Sales Order Request Source Item Transactional Processing" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderRequestItemSource) and exposes 16 fields with key fields SalesOrderRequest, SalesOrderRequestItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderRequestItemSource I_SalesOrderRequestItemSource from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SalesOrderRequestTP _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Source Item Transactional Processing 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 (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest SalesOrderRequest Sales Order Request
KEY SalesOrderRequestItem SalesOrderRequestItem Item
SlsOrdReqItemChangeType SlsOrdReqItemChangeType Sales Order Request EDI Item Change Type
ExtractedCustomerMaterial ExtractedCustomerMaterial Extracted Customer Material
ExtractedProduct ExtractedProduct Extracted Product
ExtractedProductDescription ExtractedProductDescription Extracted Description
UnitOfMeasureText UnitOfMeasureText Extracted Unit of Measure
CustomerUnitPrice CustomerUnitPrice Extracted Unit Price
ExtractedPOItemNetAmount ExtractedPOItemNetAmount Extracted Net Value
TransactionCurrency TransactionCurrency Transaction Currency
CurrencyISOCode CurrencyISOCode Document Currency
DetnStrategyForProduct DetnStrategyForProduct Determination Strategy for Product
DeterminedProduct DeterminedProduct Determined Product
_SalesOrderRequestItem _SalesOrderRequestItem
_SalesOrderRequest _SalesOrderRequest
_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_SlsOrderRequestItemSourceTP.
-- 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: RSORSITP

CREATE VIEW R_SlsOrderRequestItemSourceTP AS
SELECT
  SalesOrderRequest,
  SalesOrderRequestItem,
  SlsOrdReqItemChangeType,
  ExtractedCustomerMaterial,
  ExtractedProduct,
  ExtractedProductDescription,
  UnitOfMeasureText,
  CustomerUnitPrice,
  ExtractedPOItemNetAmount,
  TransactionCurrency,
  CurrencyISOCode,
  DetnStrategyForProduct,
  DeterminedProduct
FROM I_SalesOrderRequestItemSource
LEFT OUTER JOIN R_SalesOrderRequestTP AS _SalesOrderRequest ON SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest  -- association [1..1]
;

Learn More