1. SAP Tutorial
  2. Oil & Gas

OIURV03_FRMHDR SAP table for – Valuation Transaction Level 3 – Formula

Here we would like to draw your attention to OIURV03_FRMHDR 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). OIURV03_FRMHDR is a SAP standard transp table used for storing Valuation Transaction Level 3 – Formula related data in SAP. It comes under the package OIU_RV03.

SAP OIURV03_FRMHDR table

Table OIURV03_FRMHDR technical data

TableOIURV03_FRMHDR
Data storingValuation Transaction Level 3 – Formula
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_RV03
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIURV03_FRMHDR 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 OIURV03_FRMHDR table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOC_NO : Val. document number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • LINE_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • POS_NO : Position Number for
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • PRICE_CHG_LVL : Price Change Level for Valuation Reprocessing
    Its data type is CHAR (Character String) with field length 1
  • SD_FRML : Formula number
    Its data type is CHAR (Character String) with field length 8
  • GR_VAL_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACTL_GR_VAL_AM : Actual Gross Value Amount
    Its data type is CURR (Currency Field) with field length 13
  • ENTL_GR_VAL_AM : Entitled Gross Value Amount
    Its data type is CURR (Currency Field) with field length 13
  • SETT_GR_VAL_AM : Settlement Gross Value Amount
    Its data type is CURR (Currency Field) with field length 13
  • STNDEDQ_CD : Varying/Equ Daily Qu
    Its data type is CHAR (Character String) with field length 1
  • BY_SLL_CT_NO : Buy/Sell Contract
    Its data type is CHAR (Character String) with field length 10
  • BY_SLL_VAL_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BY_SLL_VAL : Buy/Sell Value
    Its data type is CURR (Currency Field) with field length 13
  • LSE_VAL_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • LSE_VAL : Lease Value
    Its data type is CURR (Currency Field) with field length 15
  • BRD_CD : Brand Code
    Its data type is CHAR (Character String) with field length 4
  • ALT_CT_NO : Alternate Contract Number
    Its data type is CHAR (Character String) with field length 10
  • MORE_ALT_CT_FL : Alternate Contract Flag
    Its data type is CHAR (Character String) with field length 1
  • SECT_BURKS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SECT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • SECT_DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • POSNR : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • GAS_PLT_VNAME_NO : Gas plant venture name number
    Its data type is CHAR (Character String) with field length 6
  • GAS_PLANT_DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • SLID_SCAL_IND : Sliding scale indicator
    Its data type is CHAR (Character String) with field length 1
  • ADJ_CT_DECM : Contract Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • UOM : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • KS_ADP_VAL : Kansas average daily production value
    Its data type is QUAN (Quantity field) with field length 13
  • PRICE_PER_UNIT : Transporter unit value
    Its data type is CURR (Currency Field) with field length 15
  • PRICE_PUNIT_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • KALSM : Sales and Distribution: Pricing Procedure in Pricing
    Its data type is CHAR (Character String) with field length 6
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • PC_WL_NO : Well ID number
    Its data type is CHAR (Character String) with field length 15
  • PC_WC_NO : Well Completion Number
    Its data type is CHAR (Character String) with field length 5
  • PC_MP_NO : Measurement point number
    Its data type is CHAR (Character String) with field length 20
  • OICONTNR : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • KS_TAX_CLS : Tax Class
    Its data type is CHAR (Character String) with field length 4

    • OIURV03_FRMHDR related tables

    • OIURV03_TAXMKT : Valuation Tax Marketing Detail
    • OIURV03_VOLDTL : Valuation Transaction Level 2 -Volume
    • OIURV03_CONFIG : MP to Well Completion Split Out Config
    • OIURV03_DOCMPXRF : VL Doc to MP XRef
    • OIURV03_FRMTAX : Valuation Transactions Level 3 – Formula Tax Detail
    • OIURV03_FRMHDR : Valuation Transaction Level 3 – Formula
    • OIURV03_MPWC_XRF : MP to Well Completion Split Out XRef
    • OIURV03_TAXHDR : Valuation Tax Header
    • OIURV03_DTL_BK : Valuation Transactions Level 1 – Vltxns
    • OIURV03_TAXEMP : Valuation Tax Exempt Detail
    • OIURV03_DTL_ZE : Valuation Transactions Level 1 – Zero Volume
    • OIURV03_TAXDTL : Valuation Tax Master Detail

    Related References

    Related Tutorials

    OIURV_DOC_FRMHDR SAP table for – Valuation Transaction Level 3 – Formula

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

    OIURV03_FRMTAX SAP table for – Valuation Transactions Level 3 – Formula Tax Detail

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

    OIURV_DOC_FRMTAX SAP table for – Valuation Transactions Level 3 – Formula Tax Detail

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

    OIURV03_VOLDTL SAP table for – Valuation Transaction Level 2 -Volume

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

    OIURV03_DTL_ZE SAP table for – Valuation Transactions Level 1 – Zero Volume

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

    OIURV03_DTL_BK SAP table for – Valuation Transactions Level 1 – Vltxns

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

    OIURV_DOC_VOLDTL SAP table for – Valuation Transaction Level 2 -Volume

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

    «
    »