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 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More