OIUH_PR_SAND SAP table for – Oil and Gas appl table

Here we would like to draw your attention to OIUH_PR_SAND 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_PR_SAND is a SAP standard transp table used for storing Oil and Gas appl table related data in SAP. It comes under the package OIU_H.

SAP OIUH_PR_SAND table

Table OIUH_PR_SAND technical data

TableOIUH_PR_SAND
Data storingOil and Gas appl table
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV
SAP PackageOIU_H
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUH_PR_SAND 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_PR_SAND table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SAND_SYS_NO : OIUH_DEC18
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • SAND_SAND_NO : OIUH_CHAR4
    Its data type is CHAR (Character String) with field length 4
  • SAND_FL_NO : OIUH_CHAR3
    Its data type is CHAR (Character String) with field length 3
  • SAND_SAND_NM9 : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • SAND_SAND_NM : OIUH_CHAR35
    Its data type is CHAR (Character String) with field length 35
  • SAND_EXT_COM_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • SAND_VER_NO : OIUH_DEC5
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SAND_USER_ID : OIUH_CHAR8
    Its data type is CHAR (Character String) with field length 8
  • SAND_TIMESTAMP : OIUH_CHAR14
    Its data type is CHAR (Character String) with field length 14