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

58 columns | Print definition?ERP 6.0  | ENTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T7IEBMapping table for Enterprise and ERn numbers2ENTNREnterprise numbernvarchar100
2T7NOEDG_BF_GRANTEDAG - Granted Bunnfradrag amount per year2ENTNREDAG - Enterprise Nr.nvarchar110
3T7NOEDG_PRD02EDAG - IRED storage (actual version)4ENTNREDAG - Enterprise Nr.nvarchar110
4T7NOEDG_PRD03EDAG - IRED storage (versions)4ENTNREDAG - Enterprise Nr.nvarchar110
5T7NOEDG_PRD04EDAG - SMBS links to IRED storage5ENTNREDAG - Enterprise Nr.nvarchar110
6T7NOEDG_PRD05EDAG - ACF links3ENTNREDAG - Enterprise Nr.nvarchar110
7T7NOEDG_PRD06EDAG - Receptions3ENTNREDAG - Enterprise Nr.nvarchar110
8T7NOEDG_PRD07EDAG - Last submission info3ENTNREDAG - Enterprise Nr.nvarchar110
9T7NOEDG_TEST01EDAG[TEST] - ACF test table 14ENTNREDAG - Enterprise Nr.nvarchar110
10T7NOEDG_TEST02EDAG[TEST] - IRED storage (actual version)4ENTNREDAG - Enterprise Nr.nvarchar110
11T7NOEDG_TEST03EDAG[TEST] - IRED storage (versions)4ENTNREDAG - Enterprise Nr.nvarchar110
12T7NOEDG_TEST04EDAG[TEST] - SMBS links to IRED storage5ENTNREDAG - Enterprise Nr.nvarchar110
13T7NOEDG_TEST05EDAG[TEST] - ACF links3ENTNREDAG - Enterprise Nr.nvarchar110
14T7NOEDG_TEST06EDAG[TEST] - Receptions3ENTNREDAG - Enterprise Nr.nvarchar110
15T7NOEDG_TEST07EDAG[TEST] - Last submission info3ENTNREDAG - Enterprise Nr.nvarchar110
TOPRecycling Administration Core Functions
16J_7LBDCMSGREA Conditions: Error Messages BDC Condition Adjustment12ENTNRRecycling Partnernvarchar100
17J_7LE01REA Partner Master Record: General Data (Country-Dependent)2ENTNRRecycling Partnernvarchar100
18J_7LE02REA Partner Master Record: Company Code2ENTNRRecycling Partnernvarchar100
19J_7LE04REA Partner Master Record: Volume/Area Classes2ENTNRRecycling Partnernvarchar100
20J_7LE04TREA Partner Master Record: Volume/Area Classes Short Texts2ENTNRRecycling Partnernvarchar100
21J_7LE05REA Partner Master Record: Packaging Types2ENTNRRecycling Partnernvarchar100
22J_7LE06REA Partner Master Record: Additional Information Key2ENTNRRecycling Partnernvarchar100
23J_7LE06TREA Partner Master Record: Additional Info., Short Text2ENTNRRecycling Partnernvarchar100
24J_7LE07REA Partner Master Record: Content Identification Key2ENTNRRecycling Partnernvarchar100
25J_7LE07TREA Partner Master Record: Content Ident.Key, Short Text2ENTNRRecycling Partnernvarchar100
26J_7LE08REA Partner Master Record: Month-Quarter Assignment2ENTNRRecycling Partnernvarchar100
27J_7LE09REA Partner Master: Document Types2ENTNRRecycling Partnernvarchar100
28J_7LE09TREA Partner Master: Document Types Short Text2ENTNRRecycling Partnernvarchar100
29J_7LE10REA Partner Master: Document Types Periodicity2ENTNRRecycling Partnernvarchar100
30J_7LE11REA Partner Master: Selection Groups for Consecutive Docs2ENTNRRecycling Partnernvarchar100
31J_7LE11TREA Partner Master: Selection Grps for Consec.Docs Short Txt2ENTNRRecycling Partnernvarchar100
32J_7LE12REA Partner Master: Consecutive Doc.-to-Selection Grp Asgmt2ENTNRRecycling Partnernvarchar100
33J_7LE13REA Partner Master: Trade Levels2ENTNRRecycling Partnernvarchar100
34J_7LE13TREA Partner Master: Trade Levels - Short Text2ENTNRRecycling Partnernvarchar100
35J_7LE14REA Partner Master: Trade Level Proportion (price list vers)2ENTNRRecycling Partnernvarchar100
36J_7LE15REA Partner Master: Formulas for Fee Calculation2ENTNRRecycling Partnernvarchar100
37J_7LE15TREA Partner Master Record: Formulas - Short Texts2ENTNRRecycling Partnernvarchar100
38J_7LE16REA Partner Master Record: Packaging Category - Fraction2ENTNRRecycling Partnernvarchar100
39J_7LE16TREA Partner Master Rec.: Packag. Ctgry Fraction, Short Text2ENTNRRecycling Partnernvarchar100
40J_7LE17REA Partner Master: Price Formulas2ENTNRRecycling Partnernvarchar100
41J_7LE17TREA Partner Master: Formulas Short Text2ENTNRRecycling Partnernvarchar100
42J_7LM05REA Article Master: Recycling Partner Assignment7ENTNRRecycling Partnernvarchar100
43J_7LM09REA Article Master: R.Partner-Depend.Data Assign.Packaging8ENTNRRecycling Partnernvarchar100
44J_7LM10REA Article Master: Filters for Regional Processing7ENTNRRecycling Partnernvarchar100
45J_7LM11REA Article Master: Declaration Key6ENTNRRecycling Partnernvarchar100
46J_7LMS01REA Declaration System Lock Table2ENTNRRecycling Partnernvarchar100
47J_7LP01REA Price List: Versions2ENTNRRecycling Partnernvarchar100
48J_7LP02REA Price List: Items2ENTNRRecycling Partnernvarchar100
49J_7LP03REA Price List: Conditions2ENTNRRecycling Partnernvarchar100
50J_7LS02REA Fractions: Partner Fractions3ENTNRRecycling Partnernvarchar100
51J_7LS02TREA Partner Fractions: Short Text3ENTNRRecycling Partnernvarchar100
52J_7LV03REA Packaging Master Data: Recycling Partner Assignment4ENTNRRecycling Partnernvarchar100
53J_7LV07REA Packaging Groups: Recycling Partner-Dep. Packaging Data5ENTNRRecycling Partnernvarchar100
54J_7LV08REA Packag. Mast. Data: Re.Partner-Dep. Data Asgmt Fraction5ENTNRRecycling Partnernvarchar100
55J_7LV1KREA Document: Header Data42ENTNRRecycling Partnernvarchar100
TOPTime Data Recording and Administration
56TMW_TDTYPETime Data ID4ENTNREntry Numbernvarchar50
57TMW_TD_SUBLASubset5ENTNREntry Numbernvarchar50
TOPUse Subcomponents
58SADRX5X.500 Directory Entries10ENTNRAddresses: Sequence numbernvarchar30