Variables in SAP BW/BI Reporting

SAP BW Variables Types and Processing types Matrix:









----------------------------------------------------------------------------------------------

 We can check the data provider in the object i_infoprov in debug in RSRT t.code. Check the Code snippet.

IF i_infoprov IS INITIAL
AND cl_rsroa_vq_services=>is_iobj_virtual( i_iobjnm ) = rs_c_true.
i_infoprov = cl_rsroa_vq_services=>get_infoprov_from_iobjnm( i_iobjnm ).
ENDIF.

----------------------------------------------------------------------------------------------
YTD from Input Date
DATA: l_s_range TYPE rsr_s_rangesid,
      loc_var_range type rrrangeexit.

DATA: LV_YEAR(4) TYPE N.
CASE i_vnam.
WHEN 'ZYTD_DATE'.

    IF I_STEP = 2.

      LOOP AT I_T_VAR_RANGE INTO
                LOC_VAR_RANGE WHERE VNAM = 'ZPP_INP'.
        L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW.
        CLEAR ZDAY.
        CLEAR ZMON.
        CLEAR ZYEAR.

      ENDLOOP.
      ZMON = LOC_VAR_RANGE-LOW+4(2).
      ZYEAR = LOC_VAR_RANGE-LOW+0(4).

      IF ZMON EQ '01' OR ZMON EQ '02'
        OR ZMON EQ '03'.
        ZYEAR = ZYEAR - 1.
      ENDIF.
      CLEAR ZMON.

      ZMON = '04'.
      ZDAY = '01'.
      CONCATENATE ZYEAR ZMON ZDAY INTO L_S_RANGE-LOW .

      L_S_RANGE-SIGN = 'I'.
      L_S_RANGE-OPT = 'BT'.
      APPEND L_S_RANGE TO E_T_RANGE.

      EXIT.
    ENDIF.

Previous Fiscal Year from Fiscal Period: (PFY/LFY from OFISCPER)

DATA: l_s_range TYPE rsr_s_rangesid,
      loc_var_range type rrrangeexit.

DATA: LV_YEAR(4) TYPE N.
CASE i_vnam. 
***********Previous Fiscal Year from Fiscal Period  ***********

  WHEN 'ZFY_PY'.

    IF i_step = 2.
      LOOP AT i_t_var_range INTO loc_var_range WHERE vnam = 'ZFYP_IN'.
        LV_YEAR = loc_var_range-low+0(4).
        LV_YEAR = LV_YEAR - 1.
        l_s_range-low = LV_YEAR.
        l_s_range-sign = 'I'.
        l_s_range-opt = 'EQ'.
        APPEND l_s_range TO e_t_range.
      ENDLOOP.
    ENDIF.

Fiscal Year from Fiscal Period (OFISCYEAR from OFISCPER)
DATA: l_s_range TYPE rsr_s_rangesid,
      loc_var_range type rrrangeexit.

DATA: LV_YEAR(4) TYPE N.
CASE i_vnam.

***********Fiscal Year from Fiscal Period  *************

  WHEN 'ZFY_CY'.

    IF i_step = 2.

      LOOP AT i_t_var_range INTO loc_var_range WHERE vnam = 'ZFYP_IN'.
        l_s_range-low = loc_var_range-low+0(4).
        l_s_range-sign = 'I'.
        l_s_range-opt = 'EQ'.
        APPEND l_s_range TO e_t_range.
      ENDLOOP.
    ENDIF.

MTD (MTD from Input Date)

DATA: l_s_range TYPE rsr_s_rangesid,
      loc_var_range type rrrangeexit.

DATA: LV_YEAR(4) TYPE N.
CASE i_vnam.

WHEN 'ZPP_MTD'.

    IF I_STEP = 2.

      LOOP AT I_T_VAR_RANGE INTO
                LOC_VAR_RANGE WHERE VNAM = 'ZPP_INP'.
        L_S_RANGE-HIGH = LOC_VAR_RANGE-LOW.
        CLEAR ZDAY.
        CLEAR ZMON.
        CLEAR ZYEAR.

      ENDLOOP.
      ZMON = LOC_VAR_RANGE-LOW+4(2).
      ZYEAR = LOC_VAR_RANGE-LOW+0(4).

      ZDAY = '01'.
      CONCATENATE ZYEAR ZMON ZDAY INTO L_S_RANGE-LOW .

      L_S_RANGE-SIGN = 'I'.
      L_S_RANGE-OPT = 'BT'.
      APPEND L_S_RANGE TO E_T_RANGE.

      EXIT.
   ENDIF.

Comments

Anonymous said…
Thanks for sharing this Information. Got to learn new things from your Blog on SAP HANA

http://thecreatingexperts.com/category/sap-hana-training-in-chennai/

contact 8122241286
August 2, 2017 at 5:17 PM
Post a Comment

Popular posts from this blog

COPA Extraction Step By Step in SAP BW

Image
COPA Extraction Step by Step: SAP R/3 or SAP ECC: 1. SAP R/3 or ECC goto T.Code KEB0 , In Function: Select Create  Control Parameters: Provide a New CO-PA DataSource Name:1_CO_PA%CL%ERK 2. Select your O perating C oncern, e.g.,IDES. 3. Select radio button Costing-based or Account-based as OC . 4.Select field names for partitioning.e.g. BUKRS (Company Code), Check 5.Click on Info Catalog (F7) 6. Select the Characteristics & Value fields & Keyfigures 7. Select the Package/Development Class for Workbench request 8. Edit your DataSource to select/Hide fields, Save. Datasource created successfully. 9. Extractor Checker or RSA3, extraction. SAP BW:   1. Replicate DataSource 2. Assign InfoSource 3. Transfer all the datasource elements to an InfoSource 4. Activate InfoSource 5. Create a InfoCube (Copy Str from InfoSource) 6. Create Dimension & Define and Assign it. 7. Check & Activate. 8. Create Transformati...
Read more

Types of SAP HANA Editions (HANA Versions)

Image
1) Platform Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer 2) Enterprise Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 3) Enterprise Extended Edition: SAP HANA Database SAP HANA Studio SAP HANA Client  SAP Host Agent SAP HANA Information Composer LT Replication Add-on (SLT) LT Replication Server (SLT) SAP BO Data Services 4.0 Sybase Adaptive Server Enterprise (ASE) Sybase Replication Server (ECDA) Sybase Replication Server Agent SAP HANA Load Controller (Includes R/3 Load, RepServer De-cluster Add-On) It depends on what licenses you already have and how do you intends to use SAP HANA. Platform Edition = ETL via BO Data Services (If the client already have li...
Read more

One stage stop to know all about BW Extractors-Part1

Image
Types of Extractors:               Application specific BW content extractors: Lo Extraction: Logistics refers to the process of getting a product or service to its desired location upon request which involves transportation, purchasing, warehousing etc. Main areas in logistics are: Sales and Distribution (SD) : application 11, 13, 08 (in LBWE T-code) Materials Management (MM) : application 03, 02 Logistics Execution (LE) : application 12 Quality Management : application 05 Plant Maintenance (PM) : application 04, 17 Customer Service (CS) : application 18 Project System (PS) : application 20 SAP Retail : application 40,43,44,45 How the data extraction happens? Extraction can be done using either Full update/delta update. Full load: Incase of l...
Read more