1. SAP Tutorial
  2. Oil & Gas

OIUH_RV_TPPN SAP table for – Tr PPN

Here we would like to draw your attention to OIUH_RV_TPPN 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_RV_TPPN is a SAP standard transp table used for storing Tr PPN related data in SAP. It comes under the package OIU_H.

SAP OIUH_RV_TPPN table

Table OIUH_RV_TPPN technical data

TableOIUH_RV_TPPN
Data storingTr PPN
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_RV_TPPN 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_RV_TPPN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DUMMY_SEQ_FIELD : OIUH_CHAR10
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • TPPN_MP_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_MP_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • TPPN_WL_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_WL_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • TPPN_WC_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_WC_NO : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • TPPN_PR_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_PR_NO : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • TPPN_DOI_NO9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_DOI_NO : OIUH_CHAR5
    Its data type is CHAR (Character String) with field length 5
  • TPPN_MAJ_PD_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_PD_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • TPPN_ST_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • PPN_EFF_FROM_DT : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14
  • TPPN_EFF_TO_DT : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14
  • PN_EFF_TO_DT_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_ST_RPT_NO : OIUH_CHAR13
    Its data type is CHAR (Character String) with field length 13
  • TPPN_ST_PRDR_CD : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • TPPN_TAX_PAY_CD : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • PPN_PLT_PRCS_CD : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • PN_OIL_CLASS_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_GAS_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • N_CONTINUITY_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_CONS_WL_NO : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • TPPN_WL_SER_NO : OIUH_CHAR6
    Its data type is CHAR (Character String) with field length 6
  • TPPN_ST_FL_CD : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • TPPN_OFF_LSE_CD : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • TPPN_TXN_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • TPPN_ALLOC_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • TPPN_ENTY_CD : OIUH_CHAR2
    Its data type is CHAR (Character String) with field length 2
  • PPN_EXIN_DEC_AM : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PPN_EX_RE_ALC_PC : OIUH_DEC9_8
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • N_SCHOL_DIST_CD : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • TPPN_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • TPPN_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • TPPN_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14

    • OIUH_RV_TPPN related tables

    • OIUH_CM_STATE : State Codes Table
    • OIUH_RV_RDTSW : Texas Royalty Detail Sweet And Sour Table
    • OIUH_RV_LSSL : Journal Entry Legal Suspense Subledger Table
    • OIUH_RV_JE : Journal Entry
    • OIUH_CDEX_PROD : Mapping Product code with CDEX Product Code
    • OIUH_RV_DTWK : Deduction/Tax Work Table
    • OIUH_RV_RPAD : Royalty Processing Allowance Detail
    • OIUH_RV_DOH : DOI Owner History
    • OIUH_RV_GRP : Group Number And Description
    • OIUH_RV_DAVT : DOI Ad Valorem Tax
    • OIUH_PR_TXBBA : Oil and Gas appl table
    • OIUH_RV_CDTRAN : Transaction Code Cross Reference With Deduction Type Code
    • OIUH_AR_BAL : AR Balance categories (TBLRD044)
    • OIUH_X_EP2RZ : Razorfish To PRA Cross Reference
    • OIUH_CM_SRBT : Oil and Gas appl table
    • OIUH_CM_CTTYP : Oil and Gas appl table
    • OIUH_RV_PUC : Property Unit Use Control
    • OIUH_RV_DOACC : DOI Owner Override Acct Codes
    • OIUH_PR_MP : Measurement Point
    • OIUH_RV_BC : Batch Control

    OIUH_RV_TPPN related transaction codes under SAP package OIU_H

    • O3UH_ACCT_CLOSE : Accounting Period Close
    • OIUH_JE18 : Accounts Payable Subledger Query
    • OIUH_CI04 : Remitter/Layout Cross Reference
    • OIUH_JE15 : Income Subledger Query
    • O3UH_NA_IN : Negative Amount Invoice
    • O3UH_ARJE : A/R Journal Entry Generation
    • S_SOG_81000030 : IMG activity: OIUH_PREMAS_NR
    • O3UH_TC : Treasury Check
    • OIUH_TR02 : Severance Tax Master File
    • O5UH_JE03 : Accounting Category
    • OIUH_JE02 : Account Entry Control
    • OIUH_DO08 : DOI Owner Accounting Entry code
    • OIUH_JE05 : Manual Journal Entry
    • OIUH_TR04 : Severance Tax Transaction
    • O3UH_AR_UP : Accounts Receivable Update
    • S_SOG_81000120 : IMG activity: OIUH_LEGEND_CODE
    • O3UH_ES : Escheat Processing
    • O3UH_FLASH_DOWNLOAD : Download Reporting Flashforms
    • OIUH_RD03 : Owner Check
    • OIUH_RD04 : Owner 1099 Information

    Related References

    Related Tutorials

    OIU_PR_HPPND SAP table for – Volumetric Historical PPN Detail

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

    OIU_RV_CNDKY SAP table for – Condition PPN field cross reference

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

    OIU_PR_HPPNH SAP table for – Volumetric Historical PPN Header

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

    OIUY3Y_TX_RRC SAP table for – Royalty 2.0 – TX GLO/TAMU – RRC Master PPN

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

    OIUVL_PPN_REJSEL SAP table for – PPN – Reject Selection

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

    OIUX5Y_OK_MASTER SAP table for – Tax 2.0 – Oklahoma Master Data PPN

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

    OIUX6Y_WY_MASTER SAP table for – Tax 2.0 – Wyoming Master Data PPN

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

    «
    »