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

138 columns | Print definition?ERP 6.0  | SAPRL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SYS_DETAILSsystem details for uniform files to the tax authorities1SAPRLRelease of SAP Systemnvarchar40
2/SAPF15/F15F15 Belege (Kopfdaten)25SAPRLRelease-Stand eines SAP-Systemsnvarchar40
3/SAPF15/F15HF15 Belege (Kopfdaten Historie)26SAPRLRelease-Stand eines SAP-Systemsnvarchar40
4/SAPF15/XPRAF15 XPRA Status10SAPRLEinstelliges Kennzeichennvarchar10
5/SLOAP/BC_INFOBasis information7SAPRLSAP Releasenvarchar40
6BBP_RBKPDocument Header: Invoice Receipt32SAPRLSAP Releasenvarchar40
7CNVCMIS_A_10_RUNcmis table for tracking execution of the analysis prg6SAPRLSAP Releasenvarchar40
8CNVPERFDATATable for database performance10SAPRLRelease of SAP Systemnvarchar40
9DRP_SMTC_HISTDEV Reporting (SE28): Metrics Data2SAPRLRelease of SAP Systemnvarchar40
10DRP_SMTC_HLISTDEV Reporting (SE28): Control Table2SAPRLRelease of SAP Systemnvarchar40
11MLAUFHHistory table for summarized MLAUF data19SAPRLRelease of SAP Systemnvarchar40
12P2B2_B2VERSIONHCM Declustering B2 - B2 Version7SAPRLnvarchar40
13P2RX_VERSIONInformation on Creation4SAPRLRelease of SAP Systemnvarchar40
14T021DLine Layout Fast Entry: Administration8SAPRLSAP Releasenvarchar40
15TBEKRApplication Area - Package Assignment3SAPRLSAP Releasenvarchar40
16TFRT_HISTORYTypeface Repo - History6SAPRLRelease of SAP Systemnvarchar40
17TKEBBManagement for Operating Concerns (Cross-Client)4SAPRLSAP release when last generatednvarchar40
18YIT_RELNIDA: Release Notes from TNODE01R1SAPRLRelease of SAP Systemnvarchar40
19YIT_RELN_TITELIDA: Text Table for High-Performance Help Function1SAPRLRelease of SAP Systemnvarchar40
20ZNOTRTables Excluded from Translation Process6SAPRLRelease of SAP Systemnvarchar40
TOPABAP Authorization and Role Management
21HRP1250DB table for infotype 125019SAPRLRelease of SAP Systemnvarchar40
22USOB_MODApplications for Upgrade Profile Generator (TCODE_MOD)1SAPRLRelease of SAP Systemnvarchar40
TOPAccounting Engine
23FINACHDAccounting Document Header35SAPRLSAP Releasenvarchar40
TOPActual CostingMaterial Ledger
24CKMLLACRML Activity Type: Period Record/Currency Record19SAPRLRelease of SAP Systemnvarchar40
25CKMLPPMaterial Ledger Period Totals Records Quantity10SAPRLRelease of SAP Systemnvarchar40
26MLAUFMaterial Ledger Item Table for Order History18SAPRLRelease of SAP Systemnvarchar40
TOPApplication Framework
27MDG_DEMO_TRANSCluster Table for Transport7SAPRLnvarchar40
28MDG_MDFTRANSCluster Table for Master Data Transport7SAPRLnvarchar40
29MDG_TR_DELIVPiecelists for Delivery in Master Data Environment2SAPRLSAP Releasenvarchar100
30MDG_TR_TRANSCluster Table for Master Data Transport7SAPRLnvarchar40
TOPBank Accounting
31REGUTTemSe - Administration Data31SAPRLRelease of SAP Systemnvarchar40
TOPBasic Functions
32T800AFI-SL tables24SAPRLSAP Release for which the table was installednvarchar40
33VBUKSales Document: Header Status and Administrative Data58SAPRLSAP Releasenvarchar40
TOPBasic functions
34VEKPHandling Unit - Header Table73SAPRLSAP Releasenvarchar40
TOPBusiness Accounting
35/EACC/TRANSBusiness Accounting: Metadata Transport7SAPRLnvarchar40
36URBWLGRealigner: Status Information for DataSource28SAPRLRelease of SAP Systemnvarchar40
TOPBusiness Service Functions
37RTXTHHeader Table for Report Texts14SAPRLRelease of SAP Systemnvarchar40
TOPCATT Computer Aided Test Tool
38CATKCATT: Log Process Data17SAPRLRelease of SAP Systemnvarchar40
TOPClient Copy
39CCCFLOWClient Copy Control Flow16SAPRLSAP Releasenvarchar40
TOPCoding Block
40TCOBACoding Block: Customer Subscreens (Header)8SAPRLRelease of SAP Systemnvarchar40
41TCOBNCoding Block: Customer Fields13SAPRLRelease of SAP Systemnvarchar40
TOPCondition Technique
42/SAPCND/T681Condition Table Structure9SAPRLRelease of SAP Systemnvarchar40
TOPConditions
43T681Conditions: Structures12SAPRLRelease of SAP Systemnvarchar40
44T681YConditions: List Variants10SAPRLRelease of SAP Systemnvarchar40
45T682Conditions: Access Sequences11SAPRLRelease of SAP Systemnvarchar40
TOPContract Accounts Receivable and Payable
46TFK021DScreen variants: Administration8SAPRLScreen variants: Creation version (display field)nvarchar40
47TFK021KSubscreen Management (SAP)11SAPRLScreen variants: Creation version (display field)nvarchar40
48TFK021KCDetail Screen Structure for Document Display (Customer)10SAPRLScreen variants: Creation version (display field)nvarchar40
TOPContract Billing
49EUPDLOGHDISU: Header Data of Update Log for Rate Transport12SAPRLRelease of SAP Systemnvarchar40
TOPCost Center Accounting
50KPP0RCO planning: directory of generated reports7SAPRLRelease of SAP Systemnvarchar40
51KPP2DCO planning: directory of generated dumps9SAPRLRelease of SAP Systemnvarchar40
TOPCross-Application Components
52VVBUKSales Document: Header Status and Administrative Data58SAPRLSAP Releasenvarchar40
TOPCross-Application Mass Maintenance
53MASSVARDBVariants for Mass Maintenance6SAPRLRelease of SAP Systemnvarchar40
54MASSVARIANTVariants: Basic Information5SAPRLRelease of SAP Systemnvarchar40
55MASSVARIANT_SSystem Variants: Basic Information4SAPRLRelease of SAP Systemnvarchar40
56MASSVARTRMass Maintenance Variants in Transportable Form6SAPRLRelease of SAP Systemnvarchar40
TOPData Collection
57TKCAAspects6SAPRLSAP releasenvarchar40
58TKCCOComment tables3SAPRLSAP releasenvarchar40
TOPData Retention Tool
59TXW_C_V0Data view: Header5SAPRLRelease of SAP Systemnvarchar40
60TXW_DIRData file log (replaced by txw_dir2, use of guids)10SAPRLRelease of SAP Systemnvarchar40
61TXW_DIR2Data file log12SAPRLRelease of SAP Systemnvarchar40
62TXW_DIRSEGData file segment directory (replaced by txw_dirsg2: uuids)24SAPRLRelease of SAP Systemnvarchar40
63TXW_DIRSG2Data file segment directory24SAPRLRelease of SAP Systemnvarchar40
64TXX_ADMI_EXTRDART-Administration --- Extract_Data---15SAPRLRelease of SAP Systemnvarchar40
65TXX_C_V0View: Header Area5SAPRLRelease of SAP Systemnvarchar40
66TXX_EXTR_TEMPLDART-Administration --- Extract_Data---11SAPRLRelease of SAP Systemnvarchar40
TOPDB2 for OS39
67DBSYCHKDB2DB2/390: Global Information for Database System Check4SAPRLRelease of SAP Systemnvarchar40
TOPDownstream
68TOI0_BCSETSBC-Sets to be activated externally / log for activated5SAPRLRelease of SAP Systemnvarchar40
TOPEnd User Technology
69RSRA_BP_RTXTHReport Agent BP Transport Copy/Versioning of rtxth14SAPRLRelease of SAP Systemnvarchar40
TOPFinancial Accounting
70TNAMNPuffer for Keywords (NAMETAB)7SAPRLSAP Releasenvarchar40
TOPFinancials Basis
71FINB_DEMO_TRANSFINB Transport: Cluster Table for Transport7SAPRLnvarchar40
72FINB_TR_DELIVFINB TR: Bill of Material for Delivery2SAPRLSAP Releasenvarchar100
73FINB_TR_DERIVEFINB-Transport: Table for Transporting the ABA Derivation7SAPRLnvarchar40
74FINB_TR_TRANSFINB Transport: Cluster Table for Transport7SAPRLnvarchar40
75UGCMBACKData Model Synchronization: Backup for Conversion9SAPRLSAP Releasenvarchar100
76UGMDTRANSFIN Master Data: Cluster Table for Transport7SAPRLnvarchar40
77UGMD_BACKFIN Master Data: Cluster Table for Transport6SAPRLnvarchar40
TOPImplementation Guide
78CTIMPEXCLogical import: exception table6SAPRLRelease of SAP Systemnvarchar40
TOPInterest
79TZIN1Document Header Data from Source Document (PS Int.Calc.)8SAPRLSAP Releasenvarchar40
TOPInventory Accounting
80UAINVDEBCRHDocument for Revaluation Through Material Debit/Credit10SAPRLRelease of SAP Systemnvarchar40
81UAINVREVALHDocument for INV Price Change and Inventory Revaluation12SAPRLRelease of SAP Systemnvarchar40
TOPInventory Management
82MMIM_PREDOC_ORGParked Material Documents, Organizational Data7SAPRLRelease of SAP Systemnvarchar40
83MMINKON_UPCorrections due to Technical Problems with Stock25SAPRLSAP Releasenvarchar40
TOPInvoice Verification
84RBKPDocument Header: Invoice Receipt32SAPRLSAP Releasenvarchar40
TOPJoint Venture und Production Sharing Accounting
85RGJAFVC470Control table for transfer JV data from AFVC to AFVU11SAPRLRelease of SAP Systemnvarchar40
TOPMonitoring
86SCSM_MONSYS_BUFBuffer Table ALSYSTEM6SAPRLRelease of SAP Systemnvarchar40
TOPOrganizational Management
87HRP1016Infotype 1016 DB Table19SAPRLRelease of SAP Systemnvarchar40
88HRP1205Infotype 1205 DB Table23SAPRLRelease of SAP Systemnvarchar40
89HRP1220DB Table for Infotype 1220 Activity Profile19SAPRLRelease of SAP Systemnvarchar40
90HRS1205Standard Infotype 1205 Workflow Definition10SAPRLRelease of SAP Systemnvarchar40
TOPOverhead Cost Orders
91AUAKDocument Header for Settlement24SAPRLSAP Releasenvarchar40
TOPPerformance Monitors TCC
92AMSKSQL trace header info in application monitor2SAPRLRelease of SAP Systemnvarchar40
93AMSPSQL trace position info in application monitor2SAPRLRelease of SAP Systemnvarchar40
TOPPeriodic Material Valuation
94CKMLDELTAPOSTTemporary Storage for Delta Postings for Cumulation8SAPRLSAP Releasenvarchar40
TOPProduct Cost by Period
95CKPHMaster Record: Cost Object ID Number31SAPRLRelease the document as it was last savednvarchar40
TOPProduct Cost Planning
96KEKOProduct Costing - Header Data76SAPRLRelease the document as it was last savednvarchar40
TOPProfitability Analysis
97/EACA/TPMTRANSCluster Table for Metadata Transport7SAPRLnvarchar40
98TKEBManagement for Operating Concerns (Client-Specific)3SAPRLSAP release when last generatednvarchar40
99TKEBAStatus of Operating Concern (Client-Specific)3SAPRLSAP release when last generatednvarchar40
100TKEBWLGCO-PA Connectn to SAP BW: Status Information for InfoSource30SAPRLRelease of SAP Systemnvarchar40
101TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource26SAPRLRelease of SAP Systemnvarchar40
102TKEHISTUpgrade History9SAPRLSAP release when last generatednvarchar40
103TKEPVERSTable for New PVERS Logic (Industry-Specific)2SAPRLSAP release when last generatednvarchar40
104TKEPVERS_DOKUPVERS Logic - Description of Program Versions2SAPRLSAP release when last generatednvarchar40
105TKETRANSCO-PA: Cluster Table for Transporting Metadata7SAPRLSAP release when last generatednvarchar40
106TKETRLGSummarization Levels: Catalog entry, header (generated obj.)12SAPRLVersion of generated programsnvarchar40
TOPPurchasing
107EKBEHistory per Purchasing Document57SAPRLSAP Releasenvarchar40
108EKBEHRemoved PO History Records57SAPRLSAP Releasenvarchar40
109EKBZHistory per Purchasing Document: Delivery Costs35SAPRLSAP Releasenvarchar40
110EKBZHHistory per Purchasing Document: Delivery Costs35SAPRLSAP Releasenvarchar40
TOPRisk Analysis
111JBRRMBBFAnalysis Structure4SAPRLSAP Release for last generationnvarchar40
TOPRuntime
112SWFGPDEPLOYGuided Procedures Deployment-Run5SAPRLRelease of SAP Systemnvarchar40
TOPSales and Distribution SD enhancements
113VSVBUK_CNSales Document: Header Status and Administrative Data59SAPRLSAP Releasenvarchar40
TOPSAP Business Workflow
114OJDEFLObjects in the SAP System: definitions load4SAPRLRelease of SAP Systemnvarchar40
115SWD_HRS1205Copy of HRS1205 (Last Active Version)8SAPRLRelease of SAP Systemnvarchar40
116SWF_POPCONWF: Control table for display of "What's new?" dialogs3SAPRLRelease of SAP Systemnvarchar40
117SWF_POPUP1Popups for "What's new?" Display3SAPRLRelease of SAP Systemnvarchar40
118SWF_WFPCONWF: Control table for single actions in a release3SAPRLRelease of SAP Systemnvarchar40
119SWJPHEADHeader Table for Parameter Condition7SAPRLRelease of Systemnvarchar40
120SWLWPLOGSYSLogical Handler System3SAPRLBasis Releasenvarchar40
TOPSAP NetWeaver Mobile - Use subcomponents
121MEREP_401SyncBO ID12SAPRLSAP Release at Synchronizer Generationnvarchar40
TOPSecurity
122LAW_PROTLog Table for License Audit Workbench6SAPRLRelease of SAP Systemnvarchar40
TOPSets
123SETHEADERSet Header and Directory16SAPRLRelease of SAP Systemnvarchar40
TOPTrading Contract
124WB2_MAP_CONTROLGT: Generation Status for Field Mapping4SAPRLRelease of SAP Systemnvarchar40
TOPTranslation Tools
125NOINDTables Excluded from Conversion7SAPRLRelease of SAP Systemnvarchar40
126NOTRATables Excluded from Translation Process6SAPRLRelease of SAP Systemnvarchar40
TOPTreasury
127TTMRBAdministration of Risk Management areas (indep. of client)4SAPRLSAP release when last generatednvarchar40
TOPUpgrade - General
128UMODHDRUpgrade Modification Information1SAPRLSAP Releasenvarchar40
129UMODOBJUpgrade Modification Information: Objects1SAPRLSAP Releasenvarchar40
TOPUpgrade Tools
130DDCDIMDD: Conversion, number of table lines2SAPRLSAP Releasenvarchar40
131DDCNVSTATDD: Statistical Data for Conversion7SAPRLRelease of SAP Systemnvarchar40
132DDCPRODD: Conversion projects2SAPRLSAP Releasenvarchar40
133DDCPROTDD: Text on conversion projects2SAPRLSAP Releasenvarchar40
134DDCPROTABDD: Table for conversion projects2SAPRLSAP Releasenvarchar40
135DDCSTATDD: Statistics table for conversions2SAPRLSAP Releasenvarchar40
136DDICNVLSTContains information on converter exits2SAPRLSAP Releasenvarchar40
137DDSTATHISTDD: Statistical Data for Conversion7SAPRLRelease of SAP Systemnvarchar40
TOPURL Generation
138TWPSRVLOGSRuntime for Release Status of Logical System (Workplace Srv)2SAPRLSAP Releasenvarchar40