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

41 columns | Print definition?ERP 6.0  | TBNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T130CDefinition of required tables2TBNAMTable Namenvarchar300
2T130GSelection group and its tables3TBNAMTable namenvarchar300
3T130PStatus and table3TBNAMTable namenvarchar300
4T131AChange code, selection group, and material master table4TBNAMTable namenvarchar300
5T731Key Figures in Info Library (Transport Table)5TBNAMTable Namenvarchar300
6T731NInfo Sets in LIL (Transport Table)5TBNAMTable Namenvarchar300
7TFAVFI: Worklists4TBNAMTable Namenvarchar300
TOPAccount Determination
8T180AReporting: Access Types according to Field1TBNAMTable Namenvarchar300
TOPApplication System
9/SAPTRX/ASITEMIDItem Identifier Refernce Table6TBNAMTable Name for Date/Time Fieldnvarchar160
TOPBasic Functions
10T859Data entry forms11TBNAMTable name for input of FI-LC financial reporting datanvarchar40
11TVBSTSD Documents: Processing Status: Texts3TBNAMStatus table namenvarchar300
12TVGRPFGroup Referencing Requirement: Fields3TBNAMGroup referencing requirement: tablesnvarchar300
13TVUVFIncompletion Control: Fields3TBNAMTable for documents in sales and distributionnvarchar300
TOPCross-Application Components
14VVBUVSales Document: Incompletion Log7TBNAMTable for documents in sales and distributionnvarchar300
TOPDay-to-Day Activities
15LSOCRPTXTVARText Variables5TBNAMStructure name of a text variablenvarchar300
TOPFinancial Accounting
16TFAVAFI: Details of Automatically Generated Worklists3TBNAMTable Namenvarchar300
TOPLogistics Information Library
17MCLIKey Figures in Information Library5TBNAMTable Namenvarchar300
18MCLINInfo Sets in LIL5TBNAMTable Namenvarchar300
TOPMaster Data
19T440AChange fields for MRP2TBNAMTable Namenvarchar300
TOPMaterial Master
20MGVDYNPRODBAssignment table different NameScreenField - DatabaseField3TBNAMTable Namenvarchar300
21MGVFIELDBUNDLETable of field packages2TBNAMTable Namenvarchar300
22MGVFIELDGROUPFLDFields/field packages that cannot be versionned2TBNAMTable Namenvarchar300
23MGVFIELDSALLOWEDVersions of allowed fields/field packages2TBNAMTable Namenvarchar300
24MGVTYPEFIELDTable of field without a version3TBNAMTable Namenvarchar300
25MGVTYPEFIELDWORKTable of field without a version3TBNAMTable Namenvarchar300
26MGVTYPEFIELD_WRKTable of field without a version3TBNAMTable Namenvarchar300
27MVD_CUSTSAP Customizing Data: Material Versions Overview Screen3TBNAMTablenvarchar300
28MVD_CUST_SAPSAP Customizing Data: Material Versions Overview Screen3TBNAMTablenvarchar300
29T130QReduced status and its tables3TBNAMTable namenvarchar300
30T130RTable and key field3TBNAMTable namenvarchar300
31T133PRetail: Status and Table3TBNAMTable namenvarchar300
32T133RRetail: Table and Key Field3TBNAMTable namenvarchar300
33T148KLower stock balance indicator for individual segments6TBNAMTable namenvarchar300
34TMGW5Fields from reference prepack, not from generic material2TBNAMTable Namenvarchar300
TOPPersonnel Administration
35T588VBusiness Object Type Determination1TBNAMTable for personal informationnvarchar300
36T588WEvent types for infotype operations1TBNAMTable for personal informationnvarchar300
37T588XCust. composite definition of event types for IT operations1TBNAMTable for personal informationnvarchar300
TOPSales
38VBUVSales Document: Incompletion Log7TBNAMTable for documents in sales and distributionnvarchar300
TOPSales and Distribution SD enhancements
39MILL_VS_FIELDSVersion Management: Fields2TBNAMTable for documents in sales and distributionnvarchar300
TOPShipping
40TVSLTDeliveries: Texts Processing Status2TBNAMStatus table namenvarchar300
TOPTraining and Event Management
41T77VCText Variable Editing2TBNAMStructure name of a text variablenvarchar300