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

47 columns | Print definition?ERP 6.0  | CR_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBT09INDEXAll indexes they are not on the database6CR_DATEALE Customizing Distribution: Creation Datenvarchar80
2CNVTDMS_09_INDEXAll indexes they are not on the database6CR_DATEALE Customizing Distribution: Creation Datenvarchar80
3EBILLPRGIS-U: Billing Programs11CR_DATEDate on Which Record Was Creatednvarchar80
4ECONDIPROCINTFIS-U: Processing Interface for Conditions11CR_DATEDate on Which Record Was Creatednvarchar80
5ESCHEXTBilling Schema Extension (Administrative Data)3CR_DATEDate on Which Record Was Creatednvarchar80
6ETOUEXCEPTIONTOU Exception13CR_DATEDate on Which Record Was Creatednvarchar80
7ETOUEXCEPTRESPTOU Exception Response6CR_DATEDate on Which Record Was Creatednvarchar80
8ETOUEXCPTPRGTOU Exception Program12CR_DATEDate on Which Record Was Creatednvarchar80
9LOP_D_LIST_HDOption list header36CR_DATEDate on Which Record Was Creatednvarchar80
10LOP_D_LIST_ITOption list items9CR_DATEDate on Which Record Was Creatednvarchar80
11LOP_D_MASTER_HDOption list header as master data12CR_DATEDate on Which Record Was Creatednvarchar80
12LOP_D_MASTER_ITOption List items as master data9CR_DATEDate on Which Record Was Creatednvarchar80
TOPAMI Event Management
13TEAMI_EM_EVTRESResults for AMI Events10CR_DATEDate on Which Record Was Creatednvarchar80
14TEAMI_EM_EVTSIS-U AMI Event Management AMI Events14CR_DATEDate on Which Record Was Creatednvarchar80
TOPAnalyzer
15AFWBM_CALC_PROTAdministration of Authorization for Benchmarks9CR_DATECreated Onnvarchar80
16AFWBM_DEL_ADMDeleted Objects from PAEPBM as a Worklist4CR_DATECreated Onnvarchar80
17AFWGO_CALCADMINManagement of Analysis Runs for Each Eval. Proc. 26CR_DATECreated Onnvarchar80
18AFWGO_LOADADMINManagement of Single Records Procedures per Date9CR_DATECreated Onnvarchar80
19AFWGO_LOGHISTORYHistory of Application Logs in Single Records Procedure8CR_DATECreated Onnvarchar80
TOPBank Customer Accounts
20RTP_US_PLANRetirement plan data (US enhancement)21CR_DATEDate creatednvarchar80
TOPClinical System
21N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces11CR_DATEIS-H: Date when Record Creatednvarchar80
22N2DSDEVICE_DATAISHMED: Transfer Data from Interface11CR_DATEIS-H: Date when Record Creatednvarchar80
TOPCollateral Management System
23CMS_PCN_CRChange Requests11CR_DATEDate on which Change Request was Sent or Receivednvarchar80
TOPCross-Application Components
24BC430_DSStatus of Sample Data for BC4302CR_DATEnvarchar80
TOPCross-Application Topics
25/SPE/CD_DOCFLOWDocument Flow for Transportation Cross-Docking5CR_DATEDate on Which Record Was Creatednvarchar80
TOPGlobal Trade
26WB2_D_ASGT_DISTAssignment distributions9CR_DATEDate on Which Record Was Creatednvarchar80
27WB2_D_ASSGMTAssignments19CR_DATEDate on Which Record Was Creatednvarchar80
28WB2_D_COMSUBTrading Contract: commodity sub items13CR_DATEDate on Which Record Was Creatednvarchar80
29WB2_D_PRASPTrading Contract: pricing aspects19CR_DATEDate on Which Record Was Creatednvarchar80
30WB2_D_SHD_ITEMShadow Items23CR_DATEDate on Which Record Was Creatednvarchar80
31WB2_D_SHD_PRASPPricing aspects of shadow items16CR_DATEDate on Which Record Was Creatednvarchar80
TOPInformation System
32T803JReport Writer: Report Groups5CR_DATECreation datenvarchar80
TOPIntercompany Data Exchange
33TINV_INV_TMPLTBill Document: Template8CR_DATEDate record created onnvarchar80
TOPLogistics Basic Data
34MASS_JOB_ERRORMass Maintenance Cluster for Error Recover7CR_DATEDate in CHAR formatnvarchar80
TOPSAP Utilities
35ISU_WUI_DOC_FLTRDocument filter criteria for user10CR_DATEDate on Which Record Was Creatednvarchar80
36TEAMI_LOG_DATALog for Service Communication in AMI Environment20CR_DATEDate on Which Record Was Creatednvarchar80
37TEAMI_MSGMessages11CR_DATECreation Date of Messagenvarchar80
TOPTrading Contract
38PPE_D_ITEM_LISTEvents17CR_DATEDate on Which Record Was Creatednvarchar80
TOPTransaction Manager
39THAHRT_EXT_RETROExternal Retrospective Assessment7CR_DATEDate stamp: system date when valuation is executednvarchar80
40THMHRT_EXT_PROSExternal Prospective Assessment7CR_DATEDate stamp: system date when valuation is executednvarchar80
41THMHRT_HR_VALValuation details for the hedging relationship8CR_DATEDate stamp: system date when valuation is executednvarchar80
42TPMHRT_EXT_RETROExternal Retrospective Assessment7CR_DATEDate stamp: system date when valuation is executednvarchar80
TOPTransaction Tax Engine
43TTEC_DT_DATADecision Tree Data6CR_DATECreation Datenvarchar80
TOPTranslation Tools
44LXE_KEY_VALUEProperties4CR_DATESystem Datenvarchar80
45LXE_KW_TRANSLKW folders defined for translation9CR_DATESystem Datenvarchar80
TOPWeb Survey
46TUWS_SURVEY_LOGSurvey Log16CR_DATESystem Datenvarchar80
47TUXX_COND_VALResults of Conditions on XML Documents11CR_DATESystem Datenvarchar80