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  | OBJECT_KEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_BUND_LNKBundle Link table to Objects2OBJECT_KEYGUIDvarbinary160
2/ORS/APPR_LOGApproval Log5OBJECT_KEYReference Keynvarchar200
3/ORS/STACK_HDRApproval Stack Header4OBJECT_KEYReference Keynvarchar200
4/SDF/DRM_CONF_DEData Readyness Monitoring - Configuration Details3OBJECT_KEYCharacter String - 32 User-Defined Charactersnvarchar320
5/SDF/DRM_DC_RESData Readyness Monitoring - Data Collection Results3OBJECT_KEYCharacter String - 32 User-Defined Charactersnvarchar320
6/SDF/DRM_RESULTSData Readyness Monitoring - Results3OBJECT_KEYCharacter String - 32 User-Defined Charactersnvarchar320
7/SDF/DRM_RES_DEData Readyness Monitoring - Results Details3OBJECT_KEYCharacter String - 32 User-Defined Charactersnvarchar320
8/SYCLO/MDW00DMobile user client deployment status - last update5OBJECT_KEYDeployment object keynvarchar1000
9/SYCLO/MDW02Syclo Middleware Session Data Object Registry5OBJECT_KEYSyclo middleware object keynvarchar1000
10BBPT_EXCEPTIONEvent Framework - persistent exceptions3OBJECT_KEYGlobally Unique identifiervarbinary160
11BDS_BAR_IN_REFReference Structure for BDS_BAR_IN3OBJECT_KEYBusiness Document Service: Object keynvarchar700
12BDS_CON019BDS: Link Table6OBJECT_KEYBusiness Document Service: Object keynvarchar700
13CNVMBTCHKLOGCHKCheck Framework: Log Check Executions4OBJECT_KEYCheck Framework: Object Keynvarchar640
14CNVMBTCHKLOGCHKOCheck Framework: Data Objects of Check Executions4OBJECT_KEYCheck Framework: Object Keynvarchar640
15CNVMBTCHKLOGCHKPCheck Framework: Parameters of Check Executions4OBJECT_KEYCheck Framework: Object Keynvarchar640
16GRFNATAudit Trail Framework data repository4OBJECT_KEYTable Keynvarchar1200
17SQSC_RIS_INDEXSQSC Index Table for Repository Information System3OBJECT_KEYWB Request: Key for Object in Development Environmentnvarchar1800
18STORE_SOHBATSohbat: table for CRUD services (internal use only !)3OBJECT_KEYUUID in character formnvarchar320
19VISITOR_TRACKERSohbat: table for CRUD services (internal use only !)3OBJECT_KEYnvarchar640
20ZDPR_OBJLINKObject link data storage for DPR10OBJECT_KEYKey of the linked objectnvarchar2550
21ZRPM_OBJ_LINKObject link data storage6OBJECT_KEYKey of the linked objectnvarchar2550
TOPBusiness Document Service
22BDS_BAR_INBusiness Document Service: Internal Bar Codes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
23BDS_CONN00BDS: Client-Specific Link Tables6OBJECT_KEYBusiness Document Service: Object keynvarchar700
24BDS_CONN01BDS: Client-Independent Link Tables5OBJECT_KEYBusiness Document Service: Object keynvarchar700
25BDS_CONN02BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
26BDS_CONN03BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
27BDS_CONN04BDS: Client-Specific Link Tables6OBJECT_KEYBusiness Document Service: Object keynvarchar700
28BDS_CONN05BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
29BDS_CONN06BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
30BDS_CONN07BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
31BDS_CONN08BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
32BDS_CONN09BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
33BDS_LOGBDS: Protocol Table for Accesses to BDS Documents6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPBusiness Information Collection
34BDS_CONN23BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPBusiness Partner
35FSBP_CC_IMAGETable for CC Image Data5OBJECT_KEYKey Parametersnvarchar1200
36FSBP_INFMSG_LOGPersistency for Identifying Transferred BP Changes5OBJECT_KEYKey Parametersnvarchar1200
37TXO_CLUSTERObsolete3OBJECT_KEYnvarchar320
38TXO_CLUSTER_MOObsolete3OBJECT_KEYnvarchar320
39TXO_GEN_DBXO-User-Specific Generic Database Table4OBJECT_KEYKey Parametersnvarchar1200
TOPBusiness Planning and Simulation
40BDS_CONN22BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
41BDS_CONN31BDS: Link Table Default for Undefined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPClaims Management
42TICL345Office Integration Business Object Cat. -> Corresp.Templates6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPClient-System Adapter
43MDMFDBEVENTMDM: Message inbound events4OBJECT_KEYchar120nvarchar1200
44MDM_DISTR_XLOGMDM : Request Logging5OBJECT_KEYMDM: External object key.nvarchar1200
TOPContract Accounts Receivable and Payable
45FKK_FDT_EXPR000BFR/BPEM case expression C table7OBJECT_KEYObject keynvarchar700
46FKK_FDT_EXPR000ABFR/BPEM case expression table A7OBJECT_KEYObject keynvarchar700
47FKK_FDT_EXPR000SBFR/BPEM case expression table S6OBJECT_KEYObject keynvarchar700
48FKK_FDT_EXPR000TBFR/BPEM case expression table T6OBJECT_KEYObject keynvarchar700
TOPControlling
49BDS_CONN24BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPCorporate Performance Monitor
50BDS_CONN15BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
51BDS_CONN17BDS: Link Table Default for Undefined Class5OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPCross-Application Components
52/IXOS/DC_TBLOCKLock table for asynchron scenarios3OBJECT_KEYSAP ArchiveLink: Object ID (object identifier)nvarchar500
53CFX_OBJ_EXP_DATELast export detail of the object2OBJECT_KEYObject Key to set export datenvarchar1000
TOPData Replication Framework
54MDGD_CPMDG Change Pointer12OBJECT_KEYObject valuenvarchar900
TOPDocument Management Framework
55SKWF_TRANSShadow Table for Namespace Transport2OBJECT_KEYID for documents and relationsnvarchar320
TOPDocument Management System
56DMS_DOC_FOLDER3DMS: Folder for documents (structure)4OBJECT_KEYDocument management object keynvarchar500
TOPEnd User Technology
57BDS_CONN111BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPFramework for the Principle of Dual Control
58BCA_REL_LOG_HHeader Data of Log Table for Release4OBJECT_KEYObject Key (Chain of Object Key Fields)nvarchar700
TOPGovernance, Risk and Compliance
59GRFNATFAudit Trail Framework data repository4OBJECT_KEYTable Keynvarchar1200
TOPHR Administrative Services
60POBJD_OBJECTSObjects run for process object4OBJECT_KEYChar255nvarchar2550
61T5ASRPROCESSESHR Administrative Services: Processes10OBJECT_KEYObject Keynvarchar320
TOPInformation Quality Management
62SIQMKEYSObject Key (Information Quality)2OBJECT_KEYHash Value: Objectnvarchar420
63SIQMOBJECTSObject Type (Information Quality)2OBJECT_KEYHash Value: Objectnvarchar420
64SIQMRESULTSInformation Quality Results (Main Table)7OBJECT_KEYHash Value: Objectnvarchar420
TOPLaunchpad
65BDS_CONN24ABDS: Linkage Default for non-defined Classes6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPMaintenance Orders
66/MRSS/D_ADDRESSStores Primary/Secondary address2OBJECT_KEYGUIDvarbinary160
TOPMass Load
67MDGD_OBJ_STATUSMDG Data Load Object Processing Status5OBJECT_KEYObject Keysnvarchar1200
TOPMaster Data
68JYT_LOG_HEADERIS-M: Log, Header4OBJECT_KEYIS-M: Log, Object Keynvarchar500
69JYT_LOG_ITEMIS-M: Log, Item4OBJECT_KEYIS-M: Log, Object Keynvarchar500
TOPMaterial Master
70EANC_GLN_MAPPGLN - R/3 Mapping Table3OBJECT_KEYKey of R/3 Object Identified by an ILNnvarchar300
TOPMonitoring
71SCMC_CACHE_CHGLogging of All Deleted/New Cache Entries1OBJECT_KEYKey for Cache Entriesvarbinary160
72SCMC_NODEBasic Data of Executed Monitors1OBJECT_KEYKey for Cache Entriesvarbinary160
73SCMC_NODE_MSCAdditional Attributes for Message Container Nodes1OBJECT_KEYKey for Cache Entriesvarbinary160
74SCMC_NODE_PERFAdditional Attributes for Performance Nodes1OBJECT_KEYKey for Cache Entriesvarbinary160
75SCMC_NODE_SMESAdditional Attributes for Log Nodes1OBJECT_KEYKey for Cache Entriesvarbinary160
TOPObject Links
76DPR_OBJLINKObject Link10OBJECT_KEYLinked Object Keyntext10737418230
TOPPatient Management
77N1TC_ACCESS_LOGLog of Access to Treatment Contracts Applied for9OBJECT_KEYObject Keynvarchar2550
TOPPeople Centric UI Framework
78CRM_BSP_LIST_OBJCRM PCUI List Objects and Attributes3OBJECT_KEYObject Keynvarchar1000
TOPPeople Centric UI Framework Customizing
79CRMC_BL_FAVORITEApplication Scenario: User Favorites6OBJECT_KEYObject Keynvarchar1000
TOPPortfolio Management
80/RPM/OBJ_MIGRDocuments, which xRPM 2.0 objects were migrated3OBJECT_KEYCommentnvarchar500
81RPM_DOCUMENTDocument data storage5OBJECT_KEYKey to the attached documentntext10737418230
82RPM_OBJ_LINKObject link data storage6OBJECT_KEYKey of the linked objectntext10737418230
83RPM_OBJ_LINK_CDObject links - Pseudo table for change documents6OBJECT_KEYKey of the linked objectntext10737418230
TOPProcess Management
84BDS_CONN25BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPProduction and Revenue Accounting
85OIUT2_INTDObsolete: Ownership Interface Detail5OBJECT_KEYObject Keynvarchar300
TOPProfitability Analysis
86TKE_ALE_SCEN_OBJRKE_ALE Sender Objects4OBJECT_KEY30 Charactersnvarchar300
TOPReal Estate Management
87BDS_CONN26BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPRecords and Case Management
88RMPS_AI_SESSSave Session5OBJECT_KEYObject keynvarchar700
TOPSAP Business Workflow
89BDS_CON020BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
90SWN_TIMESTAMPSWF Notif: Time Stamp2OBJECT_KEYObject Key (for Table swn_timestamps)nvarchar1280
TOPSAP GUI for Windows Controls
91BDS_CONN14BDS: Client-Specific Link Tables6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPSAP List Viewer
92BDS_CONN16BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPSAPscript
93BDSX_CON04BDS link5OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPStakeholder Relationship Management
94BDS_CON028BDS: Link Table Default for Undefined Class6OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPTransaction Variant and Table Control Settings
95BDS_CONN21BDS: Link Table Default for Undefined Class5OBJECT_KEYBusiness Document Service: Object keynvarchar700
TOPWithout Description
96BDS_CONN18BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700
97BDS_CONN20BDS: Link Table Default for Undefined Classes5OBJECT_KEYBusiness Document Service: Object keynvarchar700