1. SAP Tutorial
  2. Oil & Gas

OIUH_PTR_REP_LOG SAP table for – Production, Tax and Royalty Reporting Execution Log

Here we would like to draw your attention to OIUH_PTR_REP_LOG table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUH_PTR_REP_LOG is a SAP standard transp table used for storing Production, Tax and Royalty Reporting Execution Log related data in SAP. It comes under the package OIU_H.

SAP OIUH_PTR_REP_LOG table

Table OIUH_PTR_REP_LOG technical data

TableOIUH_PTR_REP_LOG
Data storingProduction, Tax and Royalty Reporting Execution Log
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_PTR_REP_LOG Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUH_PTR_REP_LOG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • JIL : Jil Name
    Its a key field. Its data type is CHAR (Character String) with field length 40
  • .INCLUDE : Report Execution key parameters
    Its a key field.
  • REP_YEAR : Reporting Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • REP_MONTH : Reporting Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • OR1_OR_LVL_1_NO : Company Level 1 – (ORG1)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • AC_INDICATOR : Amended/current Report Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • STATE : Primary geographical location (PRI geo. loc.)
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • REG_NUMBER : Regulatory Reporting Run Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • STATUS : Production: Regulatory Rep. – Run Status
    Its data type is CHAR (Character String) with field length 2
  • JOBNAME : Background job name
    Its data type is CHAR (Character String) with field length 32
  • JOBCOUNT : Job ID
    Its data type is CHAR (Character String) with field length 8
  • .INCLUDE : Regulatory, Tax and Royalty reporting parameter
  • OR2_OR_LVL_2_NO : Second-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 1
  • OR3_OR_LVL_3_NO : Third-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 3
  • OR4_OR_LVL_4_NO : Fourth-highest organization level number ( Company Code)
    Its data type is CHAR (Character String) with field length 2
  • TF_INDICATOR : Trial/Final Indicator
    Its data type is CHAR (Character String) with field length 1
  • TF_INDICATOR_YN : Trial/Final Indicator (Yes/No)
    Its data type is CHAR (Character String) with field length 1
  • PRODUCT : Product Code for Reporting
    Its data type is CHAR (Character String) with field length 1
  • SUBLEDGER_TYPE : SubLedger Type
    Its data type is CHAR (Character String) with field length 2
  • INTERCOMPANY_FL : InterCompany Flag
    Its data type is CHAR (Character String) with field length 1
  • TAXTYPE : Severance Tax Type
    Its data type is CHAR (Character String) with field length 2
  • REP_TYPE : Report type used in e.g. Jil TRB340A
    Its data type is CHAR (Character String) with field length 6
  • REP_ID : REPORT id use in jil trb550a
    Its data type is CHAR (Character String) with field length 7
  • HYEAR : FILLING MONTH OF
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15

    • OIUH_PTR_REP_LOG related tables

    • OIUH_RV_BT : Balance Transfer Table
    • OIUH_RV_ARSL_H : Oil and Gas appl table
    • OIUH_RV_CCH : Obsolete (4.72)-keep for 1 minor release- Cdex Check History
    • OIUH_PR_RRWY : Oil and Gas appl table
    • OIUH_RV_OPSL_H : Oil and Gas OPSL History Table
    • OIUH_RV_PAC : Property Affiliated Company
    • OIUH_RV_COA : Chart of Accounts
    • OIUH_RV_VCHDD : Void Check Deductions Detail
    • OIUH_RV_COADV : Colorado Ad Valorem
    • OIUH_RV_CNL : Cdex New Lease
    • OIUH_RV_DTWK : Deduction/Tax Work Table
    • OIUH_RV_CLT : Contract — Long Term
    • OIUH_RV_DOEX : Owner State Tax Exemption
    • OIUH_RV_CR : Check Register
    • OIUH_PR_TXBBA : Oil and Gas appl table
    • OIU_CM_BATCH_TX : Batch Job Name
    • OIUH_PR_MMSBA : Oil and Gas appl table
    • OIUH_RV_RPAD : Royalty Processing Allowance Detail
    • OIUH_RV_DPPC : DOI Product Processed Control
    • OIUH_RV_NDPUR : North Dakota Tax History Oil Detail For Purchasers

    OIUH_PTR_REP_LOG related transaction codes under SAP package OIU_H

    • OIUH_JE01 : Account Maintenance
    • OIUH_TR01 : Tax and Royalty Profile
    • O3UH_VC_CP : Void/Cleared Check Purge
    • O3UH_ARJE : A/R Journal Entry Generation
    • OIUH_RD08 : Negative Payable/Suspence
    • OIUH_VL10 : Purchaser/Remitter Cross Reference
    • O3UH_NA_PU : Negative Amount Purge
    • O3UH_TP_WO : Taxes Payable Write Off
    • OIUH_RD14 : Owner Interest Calculation
    • OIUH_DO08 : DOI Owner Accounting Entry code
    • O3UH_CR_NA : Create Negative Amounts
    • S_SOG_81000030 : IMG activity: OIUH_PREMAS_NR
    • OIUH_JE10 : Miscellaneous Subledger Query
    • OIUH_JE16 : Expense Subledger Query
    • O3UH_OUT_CDEX : Outbound CDEX
    • O3UH_AR_UP : Accounts Receivable Update
    • OIUH_CI06 : Product/Property Translations
    • S_SOG_81000122 : IMG activity: OIUH_LA_PARISH
    • OIUH_CI04 : Remitter/Layout Cross Reference
    • OIUH_TR06 : Colorado Ad Valorem

    Related References

    Related Tutorials

    OIUY1_EXEC_STATD SAP table for – Execution Statistics for Royalty Reporting

    OIUY1_EXEC_STATD table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_EXEC_COMB SAP table for – Execution Combinations for Tax Reporting

    OIUX1_EXEC_COMB table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_ACTIVATE SAP table for – Reg./Tax and Royalty Reporting – report activation

    OIUREP_ACTIVATE table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_LGL_RPTS SAP table for – Legal Reports for Tax and Royalty Reporting

    OIUREP_LGL_RPTS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUREP_ROY_AGY SAP table for – Reporting Agencies for Tax and Royalty

    OIUREP_ROY_AGY table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_EXEC_STAT SAP table for – Execution Statistics for Tax Reporting

    OIUX1_EXEC_STAT table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX2_EXEC_STATD SAP table for – Execution Statistics for Tax Reporting

    OIUX2_EXEC_STATD table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »