P_Addmatlgrp4

DDL: P_ADDMATLGRP4 SQL: padntmtlgrp4 Type: view BASIC

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

Data Sources (1)

SourceAliasJoin Type
tvm4 tvm4 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_Addmatlgrp4txt _Text $projection.AdditionalMaterialGroup4 = _Text.AdditionalMaterialGroup4

Annotations (6)

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

Fields (2)

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

@Search.searchable: true
//@EndUserText.label: 'value help for addional matl grp4'

@ObjectModel.representativeKey: 'AdditionalMaterialGroup4'
define view P_Addmatlgrp4 as select from
tvm4
association [0..*] to P_Addmatlgrp4txt as _Text on $projection.AdditionalMaterialGroup4  = _Text.AdditionalMaterialGroup4
{
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8 
    key cast(mvgr4 as FOURTHSALESSPECPRODUCTGROUP) as AdditionalMaterialGroup4 ,
    _Text
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TVM4"
],
"ASSOCIATED":
[
"P_ADDMATLGRP4TXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/