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

30 columns | Print definition?ERP 6.0  | PROCID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7CNTPM_PROCTPM: Process2PROCIDProcess IDnvarchar320
2T7CNTPM_PROCDEFTPM: Process Definition(Step)3PROCIDProcess IDnvarchar320
3T7CNTPM_PROCRECTPM: Process Record13PROCIDProcess IDnvarchar320
TOPBasic Functions
4EMMAC_BPC_PROCIDLog Process ID of Action Box Transaction2PROCIDGeneric process class IDnvarchar600
TOPBatch-Oriented Parallel Processing of Mass Data
5BANK_PP_PARUNHDGeneral Data on Mass Runs (Header)19PROCIDProcess IDvarbinary160
6BANK_PROCFL_LOGData For Instantiation of Message Objects in Processes2PROCIDProcess IDvarbinary160
7BANK_PROCFL_PROCTemporary Process Data2PROCIDProcess IDvarbinary160
8BANK_PROCFL_RELLink Table for the Processes2PROCIDProcess IDvarbinary160
9BANK_REPORTSReport on Process2PROCIDProcess IDvarbinary160
10BANK_REP_PARAMSCurrent Selection Values for Report2PROCIDProcess IDvarbinary160
TOPCATT Computer Aided Test Tool
11CATDACATT - Test object transaction data information4PROCIDCATT - Subprocess IDnvarchar200
TOPContract Accounts Receivable and Payable
12TFKFSField Selector2PROCIDIdentification for a Process in FI-CAnvarchar20
13TFKFSDField Selector Data Table2PROCIDIdentification for a Process in FI-CAnvarchar20
TOPCustomer Interaction Center
14CRM_CIC_DEFWSSLDefault Workspace Profile Slot7PROCIDGeneric process class IDnvarchar600
15EWFCALFront Office Call9PROCIDGeneric process class IDnvarchar600
TOPEnvironment, Health and Safety
16/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten11PROCIDObsolete - Origin of tasknvarchar120
17/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv11PROCIDObsolete - Origin of tasknvarchar120
TOPGlobal Trade Services
18/SAPSLL/BOMHDSLL: BOM - Header14PROCIDProcurement Indicatornvarchar10
19/SAPSLL/BOMITSLL: BOM - Item10PROCIDProcurement Indicatornvarchar10
20/SAPSLL/PRFPMSLL: Preference: Log: Products8PROCIDProcurement Indicatornvarchar10
21/SAPSLL/PRFPMRASLL: Preference: Log: Prod: BOM Calculation Result- Assembly14PROCIDProcurement Indicatornvarchar10
22/SAPSLL/PRFPMRCSLL: Preference: Log: product: Result of BOM Calc - Compnt7PROCIDProcurement Indicatornvarchar10
23/SAPSLL/PRPROCIDSLL: Product Master: Procurement Type5PROCIDProcurement Indicatornvarchar10
TOPGraphical User Interface
24CNTLSTRINFAttributes of a stream3PROCIDChar 80nvarchar800
TOPLoans Management
25VDHOKOMain file header20PROCIDProcess IDnvarchar10
TOPOff-Cycle
26T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program21PROCIDProcess numbernvarchar100
27T52OCMPOff-Cycle Flag for Mass Processing15PROCIDProcess numbernvarchar100
TOPProcess Monitoring Infrastructure
28SSPIADMTR2PMI: Status Table for Transport Jobs (Central)3PROCIDSPI: Process Type IDnvarchar320
TOPService Station Retailing
29OIRADBTCSPROCLink subsequent processes to a completion strategy3PROCIDProcess IDnvarchar40
30OIRADBTSUBPROCSubsequent processes for the document base table1PROCIDProcess IDnvarchar40