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

45 columns | Print definition?ERP 6.0  | UPDTIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CFMFND/DOBJCLACustomizingtabelle dyn. Objekte - Klassifizierungsmerkmal13UPDTIMEÄnderungszeitnvarchar60
2/CFMFND/DOBJDESCCustomizingtabelle dyn. Objekte - Darstellungsmerkm. - Tab15UPDTIMEÄnderungszeitnvarchar60
3/CFMFND/DOBJFILCustomizingtabelle dyn. Objekte - Filtermerkmale - Tabelle17UPDTIMEÄnderungszeitnvarchar60
4/CFMFND/DOBJGRPCustomizingtabelle dyn. Objekte - Gruppen9UPDTIMEÄnderungszeitnvarchar60
5/CFMFND/DOBJSRCCustomizingtabelle dyn. Objekte - Alternative Datenquellen10UPDTIMEÄnderungszeitnvarchar60
6/CFMFND/DOBJTYPCustomizingtabelle dyn. Objekte - Typen13UPDTIMEÄnderungszeitnvarchar60
7/CFMFND/EAM_EQTFCustomizing table for filtering on Equipment types11UPDTIMEModification timenvarchar60
8/CFMFND/EAM_TPLFCustomizing Tabelle für Filter auf Technische Plätze12UPDTIMEÄnderungszeitnvarchar60
9/CFMFND/LAYTOPZuordnung Layout zu CWS Browser10UPDTIMEÄnderungszeitnvarchar60
10/CFMFND/RECL_STDKlassifizierung: Standardklasse für Objekte12UPDTIMEÄnderungszeitnvarchar60
11/CFMFND/RE_AOTYFCustomizing Tabelle für Filter auf Architektonische Objekte10UPDTIMEÄnderungszeitnvarchar60
12/CIDEON/AF_CONFTabelle mit Konfigurationseinträge13UPDTIMEÄnderungszeitnvarchar60
13/CIDEON/AUTHGRPCIDEON Berechtigungsgruppen10UPDTIMEÄnderungszeitnvarchar60
14/CIDEON/CAD_NBTTable for entrainment of relative path17UPDTIMEtime of changingnvarchar60
15/CIDEON/CAD_WFDTable for entrainment of relative path17UPDTIMEtime of changingnvarchar60
16/CIDEON/MAINT_NBCIDEON Maintenance Standard Library Parts15UPDTIMEtime of changingnvarchar60
17/CIDEON/MOVE_PRUmzugsmanagement: Umzugsprojekte16UPDTIMEÄnderungszeitnvarchar60
18/CIDEON/MOVE_SCUmzugsmanagement: Umzugsszenarien19UPDTIMEÄnderungszeitnvarchar60
19/CIDEON/NBT_PARStatus Change Assistant Configuration Parameter12UPDTIMEtime of changingnvarchar60
20/CIDEON/PRDTable19UPDTIMEModification timenvarchar60
21/TDAG/CPT_TRCHKTracking of checked components6UPDTIMEChange Timenvarchar60
22GRACCRPROFILECritical Profile Rule7UPDTIMETimestamp when the Field was Last Updateddecimal150
23GRACCRROLECritical Role Rule7UPDTIMETimestamp when the Field was Last Updateddecimal150
24GRACFUNCFunction5UPDTIMETimestamp when the Field was Last Updateddecimal150
25GRACRULESETRule Set3UPDTIMETimestamp when the Field was Last Updateddecimal150
26GRACSODRISKSOD Risk7UPDTIMETimestamp when the Field was Last Updateddecimal150
27GRACSTDROLEDefault Role5UPDTIMETimestamp when the Field was Last Updateddecimal150
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
28DTELLINKSsddo16UPDTIMETIME Data Element for SYSTnvarchar60
29DTELPROTsddo8UPDTIMETIME Data Element for SYSTnvarchar60
TOPALE Integration Technology
30IDXSLOADIDoc Adapter Administration5UPDTIMETime at which control record was last changednvarchar60
TOPBasic Data and Tools
31EHFNDD_CI_USRDEFCluster table for user specific settings7UPDTIMESystem Timenvarchar60
32EHSBC_TMSTMPEHS-BAS: Time Stamp of Last Possible Change (See Doc.)4UPDTIMESystem Timenvarchar60
TOPClinical System
33N2DWSWL_TASKDProvisional Task40UPDTIMETime of Last Changenvarchar60
34N2PHYO_ORDERPhysician Order20UPDTIMETime of Last Changenvarchar60
TOPEnvironment, Health and Safety
35/TDAG/CPT_DEFSCLCP: Cluster table for user defaults7UPDTIMESystem Timenvarchar60
36/TDAG/CPT_TASKHHeader data for tasks26UPDTIMEChange Timenvarchar60
37/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv26UPDTIMEChange Timenvarchar60
38/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten23UPDTIMEChange Timenvarchar60
39/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv23UPDTIMEChange Timenvarchar60
TOPPatient Management
40N2DTIS-H*MED: Table of Documentation Categories60UPDTIMEPMD: Timenvarchar60
TOPProduct Safety
41CCRCT_EHS_WLEHS: Worklist of Changed Materials5UPDTIMELast Changed Atnvarchar60
42ESTWLEHS: BOMBOS - Worklist Table24UPDTIMECreation Time of the Worklist Entrynvarchar60
43TCGES_QUERYEHS: Search Form Enterprise Search12UPDTIMEField of type TIMSnvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
44N2DWSWL_TASKTask40UPDTIMETime of Last Changenvarchar60
TOPSets
45SETHEADERSet Header and Directory15UPDTIMETime of last changenvarchar60