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

31 columns | Print definition?ERP 6.0  | USERG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T588BInfotype Menus4USERGUser groupnvarchar20
2T5UPBS01FAVORITENature of Actions Favorites Tree4USERGUser groupnvarchar20
3T5UPBS01TREEPersonnel Actions Tree4USERGUser groupnvarchar20
TOPPension fund Netherlands
4T5NBCInfotypes voor veldselectie van actuarieel rapportagetool5USERGGebruikersgroepnvarchar20
TOPPersonnel Administration
5T529FFast Data Entry for Actions4USERGUser groupnvarchar20
6T588DInfogroups for Actions3USERGUser groupnvarchar20
7T588YSAdditional Info on Screens Generated from TMYPA425USERGUser groupnvarchar20
TOPPublic Sector
8T7PBSWB4ASpecification of Process group4USERGPWE user parameter valuenvarchar20
TOPTravel Planning
9FTPT_ITEMTravel Service Request Item8USERGUser Grouping for Travel Planningnvarchar20
10FTPT_QT_QTRIPQuicktrip Trip4USERGUser Grouping for Travel Planningnvarchar20
11TA20BControl Variant for Travel Planning2USERGGrouping: Travel Planning Control Variantnvarchar20
12TA20B1Control Variants - Travel Planning (Language-Dependent)3USERGGrouping: Travel Planning Control Variantnvarchar20
13TA20BAAccess Parameters of User Groups per Reservation System2USERGUser Grouping for Travel Planningnvarchar20
14TA20BHDisplayable Hotel Rates of User Groups2USERGGrouping: Travel Planning Control Variantnvarchar20
15TA20BPRProvider-Specific Reservation Systems2USERGGrouping for Sales Office Determinationnvarchar20
16TA20CEnterprise-Specific Travel Service Categories2USERGGrouping for Sales Office Determinationnvarchar20
17TA20C1Enterprise-Spec. Travel Service Categories (Language-Dep.)3USERGGrouping for Sales Office Determinationnvarchar20
18TA20DBAccess Parameters for Deutsche Bahn via API2USERGGrouping for Sales Office Determinationnvarchar20
19TA20FINALMESSAGEStrategic Settings for Travel Planning3USERGGrouping: Travel Planning Control Variantnvarchar20
20TA20HHMaximum Rates for Hotel Stay2USERGGrouping: Travel Planning Control Variantnvarchar20
21TA20HH1Maximum Rates for Hotel Stay3USERGGrouping: Travel Planning Control Variantnvarchar20
22TA20KReasons4USERGGrouping: Travel Planning Control Variantnvarchar20
23TA20K1Reasons (Language-Dependent)5USERGGrouping: Travel Planning Control Variantnvarchar20
24TA20LTCurrent Settings for Travel Planning Control Variants2USERGGrouping: Travel Planning Control Variantnvarchar20
25TA20LT1Current Settings for Control Variant (Language-Dependent)3USERGGrouping: Travel Planning Control Variantnvarchar20
26TA20PPZMessage handling: chosen priority with top priority2USERGGrouping: Travel Planning Control Variantnvarchar20
27TA20PPZ1Message handling (language-dependent)3USERGGrouping: Travel Planning Control Variantnvarchar20
28TA20WIZARDStrategic Settings for Travel Planning3USERGGrouping: Travel Planning Control Variantnvarchar20
29TA20WWWWWW Link Catalog for Information Sources2USERGGrouping: Travel Planning Control Variantnvarchar20
30TA20WWW1WWW LInk Catalog for Information Sources (Language-Depend.)3USERGGrouping: Travel Planning Control Variantnvarchar20
31TA23CEnterprise-Specific F4 Help for IATA Locations2USERGGrouping for Sales Office Determinationnvarchar20