SRFHelperGBVATDeclaration

DDL: SRF_HELPER_GB_VAT_DCL SQL: SRF_GB_VAT_DCL Type: view

Calculated Values for GB VAT Declaration

SRFHelperGBVATDeclaration is a CDS View that provides data about "Calculated Values for GB VAT Declaration" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 9 fields.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (7)

NameTypeDefault
P_TaxBox01Balance abap.curr( 23,2)
P_TaxBox02Balance abap.curr( 23,2)
P_TaxBox04Balance abap.curr( 23,2)
P_TaxBox06Balance abap.curr( 23,2)
P_TaxBox07Balance abap.curr( 23,2)
P_TaxBox08Balance abap.curr( 23,2)
P_TaxBox09Balance abap.curr( 23,2)

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName SRF_GB_VAT_DCL view
EndUserText.label Calculated Values for GB VAT Declaration view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
TaxBox01Balance
TaxBox02Balance
TaxBox03Balance
TaxBox04Balance
TaxBox05Balance
TaxBox06Balance
TaxBox07Balance
TaxBox08Balance
TaxBox09Balance 
@AbapCatalog.sqlViewName: 'SRF_GB_VAT_DCL'
@EndUserText.label: 'Calculated Values for GB VAT Declaration'
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#D
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED

define view SRFHelperGBVATDeclaration
  with parameters
    P_TaxBox01Balance : abap.curr( 23,2),
    P_TaxBox02Balance : abap.curr( 23,2),
    P_TaxBox04Balance : abap.curr( 23,2),
    P_TaxBox06Balance : abap.curr( 23,2),
    P_TaxBox07Balance : abap.curr( 23,2),
    P_TaxBox08Balance : abap.curr( 23,2),
    P_TaxBox09Balance : abap.curr( 23,2)
  as select from I_SAPClient //dummy select, CDS view only used for calculations

{
  (-1) * $parameters.P_TaxBox01Balance                                    as TaxBox01Balance,
  (-1) * $parameters.P_TaxBox02Balance                                    as TaxBox02Balance,
  (-1) * $parameters.P_TaxBox01Balance + (-1) * $parameters.P_TaxBox02Balance    as TaxBox03Balance,
  $parameters.P_TaxBox04Balance                                    as TaxBox04Balance,
  
  
  abs(((-1) * $parameters.P_TaxBox01Balance + (-1) * $parameters.P_TaxBox02Balance)-($parameters.P_TaxBox04Balance))                      
           as TaxBox05Balance,
  
  cast((-1)*floor($parameters.P_TaxBox06Balance) as abap.dec( 23, 0))   as TaxBox06Balance,
  cast(floor($parameters.P_TaxBox07Balance) as abap.dec( 23, 0))   as TaxBox07Balance,
  cast((-1)*floor($parameters.P_TaxBox08Balance) as abap.dec( 23, 0))   as TaxBox08Balance,
  cast(floor($parameters.P_TaxBox09Balance) as abap.dec( 23, 0))   as TaxBox09Balance
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More