P_AU_STRPBASCALCULATION
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)
| Source | Alias | Join Type |
|---|---|---|
| I_SAPClient | I_SAPClient | from |
Parameters (24)
| Name | Type | Default |
|---|---|---|
| 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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA