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  | IMRG
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
Plant Maintenance :: Technical Objects :: Additional Functions :: Measuring Points and Counters
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0IMRG534Measurement DocumentMeasuring Points and Counters
SQL:  selectupdate insert create

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

SELECT MANDT, MDOCM, POINT, IDATE, ITIME, INVTS, CNTRG, MDTXT, MLANG, KZLTX, READR, ERDAT, ERUHR, ERNAM, AEDAT, AENAM, LVORM, GENER, PRUEFLOS, VORGLFNR, MERKNR, DETAILERG, ROOTD, TOLTY, TOLID, WOOBJ, DOCAF, READG, READGI, RECDV, RECDVI, RECDU, CNTRR, CNTRRI, CDIFF, CDIFFI, IDIFF, EXCHG, TOTEX, CODCT, CODGR, VLCOD, CVERS, PREST, CANCL, WOOB1, PROBENR, MBEWERTG, INTVL, IDAT1, ITIM1, TMSTP_BW, LOGSYSTEM FROM IMRG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2MDOCMMeasurement Documentnvarchar200CHAR(N' ')NoIMRC_MDOCM Allow NULL? 
3POINTMeasuring Pointnvarchar120CHAR(N' ')NoIMPTTIMRC_POINT Allow NULL? 
4IDATEDate of the Measurementnvarchar80DATS(N'00000000')NoIMRC_IDATE Allow NULL? 
5ITIMETime of Measurementnvarchar60TIMS(N'000000')NoIMRC_ITIME Allow NULL? 
6INVTSInverted Time Stamp: 99.999.999.999 - Seconds ADnvarchar110NUMC(N'00000000000')NoIMRC_INVTS Allow NULL? 
7CNTRGIndicator: Counter Reading Documentchar10CHAR(N' ')NoIMRC_CNTRG Allow NULL? 
8MDTXTMeasurement Document Textnvarchar400CHAR(N' ')NoIMRC_MDTXT Allow NULL? 
9MLANGLanguage Keychar10LANG(N' ')NoT002SPRAS Allow NULL? 
10KZLTXIndicator: Long text existschar10CHAR(N' ')NoILOM_KZLTX Allow NULL? 
11READRPerson who Took the Measurement Readingnvarchar120CHAR(N' ')NoIMRC_READR Allow NULL? 
12ERDATDate on which the object was creatednvarchar80DATS(N'00000000')NoICRDT Allow NULL? 
13ERUHRTime at which the object was creatednvarchar60TIMS(N'000000')NoICRTM Allow NULL? 
14ERNAMName of User Who Created the Objectnvarchar120CHAR(N' ')NoICRNA Allow NULL? 
15AEDATDate on which the object was last changednvarchar80DATS(N'00000000')NoIUPDT Allow NULL? 
16AENAMName of the user who last changed the objectnvarchar120CHAR(N' ')NoIUPNA Allow NULL? 
17LVORMDeletion Flag for 1-Level Deletion Logicchar10CHAR(N' ')NoIMRC_DEL1 Allow NULL? 
18GENEROrigin Indicatorchar10CHAR(N' ')NoIMRC_GENER Allow NULL? 
19PRUEFLOSInspection Lot Numbernvarchar120NUMC(N'000000000000')NoQALSQPLOS Allow NULL? 
20VORGLFNRCurrent Node Number from Order Counter APLZLnvarchar80NUMC(N'00000000')NoQLFNKN Allow NULL? 
21MERKNRInspection Characteristic Numbernvarchar40NUMC(N'0000')NoQMERKNRP Allow NULL? 
22DETAILERGDevelopment reserve: Format NUMC, length 8nvarchar80NUMC(N'00000000')NoRESERVE_NUMC_008 Allow NULL? 
23ROOTDSource Document for Measurement Reading Transfernvarchar200CHAR(N' ')NoIMRGIMRC_ROOTD Allow NULL? 
24TOLTYCIM Resource Object Type for Production Resources/Toolsnvarchar20CHAR(N' ')NoIMRC_TOLTY Allow NULL? 
25TOLIDProduction Resource/Tool Object IDnvarchar80NUMC(N'00000000')NoCRIDIMRC_TOLID Allow NULL? 
26WOOBJObject Number of Ordernvarchar220CHAR(N' ')NoONR00IMRC_WOOBJ Allow NULL? 
27DOCAFIndicator: MeasDoc. Created After Associated Taskchar10CHAR(N' ')NoIMRC_DOCAF Allow NULL? 
28READGMeasurement Reading/Total Counter Reading in SI Unitfloat1516FLTP((0))NoIMRC_READG
29READGIIndicator: Associated Number Field Contains a Valuechar10CHAR(N' ')NoIVALU Allow NULL? 
30RECDVMeasurement Reading in Unit of Entryfloat1516FLTP((0))NoIMRC_RECDV
31RECDVIIndicator: Associated Number Field Contains a Valuechar10CHAR(N' ')NoIVALU Allow NULL? 
32RECDUUnit of Measurement for Document Entrynvarchar30UNIT(N' ')NoT006IMRC_RECDU Allow NULL? 
33CNTRRCounter Reading in SI Unitfloat1516FLTP((0))NoIMRC_CNTRR
34CNTRRIIndicator: Associated Number Field Contains a Valuechar10CHAR(N' ')NoIVALU Allow NULL? 
35CDIFFCounter Reading Difference in SI Unitfloat1516FLTP((0))NoIMRC_CDIFF
36CDIFFIIndicator: Associated Number Field Contains a Valuechar10CHAR(N' ')NoIVALU Allow NULL? 
37IDIFFIndicator: Counter Reading Entered as Differencechar10CHAR(N' ')NoIMRC_IDIFF Allow NULL? 
38EXCHGIndicator: Counter Replacedchar10CHAR(N' ')NoIMRC_EXCHG Allow NULL? 
39TOTEXIndicator: Total Counter Reading Set Externallychar10CHAR(N' ')NoIMRC_TOTEX Allow NULL? 
40CODCTCatalog Type - Measurement Reading Valuation Codechar10CHAR(N' ')NoTQ15IMRC_CODCT Allow NULL? 
41CODGRCode Group - Measurement Reading Valuation Codenvarchar80CHAR(N' ')NoQPGRIMRC_CODGR Allow NULL? 
42VLCODValuation Codenvarchar40CHAR(N' ')NoQPCDIMRC_VLCOD Allow NULL? 
43CVERSVersion Numbernvarchar60CHAR(N' ')NoQVERSNR Allow NULL? 
44PRESTProcessing Statuschar10CHAR(N' ')NoIMRC_PREST Allow NULL? 
45CANCLReversal Indicatorchar10CHAR(N' ')NoIMRC_CANCL Allow NULL? 
46WOOB1Object Number of Order Operation/Confirmation Counter etc.nvarchar220CHAR(N' ')YesONR00IMRC_WOOB1 Allow NULL? 
47PROBENRNumber of the Partial Samplenvarchar60NUMC(N'000000')YesQASVQSTIPRONR Allow NULL? 
48MBEWERTGInspection Result Valuationchar10CHAR(N' ')YesQMBEWERTG Allow NULL? 
49INTVLIndicator that Document Refers to Time Intervalchar10CHAR(N' ')YesIMRC_INTVL Allow NULL? 
50IDAT1Date of Interval Startnvarchar80DATS(N'00000000')YesIMRC_IDAT1 Allow NULL? 
51ITIM1Time of Interval Startnvarchar60TIMS(N'000000')YesIMRC_ITIM1 Allow NULL? 
52TMSTP_BWTime Stamp for BW Delta Extractiondecimal160DEC((0))YesTSTMP_BW_EXTRACT
53LOGSYSTEMLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
NamePrimaryUniqueTypeColumns
IMRG~0YesYesCLUSTEREDMDOCM, MANDT
IMRG~ANoNoNONCLUSTEREDINVTS, POINT, MANDT
IMRG~TNoNoNONCLUSTEREDROOTD, MANDT
IMRG~WNoNoNONCLUSTEREDWOOBJ, 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