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
9OVTG52Tax Definition
10OPOR386Purchase Order

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

32 columns | Print definition?ERP 6.0  | GRPNO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1RVTXOBJSD Text Determination: Allowed Text Objects3GRPNONumber of the routine used for copyingnvarchar30
2TFRMForm Routines for Requirements/Formulas/Data Transports2GRPNONumber of the routine used for copyingnvarchar30
3TFRMTFORM Routines for Reqs./Formulae/Data Transports: Texts3GRPNONumber of the routine used for copyingnvarchar30
4TVARASales Document Archiving Control5GRPNONumber of the routine used for copyingnvarchar30
5TVARKArchiving Control for Sales Activities in Sales Support5GRPNONumber of the routine used for copyingnvarchar30
6TVARRArchiving Control for Billing6GRPNONumber of the routine used for copyingnvarchar30
7TVCPTSales docs: Texts for modules from TVCPA,TVCPF,TVCPL,TTXVR4GRPNONumber of the routine used for copyingnvarchar30
8TVFOSubsequent Functions and Requirements4GRPNONumber of the routine used for copyingnvarchar30
9VFPRCC_UERATTR_CRelevant attributes of pricing user exits (Customer)3GRPNONumber of the routine used for copyingnvarchar30
10VFPRCC_UERATTR_SRelevant attributes of pricing user exits (SAP delivery)3GRPNONumber of the routine used for copyingnvarchar30
11VFPRCC_UE_META_CMeta Data of Pricing User Exits3GRPNONumber of the routine used for copyingnvarchar30
12VFPRCC_UE_META_SMeta Data of Pricing User Exits3GRPNONumber of the routine used for copyingnvarchar30
TOPAccount Determination
13TVARLArchiving Control for Delivery5GRPNONumber of the routine used for copyingnvarchar30
TOPBank Accounting
14DFPAYGPayment date: Grouping5GRPNOGrouping Criterium for Paymentsint100
15REGUTTemSe - Administration Data28GRPNOGrouping Criterium for Paymentsint100
TOPBasic Functions
16KNVHCustomer Hierarchies13GRPNONumber of the routine used for copyingnvarchar30
17T182AAllocate Reporting Edit Routines to SAPscript Elements2GRPNONumber of the routine used for copyingnvarchar30
18T182BStructure of Info View in SD Reporting6GRPNONumber of the routine used for copyingnvarchar30
19T606LLegal Control: Country Classification by Destination Ctry6GRPNONumber of the routine used for copyingnvarchar30
20T606MLegal Control: Product Classification by Destinat. Ctry8GRPNONumber of the routine used for copyingnvarchar30
21T606NLegal Control: Product Classification by Country Grouping8GRPNONumber of the routine used for copyingnvarchar30
22T610FAImport Processing: Anti-dumping Code Determination10GRPNONumber of the routine used for copyingnvarchar30
23T610FKImport Processing: Customs Quota Code Determination11GRPNONumber of the routine used for copyingnvarchar30
TOPContract Accounts Receivable and Payable
24DPAYGPayment program - payment group5GRPNOGrouping criterium for paymentsint100
25DPAYHPayment program - data for payment8GRPNOGrouping criterium for paymentsint100
TOPCredit Management
26T691FControl of Automatic Credit Control72GRPNONumber of the routine used for copyingnvarchar30
27T691OControl for payment guarantee procedure5GRPNONumber of the routine used for copyingnvarchar30
TOPData Collection
28TMC2WAdditional Information and Warnings for Source Fields9GRPNONumber of the routine used for copyingnvarchar30
TOPFinancial Supply Chain Management
29BNK_BATCH_ITEMBatch Payment Items10GRPNOGrouping Criterium for Paymentsint100
TOPPayment Transactions
30REGUHSettlement data from payment program157GRPNOGrouping Criterium for Paymentsint100
TOPSales Plan
31T445MMacro Definitions: LIS Planning14GRPNONumber of the routine used for copyingnvarchar30
TOPVendor Master
32LFMHVendor hierarchy9GRPNONumber of the routine used for copyingnvarchar30