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

52 columns | Print definition?ERP 6.0  | CREATED_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_DLVY_HDRDelivery9CREATED_TIMECreation Timenvarchar60
2/GBT/O_HU_HDRHandling Unit Master - Header table9CREATED_TIMECreation Timenvarchar60
3/GBT/O_MDOC_HDRMaterial Document9CREATED_TIMECreation Timenvarchar60
4/GBT/O_PORD_HDRProduction Order for Tracking11CREATED_TIMECreation Timenvarchar60
5/GBT/O_PURO_HDRPurchasing Document9CREATED_TIMECreation Timenvarchar60
6/GBT/O_SALO_HDRSales Document9CREATED_TIMECreation Timenvarchar60
7/OTX/RM_ERRORQArchiveLink entries whose RM processing failed11CREATED_TIMEError Queue entry creation timenvarchar60
8/OTX/RM_ERRORQPLPrintlist entries whose RM processing failed21CREATED_TIMEError Queue entry creation timenvarchar60
9/OTX/RM_WSC_ERRQECM Workspace Error Queue8CREATED_TIMEError Queue entry creation timenvarchar60
10CNVMBTATTACHMENTAttachments8CREATED_TIMEField of type TIMSnvarchar60
11GRFNPOLICYVERDB table for policy version information in policy management13CREATED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
12HRHAPCN_OBJ_LOGObject Library: Action Log - Additional Data9CREATED_TIMESystem Timenvarchar60
13SNHI_DU_PROXYHANA Integration: Proxy for a HANA Delivery Unit5CREATED_TIMEField of type TIMSnvarchar60
14TSIW_TEST_CLDEPClient-Dependent Test Table for SIW Mass TABU Producer10CREATED_TIMETest Timestamp SIW Table Entry Producerdecimal217
15ZTRM_MIRRORSTRM: Mirror Transactions10CREATED_TIMESystem Timenvarchar60
TOPAppraisal, Valuation, and Survey Tool
16HRHAP_ACT_LOGAppraisal Document: Action Log - Additional Data7CREATED_TIMESystem Timenvarchar60
TOPBalanced Scorecard
17UMB_EBB_STRUCBriefing Book Structure6CREATED_TIMECreated ondecimal150
TOPBasic Functions
18BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases19CREATED_TIMECreation Timenvarchar60
19EMMAC_CCAT_HDRClarification Case Categories21CREATED_TIMECreation Timenvarchar60
20EMMA_CASEClarification Case29CREATED_TIMECreation Timenvarchar60
TOPCross-Application Components
21/OPT/VPRVendor Portal Registration7CREATED_TIMETimenvarchar60
TOPGRC Risk Management
22GRRMSCENARIOCASEScenario Case Analysis10CREATED_TIMETime Stampdecimal150
23GRRMSCENARIOCLSFScenario Classification8CREATED_TIMETime Stampdecimal150
TOPLocal Event Infrastructure
24SLEI_LNKGLEI Linkages - Cross client13CREATED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25SLEI_LNKG_CLEI Linkages - Client specific15CREATED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMaintenance Orders
26/MRSS/D_SQM_KHQualification Catalog: Header Data11CREATED_TIMETime of initial entrynvarchar60
27/MRSS/D_SQM_MHQualification Matrix9CREATED_TIMETime of initial entrynvarchar60
TOPManagement of Internal Controls
28FOPCDEFICSELMIC: Selection Conditions for Deficiency Analysis20CREATED_TIMECreated Ondecimal150
TOPProcess Controls
29GRPCAODINFOaod infos8CREATED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
30GRPCDEFICSELPC: Selection Conditions for Deficiency Analysis20CREATED_TIMECreated Ondecimal150
TOPProcess Orchestration for Built-In Processes
31POC_C_PROC_CHNGEProcess Definition: Create and Change Information5CREATED_TIMECreated At (UTC)decimal217
TOPReal Estate
32CMS_RE_OBJReal estate header details27CREATED_TIMECreated Atnvarchar60
33CMS_RE_OBJ_BPLink between Real estate objects and BuPa is stored here10CREATED_TIMECreated Atnvarchar60
34CMS_RE_OBJ_DOCLink between Real estate objects and Doc is stored here7CREATED_TIMECreated Atnvarchar60
35CMS_RE_OBJ_PRTReal Estate Object part details106CREATED_TIMECreated Atnvarchar60
36CMS_RE_OBJ_RLReal Estate Object role details7CREATED_TIMECreated Atnvarchar60
37CMS_RE_OBJ_SPCSpace Details to describe a real estate object22CREATED_TIMECreated Atnvarchar60
38CMS_RE_PRT_ACSReal Estate Part accessory details31CREATED_TIMECreated Atnvarchar60
39CMS_RE_PRT_BPReal Estate Part BP details13CREATED_TIMECreated Atnvarchar60
40CMS_RE_PRT_CSTReal Estate Part Cost details21CREATED_TIMECreated Atnvarchar60
41CMS_RE_PRT_DOCReal Estate Document details13CREATED_TIMECreated Atnvarchar60
42CMS_RE_PRT_LRReal Estate Part LR details8CREATED_TIMECreated Atnvarchar60
43CMS_RE_PRT_VALReal Estate Part value details16CREATED_TIMECreated Atnvarchar60
TOPRecipe Development
44/PLMB/RCP_MDL_HDRecipe Model Header9CREATED_TIMETime at Which Object (Item) Was Creatednvarchar60
45/PLMB/RCP_MDL_RLRecipe Model Table for Rules10CREATED_TIMETime at Which Object (Item) Was Creatednvarchar60
TOPRecords and Case Management
46RMPS_T_RESUBResubmissions (new)10CREATED_TIMECreated Ondecimal150
TOPSecurities
47CMS_SEC_ACCSecurities account details35CREATED_TIMECreated Atnvarchar60
48CMS_SEC_ACC_BPLink between securities account and BuPa is stored here12CREATED_TIMECreated Atnvarchar60
49CMS_SEC_ACC_DOCLink between securities account and Documents is stored here12CREATED_TIMECreated Atnvarchar60
50CMS_SEC_ACC_POSSecurities position details32CREATED_TIMECreated Atnvarchar60
TOPSoftware Agent Framework
51CRMD_EI_LANG_SAPSAF: Knowldge base entity information for SAP data sources12CREATED_TIMESAF - Timenvarchar60
TOPWaste Management
52EWA_EL_DELVRYBANDelivery Lock11CREATED_TIMETime Creatednvarchar60