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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

43 columns | Print definition?ERP 6.0  | CREADATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ISM_PT_JFRKPortugal: Digital Signature for Billing Document16CREADATESignature PT: Creation Datenvarchar80
2ISM_PT_JHTFKPortugal: Digital Signature for M/AM Billing Document16CREADATESignature PT: Creation Datenvarchar80
3SIPT_LIKPPortugal: Digital Signature for Delivery Document17CREADATESignature PT: Creation Datenvarchar80
4TBTCYTable for Jobs in Status "Ready"21CREADATEPlanned Start Date for Background Jobnvarchar80
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
5SCICHKV_ALTERCode Inspector: Mapping Global Check Variant to Alter Ego4CREADATECode Inspector: Changed Onnvarchar80
6SCICHKV_HDCode Inspector: Check Variant4CREADATECode Inspector: Changed Onnvarchar80
7SCIINS_INFCode Inspector: Data from Inspections13CREADATECode Inspector: Changed Onnvarchar80
8SCIOBJ_INFCode Inspector: Object Set7CREADATECode Inspector: Changed Onnvarchar80
9SCIPRIORITIESCode Inspector: Customizing for Message Priorities5CREADATECode Inspector: Changed Onnvarchar80
10SCI_OCSASSIGNCode Inspector: Customizing for Message Priorities5CREADATECode Inspector: Changed Onnvarchar80
11SCI_OCSNAMESCI: Data Object Classification Schema4CREADATECode Inspector: Changed Onnvarchar80
TOPBackground Processing
12FAVSELSUser-Specific Favorite Selection Criteria3CREADATESystem Datenvarchar80
TOPCanada
13PCERHHistory of Payroll Posting Runs10CREADATECreated onnvarchar80
14T5KR0Record of Employment (ROE) History16CREADATECreated onnvarchar80
TOPCollectionsDisbursements
15IBROSTMACTISCD: Broker Report - Activities Executed for Item8CREADATEDate on Which Record Was Creatednvarchar80
16IBROSTMHISCD: Broker Report - Header Data43CREADATEDate on Which Record Was Creatednvarchar80
17ITAGCYCOINSADDAgency Collections: Addtl Specification Coinsurance Shares3CREADATEDatenvarchar80
TOPData Transfer
18PEVSHHistory of Payroll Posting Runs8CREADATECreated onnvarchar80
19PPDSHPayroll Posting Document: Status History8CREADATECreated onnvarchar80
TOPInterface to Terminal Automation System
20OIKLIDTAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)31CREADATECreated onnvarchar80
21OIKLIDWTAS LID Working version (NOTE: keep DB eq to DB OIKLID)31CREADATECreated onnvarchar80
22OIKLOG01Log Table for Shipment planning7CREADATECreated onnvarchar80
TOPKnowledge Warehouse
23KWDELTA_WLIWB: Worklist for Delta Delivery (Content)6CREADATECreated onnvarchar80
TOPLocalization
24ISJPINVSUMHDInvoice Summary Header26CREADATECreation Datenvarchar80
25ISJPINVSUMITLine items for invoice summary21CREADATECreation Datenvarchar80
26ISJPVIRTACCTVirtual accounts6CREADATECreation Datenvarchar80
27SIPT_BKPFPortugal: Digital Signature for Accounting Documents18CREADATESignature PT: Creation Datenvarchar80
28SIPT_RBKPPortugal: Digital Signature for Self Billing Document20CREADATESignature PT: Creation Datenvarchar80
29SIPT_VBRKPortugal: Digital Signature for Billing Document16CREADATESignature PT: Creation Datenvarchar80
30VIXCPTSIPTDigital Signature for Invoices19CREADATESignature PT: Creation Datenvarchar80
TOPMonitoring
31ALPFDBVARPFDB: Report Variants5CREADATEAlert: datenvarchar80
TOPProduct Configurator
32COMM_CFGKBRuntime Version of SCE Knowledge Base16CREADATEKB validity datenvarchar80
TOPReporting
33T5KR4Record of Employment (ROE) History for Concurrent Employment15CREADATECreated onnvarchar80
TOPRuntime WorkbenchMonitoring
34SXIPMIDESTPMI Component and Destination for XI Component12CREADATESystem Datenvarchar80
35SXIPMIPROCIDXI Process Type of PMI Monitoring5CREADATESystem Datenvarchar80
TOPSales and Distribution
36SCEKBRuntime Version of SCE Knowledge Base10CREADATECreation datenvarchar80
37SCEKBOBJKnowledge-Base Object (SCE)8CREADATEDate on Which Record Was Creatednvarchar80
TOPSAP Business Workflow
38SWFDEXPVERTest and Verification of Expression Package SWF_EXP25CREADATESystem Datenvarchar80
39SWUFORMTRCSAPforms: Trace management4CREADATESAPforms: Creation date of trace entrynvarchar80
TOPSAP Records Management
40SRMWFPATHWorkflow Process Route7CREADATEDate Process Route Creatednvarchar80
41SRMWFPTHPSProcess Route Item for Workflow12CREADATECreation Date of Process Route Itemnvarchar80
TOPThird Party Remittance
42T51R5_HISTRemittance accumulated posting data history11CREADATECreated onnvarchar80
TOPTranslation Tools
43TPM_DIRTranslation performance monitor header4CREADATEDate creatednvarchar80