@AbapCatalog: {sqlViewName: 'FISV_OPNITM_01', preserveKey: true}
@EndUserText.label: 'Open Items of Manual Clearing'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.serviceQuality: #P
define view FISVD_OPNITM_01
as select from bseg
left outer join skb1 on bseg.bukrs = skb1.bukrs
and bseg.hkont = skb1.saknr
// association[0..1] to kna1 as kna1_assoc
left outer join kna1 as kna1_assoc on bseg.kunnr = kna1_assoc.kunnr
// association[0..1] to knb1 as knb1_assoc
left outer join knb1 as knb1_assoc on bseg.bukrs = knb1_assoc.bukrs
and bseg.kunnr = knb1_assoc.kunnr
// association[0..1] to lfa1 as lfa1_assoc
left outer join lfa1 as lfa1_assoc on bseg.lifnr = lfa1_assoc.lifnr
// association[0..1] to lfb1 as lfb1_assoc
left outer join lfb1 as lfb1_assoc on bseg.bukrs = lfb1_assoc.bukrs
and bseg.lifnr = lfb1_assoc.lifnr
{
key bseg.bukrs,
key bseg.gjahr,
key bseg.belnr,
key bseg.buzei,
bseg.koart,
bseg.shkzg,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
bseg.dmbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
case bseg.shkzg when 'H' then cast(-bseg.dmbtr as abap.curr( 23,2))
when 'S' then cast( bseg.dmbtr as abap.curr( 23,2))
else cast( bseg.dmbtr as abap.curr( 23,2))
end as dmbtr_shl,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
bseg.wrbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
case bseg.shkzg when 'H' then cast(-bseg.wrbtr as abap.curr( 23,2))
when 'S' then cast( bseg.wrbtr as abap.curr( 23,2))
else cast( bseg.wrbtr as abap.curr( 23,2))
end as wrbtr_shl,
bseg.pswsl,
bseg.zuonr,
bseg.sgtxt,
bseg.rebzg,
bseg.rebzj,
bseg.rebzz,
bseg.rebzt,
bseg.xzahl,
bseg.hkont,
bseg.kunnr,
bseg.lifnr,
bseg.netdt,
bseg.h_bldat,
bseg.h_budat,
@Semantics.currencyCode
bseg.h_waers,
bseg.h_blart,
kna1_assoc.begru as kna1_begru,
knb1_assoc.begru as knb1_begru,
lfa1_assoc.begru as lfa1_begru,
lfb1_assoc.begru as lfb1_begru,
skb1.begru as skb1_begru,
bseg.hkont as konko,
' ' as adrnr
}
where
bseg.augbl = ''
and bseg.augdt = '00000000'
and bseg.koart = 'S'
and bseg.h_bstat != 'D'
and bseg.h_bstat != 'M'
and bseg.umsks = ''
and bseg.umskz = ''
union
select from bseg
left outer join kna1 on bseg.kunnr = kna1.kunnr
left outer join knb1 on bseg.bukrs = knb1.bukrs
and bseg.kunnr = knb1.kunnr
// association[0..1] to lfa1 as lfa1_assoc
left outer join lfa1 as lfa1_assoc on bseg.lifnr = lfa1_assoc.lifnr
// association[0..1] to lfb1 as lfb1_assoc
left outer join lfb1 as lfb1_assoc on bseg.bukrs = lfb1_assoc.bukrs
and bseg.lifnr = lfb1_assoc.lifnr
// association[0..1] to skb1 as skb1_assoc
left outer join skb1 as skb1_assoc on bseg.bukrs = skb1_assoc.bukrs
and bseg.hkont = skb1_assoc.saknr
{
key bseg.bukrs,
key bseg.gjahr,
key bseg.belnr,
key bseg.buzei,
bseg.koart,
bseg.shkzg,
@Semantics: { amount : {currencyCode:'BSEG.H_HWAER' } }
bseg.dmbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_HWAER' } }
case bseg.shkzg when 'H' then cast(-bseg.dmbtr as abap.curr( 23,2))
when 'S' then cast( bseg.dmbtr as abap.curr( 23,2))
else cast( bseg.dmbtr as abap.curr( 23,2))
end as dmbtr_shl,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
bseg.wrbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
case bseg.shkzg when 'H' then cast(-bseg.wrbtr as abap.curr( 23,2))
when 'S' then cast( bseg.wrbtr as abap.curr( 23,2))
else cast( bseg.wrbtr as abap.curr( 23,2))
end as wrbtr_shl,
bseg.pswsl,
bseg.zuonr,
bseg.sgtxt,
bseg.rebzg,
bseg.rebzj,
bseg.rebzz,
bseg.rebzt,
bseg.xzahl,
bseg.hkont,
bseg.kunnr,
bseg.lifnr,
bseg.netdt,
bseg.h_bldat,
bseg.h_budat,
@Semantics.currencyCode
bseg.h_waers,
bseg.h_blart,
kna1.begru as kna1_begru,
knb1.begru as knb1_begru,
lfa1_assoc.begru as lfa1_begru,
lfb1_assoc.begru as lfb1_begru,
skb1_assoc.begru as skb1_begru,
bseg.kunnr as konko,
kna1.adrnr as adrnr
}
where
bseg.augbl = ''
and bseg.augdt = '00000000'
and bseg.koart = 'D'
and bseg.h_bstat != 'D'
and bseg.h_bstat != 'M'
and bseg.umsks = ''
and bseg.umskz = ''
union
select from bseg
left outer join lfa1 on bseg.lifnr = lfa1.lifnr
left outer join lfb1 on bseg.bukrs = lfb1.bukrs
and bseg.lifnr = lfb1.lifnr
// association[0..1] to kna1 as kna1_assoc
left outer join kna1 as kna1_assoc on bseg.kunnr = kna1_assoc.kunnr
// association[0..1] to knb1 as knb1_assoc
left outer join knb1 as knb1_assoc on bseg.bukrs = knb1_assoc.bukrs
and bseg.kunnr = knb1_assoc.kunnr
// association[0..1] to skb1 as skb1_assoc
left outer join skb1 as skb1_assoc on bseg.bukrs = skb1_assoc.bukrs
and bseg.hkont = skb1_assoc.saknr
{
key bseg.bukrs,
key bseg.gjahr,
key bseg.belnr,
key bseg.buzei,
bseg.koart,
bseg.shkzg,
@Semantics: { amount : {currencyCode:'BSEG.H_HWAER' } }
bseg.dmbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_HWAER' } }
case bseg.shkzg when 'H' then cast(-bseg.dmbtr as abap.curr( 23,2))
when 'S' then cast( bseg.dmbtr as abap.curr( 23,2))
else cast( bseg.dmbtr as abap.curr( 23,2))
end as dmbtr_shl,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
bseg.wrbtr,
@Semantics: { amount : {currencyCode:'BSEG.H_WAERS' } }
case bseg.shkzg when 'H' then cast(-bseg.wrbtr as abap.curr( 23,2))
when 'S' then cast( bseg.wrbtr as abap.curr( 23,2))
else cast( bseg.wrbtr as abap.curr( 23,2))
end as wrbtr_shl,
bseg.pswsl,
bseg.zuonr,
bseg.sgtxt,
bseg.rebzg,
bseg.rebzj,
bseg.rebzz,
bseg.rebzt,
bseg.xzahl,
bseg.hkont,
bseg.kunnr,
bseg.lifnr,
bseg.netdt,
bseg.h_bldat,
bseg.h_budat,
@Semantics.currencyCode
bseg.h_waers,
bseg.h_blart,
kna1_assoc.begru as kna1_begru,
knb1_assoc.begru as knb1_begru,
lfa1.begru as lfa1_begru,
lfb1.begru as lfb1_begru,
skb1_assoc.begru as skb1_begru,
bseg.lifnr as konko,
lfa1.adrnr as adrnr
}
where
bseg.augbl = ''
and bseg.augdt = '00000000'
and bseg.koart = 'K'
and bseg.h_bstat != 'D'
and bseg.h_bstat != 'M'
and bseg.umsks = ''
and bseg.umskz = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSEG",
"KNA1",
"KNB1",
"LFA1",
"LFB1",
"SKB1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/