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