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

54 columns | Print definition?ERP 6.0  | EDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/KPFI00005Cashier declared amounts3EDATESystem Datenvarchar80
2FIPYXXD_INSTMTBank Statement File Identification Table8EDATEImport date into bank data puffernvarchar80
3P2NZ_TAXPPayroll Result: Taxation TAXP - NZ20EDATES/L Exempt End Datenvarchar80
4P2RX_ACCRPayroll Result: Month End Accruals9EDATEEarning date for month-end accrualsnvarchar80
5T7CNREW_APRDELPayroll renewal - Approval set delegation5EDATEEnd Datenvarchar80
TOPAuto-ID Backend Integration
6AIDLOGAuto-ID Infrastructure Log Table18EDATEDue Datedecimal150
TOPBasic Functions
7FDAUCash Managment Advice Authorization Catalog13EDATEImport date into bank data puffernvarchar80
8FEBKOElectronic Bank Statement Header Records50EDATEImport date into bank data puffernvarchar80
9TABADepreciation posting documents10EDATEDay On Which Accounting Document Was Enterednvarchar80
TOPBusiness Accounting
10URBWTSRealigner: Processed Time Intervals9EDATEFinish Datenvarchar80
TOPClinical System
11N1RISMISIS-H*MED: Data transfer error (case - patient)6EDATEIS-H: Date when Record Creatednvarchar80
TOPCost Center Accounting
12T811CAllocations: Cycles5EDATEEnd datenvarchar80
TOPData Retention Tool
13TXX_ADMI_EXTRDART-Administration --- Extract_Data---12EDATEExtract Creation Date: Endnvarchar80
TOPDefense Forces and Public Security
14PA0802Personnel Info Record Infotype 080229EDATEEnd Date of Disciplinary Punishmentnvarchar80
TOPeCATT Extended Computer Aided Test Tool
15ECOQ_LOGeCATT OQ Log5EDATESystem Datenvarchar80
TOPF1 Help
16ERG001Statistics ergonomics version for Q teams6EDATESystem Datenvarchar80
TOPFinancial Accounting
17/CCEE/SIFIPE7Pro forma invoice for temporary export of goods4EDATEDatenvarchar80
TOPGeneral Ledger Accounting
18FAGL_CUST_DETCustomizing Versions: Detailed Information5EDATEDatenvarchar80
19FAGL_PROTLogs4EDATEDatenvarchar80
TOPLanguage Transport
20TLSY7Language Import History7EDATEEnd Datenvarchar80
TOPLocal Currency Changeover
21EWUCLSTATEMU Cnv: Status Table for Conversion with Clusters19EDATEEnd date of the programnvarchar80
TOPMaxDB
22ADATABSIZESAP DB: Table Sizes Including Indexes in KB11EDATESAP DB: Analysis Datenvarchar80
TOPNew Zealand
23PA0313Employee Taxation Detail Infotype NZ34EDATES/L Exempt End Datenvarchar80
TOPNon Profit Organizations
24T7UNPAD_DSDuty Station5EDATEEnd Datenvarchar80
TOPNorway
25T5V7BMessages sent to employees/emplyoers register3EDATEDate of event to be reported to employees/employers registernvarchar80
26T5V7DDynamic event recording earliest master data changes3EDATEDate of event to be reported to employees/employers registernvarchar80
TOPPatient Accounting
27NBDTIS-H: Ins. assoc. billing cases transferred - status header7EDATEIS-H: Date when Record Creatednvarchar80
28NBDT02PPA Billing Status for Treatment Certificates6EDATEIS-H: Date when Record Creatednvarchar80
29TNIEBILLIS-H: Internet-Enabled Estimated Invoice - Not Supported Now4EDATEIS-H: Date for which Estimated Invoice Is to Be Calculatednvarchar80
TOPPersonnel Administration
30HRARCENQTable for Lock Object E_HR_ARC_P3EDATEDate of Lock (Lock Object E_HR_ARC_P)nvarchar80
TOPPrint Workbench
31EFGSTTXTINFOVersion Information Standard Text11EDATEDate for a Translation Listnvarchar80
32EFRMTRLSTWorklists for Application Form Translation2EDATEDate for a Translation Listnvarchar80
33EFRMTRLSTSTRLines of a Translation List2EDATEDate for a Translation Listnvarchar80
TOPProfitability Analysis
34TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource21EDATEEnd Time: Datenvarchar80
35TKEBWTSCO-PA Connection to SAP BW: Processed Time Intervals10EDATEEnd Time: Datenvarchar80
36TKEBWTSNCO-PA Connection to SAP BW: Processed Time Intervals12EDATEEnd Time: Datenvarchar80
TOPPublic Sector
37T5RPBS8COBSOLETE(Pensions Scheme Payment Option Eligibility Crite)4EDATEPayment Option Eligibility Datenvarchar80
TOPPurchase Orders
38WBO5Calculated Actual Vendor Service Level8EDATETo-date for period of actual vendor service levelnvarchar80
TOPRegulatory reporting for insurance companies
39TISSR_LT_HEADERKopftabelle zur Speicherung von Listinhalten im neuen Mw11EDATEDatumnvarchar80
TOPRepository Browser
40OBJTYPEGROUPSSemantic Group Affiliation of Object Types4EDATECreated onnvarchar80
41WVOBJECTTYPESRegistry Table for Object Types4EDATECreated onnvarchar80
TOPRuntime WorkbenchMonitoring
42SXIPERF_REG_LOGPerformance Regression - Run Log5EDATEnvarchar80
TOPSAP Note Assistant
43SVRS_VCNT_HEADHeader table for TLogo test objects8EDATEDate of Last Changenvarchar80
TOPSchedule Manager
44SMMAINMain Information for an Entry in the Monitor6EDATEEnd Date for Processingnvarchar80
TOPSweden
45T5S0SMessages for sickness administration (SE)3EDATEDate of event to be reported to employees/employers registernvarchar80
TOPTax
46T5D2IStADUEV Notifications: Transfer Numbers6EDATEField of type DATSnvarchar80
TOPTools
47TKEBWLREQuery Data Transfer: Administration17EDATEKey date for data transfernvarchar80
TOPTranslation Tools
48BRALOGIndustry log for import/activation of industries8EDATEEnd date of actionnvarchar80
TOPTransport Organizer
49TE07FReleasable Correction Transports with Special Functions4EDATESystem Datenvarchar80
50VERSOBJ_ALIASList of Active Alias Object Types10EDATEDate of Last Changenvarchar80
TOPWork Clearance Management
51WCAAPWCM: Application41EDATEBasic finish datenvarchar80
52WCAHEWCM: Work Clearance Document (Header)41EDATEBasic finish datenvarchar80
53WCAWWCM: Work Approval39EDATEBasic finish datenvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
54COVMVHIDTable for Storing History Versions5EDATEDate for Coverage Analyzer Historynvarchar80