1. SAP Tutorial
  2. Oil & Gas

OIUCI_CDEXD SAP table for – CDEX Detail

Here we would like to draw your attention to OIUCI_CDEXD 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_CDEXD is a SAP standard transp table used for storing CDEX Detail related data in SAP. It comes under the package OIU_CI.

SAP OIUCI_CDEXD table

Table OIUCI_CDEXD technical data

TableOIUCI_CDEXD
Data storingCDEX Detail
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_CDEXD 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_CDEXD table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • CO_NO : CDEX Company
    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 12
  • CK_NO : CDEX Check Number
    Its a key field. Its data type is CHAR (Character String) with field length 14
  • LINE_NO : Check Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • LEASE_CODE : Unit/Property Lease Code
    Its data type is CHAR (Character String) with field length 14
  • PROD_FROM_DT : Production From Date
    Its data type is CHAR (Character String) with field length 4
  • PROD_TO_DT : Production To Date
    Its data type is CHAR (Character String) with field length 4
  • PD_CD : CDEX Product Code
    Its data type is CHAR (Character String) with field length 2
  • TRAN_CODE_1 : Transaction Code 1
    Its data type is CHAR (Character String) with field length 2
  • TRAN_CODE_2 : Transaction Code 2
    Its data type is CHAR (Character String) with field length 2
  • LSE_GR_VOL : Lease Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • LSE_GR_SEV : Lease Gross Sev Tax
    Its data type is CURR (Currency Field) with field length 8
  • LSE_NET_VAL : Lease Net Value
    Its data type is CURR (Currency Field) with field length 11
  • LSE_GR_CRWPT : Lease Goss Value of C/R/WPT
    Its data type is CURR (Currency Field) with field length 11
  • OWN_NET_VAL : Owner Net Value
    Its data type is CURR (Currency Field) with field length 11
  • OWN_CRWPT : Owner Share of C/R/WPT
    Its data type is CURR (Currency Field) with field length 11
  • TRANS_DATE : Transmission Date
    Its data type is CHAR (Character String) with field length 3
  • TYPE_INTEREST : Type of Interest
    Its data type is CHAR (Character String) with field length 1
  • DEC_INT_FL : Decimal Flag
    Its data type is CHAR (Character String) with field length 1
  • DEC_INT : Decimal Interest
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BTU_FACT : BTU Factor
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • STATUS : Check Line Status
    Its data type is CHAR (Character String) with field length 1
  • REJ_RSN_CD : Reject reason
    Its data type is CHAR (Character String) with field length 3

    • OIUCI_CDEXD related tables

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

    OIUCI_CDEXD related transaction codes under SAP package OIU_CI

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

    Related References

    Related Tutorials

    OIUCI_CDEX_PRDX SAP table for – CDEX Product Xref

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

    OIUCI_CDEX_REMX SAP table for – CDEX Remitter Xref

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

    OIUCI_CDEXH SAP table for – CDEX Header

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

    O3UCI_CDEX SAP tcode for – CDEX Workplace

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

    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...

    OIUCI_DETAIL SAP table for – Incoming Check’s Detail Line information

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

    «
    »