P_Addmatlgrp1

DDL: P_ADDMATLGRP1 SQL: padntmtlgrp1 Type: view BASIC

P_Addmatlgrp1 is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (tvm1) and exposes 2 fields with key field AdditionalMaterialGroup1. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
tvm1 tvm1 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_Addmatlgrp1txt _Text $projection.AdditionalMaterialGroup1 = _Text.AdditionalMaterialGroup1

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName padntmtlgrp1 view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey AdditionalMaterialGroup1 view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY AdditionalMaterialGroup1
_Text _Text 
@AbapCatalog.sqlViewName: 'padntmtlgrp1'
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@Search.searchable: true
//@EndUserText.label: 'additional material grp1'

@ObjectModel.representativeKey: 'AdditionalMaterialGroup1'
define view P_Addmatlgrp1 as select from
tvm1
association [0..*] to P_Addmatlgrp1txt as _Text on $projection.AdditionalMaterialGroup1  = _Text.AdditionalMaterialGroup1
{
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8    
    key cast(mvgr1 as FIRSTSALESSPECPRODUCTGROUP) as AdditionalMaterialGroup1, 
    _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVM1"
],
"ASSOCIATED":
[
"P_ADDMATLGRP1TXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More