I_ProductHasTCCClassification

DDL: I_PRODUCTHASTCCCLASSIFICATION SQL: IPRDTCCCLSFCTN Type: view BASIC Package: CVIEW_CMDTYCODE

Product has Classification for Scheme

I_ProductHasTCCClassification is a Basic CDS View that provides data about "Product has Classification for Scheme" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field ProductTCCSchemeClfnStatus. It has 1 association to related views. It is exposed through 1 OData service (UI_PRDTRCMDTYCLASSIFY). Part of development package CVIEW_CMDTYCODE.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProductHasTCCClassificationT _Text $projection.ProductTCCSchemeClfnStatus = _Text.ProductTCCSchemeClfnStatus

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRDTCCCLSFCTN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product has Classification for Scheme view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.representativeKey ProductTCCSchemeClfnStatus view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRDTRCMDTYCLASSIFY UI_PRDTRCMDTYCLASSIFY V4 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProductTCCSchemeClfnStatus
_Text _Text
@AbapCatalog.sqlViewName: 'IPRDTCCCLSFCTN'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Product has Classification for Scheme'
@ObjectModel.usageType:{
  serviceQuality: #A,
  sizeCategory:   #S,
  dataClass:      #META
}
@ObjectModel:   { representativeKey: 'ProductTCCSchemeClfnStatus' }
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProductHasTCCClassification 
  as select from dd07l
  association [0..*] to I_ProductHasTCCClassificationT as _Text on $projection.ProductTCCSchemeClfnStatus = _Text.ProductTCCSchemeClfnStatus 
{
  @ObjectModel.text.association: '_Text'  
  key cast( dd07l.domvalue_l as /scmtms/vdm_prd_tccns_clfn_sts ) as ProductTCCSchemeClfnStatus,
 
  @Consumption.hidden: true
  _Text
}
  where dd07l.domname = '/SCMTMS/VDM_PRD_TCCNS_CLFN_STS'
    and dd07l.as4local = 'A'