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

52 columns | Print definition?ERP 6.0  | PATCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTKPILMODULSMBT KP: initial load function moduls knowledge pool5PATCHSupport Package namenvarchar200
2CNVMBTKPTABFIELDMBT KP: Response information of tables and fields6PATCHSupport Package namenvarchar200
3OCS_CP_PAT03TLOGO PAT03 für Correction Packages1PATCHSupport-Package-Namenvarchar200
4OCS_CP_PAT07TLOGO PAT07 für Correction Packages Patch Voraussetzungen1PATCHSupport-Package-Namenvarchar200
5OCS_CP_PAT08TLOGO PAT08 für Correction Package Erwtrte. Patch-Attribute1PATCHSupport-Package-Namenvarchar200
6PAT03_PREOCS-Package Verzeichnis - Eingespielte Pre-Packages1PATCHSupport-Package-Namenvarchar200
7PATUSEDOBJObjects Used1PATCHSupport Package namenvarchar200
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
8CRMCHKCOMPShort Desc.: Software Component6PATCHSupport Package namenvarchar200
TOPATC extensions for Technical Check
9SATCCHKCOMPShort Desc.: Check Result Management: Software Component6PATCHSupport Package namenvarchar200
10SATC_AC_RESULTVRMovement data: 'Display Load' module verdicts46PATCHSupport Package namenvarchar200
11SATC_COMPShort Desc.: Check Result Management: Software Component6PATCHSupport Package namenvarchar200
TOPDevelopment Workbench
12WCF_CONF_SWITCHSwitch Info11PATCHWCF Switch Info Bindingnvarchar2550
TOPEnterprise Service Framework Layer
13COL_VERSIONCool Versions5PATCHSupport Package namenvarchar200
TOPIncentive and Commission Management ICM
14TCACS_APPLObsolete - replaced by TCACS_APPLDEF and TCACS_APPLGEN8PATCHCorrection Number for Application Kernel Versionnvarchar40
15TCACS_APPLGENCMPPatch Status of Components at Time of Generation4PATCHSupport Package namenvarchar200
16TCACS_PATCHDelivered Versions and Patches2PATCHICM: Patchnvarchar60
17TCACS_PATCH_A00Patch Manager: Shadow Table Patches3PATCHICM: Patchnvarchar60
18TCACS_PATCH_ENHDelivered Versions and Patches (Assigned Enhancements)2PATCHICM: Patchnvarchar60
19TCACS_PATCH_INFODelivered Versions and Patches (Info Documents)2PATCHICM: Patchnvarchar60
20TCACS_PATCH_INFTDelivered Versions and Patches (Info Documents)2PATCHICM: Patchnvarchar60
21TCACS_PATCH_PACKDelivered Versions and Patches (Assigned Packages)2PATCHICM: Patchnvarchar60
22TCACS_PATCH_STEPDelivered Versions and Patches (Steps)2PATCHICM: Patchnvarchar60
23TCACS_PATCH_TDelivered Versions and Patches2PATCHICM: Patchnvarchar60
24TCACS_PATCH_U01Patch Manager: Upgrade Processes (Steps)3PATCHICM: Patchnvarchar60
25TCACS_PATCH_U03Patch Manager: Job Log (Steps of Job)4PATCHICM: Patchnvarchar60
TOPOnline Correction Support Support Package and Add-On Tools
26OCSPATNTCIBuffer for Support Package Attributes for Note Admin.1PATCHnvarchar200
27OCSSPCOMPRIn kompatibler Komponentenversion enthaltene SPs2PATCHSupport-Package-Namenvarchar200
28PAD03Registered Patches4PATCHSupport Package namenvarchar200
29PAD71Patch Contents1PATCHSupport Package namenvarchar200
30PAD71KKeys of Table Entries Contained in a Patch1PATCHSupport Package namenvarchar200
31PAT01Patch Status1PATCHSupport Package namenvarchar200
32PAT02Conflicts Between Patches and Add-Ons1PATCHSupport Package namenvarchar200
33PAT03OCS Package Directory1PATCHSupport Package namenvarchar200
34PAT03_SDAPAT03 for standalone Disassembler1PATCHSupport Package namenvarchar200
35PAT07Support Package Prerequisites1PATCHSupport Package namenvarchar200
36PAT07_SDASupport Package Prerequisites1PATCHSupport Package namenvarchar200
37PAT08Extended Support Package Attributes1PATCHSupport Package namenvarchar200
38PAT08_SDAExtended Support Package Attributes1PATCHSupport Package namenvarchar200
39PAT10OCS Semaphore2PATCHSupport Package namenvarchar200
40PAT13Description of OCS File Sections1PATCHSupport Package namenvarchar200
41PAT13_SDADescription of OCS File Sections - TOOLIMPORT1PATCHSupport Package namenvarchar200
42PATHISTQHistory of SPAM/SAINT Queues2PATCHSupport Package namenvarchar200
43PATRTVERS2OCS Runtime Analysis: Komponentenversionen9PATCHSupport-Package-Namenvarchar200
TOPProfitability Analysis
44TKEHISTUpgrade History10PATCHSupport Package namenvarchar200
TOPService Data Download
45/BDL/BDLFUVER2Service Definition, Extension of BDLFUVERS12PATCHChar 20nvarchar200
46/SDF/PAT03Patch Directory1PATCHnvarchar200
47/SDF/SWCM_PAT03DOCS Package Directory for DEV1PATCHSupport Package namenvarchar200
48/SDF/SWCM_PAT03POCS Package Directory for PRD1PATCHSupport Package namenvarchar200
49/SDF/SWCM_PAT03QOCS Package Directory for QAS1PATCHSupport Package namenvarchar200
50BDLFUVER2Extension of BDLFUVERS11PATCHChar 20nvarchar200
TOPTransport Management System
51LISSYSCOMLIS: System Components7PATCHSupport Package namenvarchar200
TOPWithout Description
52RSTT_LOGRUNArchive for Test Runs32PATCHID of Test Runnvarchar100