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

101 columns | Print definition?ERP 6.0  | TNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCDOPCA_EXITSCDOP : User exits Implemented in the system13TNAMEName of extended tablenvarchar300
2CNVCDOPCA_UEXITSCDOP : User exits Implemented in the system (Valid table)13TNAMEName of extended tablenvarchar300
3CNVC_SCWB_XTTrigger header table3TNAMETriggernvarchar120
4CNVC_SCWB_XTEVTrigger event table3TNAMETriggernvarchar120
5CNVC_SCWB_XTLITrigger object list3TNAMETriggernvarchar120
6DMC_IU_TM_NODEMWB Upgrade: Node Table for Tool Manager4TNAMEMWB: Tool Namenvarchar400
7DMC_IU_TM_NODETMWB Upgrade: Node Text Table for Tool Manager4TNAMEMWB: Tool Namenvarchar400
8DMC_TM_NODEMWB: Node Table for Tool Manager4TNAMEMWB: Tool Namenvarchar400
9DMC_TM_NODETMWB Upgrade: Node Text Table for Tool Manager4TNAMEMWB: Tool Namenvarchar400
10NWS_EXT_PROTNMessage Log, R/3 Extractor9TNAMETable Namenvarchar300
11NWS_EXT_PROTSData Transport Management Tool Log Statistics8TNAMETable Namenvarchar300
12T021Fields for Line Item and Document Line Layout5TNAMETable Namenvarchar300
13T021RField selection for spec.functions (list displays)5TNAMETable Namenvarchar300
14T242ISender information4TNAMETable name of sender fieldnvarchar300
15T242SSAP-EIS: Collection programs and sender structures4TNAMETable name of sender fieldnvarchar300
16T5FPBSD2Décision : Zones9TNAMENom de tablenvarchar300
17T7UAH1TReference table of time codes (Texts)5TNAMETime Type Code Namenvarchar1280
18TAME0Application Monitor: Table - Event1TNAMETable namenvarchar300
19TIVXCITICIFORMICI Form Settings9TNAMEFirst Namenvarchar400
20TKB7CPseudonyms for Field Names3TNAMETable Namenvarchar300
21TKSBSFields for Line Structure5TNAMETable Namenvarchar300
22TSTAMApplication object tables3TNAMETable namenvarchar300
TOPAccount Determination
23T180SReporting: Display Variants: Fields8TNAMETable namenvarchar300
TOPBasic Data
24TNP00IS-H: Controlling the Customizing of Parameter Tables1TNAMEIS-H: Table Containing Parametersnvarchar100
25TNP0TIS-H: Controlling the Customizing of Parameters - Texts2TNAMEIS-H: Table Containing Parametersnvarchar100
TOPBasic Functions
26FEBKEYID administration2TNAMETable namenvarchar100
27T011ACalendar - task description3TNAMETechnical name for tasknvarchar140
28T061SFI-ARI: Functions for external partners9TNAMETable Namenvarchar300
29T180MCustomizing List: Modification3TNAMETable namenvarchar300
TOPCCMS Database Monitors for SQL Server
30MSSCNTDEADCumulated deadlock statistics data6TNAMETable namenvarchar1280
TOPClinical System
31TN2DEVICESInterface Information / Formats4TNAMEName of Transfer File (Communication Module)nvarchar50
TOPClosing Operations
32FBRC1100CContact Person Databases4TNAMETable Namenvarchar300
TOPCompany Pension Scheme Germany
33T5DCHAssignment of Statement Data Type to CPS Table Name3TNAMETable namenvarchar300
34T5DWKPermitted Structure Names in CPS Statements2TNAMETable namenvarchar300
35T5DWNStatement Structure Fields (Conversion, Status...)2TNAMETable namenvarchar300
TOPConsolidation
36TF90MMigration EC-CS - SEM-BCS: Mapping of Field Names2TNAMEField Namenvarchar300
TOPContract Accounts Receivable and Payable
37TFK004MField name allocation in FI-CA -> FI field selection item2TNAMETable Namenvarchar300
38TFK021Line layout variants: Fields5TNAMETable Namenvarchar300
39TFK022CFields to be hidden2TNAMETable Namenvarchar300
40TFK022DFields to be hidden per screen variant3TNAMETable Namenvarchar300
TOPCorrespondence Tool
41DFKKCODCorrespondence - Correspondence Data9TNAMETable Namenvarchar300
42TFK070QCorrespondence - Master Data Change2TNAMETable namenvarchar300
43TFK070QFCorrespondence - Master Data Change - Fields2TNAMETable namenvarchar300
TOPCustom Development Management Cockpit
44CNVCDMCCA_EXITSCDMC : Customer exits Implemented in the system13TNAMEName of extended tablenvarchar300
45CNVCDMCCA_UEXITSCDMC : User exits Implemented in the system - Not Valid13TNAMEName of extended tablenvarchar300
46CNVCDMCCTS_EXITSCDMC : CTS Table to store the User Exits identified14TNAMEName of extended tablenvarchar300
TOPDangerous Goods Management
47ET001Conversion of Phrases in Table Fields (Field: Translation)3TNAMETable Namenvarchar300
48ET002Conversion of Phrases in Table Fields (Contents:Translation)3TNAMETable Namenvarchar300
TOPData Staging
49RSUPDINFOUpdate info (status and program)19TNAMEBooleannvarchar10
TOPDB2 Universal Database for UNIX NT
50DBSTATHDB6DB6: Statistical History of Application Monitor1TNAMETable namenvarchar300
51DBSTATIDB6DB6: Statistics for Indexes (Application Monitor)1TNAMETable namenvarchar300
52DBSTATTDB6DB6: Table Statistics for Application Monitor1TNAMETable namenvarchar300
TOPDocument Management Services
53SDOKMEXTSDOK/Model: Model Enhancements8TNAMETable Namenvarchar300
TOPFinancial Accounting
54/CCEE/FISIFP_BForign Payments in/out5TNAMETransaction namenvarchar350
55ICRC00_TEMPLFinancial Statement Reconciliation: Templates for Notificatn2TNAMEText of Length 30nvarchar300
56ICRC00_TEMPL_TXTFinancial Statement Recon.: Text for Notification Templates3TNAMEText of Length 30nvarchar300
57ICRC00_XBLNR_RLSBalance Sheet Recon.: Rules for Determining Reference Number2TNAMETable Namenvarchar300
58T021KFields for Line Layout Variants3TNAMETable Namenvarchar300
59T021SLine Layout Variant Special Fields2TNAMETable Namenvarchar300
60TFTMPTable for Time Stamp Comparison2TNAMETable Namenvarchar300
TOPForms
61T514KAllowed Table Names / Short IDs for Forms3TNAMETable namenvarchar50
62T514NAllowed Field Names for Forms3TNAMETable namenvarchar50
63T514STable Name Texts4TNAMETable namenvarchar50
64T514TField Name Texts4TNAMETable namenvarchar50
65T514XInput Help Routines for Identifiers in PE514TNAMETable namenvarchar50
TOPHR Information Systems
66T770RTable Accesses for HR Query2TNAMETable Namenvarchar300
TOPInformation System
67T044JPreference Key for Reading Valuation Results2TNAMETable Namenvarchar300
TOPIntegrated Product and Process Engineering
68OMC_DEPTable is obsolete (no longer used)1TNAME30 Charactersnvarchar300
69OMC_MDEPEnhanced Dependency Editor: Assign Scheme2TNAMEObjects of Enhanced Dependency Editornvarchar300
TOPJoint Venture und Production Sharing Accounting
70T8JHFFields to transport from sending to new receiving asset5TNAMETable Namenvarchar300
TOPLoans Management
71TDCO_OPT_TEXTCorrespondence Tool: Optional Text Modules6TNAMESmart Forms: Name of a text modulenvarchar300
TOPMaster Data
72T449SUser Settings: Sort for Table7TNAMETable Namenvarchar300
73T449TUser-Setting For Field Sequence To Display A Table7TNAMETable Namenvarchar300
TOPMetadata Repository
74RSQTOBJTable Objects in the InfoSet4TNAMEInfoProvidernvarchar300
TOPMicrosoft SQL Server
75MSSDEADLCKDatabase Deadlock Information for MSSQL Server12TNAMETable namenvarchar1280
TOPMonitoring
76ALPF_TESTDATARepository for Test Data2TNAMEName for Test Data Recordnvarchar400
TOPOverhead Cost Controlling
77TK01HTime-based CO master data2TNAMETable Namenvarchar300
TOPPayroll General Parts
78T52DNName Range for Processing and Evaluation Classes2TNAMETable namenvarchar50
TOPPerformance Assessment Workbench
79SLS_TESTPAW - Test Description11TNAMEPAW - Test Namenvarchar400
TOPPerformance Monitors TCC
80AMDSEffective size of tables and indexes in the database1TNAMETable namenvarchar300
81AMSPSQL trace position info in application monitor8TNAMETable name (extended version for application monitor)nvarchar300
82BUFCHECKException table of tables that cannot be buffered1TNAMETable Namenvarchar300
83DBSTAIHADAActual size of indices on the database (history)1TNAMETable namenvarchar300
84DBSTAIHORAActual size of indices on the database (history)1TNAMETable namenvarchar300
85DBSTATHADAActual size of tables on the database (history)1TNAMETable namenvarchar300
86DBSTATHORAActual size of tables on the database (history)1TNAMETable namenvarchar300
87DBSTATIADAActual size of indices on the database1TNAMETable namenvarchar300
88DBSTATIORAActual size of indices on the database1TNAMETable namenvarchar300
89DBSTATTADAActual size of tables on the database1TNAMETable namenvarchar300
90DBSTATTORAActual size of tables on the database1TNAMETable namenvarchar300
TOPPurchasing
91T166CPrint-Relevant Purchasing Document Changes2TNAMEChange document creation: Table namenvarchar300
92T16CDControl of Selection in Buyer Approval2TNAMEChange document creation: Table namenvarchar300
93T16CEOutput Control: Display of Change Documents in Purchasing3TNAMEChange document creation: Table namenvarchar300
94T16CRVersion-Relevant Fields of Purchase Requisition3TNAMETable Namenvarchar300
TOPRepository Browser
95DIRTREETree administration1TNAMEName of a tree objectnvarchar450
96TREELOGChange log for table TREE (tree administration)1TNAMEName of a tree objectnvarchar450
TOPReuse Services for Country Development
97T799BRNDFCField Dependent Rounding (customer specific settings)3TNAMETable Namenvarchar300
98T799BRNDFSField Dependent Rounding (SAP-delivery)2TNAMETable Namenvarchar300
TOPSouth Africa
99T5W67SARS Interface : Definition of Electronic Tax Certificate9TNAMETable Namenvarchar50
TOPVehicle Management System
100CVLC05VELO : Control Table Object Characteristics2TNAMETable, in which object characteristic is containednvarchar300
TOPWarranty Claim Processing
101WTY_TABLE_ALVAllowed Table WTY for Generic Field Attributes1TNAMEAllowed Tables for Generic Field Attributres ALVnvarchar300