1. SAP Tutorial
  2. Oil & Gas

OIUCW_EXTD SAP table for – Extended Details from Payment Run

Here we would like to draw your attention to OIUCW_EXTD 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). OIUCW_EXTD is a SAP standard transp table used for storing Extended Details from Payment Run related data in SAP. It comes under the package OIU_CW.

SAP OIUCW_EXTD table

Table OIUCW_EXTD technical data

TableOIUCW_EXTD
Data storingExtended Details from Payment Run
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-CW
SAP PackageOIU_CW
Delivery ClassL – Table for storing temporary data
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RUN_ID : Run ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RUN_DATE : Run Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OWN_NO : Owner (Business Associate)
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • OWN_SEQ_NO : Business Associate Sequence Nr.
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • LINE_NO : Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • OWN_INT_TYPE_CD : Owner Interest Type Code
    Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : Owner Interest Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • OWN_BAL_DECM_QY : Owner Disbursement (Balance) Decimal
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • OWN_INT_DECM_QY : Owner Interest Decimal Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • DOI_PR_NO : Property
    Its data type is CHAR (Character String) with field length 8
  • DOI_SEQ_NO : Division of Interest (DOI) Number
    Its data type is CHAR (Character String) with field length 5
  • BTCH_TYPE_CD : Batch Type
    Its data type is CHAR (Character String) with field length 2
  • BTCH_NO : Batch ID
    Its data type is CHAR (Character String) with field length 4
  • ACCT_PERD : Accounting Period(YYYYMM01)
    Its data type is CHAR (Character String) with field length 8
  • SA_DT : Date of Char type for compatabiliy with dats stored as Char
    Its data type is CHAR (Character String) with field length 8
  • LGND_CD : Legend Code
    Its data type is CHAR (Character String) with field length 2
  • PD_CD : Product Code
    Its data type is CHAR (Character String) with field length 3
  • VL_TYPE_CD : Volume Type
    Its data type is CHAR (Character String) with field length 2
  • CT_NO : Contract ID
    Its data type is CHAR (Character String) with field length 6
  • AES_FL : Actual / Entitled / Settlement Code
    Its data type is CHAR (Character String) with field length 1
  • TRANS_AM : JE Transaction Amount
    Its data type is CURR (Currency Field) with field length 11
  • GR_AM : Gross Amount (Value)
    Its data type is CURR (Currency Field) with field length 11
  • GR_QY : Gross Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TXN_VAL_AM : Transaction Owner Amount
    Its data type is CURR (Currency Field) with field length 11
  • NET_TRANSP_AM : Net Transportation Amount
    Its data type is CURR (Currency Field) with field length 11
  • NET_OTH_MK_AM : Net Other Marketing Amount
    Its data type is CURR (Currency Field) with field length 11

    • OIUCW_EXTD related tables

    • OIUCW_BANK : Bank Details
    • OIUCW_RUN_PARMS : User Input Parameters for the Payment Run
    • OIUCW_NRIT_WH : State with NRIT withholding requirement
    • OIUCW_EXTD : Extended Details from Payment Run
    • OIUCW_BA_WH_EXMP : Business Associates exempt from state NRIT withholding
    • OIUCW_REJECTS : Payments Not Made in the Run
    • OIU_CW_SUM_PAY : Summarized Payable Table for Check Write
    • OIUCW_PAYMENT : Payment Details from Payment Run
    • OIUCW_LOTDESC : Check Lot Control – Description
    • OIUCW_OWNER_SEQ : Owner/Sequence List for Payment Runs
    • OIUCW_EN_WH_EXMP : Entity level Exemption for State NRIT withholding
    • OIUCW_LOTCONTROL : Check Lot Control Master
    • OIUCW_CHECKLOT : Check Lot Details for Payments
    • OIUCW_PROP_DOI : Property/DOI List for Payment Run

    OIUCW_EXTD related transaction codes under SAP package OIU_CW

    • O3UCW_TAX : Owner Taxes Withheld Report
    • O3UCM_TAB_MAINT_018 : Parameters for TX Migration
    • O3UCW_BANK : Bank Details for Payment Processing
    • S_SO7_65001318 : IMG activity: OIUCW_CHECKLOT
    • S_SO7_65001319 : IMG activity: OIUCW_CHECKNUMBERS
    • O3UCW_BA_EXEMPTION : BA exempt from state NRIT Withholdin
    • O3UCW_EXCEPTION : Exception list from Payment run
    • O3UCW_PAYMENT_RUN : PRA Payment Processing
    • O5UCW_CHECK_NUMBERS : Configure Check Numbers in Check Lot

    Related References

    Related Tutorials

    OIUCW_PAYMENT SAP table for – Payment Details from Payment Run

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

    OIUCW_PROP_DOI SAP table for – Property/DOI List for Payment Run

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

    OIUCW_RUN_PARMS SAP table for – User Input Parameters for the Payment Run

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

    O3UCW_EXCEPTION SAP tcode for – Exception list from Payment run

    O3UCW_EXCEPTION tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Exception list...

    O3UCW_BANK SAP tcode for – Bank Details for Payment Processing

    O3UCW_BANK tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Bank Details...

    OIUCW_OWNER_SEQ SAP table for – Owner/Sequence List for Payment Runs

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

    OIUCW_REJECTS SAP table for – Payments Not Made in the Run

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

    «
    »