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

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

39 columns | Print definition?ERP 6.0  | RTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/KORA/PROTOCOL_Tkr: protocol error messages6RTIMESystem Timenvarchar60
2BBPD_ARCH_RESIArchiving of EBP Documents Resididence Times4RTIMEResidence Time of SRM Documents After Change Date in Daysnvarchar40
3LXE_RLTP_LOGRemote Copy Registration7RTIMESystem Timenvarchar60
4NWS_EXT_PROTHData Transport Management Tool Log Header7RTIMERuntimenvarchar60
5P08P1CNTCLASS Interface Control Table (OBSOLETE from 46C)9RTIMECLASS CPX INTERFACE Control File Run Timenvarchar60
6P08P_CLSCCLASS Interface Control Table (46C onwards)10RTIMECLASS CPX INTERFACE Control File Run Timenvarchar60
7P08P_USSCUSS Interface Control Table (Contributions & Salary Changes)6RTIMEUSS Interface Control File Run Timenvarchar60
8P08P_USSC_CAREUSS Interface Control Table (Contributions & Salary Changes)7RTIMEUSS Interface Control File Run Timenvarchar60
9T5GPBSH_CONTROLHESA NISR Control table5RTIMETimenvarchar60
10T5GPBST_CONTROLTPS Control records6RTIMETimenvarchar60
11TVARASales Document Archiving Control4RTIMEResidence time of sales document in daysnvarchar40
12TVARKArchiving Control for Sales Activities in Sales Support4RTIMEResidence time of activity in days after last changenvarchar40
13TVARRArchiving Control for Billing4RTIMEResidence time of a billing document in daysnvarchar40
TOPAccount Determination
14TVARLArchiving Control for Delivery4RTIMEResidence time for a delivery in daysnvarchar40
TOPBasic Data
15TNC301GIIS-HCM: EDI Procedure in Institution9RTIMEResidence Type of an EDI Message in Daysnvarchar40
TOPBasic Functions
16T243LSLogging Table for Distributed CM Data5RTIMETime: TR-CM subsystem for sending data requestednvarchar60
TOPBelgium
17T5BSDSI Declaration: directory table10RTIMEnvarchar60
TOPClinical System
18N1MEOACTi.s.h.med: Medication, Order Activities9RTIMEMedication: Execution Time of Order Activitynvarchar60
TOPCommodity Pricing Engine
19CPEC_QUOTNAMEQuotation Name10RTIMEResidence Time / Daysnvarchar40
TOPConditions
20T681HConditions: Usage/Application with Client4RTIMERetention period for condition recordsnvarchar40
TOPControlling
21COK41C_IDIdentification Table for Posting Runs6RTIMESystem Timenvarchar60
TOPFinland
22T7FITELMETEL messages4RTIMERun timenvarchar60
23T7FITELME_ABSTEL messages - Absences4RTIMERun timenvarchar60
TOPFrance
24PA0424Industrial accident / maternity / sickness statement (FR)28RTIMETime of notificationnvarchar60
TOPGeneral Application Functions
25BAM5RTIMERuntime analysis6RTIMESystem Timenvarchar60
TOPGlobal Trade Services
26/SAPSLL/TVDFRMSLL: Preference: Documents12RTIMEResidence Time (Long-Term Vendor Declaration)nvarchar40
TOPliveCache Applications
27/SAPAPO/RSP_LCCSManagement of Planning Version in the RSP liveCache Check6RTIMETIME Data Element for SYSTnvarchar60
TOPNorway
28T5V5MMessages sent electronically to AA-registeret4RTIMEAA-Register file creation time.nvarchar60
29T5V7BMessages sent to employees/emplyoers register6RTIMETime message for the AA-register was created in the systemnvarchar60
TOPPatient Accounting
30NBDTIS-H: Ins. assoc. billing cases transferred - status header6RTIMEIS-H: Confirmation time of IDA billing casenvarchar60
TOPPersonnel Administration
31PA0255HR master record Infotype 0082 (Additional absence data)27RTIMETime reportednvarchar60
TOPPersonnel Time Management
32PA0082HR Master Record: Infotype 0082 (Additional Absence Data)27RTIMETime reportednvarchar60
TOPSweden
33T5S0SMessages for sickness administration (SE)6RTIMETime message for the AA-register was created in the systemnvarchar60
TOPThird Party Remittance
34T51R1Remittance evaluation run data8RTIMETimenvarchar60
TOPTraders and Schedulers Workbench
35OIJARCOIL-TSW : Archiving related customizing3RTIMEOIL-TSW: TSW archiving retention timenvarchar40
TOPTranslation Tools
36LXE_WRKLIDPersonal Worklists4RTIMETimenvarchar60
TOPTransportation and Distribution
37TOIGARCTD Archiving shipment3RTIMETD - archiving retention timenvarchar40
TOPUnited Kingdom
38T5G_ASHE_CONTROLASHE Control Table4RTIMETimenvarchar60
TOPWork Clearance Management
39WCAAPWCM: Application72RTIMEReceive Timenvarchar60