SAP Knowledge Base Article - Preview

1887350 - Sales Rapid mart not using $G_EDATE in where clause, causing delta jobs to return incorrect data sets

Symptom

R3_BillingFact ABAP Dataflow inside the Sales Rapid Mart should be using $G_EDATE as a selection parameter as noted in the DF comment:

 rmissue.png

 

The RM_Sales_DataServicesDesign_EN_XX.doc also mentions the use of $G_EDATE in section 2.5.3.2:

 rmissue2.png

However, in some versions of the Sales Rapid Mart the query in the DataFlow only uses $G_SDATE; $G_EDATE is omitted.

The result is that delta loads will load all data from $G_SDATE to the current date, unless the you manually add $G_EDATE to the where clause.   


Read more...

Product

SAP BusinessObjects Business Intelligence, Edge edition 4.0, version with data integration

Keywords

RM, rapidmart, wrong, large, incorrect, global , KBA , EIM-RMA , Rapid Marts, BOW , EIM-DS-SAP , SAP Interfaces , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.