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  | REL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NWS_EXT_MAP_DATAMapping Data Extract ByD3RELSAP Releasenvarchar100
2NWS_EXT_OBJData Transport Management Tool Data Objects25RELSAP Releasenvarchar100
3TLANOCSSprachentransport - OCS Import3RELRelease-Stand eines SAP-Systemsnvarchar40
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
4CRMEXPVERSRefDB: Export Information for Delivery System7RELSAP Releasenvarchar100
TOPASAP AcceleratedSAP
5TCUSTEMPCustomizing templates entity table2RELProject Releasenvarchar40
TOPATC extensions for Technical Check
6SATCEXPVERSRefDB: Export Information for Delivery System7RELSAP Releasenvarchar100
TOPBusiness Navigator
7DF40DDiagam Management Information11RELFirst Releasenvarchar40
8DF41SNodes13RELFirst Releasenvarchar40
9DF42SLinks14RELFirst Releasenvarchar40
TOPCustomer Enhancements
10MODWRDKey words of changed DE2RELSAP Releasenvarchar40
TOPEnd User Technology
11RSZWMDVERSIONMap release/ehp/sps information to BI 7.x+ metadata version2RELSAP Releasenvarchar100
TOPEngineering Change Management
12COMM_IL_ECMCHGEngineering Change Management: Change Graph11RELReleased Ondecimal150
13ECM_VALValidity5RELReleased Ondecimal150
14ECM_VALHValidity - Full History5RELReleased Ondecimal150
TOPF1 Help
15HLPRESOLCClient-Dependent Context Chains4RELEnhancement Releasenvarchar120
16HLPRESOLSDefault Context Chain3RELEnhancement Releasenvarchar120
TOPImplementation Guide
17SFRELNSAPfind: Attributes of the Release Notes2RELChanged in Release:nvarchar40
TOPIncentive and Commission Management ICM
18CACS00_STAT_CASStatistics for Memory Requirement of Commission Cases (DB)10RELMemory Requirement in Bytesint100
TOPInstallation Tools
19INSTCHKTABSAP Installation: Table for Check Routines for RRR1RELRelease of SAP Systemnvarchar40
20INSTCHKTBTSAP Installation: Texts for RRR Check Routines2RELRelease of SAP Systemnvarchar40
21INSTCNTLSAP Installation: Control Table for Basis Customizing1RELSAP Releasenvarchar40
22INSTCNTLJBackground Jobs During the Installation1RELSAP Releasenvarchar40
23INSTCNTLTSAP Installation: Texts for Control Table2RELSAP Releasenvarchar40
TOPKnowledge Warehouse
24IWEXTENDEnhancement Information: Add-On and Customer2RELEnhancement Releasenvarchar120
25IWEXTENDTEnhancement Information - Text Table3RELEnhancement Releasenvarchar120
26PROD_D_SUBKWSTAT: Definition of PROD_DOCU Sub-Structures2RELStandard or Enhancement Releasenvarchar120
TOPLanguage Transport
27TLANEXPLanguage Transport: Export Actions4RELRelease of SAP Systemnvarchar40
28TLANIMPLanguage Transport: Import Action3RELRelease of SAP Systemnvarchar40
29TLANSUPLanguage Transport: Supplementation Action3RELRelease of SAP Systemnvarchar40
30TLSY3Control File for Language Import1RELRelease of SAP Systemnvarchar40
31TLSY5Control table delta import2RELSAP Releasenvarchar40
32TLSY7Language Import History1RELRelease of SAP Systemnvarchar40
TOPLogistics Basic Data
33DMF_D_ARTTransfer Status of Articles5RELRelevance Indicatornvarchar10
34DMF_D_ART_SITETransfer Status of Article/Site Combinations6RELRelevance Indicatornvarchar10
35DMF_D_MATKLRelevant Merchandise Categories4RELRelevance Indicatornvarchar10
36DMF_D_MTARTRelevant Article Types4RELRelevance Indicatornvarchar10
37DMF_D_SITETransfer Status of Sites5RELRelevance Indicatornvarchar10
38DMF_D_VENDORTransfer Status of Vendors5RELRelevance Indicatornvarchar10
TOPProduct Safety
39TCG11SETEHS: Definition of the Sequence of Tab Pages10RELPriority of the Assessment Tab Pagenvarchar20
TOPProfitability Analysis
40TKEDRUPGRADECharacteristic Derivation: CO-PA Conversions from 3.0/3.17RELSAP Releasenvarchar40
TOPRetail Demand Management
41DMF_D_ARTHIERTransfer Status of Material Hierarchy6RELRelevance Indicatornvarchar10
TOPTerminologyGlossary
42STERM_EXTDEnhancement Information: Add-On and Customer2RELEnhancement Releasenvarchar120
43STERM_XTNDEnhancement Information: Add-On and Customer2RELEnhancement Releasenvarchar120
44STERM_XTNTEnhancement Information - Text Table3RELEnhancement Releasenvarchar120
TOPTranslation Tools
45BRALOGIndustry log for import/activation of industries1RELRelease for industrynvarchar30
TOPUpgrade - General
46EXP_VERSExport Information for Delivery Systems6RELSAP Releasenvarchar100
47MERGECLILCommand File Input for Merger4RELSAP Releasenvarchar100
48UPGXPRAUpg: Log Table for RSXPRAUP2RELSAP Releasenvarchar100