OIUCI_SPC_DIST SAP table for – Purchaser DOI Cross Reference

Here we would like to draw your attention to OIUCI_SPC_DIST 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). OIUCI_SPC_DIST is a SAP standard transp table used for storing Purchaser DOI Cross Reference related data in SAP. It comes under the package OIU_CI.

SAP OIUCI_SPC_DIST table

Table OIUCI_SPC_DIST technical data

TableOIUCI_SPC_DIST
Data storingPurchaser DOI Cross Reference
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-CI
SAP PackageOIU_CI
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PDX_SYS_NO : Purchaser to Property/DOI Xref System Number
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • PRDR_NO : Producer ID
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • PRDR_SEQ_NO : Producer Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • PRDR_INT_TYPE_CD : Owner Interest Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • PRDR_INT_SEQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • INT_TYPE_CD : Owner Interest Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_NO : Owner Number
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • OWN_SEQ_NO : Owner Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_INT_TYPE_CD : Owner Interest Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • PAY_PRODUCER : Pay Producer
    Its data type is CHAR (Character String) with field length 1