PSCD Cleared Item Actual/Forecast Chart

Query Query: 0PSCD_MC1_Q0002

The aim of the queries is to give an overview of the revenue situation. You use the query within the application Tax and Revenue Management Visual Composer. However, the query only displays data when the revenues are less than expected.

Structure

Filters
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Request ID 0REQUID

Variable current data (transactional infocube ) (0S_RQTRA)

Characteristic Characteristic Fiscal Year Variant 0FISCVARNT

Calender year, 4 special periods (C4)

Characteristic Characteristic Fiscal year 0FISCYEAR

Variable current fiscal year (SAP Exit) (0FYEAR)

Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Industry code 0BPARTNER_0IND_CODE

Characteristic Characteristic Contract account category 0FC_ACCTCAT

Characteristic Characteristic Country key oBPARTNER__0COUNTRY

Characteristic Characteristic Region oBPARTNER__REGION

Columns
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic YTE Actual Forecast

0FISCPER = 0I_CFYTD

0VERSION = 1

1KYFNM = 0FC_CI

Characteristic Characteristic YTE Plan

0FISCPER = 0I_CFYTD

0VERSION = 1

1KYFNM = 0FC_CI

Characteristic Characteristic YTD Actual

0FISCPER = 0I_CFYTD

0VERSION = 1

1KYFNM = 0FC_CI

Characteristic Characteristic YTD Plan

0FISCPER = 0I_CFYTD

0VERSION = 1

1KYFNM = 0FC_CI

Characteristic Characteristic YTEActualForecast < YTE Plan

Invisible column YTD Actual < YTD Plan

Characteristic Characteristic YTDActual < YTDPlan

Invisible column YTD Actual < YTD Plan

Views
Object Type Name Technical Name Description
PSCD Cleared Item Actual/Forecast -Table - Account Category 0PSCD_MC1_Q0002_V01

-

PSCD Cleared Item Actual/Forecast -Table - Industry Code 0PSCD_MC1_Q0002_V02

-

PSCD Cleared Item - Actual/Forecast -Table - Region 0PSCD_MC1_Q0002_V03

-