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

38 columns | Print definition?ERP 6.0  | KONTT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSAD_BAKAccounting: Secondary index for customers (cleared items)173KONTTAccount Assignment Category for Industry Solutionnvarchar20
2BSAK_BAKAccounting: Secondary Index for Vendors (Cleared Items)175KONTTAccount Assignment Category for Industry Solutionnvarchar20
3BSEGAccounting Document Segment288KONTTAccount Assignment Category for Industry Solutionnvarchar20
4BSID_BAKAccounting: Secondary Index for Customers173KONTTAccount Assignment Category for Industry Solutionnvarchar20
5BSIK_BAKAccounting: Secondary index for vendors175KONTTAccount Assignment Category for Industry Solutionnvarchar20
6BSSEGAccounting Document Segment277KONTTAccount Assignment Category for Industry Solutionnvarchar20
7FUDT_VDOCBSEGVerification Document Item with Additional Info277KONTTAccount Assignment Category for Industry Solutionnvarchar20
8FUDT_VDOCBSEGEVVerification Document Item in the Entry View277KONTTAccount Assignment Category for Industry Solutionnvarchar20
9FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)277KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPCollectionsDisbursements
10VVKKFOPSingle Doc in Posting Data Interface68KONTTAccount Assignment Categorynvarchar20
11VVSCPOSPayment Plan Item62KONTTAccount Assignment Categorynvarchar20
TOPContract Accounts Receivable and Payable
12DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)39KONTTAccount Assignment Categorynvarchar20
13DFKKMOPItems in contract account document91KONTTAccount Assignment Categorynvarchar20
14DFKKMOPKItems in contract account document43KONTTAccount Assignment Categorynvarchar20
15DFKKOPItems in contract account document91KONTTAccount Assignment Categorynvarchar20
16DFKKOPKItems in contract account document43KONTTAccount Assignment Categorynvarchar20
17DFKKOP_REPOpen Items from FPO495KONTTAccount Assignment Categorynvarchar20
18DFKKSUMPosting totals from FI-CA39KONTTAccount Assignment Categorynvarchar20
19FKKDEFREVTrigger Table for Deferred Revenue Postings41KONTTAccount Assignment Categorynvarchar20
20TFK000KAccount Assignment Categories1KONTTAccount Assignment Categorynvarchar20
21TFK000KTDescription of account assignment categories2KONTTAccount Assignment Categorynvarchar20
TOPElectronic Bank Statement
22FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)66KONTTAccount Assignment Category for Industry Solutionnvarchar20
23FEB_ACTAcct Assignment Templates66KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPFinancial Accounting
24BSADAccounting: Secondary Index for Customers (Cleared Items)173KONTTAccount Assignment Category for Industry Solutionnvarchar20
25BSAKAccounting: Secondary Index for Vendors (Cleared Items)175KONTTAccount Assignment Category for Industry Solutionnvarchar20
26BSIDAccounting: Secondary Index for Customers173KONTTAccount Assignment Category for Industry Solutionnvarchar20
27BSIKAccounting: Secondary Index for Vendors175KONTTAccount Assignment Category for Industry Solutionnvarchar20
28VBSEGADocument Segment for Document Parking - Asset Database63KONTTAccount Assignment Category for Industry Solutionnvarchar20
29VBSEGDDocument Segment for Customer Document Parking127KONTTAccount Assignment Category for Industry Solutionnvarchar20
30VBSEGKDocument Segment for Vendor Document Parking139KONTTAccount Assignment Category for Industry Solutionnvarchar20
31VBSEGSDocument Segment for Document Parking - G/L Account Database122KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPFinancial Services Localization
32/GSINS/UPR_DEFREUPR - Calculation of unearned insurance premium reserve13KONTTAccount Assignment Categorynvarchar20
TOPFunds Management-Specific Postings
33FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years120KONTTAccount Assignment Category for Industry Solutionnvarchar20
34PSOSEGSRecurring Request Document Segment, G/L Accounts132KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPGeneral Ledger Accounting
35BSEG_ADDEntry View of Accounting Document for Additional Ledgers64KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPGL Account Posting
36TCJ_POSITIONSCash Journal Document Items73KONTTAccount Assignment Category for Industry Solutionnvarchar20
TOPInvoicing
37DEABPSCustomer change table: Logical view of BB amounts83KONTTAccount Assignment Categorynvarchar20
TOPRemaining Beverage - Obsolete Objects
38/BEV3/CH1030BSG2Document Segment CH Event Ledger Part244KONTTAccount Assignment Category for Industry Solutionnvarchar20