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

62 columns | Print definition?ERP 6.0  | UPDDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/DOBJCLACustomizingtabelle dyn. Objekte - Klassifizierungsmerkmal12UPDDATEÄnderungsdatumnvarchar80
2/CFMFND/DOBJDESCCustomizingtabelle dyn. Objekte - Darstellungsmerkm. - Tab14UPDDATEÄnderungsdatumnvarchar80
3/CFMFND/DOBJFILCustomizingtabelle dyn. Objekte - Filtermerkmale - Tabelle16UPDDATEÄnderungsdatumnvarchar80
4/CFMFND/DOBJGRPCustomizingtabelle dyn. Objekte - Gruppen8UPDDATEÄnderungsdatumnvarchar80
5/CFMFND/DOBJSRCCustomizingtabelle dyn. Objekte - Alternative Datenquellen9UPDDATEÄnderungsdatumnvarchar80
6/CFMFND/DOBJTYPCustomizingtabelle dyn. Objekte - Typen12UPDDATEÄnderungsdatumnvarchar80
7/CFMFND/EAM_EQTFCustomizing table for filtering on Equipment types10UPDDATEModification datenvarchar80
8/CFMFND/EAM_TPLFCustomizing Tabelle für Filter auf Technische Plätze11UPDDATEÄnderungsdatumnvarchar80
9/CFMFND/LAYTOPZuordnung Layout zu CWS Browser9UPDDATEÄnderungsdatumnvarchar80
10/CFMFND/RECL_STDKlassifizierung: Standardklasse für Objekte11UPDDATEÄnderungsdatumnvarchar80
11/CFMFND/RE_AOTYFCustomizing Tabelle für Filter auf Architektonische Objekte9UPDDATEÄnderungsdatumnvarchar80
12/CIDEON/AF_CONFTabelle mit Konfigurationseinträge12UPDDATEÄnderungsdatumnvarchar80
13/CIDEON/AUTHGRPCIDEON Berechtigungsgruppen9UPDDATEÄnderungsdatumnvarchar80
14/CIDEON/CAD_NBTTable for entrainment of relative path16UPDDATEdate of changenvarchar80
15/CIDEON/CAD_WFDTable for entrainment of relative path16UPDDATEdate of changenvarchar80
16/CIDEON/MAINT_NBCIDEON Maintenance Standard Library Parts14UPDDATEdate of changenvarchar80
17/CIDEON/MOVE_PRUmzugsmanagement: Umzugsprojekte15UPDDATEÄnderungsdatumnvarchar80
18/CIDEON/MOVE_SCUmzugsmanagement: Umzugsszenarien18UPDDATEÄnderungsdatumnvarchar80
19/CIDEON/NBT_PARStatus Change Assistant Configuration Parameter11UPDDATEdate of changenvarchar80
20/CIDEON/PRDTable18UPDDATEModification datenvarchar80
21T7CNTPM_USAGETPM: Usage Data11UPDDATELast Update Timenvarchar80
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
22DTELLINKSsddo15UPDDATESystem Datenvarchar80
23DTELPROTsddo7UPDDATESystem Datenvarchar80
TOPALE Integration Technology
24IDXSLOADIDoc Adapter Administration4UPDDATEDate on which control record was last changednvarchar80
TOPBasic Data and Tools
25EHFNDD_CI_USRDEFCluster table for user specific settings6UPDDATESystem Datenvarchar80
26EHSBC_TMSTMPEHS-BAS: Time Stamp of Last Possible Change (See Doc.)3UPDDATESystem Datenvarchar80
TOPClinical System
27N2DWSWL_TASKDProvisional Task28UPDDATEDate on Which Record Was Last Changednvarchar80
28N2DWSWL_WORKDProvisional Situation31UPDDATEDate on Which Record Was Last Changednvarchar80
29N2GL_ACTpathways Activity21UPDDATEDate on Which Record Was Last Changednvarchar80
30N2GL_ACT_NOTEPathways: Comment on Activity12UPDDATEDate on Which Record Was Last Changednvarchar80
31N2GL_GUIDELINEpathways Treatment Pathway39UPDDATEDate on Which Record Was Last Changednvarchar80
32N2GL_TM_SCHEDULEpathways Patient Pathway44UPDDATEDate on Which Record Was Last Changednvarchar80
33N2GL_TM_STEPpathways Step of Patient Pathway39UPDDATEDate on Which Record Was Last Changednvarchar80
34N2PHYO_ORDERPhysician Order19UPDDATEDate on Which Record Was Last Changednvarchar80
35N2RAD_FWL_ITEMi.s.h.med Radiology Findings Work Station: Findings Tasks22UPDDATEDate on Which Record Was Last Changednvarchar80
36TN2CATCategories: Categories in Category Set11UPDDATEDate on Which Record Was Last Changednvarchar80
37TN2CATAREACategories: Category Areas6UPDDATEDate on Which Record Was Last Changednvarchar80
38TN2CATCCategories: Categories for End Users7UPDDATEDate on Which Record Was Last Changednvarchar80
39TN2CATCMCategories: Main Categories6UPDDATEDate on Which Record Was Last Changednvarchar80
40TN2CATCONTCategories: Category Container8UPDDATEDate on Which Record Was Last Changednvarchar80
41TN2CATSETCategories: Category Set8UPDDATEDate on Which Record Was Last Changednvarchar80
42TN2PDCS2OEIPPD: Assignments: SET - OU - Occupational Group9UPDDATEDate on Which Record Was Last Changednvarchar80
TOPEnvironment, Health and Safety
43/TDAG/CPT_DEFSCLCP: Cluster table for user defaults6UPDDATESystem Datenvarchar80
44/TDAG/CPT_TASKHHeader data for tasks25UPDDATEChanged Onnvarchar80
45/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv25UPDDATEChanged Onnvarchar80
46/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten22UPDDATEChanged Onnvarchar80
47/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv22UPDDATEChanged Onnvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
48N2DWSWL_FAVOHit List Entry13UPDDATEDate on Which Record Was Last Changednvarchar80
49N2DWSWL_FAVO1Hit List Entry / Changes13UPDDATEDate on Which Record Was Last Changednvarchar80
50N2DWSWL_GROUPGroups for Template Management8UPDDATEDate on Which Record Was Last Changednvarchar80
51N2DWSWL_INFOInfo Item8UPDDATEDate on Which Record Was Last Changednvarchar80
52N2DWSWL_PATTTask Template24UPDDATEDate on Which Record Was Last Changednvarchar80
53N2DWSWL_PATT1Task Template / Changes24UPDDATEDate on Which Record Was Last Changednvarchar80
54N2DWSWL_PROFProfile Template16UPDDATEDate on Which Record Was Last Changednvarchar80
55N2DWSWL_PROF1Profile Template / Changes16UPDDATEDate on Which Record Was Last Changednvarchar80
56N2DWSWL_TASKTask28UPDDATEDate on Which Record Was Last Changednvarchar80
57N2DWSWL_TPACKProfile16UPDDATEDate on Which Record Was Last Changednvarchar80
58N2DWSWL_WORKSituation31UPDDATEDate on Which Record Was Last Changednvarchar80
59N2DWSWL_WSSituation Template25UPDDATEDate on Which Record Was Last Changednvarchar80
60N2DWSWL_WS1Situation Template / Changes25UPDDATEDate on Which Record Was Last Changednvarchar80
TOPSets
61SETHEADERSet Header and Directory14UPDDATEDate on which object was last changednvarchar80
62T800SFI-SL Set Table (before Release 4.0)9UPDDATEDate on which object was last changednvarchar80