1. SAP Tutorial
  2. Oil & Gas

OIUCW_PAYMENT SAP table for – Payment Details from Payment Run

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

SAP OIUCW_PAYMENT table

Table OIUCW_PAYMENT technical data

TableOIUCW_PAYMENT
Data storingPayment 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_PAYMENT 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_PAYMENT 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
  • ORG_LVL_1 : Organization level 1 number (Company Code)
    Its data type is CHAR (Character String) with field length 3
  • TRACE_CO_NO : Organization level 1 number (Company Code)
    Its data type is CHAR (Character String) with field length 3
  • BTCH_TYPE_CD : Batch Type
    Its data type is CHAR (Character String) with field length 2
  • ACCT_NO : Account ID
    Its data type is CHAR (Character String) with field length 10
  • 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
  • VL_CLASS_CD : Volume Class Code
    Its data type is CHAR (Character String) with field length 1
  • VL_SRCE_CD : Volume source code
    Its data type is CHAR (Character String) with field length 1
  • VL_FRQ_CD : Volume Frequency code
    Its data type is CHAR (Character String) with field length 1
  • MMBTU_DET_CD : MMBTU Determination Code
    Its data type is CHAR (Character String) with field length 1
  • SA_DT : Date of Char type for compatabiliy with dats stored as Char
    Its data type is CHAR (Character String) with field length 8
  • STATE_CD : State Code
    Its data type is CHAR (Character String) with field length 2
  • PAY_CD : Pay Code
    Its data type is CHAR (Character String) with field length 2
  • LGND_CD : Legend Code
    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
  • 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_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
  • 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
  • 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
  • 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
  • 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
  • SECT_PR_NO : Section Property Number
    Its data type is CHAR (Character String) with field length 8
  • SECT_SEQ_NO : Section Sequence Number
    Its data type is CHAR (Character String) with field length 5
  • UNIT_PR_NO : Unit Property Number
    Its data type is CHAR (Character String) with field length 8
  • 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
  • SA_MP_NO : Sales Measurement Point Number
    Its data type is CHAR (Character String) with field length 6
  • 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
  • PHASE_NO : Phase number
    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
  • 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
  • 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
  • TAX_CD : Tax Code
    Its data type is CHAR (Character String) with field length 2
  • 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
  • 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
  • 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
  • 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
  • OTH_DED_01_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_02_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_03_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_04_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_05_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_06_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_07_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_08_AM : Other Deductions Amount
    Its data type is CURR (Currency Field) with field length 11
  • OTH_DED_09_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
  • TXN_VAL_AM : Transaction Owner 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
  • MMBTU_GRVL_AM : MMBTU Gross Volume
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

    • OIUCW_PAYMENT related tables

    • OIUCW_PROP_DOI : Property/DOI List for 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_NRIT_WH : State with NRIT withholding requirement
    • OIUCW_PAYMENT : Payment Details from Payment Run
    • OIUCW_BA_WH_EXMP : Business Associates exempt from state NRIT withholding
    • OIUCW_BANK : Bank Details
    • OIUCW_LOTDESC : Check Lot Control – Description
    • OIUCW_RUN_PARMS : User Input Parameters for the Payment Run
    • OIUCW_LOTCONTROL : Check Lot Control Master
    • OIUCW_OWNER_SEQ : Owner/Sequence List for Payment Runs
    • OIUCW_CHECKLOT : Check Lot Details for Payments
    • OIUCW_EN_WH_EXMP : Entity level Exemption for State NRIT withholding

    OIUCW_PAYMENT related transaction codes under SAP package OIU_CW

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

    Related References

    Related Tutorials

    OIUCW_EXTD SAP table for – Extended Details from Payment Run

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

    OIU_CW_SUM_PAY SAP table for – Summarized Payable Table for Check Write

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

    OIURV_DOC_RUNTKT SAP table for – Valuation Transaction – Run Ticket

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

    OIUVL_OILTAX_CUR SAP table for – Oil Run Statement Tax Marketing

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

    OIUVL_OILTAX_HST SAP table for – Oil Run Statement Tax Marketing

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

    «
    »