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

26 columns | Print definition?ERP 6.0  | VON

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/UST12Copy of table UST12 (used in Security Optimization Services)5VONAuthorization Valuenvarchar400
2T548SDate Conversion4VONText for start datenvarchar200
TOPBusiness Package for Manager Self-Service FI
3FPB_GEN_PROF_LOGLog Entries for Generating Authorizations7VONAuthorization Valuenvarchar400
4FPB_VALUESAuthorizations for FG FPB_Berechtigungen6VONAuthorization Valuenvarchar400
TOPCapacity Leveling
5R2AUFNROrder number for transfer from R/2 to PP-PI1VONR/2 order number at which transfer is startednvarchar80
TOPDevice Management
6EANASIS-U Device Checker: Current Processing Status of Test5VONNumber of First Object to be Testednvarchar300
TOPGRC Access Control Plug-In
7/VIRSA/FUNCTOBJFunction - Objects6VON'From' valuenvarchar400
8/VIRSA/ORGRULESOrganizational values5VON'From' valuenvarchar400
9/VIRSA/ORGUSERSMapping between users and the organizational values5VON'From' valuenvarchar400
10/VIRSA/ZCRAUTHAuthorization Objects5VON'From' valuenvarchar400
11/VIRSA/ZCRAUTHC1Restricted Critical Authorizations5VON'From' valuenvarchar400
12/VIRSA/ZCRAUTHL1SOD Authorization Object5VON'From' valuenvarchar400
13/VIRSA/ZCRAUTHL2SOD Authorization Object5VON'From' valuenvarchar400
14/VIRSA/ZCRAUTHL3SOD Authorization Object5VON'From' valuenvarchar400
15/VIRSA/ZCRAUTHL4SOD Authorization Object5VON'From' valuenvarchar400
16/VIRSA/ZCRAUTHL5SOD Authorization Object5VON'From' valuenvarchar400
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
17TFAINCalendar: Intervals for company holidays, special shifts3VONDate from which special rule is validnvarchar80
18TFAITCalendar: Text for factory calendar intervals4VONDate from which special rule is validnvarchar80
TOPInvoicing
19TE211BB: Rounding Parameter5VONLower limit of budget billing amount for roundingdecimal122
20TE647Dynamic Determination of BB Cycle3VONLower limit for dynamic determination of bud. billing cycledecimal122
TOPMobile Applications
21/ISDFPS/MECAA010Local Authorization (Item) for Logging10VONAuthorization Valuenvarchar400
TOPPublic Sector
22P01ZFA_NN_DATAZfA: Notifications Not Assigned39VONFrom Period (5.0)nvarchar60
23P01ZFA_NN_KIDSZfA: Notifications Not Assigned - Child Data17VONFrom Period (5.0)nvarchar60
TOPUser and Authorization Management
24USKRIAEntry of Critical Auths for Report RSUSR0094VON'From' valuenvarchar400
25USKRIATText table for USKRIA5VON'From' valuenvarchar400
26UST12User master: Authorizations6VONAuthorization Valuenvarchar400