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

98 columns | Print definition?ERP 6.0  | SAP_OBJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/CT_IDH_HEADInbound Document Handler: Registration table with header inf35SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
2/OTEI/T_DLEIM: Additional views for DL3SAP_OBJECTSAP-Objectnvarchar100
3/OTTM/BL_T_DMCCustomizing table for default mappings of e-receipt types3SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
4/OTTM/BL_T_EDCCustomizing table for mapping of expense and doc types5SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
5/OTX/AL_STORECTRCustomizing table for AL attributes storages2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
6/OTX/RM_ERRORQArchiveLink entries whose RM processing failed2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
7/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed12SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
8/OTX/RM_REMLNKSDummy table to provide locking for /OTX/RM_REMOVE_LINKS2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
9/OTX/RM_TPASSIGNAssignment of declaration ID to object type and doc. type2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
10/UI2/LPD_FEEDERUI BE: Launchpad Feeder Class Assignments3SAP_OBJECTSAP Objectnvarchar10
11APB_LPD_ADD_XMLSVersion independent xmls5SAP_OBJECTSAP Objectnvarchar10
12APB_LPD_PATHS_CCustomer Paths to Starter iViews2SAP_OBJECTSAP Objectnvarchar10
13J_8AMUSERXCustomer Exits3SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
14TOACMBar code entry of incoming documents2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
15ZFSCM_IDOBELVerknüpfung: IDoc <-> Eingangsbeleg4SAP_OBJECTSAP ArchiveLink: Objekttyp des Business Objektsnvarchar100
TOPArchiveLink
16IABUSEXAMExample Table of Application Attributes3SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
17OABUS817AAttribute Table of BUS08173SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
18OAPRISAP ArchiveLink: Temporary table for print parameters32SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100
19TOA01Link table 12SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
20TOA02Link table 22SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
21TOA03Link table 32SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
22TOABCSAP ArchiveLink link table for bar code documents2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
23TOADLSAP ArchiveLink print lists12SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
24TOAFOSAP ArchiveLink form management2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
25TOAFVSAP ArchiveLink form management2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
26TOAHRContainer table for HR administration level2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
27TOAKPCNArchiveLink: Link Table for KPro Entries4SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
28TOALOGLogging for Document Accesses9SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
29TOALOGPLogging of Document Accesses18SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
30TOAO2SAP ArchiveLink extended meta table2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
31TOAOMSAP ArchiveLink: Meta table for links2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
32TOAP2SAP ArchiveLink: Presettings5SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
33TOAR7SAP ArchiveLink: Request table (asynchronous storage)4SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
34TOASMLanguage-Dependent Table For TOACM2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
35TOASVSAP ArchiveLink: Language table for form management2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPArchiving Connector ABAP
36ARCHLNK_AL_INDEXAssignment of BOR Key to ArchiveLink Attachment Doc_ID4SAP_OBJECTCharacter Field Length = 10nvarchar100
37ARCHLNK_DL_INDILM: Attributes for Finding ArchiveLink Print Lists in RW7SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
38ARCHLNK_TOAXYLink Table for ArchiveLink Stores from EOL Systems5SAP_OBJECTCharacter Field Length = 10nvarchar100
39ARC_DESTR_ALAL Attachments: Candidates for Destruction9SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
40ARC_DESTR_DLAL Print Lists: Candidates for Destruction9SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
41ARC_TRANS_ALDOCSTransfer Attachments5SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
42LHM_LH_PGATE_ALLegal Hold Cases for ArchiveLink Attachments2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
43LHM_LH_PGATE_DLLegal Hold Cases for Print Lists3SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
44LHM_PGATE_AL_RWLegal Hold Cases for ArchiveLink Attachments in RW2SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPBackground Processing
45TBTCPBackground Job Step Overview51SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100
TOPBasic Data
46TNF01IS-H: Catalog of Work Organizer Types4SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPBusiness Analytics
47UAB_XML_DATAXML Data5SAP_OBJECTSAP Objectnvarchar10
48UAB_XML_DATATName of Object5SAP_OBJECTSAP Objectnvarchar10
49UAB_XML_TRANSLXML Translation2SAP_OBJECTSAP Objectnvarchar10
50UAUXS_DATAXML Data5SAP_OBJECTSAP Objectnvarchar10
51UAUXS_DATATName of Object5SAP_OBJECTSAP Objectnvarchar10
TOPControlling
52QISRCONFIGInternet Service Request: Scenario Configuration (XML)5SAP_OBJECTSAP Objectnvarchar10
53QISRCONFIGTInternet Service Request: Scenario Configuration - Text5SAP_OBJECTSAP Objectnvarchar10
TOPCorrespondence Tool
54DFKKCOHARCSAP ArchiveLink - Object Identifiers6SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
55TFK070HCorrespondence - Client-Specific Settings3SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPCross-Application Components
56/IXOS/AX_TOUTBOXOutbox11SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
57/IXOS/DC_TBCDOCLink table for changeable word documents4SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
58/IXOS/DC_TCDSData sources (attribute objects) (j_8AGTC05)9SAP_OBJECTSAP-Objectnvarchar100
59/IXOS/RM_TDL2Livelink DesktopLink Customizing for Records Management (2)5SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
60J_8A3MERKmemorize last selection - Old Version, don't use6SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
61J_8A3T0006memorize last selection7SAP_OBJECTsap objectnvarchar100
62J_8A3T0012customizing for ODMA attributes2SAP_OBJECTsap objectnvarchar100
63J_8A3T0014customer exits4SAP_OBJECTsap objectnvarchar100
TOPEnd User Technology
64RSRA_PACKAGEScheduling Packages for the Report Agent37SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100
TOPExcise Duty
65/BEV2/ED917ARCParameters for Archiving7SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
66/BEV2/EDARCDOCIDIndex Table for Archive Documents11SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPLaunchpad
67APB_LAUNCHPADLaunchpad6SAP_OBJECTSAP Objectnvarchar10
68APB_LAUNCHPADTDescriptions for APB_LAUNCHPAD4SAP_OBJECTSAP Objectnvarchar10
69APB_LAUNCHPAD_VLaunchpad with versions7SAP_OBJECTSAP Objectnvarchar10
70APB_LPD_CHNGELOGLogs changes made to launchpad for updating user version5SAP_OBJECTSAP Objectnvarchar10
71APB_LPD_OTR_KEYSOTR keys for Launchpad texts4SAP_OBJECTSAP Objectnvarchar10
72APB_LPD_REPOSWhere used list for Repositories5SAP_OBJECTSAP Objectnvarchar10
73APB_LPD_SEARCHSearch over Launchpads5SAP_OBJECTSAP Objectnvarchar10
74APB_LPD_SH_TEXTSShort Texts1SAP_OBJECTSAP Objectnvarchar10
75APB_LPD_TRANSLOGTransports change logs to lpd for updating user version5SAP_OBJECTSAP Objectnvarchar10
TOPLoans Management
76VDCORR_ALOILoans: Search Index for Correspondence (Document Finder)9SAP_OBJECTSAP ArchiveLink: Object type of business objectnvarchar100
TOPRevenue
77OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info3SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100
TOPRoyalty Reporting
78OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions35SAP_OBJECTArchiving Parameter: Object Type of SAP Objectnvarchar100
TOPServices
79UAB_FUSAGEUser of a Fomula4SAP_OBJECTSAP Objectnvarchar10
80UAB_FXMLXML Data5SAP_OBJECTSAP Objectnvarchar10
81UAB_FXMLTName of Object5SAP_OBJECTSAP Objectnvarchar10
TOPWeb Survey
82TUBD_PARAMETERBusiness Domain Lib: Class Parameter2SAP_OBJECTSAP Objectnvarchar10
83TUWS_FORMSERVICEXML Data5SAP_OBJECTSAP Objectnvarchar10
84TUWS_FORMSERVICTDescriptions to TUWS_FORMSERVICE5SAP_OBJECTSAP Objectnvarchar10
85TUWS_SURVEYSurvey5SAP_OBJECTSAP Objectnvarchar10
86TUWS_SURVEYTDescriptions for TUWS_SURVEY5SAP_OBJECTSAP Objectnvarchar10
87TUWS_SURVEY_GRPSurvey5SAP_OBJECTSAP Objectnvarchar10
88TUWS_SURVEY_GRPTDescriptions for TUWS_SURVEY5SAP_OBJECTSAP Objectnvarchar10
89TUWS_TARGETHIERXML Data5SAP_OBJECTSAP Objectnvarchar10
90TUWS_TARGETHIERTDescriptions for TUWS_TARGETHIER5SAP_OBJECTSAP Objectnvarchar10
91TUWS_TAROBJSurvey: Recipients4SAP_OBJECTSAP Objectnvarchar10
92TUWS_TAROBJ_ATTRSurvey: Recipient Attributes4SAP_OBJECTSAP Objectnvarchar10
93TUWS_TAROB_C_ATTSurvey: Recipient Attributes4SAP_OBJECTSAP Objectnvarchar10
94TUXS_QUEST_TRANSTranslation Table for Questionnaires2SAP_OBJECTSAP Objectnvarchar10
95TUXS_XML_TRANSLXML Translation2SAP_OBJECTSAP Objectnvarchar10
96TUXS_XSLT_TRANSLForm Services Translation of XSLT programs1SAP_OBJECTSAP Objectnvarchar10
97UXS_DATAXML Data5SAP_OBJECTSAP Objectnvarchar10
98UXS_DATATName of Object5SAP_OBJECTSAP Objectnvarchar10