SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | OIUCM_CONTRACT
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Production and Revenue Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIUCM_CONTRACT941PRA ContractsProduction and Revenue Accounting
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, VBELN, ERDAT, ERZET, ERNAM, ANGDT, BNDDT, AUDAT, VBTYP, TRVOG, AUART, NETWR, WAERK, VKORG, VTWEG, SPART, GUEBG, GUEEN, KNUMV, VDATU, VPRGR, KALSM, FKARA, AWAHR, KTEXT, BSTNK, BSTDK, BNAME, KUNNR, STWAE, AEDAT, KOKRS, BUKRS_VF, ZTERM, PRSDT, OIU_CT_TYPE_CD, OIU_CUST_VEND_CD, OIU_APPR_FL, OIU_APPR_DT, OIU_EXEC_DT, OIU_STD_CT_FL, OIU_PREV_CT_NO, OIU_GPLT_COMPANY, OIU_GPLT_VNAME, OIU_GPLT_DOI_NO, OIU_MK_REP_NO, OIU_MK_REP_ISQ, OIU_DEST_SALE_CD, OIU_LIFE_LSE_FL, OIU_INV_NO, OIU_INV_FL, OIU_OBLIG_DT, OIU_DESK_CD, OIU_EIA_GINA_CD, OIU_CT_STATUS_CD, OIU_SPOT_TERM_CD, OIU_STNDEDQ_CD, OIU_IOTR_FL, OIU_INTRA_INTER, OIU_EXRES_SPLT, OIU_EVGN_FL, OIU_EVGNPD_BAS, OIU_EVGN_PERD_QY, OIU_PREIM_TM_CD, OIU_PRIM_TM_QY, OIU_SEC_TM_CD, OIU_SEC_TM_QY, OIU_EXP_NOTIF_DT, OIU_INTIT_RDT_DT, OIU_NEXT_RDT_DT, OIU_RTC_DT, OIU_RDT_N_PERD, OIU_RDT_REFQ_CD, OIU_RTF_CD, OIU_IMB_PRVSN_FL, OIU_FFEE_RMB_FL, OIU_FIRM_INTRPT, OIU_BAL_BAS_CD, OIU_PNTY_BAS_CD, OIU_TRANSP_BA, OIU_DLY_MAX_T_QY, OIU_PRCS_FL, OIU_SPR_FL, OIU_DEHYD_FL, OIU_COMPR_FL, OIU_PYMT_METH_CD, OIU_CON_MATNR, OIU_CON_MAX_QY, OIU_AFFIL_FL, OIU_MMS_TYPE_CD, OIU_MMS_ETPAY_FL, OIUH_CT_NO, OIU_CRUSER, OIU_TIMESTAMP FROM OIUCM_CONTRACT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNContract Numbernvarchar100CHAR(N' ')NoOIU_CT_NO Allow NULL? 
3ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
4ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
5ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
6ANGDTQuotation/Inquiry is valid fromnvarchar80DATS(N'00000000')YesANGDT_V Allow NULL? 
7BNDDTDate until which bid/quotation is binding (valid-to date)nvarchar80DATS(N'00000000')YesBNDDT Allow NULL? 
8AUDATDocument Date (Date Received/Sent)nvarchar80DATS(N'00000000')YesAUDAT Allow NULL? 
9VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
10TRVOGTransaction groupchar10CHAR(N' ')YesTRVOG Allow NULL? 
11AUARTSales Document Typenvarchar40CHAR(N' ')YesTVAKAUART Allow NULL? 
12NETWRNet Value of the Sales Order in Document Currencydecimal152CURR((0))YesNETWR_AK
13WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
14VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
15VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVTWVTWEG Allow NULL? 
16SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART Allow NULL? 
17GUEBGValid-from date (outline agreements, product proposals)nvarchar80DATS(N'00000000')YesGUEBG Allow NULL? 
18GUEENValid-to date (outline agreements, product proposals)nvarchar80DATS(N'00000000')YesGUEEN Allow NULL? 
19KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
20VDATURequested delivery datenvarchar80DATS(N'00000000')YesEDATU_VBAK Allow NULL? 
21VPRGRProposed date typechar10CHAR(N' ')YesPRGRS_VBAK Allow NULL? 
22KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')YesT683KALSMASD Allow NULL? 
23FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')YesTVFKFKARA Allow NULL? 
24AWAHRSales probabilitynvarchar30NUMC(N'000')YesAWAHR_AK Allow NULL? 
25KTEXTSearch term for product proposalnvarchar400CHAR(N' ')YesKTEXT_V Allow NULL? 
26BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')YesBSTNK Allow NULL? 
27BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')YesBSTDK Allow NULL? 
28BNAMEName of orderernvarchar350CHAR(N' ')YesBNAME_V Allow NULL? 
29KUNNRSold-to partynvarchar100CHAR(N' ')YesKNA1KUNAG Allow NULL? 
30STWAEStatistics currencynvarchar50CUKY(N' ')YesTCURCSTWAE Allow NULL? 
31AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
32KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
33BUKRS_VFCompany code to be billednvarchar40CHAR(N' ')YesT001BUKRS_VF Allow NULL? 
34ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
35PRSDTDate for pricing and exchange ratenvarchar80DATS(N'00000000')YesPRSDT Allow NULL? 
36OIU_CT_TYPE_CDContract Typenvarchar20CHAR(N' ')YesOIU_CM_CTTYPOIU_CT_TYPE_CD Allow NULL? 
37OIU_CUST_VEND_CDCustomer/Vendor Indicatorchar10CHAR(N' ')YesOIU_CUST_VEND_CD Allow NULL? 
38OIU_APPR_FLApproval indicatorchar10CHAR(N' ')YesOIU_APPL_FL Allow NULL? 
39OIU_APPR_DTApproval Datenvarchar80DATS(N'00000000')YesOIU_APPR_DT Allow NULL? 
40OIU_EXEC_DTContract Execution Datenvarchar80DATS(N'00000000')YesOIU_EXEC_DT Allow NULL? 
41OIU_STD_CT_FLStandard Contract Flagchar10CHAR(N' ')YesOIU_STD_CT_FL Allow NULL? 
42OIU_PREV_CT_NOOld / Previous Contract Numbernvarchar100CHAR(N' ')Yes*OIU_PREV_CT_NO Allow NULL? 
43OIU_GPLT_COMPANYGas Plant Companynvarchar40CHAR(N' ')YesT001OIU_GPLT_BUKRS Allow NULL? 
44OIU_GPLT_VNAMEGas Plant Venturenvarchar60CHAR(N' ')YesOIU_DO_JVOIU_GPLT_VNAME Allow NULL? 
45OIU_GPLT_DOI_NOGasplant DOI Nonvarchar50CHAR(N' ')Yes*OIU_GPLT_DOI_NO Allow NULL? 
46OIU_MK_REP_NOMarketing Representative Nonvarchar100CHAR(N' ')Yes*OIU_MK_REP_NO Allow NULL? 
47OIU_MK_REP_ISQMarketing Representative Interest Sequence Nonvarchar20CHAR(N' ')YesOIU_MK_REP_ISQ_NO Allow NULL? 
48OIU_DEST_SALE_CDPlant Destination Of Product Sale Codeschar10CHAR(N' ')YesOIU_DEST_SALE_CD Allow NULL? 
49OIU_LIFE_LSE_FLLife Lease Flagchar10CHAR(N' ')YesOIU_LIFE_LSE_FL Allow NULL? 
50OIU_INV_NOContract Invoice Numbernvarchar60CHAR(N' ')YesOIU_INV_NO Allow NULL? 
51OIU_INV_FLInvoice Flagchar10CHAR(N' ')YesOIU_INV_FL Allow NULL? 
52OIU_OBLIG_DTObligation Datenvarchar80DATS(N'00000000')YesOIU_OBLIG_DT Allow NULL? 
53OIU_DESK_CDDesk Codesnvarchar30CHAR(N' ')Yes*OIU_DESK_CD Allow NULL? 
54OIU_EIA_GINA_CDEnergy Information Agency Report Codenvarchar20CHAR(N' ')Yes*OIU_EIA_GINA_CD Allow NULL? 
55OIU_CT_STATUS_CDContract Status Codenvarchar20CHAR(N' ')YesOIU_CT_STATUS_CD Allow NULL? 
56OIU_SPOT_TERM_CDSpot/Termchar10CHAR(N' ')YesOIU_SPOT_TERM_CD Allow NULL? 
57OIU_STNDEDQ_CDVarying/Equ Daily Quchar10CHAR(N' ')YesOIU_STNDEDQ_CD Allow NULL? 
58OIU_IOTR_FLPrice includes Tax Reimbursement.char10CHAR(N' ')YesOIU_IOTR_FL Allow NULL? 
59OIU_INTRA_INTERBoundary (Intra/Inter) Codeschar10CHAR(N' ')YesOIU_INTRA_INTER_CD Allow NULL? 
60OIU_EXRES_SPLTExcess Residue Return (Before/After) Lease Plant Split Codechar10CHAR(N' ')YesOIU_EXRES_SPLT_CD Allow NULL? 
61OIU_EVGN_FLEvergreen Flagchar10CHAR(N' ')YesOIU_EVGN_FL Allow NULL? 
62OIU_EVGNPD_BASEvergreen Period Basisnvarchar20CHAR(N' ')YesOIU_EVGNPD_BAS_CD Allow NULL? 
63OIU_EVGN_PERD_QYEvergreen Period Durationnvarchar30NUMC(N'000')YesOIU_EVGN_PERD_QY Allow NULL? 
64OIU_PREIM_TM_CDPrimary Term Basisnvarchar20CHAR(N' ')YesOIU_PREIM_TM_CD Allow NULL? 
65OIU_PRIM_TM_QYPrimary Term Lengthnvarchar30NUMC(N'000')YesOIU_PRIM_TM_QY Allow NULL? 
66OIU_SEC_TM_CDSecondary Term Basisnvarchar20CHAR(N' ')YesOIU_SEC_TM_CD Allow NULL? 
67OIU_SEC_TM_QYSecondary Term Lengthnvarchar30NUMC(N'000')YesOIU_SEC_TM_QY Allow NULL? 
68OIU_EXP_NOTIF_DTExpiration Notification Datenvarchar80DATS(N'00000000')YesOIU_EXP_NOTIF_DT Allow NULL? 
69OIU_INTIT_RDT_DTInitial Redetermination Datenvarchar80DATS(N'00000000')YesOIU_INTIT_RDT_DT Allow NULL? 
70OIU_NEXT_RDT_DTNext redetermination datenvarchar80DATS(N'00000000')YesOIU_NEXT_RDT_DT Allow NULL? 
71OIU_RTC_DTRight to cancel datenvarchar80DATS(N'00000000')YesOIU_RTC_DT Allow NULL? 
72OIU_RDT_N_PERDRe-determination Notification Period (in Days)decimal133QUAN((0))YesOIU_RDT_N_PERD_QY
73OIU_RDT_REFQ_CDRedetermination Frequency Codenvarchar20CHAR(N' ')YesOIU_RDT_REFQ_CD Allow NULL? 
74OIU_RTF_CDRatification Datenvarchar80DATS(N'00000000')YesOIU_RTF_DT Allow NULL? 
75OIU_IMB_PRVSN_FLImbalance Provision Flagchar10CHAR(N' ')YesOIU_IMB_PRVSN_FL Allow NULL? 
76OIU_FFEE_RMB_FLFiling Fee Reimbursement Flagchar10CHAR(N' ')YesOIU_FFEE_RMB_FL Allow NULL? 
77OIU_FIRM_INTRPTFirm/Interruptable Codechar10CHAR(N' ')YesOIU_FIRM_INTRPT_CD Allow NULL? 
78OIU_BAL_BAS_CDBalancing Basis Codechar10CHAR(N' ')YesOIU_BAL_BAS_CD Allow NULL? 
79OIU_PNTY_BAS_CDPenalty Basis Codechar10CHAR(N' ')YesOIU_PNTY_BAS_CD Allow NULL? 
80OIU_TRANSP_BATransportation Basis Codechar10CHAR(N' ')YesOIU_TRANSP_BAS_CD Allow NULL? 
81OIU_DLY_MAX_T_QYDaily Maximum Transport Quantitydecimal133QUAN((0))YesOIU_DLY_MAX_T_QY
82OIU_PRCS_FLProcessing Flagchar10CHAR(N' ')YesOIU_PRCS_FL Allow NULL? 
83OIU_SPR_FLSeparation Flagchar10CHAR(N' ')YesOIU_SPR_FL Allow NULL? 
84OIU_DEHYD_FLDehydration Flagchar10CHAR(N' ')YesOIU_DEHYD_FL Allow NULL? 
85OIU_COMPR_FLCompression Flagchar10CHAR(N' ')YesOIU_COMPR_FL Allow NULL? 
86OIU_PYMT_METH_CDPayment Method Codechar10CHAR(N' ')YesOIU_PYMT_METH_CD Allow NULL? 
87OIU_CON_MATNRContaminant materialnvarchar180CHAR(N' ')Yes*OIU_CON_MATNR Allow NULL? 
88OIU_CON_MAX_QYContaminant Percentnvarchar30NUMC(N'000')YesOIU_CON_MAX_QY Allow NULL? 
89OIU_AFFIL_FLAffiliate Flagchar10CHAR(N' ')YesOIU_AFFIL_FL Allow NULL? 
90OIU_MMS_TYPE_CDProduction: MMS-2014 - Sales Type Codenvarchar40CHAR(N' ')YesOIUREP_SALESTYOIUREP_MMS_2014_SALES_TYPE_CD Allow NULL? 
91OIU_MMS_ETPAY_FLMMS-2014: Contracts with Estimated Paymentchar10CHAR(N' ')YesOIUREP_MMS_2014_CT_EST_PAY_FL Allow NULL? 
92OIUH_CT_NOContract Numbernvarchar60CHAR(N' ')YesOIUH_CT_NO Allow NULL? 
93OIU_CRUSERName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
94OIU_TIMESTAMPUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTZNTSTMPS
NamePrimaryUniqueTypeColumns
OIUCM_CONTRACT~0YesYesCLUSTEREDVBELN, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy