1. SAP Tutorial
  2. Oil & Gas

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

    • OIUCI_PDX related tables

    • OIUCI_NOTES : Notes for Suspended Line item of Incoming Check
    • OIUCI_DETAIL : Incoming Check’s Detail Line information
    • OIUCI_RULESLOCK : Incoming Check Usage of Process Rules
    • OIUCI_JE : Incoming Check Journalized. Temporary hold
    • OIUCI_PTLOCK : Incoming Check Usage of Property/Product translation data
    • OIUCI_SPC_DIST : Purchaser DOI Cross Reference
    • OIUCI_FIELDATTR : Check fields attributes
    • OIUCI_MESG : Contains warning, error message pertaining to a Line item(s)
    • OIUCI_CDEX_REMX : CDEX Remitter Xref
    • OIUCI_DOCS : Incoming Checks – Generated/Booked Documents
    • OIUCI_DOC_CIREJ : Contains VL/RD rejects to be reported to Check Input
    • OIUCI_HEADER : Incoming Check Header information
    • OIUCI_PDXLOCK : Incoming Check Usage of Property/DOI xref master data
    • OIUCI_CDEX_PRDX : CDEX Product Xref
    • OIUCI_CDEXH : CDEX Header
    • OIUCI_CDEXD : CDEX Detail
    • OIUCI_PDX : Purchaser DOI Cross Reference

    OIUCI_PDX related transaction codes under SAP package OIU_CI

    • O3UCI_MASS : Processing Checks in Mass
    • O3UCI_REMX : CDEX Remitter Cross Reference
    • O3UCI_CDEX : CDEX Workplace
    • O3UCI_SUSP : Suspended Line Items messages
    • O3UCI_PRDX : CDEX Comapny Product Cross Reference
    • O3UCI_ARVAR : Receivable and Price Variance
    • O3UCI_PPD : PRA Payment Posting Desktop
    • O3UCI_PDX : Purchaser to Property/DOI Xref

    Related References

    Related Tutorials

    OIUCI_SPC_DIST SAP table for – Purchaser DOI Cross Reference

    OIUCI_SPC_DIST table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    O3UCI_PDX SAP tcode for – Purchaser to Property/DOI Xref

    O3UCI_PDX tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Purchaser to...

    OIU_RV_PDXSS SAP table for – Settlement Statements/Purchaser – DOI Cross Reference

    OIU_RV_PDXSS table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    O3UCI_REMX SAP tcode for – CDEX Remitter Cross Reference

    O3UCI_REMX tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for CDEX Remitter...

    O3UCI_PRDX SAP tcode for – CDEX Comapny Product Cross Reference

    O3UCI_PRDX tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for CDEX Comapny...

    OIUH_RV_PRX SAP table for – Purchaser Remitter Cross Reference

    OIUH_RV_PRX table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUH_RV_PLX SAP table for – Purchaser Layout Cross Reference

    OIUH_RV_PLX table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »