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

46 columns | Print definition?ERP 6.0  | BDATU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVA_PCREA_AA_CPC Reorg Analysis: FI-AA Profit Center assignments7BDATUDate validity endsnvarchar80
2DVK00unused dummy structure xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx13BDATUProcessing date of WMS communication recordnvarchar80
3FIAAQAC_EVALRATEMaintain Evaluation Group and Depreciation Rate Assignment5BDATUDate validity endsnvarchar80
4FILUD_AA_MASTERSAFT: FI Asset master data and values7BDATUDate validity endsnvarchar80
5J_3RTTAXADVPMNTSAdvanced payments for russian transport tax5BDATUDate validity endsnvarchar80
6T052RRules for Issuing Invoices3BDATUEnd of Leavenvarchar80
7T090IDepreciation simulation (Reporting)6BDATUDate validity endsnvarchar80
TOPBasic Data
8MKALProduction Versions of Material5BDATURun-time end: production versionnvarchar80
TOPBasic Functions
9ANGBAsset catalog deprec. area6BDATUDate validity endsnvarchar80
10ANKBAsset class: depreciation area5BDATUDate validity endsnvarchar80
11ANLBDepreciation terms6BDATUDate validity endsnvarchar80
12ANLBZATime-Dependent Depreciation Terms6BDATUDate validity endsnvarchar80
13ANLZTime-Dependent Asset Allocations5BDATUDate validity endsnvarchar80
14T085Investment support measures5BDATUDate validity endsnvarchar80
15T085ZCapital investment grants with time-dependent percentages4BDATUDate validity endsnvarchar80
16T090NSKMultilevel Method4BDATULevel is valid up to this calendar datenvarchar80
TOPCross-Application Components
17EEORDPurchasing Source List8BDATUSource List Record Valid Tonvarchar80
TOPFinancial Accounting
18/CCEE/FISI_DDVNSlovenia VAT open period4BDATUDate validity endsnvarchar80
19T001_UMKRSTime-Dep. Assignment of Company Code to Sales/Purch. Tax Grp5BDATUDate validity endsnvarchar80
TOPLocalization
20GLOFAATMDPNDNTTime-Dependent Country-Specific Asset Master Records5BDATUDate validity endsnvarchar80
21J_1B_CIAP_CONDCIAP Object Conditions5BDATUDate until which CIAP Condition is Validnvarchar80
22J_3RFPROPTAXVProperty tax values in asset master record5BDATUDate validity endsnvarchar80
23J_3RTASSETTime dependent master record tax parameters of vehicles5BDATUCarrier registration date completionnvarchar80
24J_3R_STRDIV_TDTable of Structural Division Intervals1BDATUDate validity endsnvarchar80
25J_3R_TAX_SETTINGSettings for Transport & Property Tax (eg. Struct. div.)3BDATUDate validity endsnvarchar80
TOPPerishables Procurement
26FIP_D_QUOTAQuotation Data5BDATUValid To Datenvarchar80
TOPProduction Orders
27AFBPCIM order: Batch print requests3BDATUDatenvarchar80
TOPPurchasing
28EORDPurchasing Source List8BDATUSource List Record Valid Tonvarchar80
29EQUKQuota File: Header4BDATUQuota arrangement period valid untilnvarchar80
TOPRepetitive Manufacturing
30RMIOInput Structure of Repetitive Manufacturing Confirmation10BDATURun-time end: production versionnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
31NAKRDIS-H AT: LKF - Datenträgernummer4BDATUGültigkeitsdatum bisnvarchar80
TOPSCM Basis
32CIF_IMPPMInt. Model Reference Table for Production Process Model5BDATUDate validity endsnvarchar80
TOPWarehouse Management
33LAGPStorage bins22BDATUDate of last movementnvarchar80
34LEINStorage unit header records12BDATUDate of last movementnvarchar80
35LL01Whse Activity Monitor: Critical Transfer Order Items12BDATUDate of last changenvarchar80
36LL02Whse Activity Monitor: Critical Transfer Requirement Items13BDATUDate of last changenvarchar80
37LL03Whse Activity Monitor: Critical Posting Change Documents9BDATUDate of last changenvarchar80
38LL04Whse Activity Monitor: Critical Deliveries9BDATUDate of last changenvarchar80
39LL05Whse Activity Monitor: Critical Stocks9BDATUDate of last changenvarchar80
40LL06Whse Activity Monitor: Critical Storage Bins9BDATUDate of last changenvarchar80
41LL07Whse Activity Monitor: Critical Production Orders9BDATUDate of last changenvarchar80
42LQUAQuants20BDATUDate of last movementnvarchar80
43LSEGDocument for Inward and Outward Movements17BDATUCreation date of whse documentnvarchar80
44LTAKWM transfer order header8BDATUCreation Date of Transfer Ordernvarchar80
45LTBKTransfer requirement header8BDATUCreation Date of Transfer Requestnvarchar80
46LUBUPosting Change Document10BDATUCreation Date of Posting Change Noticenvarchar80