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

44 columns | Print definition?ERP 6.0  | CHANGED_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/O_DLVY_HDRDelivery12CHANGED_TIMEChange Timenvarchar60
2/GBT/O_HU_HDRHandling Unit Master - Header table12CHANGED_TIMEChange Timenvarchar60
3/GBT/O_MDOC_HDRMaterial Document12CHANGED_TIMEChange Timenvarchar60
4/GBT/O_PORD_HDRProduction Order for Tracking14CHANGED_TIMEChange Timenvarchar60
5/GBT/O_PURO_HDRPurchasing Document12CHANGED_TIMEChange Timenvarchar60
6/GBT/O_SALO_HDRSales Document12CHANGED_TIMEChange Timenvarchar60
7/XFT/DIO_MON_AM1Alert Management: Local Settings for Process Type6CHANGED_TIMEField of type TIMSnvarchar60
8/XFT/DIO_MON_PTPJob Process: Local Settings for Process Type - Deactivation6CHANGED_TIMEField of type TIMSnvarchar60
9/XFT/DIO_MON_PTZJob Process: Local Setting Proc. Type - Execution Timeframe8CHANGED_TIMEField of type TIMSnvarchar60
10BBP_SUPP_MONIVendor Monitor for Changed Data14CHANGED_TIMETime of Last Changenvarchar60
11CNVMBTACTGRPActivity Groups8CHANGED_TIMEdecimal150
12CNV_10993_FORMRSResult table for Forms21CHANGED_TIMEtime of last changednvarchar60
13CNV_10993_RESHDRCoding Scan Result header table18CHANGED_TIMEtime of last changednvarchar60
14CNV_10993_RESULTCoding Scan 10993 Search Run Result Table17CHANGED_TIMESearch timenvarchar60
15GRFNAEAudit Entity16CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
16GRFNAE_BKAudit Entity History12CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
17GRFNAPAudit Plan Proposal10CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18GRFNAPLOGAudit Plan Proposal Transfer Log11CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19GRFNAUAudit Proposal16CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20GRFNAULOGAudit Proposal Transfer Log17CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21GRFNPOLICYVERDB table for policy version information in policy management15CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
22RLFW_RUNLEVELStable with historic runlevels1CHANGED_TIMEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
23SNHI_DU_PROXYHANA Integration: Proxy for a HANA Delivery Unit8CHANGED_TIMEField of type TIMSnvarchar60
24TBAC_DCSDerivative contract specification customizing table11CHANGED_TIMELast Changed atnvarchar60
TOPBalanced Scorecard
25UMB_EBB_STRUCBriefing Book Structure8CHANGED_TIMEChanged ondecimal150
TOPBasic Functions
26BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases22CHANGED_TIMELast changed atnvarchar60
27EMMAC_CCAT_HDRClarification Case Categories24CHANGED_TIMELast changed atnvarchar60
28EMMA_CASEClarification Case32CHANGED_TIMELast changed atnvarchar60
TOPBusiness Package for Manager Self-Service FI
29FPB_GEN_PROF_LOGLog Entries for Generating Authorizations11CHANGED_TIMELocal Timenvarchar60
TOPLocal Event Infrastructure
30SLEI_LNKGLEI Linkages - Cross client17CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
31SLEI_LNKG_CLEI Linkages - Client specific19CHANGED_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPMaintenance Orders
32/MRSS/D_SQM_KHQualification Catalog: Header Data14CHANGED_TIMETime last change was madenvarchar60
33/MRSS/D_SQM_MHQualification Matrix12CHANGED_TIMETime last change was madenvarchar60
TOPMarket Risk Analyzer
34TCCT_CCURVE_FUTCommodity Curve Futures Style Master Data11CHANGED_TIMETime changednvarchar60
35TCCT_CCURVE_MASTCommodity Curve Master Data30CHANGED_TIMETime changednvarchar60
TOPProcess Orchestration for Built-In Processes
36POC_C_PROC_CHNGEProcess Definition: Create and Change Information7CHANGED_TIMEChanged At (UTC)decimal217
TOPRecipe Development
37/PLMB/RCP_MDL_HDRecipe Model Header11CHANGED_TIMETime at Which Object (Item) Was Changednvarchar60
38/PLMB/RCP_MDL_RLRecipe Model Table for Rules12CHANGED_TIMETime at Which Object (Item) Was Changednvarchar60
TOPRecords and Case Management
39RMPS_RESUBResubmission - Additional Fields Public Sector5CHANGED_TIMELast Changed Ondecimal150
40RMPS_T_RESUBResubmissions (new)12CHANGED_TIMELast Changed Ondecimal150
TOPTools
41HRPYO_D_STATSCHNReason for status change4CHANGED_TIMESystem Timenvarchar60
TOPTransaction Management
42TCHT_HD_SFGDTSFGDT Representation of Instruments23CHANGED_TIMETime changednvarchar60
TOPTransaction Manager
43TRCOT_CTY_MASTERCommodity master data18CHANGED_TIMETime changednvarchar60
TOPTreasury
44ATCOVOCommodity Price Volatilities9CHANGED_TIMETime changednvarchar60