OIURV_SSTD SAP table for – Settlement statement detail

Here we would like to draw your attention to OIURV_SSTD 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_SSTD is a SAP standard transp table used for storing Settlement statement detail related data in SAP. It comes under the package OIU_RVDC.

SAP OIURV_SSTD table

Table OIURV_SSTD technical data

TableOIURV_SSTD
Data storingSettlement statement 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_SSTD 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_SSTD 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_ITEM_NO : Document Line Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • LINE_ITEM_STS_CD : Line Item Processing Status
    Its data type is CHAR (Character String) with field length 1
  • REJ_RSN_CD : Rejection Reason Code
    Its data type is CHAR (Character String) with field length 3
  • PU_VNAME : Purchaser’s Lease Number
    Its data type is CHAR (Character String) with field length 18
  • PU_MATNR : Purchaser’s Xref Product / Material
    Its data type is CHAR (Character String) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • SALE_DT : Sales Date / Month
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CT_NO : Contract Number
    Its data type is CHAR (Character String) with field length 10
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    Its data type is CHAR (Character String) with field length 2
  • FREQ_CD : Frequency
    Its data type is CHAR (Character String) with field length 1
  • COST_CENTER : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its data type is CHAR (Character String) with field length 5
  • VL_TYPE_CD : Volume type code
    Its data type is CHAR (Character String) with field length 2
  • TOT_GR_VL_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACTL_GR_VL : Actual Gross Volume Amount
    Its data type is QUAN (Quantity field) with field length 13
  • ENERGY_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACTL_ENERGY : Actual Energy
    Its data type is QUAN (Quantity field) with field length 13
  • PVR_AM_U : PVR Volume Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • HEAT_VAL_FCT_U : Measurement unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ACT_HEAT_VAL_FCT : Actual Heating Factor
    Its data type is QUAN (Quantity field) with field length 13
  • CURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ACTL_GR_VAL : Actual Gross Value Amount
    Its data type is CURR (Currency Field) with field length 13
  • HEAT_VAL_CLS : Heat value class
    Its data type is CHAR (Character String) with field length 4
  • CALC_TAXES_FL : Calculate Tax Flag
    Its data type is CHAR (Character String) with field length 1
  • PVR : Plant volume reduction amount
    Its data type is QUAN (Quantity field) with field length 13
  • .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