I_SalesOrderRequestItemSource

DDL: I_SALESORDERREQUESTITEMSOURCE SQL: ISORSI Type: view BASIC
16 Fields 1 Data Sources 3 Associations

Sales Order Request Source Item

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

Data Sources (1)

SourceAliasJoin Type
sdsls_sori_src SalesOrderRequestSourceItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesOrderRequest _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
[1..1] I_SalesOrderRequestItem _SalesOrderRequestItem $projection.SalesOrderRequest = _SalesOrderRequestItem.SalesOrderRequest and $projection.SalesOrderRequestItem = _SalesOrderRequestItem.SalesOrderRequestItem
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ISORSI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Order Request Source 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 (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest sdsls_sori_src salesorderrequest Sales Order Request
KEY SalesOrderRequestItem sdsls_sori_src salesorderrequestitem Item
SlsOrdReqItemChangeType sdsls_sori_src slsordreqitemchangetype Sales Order Request EDI Item Change Type
ExtractedCustomerMaterial sdsls_sori_src extractedcustomermaterial Extracted Customer Material
ExtractedProduct sdsls_sori_src extractedproduct Extracted Product
ExtractedProductDescription sdsls_sori_src extractedproductdescription Extracted Description
UnitOfMeasureText sdsls_sori_src unitofmeasuretext Extracted Unit of Measure
CustomerUnitPrice sdsls_sori_src customerunitprice Extracted Unit Price
ExtractedPOItemNetAmount sdsls_sori_src extractedpoitemnetamount Extracted Net Value
TransactionCurrency sdsls_sori_src transactioncurrency Transaction Currency
CurrencyISOCode sdsls_sori_src currencyisocode Document Currency
DetnStrategyForProduct sdsls_sori_src detnstrategyforproduct Determination Strategy for Product
DeterminedProduct sdsls_sori_src determinedproduct Determined Product
_SalesOrderRequest _SalesOrderRequest
_SalesOrderRequestItem _SalesOrderRequestItem
_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 I_SalesOrderRequestItemSource.
-- 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: ISORSI

CREATE VIEW I_SalesOrderRequestItemSource AS
SELECT
  SalesOrderRequestSourceItem.salesorderrequest AS SalesOrderRequest,
  SalesOrderRequestSourceItem.salesorderrequestitem AS SalesOrderRequestItem,
  SalesOrderRequestSourceItem.slsordreqitemchangetype AS SlsOrdReqItemChangeType,
  SalesOrderRequestSourceItem.extractedcustomermaterial AS ExtractedCustomerMaterial,
  SalesOrderRequestSourceItem.extractedproduct AS ExtractedProduct,
  SalesOrderRequestSourceItem.extractedproductdescription AS ExtractedProductDescription,
  SalesOrderRequestSourceItem.unitofmeasuretext AS UnitOfMeasureText,
  SalesOrderRequestSourceItem.customerunitprice AS CustomerUnitPrice,
  SalesOrderRequestSourceItem.extractedpoitemnetamount AS ExtractedPOItemNetAmount,
  SalesOrderRequestSourceItem.transactioncurrency AS TransactionCurrency,
  SalesOrderRequestSourceItem.currencyisocode AS CurrencyISOCode,
  SalesOrderRequestSourceItem.detnstrategyforproduct AS DetnStrategyForProduct,
  SalesOrderRequestSourceItem.determinedproduct AS DeterminedProduct
FROM sdsls_sori_src AS SalesOrderRequestSourceItem
LEFT OUTER JOIN I_SalesOrderRequest AS _SalesOrderRequest ON SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderRequestItem AS _SalesOrderRequestItem ON SalesOrderRequest = _SalesOrderRequestItem.SalesOrderRequest AND SalesOrderRequestItem = _SalesOrderRequestItem.SalesOrderRequestItem  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
;

Learn More