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

45 columns | Print definition?ERP 6.0  | ARCHIVEKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ZARIXBC1Archivinformationsstruktur ZZ_BC_SBOOK31_T6ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
2ZARIXBC2Archive Information Structure SAP_O_2_WI_0017ARCHIVEKEYKey for Archive Filenvarchar200
3ZARIXBC3Archive Information Structure WORKITEM7ARCHIVEKEYKey for Archive Filenvarchar200
4ZARIXCO1APPREQUEST: Indextabelle zur Selektion von Datenobjekten3ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
5ZARIXFI1Archive Information Structure SAP_FI_DOC_0026ARCHIVEKEYKey for Archive Filenvarchar200
6ZARIXFI2Archive Information Structure SAP_FI_DOC_DRB15ARCHIVEKEYKey for Archive Filenvarchar200
7ZARIXMM1MM_EBAN : Indextabelle zur Selektion von Datenobjekten4ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
8ZARIXPP1PP_ORDER : Indextabelle zur Selektion von Datenobjekten4ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
9ZARIXQM1SAP_QM_SAMPLE1 : Indextabelle zur Selektion von Datenobje4ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
10ZARIXSD1SD_VBAK : Indextabelle zur Selektion von Datenobjekten4ARCHIVEKEYSchlüssel einer Archivdateinvarchar200
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
11CRM_CATJCATT - Log Index17ARCHIVEKEYKey for Archive Filenvarchar200
TOPALE Integration Technology
12EDIDOCINDXControl record (IDoc)50ARCHIVEKEYKey for Archive Filenvarchar200
TOPAppropriation Requests
13ARC_IDX_APPREQIM: Index Table for Archiving Appropriation Requests5ARCHIVEKEYKey for Archive Filenvarchar200
TOPArchive Development Kit
14ARCH_IDXIndex table for data object selection3ARCHIVEKEYKey for Archive Filenvarchar200
15ARCH_IDX_SIndex Table for Archiving Demo with BC_SBOOK2ARCHIVEKEYKey for Archive Filenvarchar200
TOPArchive Information System
16AIND_STATUStatus management of archive information structures2ARCHIVEKEYKey for Archive Filenvarchar200
17ASPART_FILESArchivInfoSys: Information per File2ARCHIVEKEYKey for Archive Filenvarchar200
TOPBasic Functions
18ARCID_P_VBRKArchiving SD_VBRK: Index table (primary)3ARCHIVEKEYKey for Archive Filenvarchar200
19ARCID_VBRKArchiving SD_VBRK: Index Table3ARCHIVEKEYKey for Archive Filenvarchar200
20ARC_IDX_ATIndex table for ACCTIT/ACCTHD/ACCTCR archives12ARCHIVEKEYKey for Archive Filenvarchar200
21ARC_IDX_ITArchive index table for FI-SL line items12ARCHIVEKEYKey for Archive Filenvarchar200
22MMPREF_PRO_IDXArchiving object MM_PREF customs logs - Index table2ARCHIVEKEYKey for Archive Filenvarchar200
23MMPREW_PRO_IDXArchiving object MM_PREW customs logs - Index table2ARCHIVEKEYKey for Archive Filenvarchar200
TOPCATT Computer Aided Test Tool
24CATJCATT - Log archive index16ARCHIVEKEYKey for Archive Filenvarchar200
TOPContract Accounts Receivable and Payable
25ARCH_FKKKOFI-CA doc: Header-oriented doc index for archive6ARCHIVEKEYKey for Archive Filenvarchar200
26ARCH_FKKOPFI-CA doc: Header-oriented doc index for archive6ARCHIVEKEYKey for Archive Filenvarchar200
TOPDown Payment Chains
27/SAPPCE/TDPCARCHIndex table for selecting archived down payment chains2ARCHIVEKEYKey for Archive Filenvarchar200
TOPeCATT Extended Computer Aided Test Tool
28ECLOG_AIDXTable for Log Archive Index11ARCHIVEKEYKey for Archive Filenvarchar200
29ECLOG_AIDX_SPLITTable for Log Archive Index Split8ARCHIVEKEYKey for Archive Filenvarchar200
30ECLOG_SETTable of Multiple Test Configurations at Start7ARCHIVEKEYKey for Archive Filenvarchar200
TOPInventory Management
31CHVW_IDXBatch Where-Used Index Table for Selection of Data Objects2ARCHIVEKEYKey for Archive Filenvarchar200
TOPJoint Venture und Production Sharing Accounting
32ARC_IDB_ITArchive-Indextable for JV_BILLING10ARCHIVEKEYKey for Archive Filenvarchar200
33ARC_IDJ_ITArchive-Indextable for JV_OBJECT10ARCHIVEKEYKey for Archive Filenvarchar200
34ARC_IDX_PRArchiving index for JV_PRICING archives5ARCHIVEKEYKey for Archive Filenvarchar200
TOPLoans Management
35CML_ARC_DOC_ADMHAdmin. Table for Reorganization of Loan Document Data5ARCHIVEKEYKey for Archive Filenvarchar200
36VDARC_DOC_ADMAdmin. Table for Reorganization of Loan Document Data21ARCHIVEKEYKey for Archive Filenvarchar200
37VDARC_DOC_INDIndex Table for the Loan Document Data Archiving12ARCHIVEKEYKey for Archive Filenvarchar200
TOPOLAP Technology
38ARCH_IDX_PROTIndex Table for Log Archiving for BI Authorizations5ARCHIVEKEYKey for Archive Filenvarchar200
TOPProfit Center Accounting
39ARC_IPC_ITArchive index table for FI-SL line items12ARCHIVEKEYKey for Archive Filenvarchar200
TOPReport Tree
40SREPOLISTReporting: Lists18ARCHIVEKEYNumeric field length 8nvarchar80
TOPReusable Components of Business Suite Foundation
41/BOFU/DDMOCUST_HDemo Customer Header22ARCHIVEKEYKey for Archive Filenvarchar200
TOPTime Sheet
42CATS_ARCH_IDXCATS Index Table for Data Object Selection6ARCHIVEKEYKey for Archive Filenvarchar200
TOPTransport Organizer
43VRS_AR_IDXIndex table for archived versions5ARCHIVEKEYKey for Archive Filenvarchar200
TOPWarranty Claim Processing
44WTY_ARCH_IDXIndex Table for Archiving Warranty Claims2ARCHIVEKEYKey for Archive Filenvarchar200
45WTY_ARCH_IDX_2Index Table for Archiving Warranty Claims2ARCHIVEKEYKey for Archive Filenvarchar200