OIU_CW_SUM_PAY SAP table for – Summarized Payable Table for Check Write

Here we would like to draw your attention to OIU_CW_SUM_PAY 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). OIU_CW_SUM_PAY is a SAP standard transp table used for storing Summarized Payable Table for Check Write related data in SAP. It comes under the package OIU_CW.

SAP OIU_CW_SUM_PAY table

Table OIU_CW_SUM_PAY technical data

TableOIU_CW_SUM_PAY
Data storingSummarized Payable Table for Check Write
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REV-CW
SAP PackageOIU_CW
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • ORG_LVL_1 : Organization level 1 number (Company Code)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • 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
  • DOI_PR_NO : Property
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • DOI_SEQ_NO : Division of Interest (DOI) Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • PD_CD : Product Code
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • SA_DT : Date of Char type for compatabiliy with dats stored as Char
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • OWN_INT_TYPE : Owner Interest Type Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • OWN_INT_SEQ_NO : Owner Interest Sequence Number
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • ACCT_NO : Account ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OWN_DECM_QY : Owner Disbursement (Balance) Decimal
    Its a key field. Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • LGND_CD : Legend Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SYS_NO : OIUH_DEC18
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 18
  • ACCT_PERD : Accounting Period(YYYYMM01)
    Its data type is CHAR (Character String) with field length 8
  • VL_TYPE_CD : Volume Type
    Its data type is CHAR (Character String) with field length 2
  • PU_NO : Purchaser Number
    Its data type is CHAR (Character String) with field length 6
  • PU_SEQ_NO : Purchaser Sequence Number
    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
  • CT_TYPE_CD : Contract Type code
    Its data type is CHAR (Character String) with field length 2
  • WL_NO : Well ID Number
    Its data type is CHAR (Character String) with field length 6
  • WC_NO : Well Completion ID
    Its data type is CHAR (Character String) with field length 2
  • SA_MP_NO : Sales Measurement Point Number
    Its data type is CHAR (Character String) with field length 6
  • NWK_NO : Delivery Network number
    Its data type is CHAR (Character String) with field length 4
  • SUBNWK_NO : Subnetwork Number
    Its data type is CHAR (Character String) with field length 4
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • STATE_CD : State Code
    Its data type is CHAR (Character String) with field length 2
  • UNIT_PR_NO : Unit Property Number
    Its data type is CHAR (Character String) with field length 8
  • AES_FL : OIUH_CHAR1
    Its data type is CHAR (Character String) with field length 1
  • PRDR_NO : Producer ID
    Its data type is CHAR (Character String) with field length 6
  • PRDR_SEQ_NO : Producer Sequence Number
    Its data type is CHAR (Character String) with field length 2
  • 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
  • UNIT_OF_MEAS_CD : Unit of Measure Code
    Its data type is CHAR (Character String) with field length 3
  • SUS_RSN_CD : Suspense Reason Code
    Its data type is CHAR (Character String) with field length 2
  • TRANS_AM : JE Transaction Amount
    Its data type is CURR (Currency Field) with field length 11
  • TRANS_QY : JE Transaction Quantity
    Its data type is DEC (Packed number (number with fixed number of decimal places)) 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
  • TAX_RMB_AM : Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_GR_RMB_AM : Gross Tax Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • DED_RMB_AM : Deduction/Reimbursement Amount
    Its data type is CURR (Currency Field) with field length 11
  • DED_GR_RMB_AM : Gross Deduction/Reimbursement 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
  • GR_TRANSP_AM : Gross Transportation Amount
    Its data type is CURR (Currency Field) with field length 11
  • GR_OTH_MK_AM : Gross Other Marketing Amount
    Its data type is CURR (Currency Field) with field length 11
  • PLT_VL_GRED_AM : Gross Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • PLT_VL_ORED_AM : Owner Plant Volume Reduction amount
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • MMBTU_OVL_AM : Owner MMBTU
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11
  • TAX_1_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_2_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_3_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_4_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_5_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_6_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_7_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_8_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_9_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • TAX_10_AM : Tax amount
    Its data type is CURR (Currency Field) with field length 11
  • GR_TAX_1_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_2_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_3_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_4_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_5_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_6_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_7_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_8_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_9_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • GR_TAX_10_AM : Gross Tax Amount
    Its data type is CURR (Currency Field) with field length 13
  • OTH_DED_1_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_2_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_3_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_4_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_5_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_6_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_7_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_8_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_9_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_10_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_11_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_12_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_13_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_14_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_15_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_16_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_17_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_18_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • USER_ID : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • 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
  • BTCH_TYPE_CD : Batch Type
    Its data type is CHAR (Character String) with field length 2