FIN_DISCOUNTS_VIEW

CDS View

discounts for residuals

FIN_DISCOUNTS_VIEW is a CDS View in S/4HANA. discounts for residuals. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Fdm_Inv_Ref2_View view left_outer Open Invoices and References to invoices 
@AbapCatalog.sqlViewName: 'FIN_DISCOUNTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'discounts for residuals'
define view FIN_DISCOUNTS_VIEW as select 
mandt,
bukrs,
belnr,
gjahr,
sum( case shkzg
       when 'S' then wrbtr else -wrbtr
     end  ) as wrbtr,
sum(case shkzg
       when 'S' then dmbtr else -dmbtr
     end) as dmbtr
from bseg
where ktosl = 'SKT' 
group by mandt, bukrs, belnr, gjahr

Learn More