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

36 columns | Print definition?ERP 6.0  | CLASS_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/SSMMESS00SSM: Meldung: Kopftabelle5CLASS_IDSSM: Klassifikations IDnvarchar320
2/XFT/SSM_DOCC11SSM: Protokoll: Klassifikation3CLASS_IDSSM: Protokoll Klassifizierungnvarchar320
3/XFT/SSM_DOCC11TSSM: Protokoll Klass. ID4CLASS_IDSSM: Protokoll Klassifizierungnvarchar320
TOPAppointment Calendar
4SCAPPTUser-Specific Appointments14CLASS_IDVisibility for Other Usersnvarchar10
5SCGENAPPTgenerated appointments (regular or group appointments)13CLASS_IDVisibility for Other Usersnvarchar10
6SCOWNEROwner of an appointment calendar13CLASS_IDVisibility for Other Usersnvarchar10
TOPBack Office
7TRFT_CLASS_POSTreasury: TRF Class Position4CLASS_IDSecurity ID Numbernvarchar130
TOPBusiness Rule Framework
8TBRF110BRF: Event8CLASS_IDKey of Implementing Classnvarchar200
9TBRF110CBRF: Event - C Table8CLASS_IDKey of Implementing Classnvarchar200
10TBRF150BRF: Expression12CLASS_IDKey of Implementing Classnvarchar200
11TBRF171BRF: Subactions7CLASS_IDKey of Implementing Classnvarchar200
12TBRF173BRF: Assignment of Messages to Subactions7CLASS_IDKey of Implementing Classnvarchar200
13TBRF174BRF: Message Variables (for Messages in Subactions)7CLASS_IDKey of Implementing Classnvarchar200
14TBRF175BRF: Literal as Message Variable (for Subactions)8CLASS_IDKey of Implementing Classnvarchar200
15TBRF180BRF: Implementing Class4CLASS_IDKey of Implementing Classnvarchar200
16TBRF180CBRF: Implementing Class - C Table4CLASS_IDKey of Implementing Classnvarchar200
17TBRF180TBRF: Implementing Class - Text5CLASS_IDKey of Implementing Classnvarchar200
18TBRF212(Obsolete) BRF: Rules in Event - Administrative Data6CLASS_IDKey of Implementing Classnvarchar200
19TBRF250BRF: Subaction-Expressions Assignment7CLASS_IDKey of Implementing Classnvarchar200
20TBRF259BRF: Expressions in Subactions (for Pre-Processing)7CLASS_IDKey of Implementing Classnvarchar200
21TBRF280BRF: Rule Set - Header Data9CLASS_IDKey of Implementing Classnvarchar200
22TBRF280CBRF: Rule Set - Header Data - C Table9CLASS_IDKey of Implementing Classnvarchar200
23TBRF360BRF: Standard Context11CLASS_IDKey of Implementing Classnvarchar200
24TBRFMIG_CAssignment Table for Migrated Customizing Objects10CLASS_IDKey of Implementing Classnvarchar200
25TBRFMIG_SAssignment Table for Migrated System Objects9CLASS_IDKey of Implementing Classnvarchar200
TOPCampaign Weighing and Dispensing
26CWD_EQUI_CLASSCampaign Weighing Equipment Class and Characteristics2CLASS_IDClass numbernvarchar180
TOPClaims Management
27TICL947BRFplus: Prompting Texts - Display Sequence (Header Data)7CLASS_IDKey of Implementing Classnvarchar200
TOPPublic Sector Contract Accounts Receivable and Payable
28DFMCA_BRF173BRF: Assignment of Messages to Subactions7CLASS_IDKey of Implementing Classnvarchar200
29DFMCA_BRF174BRF: Message Variables (for Messages in Subactions)7CLASS_IDKey of Implementing Classnvarchar200
30DFMCA_BRF175BRF: Literal as Message Variable (for Subactions)8CLASS_IDKey of Implementing Classnvarchar200
31DFMCA_BRF177BRF: Assignment of Messages to Subactions7CLASS_IDKey of Implementing Classnvarchar200
32DFMCA_BRF178BRF: Message Variables (for Messages in Subactions)7CLASS_IDKey of Implementing Classnvarchar200
33DFMCA_BRF179BRF: Literal as Message Variable (for Subactions)8CLASS_IDKey of Implementing Classnvarchar200
TOPTransaction Manager
34TRQT_INIT_LOT(obsolete)3CLASS_IDSecurity ID Numbernvarchar130
TOPWorkforce Management Core
35/SAPAPO/LRPOBJTTable for LRP Text Objects2CLASS_IDGUID of a Persistent Objectnvarchar220
36/SAPAPO/LRPSMAPObsolete: Mapping Table of LRP Naming Service (Short Names)4CLASS_IDGUID of a Persistent Objectnvarchar220