SAP Knowledge Base Article - Public

3520247 - Data Source "Registered Product Movement History" Displays Unexpected Date

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

  1. Go to work center Business Analytics.
  2. Access view Design Data Sources.
  3. Search "Registered Product Movement History" (REG_PROD_MH), click Preview.
  4. Under Selection, enter ABC in filter Movement Document ID, click Apply.
  5. Under View, add all available fields into row, in the result there is a serial numbers with date DD_MM_YYYY_1.
  6. 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.
  7. 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

Product

SAP Business ByDesign all versions