Updating Keyfigure 0RTPRINSASV & 0RTPRINSAPV in 0RT_C01 Infocube

[Former Member]

Hi

In Sales perspective 0RT_C01 infocube is updated using 2LIS_13_VDITM which in turn is getting value from the base table VBRP. The standard routine does not supply the correct promotion Sales and Cost Value . Wanted to know from which Field of VBRP the value is getting populated.

The routine is given below

IF ( COMM_STRUCTURE-PROCESSKEY = '201'

     OR COMM_STRUCTURE-PROCESSKEY = '202' )

     AND COMM_STRUCTURE-BWAPPLNM EQ 'SD'

* Only promotions Sales are updated.

   AND NOT COMM_STRUCTURE-RT_PROMO IS INITIAL.

* currency convert                                                     *

     IF COMM_STRUCTURE-COST <> 0.       "Value in document UNIT

       PERFORM LOC_CURR_CONVERT

         USING    COMM_STRUCTURE-COST   "Value in doc UNIT

                  COMM_STRUCTURE-TRANS_DATE     "Date for exchange

                  COMM_STRUCTURE-DOC_CURRCY     "Document Currency

                  COMM_STRUCTURE-LOC_CURRCY     "Local currency

                  COMM_STRUCTURE-EXCHG_RATE     "Exchanging rate

         CHANGING RESULT.

       RESULT = COMM_STRUCTURE-NO_INV_IT.

       UNIT = COMM_STRUCTURE-LOC_CURRCY.

       RETURNCODE = 0.

     ELSE.

       RETURNCODE = 4.

     ENDIF.

   ELSE.

     RETURNCODE = 4.

   ENDIF.

There is no promotional value updated in VBRP table . It is calculated based on the condition. Then how is the same updated in these Keyfigures in BI

Regards

Reshoi R

[RamanKorrapati]

Hi,

Have you tried to check the data at RSA3?

can you take abap expert and debug at dev system, you may get idea.

Thanks

[Former Member]

Hi

I tried checking it in RSA3. Just wanted to know how this keyfigure is updated. Whether only 2LIS_13_VDITM is used for updating this or 2LIS_13_VDKON is also used. In our case only 2LIS_13_VDITM is there activated. So in any case, Is it possible to get value using only VDITM?

Regards

Reshoi R

[RamanKorrapati]

Not sure why your comparing with other update rules(VDKON).

Seems like update are standard one, if you want know then just activate VDKON data source and update rules at dev system and check it.

As you said you activate vditm only then you may get data from  vditm only.

you can cross check your cube_display data flow.whether it loading data from multiple data sources or one.

that may give you clear view.