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

50 columns | Print definition?ERP 6.0  | GRUPP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003DSID-Tabelle fuer Planning group3GRUPPPlanning Groupnvarchar100
2/SMD/MD_____00CYSID-Tabelle fuer Planning group3GRUPPPlanning Groupnvarchar100
3/SMD/MD_____010RSID-Tabelle fuer Planning group3GRUPPPlanning Groupnvarchar100
4CNVCMIS_M_VMVLDCMIS: Generated Pooltable for Matchcode ID VMVL -D8GRUPPCustomer Credit Groupnvarchar40
5FUCNBUSTRANAssign Document Type to Entry Layout3GRUPPEntry Viewtinyint30
6T021QFast Entry Line Layout: Control7GRUPPFast Entry: Grouping of Fieldsnvarchar10
7T030ATransaction Keys and Assignment to Groups2GRUPPGroup with an Account Keynvarchar30
8T030XGroups of Transaction Keys1GRUPPGroup with an Account Keynvarchar30
9T030YTransaction Group Names2GRUPPGroup with an Account Keynvarchar30
10T036QAllocating Levels for T03604GRUPPPlanning Groupnvarchar100
11T055GField groups (master data)3GRUPPField groupnvarchar20
12T055TField group names4GRUPPField groupnvarchar20
13T064SStock Mngmt Levels for Inventory Sampling9GRUPPGroup used to combine stock management levelsnvarchar20
14T243BConvert Sender Planning Group4GRUPPPlanning Groupnvarchar100
15T691B"Credit Management Groups"2GRUPPCustomer Credit Groupnvarchar40
16T691CCredit management group names3GRUPPCustomer Credit Groupnvarchar40
17ZEIM_VBAKSales Document: Header Data64GRUPPCustomer Credit Groupnvarchar40
TOPAdvertising Management
18JHAKIS-M/AM: Order-Publishing-Media (Header Data)26GRUPPCustomer Credit Groupnvarchar40
TOPAutomatic Payments
19FDZACash Management line items in payment requests10GRUPPPlanning Groupnvarchar100
TOPBank
20T055Field group fields (master data)3GRUPPField groupnvarchar20
TOPBank Components
21JBKLOBJ1Segment Table for Financial Transactions, CL Part22GRUPPCredit Limit Part: General Ledger Accountnvarchar100
TOPBasic Data
22TNP00IS-H: Controlling the Customizing of Parameter Tables5GRUPPIS-H: Grouping of system parametersnvarchar50
TOPBasic Functions
23FDAUCash Managment Advice Authorization Catalog5GRUPPPlanning Groupnvarchar100
24FDESCash Management and Forecast: Memo Records5GRUPPPlanning Groupnvarchar100
25FDESDISTCash management memo records (distributed)6GRUPPPlanning Groupnvarchar100
26FDSRCMF summary records for planning groups3GRUPPPlanning Groupnvarchar100
27FDSR2CMF Totals Records for Planning Groups (As of Release 604)5GRUPPPlanning Groupnvarchar100
28FDSRDISTCash management totals records for planning groups (distbd)4GRUPPPlanning Groupnvarchar100
29KNKKCustomer master credit management: Control area data24GRUPPCustomer Credit Groupnvarchar40
30T035Planning groups2GRUPPPlanning Groupnvarchar100
31T035TPlanning Group Texts3GRUPPPlanning Groupnvarchar100
32T035ZLiquidity Forecast: Payment Date Determinations/Assignments2GRUPPPlanning Group (masking possible)nvarchar100
33T036M2Earmarked Funds: Group Assignment If Account Missing3GRUPPPlanning Groupnvarchar100
TOPContract Accounts Receivable and Payable
34TFK055Fields of Field Groups for Document Change2GRUPPField Groupnvarchar20
35TFK055GField Groups for Document Changes2GRUPPField Groupnvarchar20
36TFK055TField Groups for Document Change (Description)3GRUPPField Groupnvarchar20
TOPCross-Application Components
37VVBAKSales Document: Header Data64GRUPPCustomer Credit Groupnvarchar40
TOPLogistics - General
38WBHKTrading Contract: Header Data75GRUPPCustomer Credit Groupnvarchar40
TOPPatient Management
39TNR01IS-H: Report Control: Group - Application Asgmt.3GRUPPIS-H: Report Control: Report Groupnvarchar20
40TNR01TIS-H: Report Control: Texts for Groups3GRUPPIS-H: Report Control: Report Groupnvarchar20
41TNR02IS-H: Report Control: Report - Group Asgmt2GRUPPIS-H: Report Control: Report Groupnvarchar20
TOPRemaining Beverage - Obsolete Objects
42/BEV1/RBVBAKSales Document: Header Data64GRUPPCustomer Credit Groupnvarchar40
TOPRisk Analysis
43JBRDBKORM: DB Table Header Information Extended Risk Object16GRUPPCredit Limit Part: General Ledger Accountnvarchar100
44JBRHKORM: Version Table: Header Information: Extended Risk Object17GRUPPCredit Limit Part: General Ledger Accountnvarchar100
45JBRSVKORM: Header Table of SDTFT for Saved Datasets11GRUPPCredit Limit Part: General Ledger Accountnvarchar100
TOPSales
46VAKCRSales Index: Orders in Credit Management8GRUPPCustomer Credit Groupnvarchar40
47VBAKSales Document: Header Data64GRUPPCustomer Credit Groupnvarchar40
TOPShipping
48LIKPSD Document: Delivery Header Data75GRUPPCustomer Credit Groupnvarchar40
49SHP_IDX_CREDOutbound Deliveries in Credit Check: Blocked and Released9GRUPPCustomer Credit Groupnvarchar40
TOPSimulation
50VSVBAK_CNVersion: Sales document: Header data65GRUPPCustomer Credit Groupnvarchar40