P_AU_STRPBASCALCULATION

DDL: P_AU_STRPBASCALCULATION SQL: PAUSTRPBASCAL Type: view COMPOSITE

P_AU_STRPBASCALCULATION is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 6 fields.

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (24)

NameTypeDefault
P_w2 figen_wth_amt_withheld
P_w3 figen_wth_other_amounts
P_w4 figen_wth_amt_with_no_abn
P_t1 figen_payg_instalment_income
P_t2 figen_payg_taxoffice_rate
P_t3 figen_payg_new_rate
P_t7 figen_payg_instalment_amount
P_t9 figen_payg_amount_payable
P_f1 figen_fbt_instalment_amount
P_f3 figen_fbt_varied_amount
P_1a figen_summ_gst_on_sales
P_1c figen_summ_wine_eq
P_1e figen_summ_luxury_car_tax_payb
P_7 figen_summ_deffered_company
P_7a figen_summ_deff_gst
P_1b figen_summ_gst_on_purchases
P_1d figen_summ_wet_refundable
P_1f figen_summ_luxurycar_taxrefund
P_g9 fiau_taxbox9
P_g21 figen_gst_instalment_amount
P_g23 figen_gst_varied_amt_payable
P_g20 fiau_taxbox20
P_gst1 boolean
P_gst3 boolean

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PAUSTRPBASCAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
AU_TotalWhldgAmtInRptgCrcy
P_t31002endasAU_BASInstlmntAmtInRptgCrcy
AU_FringeBnftInstlmntAmt
AU_FringeBenefitVariantAmt
AU_PAYGIncInstlmntAmt
AU_PAYGIncInstlmntVariationAmt
@AbapCatalog.sqlViewName: 'PAUSTRPBASCAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED

define view P_AU_STRPBASCALCULATION
  with parameters
  
    P_w2 :figen_wth_amt_withheld,
    P_w3 :figen_wth_other_amounts,
    P_w4 :figen_wth_amt_with_no_abn,
    P_t1 :figen_payg_instalment_income,
    P_t2 :figen_payg_taxoffice_rate,
    P_t3 :figen_payg_new_rate,
    P_t7 :figen_payg_instalment_amount,
    P_t9 :figen_payg_amount_payable,
    P_f1 :figen_fbt_instalment_amount,
    P_f3 :figen_fbt_varied_amount,     
    P_1a :figen_summ_gst_on_sales,
    P_1c :figen_summ_wine_eq,
    P_1e :figen_summ_luxury_car_tax_payb,
    P_7  :figen_summ_deffered_company,
    P_7a :figen_summ_deff_gst,
    P_1b :figen_summ_gst_on_purchases,
    P_1d :figen_summ_wet_refundable,
    P_1f :figen_summ_luxurycar_taxrefund,
    P_g9 : fiau_taxbox9,
    P_g21 : figen_gst_instalment_amount,
    P_g23 : figen_gst_varied_amt_payable,
    P_g20 : fiau_taxbox20,
    P_gst1 : boolean,
    P_gst3 : boolean
    
  as select from I_SAPClient
{   
  case $parameters.P_gst1 when 'X' 
    then $parameters.P_g9 + 0 
    else case $parameters.P_gst3 when 'X' 
            then case $parameters.P_g23 when 0 then $parameters.P_g21 + 0 else $parameters.P_g23 + 0 end 
    else 0 end   
   end  as AU_GSTSlsAmtOrGSTInstlmntAmt, //1A

  
  case    $parameters.P_gst1 when 'X'
    then $parameters.P_g20 + 0
    else 0 end as GSTOnPurchaseAmtInRptgCrcy, //1B

    
    
  $parameters.P_w2 + $parameters.P_w3 + $parameters.P_w4 as AU_TotalWhldgAmtInRptgCrcy, //W5


  case $parameters.P_t3
  when 0
  then division($parameters.P_t1 * $parameters.P_t2 , 100, 2)
  else division($parameters.P_t1 * $parameters.P_t3, 100, 2)
  end                                                    as AU_BASInstlmntAmtInRptgCrcy, //T11

  
$parameters.P_f1  as AU_FringeBnftInstlmntAmt,
$parameters.P_f3  as AU_FringeBenefitVariantAmt,  
$parameters.P_t7  as AU_PAYGIncInstlmntAmt,
$parameters.P_t9  as AU_PAYGIncInstlmntVariationAmt

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/