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

64 columns | Print definition?ERP 6.0  | ARC_DOC_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/CT_IDH_DOCInbound Document Handler: Table for storing document input8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
2/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
3/OPT/VIM_DOC_URLTable: XML Document URL(of DP document)5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
4/OPT/VIM_IMG_URLTable: Image URL of DP Document5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
5/OPT/VT_DOC_HReporting table: Document header20ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
6/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head32ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
7/OPT/VT_DOC_HEADDocument Header32ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
8/ORS/FILE_ATTACHFile names of the attachements added during the approvals3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
9/OTEI/DU_WD_TICDTicket details table3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
10/OTEI/FU_WD_BUFFile upload buffer4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
11/OTEI/T_ACT_LOGActvity log18ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
12/OTOC/BL_T_REQOCR Request3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
13/OTOC/BL_T_TR3OCR Request - Trace Export Request - Request Document4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
14/OTTM/BL_T_ERAE-Receipt assignments3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
15/OTTM/BL_T_ERBE-Receipt repository3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
16/OTTM/BL_T_ERME-Receipt metadata3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
17/OTX/RM_ERRORQArchiveLink entries whose RM processing failed5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
18/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed11ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
19TOAATTable to store the File attributes2ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
20ZSRSIDX_00000001ILM-SRS Index: al_ec3_arc4ARC_DOC_IDnvarchar400
TOPAccounts Receivable Accounting Process Integration
21TEBPP_REC_INV_ASAP Biller Direct: Bill Receipt Processing: Archive9ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPArchiveLink
22IABUSEXAMExample Table of Application Attributes5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
23OABUS817AAttribute Table of BUS08175ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
24TOA01Link table 15ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
25TOA02Link table 25ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
26TOA03Link table 35ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
27TOABCSAP ArchiveLink link table for bar code documents5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
28TOACRAsynchronous ArchiveLink Requests28ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
29TOADLSAP ArchiveLink print lists11ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
30TOADL_PARTSub-object of stored print list8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
31TOAFOSAP ArchiveLink form management7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
32TOAFVSAP ArchiveLink form management7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
33TOAHRContainer table for HR administration level5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
34TOALOGLogging for Document Accesses13ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
35TOALOGPLogging of Document Accesses17ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
36TOAR7SAP ArchiveLink: Request table (asynchronous storage)8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
37TOAV2VIEW table 2 structure for link table2ARC_DOC_IDSAP ArchiveLink document IDnvarchar400
TOPArchiving Connector ABAP
38ARCHLNK_TOAXYLink Table for ArchiveLink Stores from EOL Systems8ARC_DOC_IDCharacter field of length 40nvarchar400
39LHM_LH_PGATE_ALLegal Hold Cases for ArchiveLink Attachments5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
40LHM_LH_PGATE_DLLegal Hold Cases for Print Lists5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
41LHM_PGATE_AL_RWLegal Hold Cases for ArchiveLink Attachments in RW5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPClaims Management
42ICLALDDAssign Archive Link Document to Claim Subobject8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
43ICLDOCALAttachments to Outbound Documents7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
44ICLEALDDAssignment of Archive Link Document to Claim Bundle7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
45ICSALDDAssign Archive Link Document to Claim Subobject8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
46ICSDOCALAttachments to Outbound Correspondence7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
47ICSEALDDAssign Archive Link Document to Claim Subobject7ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPCross-Application Components
48/IXOS/AX_TOUTBOXOutbox13ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
49/IXOS/DCRSA_TRCETrace Table Rendering20ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
50/IXOS/DC_TBCDOCLink table for changeable word documents3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
51/IXOS/DC_WD_DV_Cdoc view cache2ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
52/IXOS/FT46_LOGFCLogging RFC call5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
53/IXOS/RM_TPROTLog table4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
54J_8A3T0001linktable for tiff with workflow and multidocuments2ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
55J_8A3T0004store filename and username with reserves fields3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
56J_8A3T0013attribute store3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
57J_8A3T0018link between originalformat and targetformat3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
58J_8A3T0019linktable for tiff with workflow and multidocuments2ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPElectonic Signature
59/DSD/ES_DELDSD Delivery Signatures4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
60/DSD/ES_INVDSD Invoice Signatures4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
61/DSD/ES_ORDDSD Order Signatures4ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPFinancial Accounting
62/OPT/VIM_1HEADDocument Header5ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPLoans Management
63VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)8ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400
TOPRecords and Case Management
64RMPSARCHATTRTemporary Storage of Scanned Document Attributes3ARC_DOC_IDSAP ArchiveLink: Document IDnvarchar400