I_CmmdtyOrdReqTraderVH

DDL: I_CMMDTYORDREQTRADERVH SQL: ICMMDTYORDTRADER Type: view BASIC

Value Help View for Order Request Trader

I_CmmdtyOrdReqTraderVH is a Basic CDS View that provides data about "Value Help View for Order Request Trader" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, vtbtra1) and exposes 3 fields with key fields CompanyCode, CommodityOrderRequestTrader.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode left_outer
vtbtra1 TraderAuth inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYORDTRADER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help View for Order Request Trader view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
Consumption.ranked true view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Trader bukrs
KEY CommodityOrderRequestTrader Trader rdealer
CompanyCodeName I_CompanyCode CompanyCodeName 
@AbapCatalog.sqlViewName: 'ICMMDTYORDTRADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Value Help View for Order Request Trader'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@Metadata.ignorePropagatedAnnotations:true
@Search.searchable: true
@Consumption.ranked: true

define view I_CmmdtyOrdReqTraderVH as select distinct from tzdea as Trader
 inner join vtbtra1 as TraderAuth on Trader.bukrs = TraderAuth.bukrs
                                 and Trader.rdealer = TraderAuth.rdealer
 left outer join I_CompanyCode as I_CompanyCode on I_CompanyCode.CompanyCode = Trader.bukrs
 {  
    key Trader.bukrs   as CompanyCode,
    @Search:{defaultSearchElement:true,ranking:#HIGH,fuzzinessThreshold:0.7}    
    key Trader.rdealer as CommodityOrderRequestTrader,
    @Search:{defaultSearchElement:true,ranking:#LOW,fuzzinessThreshold:0.7}    
    I_CompanyCode.CompanyCodeName as CompanyCodeName
     
}
where TraderAuth.rantyp  = '6'
and TraderAuth.sanlf     = '700'
and TraderAuth.sgsart    = '70D'

Learn More