SAP® Documentation

Single view

/PRA/R_FP_DISPLAY_OGOR_COMPARE - ONRR-2014 - OGOR Compare Report

ROGBILLS - Synchronize billing plans   BAL Application Log Documentation  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

The purpose of this report is to compare the two ONRR government forms, OGOR and 2014. More specifically to ensure that all OGOR master records are set up as 2014 master records; and all 2014 master records are setup in the OGOR master.

Integration

Prerequisites

Prior to running the report, the lease and agreement cross-references should be uploaded in transaction /PRA/FP_UPL_LSE_AGR. The lease and agreement cross-references are stored in database tables /PRA/FP_LEASE_ST and /PRA/FP_AGREE_ST, respectively.

The OGOR and 2014 are reported by lease and/or agreement number, however, the formats of the lease and agreement numbers may differ from the OGOR to the 2014. The cross-references translate the OGOR lease/agreement numbers to the 2014 format and the 2014 lease/agreement numbers to the OGOR format.

The compare report will run without the cross-references, but more mis-match errors may occur.

Features

The report determines whether an OGOR and 2014 master record match by comparing the following in the following order:

  • 2014 Agreement to OGOR Lease
  • 2014 Agreement to OGOR Agency Lease
  • 2014 Agreement to cross-referenced OGOR Lease
  • 2014 Agreement to cross-referenced OGOR Agency Lease
  • 2014 Lease to OGOR Lease
  • 2014 Lease to OGOR Agency Lease
  • 2014 Lease to cross-referenced OGOR Lease
  • 2014 Lease to cross-referenced OGOR Agency Lease

If any of the above match, the master records are considered a match.

For matched records, the report will find the Venture/DOI attached to the Well Completion on a matched OGOR master record and compare it to the Venture/DOI on the matching 2014 master. (Note: the 2014 master can be set up at the Venture/DOI level or the Well completion level. If set up at the Well Completion level, the report will look up the DOI from the WC-to-DOI cross-reference to make the DOI compare.)

If the DOIs do not match, the report will show a DOI error.

Errors, warnings and informational messages can be viewed in the report.

Selection

Standard Variants

Output

The results can be viewed in full-screen format or split-screen format.

The full-screen format outputs to an ALV that shows both the OGOR and 2014 records on a single line. This allows the OGOR and 2014 master records to be sorted together. Buttons across the top filter the data based on errors, warnings and success messages.

The split-screen format outputs the OGOR and 2014 to 2 separate ALVs viewed side-by-side. This allows the OGOR and 2014 records to be sorted and filtered separately.

Activities

Example

In full-screen view, the report may show that an OGOR record for well ABC is missing the equivalent 2014 master record. The match is done on OGOR Lease/Agency Lease to 2014 Lease/Agreement. So if there is a 2014 record for well ABC, but with a different lease, the full-screen view would show these records on 2 different lines, with a "no match" error on each. Switching to the split-screen view and using the standard ALV filter functionality, the OGOR records can be filtered by Well ABC and the 2014 records can be filtered by Well ABC. And the OGOR and 2014 records for well ABC can be viewed side-by-side.






Vendor Master (General Section)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 3774 Date: 20191021 Time: 140751     sap01-206 ( 123 ms )

Our Service

Looking for Support? Questions?

The

Consolut

Callback-Service

Leave us your contact details and we will call you back. Panels marked with * are mandatory.