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

57 columns | Print definition?ERP 6.0  | GPNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPAdvertising Management
1JHAGPZIS-M/AM: Assign Business Partner to Order and Item5GPNRIS-M: Business Partner Keynvarchar100
2JHA_ORDER_INDEXSelection Index for Orders2GPNRIS-M: Business Partner Keynvarchar100
3JHTFPAIS-M/AM: Settlement/Billing Document Item: Partner5GPNRIS-M: Business Partner Keynvarchar100
4JHTMGPZIS-M: Media-Mix Contract: Business Partner4GPNRIS-M/AM: Assigned Business Partner in the Contractnvarchar100
5JHTVGPZIS-M/AM: Business Partner Assignment to the Contract5GPNRIS-M/AM: Assigned Business Partner in the Contractnvarchar100
6JJTALIS-M/AM: Business Partner Alias2GPNRIS-M: Business Partner Keynvarchar100
7JJTAMIS-M/AM: Media Contact Person2GPNRIS-M: Business Partner Keynvarchar100
8JJTGPBTBRIS-M/AM: Customer Potential: Industry Sector - BP3GPNRIS-M: Business Partner Keynvarchar100
9JJTGPBTBZIS-M/AM: Customer Potential: Zone - BP3GPNRIS-M: Business Partner Keynvarchar100
10JJTGPBTF1IS-M/AM: Customer Potential: Free Attribute 1 - BP3GPNRIS-M: Business Partner Keynvarchar100
11JJTGPBTF2IS-M/AM: Customer Potential: Free Attribute 2 - BP3GPNRIS-M: Business Partner Keynvarchar100
12JJTGPBTF3IS-M/AM: Customer Potential: Free Attribute 3 - BP3GPNRIS-M: Business Partner Keynvarchar100
13JJTGPBTF4IS-M/AM: Customer Potential: Free Attribute 4 - BP3GPNRIS-M: Business Partner Keynvarchar100
14JJTGPBTF5IS-M/AM: Customer Potential: Free Attribute 5 - BP3GPNRIS-M: Business Partner Keynvarchar100
15JJTGPBTF6IS-M/AM: Customer Potential: Free Attribute 6 - BP3GPNRIS-M: Business Partner Keynvarchar100
16JJTGPBTF7IS-M/AM: Customer Potential: Free Attribute 7 - BP3GPNRIS-M: Business Partner Keynvarchar100
17JJTPHIS-M/AM: BP Product Hierarchy Assignment2GPNRIS-M: Business Partner Keynvarchar100
TOPMaster Data
18JGTADAVIS-M/SD: Worklist of Address Changes2GPNRIS-M: Business Partner Keynvarchar100
19JGTADRAIS-M: Business Partner-Address Assignment (Time-Dependent)2GPNRIS-M: Business Partner Keynvarchar100
20JGTADRGIS-M: Business Partner Assignment2GPNRIS-M: Business Partner Keynvarchar100
21JGTAKTFSYSIS-M: Buffer Table for Activities in Non-SAP Systems (BP)3GPNRIS-M: Business Partner Keynvarchar100
22JGTBKEZIS-M: Additional Data on Collection Authorization for Banks2GPNRIS-M: Business Partner Keynvarchar100
23JGTBKVWIS-M: Note to Payee for Banks2GPNRIS-M: Business Partner Keynvarchar100
24JGTGPNRIS-M: Central Business Partner Table2GPNRIS-M: Business Partner Keynvarchar100
25JGTKNBKFSYIS-M: Index for Synchronization of Cust.Bank with Th.-Pty FI3GPNRIS-M: Business Partner Keynvarchar100
26JGTLFBKFSYIS-M: Index for Synchronization of Vendor Bank w/Th.-Pty FI3GPNRIS-M: Business Partner Keynvarchar100
27JGTLFM1IS-M/SD: Business Partner Purchasing Organization2GPNRIS-M: Business Partner Keynvarchar100
28JGTZUAUSIS-M/SD: Lost Time for Carriers3GPNRIS-M: Business Partner Keynvarchar100
29RJGTEXTORDIS-M/AM: Transfer Business Partner from Technical System2GPNRIS-M: Business Partner Keynvarchar100
TOPPeriodical Sales and Distribution
30A458IS-M/SD: Employee Renewal Commission5GPNRIS-M: Business Partner Keynvarchar100
31A459IS-M/SD: Employee Up-Front Commission5GPNRIS-M: Business Partner Keynvarchar100
32A461IS-M/SD: Employee Bonus for Sales Promotion5GPNRIS-M: Business Partner Keynvarchar100
33A470IS-M/SD: Deliverer Settlement - Normal Items5GPNRIS-M: Business Partner Keynvarchar100
34A483IS-M/SD: Payment Method for Employee Bonus for Up-Front Com.5GPNRIS-M: Business Partner Keynvarchar100
35A484IS-M/SD: Employee Commission Deposit5GPNRIS-M: Business Partner Keynvarchar100
36JDTDRERIS-M/SD: Publications8GPNRIS-M: Business Partner Publishernvarchar100
37JDTPVAIS-M/SD: Editions58GPNRIS-M: Business Partner Publishernvarchar100
38JFDFSIS-M/SD: Billing/Settlement Index17GPNRIS-M: Business Partner Keynvarchar100
39JFXDEBIDLIS-M: Backup Transfer Internal Table XDEBI4GPNRIS-M: Business Partner Keynvarchar100
40JKCOMMSales Order: Commission for Introduction Record5GPNRIS-M: Commission Recipientnvarchar100
41JKGIFTSales Order: Promotional Gifts for Introduction Record6GPNRBusiness Partner Sales Agentnvarchar100
42JKPASales Order: Partner8GPNRIS-M: Business Partner Keynvarchar100
43JKWWWTEMP_BPIS-M/SD: WWW, Temporary Table for BP Data from Internet4GPNRIS-M: Business Partner Keynvarchar100
44JKWWWTEMP_COMPLIS-M/SD: Temporary Table for Complaints in Internet6GPNRIS-M: Business Partner Keynvarchar100
45JKWWWTEMP_GIFTIS-M: Internet Temporary Table: Gift Data22GPNRIS-M: Business Partner Keynvarchar100
46JKWWWTEMP_REDIRIS-M: Temporary Internet Table: Redirection Data22GPNRIS-M: Business Partner Keynvarchar100
47JKWWWTEMP_SERVIS-M: Temporary Table for Changes from Internet3GPNRIS-M: Business Partner Keynvarchar100
48JKWWW_PROTOCOLIS-M: Table for Logging Creation/Changes made with IACs8GPNRIS-M: Business Partner Keynvarchar100
49JLCOMMINDIS-M: Commission Index5GPNRIS-M: Business Partner Keynvarchar100
50JLRKIS-M/SD: Settlement Header Data42GPNRIS-M: Business Partner Keynvarchar100
51JRTBEABSTIS-M/SD: Unloading Point7GPNRIS-M: Business Partner Keynvarchar100
52JWTWEKOIS-M/SD: Sales Activity for Business Partner3GPNRIS-M: Business Partner Keynvarchar100
53JYTTRGWAERIS-M: Trigger Entries for Currency Changes2GPNRIS-M: Business Partner Keynvarchar100
54TJKW0IS-M/SD: WBZ, Computer Center9GPNRIS-M: Business Partner Keynvarchar100
55TJL35IS-M/SD: Master Data for Contract Arrangement Determination3GPNRIS-M: Business Partner Keynvarchar100
56TJL42IS-M/SD: Master Data for External Contract Arrangement Det.3GPNRIS-M: Business Partner Keynvarchar100
TOPSAP Media
57J_1S_AENDIS-M/SD CH/S: Orders Affected by Change Number7GPNRIS-M: Business Partner Keynvarchar100