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

56 columns | Print definition?ERP 6.0  | FOLDER_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/T_FF_DCSUBSubfolders in DocuLink folder structure view7FOLDER_IDFolder IDnvarchar30
2/OTEI/T_FF_DCTOPTopfolders in DocuLink folder structure view7FOLDER_IDFolder IDnvarchar30
3/OTEI/T_FF_SUBFlexible folder structure subfolder3FOLDER_IDFolder IDnvarchar30
4/OTEI/T_FF_SUBDTFlexible folder structure subfolder document types3FOLDER_IDFolder IDnvarchar30
5/OTEI/T_FF_SUBTFlexible folder structure subfolders3FOLDER_IDFolder IDnvarchar30
6/OTEI/T_FF_TOPFlexible folder structure top level folders3FOLDER_IDFolder IDnvarchar30
7/OTEI/T_FF_TOPDTFlexible folder structure top level folder document types3FOLDER_IDFolder IDnvarchar30
8/OTEI/T_FF_TOPTFlexible folder structure top level folder texts3FOLDER_IDFolder IDnvarchar30
9/SAPPSSRM/FLDR_DDefinition of the folders2FOLDER_IDFolder ID for Multi-Envelope RFx Responsenvarchar60
10/SAPPSSRM/FLDR_TText table for the folder definition2FOLDER_IDFolder ID for Multi-Envelope RFx Responsenvarchar60
11/SAPPSSRM/RL_AUTDefine the Collaboration folder Authorizations for the roles4FOLDER_IDFolder ID for Multi-Envelope RFx Responsenvarchar60
12/SAPPSSRM/SEF_DRelationship between envelope, folde and the Schema4FOLDER_IDFolder ID for Multi-Envelope RFx Responsenvarchar60
13/SAPPSSRM/TD_CCollaboration Folder ID3FOLDER_IDFolder ID of the cFolders Collaborationnvarchar320
14BBPC_MENV_FLDRMulti Envelope Bidding: Folder Definitions2FOLDER_IDMulti-Envelope RFx Response: Folder IDnvarchar150
15BBPC_MENV_FLDR_TMulti Envelope Bidding: Folder Type Text Table2FOLDER_IDMulti-Envelope RFx Response: Folder IDnvarchar150
16BBPC_MENV_RL_AUTMulti Envelope Bidding: Folder role authorization4FOLDER_IDMulti-Envelope RFx Response: Folder IDnvarchar150
17BBPC_MENV_SCHFLDMulti Envelope Bidding: Relation between envelope and folder4FOLDER_IDMulti-Envelope RFx Response: Folder IDnvarchar150
TOPBusiness Consolidation
18UCFTL00Data Collection: Overview Screen8FOLDER_IDCharacteristic Valuenvarchar450
TOPBusiness Package for Manager Self-Service FI
19FPB_LP6_FOL_TTexts for Folders3FOLDER_IDFour-digit numbernvarchar40
20FPB_LP6_FOL_UTTexts for Folder for User3FOLDER_IDFour-digit numbernvarchar40
21FPB_LP6_F_R_CFolder <---> Reports Assignment3FOLDER_IDFour-digit numbernvarchar40
22FPB_LP6_F_R_UCFolder <---> Reports Assignment3FOLDER_IDFour-digit numbernvarchar40
23FPB_LP6_O_F_CContexts <--> Folder Assignment3FOLDER_IDFour-digit numbernvarchar40
24FPB_LP6_O_F_UCContexts <--> Folder for User Assignment3FOLDER_IDFour-digit numbernvarchar40
TOPCollaboration Folders
25CFX_FOLCollaboration Folders: Folder2FOLDER_IDFolder IDvarbinary160
TOPCollaborative Cross Applications
26/POA/D_CLM_IODICDictionary of IO files and objects for CLM2FOLDER_IDID in Content Lifecycle Managementint100
27/POA/D_CLM_PG03Database table strores the package archive in binary form4FOLDER_IDID in Content Lifecycle Managementint100
TOPConfiguration management
28TCM_BASELINEBaseline data (Configuration Management)2FOLDER_IDConfiguration foldernvarchar400
29TCM_BASELINETText table for Baseline description2FOLDER_IDConfiguration foldernvarchar400
30TCM_PFOLDERConfiguration Folder (Configuration Management)2FOLDER_IDConfiguration foldernvarchar400
31TCM_PF_CONTTable for data container for product folder (Conf. Mgmt)2FOLDER_IDConfiguration foldernvarchar400
32TCM_PF_CONTTText table for description for configuration folders2FOLDER_IDConfiguration foldernvarchar400
33TCM_WORKLISTWorklist for the CM user3FOLDER_IDConfiguration foldernvarchar400
TOPCross-Application Components
34CFX_OBJ_EXP_DATELast export detail of the object7FOLDER_IDUUID in character formnvarchar320
TOPDocument Management System
35DMS_DOC_FOLDER1DMS: Folder for documents (Header)2FOLDER_IDGUID for Doc. Foldernvarchar320
36DMS_DOC_FOLDER2DMS: Folder for documents (descirptions)2FOLDER_IDGUID for Doc. Foldernvarchar320
37DMS_DOC_FOLDER3DMS: Folder for documents (structure)2FOLDER_IDGUID for Doc. Foldernvarchar320
38DMS_DOC_FOLDER4Determine All Subscribed Root Folders1FOLDER_IDGUID for Doc. Foldernvarchar320
TOPKnowledge Warehouse
39IWBKMIGStatistics for keyword migration2FOLDER_IDID for documents and relationsnvarchar320
40KWDEL_HEADContent Deletion Report: History3FOLDER_IDID for documents and relationsnvarchar320
TOPProcess Controls
41GRPCNWBCFDRFolders2FOLDER_IDFolder IDnvarchar100
42GRPCNWBCFDRTFolder Texts3FOLDER_IDFolder IDnvarchar100
43GRPCNWBCLINKLinks8FOLDER_IDFolder IDnvarchar100
TOPProcess Management
44CMX_XSR_DB_FOLDStandard Execution Step Repository: Folder2FOLDER_IDXSteps: Unique ID of a Nodenvarchar220
45CMX_XSR_DB_FOLDTStandard Execution Step Repository: Texts for Folder2FOLDER_IDXSteps: Unique ID of a Nodenvarchar220
TOPProduct Data Management
46CEP_REVFOL_STATStatus Administration for Review Folder1FOLDER_IDObject numbernvarchar220
TOPProduct Structure Browser
47USROBJECTSTable of Previous Initial Object in Structure Overview23FOLDER_IDConfiguration foldernvarchar400
TOPPurchasing
48WRFT_ACTFLDKeys of Activity Folders2FOLDER_IDKey of an Activity Foldernvarchar80
49WRFT_ACTFLDTText Table for Activity Folder2FOLDER_IDKey of an Activity Foldernvarchar80
50WRF_PRCT_WL_ITEMOriginal Table for Worklist Items6FOLDER_IDKey of an Activity Foldernvarchar80
51WRF_PRCT_WL_SHDWShadow Table for Worklist Items9FOLDER_IDKey of an Activity Foldernvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
52MIME_LOGMIME Repository: Logging Table8FOLDER_IDID for documents and relationsnvarchar320
TOPWorkflow Modeler
53SWFMOD_COMP_TMPLTemplates and components for the workflow modeler4FOLDER_IDFolder unique identification number GUIDnvarchar320
54SWFMOD_FOLDERFolders for components, templates and user workflows2FOLDER_IDFolder unique identification number GUIDnvarchar320
55SWFMOD_FOLDERTFolder text2FOLDER_IDFolder unique identification number GUIDnvarchar320
56SWFMOD_USER_WKFLUser specific workflows (created in modeler)5FOLDER_IDFolder unique identification number GUIDnvarchar320