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

43 columns | Print definition?ERP 6.0  | CR_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/UI2/CACHECache for storing query results (collections and entities)13CR_TIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
2CNVMBT09INDEXAll indexes they are not on the database7CR_TIMEnvarchar60
3CNVTDMS_09_INDEXAll indexes they are not on the database7CR_TIMEnvarchar60
4EBILLPRGIS-U: Billing Programs12CR_TIMEEntry timenvarchar60
5ECONDIPROCINTFIS-U: Processing Interface for Conditions12CR_TIMEEntry timenvarchar60
6ESCHEXTBilling Schema Extension (Administrative Data)4CR_TIMEEntry timenvarchar60
7ETOUEXCEPTIONTOU Exception14CR_TIMEEntry timenvarchar60
8ETOUEXCEPTRESPTOU Exception Response7CR_TIMEEntry timenvarchar60
9ETOUEXCPTPRGTOU Exception Program13CR_TIMEEntry timenvarchar60
10LOP_D_LIST_HDOption list header37CR_TIMETime, at Which Record Was Addednvarchar60
11LOP_D_LIST_ITOption list items10CR_TIMETime, at Which Record Was Addednvarchar60
12LOP_D_MASTER_HDOption list header as master data13CR_TIMETime, at Which Record Was Addednvarchar60
13LOP_D_MASTER_ITOption List items as master data10CR_TIMETime, at Which Record Was Addednvarchar60
TOPAMI Event Management
14TEAMI_EM_EVTRESResults for AMI Events11CR_TIMEEntry timenvarchar60
15TEAMI_EM_EVTSIS-U AMI Event Management AMI Events15CR_TIMEEntry timenvarchar60
TOPAnalyzer
16AFWBM_CALC_PROTAdministration of Authorization for Benchmarks10CR_TIMEEntry Timenvarchar60
17AFWBM_DEL_ADMDeleted Objects from PAEPBM as a Worklist5CR_TIMEEntry Timenvarchar60
18AFWGO_CALCADMINManagement of Analysis Runs for Each Eval. Proc. 27CR_TIMEEntry Timenvarchar60
19AFWGO_LOADADMINManagement of Single Records Procedures per Date10CR_TIMEEntry Timenvarchar60
20AFWGO_LOGHISTORYHistory of Application Logs in Single Records Procedure9CR_TIMEEntry Timenvarchar60
TOPBank Customer Accounts
21RTP_US_PLANRetirement plan data (US enhancement)22CR_TIMETime creatednvarchar60
TOPClinical System
22N2DSDEVICE_ARCHISHMED: Archive Transfer Data from Interfaces12CR_TIMEIS-H: Time Record Creatednvarchar60
23N2DSDEVICE_DATAISHMED: Transfer Data from Interface12CR_TIMEIS-H: Time Record Creatednvarchar60
TOPCross-Application Components
24BC430_DSStatus of Sample Data for BC4303CR_TIMEnvarchar60
TOPCross-Application Topics
25/SPE/CD_DOCFLOWDocument Flow for Transportation Cross-Docking6CR_TIMEEntry timenvarchar60
TOPGlobal Trade
26WB2_D_ASGT_DISTAssignment distributions10CR_TIMETime, at Which Record Was Addednvarchar60
27WB2_D_ASSGMTAssignments20CR_TIMETime, at Which Record Was Addednvarchar60
28WB2_D_COMSUBTrading Contract: commodity sub items14CR_TIMETime, at Which Record Was Addednvarchar60
29WB2_D_PRASPTrading Contract: pricing aspects20CR_TIMETime, at Which Record Was Addednvarchar60
30WB2_D_SHD_ITEMShadow Items24CR_TIMETime, at Which Record Was Addednvarchar60
31WB2_D_SHD_PRASPPricing aspects of shadow items17CR_TIMETime, at Which Record Was Addednvarchar60
TOPInformation System
32T801HReport Writer: Parallel Reports12CR_TIMECreation Timenvarchar60
33T803JReport Writer: Report Groups11CR_TIMECreation Timenvarchar60
TOPLogistics Basic Data
34MASS_JOB_ERRORMass Maintenance Cluster for Error Recover8CR_TIMETime in CHAR Formatnvarchar60
TOPSAP Utilities
35ISU_WUI_DOC_FLTRDocument filter criteria for user11CR_TIMEEntry timenvarchar60
36TEAMI_LOG_DATALog for Service Communication in AMI Environment21CR_TIMEEntry timenvarchar60
37TEAMI_MSGMessages12CR_TIMECreation Time of Messagenvarchar60
TOPTrading Contract
38PPE_D_ITEM_LISTEvents18CR_TIMETime, at Which Record Was Addednvarchar60
TOPTransaction Tax Engine
39TTEC_DT_DATADecision Tree Data7CR_TIMECreation Timenvarchar60
TOPTranslation Tools
40LXE_KEY_VALUEProperties5CR_TIMESystem Timenvarchar60
41LXE_KW_TRANSLKW folders defined for translation10CR_TIMESystem Timenvarchar60
TOPWeb Survey
42TUWS_SURVEY_LOGSurvey Log17CR_TIMETIME Data Element for SYSTnvarchar60
43TUXX_COND_VALResults of Conditions on XML Documents12CR_TIMETIME Data Element for SYSTnvarchar60