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

87 columns | Print definition?ERP 6.0  | INFO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X049Opentext: VIM IE Monitor fcode put on control toolbar5INFOQuickinfo for an iconnvarchar300
2/OPT/X181IEM new fcode put on control toolbar3INFOQuickinfo for an iconnvarchar300
3/OPT/Y049Opentext: VIM IE Monitor fcode put on control toolbar5INFOQuickinfo for an iconnvarchar300
4/OPT/Y181IEM new fcode put on control toolbar3INFOQuickinfo for an iconnvarchar300
5/OPT/Z049Opentext: VIM IE Monitor fcode put on control toolbar5INFOQuickinfo for an iconnvarchar300
6/OPT/Z181IEM new fcode put on control toolbar3INFOQuickinfo for an iconnvarchar300
7/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed3INFOSAP ArchiveLink: Info fieldnvarchar30
8/PTGWFI/IEMFCODEIEM new fcode put on control toolbar3INFOQuickinfo for an iconnvarchar300
9/SAPF15/RMF15 Rückmeldung Klärungsbestand10INFOnvarchar2000
10/SAPF15/RMLOGF15 Rückmeldung Klärungsbestand Änderungshistorie11INFOnvarchar2000
11/SAPF15/TRMKFAH4Klärung HKR4 Fehlercode -> Klärungsfallarten7INFOnvarchar400
12/SAPF15/TRMKFAZ9Klärung ZÜV900 Fehlercode -> Klärungsfallarten6INFOnvarchar400
13BWSD_DATAData Store for Scenario Objects9INFOSingle-Character Indicatornvarchar10
14CNVCDOPCA_COMPCDOP - Results from Remote comparision9INFOInfo Text from Remote compare, e.g. error informationnvarchar730
15ITAGCYTCBPAgency Collections: Temporary Collections with BP14INFOInformation Field for Temporary Collection/Disbursementnvarchar2550
16MDS_VERSIONMDS: Headertable for analysis versions2INFOMDS: Info of an analysis versionnvarchar600
17SATC_CI_CUSTOMCustomizing3INFOimage21474836470
18SCIREST_TMPCode Inspector: Temporary Information6INFOCode Inspector: Detail Informationimage21474836470
19T513KRPDSYS00 - Relations5INFORPDSYS00: Reference validitynvarchar200
20T513LRPDSYS00 - Exploding Functions4INFORPDSYS00: Reference validitynvarchar200
21T513MRPDSYS00 - Origin of Documentation4INFORPDSYS00 - Origin of Documentationnvarchar80
22T513NRPDSYS00 - Supplementary Information4INFORPDSYS00 - Variable informationnvarchar700
23/BOBF/CONF_LOGTable for loging5INFOnvarchar4000
TOPABAP Runtime Environment
24INSTVERSDocumentation for installation Status and History14INFO128 characternvarchar1280
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
25CRM_ECLOG_HEADTable for Replicated eCATT Log Header17INFOCharacter 100nvarchar1000
TOPAdvertising Management
26JHATVASPTDIS-M/AM: Order Item Pool Issue Shift Header6INFOIS-M/AM: Information on Order Items Following Issue Shiftnvarchar600
TOPArchiveLink
27OAPRISAP ArchiveLink: Temporary table for print parameters41INFOArchiving Parameter: Info Fieldnvarchar30
28TOACRAsynchronous ArchiveLink Requests14INFOSAP ArchiveLink: Info fieldnvarchar30
29TOADLSAP ArchiveLink print lists3INFOSAP ArchiveLink: Info fieldnvarchar30
30TOADL_KEYSearch key for stored print lists3INFOSAP ArchiveLink: Info fieldnvarchar30
31TOADL_OLOnline section of stored print list3INFOSAP ArchiveLink: Info fieldnvarchar30
32TOADL_PARTSub-object of stored print list3INFOSAP ArchiveLink: Info fieldnvarchar30
33TOAKPDLArchiveLink: Print List Table KPro Entries5INFOSAP ArchiveLink: Info fieldnvarchar30
34TOALOGPLogging of Document Accesses9INFOSAP ArchiveLink: Info fieldnvarchar30
TOPArchiving Connector ABAP
35ARCHLNK_DL_INDILM: Attributes for Finding ArchiveLink Print Lists in RW5INFOSAP ArchiveLink: Info fieldnvarchar30
36ARCHLNK_TOAXYLink Table for ArchiveLink Stores from EOL Systems13INFOSAP ArchiveLink: Info fieldnvarchar30
TOPBackground Processing
37TBTCPBackground Job Step Overview60INFOArchiving Parameter: Info Fieldnvarchar30
TOPBasic Data
38TN00LIS-H: Log Table for Special Usage8INFOIS-H: special information (for log)nvarchar2550
TOPBusiness Partner
39BPTRGP_ADREConversion: TR Addresses - PDC Addresses8INFOAddress Information Fieldnvarchar10
40FSBP_CNS_IMAGETable for CNS Image Data3INFOAdditional Information for CNS Image Datanvarchar100
TOPChange Pointer Service
41CNS_CP_INFOCNS: Change Pointer Additional4INFOAdditional Informationnvarchar400
TOPCollectionsDisbursements
42ITAGCYTEMPCOLLAgency Collections: Data for Temporary Collections7INFOInformation Field for Temporary Collection/Disbursementnvarchar2550
TOPCross-Application Components
43/IXOS/DC_TADAAdministrator maintenance for Details15INFOInfotext: Use the text enhancement on create/detail screennvarchar10
44/IXOS/DC_TAIAAdministrator maintenance for Creating19INFOInfotext: Use the text enhancement on create/detail screennvarchar10
45/OPT/VIM_FCODEOpentext: VIM IE Monitor fcode put on control toolbar5INFOQuickinfo for an iconnvarchar300
46CACNS_SEARCHCUSTFavorites for Customer Search Consultant Portal10INFOCustomer Numbernvarchar100
47CRMRFCPARDefinitions for RFC Connections9INFOInformation/Commentsnvarchar300
TOPCustom Development Management Cockpit
48CNVCDMCCA_COMPCDMC - Results from Remote comparision9INFOInfo Text from Remote compare, e.g. error informationnvarchar730
TOPDBOS Migrations
49TIMIGIMIG: Administration & Status13INFOnvarchar2000
TOPDirectory
50LDAPUSERLDAP System User7INFOAccess information for credentialsnvarchar2550
TOPeCATT Extended Computer Aided Test Tool
51ECLOG_HEADTable for Log Header16INFOCharacter 100nvarchar1000
52ECLOG_HYDRASeveral Header Entries for Log25INFOCharacter 100nvarchar1000
TOPEnd User Technology
53RSRA_PACKAGEScheduling Packages for the Report Agent46INFOArchiving Parameter: Info Fieldnvarchar30
TOPEvent Management
54/SAPTRX/EXT_PARParameter and IDs for EM generic extraction6INFOInfo Parameternvarchar10
TOPFrance
55T5F6BDynamic Mapping for Interface: DDIC ADP (309FF)10INFOInformation from TEDM table (free or non-free element)nvarchar10
TOPFunds Management
56FMRES_EW_INFOSSaving Enhancement Wizard Settings2INFOCharacter field of length 40nvarchar400
TOPGovernance, Risk and Compliance
57GRFN_ORM_PROTORM Transfer: Log6INFOntext10737418230
TOPliveCache
58LCINIT_LOGLog Entries: Start/Stop/Init of Prep./Postprocessing Reports12INFOSAP DB: Response line from DBM commandnvarchar2550
TOPManagement of Internal Controls
59FOPC_ORM_PROTORM Transfer: Log8INFOntext10737418230
TOPMaterials Management
60/ISDFPS/LOSSMANLoss Management7INFOInformation Sent to Vendor and Goods Recipientnvarchar10
61/ISDFPS/LOSTMANObsolete5INFOInformation Sent to Vendor and Goods Recipientnvarchar10
TOPNetWeaver Enterprise Search
62ESH_CA_CLUSTERESH Cache Storage: INDX-like database for clustered data9INFOnvarchar320
63ESH_CO_JOB_INFOInformation about background jobs4INFOInformation About Background Jobnvarchar640
TOPPerformance Assessment Workbench
64SLS_UTILPAW - utility table4INFOChar 20nvarchar200
TOPPersonnel Time Management
65T555IPDC Master Record Information7INFOInfo fieldnvarchar40
TOPPortfolio Management
66/RPM/OBJ_MIGRDocuments, which xRPM 2.0 objects were migrated7INFOCharacter 100nvarchar1000
TOPProcess Controls
67GRPC_ORM_PROTORM Transfer: Log8INFOntext10737418230
TOPRegulatory reporting for insurance companies
68ISSR_ADMN_ASTVWISSR: Feste und variable Daten Meldewesen19INFOnvarchar600
69ISSR_MIG_BCKPISSR: Clustertabelle für Backup19INFOnvarchar600
TOPRevenue
70OIUE2_ESCH_MDDProc 2.0 - Escheat - Mass Due Diligence Print Info12INFOArchiving Parameter: Info Fieldnvarchar30
TOPRisk Analysis
71JBRMSGSELRM: Indicators that control the Filter for Messages4INFOOutput Field as Checkboxnvarchar10
TOPRoyalty Reporting
72OIUREP_2014_REPMMS-2014 - Supplemental Reports From Report Executions44INFOArchiving Parameter: Info Fieldnvarchar30
TOPSAP Internet Transaction Server
73W3GENSTYLESW3: Generation Styles for HTML Templates3INFOText Fieldnvarchar500
TOPSyntax, Compiler, Runtime
74SXBNFRULEXBNF rules4INFOXBNF Infonvarchar700
TOPTime Sheet
75CATS_MY_PUSHCATS notebook: Synchronize Static Objects5INFOnvarchar10
TOPTraders and Schedulers Workbench
76OIJRDTYPOIL-TSW : Partner Roles differentiation Types3INFOCharacter field length 20 with upper/lower casenvarchar200
77OIJRRPARTOIL-TSW : Partner Roles -> Role Partner Types3INFOCharacter field length 20 with upper/lower casenvarchar200
TOPTravel Planning
78FTPT_FLIGHT_TSTKTicket Information22INFOTicket Informationnvarchar770
TOPUser Administration
79SMUM_ACLValid sender information4INFOChar255nvarchar2550
TOPVirtual Machine Container
80SVMCRT_MODULESVMC Runtime: Modules5INFOModule Informationimage21474836470
TOPWeb Service and SOAP - ABAP
81SRT_DT_CHG_STATSRT: Design Time-to-Runtime Change Table7INFOntext10737418230
82SRT_DT_CHG_STATLSRT: Design Time-to-Runtime Change Table (History)7INFOntext10737418230
83SRT_MIG_HISTConfiguration migration history4INFOntext10737418230
TOPWorkbench Tools Editors, Painters, Modelers
84COVMODSETRepository for Customer/SAP View Information2INFOnvarchar500
TOPWorkforce Management Core
85/SAPAPO/LRPRTSATAttributes for a Requirement's Time Data17INFOChar 80nvarchar800
86/SAPAPO/LRPSTSATAttributes for Resource's Time Data17INFOChar 80nvarchar800
87/SAPAPO/LRPTSATTObsolete: Attributes for Time Data17INFOChar 80nvarchar800