I_FldLogsMaterialText

DDL: I_FLDLOGSMATERIALTEXT SQL: IFLMATTEXT Type: view COMPOSITE

FL Return Material Text view

I_FldLogsMaterialText is a Composite CDS View that provides data about "FL Return Material Text view" in SAP S/4HANA. It reads from 3 data sources (I_FieldLogisticsPlantAll, I_FldLogsSupplierItem, I_FldLogsSupplierItem) and exposes 6 fields with key fields Material, Language, FldLogsSuplrItemUUID, Language, FldLogsSuplrItemUUID. It has 1 association to related views.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_FieldLogisticsPlantAll _FldLogsAllPlants inner
I_FldLogsSupplierItem I_FldLogsSupplierItem from
I_FldLogsSupplierItem I_FldLogsSupplierItem union_all

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FldLogsMaterialTextBasic _MaterialText _MaterialText.Material = $projection.Material

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFLMATTEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label FL Return Material Text view view
Search.searchable true view
ObjectModel.dataCategory #TEXT view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Material view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Material _Material Material
KEY Language _MaterialText Language
KEY FldLogsSuplrItemUUID
KEY Language
KEY FldLogsSuplrItemUUID FldLogsSuplrItemUUID
MaterialName FldLogsSuplrItemName 
@AbapCatalog.sqlViewName: 'IFLMATTEXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'FL Return Material Text view'
@Search.searchable: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'Material'

define view I_FldLogsMaterialText
  as select distinct from I_MaterialPlant          as _Material
    inner join            I_FieldLogisticsPlantAll as _FldLogsAllPlants on _FldLogsAllPlants.Plant = _Material.Plant
  association [0..*] to I_FldLogsMaterialTextBasic as _MaterialText on _MaterialText.Material = $projection.Material
{
  key    _Material.Material,
  key    _MaterialText.Language,
  key    hextobin( '00000000000000000000000000000000' ) as FldLogsSuplrItemUUID,
         @Search.defaultSearchElement: true
         _MaterialText.MaterialName
}

union all select from I_FldLogsSupplierItem
{
  key    FldLogsSuplrItemSerialNumber as Material,
  key    'E'                          as Language,
  key    FldLogsSuplrItemUUID,
         FldLogsSuplrItemName         as MaterialName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIELDLOGISTICSPLANTALL",
"I_FLDLOGSMATERIALTEXTBASIC",
"I_FLDLOGSSUPPLIERITEM",
"I_MATERIALPLANT"
],
"ASSOCIATED":
[
"I_FLDLOGSMATERIALTEXTBASIC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More