OIURV_DOC_FRMMKT SAP table for – Valuation Transactions Level 3 – Marketing Detail

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

SAP OIURV_DOC_FRMMKT table

Table OIURV_DOC_FRMMKT technical data

TableOIURV_DOC_FRMMKT
Data storingValuation Transactions Level 3 – Marketing Detail
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-VAL
SAP PackageOIU_RVDC
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIURV_DOC_FRMMKT 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 OIURV_DOC_FRMMKT 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
  • MKT_TYPE : Marketing type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • AES_CD : Actual / Entitled / Settlement Code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • MKT_COST_CHG_LVL : Marketing Cost Change Level for VCR Reprocessing
    Its data type is CHAR (Character String) with field length 1
  • TRNSP_NO : Transporter number
    Its data type is CHAR (Character String) with field length 10
  • TRNSP_CT_NO : Transporter contract number
    Its data type is CHAR (Character String) with field length 10
  • INT_BUKRS : Internal Company Code
    Its data type is CHAR (Character String) with field length 4
  • INT_VNAME : Internal venture name
    Its data type is CHAR (Character String) with field length 6
  • INT_DOI_NO : Internal division of interest number
    Its data type is CHAR (Character String) with field length 5
  • EXT_BUKRS : External Company Code
    Its data type is CHAR (Character String) with field length 4
  • EXT_VNAME : External venture name
    Its data type is CHAR (Character String) with field length 6
  • EXT_DOI_NO : External division of interest number
    Its data type is CHAR (Character String) with field length 5
  • MKCT_EXT : Actual marketing cost external
    Its data type is CURR (Currency Field) with field length 15
  • MKCT_INT : Actual marketing cost internal
    Its data type is CURR (Currency Field) with field length 15
  • MCR_EXT : Actual marketing cost reimbursement external
    Its data type is CURR (Currency Field) with field length 15
  • GR_VAL_CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5