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

77 columns | Print definition?ERP 6.0  | ARCHIV_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/CL_ARCHIVEArchives that are detected as Opentext/Ixos archives1ARCHIV_IDContent Repository Identificationnvarchar20
2/OPT/CT_IDH_DOCInbound Document Handler: Table for storing document input7ARCHIV_IDContent Repository Identificationnvarchar20
3/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf3ARCHIV_IDContent Repository Identificationnvarchar20
4/OPT/IT_ARC_SETTable to maintain the Archive Settings2ARCHIV_IDContent Repository Identificationnvarchar20
5/OPT/VIM_DOC_URLTable: XML Document URL(of DP document)4ARCHIV_IDContent Repository Identificationnvarchar20
6/OPT/VIM_IMG_URLTable: Image URL of DP Document4ARCHIV_IDContent Repository Identificationnvarchar20
7/OPT/VT_DOC_HReporting table: Document header19ARCHIV_IDContent Repository Identificationnvarchar20
8/OPT/VT_DOC_HEA1Document Header - copy of /opt/vt_doc_head31ARCHIV_IDContent Repository Identificationnvarchar20
9/OPT/VT_DOC_HEADDocument Header31ARCHIV_IDContent Repository Identificationnvarchar20
10/OPT/X024Table to maintain the Archive Settings2ARCHIV_IDContent Repository Identificationnvarchar20
11/OPT/Y024Table to maintain the Archive Settings2ARCHIV_IDContent Repository Identificationnvarchar20
12/OPT/Z024Table to maintain the Archive Settings2ARCHIV_IDContent Repository Identificationnvarchar20
13/ORS/FILE_ATTACHFile names of the attachements added during the approvals2ARCHIV_IDContent Repository Identificationnvarchar20
14/OTEI/T_ACT_LOGActvity log17ARCHIV_IDContent Repository Identificationnvarchar20
15/OTX/RM_ERRORQArchiveLink entries whose RM processing failed4ARCHIV_IDContent Repository Identificationnvarchar20
16/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed8ARCHIV_IDContent Repository Identificationnvarchar20
17TOAP1ArchiveLink: Early/late input settings archives5ARCHIV_IDContent Repository Identificationnvarchar20
18TSP0FArchive device for archive ID1ARCHIV_IDContent Repository Identificationnvarchar20
TOPAccounts Payable
19/PTGWFI/F_SMIMTRSMI Process Monitor3ARCHIV_IDContent Repository Identificationnvarchar20
TOPArchiveLink
20IABUSEXAMExample Table of Application Attributes6ARCHIV_IDContent Repository Identificationnvarchar20
21OABUS817AAttribute Table of BUS08176ARCHIV_IDContent Repository Identificationnvarchar20
22OAPRISAP ArchiveLink: Temporary table for print parameters34ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20
23TOA01Link table 14ARCHIV_IDContent Repository Identificationnvarchar20
24TOA02Link table 24ARCHIV_IDContent Repository Identificationnvarchar20
25TOA03Link table 34ARCHIV_IDContent Repository Identificationnvarchar20
26TOAARCommunications configuration table for storage system1ARCHIV_IDContent Repository Identificationnvarchar20
27TOABCSAP ArchiveLink link table for bar code documents4ARCHIV_IDContent Repository Identificationnvarchar20
28TOADLSAP ArchiveLink print lists8ARCHIV_IDContent Repository Identificationnvarchar20
29TOADL_SPLTList delimitation1ARCHIV_IDContent Repository Identificationnvarchar20
30TOAERSAP ArchiveLink: Storage system related error texts1ARCHIV_IDContent Repository Identificationnvarchar20
31TOAFOSAP ArchiveLink form management6ARCHIV_IDContent Repository Identificationnvarchar20
32TOAFVSAP ArchiveLink form management6ARCHIV_IDContent Repository Identificationnvarchar20
33TOAHRContainer table for HR administration level4ARCHIV_IDContent Repository Identificationnvarchar20
34TOALOGLogging for Document Accesses11ARCHIV_IDContent Repository Identificationnvarchar20
35TOALOGPLogging of Document Accesses14ARCHIV_IDContent Repository Identificationnvarchar20
36TOAO2SAP ArchiveLink extended meta table6ARCHIV_IDContent Repository Identificationnvarchar20
37TOAOMSAP ArchiveLink: Meta table for links5ARCHIV_IDContent Repository Identificationnvarchar20
38TOAP2SAP ArchiveLink: Presettings7ARCHIV_IDContent Repository Identificationnvarchar20
39TOAR7SAP ArchiveLink: Request table (asynchronous storage)7ARCHIV_IDContent Repository Identificationnvarchar20
40TOASRLanguage-Dependent Table For TOAAR1ARCHIV_IDContent Repository Identificationnvarchar20
41TOAV1VIEW basis table structure analogous to TOAOM3ARCHIV_IDSAP ArchiveLink: Storage ID (view)nvarchar20
TOPArchiving Connector ABAP
42ARCHLNK_TOAARCopied TOAAR from Legacy Systems to be Decommissioned1ARCHIV_IDCharacter field of length 40nvarchar400
43ARCHLNK_TOAXYLink Table for ArchiveLink Stores from EOL Systems7ARCHIV_IDContent Repository Identificationnvarchar20
44ARC_TRANS_ALDOCSTransfer Attachments8ARCHIV_IDContent Repository Identificationnvarchar20
TOPBackground Processing
45TBTCPBackground Job Step Overview53ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20
TOPClaims Management
46ICLALDDAssign Archive Link Document to Claim Subobject7ARCHIV_IDContent Repository Identificationnvarchar20
47ICLDOCALAttachments to Outbound Documents6ARCHIV_IDContent Repository Identificationnvarchar20
48ICLEALDDAssignment of Archive Link Document to Claim Bundle6ARCHIV_IDContent Repository Identificationnvarchar20
49ICSALDDAssign Archive Link Document to Claim Subobject7ARCHIV_IDContent Repository Identificationnvarchar20
50ICSDOCALAttachments to Outbound Correspondence6ARCHIV_IDContent Repository Identificationnvarchar20
51ICSEALDDAssign Archive Link Document to Claim Subobject6ARCHIV_IDContent Repository Identificationnvarchar20
TOPComplaints and Returns
52/SPE/INSPECRESPInspection Outcome: Item18ARCHIV_IDSAP ArchiveLink: Doc_IDnvarchar400
TOPCross-Application Components
53/IXOS/AX_TOUTBOXOutbox12ARCHIV_IDContent Repository Identificationnvarchar20
54/IXOS/DCRSA_TRCETrace Table Rendering21ARCHIV_IDContent Repository Identificationnvarchar20
55/IXOS/DC_TBCDOCLink table for changeable word documents2ARCHIV_IDContent Repository Identificationnvarchar20
56/IXOS/FT46_LOGFCLogging RFC call4ARCHIV_IDContent Repository Identificationnvarchar20
57/IXOS/OA_CUSTCustomizing for java/web viewer integration1ARCHIV_IDContent Repository Identificationnvarchar20
58/IXOS/OA_CUST_ACustomizing viewer usage and settings2ARCHIV_IDContent Repository Identificationnvarchar20
59/IXOS/OA_IPRANGECustomizing IP Ranges for WebViewer2ARCHIV_IDContent Repository Identificationnvarchar20
60/IXOS/RM_TPROTLog table5ARCHIV_IDContent Repository Identificationnvarchar20
61J_8A3T0001linktable for tiff with workflow and multidocuments3ARCHIV_IDContent Repository Identificationnvarchar20
62J_8A3T0004store filename and username with reserves fields2ARCHIV_IDContent Repository Identificationnvarchar20
63J_8A3T0013attribute store2ARCHIV_IDContent Repository Identificationnvarchar20
64J_8A3T0018link between originalformat and targetformat2ARCHIV_IDContent Repository Identificationnvarchar20
65J_8A3T0019linktable for tiff with workflow and multidocuments3ARCHIV_IDContent Repository Identificationnvarchar20
TOPDocument Management Services
66SDOKSTRESDOK: Physical storage locations (Storage Repository)17ARCHIV_IDContent Repository Identificationnvarchar20
TOPElectonic Signature
67/DSD/ES_CUST_REPDSD Signature Repository3ARCHIV_IDContent Repository Identificationnvarchar20
68/DSD/ES_DELDSD Delivery Signatures3ARCHIV_IDContent Repository Identificationnvarchar20
69/DSD/ES_INVDSD Invoice Signatures3ARCHIV_IDContent Repository Identificationnvarchar20
70/DSD/ES_ORDDSD Order Signatures3ARCHIV_IDContent Repository Identificationnvarchar20
TOPEnd User Technology
71RSRA_PACKAGEScheduling Packages for the Report Agent39ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20
TOPExcise Duty
72/BEV2/ED917ARCParameters for Archiving9ARCHIV_IDSAP ArchiveLink: Target storage systemnvarchar20
TOPFinancial Accounting
73/OPT/VIM_1HEADDocument Header4ARCHIV_IDContent Repository Identificationnvarchar20
TOPLoans Management
74VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)7ARCHIV_IDContent Repository Identificationnvarchar20
TOPRecords and Case Management
75RMPSARCHATTRTemporary Storage of Scanned Document Attributes2ARCHIV_IDContent Repository Identificationnvarchar20
TOPRevenue
76OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info5ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20
TOPRoyalty Reporting
77OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions37ARCHIV_IDArchiving Parameter: Target Storage Systemnvarchar20