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

35 columns | Print definition?ERP 6.0  | FDNAM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TCOBKCoding Block: Components per Field1FDNAMCoding block field namenvarchar300
2TCOBMCoding Block: Modification Numbers1FDNAMCoding block field namenvarchar300
3TFAVFI: Worklists5FDNAMField Namenvarchar300
4TKB2CDefault Rules for Posting Rules7FDNAMField containing the default valuenvarchar240
5TKB3Settings for Default Rules6FDNAMField containing the default valuenvarchar240
TOPAccount Determination
6T180AReporting: Access Types according to Field2FDNAMField Namenvarchar300
TOPBasic Data
7TNCF0IS-HCM Message Fields3FDNAMIS-HCM: Segment Field Namenvarchar100
8TNCF1IS-HCM Message Fields - Texts4FDNAMIS-HCM: Segment Field Namenvarchar100
9TNCS2IS-HCM Message Segment - Field Assignment6FDNAMIS-HCM: Segment Field Namenvarchar100
TOPBasic Functions
10TVBSTSD Documents: Processing Status: Texts4FDNAMField name of the status tablenvarchar300
11TVGRPFGroup Referencing Requirement: Fields4FDNAMDocument field namenvarchar300
12TVUVFIncompletion Control: Fields4FDNAMDocument field namenvarchar300
TOPCoding Block
13TCOBALECoding Block: Replicated Fields2FDNAMCoding block field namenvarchar300
14TCOBCCoding Block: Customer Subscreens (Fields)3FDNAMCoding block field namenvarchar300
15TCOBFIELDSCoding Block: Field Characteristics1FDNAMCoding block field namenvarchar300
16TCOBNCoding Block: Customer Fields1FDNAMCoding block field namenvarchar300
TOPCollectionsDisbursements
17TKKVBLERMConversion Table Data Medium Item in Doc Type6FDNAMData Field Namenvarchar100
18TKKVDTSTRControl Table DME File Processing Austria6FDNAMData Field Namenvarchar100
19TKKVVKKMModif. No. for Invoice Fields2FDNAMDB field namenvarchar300
20TKKVVKKMTText Table for Modif. No. for Invoice Fields3FDNAMDB field namenvarchar300
TOPContract Accounts Receivable and Payable
21TFK090DOBSOLETE - Mass Activity - Modification Nos for Field Sel.2FDNAMDB field namenvarchar300
TOPCross-Application Components
22VVBUVSales Document: Incompletion Log8FDNAMDocument field namenvarchar300
TOPFinancial Accounting
23ICRCAICRC: Items to be Reconciled20FDNAMICRC: Name of Field Used for Reconciliationnvarchar300
24ICRCUICRC: Potentially Differing Document Groups20FDNAMICRC: Name of Field Used for Reconciliationnvarchar300
25ICRCZICRC: Reconciled, Completed Items20FDNAMICRC: Name of Field Used for Reconciliationnvarchar300
26TFAVAFI: Details of Automatically Generated Worklists4FDNAMField Namenvarchar300
27TICRC2Selection of Recon. Criteria for Recon. Affiliated Companies2FDNAMICRC: Name of Field Used for Reconciliationnvarchar300
TOPGlobal Trade Services
28/SAPSLL/TLEMOFGTS: Definition of Field Names for BOM Cost Estimate2FDNAMName of (External) Fieldnvarchar300
29/SAPSLL/TLEMOFTGTS: Definition of Field Names BOM Cost Estimate - Descriptn3FDNAMName of (External) Fieldnvarchar300
30/SAPSLL/TLEMOHGTS: Definition of Hierarchy Levels BOM Cost Estimate4FDNAMName of (External) Fieldnvarchar300
TOPJapan
31T7JPLV_RECDSTRUDefine Record Structure7FDNAMField Namenvarchar200
TOPMaster Data
32T440AChange fields for MRP3FDNAMDB field namenvarchar300
TOPSales
33VBUVSales Document: Incompletion Log8FDNAMDocument field namenvarchar300
TOPSales and Distribution SD enhancements
34MILL_VS_FIELDSVersion Management: Fields3FDNAMDocument field namenvarchar300
TOPShipping
35TVSLTDeliveries: Texts Processing Status3FDNAMField name of the status tablenvarchar300