Symptom
When search movement document ABC (ABC represents document ID) in data source "Registered Product Movement History" (REG_PROD_MH) , it displays the date of another document.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to work center Business Analytics.
- Access view Design Data Sources.
- Search "Registered Product Movement History" (REG_PROD_MH), click Preview.
- Under Selection, enter ABC in filter Movement Document ID, click Apply.
- Under View, add all available fields into row, in the result there is a serial numbers with date DD_MM_YYYY_1.
- Check the master data of this serial number, under tab Detailed Inventory Tracking, Goods and Activity Confirmation (GAC) DEF (DEF represents GAC ID) is the last active document, it has date as DD_MM_YYYY_1; the active document earlier that that is GAC ABC, with date DD_MM_YYYY_2.
- Since in above step 3, GAC ABC is maintained in filter, the actual execution date of this GAC, which is DD_MM_YYYY_2, is expected to display as date in data source result.
Cause
The characteristic Date in data source REG_PROD_MH maps with the last change date and time of the serial number tracking. Since the last active document GAC DEF has date DD_MM_YYYY_1, then in data source REG_PROD_MH the characteristic Date will display this date, even when another movement document GAC ABC is filtered.
Resolution
This is system standard behavior.
Keywords
Registered Product Movement History, REG_PROD_MH, Movement Document, Date, Serial Number, Tracking , KBA , AP-IP-INV , Inventory , Problem