P_SAFTTaxAmountSum

DDL: P_SAFTTAXAMOUNTSUM SQL: PSAFTTAXAMNTSUM Type: view COMPOSITE Package: GLO_FIN_IS_SAFT_GEN

SAFT Get Sum Tax Amount

P_SAFTTaxAmountSum is a Composite CDS View that provides data about "SAFT Get Sum Tax Amount" in SAP S/4HANA. It reads from 1 data source (I_TaxItem) and exposes 9 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_SAFT_GEN.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_TaxItem I_TaxItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSAFTTAXAMNTSUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
TaxCode TaxCode
TaxRate
TaxAmountInCoCodeCrcy
TaxBaseAmountInCoCodeCrcy
TaxAmount
TaxBaseAmountInTransCrcy 
@AbapCatalog.sqlViewName: 'PSAFTTAXAMNTSUM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #P
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking : #NOT_REQUIRED
define view P_SAFTTaxAmountSum
  as select from I_TaxItem
{
  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
      TaxCode,
      max(TaxRate)                                            as TaxRate,

      cast( sum(TaxAmountInCoCodeCrcy) as abap.dec(23,2))     as TaxAmountInCoCodeCrcy,
      cast( max(TaxBaseAmountInCoCodeCrcy) as abap.dec(23,2)) as TaxBaseAmountInCoCodeCrcy,
  // Added amounts in Document Currency    

      cast( sum(TaxAmount) as abap.dec(23,2))     as TaxAmount,
      cast( max(TaxBaseAmountInTransCrcy) as abap.dec(23,2)) as TaxBaseAmountInTransCrcy

}
group by
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  TaxCode
//  TaxBaseAmountInCoCodeCrcy

Learn More