Febvd_Bs_Status_01

DDL: FEBVD_BS_STATUS_01 SQL: FEBV_BS_STAT_01 Type: view

determine posting status fields from FEBEP

Febvd_Bs_Status_01 is a CDS View that provides data about "determine posting status fields from FEBEP" in SAP S/4HANA. It reads from 2 data sources (febep, febep) and exposes 7 fields.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
febep febep from
febep febep union

Parameters (1)

NameTypeDefault
current_esnum abap.numc( 5 )

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FEBV_BS_STAT_01 view
EndUserText.label determine posting status fields from FEBEP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
kukey kukey
esnum esnum
vb1ok vb1ok
vb2ok vb2ok
esnum esnum
vb1ok vb1ok
vb2ok 
@AbapCatalog.sqlViewName: 'FEBV_BS_STAT_01'
@EndUserText.label: 'determine posting status fields from FEBEP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view Febvd_Bs_Status_01 with parameters  current_esnum : abap.numc( 5 ) 
                                               
as select from febep {
  kukey as kukey,
  esnum as esnum,
  vb1ok as vb1ok,
  vb2ok as vb2ok,
  case when vb1ok = 'X' then 'X'
    else case when ak1bl = '' then ''
          else 'X' end end as vb1ok_or_onaccount,
  case when vb2ok = 'X' then 'X'
    else case when akbln = '' then ''
          else 'X' end end as vb2ok_or_onaccount          
}  where esnum != $parameters.current_esnum 

union

select from febep {
kukey as kukey,
esnum as esnum,
vb1ok as vb1ok,
'X'   as vb2ok,
case when vb1ok = 'X' then 'X'
    else case when ak1bl = '' then ''
          else 'X' end end as vb1ok_or_onaccount,
'X'   as vb2ok_or_onaccount          

}  where esnum = $parameters.current_esnum       
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FEBEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More