SAP Netweaver Business Intelligence BI / BW

Symptom

You want to use VDATU of the 2LIS_11_VA0ITM DataSource as an “update date for statistics update” in the same way that VDATU of the 2LIS_11_VA0HDR DataSource is used.
However, the 2LIS_11_VA0HDR-VDATU field is important for another reason. It contains the customer request delivery date of the document at header level.
Other terms

Sales order extraction
Reason and Prerequisites

This situation is due to the current system design.
Solution
Modification proposal

To create a field in 2LIS_11_VA0HDR that transfers the “Update date for statistics update” function, proceed as follows:
1. Add the ZZVDATU field to the MCVBAK structure.
2. Add the ZZVDATU field to the MC11VA0HDR structure.
3. Add the following source code lines into EXIT_SAPLRSAP_001:
IF i_control-modus EQ con_modus_new OR
i_control-modus EQ con_modus_newbw OR
i_control-modus EQ con_modus_simbw OR
i_control-modus EQ con_modus_log.
MCVBAK-ZZVDATU = MCVBAK-ERDAT.
ELSE.
MCVBAK-ZZVDATU = MCVBAK-AEDAT.
ENDIF.
The creation date is used accordingly when you create a field and the change date of the sales document is used when you change it.
This proposal is not binding and does not represent a consulting service in this case. For this reason, we will not be responsible for providing any maintenance for problems that might occur in connection with this modification. Therefore, make sure that you discuss this proposal with your consulting partner on site. If you have any further queries about this problem, contact our remote consulting as described in note 82149 by creating a message under the XX RC component.