I_SalesOrderRequestItemSource

DDL: I_SALESORDERREQUESTITEMSOURCE SQL: ISORSI Type: view BASIC Package: VDM_SD_SLS_AUTOEXTRN

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. Part of development package VDM_SD_SLS_AUTOEXTRN.

1 data source(s) 16 fields

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
KEY SalesOrderRequestItem sdsls_sori_src salesorderrequestitem
SlsOrdReqItemChangeType sdsls_sori_src slsordreqitemchangetype
ExtractedCustomerMaterial sdsls_sori_src extractedcustomermaterial
ExtractedProduct sdsls_sori_src extractedproduct
ExtractedProductDescription sdsls_sori_src extractedproductdescription
UnitOfMeasureText sdsls_sori_src unitofmeasuretext
CustomerUnitPrice sdsls_sori_src customerunitprice
ExtractedPOItemNetAmount sdsls_sori_src extractedpoitemnetamount
TransactionCurrency sdsls_sori_src transactioncurrency
CurrencyISOCode sdsls_sori_src currencyisocode
DetnStrategyForProduct sdsls_sori_src detnstrategyforproduct
DeterminedProduct sdsls_sori_src determinedproduct
_SalesOrderRequest _SalesOrderRequest
_SalesOrderRequestItem _SalesOrderRequestItem
_TransactionCurrency _TransactionCurrency 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ISORSI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Sales Order Request Source Item'
@ObjectModel:{
  representativeKey: 'SalesOrderRequestItem',
  usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}

@VDM: {
  viewType: #BASIC
}

define view I_SalesOrderRequestItemSource
  as select from sdsls_sori_src as SalesOrderRequestSourceItem

  association [1..1] to I_SalesOrderRequest     as _SalesOrderRequest     on  $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
  association [1..1] to I_SalesOrderRequestItem as _SalesOrderRequestItem on  $projection.SalesOrderRequest     = _SalesOrderRequestItem.SalesOrderRequest
                                                                          and $projection.SalesOrderRequestItem = _SalesOrderRequestItem.SalesOrderRequestItem
  association [0..1] to I_Currency              as _TransactionCurrency   on  $projection.TransactionCurrency = _TransactionCurrency.Currency

{
      //      @ObjectModel.foreignKey.association: '_SalesOrderRequest'

  key SalesOrderRequestSourceItem.salesorderrequest           as SalesOrderRequest,
  key SalesOrderRequestSourceItem.salesorderrequestitem       as SalesOrderRequestItem,
      SalesOrderRequestSourceItem.slsordreqitemchangetype     as SlsOrdReqItemChangeType,
      SalesOrderRequestSourceItem.extractedcustomermaterial   as ExtractedCustomerMaterial,
      SalesOrderRequestSourceItem.extractedproduct            as ExtractedProduct,
      SalesOrderRequestSourceItem.extractedproductdescription as ExtractedProductDescription,
      SalesOrderRequestSourceItem.unitofmeasuretext           as UnitOfMeasureText,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderRequestSourceItem.customerunitprice           as CustomerUnitPrice,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesOrderRequestSourceItem.extractedpoitemnetamount    as ExtractedPOItemNetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      SalesOrderRequestSourceItem.transactioncurrency         as TransactionCurrency,
      SalesOrderRequestSourceItem.currencyisocode             as CurrencyISOCode,

      //Determination Strategy and Determined values

      SalesOrderRequestSourceItem.detnstrategyforproduct      as DetnStrategyForProduct,
      SalesOrderRequestSourceItem.determinedproduct           as DeterminedProduct,

      _SalesOrderRequest,
      _SalesOrderRequestItem,
      _TransactionCurrency

}

Learn More