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

42 columns | Print definition?ERP 6.0  | ADATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_BADIExit: Implementation side: Attributes10ADATEDatenvarchar80
2CNVCMIS_A_SESSTable to store status information about table analysis4ADATEDate in CHAR Formatnvarchar80
3CNVTDMS_02_SESSTable to store status information about table analysis4ADATEDate in CHAR formatnvarchar80
4DFKKEPRTLog for Inconsistent FI-CA Documents31ADATEDate on Which Record Was Creatednvarchar80
5EXP_USASCIException handling non US ASCII keys8ADATEDate of Last Changenvarchar80
6T021DLine Layout Fast Entry: Administration5ADATEFast Entry: Activation Datenvarchar80
7TLANOCSSprachentransport - OCS Import6ADATESystemdatumnvarchar80
8WBBGRFCTMPLog for Where Used Index Update in Backgound Tasks4ADATESystem Datenvarchar80
TOPAccounts Receivable Accounting Process Integration
9DEBPPEVENTLOGLogged Event8ADATEDate of Log Entrynvarchar80
TOPAppraisal Systems
10HRP1045DB Table for Infotype 104520ADATECreation date of appraisalnvarchar80
TOPAuto-ID Backend Integration
11AIDEPCREFObsolite: EPC Reference11ADATEDue Datedecimal150
12AIDLOGAuto-ID Infrastructure Log Table19ADATEDue Datedecimal150
TOPBasis Components
13/SSF/DHEADService Software Framework: Analysis/download control header2ADATEnvarchar80
TOPBelgium
14T5BSDSI Declaration: directory table13ADATEAcceptance date SI declarationnvarchar80
TOPBusiness Planning and Simulation
15UPX_CLUSTERCluster Table for Sales Planning5ADATEDate data element for SYSTnvarchar80
TOPCompensation Management
16T71LB1Award4ADATEAward datenvarchar80
17T71LB2Country-dependent award attributes5ADATEAward datenvarchar80
TOPContract Accounts Receivable and Payable
18TFK021DScreen variants: Administration5ADATEScreen variants: Activation datenvarchar80
TOPCost Center Accounting
19T811DAllocations: Document Numbers9ADATEProcessing datenvarchar80
20T811DAAllocations: Dependent Document Numbers9ADATEProcessing datenvarchar80
21T811DSAllocations: Document Numbers for Segment Reverse/Rebook13ADATEProcessing datenvarchar80
TOPCustomer Enhancements
22SXC_ATTRExit: Implementation side: Attributes6ADATEDatenvarchar80
TOPGeneral Application Functions
23TFISEVENTLOGLogged Event7ADATEDate of Log Entrynvarchar80
TOPLanguage Transport
24TLANEXITLanguage Transport User Exits3ADATESystem Datenvarchar80
25TLANEXPLanguage Transport: Export Actions7ADATESystem Datenvarchar80
26TLANIMPLanguage Transport: Import Action6ADATESystem Datenvarchar80
27TLANNOTTALanguage Transport: Exclusion Table4ADATESystem Datenvarchar80
28TLANSUPLanguage Transport: Supplementation Action6ADATESystem Datenvarchar80
29TLSY7Language Import History5ADATEStart Datenvarchar80
TOPMaxDB
30ADATABSIZESAP DB: Table Sizes Including Indexes in KB9ADATESAP DB: Analysis Datenvarchar80
TOPOperating System Monitors
31OSMONOperating system monitoring data2ADATEDate of analysisnvarchar80
TOPOverhead Cost Controlling
32T823DRevaluation document numbers10ADATEProcessing datenvarchar80
TOPPayroll
33T5H9DPayroll accounting data table6ADATEHR-H 255- long textnvarchar2550
TOPProduct Safety
34CCGLT_AUDHEHS: Audit Data Header Entry5ADATEDate in CHAR formatnvarchar80
TOPProfitability Analysis
35/EACA/TPMLIDOCSource Document PM Line Item4ADATEDocument Datenvarchar80
36TKE_DIST_EXECDocument Numbers in CO-PA Distribution9ADATEProcessing datenvarchar80
TOPPublic Sector
37PA0716Business Scenario Management Infotype33ADATEEffective date for the action to be triggerednvarchar80
TOPQuality Management
38ZPH_REQAnforderungen13ADATEAnforderungen: Anlagedatumnvarchar80
TOPTranslation Tools
39BRACNTLIndustry control table5ADATEDate of last industry changenvarchar80
40BRALOGIndustry log for import/activation of industries6ADATEStart date of actionnvarchar80
TOPUSA
41PA0216Garnishment Adjustment26ADATEDate of adjustmentnvarchar80
42PA0566HR Master Record: Infotype 056625ADATEQDRO Award Datenvarchar80