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

48 columns | Print definition?ERP 6.0  | FILTER_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/RCFUIX/FLT_IDSJob Filter Bookmarks2FILTER_IDJob Filter Bookmark IDvarbinary160
2T7CNRMP_CUSTEXTCustomer Exit5FILTER_IDFilter ID of BAdInvarchar100
3T7CNRMP_CUST_PDConfiguration Table for Fields in Organization Management8FILTER_IDFilter ID of BAdInvarchar100
TOPActual CostingMaterial Ledger
4CKMLMV011TFilter hierarchies1FILTER_IDHierarchy for displaying costing run resultsnvarchar40
TOPASAP AcceleratedSAP
5SQACITFCI template project to filter assignment2FILTER_IDGUID for Structurenvarchar320
6SQACYCLECycles in Q&Adb3FILTER_IDGUID for Structurenvarchar320
TOPBRFplus - ABAP-Based Business Rules
7FDT_FILTER_0002FDT: Filter - Included Filters4FILTER_IDFDT: Universal Unique Identifiernvarchar320
8FDT_FILTER_0002AFDT: Filter - Included Filters4FILTER_IDFDT: Universal Unique Identifiernvarchar320
9FDT_FILTER_0002SFDT: Filter - Included Filters3FILTER_IDFDT: Universal Unique Identifiernvarchar320
10FDT_FILTER_0002TFDT: Filter - Included Filters3FILTER_IDFDT: Universal Unique Identifiernvarchar320
11FDT_FNCT_0100FDT: Function - Attributes6FILTER_IDFDT: Universal Unique Identifiernvarchar320
12FDT_FNCT_0100AFDT: Function - Attributes6FILTER_IDFDT: Universal Unique Identifiernvarchar320
13FDT_FNCT_0100SFDT: Function - Attributes5FILTER_IDFDT: Universal Unique Identifiernvarchar320
14FDT_FNCT_0100TFDT: Function - Attributes5FILTER_IDFDT: Universal Unique Identifiernvarchar320
15FDT_WD_FILTERFDT WD: Filter Assignment to user3FILTER_IDFDT: Universal Unique Identifiernvarchar320
TOPBusiness Navigator
16DF50DVariant diagram radio button1FILTER_IDFilternvarchar200
17DF52AFilter Action Log1FILTER_IDFilternvarchar200
18DF52LFilter1FILTER_IDFilternvarchar200
19DF52TFilter names2FILTER_IDFilternvarchar200
20DF53SActive variant on variant node1FILTER_IDFilternvarchar200
21DF54SActive nodes for a variant1FILTER_IDFilternvarchar200
22DF55LVariants1FILTER_IDFilternvarchar200
23DF55TVariant name3FILTER_IDFilternvarchar200
24DFMLOLinks from R/3 Reference Model objects to mail folder2FILTER_IDFilternvarchar200
TOPCorrespondence Tool
25TRCV_FILTERIDBAdI Filter Values for Dynamic Recipient Determination1FILTER_IDBAdI Filter Value for Dynamic Recipient Determinationnvarchar200
26TRCV_FILTERIDTBAdI Filter Values for Dynamic Recipient Determ. (Texts)2FILTER_IDBAdI Filter Value for Dynamic Recipient Determinationnvarchar200
27TRCV_FILTERID_CSClient-Dep. BAdI Filter Values for Dynamic Recipient Determ.2FILTER_IDBAdI Filter Value for Dynamic Recipient Determinationnvarchar200
TOPData Replication Framework
28DRFD_APPL_FILT_CFilterCriteria6FILTER_IDFilter for a Filter Objectnvarchar20
TOPDistributed System Landscape
29/ISDFPS/XI_FILTXI Filter for Prioritized Message Dispatch4FILTER_IDFilter IDvarbinary160
TOPEngineering Desktop
30EDESK_SELVAREngineering Desktop: Table for Managing Selection Variants7FILTER_IDName of Filter in iPPE Workbenchnvarchar400
TOPGeneral
31LWMHR_D_MYM_QYFLFilter Values for Query Variants of HR Business Partner4FILTER_IDNatural Numberint100
TOPHierarchy Storage
32TTREV_NODEHierarchy Tool: Structure Versioning Node Table20FILTER_IDUnique ID - 32 charactersnvarchar320
TOPIntegration Engine
33SXMS_EXT_FILFilter for Extractors2FILTER_IDFilter ID for Data Extractionvarbinary160
34SXMS_LMS_EXTRLean Message Search Extractor3FILTER_IDFilter ID for Data Extractionvarbinary160
35SXMS_NSPREFIXTable for Extractor Namespace Prefixes2FILTER_IDFilter ID for Data Extractionvarbinary160
36SXMS_PACKCOUNTCounter for Packaged Messages2FILTER_IDFilter IDvarbinary160
TOPMedia Product Sales and Distribution
37TJKSD13FILTERMedia Issue Worklist: Selection Filters2FILTER_IDIS-M: Filter for Selection in Media Issue Worklistnvarchar20
38TJKSD13FILTERTSelection Filter Descriptions2FILTER_IDIS-M: Filter for Selection in Media Issue Worklistnvarchar20
39TJKSD13FILTERZUOAssignment of Filters to Media Issue Worklist Filter Group3FILTER_IDIS-M: Filter for Selection in Media Issue Worklistnvarchar20
40TJKSDFIHIERZUOFilter Assignment to Structure Nodes4FILTER_IDFilter for Quantity Planning Viewnvarchar30
41TJKSDFILTERFilter for Quantity Planning View2FILTER_IDFilter for Quantity Planning Viewnvarchar30
42TJKSDFILTERTText - Filter for Quantity Planning View2FILTER_IDFilter for Quantity Planning Viewnvarchar30
43TJKSDVIEWFILTERAssignment of Filters to Quantity Planning Views4FILTER_IDFilter for Quantity Planning Viewnvarchar30
TOPRuntime WorkbenchMonitoring
44SXMSMSGFILTERSAP XI: Filter for Sender/Receiver Attributes2FILTER_IDSAP XI: Filter ID for Sender/Receiver Attributesnvarchar400
TOPSAP Business Workflow
45SWF_TRC_HFILTTrace: Hierarchy Filter2FILTER_IDUnique ID in Tracevarbinary160
46SWF_TRC_SELOPTTrace: Hierarchy Filter2FILTER_IDUnique ID in Tracevarbinary160
TOPTest Organizer
47ISSUE_RELIssue Management: Relationship Table (Project, Issue)7FILTER_IDUnique ID - 32 charactersnvarchar320
48ISSUE_RELATIONIssue Management: Relationship Table (Project, Issue)8FILTER_IDUnique ID - 32 charactersnvarchar320