SRFHelperSGVATDeclaration

DDL: SRFHELPERSGVATDECLARATION SQL: SRF_SG_VAT_DCL Type: view Package: GLO_FIN_IS_VAT_SG

Calculated Values for SG VAT Declaration

SRFHelperSGVATDeclaration is a CDS View that provides data about "Calculated Values for SG VAT Declaration" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 15 fields. Part of development package GLO_FIN_IS_VAT_SG.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (14)

NameTypeDefault
P_TaxBox01Balance abap.curr( 23,2)
P_TaxBox02Balance abap.curr( 23,2)
P_TaxBox03Balance abap.curr( 23,2)
P_TaxBox05Balance abap.curr( 23,2)
P_TaxBox06Balance abap.curr( 23,2)
P_TaxBox07Balance abap.curr( 23,2)
P_TaxBox09Balance abap.curr( 23,2)
P_TaxBox11Balance abap.curr( 23,2)
P_TaxBox13Balance abap.curr( 23,2)
P_TaxBox14Balance abap.curr( 23,2)
P_TaxBox15Balance abap.curr( 23,2)
P_TaxBox16Balance abap.curr( 23,2)
P_TaxBox17Balance abap.curr( 23,2)
P_TaxBox99Balance abap.curr( 23,2)

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SRF_SG_VAT_DCL view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #P view

Fields (15)

KeyFieldSource TableSource FieldDescription
TaxBox01Balance
TaxBox02Balance
TaxBox03Balance
P_TaxBox99BalanceasTaxBox04Balance
TaxBox05Balance
TaxBox06Balance
TaxBox07Balance
TaxBox08Balance
TaxBox09Balance
TaxBox11Balance
P_TaxBox99BalanceasTaxBox13Balance
TaxBox14Balance
TaxBox15Balance
TaxBox16Balance
TaxBox17Balance 
@AbapCatalog.sqlViewName: 'SRF_SG_VAT_DCL'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#P
define view SRFHelperSGVATDeclaration

  with parameters
    P_TaxBox01Balance : abap.curr( 23,2),
    P_TaxBox02Balance : abap.curr( 23,2),
    P_TaxBox03Balance : abap.curr( 23,2),
    P_TaxBox05Balance : abap.curr( 23,2),
    P_TaxBox06Balance : abap.curr( 23,2),
    P_TaxBox07Balance : abap.curr( 23,2),
    P_TaxBox09Balance : abap.curr( 23,2),
    P_TaxBox11Balance : abap.curr( 23,2),
    P_TaxBox13Balance : abap.curr( 23,2),
    P_TaxBox14Balance : abap.curr( 23,2),
    P_TaxBox15Balance : abap.curr( 23,2),
    P_TaxBox16Balance : abap.curr( 23,2),
    P_TaxBox17Balance : abap.curr( 23,2),
    P_TaxBox99Balance : abap.curr( 23,2)
  as select from I_SAPClient
{
  abs($parameters.P_TaxBox01Balance)                                    as TaxBox01Balance,
  abs($parameters.P_TaxBox02Balance)                                    as TaxBox02Balance,
  abs($parameters.P_TaxBox03Balance)+abs($parameters.P_TaxBox99Balance) as TaxBox03Balance,
  abs($parameters.P_TaxBox01Balance)+abs($parameters.P_TaxBox02Balance)+
  abs($parameters.P_TaxBox03Balance)+abs($parameters.P_TaxBox99Balance) as TaxBox04Balance,
  abs($parameters.P_TaxBox05Balance)                                    as TaxBox05Balance,
  abs($parameters.P_TaxBox06Balance)                                    as TaxBox06Balance,
  abs($parameters.P_TaxBox07Balance)                                    as TaxBox07Balance,
  abs($parameters.P_TaxBox06Balance)- $parameters.P_TaxBox07Balance     as TaxBox08Balance,
  abs($parameters.P_TaxBox09Balance)                                    as TaxBox09Balance,
  abs($parameters.P_TaxBox11Balance)                                    as TaxBox11Balance,
  //tax box 99 is for balance of exchange gain/loss. In case of loss, the balance will be in debit, which is a positive value, so we get the reversed sign instead

  -($parameters.P_TaxBox13Balance + $parameters.P_TaxBox01Balance + $parameters.P_TaxBox02Balance +
   $parameters.P_TaxBox03Balance + $parameters.P_TaxBox99Balance)       as TaxBox13Balance,
  abs($parameters.P_TaxBox14Balance)                                    as TaxBox14Balance,
  abs($parameters.P_TaxBox15Balance)                                    as TaxBox15Balance,
  abs($parameters.P_TaxBox16Balance)                                    as TaxBox16Balance,
  abs($parameters.P_TaxBox17Balance)                                    as TaxBox17Balance

}

Learn More