Skip to Content
0
Apr 22, 2014 at 01:14 PM

Updating Keyfigure 0RTPRINSASV & 0RTPRINSAPV in 0RT_C01 Infocube

32 Views

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