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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

100 tablesERP 6.0 

Cross-Application Components :: General Application Functions :: Data Retention Tool
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DARTEOL_LOG21Lock object for log fileData Retention Tool
2ERP EHP76.0TXA_C_BUKRS31Settings for company codesData Retention Tool
3ERP EHP76.0TXW_C_BUKRS31Settings for company codesData Retention Tool
4ERP EHP76.0TXW_C_GLO31Global settings (fields from structure TXW_GLOBAL)Data Retention Tool
5ERP EHP76.0TXW_C_REF51Reference for currency/amount fieldsData Retention Tool
6ERP EHP76.0TXW_C_RELA81Relations of tables and domainsData Retention Tool
7ERP EHP76.0TXW_C_SKIP_SEG31Customizing skip segmentsData Retention Tool
8ERP EHP76.0TXW_C_SOEX21Source tables and export structuresData Retention Tool
9ERP EHP76.0TXW_C_STRC151Segment structuresData Retention Tool
10ERP EHP76.0TXW_C_V0151Data view: HeaderData Retention Tool
11ERP EHP76.0TXW_C_V0T41Data view: DescriptionData Retention Tool
12ERP EHP76.0TXW_C_V141Data view: Data segmentsData Retention Tool
13ERP EHP76.0TXW_C_V281Data view: Join conditionsData Retention Tool
14ERP EHP76.0TXW_C_V2S51Data view: Standard join conditionsData Retention Tool
15ERP EHP76.0TXW_C_V381Data view: View fieldsData Retention Tool
16ERP EHP76.0TXW_C_V471Data view: Selection conditionsData Retention Tool
17ERP EHP76.0TXW_C_VOL41Data file directory setsData Retention Tool
18ERP EHP76.0TXW_C_VOLD41Data file directoriesData Retention Tool
19ERP EHP76.0TXW_C_VOLT41Data file directory set descriptionsData Retention Tool
20ERP EHP76.0TXW_DIR411Data file log (replaced by txw_dir2, use of guids)Data Retention Tool
21ERP EHP76.0TXW_DIR2461Data file logData Retention Tool
22ERP EHP76.0TXW_DIRAL161Data file log - ArchiveLink (obsolete after rel 99)Data Retention Tool
23ERP EHP76.0TXW_DIRAL2181Data file log - ArchiveLinkData Retention Tool
24ERP EHP76.0TXW_DIRSEG282Data file segment directory (replaced by txw_dirsg2: uuids)Data Retention Tool
25ERP EHP76.0TXW_DIRSG2282Data file segment directoryData Retention Tool
26ERP EHP76.0TXW_FSZH21DART: file size settings headerData Retention Tool
27ERP EHP76.0TXW_FSZR41DART: file size estimator settings recordsData Retention Tool
28ERP EHP76.0TXW_FSZT41DART: file size settings descriptionData Retention Tool
29ERP EHP76.0TXW_IBU41DART: IBU add-on extraction function modulesData Retention Tool
30ERP EHP76.0TXW_INDEX61Temporary table for data segment indexData Retention Tool
31ERP EHP76.0TXW_INDEX_0161Temporary table for data segment indexData Retention Tool
32ERP EHP76.0TXW_INDEX_0261Temporary table for data segment indexData Retention Tool
33ERP EHP76.0TXW_INDEX_0361Temporary table for data segment indexData Retention Tool
34ERP EHP76.0TXW_INDEX_0461Temporary table for data segment indexData Retention Tool
35ERP EHP76.0TXW_INDEX_0561Temporary table for data segment indexData Retention Tool
36ERP EHP76.0TXW_LOCK111Lock object for INDX (Tax Data retention)Data Retention Tool
37ERP EHP76.0TXW_LOCK221Lock object for data fileData Retention Tool
38ERP EHP76.0TXW_R_STAT111Status/Trace for TXW-data retrieval from archivesData Retention Tool
39ERP EHP76.0TXW_S_ANEA391Retrieve ANEA from archiveData Retention Tool
40ERP EHP76.0TXW_S_ANEK382Retrieve ANEP from archiveData Retention Tool
41ERP EHP76.0TXW_S_ANEP291Retrieve ANEP from archiveData Retention Tool
42ERP EHP76.0TXW_S_BKPF472Retrieve BKPF from archiveData Retention Tool
43ERP EHP76.0TXW_S_BSEG1241Retrieve BSEG from archiveData Retention Tool
44ERP EHP76.0TXW_S_COBK303Retrieve COBK from archiveData Retention Tool
45ERP EHP76.0TXW_S_COEP451Retrieve COEP from archiveData Retention Tool
46ERP EHP76.0TXW_S_COFI242Retrieve COFIS from archiveData Retention Tool
47ERP EHP76.0TXW_S_EKKO221Retrieve EKKO from archiveData Retention Tool
48ERP EHP76.0TXW_S_EKPO291Retrieve EKPO from archiveData Retention Tool
49ERP EHP76.0TXW_S_GLT0633Retrieve archived GLT0 dataData Retention Tool
50ERP EHP76.0TXW_S_KNC1591Retrieve archived Customer master dataData Retention Tool
51ERP EHP76.0TXW_S_LFC1551Retrieve archived Vendor master (transaction figures) dataData Retention Tool
52ERP EHP76.0TXW_S_LIKP181Retrieve LIKP from archiveData Retention Tool
53ERP EHP76.0TXW_S_LIPS321Retrieve LIPS from archiveData Retention Tool
54ERP EHP76.0TXW_S_MKPF241Retrieve MKPF from archiveData Retention Tool
55ERP EHP76.0TXW_S_MSEG631Retrieve MSEG from archiveData Retention Tool
56ERP EHP76.0TXW_S_VBAK171Retrieve VBAK from archiveData Retention Tool
57ERP EHP76.0TXW_S_VBAP211Retrieve VBAP from archiveData Retention Tool
58ERP EHP76.0TXW_S_VBPA111Retrieve VBPA from archiveData Retention Tool
59ERP EHP76.0TXW_S_VBRK501Retrieve VBRK from archiveData Retention Tool
60ERP EHP76.0TXW_S_VBRP541Retrieve VBRP from archiveData Retention Tool
61ERP EHP76.0TXW_VARIA91Contents of Variant of TXW-archive retrievalData Retention Tool
62ERP EHP76.0TXW_VC_LOCK21Locktable view outputData Retention Tool
63ERP EHP76.0TXW_VWLOG291View query log (replaced by txw_vwlog2: uuids)Data Retention Tool
64ERP EHP76.0TXW_VWLOG2321View query logData Retention Tool
65ERP EHP76.0TXW_VWLOG2_U41Data view query logData Retention Tool
66ERP EHP76.0TXW_VWLOGAL2171View query log - ArchiveLinkData Retention Tool
67ERP EHP76.0TXX_ADMI_EXTR182DART-Administration --- Extract_Data---Data Retention Tool
68ERP EHP76.0TXX_ADMI_PAR101DART-Administration ---Segment-Management---Data Retention Tool
69ERP EHP76.0TXX_ADMI_RES101DART-Administration ---Resource Management ---Data Retention Tool
70ERP EHP76.0TXX_ADMI_SEGS101DART-Administration ---Segment-Management---Data Retention Tool
71ERP EHP76.0TXX_ADMI_VW241DART Administration: Tax View FileData Retention Tool
72ERP EHP76.0TXX_ADMI_VW_U31DART Administration: Tax View RelationshipsData Retention Tool
73ERP EHP76.0TXX_APPL31Value Table: ApplicationsData Retention Tool
74ERP EHP76.0TXX_APPLT41Value Table: ApplicationsData Retention Tool
75ERP EHP76.0TXX_ARCH_OBJ61Archiving Object Assignment ILMData Retention Tool
76ERP EHP76.0TXX_CON91Control Information: SAP SegmentsData Retention Tool
77ERP EHP76.0TXX_C_CON81Control Information: Customer-Specific SegmentsData Retention Tool
78ERP EHP76.0TXX_C_DATASETS31Assignment of Segments to DatasetsData Retention Tool
79ERP EHP76.0TXX_C_DSET_NAMES21Datasets - Value TableData Retention Tool
80ERP EHP76.0TXX_C_DSET_NAMET41Datasets - Text TableData Retention Tool
81ERP EHP76.0TXX_C_GLO31Basic SettingsData Retention Tool
82ERP EHP76.0TXX_C_REF51Reference for Currency and Quantity FieldsData Retention Tool
83ERP EHP76.0TXX_C_RELA81Relationships Between SegmentsData Retention Tool
84ERP EHP76.0TXX_C_SEL_FL_D41Customizing: Display Selection IndicatorsData Retention Tool
85ERP EHP76.0TXX_C_SOEX31Reference Tables for SegmentsData Retention Tool
86ERP EHP76.0TXX_C_STRC71Segments for Data ExtractionData Retention Tool
87ERP EHP76.0TXX_C_STRCT41Segment DescriptionData Retention Tool
88ERP EHP76.0TXX_C_V0111View: Header AreaData Retention Tool
89ERP EHP76.0TXX_C_V0T41View: DescriptionData Retention Tool
90ERP EHP76.0TXX_C_V141View: Data SegmentsData Retention Tool
91ERP EHP76.0TXX_C_V281View: Join ConditionsData Retention Tool
92ERP EHP76.0TXX_C_V361View: View FieldsData Retention Tool
93ERP EHP76.0TXX_C_VOL31View File: Directory SetData Retention Tool
94ERP EHP76.0TXX_C_VOLT41View File: Directory Set DescriptionData Retention Tool
95ERP EHP76.0TXX_EXTR_TEMPL142DART-Administration --- Extract_Data---Data Retention Tool
96ERP EHP76.0TXX_LOCK111Lock Object for INDX (Control Data Retention)Data Retention Tool
97ERP EHP76.0TXX_RAOB31Registered Archiving ObjectData Retention Tool
98ERP EHP76.0TXX_RAOB_TABLES51Table classification of registered Archiving ObjectData Retention Tool
99ERP EHP76.0TXX_SEL_FLAGS41Selection ParametersData Retention Tool
100ERP EHP76.0TXX_VC_LOCK61Lock Table - Generated TablesData Retention Tool