OIUCI_PDX SAP table for – Purchaser DOI Cross Reference

Here we would like to draw your attention to OIUCI_PDX 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_PDX 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_PDX table

Table OIUCI_PDX technical data

TableOIUCI_PDX
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_PDX 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_PDX table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • PU_NO : Remitter ID
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • PU_SEQ_NO : Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • PU_PR_NO : Remitter Property
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • PU_PD_CD : Remitter Product
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • LYT_FL_NO : Layout Field
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • LYT_FL_CD : Layout Field Value
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • EFF_FROM_DT : Effective From Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT_CD : Effective to date code
    Its data type is CHAR (Character String) with field length 1
  • SYS_NO : Purchaser to Property/DOI Xref System Number
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • RCVBL_DECM_PC : Receivable Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PD_CD : Product
    Its data type is CHAR (Character String) with field length 3
  • AFFIL_ACCT_NO : Affiliated Account Number
    Its data type is CHAR (Character String) with field length 3
  • OVRD_PRCS_NO : Override Process No
    Its data type is CHAR (Character String) with field length 4
  • RCVBL_MP_NO : Measurement Point ID
    Its data type is CHAR (Character String) with field length 6
  • PR_NO : Property / DOI
    Its data type is CHAR (Character String) with field length 8
  • DOI_NO : Division of Interest (DOI) Number
    Its data type is CHAR (Character String) with field length 5
  • TAX_CALC_FL : Calculate Severance Tax
    Its data type is CHAR (Character String) with field length 1
  • BLN_IND_FL : Blanchard Cross Reference
    Its data type is CHAR (Character String) with field length 1
  • CDEX_OVRD_NO : CDEX Override Process No
    Its data type is CHAR (Character String) with field length 4
  • CT_NO : Resell Contract
    Its data type is CHAR (Character String) with field length 6
  • CMT_FL : Extended comment flag
    Its data type is CHAR (Character String) with field length 1
  • VER_NO : Version No
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SPC_DIST_FL : Special Distribution Flag
    Its data type is CHAR (Character String) with field length 1
  • USED_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • UNIT_OF_MEAS_CD : Unit of Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • COST_CENTER : Template cost center
    Its data type is CHAR (Character String) with field length 10
  • OR_LVL_1_NO : Organization level 1 number (Company Code)
    Its data type is CHAR (Character String) with field length 3
  • .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