P_Addmatlgrp2

DDL: P_ADDMATLGRP2 SQL: padntmtlgrp2 Type: view BASIC

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

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
tvm2 tvm2 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_Addmatlgrp2txt _Text $projection.AdditionalMaterialGroup2 = _Text.AdditionalMaterialGroup2

Annotations (6)

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

Fields (2)

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

@Search.searchable: true
//@EndUserText.label: 'value help for addionalymatl grp2'

@ObjectModel.representativeKey: 'AdditionalMaterialGroup2'
define view P_Addmatlgrp2 as select from
tvm2
association [0..*] to P_Addmatlgrp2txt as _Text on $projection.AdditionalMaterialGroup2  = _Text.AdditionalMaterialGroup2
{
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8 
     key cast(mvgr2 as SECONDSALESSPECPRODUCTGROUP) as AdditionalMaterialGroup2,
    _Text
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVM2"
],
"ASSOCIATED":
[
"P_ADDMATLGRP2TXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More