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

48 columns | Print definition?ERP 6.0  | TDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BWBICS_INA_STOREPersistance for the Test Tool4TDATESystem Datenvarchar80
2DFKKBPLOCKFI-CA: Business Partner Locks6TDATELock valid tonvarchar80
3DFKKBPLOCKHFI-CA: Business Partner Locks - History8TDATELock valid tonvarchar80
4P2NZ_EMSPayroll Result: Employer Monthly Schedule - NZ12TDATEFire Datenvarchar80
5P2NZ_TAXPPayroll Result: Taxation TAXP - NZ19TDATENeglect employees terminated before this datenvarchar80
6T7PIQPKEYPeriod control4TDATETranslation Datenvarchar80
TOPActive Quality Control
7TQG_EVAL_GR_TYPXGraphic Types: XML Layout4TDATESystem Datenvarchar80
TOPAustralia
8PA0701HR Terminations Data Container : Infotype 070124TDATEEmployee's Termination Datenvarchar80
TOPBasic Functions
9T830AFI-SL Master Record Table5TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
10T830BFI-SL Master Record Table5TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
11T830DFI-SL Master Record Table5TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
12T831AFI-SL Master data text6TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
13T831BFI-SL Master Record Table6TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
14T831DFI-SL Master data text6TDATEValid to date (inverted: 99999999 - YYYYMMDD)nvarchar80
TOPContract Accounts Receivable and Payable
15DFKKCFCSLOCKSFI-CA Locks12TDATELock valid tonvarchar80
16DFKKLOCKSFI-CA: Business Locks7TDATELock valid tonvarchar80
17DFKKLOCKSHBusiness Lock Histories8TDATELock valid tonvarchar80
18DFKKOPLLocks for Open Items (Change Document Interface)8TDATELock valid tonvarchar80
19DFKKORDERLOCKSRequests: Processing Locks8TDATELock valid tonvarchar80
20DFKKORDERLOCKS_SRequest Templates: Processing Locks8TDATELock valid tonvarchar80
21DFKKUREUpdate Run: Defective Data Records22TDATEValid-To Date of Processing Locknvarchar80
22TFKMSGARecording of Problem Classes of Messages4TDATEDate to which Activation is Validnvarchar80
TOPInformation System
23T804AReport Writer: File Description4TDATEIndicator: Read with datenvarchar10
TOPInterest
24TPI03CO Objects: Date of Last Interest Run5TDATEDatenvarchar80
TOPInvoicing
25EABPJVL_CORRCorrespondence Print: Bud. Bill. Plan Header and YAP Info.26TDATELock valid tonvarchar80
26EJVLYearly Advance Payment23TDATELock valid tonvarchar80
TOPPerformance Assessment Workbench
27SLS_PETPAW - Person/Event/Test Relationship Table25TDATEPAW - Test execution datenvarchar80
TOPPublic Sector
28T5QPBS2OImpact of Organizational change6TDATEDatenvarchar80
TOPSAP Internet Transaction Server
29IACFLFeature in ITS Plug-In4TDATEDate IAC object changednvarchar80
30IACFLOWINDX file for HTML templates (cross-language)8TDATEDate IAC object changednvarchar80
31IACHTMLObsolete:INDX File for HTML Templates (Language-Independent)12TDATEDate IAC object changednvarchar80
32IACHTMLLObsolete: INDX File for HTML Templates (Language-Dependent)13TDATEDate IAC object changednvarchar80
33IACHTRCObsolete: Language Resources for Internet Applications8TDATEDate IAC object changednvarchar80
34IACHTRCLObsolete: Language Resources for Internet Applications9TDATEDate IAC object changednvarchar80
35IACJSCRObsolete: INDX File for MIME Objects (Language-Independent)11TDATEDate IAC object changednvarchar80
36IACMIMEObsolete: INDX File for MIME Objects (Language-Independent)11TDATEDate IAC object changednvarchar80
37IACMIMELObsolete: INDX File for MIME Objects (Language-Dependent)12TDATEDate IAC object changednvarchar80
38IACMLParameters for MIME Objects (Language-Specific) File & Rel.7TDATEDate IAC object changednvarchar80
39IACMUParameters for MIME Objects (Non-Lang.-Specific) File & Rel.7TDATEDate IAC object changednvarchar80
40IACRLanguage Resources for Internet Applications (Service, Theme5TDATEDate IAC object changednvarchar80
41IACSInternet Application Components with ITS4TDATEDate IAC object changednvarchar80
42IACSERVICEObsolete: Internet Application Components with ITS7TDATEDate IAC object changednvarchar80
43IACTLParameters for HTML Templates (Non-Lang.-Spec.) Prog. Name8TDATEDate IAC object changednvarchar80
44IACTUParameters for HTML Templates (Non-Lang.-Spec.) Prog. Name8TDATEDate IAC object changednvarchar80
45IACXUXML Templates for HTML Templates8TDATEDate IAC object changednvarchar80
TOPService Data Download
46/SDF/CMO_IACJSCRCMO Service: INDX File for MIME Objects (Language-Indep11TDATEDate IAC object changednvarchar80
TOPSyntax, Compiler, Runtime
47TPDATRACEADMINTPDA: ABAP Trace Verwaltung5TDATESystemdatumnvarchar80
TOPWebRFC, Web Reporting
48WWWDATAINDX-type table for storing WWW objects7TDATEDatenvarchar80