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

39 columns | Print definition?ERP 6.0  | COMPLETE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/MPQQMap Weightages to PQQ5COMPLETECheckboxnvarchar10
2FMSAVE_RETSave Retention Period for Archived Document14COMPLETESingle-Character Indicatornvarchar10
3TDM19Specialization category4COMPLETEFlag: Completeness of specializationnvarchar10
TOPAdvanced Returns Management
4MSR_D_HEADAdvanced Returns Management - Tracking Header Data3COMPLETECompletednvarchar10
TOPBRFplus - ABAP-Based Business Rules
5FDT_EXPR_1900FDT/BRF: Expression - Value request (structure and tables)7COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
6FDT_EXPR_1900AFDT/BRF: Expression - Value request (structure and tables)7COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
7FDT_EXPR_1900SFDT/BRF: Expression - Value request (structure and tables)6COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
8FDT_EXPR_1900TFDT/BRF: Expression - Value request (structure and tables)6COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPBusiness Analytics
9UAB_FIELD_CALMemorize Fields of PDCE Join which Kind of Costing10COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPBusiness Rule Framework
10FDT_EXPR_1950FDT/BRF: Expression - Value request (structure and tables)7COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
11FDT_EXPR_1950AFDT/BRF: Expression - Value request (structure and tables)7COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
12FDT_EXPR_1950SFDT/BRF: Expression - Value request (structure and tables)6COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
13FDT_EXPR_1950TFDT/BRF: Expression - Value request (structure and tables)6COMPLETEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPContract Accounts Receivable and Payable
14DFKKSUMCControl details for posting totals25COMPLETEStatus Of Detail Structures For Reconciliation Keynvarchar10
TOPData Modeler
15DM45LDM Specialization Category6COMPLETEFlag: Completeness of specializationnvarchar10
16TDM21Entity Specialization Category6COMPLETEFlag: Completeness of specializationnvarchar10
TOPDocumentation Tools
17TLSYSLanguage Versions in the System5COMPLETENew Input Valuesnvarchar10
TOPFlexible Real Estate Management
18TIVCAPROCREPReport on Process4COMPLETEAs of Which Step Are the Values of the Report Completenvarchar40
19TIVSCISREPORTSOBSOLETE3COMPLETEOBSOLETE:As of which step are the values of the report complnvarchar40
TOPHierarchy Storage
20TTREEIList of Active Nodes for a Structure3COMPLETECheckboxnvarchar10
21TTREVIList of Active Nodes for a Structure4COMPLETECheckboxnvarchar10
TOPLanguage Transport
22TLANSUPTALanguage Transport: Tables to Be Supplemented4COMPLETEBoolean Variable (X=True, -=False, Space=Unknown)nvarchar10
TOPLogistics - General
23WBHITrading Contract: Item Data102COMPLETETrading Contract: Item Is Completednvarchar10
24WBHKTrading Contract: Header Data34COMPLETETrading Contract: Document is Completenvarchar10
TOPNon Profit Organizations
25T7UNCMT_LOADSCMT Deliveries Loads Executed9COMPLETECheckboxnvarchar10
TOPOccupational Health
26T7EHS00_RESQUESTTable for Questions Answered13COMPLETEQuestion Answered with 'Yes'nvarchar10
TOPPackage Tools
27BCUSEDMIGRControl Table for Migrationrep. BCUSED_TO_DEFAULT_INTERFACEd7COMPLETEGeneral Flagnvarchar10
TOPPosition Management
28WBITAssociation Item at Step Level31COMPLETEGlobal Trade: Item Closednvarchar10
TOPProduct Structure Browser
29FILTERGeneral and Private Filters5COMPLETEFilter is completenvarchar40
TOPProgress Tracking
30TSTNTExpediting Status Information18COMPLETECompletion Ind. for Status Information in Progress Trackingnvarchar10
TOPService Data Download
31/BDL/HEADNachbau: DSVAS: Session data (header)10COMPLETEnvarchar10
32BDLHEADNachbau: DSVAS: Session data (header)10COMPLETEnvarchar10
33BDLSESSIONHEADNachbau: DSVAS: Session data (header)10COMPLETEnvarchar10
TOPStructure
34DPR_TSK_TYPETask Type5COMPLETEAllow Completion of Tasks Even If Subtasks Were Cancelednvarchar10
TOPTrading Contract
35WBGTGlobal Trade: Generic Document Information17COMPLETEGlobal Trade: Item Closednvarchar10
TOPTraining Management
36HRP5045DB Table for Infotype 504523COMPLETEAction for Participationnvarchar10
37HRP5046DB Table for Infotype 504627COMPLETEAction for Participationnvarchar10
TOPWeb Service and SOAP - ABAP
38SRT_MONILOG_DATASOAP Runtime Table for Monitoring and Log Data Records7COMPLETEnvarchar20
39SRT_MONLOG_DATA2SOAP Runtime Table for Monitoring and Log Data Records7COMPLETEnvarchar20