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  | ENTRY_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SYCLO/WB005RDevTool: Data table entries2ENTRY_IDDevTool: entry GUIDnvarchar320
2/XFT/CM_002Contract: Dsitributor automatic notification3ENTRY_IDCharacter field, length 32nvarchar320
3/XFT/CM_100Contract: Order table for autom. sending of notifications3ENTRY_IDCharacter field, length 32nvarchar320
4/XFT/CM_100_AContract: Order table autom. sending of notification (arch.)3ENTRY_IDCharacter field, length 32nvarchar320
5/XFT/SRMDOCTT003Form Fields: Catalogs4ENTRY_IDSequencenvarchar80
6/XFT/SRMDOCTT004Short Description: Form Fields4ENTRY_IDSequencenvarchar80
7AMC_LOG_STORAGEAMC logging storage9ENTRY_ID16 Byte UUID in 32 Characters (Hexadecimal Encoded)nvarchar320
TOPApplication Frame
8CRMC_UI_CBENTRYEntry Definition2ENTRY_IDEntry IDnvarchar100
9CRMC_UI_CBENTR_TEntry Definition2ENTRY_IDEntry IDnvarchar100
10CRMC_UI_CBPROF_AEntry Assignment3ENTRY_IDEntry IDnvarchar100
TOPAppointment Calendar
11SCOWNEROwner of an appointment calendar6ENTRY_IDView Displayed After Calendar Callednvarchar10
TOPBackground RFC bgRFC
12BGRFC_CUST_I_SYSCustomizing for Outbound Scheduler/System-Wide Settings1ENTRY_IDID of Entry in System-Wide bgRFC Customizingnvarchar100
13BGRFC_CUST_O_SYSCustomizing for Outbound Scheduler/System-Wide Settings1ENTRY_IDID of Entry in System-Wide bgRFC Customizingnvarchar100
TOPBasis Components
14/XFT/INV_Q_13Relations Process Types3ENTRY_IDEntry IDnvarchar320
15/XFT/INV_Q_13_SRelationes Process Types (Shadow Table)3ENTRY_IDEntry IDnvarchar320
TOPGeneral Application Functions
16BAMUIASApplication Analysis: Displaying ASTAT Records in ST144ENTRY_IDSAP Workload: Workload: Tcode, report or report+jobnamenvarchar730
17BAMUIASTApplication Analysis: ASTAT Records in ST145ENTRY_IDSAP Workload: Workload: Tcode, report or report+jobnamenvarchar730
TOPInteraction Center WebClient
18CRMC_IC_ACENTRYActivity Clipboard Entry Definition2ENTRY_IDActivity Clipboard Entry IDnvarchar300
19CRMC_IC_ACENTR_TActivity Clipboard Entries of a Profile2ENTRY_IDActivity Clipboard Entry IDnvarchar300
20CRMC_IC_ACPROFEActivity Clipboard Entries of a Profile3ENTRY_IDActivity Clipboard Entry IDnvarchar300
21CRMC_IC_ACPROFFActivity Clipboard Filters for Profile Entries3ENTRY_IDActivity Clipboard Entry IDnvarchar300
22CRMC_IC_NBENTRYNavigation Bar Entry Definition2ENTRY_IDNavigation Bar Entry IDnvarchar300
23CRMC_IC_NBENTR_TNavigation Bar Entry Definition Texts2ENTRY_IDNavigation Bar Entry IDnvarchar300
24CRMC_IC_NBEVIEWSTarget Views and View Sets2ENTRY_IDNavigation Bar Entry IDnvarchar300
25CRMC_IC_NBPERSPersonalized Navigation Bar Profile Settings4ENTRY_IDNavigation Bar Entry IDnvarchar300
26CRMC_IC_NBPROFNavigation Bar Profile3ENTRY_IDDefault Entry When Logging On to IC WebClientnvarchar300
27CRMC_IC_NBPROFENavigation Bar Entries of a Profile3ENTRY_IDNavigation Bar Entry IDnvarchar300
28CRMD_IC_NBPERSPersonalized Navigation Bar Profile Settings4ENTRY_IDNavigation Bar Entry IDnvarchar300
TOPMaxDB
29SDBADSDBDBA calendar: planning- vs. R/3 exec.vs. DB exec. times16ENTRY_IDCommentnvarchar500
TOPUse Subcomponents
30SADRFFax addresses with cover sheet38ENTRY_IDRow Index of Internal Tablesint100