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  | TEMRUN
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 :: SAP Utilities :: Tools :: Migration
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TEMRUN253Mass import: Header dataMigration
SQL:  selectupdate insert create

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

SELECT RUNID, MASSRUNID, FIRMA, OBJECT, FILE, PATH, CPGFS, FILESIZE, STATUS, SPLITFILE, SPLITERRFILE, NCOMM, ERABS, ERREL, ERINT, STOP, ERRFILE, DISTRIBUTION, DIST_ACTIVE, DATUM1, UZEIT1, UNAME1, DATUM2, UZEIT2, UNAME2 FROM TEMRUN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1RUNIDIdentification of mass importnvarchar320CHAR(N' ')NoEMG_MASSRUN Allow NULL? 
2MASSRUNIDIS Migration: Identifier Distributed Importnvarchar150CHAR(N' ')NoEMG_MASSRUNID Allow NULL? 
3FIRMACompany (Client) for Migrationnvarchar50CHAR(N' ')Yes*EMG_FIRMA Allow NULL? 
4OBJECTMigration Objectnvarchar100CHAR(N' ')Yes*EMG_OBJECT Allow NULL? 
5FILEFile Name for Migrationnvarchar140CHAR(N' ')YesEMG_FILE Allow NULL? 
6PATHPath for Migration Batchnvarchar600CHAR(N' ')YesEMG_PFAD_BACK Allow NULL? 
7CPGFSCode Page of Legacy Systemnvarchar40NUMC(N'0000')Yes*EMG_SCP Allow NULL? 
8FILESIZEFile size for mass importnvarchar50NUMC(N'00000')YesEMG_MASSRUN_SIZE Allow NULL? 
9STATUSMigration statusnvarchar40CHAR(N' ')YesEMG_STATUS Allow NULL? 
10SPLITFILEName of Input File After Split is Genericnvarchar140CHAR(N' ')YesEMG_SPLITFILE Allow NULL? 
11SPLITERRFILEGeneric Name for Error File for Splitnvarchar140CHAR(N' ')YesEMG_SPLITERRFILE Allow NULL? 
12NCOMMCommit interval of migrationnvarchar60NUMC(N'000000')YesEMG_NCOMM Allow NULL? 
13ERABSNumber of absolute errors per migration runnvarchar60NUMC(N'000000')YesEMG_ERABS Allow NULL? 
14ERRELRelative errors per migration runnvarchar30NUMC(N'000')YesEMG_ERREL Allow NULL? 
15ERINTInterval for determining relative errornvarchar40NUMC(N'0000')YesEMG_ERINT Allow NULL? 
16STOPCancel distributed import runchar10CHAR(N' ')YesEMG_MASSRUN_STOP Allow NULL? 
17ERRFILEName of error filenvarchar140CHAR(N' ')YesEMG_EFILE Allow NULL? 
18DISTRIBUTIONJob Distribution Definitionnvarchar150CHAR(N' ')YesTEMRUNDEFDISTEMG_DISTRIBUTION Allow NULL? 
19DIST_ACTIVEActivate Job Distributionchar10CHAR(N' ')YesEMG_DIST_ACTIVE Allow NULL? 
20DATUM1Date of entrynvarchar80DATS(N'00000000')YesEMG_EDATUM Allow NULL? 
21UZEIT1Time of Entrynvarchar60TIMS(N'000000')YesEMG_EUZEIT Allow NULL? 
22UNAME1Name of usernvarchar120CHAR(N' ')YesEMG_EUSER Allow NULL? 
23DATUM2Date of last changenvarchar80DATS(N'00000000')YesEMG_ADATUM Allow NULL? 
24UZEIT2Last changed atnvarchar60TIMS(N'000000')YesEMG_AUZEIT Allow NULL? 
25UNAME2Name of user who made changes lastnvarchar120CHAR(N' ')YesEMG_AUSER Allow NULL? 
NamePrimaryUniqueTypeColumns
TEMRUN~0YesYesCLUSTEREDRUNID
TEMRUN~001NoNoNONCLUSTEREDDISTRIBUTION, DIST_ACTIVE
TEMRUN~002NoNoNONCLUSTEREDMASSRUNID

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