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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

27 columns | Print definition?ERP 6.0  | POART

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TJKBC01IS-M/SD: Undesirable Orders, Control Data6POARTInternal Item Type for Sales Ordernvarchar20
2TJKBC02IS-M/SD: Undesirable Orders, Filter Data6POARTInternal Item Type for Sales Ordernvarchar20
TOPPeriodical Sales and Distribution
3A454IS-M/SD: Sales Promotion Discount7POARTInternal Item Type for Sales Ordernvarchar20
4JFXBPOSDLIS-M: Backup Transfer Internal Table XBPOS25POARTIS-M: Item type for transfer to FI/RFnvarchar10
5JKAPSales Order - Item Data6POARTInternal Item Type for Sales Ordernvarchar20
6JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data3POARTInternal Item Type for Sales Ordernvarchar20
7JKWWWTEMP_ORDERIS-M/SD: WWW Temporary Table for Order Data from Internet11POARTInternal Item Type for Sales Ordernvarchar20
8JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data3POARTInternal Item Type for Sales Ordernvarchar20
9JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet51POARTInternal Item Type for Sales Ordernvarchar20
10JKWWWTEMP_SUSPIS-M: Temporary Internet Table: Suspension Data3POARTInternal Item Type for Sales Ordernvarchar20
11JKWWWTEMP_TRNSFIS-M: Internet Temporary Table: Transfer Data3POARTInternal Item Type for Sales Ordernvarchar20
12JLRPIS-M/SD: Item Data for Settlement135POARTInternal Item Type for Sales Ordernvarchar20
13JVTNCT4IS-M/SD: Tab.4 for Netchange (ChNo.Planng View)-see JKVDIS37POARTInternal Item Type for Sales Ordernvarchar20
14JVTZAEM1IS-M/SD: Carrier Change Notification - Order Change21POARTInternal Item Type for Sales Ordernvarchar20
15JYTREORGIS-M/SD: Reorganization Periods and Areas8POARTInternal Item Type for Sales Ordernvarchar20
16JYTSTREORGIS-M/SD: Reorganization Status8POARTInternal Item Type for Sales Ordernvarchar20
17TJAPSales Order: Item Types2POARTInternal Item Type for Sales Ordernvarchar20
18TJAPTSales Order: Texts for Item Types3POARTInternal Item Type for Sales Ordernvarchar20
19TJAPZIS-M/SD: Item Type-Sales Document Type Assignment3POARTInternal Item Type for Sales Ordernvarchar20
20TJCPFIS-M/SD: Billing - Copying Control5POARTInternal Item Type for Sales Ordernvarchar20
21TJEPZIS-M/SD: Sales Doc.Type-Item Type-Schedule Line Type Assgmt3POARTInternal Item Type for Sales Ordernvarchar20
22TJI05IS-M/SD: Basic Audit Report Category Default: Periodical SD3POARTInternal Item Type for Sales Ordernvarchar20
23TJKFProcessing Functions for Sales Order5POARTInternal Item Type for Sales Ordernvarchar20
24TJKWWIS-M/SD: Control Table for Creating Trial Subscriptions5POARTInternal Item Type for Sales Ordernvarchar20
25TJKWWW_FIXIS-M/SD: WWW, Combinations of Fixed Order Values11POARTInternal Item Type for Sales Ordernvarchar20
26TJKWWW_VACATIONIS-M/SD: WWW, Vacation Service, Preassignments4POARTItem Type in Sales Order for WWWnvarchar20
TOPSAP Media
27J_1SWEMF04IS-M/SD CH/W: Special Category Determination for WEMF3POARTInternal Item Type for Sales Ordernvarchar20