I_FuncLocationStructure is a Basic CDS View that provides data about "Functional Location Structure" in SAP S/4HANA. It reads from 1 data source (t370s) and exposes 6 fields with key field FuncLocationStructure. It has 1 association to related views.
@AbapCatalog.compiler.compareFilter: true@EndUserText.label: 'Functional Location Structure'
@VDM.viewType: #BASIC@AbapCatalog.sqlViewName: 'IFLOCSTRUCTURE'
@AccessControl.authorizationCheck:#NOT_REQUIRED@ObjectModel.representativeKey: 'FuncLocationStructure'
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]@ClientHandling.algorithm: #SESSION_VARIABLE@ObjectModel.usageType.dataClass: #CUSTOMIZING@ObjectModel.usageType.serviceQuality: #A@ObjectModel.usageType.sizeCategory: #S@Metadata.ignorePropagatedAnnotations@ObjectModel.alternativeKey:[{id:'OID',element:['FuncLocationStructureCodeOID']}]
//@ObjectModel.sapObjectNodeType.name:'FuncLocationStructureCode'
@ObjectModel.objectIdentifier.oidElement:'FuncnlLocationStructureCodeOID'
defineview I_FuncLocationStructure
asselectfrom t370s
leftouter to one join I_MdiOidConfiguration on I_MdiOidConfiguration.ObjectTypeCode = '3495'
association [0..*] to I_FuncLocationStructureText as _FuncLocationStructureText on _FuncLocationStructureText.FuncLocationStructure = $projection.FuncLocationStructure
{
@ObjectModel.text.association: '_Funclocationstructuretext'
key t370s.tplkz as FuncLocationStructure,
t370s.editm as FuncLocationStructureEditMask,
t370s.stufm as FuncLocationStrucHierLevels,
t370s.level_kz as FuncLocStrucIdentifyingLevel,
t370s.level_kz2 as FuncLocStruc2ndIdentifyingLvl,
//Context ID isnot specified
casewhen I_MdiOidConfiguration.Context is initial
//Composition is disabled
or I_MdiOidConfiguration.ComposeOid is initial thencast( t370s.tplkz as funclocationstructure_oid ) //use your own data element
//Context ID is specified
when I_MdiOidConfiguration.Context isnot initial
// and dd07l.domvalue_l isnot initial
and I_MdiOidConfiguration.ComposeOid isnot initial thencast( concat( concat( I_MdiOidConfiguration.Context, ':' ), t370s.tplkz ) as funclocationstructure_oid ) //use your own data element
endas FuncnlLocationStructureCodeOID, //use your own OID field name
_FuncLocationStructureText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MDIOIDCONFIGURATION",
"T370S"
],
"ASSOCIATED":
[
"I_FUNCLOCATIONSTRUCTURETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/