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

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FMBASOBJNR_TRACETrace for table FMBASOBJNR7FUNCAREAFunctional Areanvarchar160
2FMBCS_FMBL_CDEmpty table for change documents on FMBL incl. local. fields15FUNCAREAFunctional Areanvarchar160
3GRACREQRequest Header9FUNCAREAFunctional Areanvarchar100
TOPActual Update and Commitment Update
4GMREVBDGTFM1Defult settings for GM revaluation of currency7FUNCAREAFunctional Areanvarchar160
TOPAvailability Control
5FMAVCOObject table 111FUNCAREAFunctional Areanvarchar160
TOPBases
6T77OMAHQ_FUNCAROM-Search Function "Free Search": Obj. Type InfoSet (Cust.)4FUNCAREASAP Query (S): InfoSetnvarchar240
7T77OMAHQ_FUNCARSOM-Search Function "Free Search": Obj. Type InfoSet (Std.)4FUNCAREASAP Query (S): InfoSetnvarchar240
TOPBudget Control System
8FMBASOBJNRObject numbers for FM addresses9FUNCAREAFunctional Areanvarchar160
TOPBudgeting
9BUCC_RULEConsistency Checks - Rules17FUNCAREAKey Figures - Functional area aggregationnvarchar10
10FMBDOObject table 1 - Budget address11FUNCAREAFunctional Areanvarchar160
11FMBLFunds management budget document lines (entry documents)15FUNCAREAFunctional Areanvarchar160
12FMHBLFunds management budget document lines (held documents)15FUNCAREAFunctional Areanvarchar160
13FMPEP_VARIANTLSession variants (line part) for transaction FMPEP15FUNCAREAFunctional Areanvarchar160
14FMRBOObject table 111FUNCAREAFunctional Areanvarchar160
TOPBudgeting and Availability Control
15GMFMRECSGM RIB: FM Receivers (obsolete)9FUNCAREAFunctional Areanvarchar160
16GMFMRECS1GM RIB: FM Budget Receivers6FUNCAREAFunctional Areanvarchar160
TOPBW Service API
17AQBWCATInfoSource Catalog (SAP Query) Customer3FUNCAREASAP Query (S): InfoSetnvarchar240
18AQBWCAT_SAPInfoSource Catalog (SAP Query) Used by SAP3FUNCAREASAP Query (S): InfoSetnvarchar240
TOPClaims Management
19ICLALAERESCurrent Reserves (Settlement Expenses (ALAE) and Losses)9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
20ICLINDRESIClaim-Independent Reserve22FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
21ICLULAEACCRESAdditional Reserve Amounts at Claim Year and Coverage Level9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
22ICLULAECOVRESDetermined Additional Reserve Amounts at Coverage Level9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
23ICLULAEDRIVER1Reported Distribution Key 19FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
24ICLULAEDRIVER2Reported Distribution Key 29FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
25ICLULAEPERCENTDetermined Percentage and Additional Reserve Amounts9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
26ICLULAEREPPAYReported Settlement Expenses9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
27ICLULAERESCurrent Reassigned Reserves (ULAE)9FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
28TICL830Entity Table: Operational Area (Possibly Function Area)2FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
29TICL830TText Table Operational Area3FUNCAREAFunctional Area for Reserve Redistribution (LAE)nvarchar30
TOPEmployee Self-Service
30T77WWW_WHOControl Table for Selection and Output Fields in Who's Who3FUNCAREASAP Query (S): InfoSetnvarchar240
31T77WWW_WHO_PARAESS Who's Who: Parameters per Country Grpg and Appl. Type4FUNCAREASAP Query (S): InfoSetnvarchar240
TOPOrganizational Management
32T77ARRAYTPColumn Framework: Definition of Column Groups3FUNCAREASAP Query (S): InfoSetnvarchar240
TOPSAP Query
33AQPROTQuery Logging5FUNCAREASAP Query (S): InfoSetnvarchar240
34AQPROTCUSTQuery Logging Control3FUNCAREASAP Query (S): InfoSetnvarchar240
TOPWithout Description
35RSTT_ERRAttributes for Defects Found with BI ATR10FUNCAREATechnology Area for Test Activitiesnvarchar40
36RSTT_TESTStore of Existing Test Sequences8FUNCAREATechnology Area for Test Activitiesnvarchar40