I_ProductTrdClassfctnEndUse

DDL: I_PRODUCTTRDCLASSFCTNENDUSE SQL: IPRTRDCLSENDUSE Type: view BASIC

Product Classfication for End Use

I_ProductTrdClassfctnEndUse is a Basic CDS View that provides data about "Product Classfication for End Use" in SAP S/4HANA. It reads from 2 data sources (/sapsll/maritec, I_Product) and exposes 19 fields with key fields Product, TrdClassfctnNmbrSchm, TrdClassfctnEndUse, ValidityStartDate. It has 5 associations to related views.

2 data source(s) 19 fields

Data Sources (2)

SourceAliasJoin Type
/sapsll/maritec _a from
I_Product _ProductMaster left_outer

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_TrdClassfctnNmbrSchm _TrdClassfctnNmbrSchm $projection.TrdClassfctnNmbrSchm = _TrdClassfctnNmbrSchm.TrdClassfctnNmbrSchm
[0..*] I_TrdClassfctnNmbrSchmText _TrdClassfctnNmbrSchmText $projection.TrdClassfctnNmbrSchm = _TrdClassfctnNmbrSchmText.TrdClassfctnNmbrSchm
[0..1] I_TrdClassfctnEndUse _TrdClassfctnEndUse $projection.TrdClassfctnNmbrSchm = _TrdClassfctnEndUse.TrdClassfctnNmbrSchm and $projection.TrdClassfctnEndUse = _TrdClassfctnEndUse.TrdClassfctnEndUse
[0..*] I_TrdClassfctnEndUseText _TrdClassfctnEndUseText $projection.TrdClassfctnNmbrSchm = _TrdClassfctnEndUseText.TrdClassfctnNmbrSchm and $projection.TrdClassfctnEndUse = _TrdClassfctnEndUseText.TrdClassfctnEndUse

Annotations (10)

NameValueLevelField
EndUserText.label Product Classfication for End Use view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPRTRDCLSENDUSE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass #MASTER view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Product
KEY TrdClassfctnNmbrSchm stcts
KEY TrdClassfctnEndUse teuse
KEY ValidityStartDate datab
ValidityEndDate datbi
TrdClassfctnNmbr ccngn
TrdClassfctnRemark tclrm
TrdClassfctnNmbrSchmType _TrdClassfctnNmbrSchm TrdClassfctnNmbrSchmType
ProductGroup I_Product ProductGroup
ProductType I_Product ProductType
AuthorizationGroup I_Product AuthorizationGroup
_Product _Product
_ProductGroup I_Product _ProductGroup
_ProductType I_Product _ProductType
_TrdClassfctnNmbrSchm _TrdClassfctnNmbrSchm
_TrdClassfctnNmbrSchmText _TrdClassfctnNmbrSchmText
_TrdClassfctnNmbrSchmTypeText _TrdClassfctnNmbrSchm _TrdClassfctnNmbrSchmTypeText
_TrdClassfctnEndUse _TrdClassfctnEndUse
_TrdClassfctnEndUseText _TrdClassfctnEndUseText 
@EndUserText.label: 'Product Classfication for End Use'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPRTRDCLSENDUSE'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: #MASTER
define view I_ProductTrdClassfctnEndUse
  as select from    /sapsll/maritec as _a
    left outer join I_Product       as _ProductMaster on _a.matnr = _ProductMaster.Product
  association [0..1] to I_Product                  as _Product                  on  $projection.Product = _Product.Product
  association [0..1] to I_TrdClassfctnNmbrSchm     as _TrdClassfctnNmbrSchm     on  $projection.TrdClassfctnNmbrSchm = _TrdClassfctnNmbrSchm.TrdClassfctnNmbrSchm
  association [0..*] to I_TrdClassfctnNmbrSchmText as _TrdClassfctnNmbrSchmText on  $projection.TrdClassfctnNmbrSchm = _TrdClassfctnNmbrSchmText.TrdClassfctnNmbrSchm
  association [0..1] to I_TrdClassfctnEndUse       as _TrdClassfctnEndUse       on  $projection.TrdClassfctnNmbrSchm = _TrdClassfctnEndUse.TrdClassfctnNmbrSchm
                                                                                and $projection.TrdClassfctnEndUse   = _TrdClassfctnEndUse.TrdClassfctnEndUse
  association [0..*] to I_TrdClassfctnEndUseText   as _TrdClassfctnEndUseText   on  $projection.TrdClassfctnNmbrSchm = _TrdClassfctnEndUseText.TrdClassfctnNmbrSchm
                                                                                and $projection.TrdClassfctnEndUse   = _TrdClassfctnEndUseText.TrdClassfctnEndUse

{
      @ObjectModel.foreignKey.association: '_Product'
  key cast (_a.matnr as productnumber) as Product,
      @ObjectModel.foreignKey.association: '_TrdClassfctnNmbrSchm'
      @ObjectModel.text.association: '_TrdClassfctnNmbrSchmText'
  key stcts                         as TrdClassfctnNmbrSchm,
      @ObjectModel.foreignKey.association: '_TrdClassfctnEndUse'
      @ObjectModel.text.association: '_TrdClassfctnEndUseText'
  key teuse                         as TrdClassfctnEndUse,
      @Semantics.businessDate.from: true
  key datab                         as ValidityStartDate,
      @Semantics.businessDate.to: true
      datbi                         as ValidityEndDate,
      ccngn                         as TrdClassfctnNmbr,
      tclrm                         as TrdClassfctnRemark,
      
      _TrdClassfctnNmbrSchm.TrdClassfctnNmbrSchmType,
                        
      _ProductMaster.ProductGroup,
      _ProductMaster.ProductType,
      _ProductMaster.AuthorizationGroup,

      _Product,
      _ProductMaster._ProductGroup,
      _ProductMaster._ProductType,
      _TrdClassfctnNmbrSchm,
      _TrdClassfctnNmbrSchmText,
      _TrdClassfctnNmbrSchm._TrdClassfctnNmbrSchmTypeText,
      _TrdClassfctnEndUse,
      _TrdClassfctnEndUseText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODUCT",
"I_TRDCLASSFCTNNMBRSCHM",
"/SAPSLL/MARITEC"
],
"ASSOCIATED":
[
"I_PRODUCT",
"I_PRODUCTGROUP",
"I_PRODUCTTYPE",
"I_TRDCLASSFCTNENDUSE",
"I_TRDCLASSFCTNENDUSETEXT",
"I_TRDCLASSFCTNNMBRSCHM",
"I_TRDCLASSFCTNNMBRSCHMTEXT",
"I_TRDCLASSFCTNNMBRSCHMTYPETEXT"
],
"BASE":
[
"I_PRODUCT",
"I_TRDCLASSFCTNNMBRSCHM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More