I_ProdSrcgTypeItemExcludeModel

DDL: I_PRODSRCGTYPEITEMEXCLUDEMODEL Type: view_entity BASIC

Item Exclude Model for Product Srcg Type

I_ProdSrcgTypeItemExcludeModel is a Basic CDS View that provides data about "Item Exclude Model for Product Srcg Type" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectType) and exposes 5 fields with key fields SourcingProjectType, SrcgProjQtnItemExcludingRsnGrp, ProductSourcingReason. It has 2 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectType _Type from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SourcingProjectTypeText _SourcingProjectTypeText $projection.SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType
[0..*] I_ProductSourcingReasonText _ProductSourcingReasonText $projection.ProductSourcingReason = _ProductSourcingReasonText.ProductSourcingReason

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view
EndUserText.label Item Exclude Model for Product Srcg Type view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectType R_SourcingProjectType SourcingProjectType
KEY SrcgProjQtnItemExcludingRsnGrp R_SourcingProjectType SrcgProjQtnItemExcludingRsnGrp
KEY ProductSourcingReason _ReasonMod ProductSourcingReason
_SourcingProjectTypeText _SourcingProjectTypeText
_ProductSourcingReasonText _ProductSourcingReasonText 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:{
    usageType:{
        dataClass: #CUSTOMIZING,
        serviceQuality: #A,
        sizeCategory: #S },
    supportedCapabilities: [#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE,#CDS_MODELING_ASSOCIATION_TARGET],
    modelingPattern: #NONE }
@VDM.viewType: #BASIC
@EndUserText.label: 'Item Exclude Model for Product Srcg Type'

define view entity I_ProdSrcgTypeItemExcludeModel
  as select from R_SourcingProjectType        as _Type
    join         I_ProductSourcingReasonModel as _ReasonMod on _Type.SrcgProjQtnItemExcludingRsnGrp = _ReasonMod.ProductSourcingReasonGroup
  association [0..*] to I_SourcingProjectTypeText   as _SourcingProjectTypeText   on $projection.SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType
  association [0..*] to I_ProductSourcingReasonText as _ProductSourcingReasonText on $projection.ProductSourcingReason = _ProductSourcingReasonText.ProductSourcingReason

{
         @ObjectModel.text.association: '_SourcingProjectTypeText'
         @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectType'
  key    _Type.SourcingProjectType            as SourcingProjectType,
  key    _Type.SrcgProjQtnItemExcludingRsnGrp as SrcgProjQtnItemExcludingRsnGrp,
         @ObjectModel.text.association: '_ProductSourcingReasonText'
         @ObjectModel.sapObjectNodeTypeReference: 'ProductSourcingReason'
  key    _ReasonMod.ProductSourcingReason     as ProductSourcingReason,

         _SourcingProjectTypeText,
         _ProductSourcingReasonText
}

Learn More