You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntry

in Reporting and Analytics for ERP

Summary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Filter turned off, ElementEntryPVO returns over 250 million records, whereas ElementEntry returns only around 400,000 records.

Compared to ElementEntry, the ElementEntryPVO object is missing two key date columns: EffectiveStartDate1 and EffectiveEndDate1. Because these date-effective columns are absent, ElementEntryPVO ends up containing a large number of duplicate rows (one for each historical change).

Questions:

  • Is there any official documentation that explains why ElementEntry has significantly fewer records (i.e., why it appears to be date-effective/de-duplicated while ElementEntryPVO
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!