@AbapCatalog.sqlViewName: 'FIACDOCINGST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey: true
define view FIACCDOCINGST
as select from I_StRpTaxItem
left outer join j_1iexcdefn as _CodeName on I_StRpTaxItem.TaxCalculationProcedure = _CodeName.kalsm
and I_StRpTaxItem.ConditionType = _CodeName.kschl
{
key I_StRpTaxItem.CompanyCode,
key I_StRpTaxItem.AccountingDocument,
key I_StRpTaxItem.FiscalYear,
I_StRpTaxItem.BusinessPlace,
max(I_StRpTaxItem.TaxRate) as kbetr,
max(_CodeName.cond_name) as condname
}
group by
CompanyCode,
AccountingDocument,
FiscalYear,
BusinessPlace
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPTAXITEM",
"J_1IEXCDEFN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/