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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

28 columns | Print definition?ERP 6.0  | FROMDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPCentral Part of Product Master
1COMM_PME_CAT_MAPMapping of a Category or Product to PME Classes3FROMDATEDate for Determining the Relevant Knowledge Basenvarchar80
2COMM_PME_PRD_MAPMapping of CRM Products for PME Classes3FROMDATEDate for Determining the Relevant Knowledge Basenvarchar80
3COMM_PME_SET_MAPMapping Set Types for PME Classes3FROMDATEDate for Determining the Relevant Knowledge Basenvarchar80
TOPCollectionsDisbursements
4DIMAIOBPARIO: Insurance Object-Partner Relationship in FS-CD13FROMDATETime Stamp (Date and Time)nvarchar140
TOPContract Accounts Receivable and Payable
5DFKKCCTKCollections Management: Test Series - Header Data4FROMDATEValid-from datenvarchar80
6DFKKCMUSERAdditional User for Collections Management6FROMDATEValid-From Date of Assignmentnvarchar80
7DFKKMANAGERAdditional User for Management of Worklists5FROMDATEValid-From Date of Assignmentnvarchar80
8DFKKVBUNDHistory: Trading Partners (VBUND) for Business Partner4FROMDATEValid-from datenvarchar80
9DFKKVBUNDHHistory: VBUND Adjustment Postings4FROMDATEValid-from datenvarchar80
TOPCross-Application Components
10CACNS_CU_HISTProjects at Customer7FROMDATEDate on which the Record Was Creatednvarchar80
TOPIntercompany Data Exchange
11EMRDETAILIDE: detailed information on MR results (ISU_USAGE_DATA)8FROMDATEStart of Periodnvarchar80
TOPInterface to Terminal Automation System
12OIK01IS-OIL/TAS: LID Document Data9FROMDATEValid from date (TAS)nvarchar80
13OIK01DIS-OIL/TAS: deactivated LID Document Data10FROMDATEValid from date (TAS)nvarchar80
14OIK37IS OIL: Shadow table for SD document processing26FROMDATETPI From Datenvarchar80
15OIKLIDRTD - TAS Reference Table5FROMDATETimestamp valid fromnvarchar140
TOPLease Accounting
16FILA_RE_PRGRefinancing Program11FROMDATEValid-from datenvarchar80
TOPMaster Data
17EPROPHAllocation of Inst. to Ownership4FROMDATEDate from which time slice is validnvarchar80
TOPProduct Configurator
18COMM_CFGKBRuntime Version of SCE Knowledge Base12FROMDATEKB validity datenvarchar80
TOPSales and Distribution
19SCEKBRuntime Version of SCE Knowledge Base6FROMDATEValid-from datenvarchar80
20SCEKBOBJKnowledge-Base Object (SCE)13FROMDATEValid-From Datenvarchar80
TOPTraders and Schedulers Workbench
21OIJTHPUTFCESTOIL-TSW: Rack issue / Throughput estimate pop-up10FROMDATEOIL-TSW: Start datenvarchar80
22OIJ_EL_DOC_I_REFDocument item reference to nomination40FROMDATEOIL-TSW: Deal validity From datenvarchar80
23OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item21FROMDATEOIL-TSW: Deal validity From datenvarchar80
24OIJ_RELPROFOil-TSW: Release profiles for Schedules4FROMDATEValid-from datenvarchar80
25S430SIS: (OIL-TSW) Sales document statistics by TSW object39FROMDATEOIL-TSW: Deal validity From datenvarchar80
26S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object44FROMDATEOIL-TSW: Deal validity From datenvarchar80
TOPTranslation Tools
27LXE_CSN_UPDATETable for Report RS_TRANSLATION_CSN_UPDATE7FROMDATESystem Datenvarchar80
28TPM_DIRTranslation performance monitor header6FROMDATEDate of Beginning of Intervalnvarchar80