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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

32 columns | Print definition?ERP 6.0  | ADATU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_PCREA_AA_CPC Reorg Analysis: FI-AA Profit Center assignments8ADATUDate for beginning of validitynvarchar80
2DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx7ADATUDate on Which Record Was Creatednvarchar80
3FIAAQAC_EVALRATEMaintain Evaluation Group and Depreciation Rate Assignment6ADATUDate for beginning of validitynvarchar80
4FILUD_AA_MASTERSAFT: FI Asset master data and values8ADATUDate for beginning of validitynvarchar80
5T090IDepreciation simulation (Reporting)7ADATUDate for beginning of validitynvarchar80
TOPBasic Data
6MKALProduction Versions of Material6ADATUValid-from date of production versionnvarchar80
TOPBasic Functions
7ANGBAsset catalog deprec. area5ADATUDate for beginning of validitynvarchar80
8ANKBAsset class: depreciation area6ADATUDate for beginning of validitynvarchar80
9ANLBDepreciation terms7ADATUDate for beginning of validitynvarchar80
10ANLBZATime-Dependent Depreciation Terms7ADATUDate for beginning of validitynvarchar80
11ANLZTime-Dependent Asset Allocations6ADATUDate for beginning of validitynvarchar80
12T085Investment support measures4ADATUDate for beginning of validitynvarchar80
13T085ZCapital investment grants with time-dependent percentages5ADATUDate for beginning of validitynvarchar80
TOPCharacteristics
14CABNCharacteristic40ADATUDate on Which Record Was Creatednvarchar80
15CABNNEWCharacteristic40ADATUDate on Which Record Was Creatednvarchar80
TOPClasses
16KLAHClass Header Data11ADATUDate on Which Record Was Creatednvarchar80
TOPEnvironment
17LCABNCharacteristic40ADATUDate on Which Record Was Creatednvarchar80
18LKLAHClass Header (Special Objects)11ADATUDate on Which Record Was Creatednvarchar80
TOPFinancial Accounting
19T001_UMKRSTime-Dep. Assignment of Company Code to Sales/Purch. Tax Grp3ADATUDate for beginning of validitynvarchar80
TOPLease Accounting
20FILA_GF_ITEMDATAProcess Data32ADATUDate for beginning of validitynvarchar80
TOPLocalization
21GLOFAATMDPNDNTTime-Dependent Country-Specific Asset Master Records6ADATUDate for beginning of validitynvarchar80
22J_1B_CIAP_CONDCIAP Object Conditions4ADATUDate from which CIAP Condition is Validnvarchar80
23J_3RFPROPTAXVProperty tax values in asset master record6ADATUDate for beginning of validitynvarchar80
24J_3RTASSETTime dependent master record tax parameters of vehicles6ADATUDate for beginning of validitynvarchar80
25J_3R_STRDIV_TDTable of Structural Division Intervals2ADATUDate for beginning of validitynvarchar80
26J_3R_TAX_SETTINGSettings for Transport & Property Tax (eg. Struct. div.)4ADATUDate for beginning of validitynvarchar80
TOPProduct Safety
27TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions15ADATUDate on Which Record Was Creatednvarchar80
TOPR2-R3 Link
28LDK00Status Record for WM Communication Records6ADATUArrival date of WMS communication recordnvarchar80
TOPRepetitive Manufacturing
29RMIOInput Structure of Repetitive Manufacturing Confirmation9ADATUValid-from date of production versionnvarchar80
TOPSCM Basis
30CIF_IMPPMInt. Model Reference Table for Production Process Model6ADATUDate for beginning of validitynvarchar80
TOPVariant Configuration
31KRIFRichie Riffle10ADATUDate on Which Record Was Creatednvarchar80
TOPWarehouse Management
32LQUAQuants26ADATUDate of last stock removalnvarchar80