FCO_MIG_VERSNE
Info from FINSC_CMP_VERSNC per ledger
FCO_MIG_VERSNE is a CDS View in S/4HANA. Info from FINSC_CMP_VERSNC per ledger. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCO_MIG_ACDOCA | view | inner | CO Delta Entries - Aggregated ACDOCA Records |
@AbapCatalog.sqlViewName: 'FCOV_MIG_VERSNE'
@EndUserText.label: 'Info from FINSC_CMP_VERSNC per ledger'
@ObjectModel.usageType.serviceQuality: #P
define view FCO_MIG_VERSNE as
select mandt, bukrs, rldnr,
max( case when versn.wkgbtr = 'OSL' then 1
when versn.wogbtr = 'OSL' then 1
when versn.wkfbtr = 'OSL' then 1
when versn.pagbtr = 'OSL' then 1
when versn.pafbtr = 'OSL' then 1
else 0 end ) as rocur,
max( case when versn.wkgbtr = 'VSL' then 1
when versn.wogbtr = 'VSL' then 1
when versn.wkfbtr = 'VSL' then 1
when versn.pagbtr = 'VSL' then 1
when versn.pafbtr = 'VSL' then 1
else 0 end ) as rvcur,
max( case when versn.wkgbtr = 'BSL' then 1
when versn.wogbtr = 'BSL' then 1
when versn.wkfbtr = 'BSL' then 1
when versn.pagbtr = 'BSL' then 1
when versn.pafbtr = 'BSL' then 1
else 0 end ) as rbcur,
max( case when versn.wkgbtr = 'CSL' then 1
when versn.wogbtr = 'CSL' then 1
when versn.wkfbtr = 'CSL' then 1
when versn.pagbtr = 'CSL' then 1
when versn.pafbtr = 'CSL' then 1
else 0 end ) as rccur,
max( case when versn.wkgbtr = 'DSL' then 1
when versn.wogbtr = 'DSL' then 1
when versn.wkfbtr = 'DSL' then 1
when versn.pagbtr = 'DSL' then 1
when versn.pafbtr = 'DSL' then 1
else 0 end ) as rdcur,
max( case when versn.wkgbtr = 'ESL' then 1
when versn.wogbtr = 'ESL' then 1
when versn.wkfbtr = 'ESL' then 1
when versn.pagbtr = 'ESL' then 1
when versn.pafbtr = 'ESL' then 1
else 0 end ) as recur,
max( case when versn.wkgbtr = 'FSL' then 1
when versn.wogbtr = 'FSL' then 1
when versn.wkfbtr = 'FSL' then 1
when versn.pagbtr = 'FSL' then 1
when versn.pafbtr = 'FSL' then 1
else 0 end ) as rfcur,
max( case when versn.wkgbtr = 'GSL' then 1
when versn.wogbtr = 'GSL' then 1
when versn.wkfbtr = 'GSL' then 1
when versn.pagbtr = 'GSL' then 1
when versn.pafbtr = 'GSL' then 1
else 0 end ) as rgcur,
max( case when versn.wtgbtr = 'WSL' then 1
else 0 end ) as wsl,
max( case when versn.wtgbtr = 'WSL2' then 1
else 0 end ) as wsl2,
max( case when versn.wtgbtr = 'WSL3' then 1
else 0 end ) as wsl3,
max( case when versn.wkgbtr = 'HSL' then 1
when versn.wogbtr = 'HSL' then 1
when versn.wkfbtr = 'HSL' then 1
when versn.pagbtr = 'HSL' then 1
when versn.pafbtr = 'HSL' then 1
else 0 end ) as hsl,
max( case when versn.wkgbtr = 'KSL' then 1
when versn.wogbtr = 'KSL' then 1
when versn.wkfbtr = 'KSL' then 1
when versn.pagbtr = 'KSL' then 1
when versn.pafbtr = 'KSL' then 1
else 0 end ) as ksl,
max( case when versn.wkgbtr = 'OSL' then 1
when versn.wogbtr = 'OSL' then 1
when versn.wkfbtr = 'OSL' then 1
when versn.pagbtr = 'OSL' then 1
when versn.pafbtr = 'OSL' then 1
else 0 end ) as osl,
max( case when versn.wkgbtr = 'VSL' then 1
when versn.wogbtr = 'VSL' then 1
when versn.wkfbtr = 'VSL' then 1
when versn.pagbtr = 'VSL' then 1
when versn.pafbtr = 'VSL' then 1
else 0 end ) as vsl,
max( case when versn.wkgbtr = 'BSL' then 1
when versn.wogbtr = 'BSL' then 1
when versn.wkfbtr = 'BSL' then 1
when versn.pagbtr = 'BSL' then 1
when versn.pafbtr = 'BSL' then 1
else 0 end ) as bsl,
max( case when versn.wkgbtr = 'CSL' then 1
when versn.wogbtr = 'CSL' then 1
when versn.wkfbtr = 'CSL' then 1
when versn.pagbtr = 'CSL' then 1
when versn.pafbtr = 'CSL' then 1
else 0 end ) as csl,
max( case when versn.wkgbtr = 'DSL' then 1
when versn.wogbtr = 'DSL' then 1
when versn.wkfbtr = 'DSL' then 1
when versn.pagbtr = 'DSL' then 1
when versn.pafbtr = 'DSL' then 1
else 0 end ) as dsl,
max( case when versn.wkgbtr = 'ESL' then 1
when versn.wogbtr = 'ESL' then 1
when versn.wkfbtr = 'ESL' then 1
when versn.pagbtr = 'ESL' then 1
when versn.pafbtr = 'ESL' then 1
else 0 end ) as esl,
max( case when versn.wkgbtr = 'FSL' then 1
when versn.wogbtr = 'FSL' then 1
when versn.wkfbtr = 'FSL' then 1
when versn.pagbtr = 'FSL' then 1
when versn.pafbtr = 'FSL' then 1
else 0 end ) as fsl,
max( case when versn.wkgbtr = 'GSL' then 1
when versn.wogbtr = 'GSL' then 1
when versn.wkfbtr = 'GSL' then 1
when versn.pagbtr = 'GSL' then 1
when versn.pafbtr = 'GSL' then 1
else 0 end ) as gsl,
max( case when versn.wkgbtr = 'KFSL' then 1
when versn.wogbtr = 'KFSL' then 1
when versn.wkfbtr = 'KFSL' then 1
when versn.pagbtr = 'KFSL' then 1
when versn.pafbtr = 'KFSL' then 1
else 0 end ) as kfsl,
max( case when versn.wkgbtr = 'KFSL2' then 1
when versn.wogbtr = 'KFSL2' then 1
when versn.wkfbtr = 'KFSL2' then 1
when versn.pagbtr = 'KFSL2' then 1
when versn.pafbtr = 'KFSL2' then 1
else 0 end ) as kfsl2,
max( case when versn.wkgbtr = 'KFSL3' then 1
when versn.wogbtr = 'KFSL3' then 1
when versn.wkfbtr = 'KFSL3' then 1
when versn.pagbtr = 'KFSL3' then 1
when versn.pafbtr = 'KFSL3' then 1
else 0 end ) as kfsl3,
max( case when versn.wkgbtr = 'PSL' then 1
when versn.wogbtr = 'PSL' then 1
when versn.wkfbtr = 'PSL' then 1
when versn.pagbtr = 'PSL' then 1
when versn.pafbtr = 'PSL' then 1
else 0 end ) as psl,
max( case when versn.wkgbtr = 'PSL2' then 1
when versn.wogbtr = 'PSL2' then 1
when versn.wkfbtr = 'PSL2' then 1
when versn.pagbtr = 'PSL2' then 1
when versn.pafbtr = 'PSL2' then 1
else 0 end ) as psl2,
max( case when versn.wkgbtr = 'PSL3' then 1
when versn.wogbtr = 'PSL3' then 1
when versn.wkfbtr = 'PSL3' then 1
when versn.pagbtr = 'PSL3' then 1
when versn.pafbtr = 'PSL3' then 1
else 0 end ) as psl3,
max( case when versn.wkgbtr = 'PFSL' then 1
when versn.wogbtr = 'PFSL' then 1
when versn.wkfbtr = 'PFSL' then 1
when versn.pagbtr = 'PFSL' then 1
when versn.pafbtr = 'PFSL' then 1
else 0 end ) as pfsl,
max( case when versn.wkgbtr = 'PFSL2' then 1
when versn.wogbtr = 'PFSL2' then 1
when versn.wkfbtr = 'PFSL2' then 1
when versn.pagbtr = 'PFSL2' then 1
when versn.pafbtr = 'PFSL2' then 1
else 0 end ) as pfsl2,
max( case when versn.wkgbtr = 'PFSL3' then 1
when versn.wogbtr = 'PFSL3' then 1
when versn.wkfbtr = 'PFSL3' then 1
when versn.pagbtr = 'PFSL3' then 1
when versn.pafbtr = 'PFSL3' then 1
else 0 end ) as pfsl3
from finsc_cmp_versnc as versn
group by mandt, bukrs, rldnr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINSC_CMP_VERSNC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/