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

163 columns | Print definition?ERP 6.0  | CREATOR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/BDC_IF_CONFAssign Batch Input Session and Creator (Config.)6CREATORQueue user ID / for historical reasonsnvarchar120
2/AIF/BDC_IF_GENAssign Batch Input Session and Creator (Gen.)5CREATORQueue user ID / for historical reasonsnvarchar120
3/AIF/BDC_ST_CONFDefine Pre-Interface Determination for Batch Input (Config.)3CREATORQueue user ID / for historical reasonsnvarchar120
4/AIF/BDC_ST_GENDefine Pre-Interface Determination for Batch Input (Gen.)2CREATORQueue user ID / for historical reasonsnvarchar120
5/AIF/T_FG_MAPmapping table for created objects9CREATORUser Namenvarchar120
6/AIF/T_SEL_BDCSelection Set for BDC Interfaces6CREATORQueue user ID / for historical reasonsnvarchar120
7/OTEB/SWF_TACTxIM activities business data8CREATORxIM activity creatornvarchar120
8/OTEB/SWF_TMPSELTemporary save of selected actkeys (several workitems exist)5CREATORxIM activity creatornvarchar120
9/OTEI/SWF_TMPSELTemporary save of selected actkeys (several workitems exist)4CREATORxIM activity creatornvarchar120
10/OTEI/T_GU_LOGGuestUser: Log-Table guest users10CREATORGuestUser: Account created bynvarchar120
11/OTEI/T_GU_TICGuest user tickets9CREATORGuestUser: Account created bynvarchar120
12/PLMI/AGT_MAPAgent Mapping for process route templates6CREATORCreator of Agent Mappingnvarchar120
13/PLMI/PRT_HEADERtemplate maintainance, prt header table4CREATORName of Process Route Creatornvarchar120
14/PLMI/TD_AGT_LSTTeam Definition: Agent List9CREATORName of Creator of Process Route Itemnvarchar120
15/SLOAP/ANALYSISSLOAP analysis data5CREATORSLOAS creatornvarchar120
16/SLOAP/ANLREPORTSLOAS analysis report control table5CREATORSLOAS creatornvarchar120
17/SLOAP/ANL_MDSLOAS Mapping of analyses to analysis modules4CREATORSLOAS creatornvarchar120
18/SLOAP/AUTHSLOAS: Authorization Data4CREATORSLOAS creatornvarchar120
19/SLOAP/CUSTOMERSLOAS customer data4CREATORSLOAS creatornvarchar120
20/SLOAP/DESC_ALIASLOAS description alias to guid mapping6CREATORSLOAS creatornvarchar120
21/SLOAP/DESC_ALITTransport table for /SLOAS/DESC_ALIA8CREATORSLOAS creatornvarchar120
22/SLOAP/FIELDSLOAS table fields8CREATORSLOAS creatornvarchar120
23/SLOAP/FIELDTTransport table for /SLOAS/FIELD10CREATORSLOAS creatornvarchar120
24/SLOAP/HELP_HEADapplication help header entries5CREATORSLOAS creatornvarchar120
25/SLOAP/IMP_LOGImprovement message log8CREATORSLOAS creatornvarchar120
26/SLOAP/KNA1_PROJSLOAS mapping of kunnr to project4CREATORSLOAS creatornvarchar120
27/SLOAP/LOG_METAmetainfo for sloap log content table4CREATORSLOAS creatornvarchar120
28/SLOAP/MD_FIELDSLOAS module-field mapping5CREATORSLOAS creatornvarchar120
29/SLOAP/MD_FIELDTtransport table for /SLOAS/MD_FIELD7CREATORSLOAS creatornvarchar120
30/SLOAP/MD_SYSSLOAS analysis module to system type mapping6CREATORSLOAS creatornvarchar120
31/SLOAP/MD_SYSTtransport table for /SLOAS/MD_SYS8CREATORSLOAS creatornvarchar120
32/SLOAP/MODULESLOAP analysis module data7CREATORSLOAS creatornvarchar120
33/SLOAP/MODULETtransport table for /SLOAP/MODULE9CREATORSLOAS creatornvarchar120
34/SLOAP/OUT_GRSLOAP Output Group8CREATORSLOAS creatornvarchar120
35/SLOAP/OUT_GRTtransport tables for /SLOAS/OUT_GR10CREATORSLOAS creatornvarchar120
36/SLOAP/OUT_MDSLOAP output module6CREATORSLOAS creatornvarchar120
37/SLOAP/OUT_MDTtransport table for /SLOAS/OUT_MD8CREATORSLOAS creatornvarchar120
38/SLOAP/OUT_PRSLOAP Output Profile8CREATORSLOAS creatornvarchar120
39/SLOAP/OUT_PRTtransport tables for /SLOAS/OUT_PR10CREATORSLOAS creatornvarchar120
40/SLOAP/PRESERSLOAS Service pertend table4CREATORSLOAS creatornvarchar120
41/SLOAP/PROJECTSLOAS Project data4CREATORSLOAS creatornvarchar120
42/SLOAP/RESULTSLOAP analysis results9CREATORSLOAS creatornvarchar120
43/SLOAP/ROLESLOAS: Role data4CREATORSLOAS creatornvarchar120
44/SLOAP/SERVICESLOAS - Analysis Services4CREATORSLOAS creatornvarchar120
45/SLOAP/STORAGESLOAS storage control table8CREATORSLOAS creatornvarchar120
46/SLOAP/STORAGETtransport table for /SLOAS/STORAGE10CREATORSLOAS creatornvarchar120
47/SLOAP/SYS_MESSSystem messages9CREATORUser namenvarchar120
48/SLOAP/TEXTSLOAS text mappings7CREATORSLOAS creatornvarchar120
49/SLOAP/TEXTTtransport tables for /SLOAS/TEXT9CREATORSLOAS creatornvarchar120
50/SLOAP/TRANSSAP LT AP: transport admin tables8CREATORSLOAS creatornvarchar120
51/SLOAP/USERSLOAS User data4CREATORSLOAS creatornvarchar120
52CNV_MBT_ME_MAPPSTable for mappings of the Mapping Engine5CREATORUser Namenvarchar120
53GRPCDBBUFDashboard buffer7CREATORUser Namenvarchar120
54J_8AFMIXOS Forms Management: Permanent table8CREATORForm creatornvarchar120
55LXE_PPAT_RUNPPAT Run5CREATORUser Namenvarchar120
56SWF_UNIT_CONFWorkflow: Workflow Unit Configuration5CREATORUser Namenvarchar120
57TOAATTable to store the File attributes4CREATORUser Namenvarchar120
TOPBackground Processing
58FAVSELSUser-Specific Favorite Selection Criteria2CREATORUser Namenvarchar120
TOPBusiness Package for Manager Self-Service FI
59FPB_EXP_CA_ASSMExpress Planning: Assignments Context Elem. / Roadmap Elem.9CREATORExpress Planning: Name of Created By Usernvarchar120
60FPB_EXP_CA_ITMExpress Planning: Elements of the Context Area (Obsolete)8CREATORExpress Planning: Name of Created By Usernvarchar120
61FPB_EXP_CA_ITM1Express Planning: Elements of the Context Area9CREATORExpress Planning: Name of Created By Usernvarchar120
62FPB_EXP_GRP_STPExpress Planning: Assignment of Substeps to Steps7CREATORExpress Planning: Name of Created By Usernvarchar120
63FPB_EXP_HIERExpress Planning: Object Hierarchies for Planning Instances7CREATORExpress Planning: Name of Created By Usernvarchar120
64FPB_EXP_INSTExpress Planning: Instances8CREATORExpress Planning: Name of Created By Usernvarchar120
65FPB_EXP_INSTRUCTExpress Planning: Instruction Texts7CREATORExpress Planning: Name of Created By Usernvarchar120
66FPB_EXP_INSTTExpress Planning: Instance Texts8CREATORExpress Planning: Name of Created By Usernvarchar120
67FPB_EXP_INS_MAILExpress Planning: Standard E-Mails9CREATORExpress Planning: Name of Created By Usernvarchar120
68FPB_EXP_ROLEExpress Planning: User Roles for Planning Rounds9CREATORExpress Planning: Name of Created By Usernvarchar120
69FPB_EXP_SCENExpress Planning: Scenarios5CREATORExpress Planning: Name of Created By Usernvarchar120
70FPB_EXP_SCENTExpress Planning: Scenario Texts7CREATORExpress Planning: Name of Created By Usernvarchar120
71FPB_EXP_SCEN_GRPExpress Planning: Assignment of Steps to Scenarios7CREATORExpress Planning: Name of Created By Usernvarchar120
72FPB_EXP_SECTExpress Planning: Context Area Sections7CREATORExpress Planning: Name of Created By Usernvarchar120
73FPB_EXP_SECTTText Table for FPB_EXP_SECT7CREATORExpress Planning: Name of Created By Usernvarchar120
74FPB_EXP_STPExpress Planning: Planning Substeps8CREATORExpress Planning: Name of Created By Usernvarchar120
75FPB_EXP_STPGRPExpress Planning: Steps6CREATORExpress Planning: Name of Created By Usernvarchar120
76FPB_EXP_STPGRPTExpress Planning: Groups or Planning Steps (Texts)6CREATORExpress Planning: Name of Created By Usernvarchar120
77FPB_EXP_STPTExpress Planning: Texts for Substeps6CREATORExpress Planning: Name of Created By Usernvarchar120
78FPB_EXP_UINSTExpress Planning: User Instance12CREATORExpress Planning: Name of Created By Usernvarchar120
79FPB_EXP_USCENExpress Planning: Application Scenario per iView and User6CREATORExpress Planning: Name of Created By Usernvarchar120
80FPB_EXP_VARVALExpress Planning: Value Assignment to Variables (SAP & Ext.)7CREATORExpress Planning: Name of Created By Usernvarchar120
81FPB_EXP_VAR_EXTExpress Planning: Customer-Specific Variables6CREATORExpress Planning: Name of Created By Usernvarchar120
82FPB_EXP_VAR_EXTTExpress Planning: Customer-Specific Variables Texts7CREATORExpress Planning: Name of Created By Usernvarchar120
TOPCanada
83PCERHHistory of Payroll Posting Runs9CREATORUser namenvarchar120
84T5KR0Record of Employment (ROE) History15CREATORUser namenvarchar120
TOPComponent Integration Installation Windows Components
85ECLSTAMPSTable of All Existing Stamps for ECL Viewer5CREATORnvarchar120
TOPCross-Application Components
86/OPT/VPRVendor Portal Registration5CREATORUser Namenvarchar120
87CACNS_PM_PROJEasyProjectMarket22CREATORCACNS: Creator IDnvarchar120
88ETP_TEXTHEADEREasy Task Planning: Texts for Task7CREATORUser Namenvarchar120
TOPData Transfer
89PEVSHHistory of Payroll Posting Runs7CREATORUser namenvarchar120
90PPDSHPayroll Posting Document: Status History7CREATORUser namenvarchar120
TOPDB2 for OS39
91DB2BPTUNEDB2/390: Buffer Pool Tuning Settings1CREATORCreator of BP tuning settings ( = SAP for default settings )nvarchar120
92DB2CCDAILYList of TS/IXS needing utility treatment (DSNACCOR Daily)6CREATORDB2 creator namenvarchar80
93DB2CCDAILYXList of TS/IXS needing utility treatment (DSNACCOX Daily)6CREATORDB2 creator namenvarchar80
94DB2CCHOURList of TS/IXS needing utility treatment (DSNACCOR Hourly)6CREATORDB2 creator namenvarchar80
95DB2DB02EXTENTSTx DB02: Data for DB02's Extent Monitor5CREATORDB2 creator namenvarchar80
96DB2DB02TBDYNTx DB02: Dynamics of the size of tables1CREATORDB2 creator namenvarchar80
97DB2DB02TBTOPGROWTx DB02: Top Twenty of table growth for fast access1CREATORDB2 creator namenvarchar80
98DB2DB02TSDYNTx DB02: Dynamics of the size of tablespaces4CREATORDB2 creator namenvarchar80
99DB2DB02TSSIZETransaction DB02: List of tablespace datasets6CREATORDB2 creator namenvarchar80
100DB2DB02TS_SUMTx DB02: Summary of TS info. Partitions are summed up5CREATORDB2 creator namenvarchar80
101DB2IXBACKList of indexes that need a backup6CREATORDB2 creator namenvarchar80
102DB2JOBJCL Jobs for OS/3902CREATORCreator of the JCL jobnvarchar180
103DB2JSINFHeader Table of JCL Administration2CREATORCreator of the JCL jobnvarchar180
104DB2TSBACKList of tablespaces that need a backup7CREATORDB2 creator namenvarchar80
105DB2TSSIZE_TDB2/390: Storage Information on R/3 Tablespaces4CREATORDB2 creator namenvarchar80
106DBSTAIHDB2DB2/390 Statistics for Indexes2CREATORDB2 creator namenvarchar80
107DBSTATHDB2DB2/390 Statistics for Tables (History)2CREATORDB2 creator namenvarchar80
108DBSTATIDB2DB2/390 Statistics for Indexes2CREATORDB2 creator namenvarchar80
109DBSTATTDB2DB2/390 Statistics for Tables2CREATORDB2 creator namenvarchar80
TOPDocument Management Framework
110SKWF_LOGLogging Table3CREATORCreated Bynvarchar120
TOPE-Recruiting
111HRP5135DB Table for Infotype 513532CREATORUser Namenvarchar120
112HRP5136DB Table for Infotype 513632CREATORUser Namenvarchar120
113HRP5137DB Table for Infotype 513732CREATORUser Namenvarchar120
114HRP5138DB Table for Infotype 513832CREATORUser Namenvarchar120
115HRP5139DB Table for Infotype 513932CREATORUser Namenvarchar120
116HRP5140DB Table for Infotype 514032CREATORUser Namenvarchar120
117HRP5141DB Table for Infotype 514132CREATORUser Namenvarchar120
118HRP5142DB Table for Infotype 514232CREATORUser Namenvarchar120
119HRP5143Database Table for Infotype 514332CREATORUser Namenvarchar120
120HRP5144Database Table for Infotype 514432CREATORUser Namenvarchar120
121HRP5145Database Table for Infotype 514532CREATORUser Namenvarchar120
122HRP9901eQuest Posting Information67CREATORUser Namenvarchar120
TOPGovernance, Risk and Compliance
123GRFNDMLOGDatamart: Central Log7CREATORUser Namenvarchar120
TOPGRC Risk Management
124GRRMVALIDATIONAnalysis Table5CREATORUser Namenvarchar120
TOPKnowledge Management and Collaboration
125CPETASKLOGDatabase table with log information for Ad hoc Workflow3CREATORCharacter 100nvarchar1000
TOPManagement of Internal Controls
126FOPCRBFLOGReporting Buffers: Central Log6CREATORUser Namenvarchar120
TOPMaster Data
127JYT_LOGIS-M: Log4CREATORCreated Bynvarchar120
128JYT_LOG_HEADERIS-M: Log, Header7CREATORCreated Bynvarchar120
TOPMaterial Master
129WRF_HIER_NODESHierarchy Node8CREATORCreated Bynvarchar120
130WRF_HIER_OBJObjects of a Hierarchy8CREATORCreated Bynvarchar120
TOPMonitoring
131SQLRUSERCustomizing Table for SQL Trace Interpreter7CREATORUser Namenvarchar120
132SQLRUSER1User Table for Groups for SQL Trace Interpreter4CREATORUser Namenvarchar120
133SQLRUSER2User Table for Function for SQL Trace Interpreter3CREATORUser Namenvarchar120
TOPMusing Tools
134WDKSNAPSHOTSSnapshops / Serialization5CREATORUser Namenvarchar120
TOPPersonal Object Worklist
135POWL_CATEGORYCategory definition3CREATORUser namenvarchar120
136POWL_QUERYQuery meta data6CREATORUser namenvarchar120
TOPPosition Budgeting and Control
137HRFPM_RUNADMINSHRFPM: Administration Information for Commitment Runs7CREATORUser namenvarchar120
TOPPost Processing Framework
138PPFTBOOKPPF: Book Management (Demo Application)11CREATORUser Namenvarchar120
TOPProcess Controls
139GRPCRBFLOGReporting Buffers: Central Log6CREATORUser Namenvarchar120
TOPProduct Configurator
140COMM_CFGKBRuntime Version of SCE Knowledge Base15CREATORKB Creatornvarchar120
TOPPurchasing
141MMPURUI_CFDOCcFolders ID for Purchasing Documents11CREATORName of Person who Created the Objectnvarchar120
TOPReporting
142T5KR4Record of Employment (ROE) History for Concurrent Employment14CREATORUser namenvarchar120
TOPSales and Distribution
143SCEKBRuntime Version of SCE Knowledge Base9CREATORUser that created a knowledge base versionnvarchar120
144SCEKBOBJKnowledge-Base Object (SCE)7CREATORName of Person who Created the Objectnvarchar120
TOPSAP Business Workflow
145SWLWPTSSIDTask Linkages for WebFlow Services7CREATORUser Namenvarchar120
146SWU5_DYNPChronology of generated program objects10CREATORUser Namenvarchar120
TOPSAP Records Management
147SRMDPDISPCircular6CREATORCircular Created Bynvarchar120
148SRMWFPATHWorkflow Process Route6CREATORName of Process Route Creatornvarchar120
149SRMWFPTHPSProcess Route Item for Workflow11CREATORName of Creator of Process Route Itemnvarchar120
TOPSouth Africa
150T5W63SARS Interface : Run Attributes10CREATORPAYE Reference Numbernvarchar100
151T5W66SARS Interface : PAYE Reference Number Attributes4CREATORIndicator: Registered as Creator at SARSnvarchar10
152T5W72UIF interface: Runs per UIF reference number5CREATORUIF reference numbernvarchar90
TOPStakeholder Relationship Management
153USS_COMP_FIGSKey Figures Related to Company10CREATORSource of Assetnvarchar100
154USS_SHARE_FIGSKey Figure Related to Securities10CREATORSource of Assetnvarchar100
TOPSupplier Managed Inventory
155SMI_PROFILESMI Profile34CREATORName of Person who Created the Objectnvarchar120
TOPThird Party Remittance
156T51R5_HISTRemittance accumulated posting data history10CREATORUser namenvarchar120
TOPUI Services, Screen, Batch Input
157APQIQueue info definition14CREATORQueue user ID / for historical reasonsnvarchar120
158APQLBatch Input Log Directory7CREATORQueue user ID / for historical reasonsnvarchar120
159BDCUSEOPUser-Specific Options for Transaction SM355CREATORQueue user ID / for historical reasonsnvarchar120
TOPUse Subcomponents
160SOODSAPoffice: Object definition89CREATORCreator for MacIntosh-based filesnvarchar40
161SOSTSAPoffice: Status log table27CREATORUser name responsible for creating statusnvarchar120
TOPWithout Description
162KAP_PSR_OBJObject: Element, Sample4CREATORCreated bynvarchar120
TOPWorkbench Tools Editors, Painters, Modelers
163MIME_LOGMIME Repository: Logging Table3CREATORCreated Bynvarchar120