1. SAP Tutorial
  2. Oil & Gas

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

    • OIU_CW_SUM_PAY related tables

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

    OIU_CW_SUM_PAY related transaction codes under SAP package OIU_CW

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

    Related References

    Related Tutorials

    O3UH_TP_WO SAP tcode for – Taxes Payable Write Off

    O3UH_TP_WO tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Taxes Payable...

    O3UX4_WO_SETUP SAP tcode for – Taxes Payable Write Off Setup

    O3UX4_WO_SETUP tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Taxes Payable...

    O3U_AWO SAP tcode for – Taxes Payable Auto Write-Off

    O3U_AWO tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Taxes Payable...

    OIUCI_JE SAP table for – Incoming Check Journalized. Temporary hold

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

    OIUX4_BALANCE SAP table for – Taxes Payable Balance

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

    OIUX6_WY_FORM2 SAP table for – Tax 2.0 – Wyoming Conservation Summarized FORM 2 Data

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

    OIUX4_BALANCE_H SAP table for – Taxes Payable Balance History

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

    «
    »