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

97 columns | Print definition?ERP 6.0  | AR_OBJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/CT_FILE_EXTTable: Image file extentions2AR_OBJECTArchive Document Typenvarchar100
2/OPT/CT_IDH_DOCInbound Document Handler: Table for storing document input9AR_OBJECTArchive Document Typenvarchar100
3/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf5AR_OBJECTArchive Document Typenvarchar100
4/OPT/CT_IDH_MAILInbound Document Handler: Email Input Log - obsolete14AR_OBJECTArchive Document Typenvarchar100
5/OPT/VIM_AL_MAPArchive Link Doctype Mapping4AR_OBJECTDocument typenvarchar100
6/OPT/VIM_CFG_OBJTable to store the document types of ICC applications3AR_OBJECTArchive Document Typenvarchar100
7/OPT/VIM_DOC_URLTable: XML Document URL(of DP document)3AR_OBJECTDocument typenvarchar100
8/OPT/VIM_FB_OBJTable to store ICC feedback status2AR_OBJECTArchive Document Typenvarchar100
9/OPT/VIM_IMG_URLTable: Image URL of DP Document3AR_OBJECTDocument typenvarchar100
10/OPT/VIM_VAL_DETTable for OCR validation determination2AR_OBJECTDocument typenvarchar100
11/OPT/X001Logical System and Archive Document Type Mapping2AR_OBJECTDocument typenvarchar100
12/OPT/X069Document Type Definition4AR_OBJECTDocument typenvarchar100
13/OPT/X123Table for OCR validation determination2AR_OBJECTDocument typenvarchar100
14/OPT/Y001Logical System and Archive Document Type Mapping2AR_OBJECTDocument typenvarchar100
15/OPT/Y069Document Type Definition4AR_OBJECTDocument typenvarchar100
16/OPT/Y123Table for OCR validation determination2AR_OBJECTDocument typenvarchar100
17/OPT/Z001Logical System and Archive Document Type Mapping2AR_OBJECTDocument typenvarchar100
18/OPT/Z069Document Type Definition4AR_OBJECTDocument typenvarchar100
19/OPT/Z123Table for OCR validation determination2AR_OBJECTDocument typenvarchar100
20/ORS/ARCH_ATTACHMapping of Archive Document Type to File Extensions3AR_OBJECTDocument typenvarchar100
21/OTEI/DU_WD_DCTPDocument types customzing table5AR_OBJECTDocument typenvarchar100
22/OTEI/DU_WD_TICDTicket details table10AR_OBJECTDocument typenvarchar100
23/OTTM/BL_T_DMCCustomizing table for default mappings of e-receipt types5AR_OBJECTDocument typenvarchar100
24/OTTM/BL_T_EDCCustomizing table for mapping of expense and doc types6AR_OBJECTDocument typenvarchar100
25/OTX/AL_STORECTRCustomizing table for AL attributes storages3AR_OBJECTDocument typenvarchar100
26/OTX/RM_AUNITCFGServer-specific configuration for unit tests3AR_OBJECTDocument typenvarchar100
27/OTX/RM_ERRORQArchiveLink entries whose RM processing failed6AR_OBJECTDocument typenvarchar100
28/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed13AR_OBJECTDocument typenvarchar100
29/OTX/RM_TPASSIGNAssignment of declaration ID to object type and doc. type3AR_OBJECTDocument typenvarchar100
30T390PM: Shop papers for print control7AR_OBJECTSAP ArchiveLink: Object typenvarchar100
31TN1DOC_ARCSettings for Archiving of Document Categories4AR_OBJECTDocument typenvarchar100
32TOACMBar code entry of incoming documents3AR_OBJECTDocument typenvarchar100
33ZFSCM_IDOBELVerknüpfung: IDoc <-> Eingangsbeleg6AR_OBJECTDokumentartnvarchar100
TOPAgency Business Global Trade
34TMFKAgency Business: Billing Document Types53AR_OBJECTDocument typenvarchar100
TOPArchiveLink
35IABUSEXAMExample Table of Application Attributes7AR_OBJECTDocument typenvarchar100
36OA0817BARCustomizing Table for BUS08172AR_OBJECTDocument typenvarchar100
37OABUS817AAttribute Table of BUS08177AR_OBJECTDocument typenvarchar100
38OAPRISAP ArchiveLink: Temporary table for print parameters33AR_OBJECTArchiving Parameter: Document Typenvarchar100
39TOA01Link table 16AR_OBJECTDocument typenvarchar100
40TOA02Link table 26AR_OBJECTDocument typenvarchar100
41TOA03Link table 36AR_OBJECTDocument typenvarchar100
42TOABCSAP ArchiveLink link table for bar code documents6AR_OBJECTDocument typenvarchar100
43TOADLSAP ArchiveLink print lists13AR_OBJECTDocument typenvarchar100
44TOADVSAP ArchiveLink: Global document types2AR_OBJECTDocument typenvarchar100
45TOAFOSAP ArchiveLink form management3AR_OBJECTDocument typenvarchar100
46TOAFVSAP ArchiveLink form management3AR_OBJECTDocument typenvarchar100
47TOAHRContainer table for HR administration level6AR_OBJECTDocument typenvarchar100
48TOALOGLogging for Document Accesses12AR_OBJECTDocument typenvarchar100
49TOALOGPLogging of Document Accesses19AR_OBJECTDocument typenvarchar100
50TOAO2SAP ArchiveLink extended meta table3AR_OBJECTDocument typenvarchar100
51TOAOMSAP ArchiveLink: Meta table for links3AR_OBJECTDocument typenvarchar100
52TOAP2SAP ArchiveLink: Presettings6AR_OBJECTDocument typenvarchar100
53TOAR7SAP ArchiveLink: Request table (asynchronous storage)5AR_OBJECTDocument typenvarchar100
54TOASPSAP ArchiveLink: Language table for archive objects2AR_OBJECTDocument typenvarchar100
55TOASVSAP ArchiveLink: Language table for form management3AR_OBJECTDocument typenvarchar100
TOPArchiving Connector ABAP
56ARCHLNK_DL_INDILM: Attributes for Finding ArchiveLink Print Lists in RW8AR_OBJECTDocument typenvarchar100
57ARCHLNK_TOAXYLink Table for ArchiveLink Stores from EOL Systems9AR_OBJECTCharacter Field Length = 10nvarchar100
58ARC_TRANS_ALDOCSTransfer Attachments7AR_OBJECTDocument typenvarchar100
TOPBackground Processing
59TBTCPBackground Job Step Overview52AR_OBJECTArchiving Parameter: Document Typenvarchar100
TOPBasic Data
60TNF30IS-H: Work Organizers Without Selection Conditions30AR_OBJECTIS-H: ArchiveLink Document Typenvarchar100
61TNF31IS-H: Work Organizers with Ins. Prov. Conditions32AR_OBJECTIS-H: ArchiveLink Document Typenvarchar100
62TNF32IS-H: Work Organizers with Billing Type and Ins. Prov. Cond.32AR_OBJECTIS-H: ArchiveLink Document Typenvarchar100
TOPClaims Management
63TICL031Claim Document4AR_OBJECTDocument typenvarchar100
64TICL190FS-CM Document Types for Claims3AR_OBJECTDocument typenvarchar100
65TICL346Office Integration: Additional Template Attributes4AR_OBJECTDocument typenvarchar100
TOPClinical System
66TN2DOCARCHIS-H*MED: Settings for Archiving Documents3AR_OBJECTDocument typenvarchar100
TOPContract Accounts Receivable and Payable
67FKK_EBS_AR_OBJArchiveLink: Define Document Type in ArchiveLink3AR_OBJECTDocument typenvarchar100
TOPCorrespondence
68TIVCPCACorrespondence Application4AR_OBJECTDocument typenvarchar100
TOPCorrespondence Tool
69TFK070HCorrespondence - Client-Specific Settings4AR_OBJECTDocument typenvarchar100
TOPCross-Application Components
70/IXOS/DC_TALNTUAUser settings for archiving at nodetypes9AR_OBJECTDocument typenvarchar100
71/IXOS/DC_TBCDOCLink table for changeable word documents5AR_OBJECTDocument typenvarchar100
72/IXOS/DC_TCDSData sources (attribute objects) (j_8AGTC05)10AR_OBJECTDocument typenvarchar100
73/IXOS/OA_CUST3Customizing for forceMimeType1AR_OBJECTDocument typenvarchar100
74/IXOS/RM_TDL2Livelink DesktopLink Customizing for Records Management (2)6AR_OBJECTDocument typenvarchar100
75J_8A3MERKmemorize last selection - Old Version, don't use5AR_OBJECTDocument typenvarchar100
76J_8A3T0006memorize last selection5AR_OBJECTsingle documenttypesnvarchar100
TOPData Retention Tool
77TXW_DIRAL2Data file log - ArchiveLink18AR_OBJECTdocument type DART extractnvarchar100
78TXW_VWLOGAL2View query log - ArchiveLink17AR_OBJECTdocument type DART viewnvarchar100
TOPElectonic Signature
79/DSD/ES_CUST_REPDSD Signature Repository2AR_OBJECTDocument typenvarchar100
TOPEnd User Technology
80RSRA_PACKAGEScheduling Packages for the Report Agent38AR_OBJECTArchiving Parameter: Document Typenvarchar100
TOPExcise Duty
81/BEV2/ED917ARCParameters for Archiving8AR_OBJECTDocument typenvarchar100
82/BEV2/EDARCDOCIDIndex Table for Archive Documents12AR_OBJECTDocument typenvarchar100
TOPFinancial Accounting
83/OPT/AR_LOGSYSLogical System and Archive Document Type Mapping2AR_OBJECTDocument typenvarchar100
84/OPT/VIM_1HEADDocument Header6AR_OBJECTArchive Document Typenvarchar100
85/OPT/VIM_T100Document Type Definition4AR_OBJECTDocument typenvarchar100
TOPFinancial Supply Chain Management
86EDX_CONFIG_INEDX: Configuration for Incoming Messages9AR_OBJECTEDX: Document Type in Archivenvarchar100
TOPHR Administrative Services
87T5ASRDPFARDOCSAssignment of Archived Documents to Category of Record2AR_OBJECTDocument typenvarchar100
TOPIndustry Solution - Telecommunications
88IST_EBS_AR_OBJArchiveLink: Define Document Type in ArchiveLink3AR_OBJECTDocument typenvarchar100
TOPLoans Management
89VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)11AR_OBJECTDocument typenvarchar100
TOPLogistics - General
90TB2BETrading Contract: Trading Contract Type52AR_OBJECTDocument typenvarchar100
TOPMaterials Management
91/SAPPSPRO/SEMALDAssignment of AL document types to Semantic classification3AR_OBJECTDocument typenvarchar100
TOPPension fund General Parts
92T5CBMOutput Sequence Steps10AR_OBJECTDocument typenvarchar100
TOPPrint Workbench
93EFCLPrint Worbench: Form Classes12AR_OBJECTDocument typenvarchar100
TOPPurchasing
94T161Purchasing Document Types26AR_OBJECTDocument typenvarchar100
TOPRevenue
95OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info4AR_OBJECTArchiving Parameter: Document Typenvarchar100
TOPRoyalty Reporting
96OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions36AR_OBJECTArchiving Parameter: Document Typenvarchar100
TOPSales Activities
97TVKKSales Activity Types33AR_OBJECTDocument typenvarchar100