OIUCM_CONTRACT SAP (PRA Contracts) Table details

Dictionary Type: Table
Description: PRA Contracts




ABAP Code to SELECT data from 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
MANDTClient MANDTCLNT3T000MANDT
VBELNContract Number OIU_CT_NOCHAR10ALPHAOIUCM_CONTRACT_NUMBEROIU_CID
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ANGDTQuotation/Inquiry is valid from ANGDT_VDATS8DATUM
BNDDTDate until which bid/quotation is binding (valid-to date) BNDDTDATS8DATUM
AUDATDocument Date (Date Received/Sent) AUDATDATS8DATUM
VBTYPSD document category VBTYPCHAR1VBTYP
TRVOGTransaction group TRVOGCHAR1TRVOGVTV
AUARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
NETWRNet Value of the Sales Order in Document Currency NETWR_AKCURR15(2) WERTV8
WAERKSD Document Currency WAERKCUKY5TCURCWAERSFWS
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
GUEBGValid-from date (outline agreements, product proposals) GUEBGDATS8DATUM
GUEENValid-to date (outline agreements, product proposals) GUEENDATS8DATUM
KNUMVNumber of the document condition KNUMVCHAR10KNUMV
VDATURequested delivery date EDATU_VBAKDATS8DATUM
VPRGRProposed date type PRGRS_VBAKCHAR1PRGRS
KALSMSales and Distribution: Pricing Procedure in Pricing KALSMASDCHAR6T683KALSM
FKARAProposed billing type for an order-related billing document FKARACHAR4TVFKFKART
AWAHRSales probability AWAHR_AKNUMC3AWAHR
KTEXTSearch term for product proposal KTEXT_VCHAR40TEXT40
BSTNKCustomer purchase order number BSTNKCHAR20BSTNK
BSTDKCustomer purchase order date BSTDKDATS8DATUM
BNAMEName of orderer BNAME_VCHAR35NAME
KUNNRSold-to party KUNAGCHAR10KNA1ALPHAKUNNRVAG
STWAEStatistics currency STWAECUKY5TCURCWAERS
AEDATChanged On AEDATDATS8DATUM
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
BUKRS_VFCompany code to be billed BUKRS_VFCHAR4T001BUKRSBUK
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
OIU_CT_TYPE_CDContract Type OIU_CT_TYPE_CDCHAR2OIU_CM_CTTYPOIU_CT_TYPE_CDOIU_CTY
OIU_CUST_VEND_CDCustomer/Vendor Indicator OIU_CUST_VEND_CDCHAR1OIU_CUST_VEND_CD
OIU_APPR_FLApproval indicator OIU_APPL_FLCHAR1OIU_X_FLAG
OIU_APPR_DTApproval Date OIU_APPR_DTDATS8DATUM
OIU_EXEC_DTContract Execution Date OIU_EXEC_DTDATS8DATUM
OIU_STD_CT_FLStandard Contract Flag OIU_STD_CT_FLCHAR1OIU_X_FLAG
OIU_PREV_CT_NOOld / Previous Contract Number OIU_PREV_CT_NOCHAR10Assigned to domainALPHAVBELN
OIU_GPLT_COMPANYGas Plant Company OIU_GPLT_BUKRSCHAR4T001BUKRS
OIU_GPLT_VNAMEGas Plant Venture OIU_GPLT_VNAMECHAR6OIU_DO_JVALPHAJV_NAME
OIU_GPLT_DOI_NOGasplant DOI No OIU_GPLT_DOI_NOCHAR5Assigned to domainALPHAOIU_DOI_NO
OIU_MK_REP_NOMarketing Representative No OIU_MK_REP_NOCHAR10Assigned to domainALPHAKUNNROIU_MK_REP
OIU_MK_REP_ISQMarketing Representative Interest Sequence No OIU_MK_REP_ISQ_NOCHAR2ALPHAOIU_MK_REP_ISQ_NOOIU_MK_REP_ISQ
OIU_DEST_SALE_CDPlant Destination Of Product Sale Codes OIU_DEST_SALE_CDCHAR1OIU_DEST_SALE_CD
OIU_LIFE_LSE_FLLife Lease Flag OIU_LIFE_LSE_FLCHAR1OIU_X_FLAG
OIU_INV_NOContract Invoice Number OIU_INV_NOCHAR6OIU_INV_NO
OIU_INV_FLInvoice Flag OIU_INV_FLCHAR1OIU_X_FLAG
OIU_OBLIG_DTObligation Date OIU_OBLIG_DTDATS8DATUM
OIU_DESK_CDDesk Codes OIU_DESK_CDCHAR3Assigned to domainOIU_DESK_CD
OIU_EIA_GINA_CDEnergy Information Agency Report Code OIU_EIA_GINA_CDCHAR2Assigned to domainOIU_EIA_GINA_CD
OIU_CT_STATUS_CDContract Status Code OIU_CT_STATUS_CDCHAR2OIU_CT_STATUS_CD
OIU_SPOT_TERM_CDSpot/Term OIU_SPOT_TERM_CDCHAR1OIU_SPOT_TERM_CD
OIU_STNDEDQ_CDVarying/Equ Daily Qu OIU_STNDEDQ_CDCHAR1OIU_STNDEDQ_CD
OIU_IOTR_FLPrice includes Tax Reimbursement. OIU_IOTR_FLCHAR1OIU_X_FLAG
OIU_INTRA_INTERBoundary (Intra/Inter) Codes OIU_INTRA_INTER_CDCHAR1OIU_INTRA_INTER_CD
OIU_EXRES_SPLTExcess Residue Return (Before/After) Lease Plant Split Code OIU_EXRES_SPLT_CDCHAR1OIU_EXRES_SPLT_CD
OIU_EVGN_FLEvergreen Flag OIU_EVGN_FLCHAR1OIU_X_FLAG
OIU_EVGNPD_BASEvergreen Period Basis OIU_EVGNPD_BAS_CDCHAR2OIU_EVGNPD_BAS_CD
OIU_EVGN_PERD_QYEvergreen Period Duration OIU_EVGN_PERD_QYNUMC3NUMC03
OIU_PREIM_TM_CDPrimary Term Basis OIU_PREIM_TM_CDCHAR2OIU_CT_TM_BASIS
OIU_PRIM_TM_QYPrimary Term Length OIU_PRIM_TM_QYNUMC3NUMC03
OIU_SEC_TM_CDSecondary Term Basis OIU_SEC_TM_CDCHAR2OIU_CT_TM_BASIS
OIU_SEC_TM_QYSecondary Term Length OIU_SEC_TM_QYNUMC3NUMC03
OIU_EXP_NOTIF_DTExpiration Notification Date OIU_EXP_NOTIF_DTDATS8DATUM
OIU_INTIT_RDT_DTInitial Redetermination Date OIU_INTIT_RDT_DTDATS8DATUM
OIU_NEXT_RDT_DTNext redetermination date OIU_NEXT_RDT_DTDATS8DATUM
OIU_RTC_DTRight to cancel date OIU_RTC_DTDATS8DATUM
OIU_RDT_N_PERDRe-determination Notification Period (in Days) OIU_RDT_N_PERD_QYQUAN13(3) MENGE
OIU_RDT_REFQ_CDRedetermination Frequency Code OIU_RDT_REFQ_CDCHAR2OIU_RDT_REFQ_CD
OIU_RTF_CDRatification Date OIU_RTF_DTDATS8DATUM
OIU_IMB_PRVSN_FLImbalance Provision Flag OIU_IMB_PRVSN_FLCHAR1OIU_X_FLAG
OIU_FFEE_RMB_FLFiling Fee Reimbursement Flag OIU_FFEE_RMB_FLCHAR1OIU_X_FLAG
OIU_FIRM_INTRPTFirm/Interruptable Code OIU_FIRM_INTRPT_CDCHAR1OIU_FIRM_INTRPT_CD
OIU_BAL_BAS_CDBalancing Basis Code OIU_BAL_BAS_CDCHAR1OIU_VBAS_CD
OIU_PNTY_BAS_CDPenalty Basis Code OIU_PNTY_BAS_CDCHAR1OIU_VBAS_CD
OIU_TRANSP_BATransportation Basis Code OIU_TRANSP_BAS_CDCHAR1OIU_VBAS_CD
OIU_DLY_MAX_T_QYDaily Maximum Transport Quantity OIU_DLY_MAX_T_QYQUAN13(3) MENGE
OIU_PRCS_FLProcessing Flag OIU_PRCS_FLCHAR1OIU_X_FLAG
OIU_SPR_FLSeparation Flag OIU_SPR_FLCHAR1OIU_X_FLAG
OIU_DEHYD_FLDehydration Flag OIU_DEHYD_FLCHAR1OIU_X_FLAG
OIU_COMPR_FLCompression Flag OIU_COMPR_FLCHAR1OIU_X_FLAG
OIU_PYMT_METH_CDPayment Method Code OIU_PYMT_METH_CDCHAR1OIU_PYMT_METH_CD
OIU_CON_MATNRContaminant material OIU_CON_MATNRCHAR18Assigned to domainMATN1MATNR
OIU_CON_MAX_QYContaminant Percent OIU_CON_MAX_QYNUMC3OIU_CON_MAX_QY
OIU_AFFIL_FLAffiliate Flag OIU_AFFIL_FLCHAR1OIU_X_FLAG
OIU_MMS_TYPE_CDProduction: MMS-2014 - Sales Type Code OIUREP_MMS_2014_SALES_TYPE_CDCHAR4OIUREP_SALESTYOIUREP_MMS_2014_SALES_TYPE_CD
OIU_MMS_ETPAY_FLMMS-2014: Contracts with Estimated Payment OIUREP_MMS_2014_CT_EST_PAY_FLCHAR1YESNO
OIUH_CT_NOContract Number OIUH_CT_NOCHAR6CHAR6
OIU_CRUSERName of Person who Created the Object ERNAMCHAR12USNAM
OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPSDEC15TZNTSTMPS

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!