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  | IMCC
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Investment Management :: Capital Investments :: Depreciation Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0IMCC471IM Summarization: Characteristics that are master dataDepreciation Simulation
SQL:  selectupdate insert create

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

SELECT CLIENT, COMPR_VRSN, INV_PROG, APPR_YEAR, PROG_POS, LOGSYSTEM, RECNO, REQUEST, MEASURE, COMPANY, COMP_CODE, BUS_AREA, CO_AREA, PROFIT_CTR, COSTCENTER, PLANT, FUNCTLOC, FUNC_AREA, INV_CNTRY, RESPNO_POS, PARTN_NAME, RESP_MEAS, NEW_OLD, BLITM, INV_REASON, ENVIR_INV, PRIORITY, ISTAT_REQ, ISTAT_MEAS, OBJECTTYPE, SCALE, IM_UFLD00, IM_UFLD01, IM_UFLD02, IM_UFLD03, IM_UFLD10, IM_UFLD11, OWNSYS_FLG, CREATED_BY, CREATED_ON, DIVISION, ORIG_APPR_YEAR, REQ_CHARACTER, MEAS_REQ_REL, IM_UFLD12, IM_UFLD13, RESP_COSTCENTER FROM IMCC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2COMPR_VRSNSummarization version in Info system for inv. programsnvarchar30CHAR(N' ')NoIMCHIMC_CVERS Allow NULL? 
3INV_PROGInvestment program namenvarchar80CHAR(N' ')NoIMCHIM_PRNAM Allow NULL? 
4APPR_YEARApproval year of the investment programnvarchar40NUMC(N'0000')NoIM_GNJHR Allow NULL? 
5PROG_POSIdentification for an investment program positionnvarchar240CHAR(N' ')NoIMCHIEIM_POSID Allow NULL? 
6LOGSYSTEMLogical Systemnvarchar100CHAR(N' ')NoIMCHLOGSYSTEM Allow NULL? 
7RECNORecord number for summarization of investment programsnvarchar80NUMC(N'00000000')NoIMC_RECNO Allow NULL? 
8REQUESTAppropriation request: Identification for internal usenvarchar240CHAR(N' ')YesIMCERIMC_RPOSID Allow NULL? 
9MEASUREMeasure: Identification for internal usenvarchar260CHAR(N' ')YesIMCEMIMC_MEASR Allow NULL? 
10COMPANYCompanynvarchar60CHAR(N' ')YesT880RCOMP_D Allow NULL? 
11COMP_CODECompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
12BUS_AREABusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
13CO_AREAControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
14PROFIT_CTRIM Summarization: Profit centersnvarchar100CHAR(N' ')YesIMCEPCIMC_PRCTR Allow NULL? 
15COSTCENTERIM Summarization: Requesting cost centernvarchar100CHAR(N' ')YesIMCECCIMC_KOSTL Allow NULL? 
16PLANTIM Summarization: Plantnvarchar40CHAR(N' ')YesIMCEPIMC_WERKS Allow NULL? 
17FUNCTLOCIM Summarization: Functional locationnvarchar300CHAR(N' ')YesIMCEFLIMC_TPLNR Allow NULL? 
18FUNC_AREAFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
19INV_CNTRYCountry for Which Approp. Request Is Plannednvarchar30CHAR(N' ')YesT005IMA_LAND1 Allow NULL? 
20RESPNO_POSPerson responsiblenvarchar80NUMC(N'00000000')YesTCJ04IM_VERNR Allow NULL? 
21PARTN_NAMEPartner Namenvarchar350CHAR(N' ')YesPARTN_NAME Allow NULL? 
22RESP_MEASName of person responsible for measurenvarchar250CHAR(N' ')YesIMC_VERNM Allow NULL? 
23NEW_OLDInd: Assignment new in approv. year/or copied from prev.yearchar10CHAR(N' ')YesIM_XGNJ Allow NULL? 
24BLITMIM: Balance sheet item (credit)nvarchar100CHAR(N' ')YesIM_ERGSO Allow NULL? 
25INV_REASONReason for investmentnvarchar20CHAR(N' ')YesT087IIZWEK Allow NULL? 
26ENVIR_INVReason for environmental investmentnvarchar50CHAR(N' ')YesT087KIMA_UMWKZ Allow NULL? 
27PRIORITYPrioritychar10CHAR(N' ')Yes*IM_PRIOR Allow NULL? 
28ISTAT_REQMain system status of an appropriation requestnvarchar50CHAR(N' ')YesIMA_STATUS Allow NULL? 
29ISTAT_MEASMain system status of measurenvarchar50CHAR(N' ')YesIM_STATUS Allow NULL? 
30OBJECTTYPEObject Typenvarchar20CHAR(N' ')YesJ_OBART_LD Allow NULL? 
31SCALEScale of investment objectsnvarchar20CHAR(N' ')YesTAIF5IM_SIZECL Allow NULL? 
32IM_UFLD00User field 1 (20 characters)nvarchar200CHAR(N' ')YesIMA_USR00 Allow NULL? 
33IM_UFLD01User field 2 (20 characters)nvarchar200CHAR(N' ')YesIMA_USR01 Allow NULL? 
34IM_UFLD02User field 3 (10 characters)nvarchar100CHAR(N' ')YesTAIF9IMA_USR02 Allow NULL? 
35IM_UFLD03User field 4 (10 characters)nvarchar100CHAR(N' ')YesTAIF9IMA_USR03 Allow NULL? 
36IM_UFLD10User field 11 as indicator for IM reportschar10CHAR(N' ')YesIMA_USR10 Allow NULL? 
37IM_UFLD11User field 12 as indicator for IM reportschar10CHAR(N' ')YesIMA_USR11 Allow NULL? 
38OWNSYS_FLGIM Summarization: Indicator: Own logical systemchar10CHAR(N' ')YesIMC_XOWN Allow NULL? 
39CREATED_BYName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
40CREATED_ONDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
41DIVISIONRequesting Divisionnvarchar20CHAR(N' ')YesTSPAIMA_ASPART Allow NULL? 
42ORIG_APPR_YEARApproval year for appropriation requestnvarchar40NUMC(N'0000')YesIMA_GJAHR Allow NULL? 
43REQ_CHARACTERAssignment of measures to appropriation requestchar10NUMC(N'0')YesIMA_REQ_CH Allow NULL? 
44MEAS_REQ_RELAssignment of measure to an appropriation requestchar10NUMC(N'0')YesIM_MEAS_AS Allow NULL? 
45IM_UFLD12User field 13 for period and fiscal yearnvarchar60ACCP(N' ')YesIMA_USR12 Allow NULL? 
46IM_UFLD13User field 14 for period and fiscal yearnvarchar60ACCP(N' ')YesIMA_USR13 Allow NULL? 
47RESP_COSTCENTERResponsible cost centernvarchar100CHAR(N' ')Yes*IMA_VKOSTL Allow NULL? 
NamePrimaryUniqueTypeColumns
IMCC~0YesYesCLUSTEREDRECNO, LOGSYSTEM, PROG_POS, APPR_YEAR, INV_PROG, COMPR_VRSN, CLIENT

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