I_RO_SAFTCommodityCode

DDL: I_RO_SAFTCOMMODITYCODE Type: view BASIC

RO SAFT Commodity Code

I_RO_SAFTCommodityCode is a Basic CDS View that provides data about "RO SAFT Commodity Code" in SAP S/4HANA. It reads from 2 data sources (/sapsll/maritc, /sapsll/tunos) and exposes 5 fields with key field ProductID.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
/sapsll/maritc _CommodityCode from
/sapsll/tunos _NumberScheme inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTCOMCODE view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
EndUserText.label RO SAFT Commodity Code view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProductID /sapsll/maritc matnr
TrdClassfctnNmbrSchm /sapsll/maritc stcts
CommodityCodeText /sapsll/maritc ccngn
RO_SAFTComCodeValidFromDate /sapsll/maritc datab
RO_SAFTComCodeValidToDate /sapsll/maritc datbi 
// active core entity

@AbapCatalog: {
  sqlViewName: 'IROSAFTCOMCODE',
  preserveKey: true
}
@VDM.viewType: #BASIC
@AccessControl: {
  authorizationCheck: #CHECK
}
@AbapCatalog.compiler.compareFilter:true
@EndUserText.label: 'RO SAFT Commodity Code'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #XXL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_RO_SAFTCommodityCode as select from /sapsll/maritc as _CommodityCode
  inner join /sapsll/tunos as _NumberScheme on _NumberScheme.stcts = _CommodityCode.stcts {
  key _CommodityCode.matnr as ProductID,
      _CommodityCode.stcts as TrdClassfctnNmbrSchm,
      _CommodityCode.ccngn as CommodityCodeText,
      _CommodityCode.datab as RO_SAFTComCodeValidFromDate,
      _CommodityCode.datbi as RO_SAFTComCodeValidToDate
} where _NumberScheme.ctsty = '01' and _NumberScheme.land1 = 'RO'

Learn More