OIUCM_CONTRACT SAP (PRA Contracts) Table details
Dictionary Type: Table
Description: PRA Contracts
Description: PRA Contracts
ABAP Code to SELECT data from OIUCM_CONTRACT
Related tables to OIUCM_CONTRACT
Access table OIUCM_CONTRACT
Related tables to OIUCM_CONTRACT
Access table OIUCM_CONTRACT
Table field list including key, data, relationships and ABAP select examples
OIUCM_CONTRACT is a standard SAP Table which is used to store PRA Contracts data and is available within R/3 SAP systems depending on the version and release level.
The OIUCM_CONTRACT table consists of various fields, each holding specific information or linking keys about PRA Contracts data available in SAP. These include VBELN (Contract Number), ERDAT (Date on Which Record Was Created), ERZET (Entry time), ERNAM (Name of Person who Created the Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIUCM_CONTRACT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Contract Number | OIU_CT_NO | CHAR | 10 | ALPHA | OIUCM_CONTRACT_NUMBER | OIU_CID | ||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ANGDT | Quotation/Inquiry is valid from | ANGDT_V | DATS | 8 | DATUM | ||||
BNDDT | Date until which bid/quotation is binding (valid-to date) | BNDDT | DATS | 8 | DATUM | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | TRVOG | VTV | |||
AUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
NETWR | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15(2) | WERTV8 | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
GUEBG | Valid-from date (outline agreements, product proposals) | GUEBG | DATS | 8 | DATUM | ||||
GUEEN | Valid-to date (outline agreements, product proposals) | GUEEN | DATS | 8 | DATUM | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
VDATU | Requested delivery date | EDATU_VBAK | DATS | 8 | DATUM | ||||
VPRGR | Proposed date type | PRGRS_VBAK | CHAR | 1 | PRGRS | ||||
KALSM | Sales and Distribution: Pricing Procedure in Pricing | KALSMASD | CHAR | 6 | T683 | KALSM | |||
FKARA | Proposed billing type for an order-related billing document | FKARA | CHAR | 4 | TVFK | FKART | |||
AWAHR | Sales probability | AWAHR_AK | NUMC | 3 | AWAHR | ||||
KTEXT | Search term for product proposal | KTEXT_V | CHAR | 40 | TEXT40 | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BNAME | Name of orderer | BNAME_V | CHAR | 35 | NAME | ||||
KUNNR | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
BUKRS_VF | Company code to be billed | BUKRS_VF | CHAR | 4 | T001 | BUKRS | BUK | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
OIU_CT_TYPE_CD | Contract Type | OIU_CT_TYPE_CD | CHAR | 2 | OIU_CM_CTTYP | OIU_CT_TYPE_CD | OIU_CTY | ||
OIU_CUST_VEND_CD | Customer/Vendor Indicator | OIU_CUST_VEND_CD | CHAR | 1 | OIU_CUST_VEND_CD | ||||
OIU_APPR_FL | Approval indicator | OIU_APPL_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_APPR_DT | Approval Date | OIU_APPR_DT | DATS | 8 | DATUM | ||||
OIU_EXEC_DT | Contract Execution Date | OIU_EXEC_DT | DATS | 8 | DATUM | ||||
OIU_STD_CT_FL | Standard Contract Flag | OIU_STD_CT_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_PREV_CT_NO | Old / Previous Contract Number | OIU_PREV_CT_NO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
OIU_GPLT_COMPANY | Gas Plant Company | OIU_GPLT_BUKRS | CHAR | 4 | T001 | BUKRS | |||
OIU_GPLT_VNAME | Gas Plant Venture | OIU_GPLT_VNAME | CHAR | 6 | OIU_DO_JV | ALPHA | JV_NAME | ||
OIU_GPLT_DOI_NO | Gasplant DOI No | OIU_GPLT_DOI_NO | CHAR | 5 | Assigned to domain | ALPHA | OIU_DOI_NO | ||
OIU_MK_REP_NO | Marketing Representative No | OIU_MK_REP_NO | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | OIU_MK_REP | |
OIU_MK_REP_ISQ | Marketing Representative Interest Sequence No | OIU_MK_REP_ISQ_NO | CHAR | 2 | ALPHA | OIU_MK_REP_ISQ_NO | OIU_MK_REP_ISQ | ||
OIU_DEST_SALE_CD | Plant Destination Of Product Sale Codes | OIU_DEST_SALE_CD | CHAR | 1 | OIU_DEST_SALE_CD | ||||
OIU_LIFE_LSE_FL | Life Lease Flag | OIU_LIFE_LSE_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_INV_NO | Contract Invoice Number | OIU_INV_NO | CHAR | 6 | OIU_INV_NO | ||||
OIU_INV_FL | Invoice Flag | OIU_INV_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_OBLIG_DT | Obligation Date | OIU_OBLIG_DT | DATS | 8 | DATUM | ||||
OIU_DESK_CD | Desk Codes | OIU_DESK_CD | CHAR | 3 | Assigned to domain | OIU_DESK_CD | |||
OIU_EIA_GINA_CD | Energy Information Agency Report Code | OIU_EIA_GINA_CD | CHAR | 2 | Assigned to domain | OIU_EIA_GINA_CD | |||
OIU_CT_STATUS_CD | Contract Status Code | OIU_CT_STATUS_CD | CHAR | 2 | OIU_CT_STATUS_CD | ||||
OIU_SPOT_TERM_CD | Spot/Term | OIU_SPOT_TERM_CD | CHAR | 1 | OIU_SPOT_TERM_CD | ||||
OIU_STNDEDQ_CD | Varying/Equ Daily Qu | OIU_STNDEDQ_CD | CHAR | 1 | OIU_STNDEDQ_CD | ||||
OIU_IOTR_FL | Price includes Tax Reimbursement. | OIU_IOTR_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_INTRA_INTER | Boundary (Intra/Inter) Codes | OIU_INTRA_INTER_CD | CHAR | 1 | OIU_INTRA_INTER_CD | ||||
OIU_EXRES_SPLT | Excess Residue Return (Before/After) Lease Plant Split Code | OIU_EXRES_SPLT_CD | CHAR | 1 | OIU_EXRES_SPLT_CD | ||||
OIU_EVGN_FL | Evergreen Flag | OIU_EVGN_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_EVGNPD_BAS | Evergreen Period Basis | OIU_EVGNPD_BAS_CD | CHAR | 2 | OIU_EVGNPD_BAS_CD | ||||
OIU_EVGN_PERD_QY | Evergreen Period Duration | OIU_EVGN_PERD_QY | NUMC | 3 | NUMC03 | ||||
OIU_PREIM_TM_CD | Primary Term Basis | OIU_PREIM_TM_CD | CHAR | 2 | OIU_CT_TM_BASIS | ||||
OIU_PRIM_TM_QY | Primary Term Length | OIU_PRIM_TM_QY | NUMC | 3 | NUMC03 | ||||
OIU_SEC_TM_CD | Secondary Term Basis | OIU_SEC_TM_CD | CHAR | 2 | OIU_CT_TM_BASIS | ||||
OIU_SEC_TM_QY | Secondary Term Length | OIU_SEC_TM_QY | NUMC | 3 | NUMC03 | ||||
OIU_EXP_NOTIF_DT | Expiration Notification Date | OIU_EXP_NOTIF_DT | DATS | 8 | DATUM | ||||
OIU_INTIT_RDT_DT | Initial Redetermination Date | OIU_INTIT_RDT_DT | DATS | 8 | DATUM | ||||
OIU_NEXT_RDT_DT | Next redetermination date | OIU_NEXT_RDT_DT | DATS | 8 | DATUM | ||||
OIU_RTC_DT | Right to cancel date | OIU_RTC_DT | DATS | 8 | DATUM | ||||
OIU_RDT_N_PERD | Re-determination Notification Period (in Days) | OIU_RDT_N_PERD_QY | QUAN | 13(3) | MENGE | ||||
OIU_RDT_REFQ_CD | Redetermination Frequency Code | OIU_RDT_REFQ_CD | CHAR | 2 | OIU_RDT_REFQ_CD | ||||
OIU_RTF_CD | Ratification Date | OIU_RTF_DT | DATS | 8 | DATUM | ||||
OIU_IMB_PRVSN_FL | Imbalance Provision Flag | OIU_IMB_PRVSN_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_FFEE_RMB_FL | Filing Fee Reimbursement Flag | OIU_FFEE_RMB_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_FIRM_INTRPT | Firm/Interruptable Code | OIU_FIRM_INTRPT_CD | CHAR | 1 | OIU_FIRM_INTRPT_CD | ||||
OIU_BAL_BAS_CD | Balancing Basis Code | OIU_BAL_BAS_CD | CHAR | 1 | OIU_VBAS_CD | ||||
OIU_PNTY_BAS_CD | Penalty Basis Code | OIU_PNTY_BAS_CD | CHAR | 1 | OIU_VBAS_CD | ||||
OIU_TRANSP_BA | Transportation Basis Code | OIU_TRANSP_BAS_CD | CHAR | 1 | OIU_VBAS_CD | ||||
OIU_DLY_MAX_T_QY | Daily Maximum Transport Quantity | OIU_DLY_MAX_T_QY | QUAN | 13(3) | MENGE | ||||
OIU_PRCS_FL | Processing Flag | OIU_PRCS_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_SPR_FL | Separation Flag | OIU_SPR_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_DEHYD_FL | Dehydration Flag | OIU_DEHYD_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_COMPR_FL | Compression Flag | OIU_COMPR_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_PYMT_METH_CD | Payment Method Code | OIU_PYMT_METH_CD | CHAR | 1 | OIU_PYMT_METH_CD | ||||
OIU_CON_MATNR | Contaminant material | OIU_CON_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
OIU_CON_MAX_QY | Contaminant Percent | OIU_CON_MAX_QY | NUMC | 3 | OIU_CON_MAX_QY | ||||
OIU_AFFIL_FL | Affiliate Flag | OIU_AFFIL_FL | CHAR | 1 | OIU_X_FLAG | ||||
OIU_MMS_TYPE_CD | Production: MMS-2014 - Sales Type Code | OIUREP_MMS_2014_SALES_TYPE_CD | CHAR | 4 | OIUREP_SALESTY | OIUREP_MMS_2014_SALES_TYPE_CD | |||
OIU_MMS_ETPAY_FL | MMS-2014: Contracts with Estimated Payment | OIUREP_MMS_2014_CT_EST_PAY_FL | CHAR | 1 | YESNO | ||||
OIUH_CT_NO | Contract Number | OIUH_CT_NO | CHAR | 6 | CHAR6 | ||||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table OIUCM_CONTRACT using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUCM_CONTRACT to SELECT all data from the tableDATA: WA_OIUCM_CONTRACT TYPE OIUCM_CONTRACT.
SELECT SINGLE *
FROM OIUCM_CONTRACT
INTO CORRESPONDING FIELDS OF WA_OIUCM_CONTRACT
WHERE...
How to access SAP table OIUCM_CONTRACT
Within an ECC or HANA version of SAP you can also view further information about OIUCM_CONTRACT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects