FCLM_FLOW_LEVEL

CDS View

Flow level

FCLM_FLOW_LEVEL is a CDS View in S/4HANA. Flow level. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
Fclm_Bseg_Actitem view inner Actual Item in BSEG
Fclm_Bseg_Level view inner BSEG level
Fclm_Bseg_Woactitem view inner BSEG items without actual

Fields (1)

KeyField CDS FieldsUsed in Views
flow_level flow_level 1 
@AbapCatalog.sqlViewName: 'VFCLMFLOWLVL'
@EndUserText.label: 'Flow level'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view Fclm_Flow_Level as 
select from fqmi_flow_cat 
{ 
  key '000' as mandt,
  key flow_category as flow_type,
  key flow_category,key flow_level, 
  case flow_level when '90' then 1  when '80' then 0  else 0 end as count90 
}

union

select from fqmc_flow_type as a inner join fqmi_flow_cat as b 
  on a.flow_category = b.flow_category
{ 
  key a.mandt,
  key a.flow_type,
  key a.flow_category,
  key b.flow_level,
  case flow_level when '90' then 1  when '80' then 0  else 0 end as count90  
}
/*
union 
// this is because fqmi_flow_cat not maintain all the flow type used in BSEG

  select distinct from fqm_flow_cat_kf 
{ 
  key '000' as mandt,
  key flow_category as flow_type,
  key flow_category,
  key substring(flow_category,1,2) as flow_level,
  case substring(flow_category,1,2) when '90' then 1  when '80' then 0  else 0 end as count90 
}
*/
 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FQMC_FLOW_TYPE",
"FQMI_FLOW_CAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More