I_SPQtnTypeContactCatModel

DDL: I_SPQTNTYPECONTACTCATMODEL Type: view_entity BASIC Package: VDM_MM_PUR_SRCGPROJ

Contact Category Model for SPQtn Type

I_SPQtnTypeContactCatModel is a Basic CDS View that provides data about "Contact Category Model for SPQtn Type" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectType) and exposes 6 fields with key fields SourcingProjectType, SrcgProjContactGroup, SourcingProjectContactCategory. It has 3 associations to related views. Part of development package VDM_MM_PUR_SRCGPROJ.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectType _Type from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_SourcingProjectTypeText _SourcingProjectTypeText $projection.SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType
[0..*] I_SrcgProjContactGroupText _SrcgProjContactGroupText $projection.SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup
[0..*] I_SourcingProjectContactCatT _SourcingProjectContactCatT $projection.SourcingProjectContactCategory = _SourcingProjectContactCatT.SourcingProjectContactCategory

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 Contact Category Model for SPQtn Type view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectType R_SourcingProjectType SourcingProjectType
KEY SrcgProjContactGroup R_SourcingProjectType SrcgProjContactGroup
KEY SourcingProjectContactCategory _ContactMod contacttype
_SourcingProjectTypeText _SourcingProjectTypeText
_SrcgProjContactGroupText _SrcgProjContactGroupText
_SourcingProjectContactCatT _SourcingProjectContactCatT 
@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: 'Contact Category Model for SPQtn Type'

define view entity I_SPQtnTypeContactCatModel
  as select from R_SourcingProjectType as _Type
    join         mmspqcontcmod         as _ContactMod on _Type.SrcgProjContactGroup = _ContactMod.cont_group
  association [0..*] to I_SourcingProjectTypeText    as _SourcingProjectTypeText    on $projection.SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType
  association [0..*] to I_SrcgProjContactGroupText   as _SrcgProjContactGroupText   on $projection.SrcgProjContactGroup = _SrcgProjContactGroupText.SrcgProjContactGroup
  association [0..*] to I_SourcingProjectContactCatT as _SourcingProjectContactCatT on $projection.SourcingProjectContactCategory = _SourcingProjectContactCatT.SourcingProjectContactCategory

{
         @ObjectModel.text.association: '_SourcingProjectTypeText'
         @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectType'
  key    _Type.SourcingProjectType  as SourcingProjectType,
         @ObjectModel.text.association: '_SrcgProjContactGroupText'
  key    _Type.SrcgProjContactGroup as SrcgProjContactGroup,
         @ObjectModel.text.association: '_SourcingProjectContactCatT'
         @ObjectModel.sapObjectNodeTypeReference: 'SourcingProjectContactCategory'
  key    _ContactMod.contacttype    as SourcingProjectContactCategory,

         _SourcingProjectTypeText,
         _SrcgProjContactGroupText,
         _SourcingProjectContactCatT
}

Learn More