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

149 columns | Print definition?ERP 6.0  | STARTDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SHAAMWithholding tax for vendors from shaam3STARTDATEWhithholding tax start datenvarchar80
2/CEERE/FUCTax Offices - time dependent2STARTDATEStart Datenvarchar80
3/CEERE/FUKDCTax office: master data - time dependent2STARTDATEStart Datenvarchar80
4/CEERE/FURRegional Tax Office Workplace2STARTDATEStart Datenvarchar80
5/CEERE/FU_REGWRegional Tax Office Workplace2STARTDATEStart Datenvarchar80
6/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)9STARTDATEStartterminnvarchar80
7/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)10STARTDATEStartterminnvarchar80
8/OTX/RM_TMONITORMonitored jobs information3STARTDATEDate of entry into job lognvarchar80
9CNVA_00555_STATEState Table for Run Time Estimation7STARTDATEField of type DATSnvarchar80
10CNVA_CCD_ANA_STAState Table for CC Deletion Analysis Package8STARTDATEField of type DATSnvarchar80
11CNVC_SCNG_EXTRExtracts4STARTDATEDatenvarchar80
12CNV_20308_CMPHeader Data for Package Comparison27STARTDATEDatenvarchar80
13CNV_20308_DLDownloads14STARTDATEDatenvarchar80
14CNV_ADT_DP_LOGT. Summary: Data provider execution log (single DP)5STARTDATEDatenvarchar80
15CNV_ADT_DP_LOGPT. Summary: Data provider execution log (whole package)5STARTDATEDatenvarchar80
16CNV_INDX_CHECKSCheck executions for the given package4STARTDATESystem Datenvarchar80
17DMC_IU_UVERSMWB: Backup Copy of UVERS3STARTDATEDatenvarchar80
18DMC_MDS_AVERSMDS: Information About Updates of R/3 Add-On Products5STARTDATEDatenvarchar80
19DMC_MDS_UVERSMDS: Backup of Upgrade Information4STARTDATEDatenvarchar80
20SUBST_SLANA_HDRSL Analytics Header Data5STARTDATEnvarchar80
21ZSKCOURSEStraining courses4STARTDATEnvarchar80
22ZSKCSPHJ02csp2STARTDATESystemdatumnvarchar80
23ZSKSCHEDULECourse schedule for standard training5STARTDATEnvarchar80
24ZTR_COURSEStraining courses7STARTDATEnvarchar100
25HRP1774DB Table for Infotype 177421STARTDATEStart Date of Individual Worknvarchar80
26T7PIQ_NL_COUNTRYCountries4STARTDATEStart Datenvarchar80
27T7PIQ_NL_NATITYNationalities4STARTDATEStart Datenvarchar80
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
28CRM_ECLOG_HEADTable for Replicated eCATT Log Header4STARTDATEStart Datenvarchar80
TOPBackground Processing
29BTCOMSDLControl table for operation type scheduler1STARTDATEStart or end data of operation modenvarchar80
30BTCOMSETDefinition of operation type sets and exception op. modes2STARTDATEStart or end data of operation modenvarchar80
TOPBank Customer Accounts
31BKKBENCHBenchmark Results6STARTDATEStart Datenvarchar80
32BKKBENCHACBALBenchmark Results Account Balancing14STARTDATEStart Datenvarchar80
33BKKBENCHBKSTATBenchmark Results Bank Statement10STARTDATEStart Datenvarchar80
TOPBatch-Oriented Parallel Processing of Mass Data
34BANK_JC_PRFL_KEYAutom. Key Assignment for Process Flows (= Job Nets)2STARTDATEDatenvarchar80
TOPBilling in Contract Accounts Receivable and Payable
35TFK8026Billing Cycle4STARTDATEStart Date for Billing Cyclenvarchar80
36TFK8026SSubordinate Billing Cycles4STARTDATEStart Date for Billing Cyclenvarchar80
TOPBSI
37BTXCUTXBSI: Customer Tax Formula5STARTDATEBSI: Start datenvarchar80
38BTXCUTX_OBSI: Customer Tax Formula4STARTDATEBSI: Start datenvarchar80
39BTXOVERBSI: Higher Level Tax Formula8STARTDATEBSI: Start datenvarchar80
40BTXOVER_OBSI: Higher Level Tax Formula7STARTDATEBSI: Start datenvarchar80
41BTXOVFRBSI: Higher Level Formulas for Employees8STARTDATEBSI: Start datenvarchar80
42BTXOVFR_OBSI: Higher Level Formulas for Employees7STARTDATEBSI: Start datenvarchar80
43BTXRATEBSI: Tax Rates per Company Based on Degree of Experience8STARTDATEBSI: Start datenvarchar80
44BTXRATE_OBSI: Tax Rates per Company Based on Degree of Experience7STARTDATEBSI: Start datenvarchar80
TOPBusiness Package for Manager Self-Service FI
45FCOM_PL_ROOMSPlanning Rooms Back End Parameter7STARTDATEPlanning Start Datenvarchar80
TOPBusiness Planning and Simulation
46UPS_LINKSLinks to Org. Values5STARTDATEField of type DATSnvarchar80
TOPClaims Management
47ICLITEMClaim Item32STARTDATEStart Datenvarchar80
48ICLITEMEVClaim Item Evaluation25STARTDATEStart Datenvarchar80
49ICLITEMEVBClaim Item: Daily Rate Valuation11STARTDATEStart Datenvarchar80
50ICLLITHEADERLitigation12STARTDATELitigation Start Datenvarchar80
51ICL_WCMPHWorkers Comp - Header Data15STARTDATELast Day Workednvarchar80
52ICSITEMClaim Item32STARTDATEStart Datenvarchar80
53ICSITEMEVClaim Item Evaluation25STARTDATEStart Datenvarchar80
54ICSITEMEVBClaim Item: Daily Rate Valuation11STARTDATEStart Datenvarchar80
55ICSLITHEADERLitigation12STARTDATELitigation Start Datenvarchar80
56ICS_WCMPHWorkers Comp - Header Data15STARTDATELast Day Workednvarchar80
TOPClient Copy
57CCPROCTABParallel Client Copy Processes4STARTDATEDatenvarchar80
TOPClinical System
58N2GL_TM_SCHEDULEpathways Patient Pathway22STARTDATEStart Date of Patient Pathwaynvarchar80
TOPContract Accounts Receivable and Payable
59DFKKWLIWork Items47STARTDATEWork Item: Earliest Start Datenvarchar80
60DFKKWLIAWork Items (Work Item Type)47STARTDATEWork Item: Earliest Start Datenvarchar80
TOPCross-Application Components
61RASUTADMASU: Toolbox: Started reports4STARTDATE(8-character) Date for SYSTnvarchar80
62TASUVADMASU: Variants: Started reports4STARTDATE(8-character) Date for SYSTnvarchar80
TOPDenmark
63T5M8KLog of report calls for Danish payroll accounting2STARTDATEDate of changenvarchar80
TOPDocument Builder
64/IPRO/TDOCMNTDocument Builder Documents38STARTDATEStart Datenvarchar80
TOPeCATT Extended Computer Aided Test Tool
65ECLOG_AIDXTable for Log Archive Index5STARTDATEStart Datenvarchar80
66ECLOG_EXECExecuted Configuration, Variant, Script, Version8STARTDATEStart Datenvarchar80
67ECLOG_HEADTable for Log Header3STARTDATEStart Datenvarchar80
68ECLOG_HYDRASeveral Header Entries for Log12STARTDATEStart Datenvarchar80
69ECLOG_SELSelection of STORE Data for RETRIEVE12STARTDATEStart Datenvarchar80
70ECTRACEeCATT Recordings12STARTDATESystem Datenvarchar80
71TZRR_EXECTestZone: Result Repository Start Activity Data8STARTDATEStart Datenvarchar80
TOPEnvironment, Health and Safety
72/TDAG/CPT_TASKHHeader data for tasks21STARTDATEStart Date of Processingnvarchar80
73/TDAG/CPT_TASKHACP: Kopfdaten für Aufgaben / Archiv21STARTDATEStart Date of Processingnvarchar80
74/TDAG/CPT_TRCKHObsolete - CP: Tracker - Kopfdaten18STARTDATEStart Date of Processingnvarchar80
75/TDAG/CPT_TRCKHAObsolete - CP: Tracker - Kopfdaten / Archiv18STARTDATEStart Date of Processingnvarchar80
TOPFlexible Real Estate Management
76VIGBVZUAB1LUM: Grundbuch - Zu-/Abschreibungen BV5STARTDATEEintragungsdatumnvarchar80
77VIGBVZUAB2LUM: Grundbuch - zugeschr. Grundstücke im BV Zu-/Abschr.7STARTDATEEintragungsdatumnvarchar80
TOPGeneral Ledger Accounting
78NGLM_ANA_HDAnalysis Run Header4STARTDATEDatenvarchar80
TOPGlobal Performance Analysis Transaction ST3
79AMASTAGlobal Performance Analysis: Application Statistc (from 7.0)8STARTDATESAP Workload NW Collector: Datenvarchar80
80AMESISTAGlobal Performance Analysis: Statistics Main Rec + ESI Total8STARTDATESAP Workload NW Collector: Datenvarchar80
81AMSTAGlobal Performance Analysis: Statistical Data4STARTDATELocal Start Date for Performance Log Statistical Recordnvarchar80
TOPI18N Unicode
82EWCIAPSECUEarly Watch Results for Appends and Customer Incl.1STARTDATESystem Datenvarchar80
83UMGTSKQSUMG: Worklist8STARTDATEStart Datenvarchar80
TOPIndustry Solution Catch Weight Management
84/CWM/MIG_PROT_HMigration Log Header5STARTDATEnvarchar80
TOPIntegration Customer Relationship Management
85ECONSEG_H_PARCustomer Consumption Segment Parameter7STARTDATEStart of billing periodnvarchar80
TOPInternationalization I18N
86I18NSRHWLWorklist for I18N_SEARCH5STARTDATEStart Date of a Scannvarchar80
TOPKnowledge Warehouse
87KWDELTA_WLIWB: Worklist for Delta Delivery (Content)3STARTDATEDatenvarchar80
TOPliveCache Applications
88/SAPAPO/LCLOGLOGLogging of liveCache logging1STARTDATEStart datenvarchar80
89/SAPAPO/OMLOGHDRLog for Function Modules of OM Layer - Header1STARTDATEStart datenvarchar80
TOPLocalization
90J_1AOIFWVLOpen item foreign currency valuation: temp. storage13STARTDATELast Adjustment Datenvarchar80
TOPMaintenance Orders
91/MRSS/D_ENG_LOGProtokolltabelle für Engineläufe7STARTDATEStart Date of Engine Run in RCCFnvarchar80
TOPMarketing
92TEMKT_BPSEG_BWStandard Values for Extracting Marketing-Relevant Data5STARTDATEStart Date of Extractionnvarchar80
TOPMaster Data
93EWATSPCMPNTSFService Frequency20STARTDATEDate on Which Waste Disposal Service Beginsnvarchar80
TOPMonitoring
94ALDWNTIMEDowntime of systems for availability calculations8STARTDATEDatenvarchar80
95CSMCENTOOLCCMS Monitoring: Container for Methods Started Centrally14STARTDATEAlert: datenvarchar80
96SAPWLROLESSAP Workload: Table for User-Specific Parameters13STARTDATESAP Workload: Date of First Statistical Rec. of Measurementnvarchar80
97SWNCCOLLPERFPerformance Data of the Workload Collector7STARTDATESAP Workload NW Collector: Datenvarchar80
TOPOnline Correction Support Support Package and Add-On Tools
98PATHISTORYHistory of Imported SPAM/SAINT Queues5STARTDATESupport Package import datenvarchar80
99PATRTPHASEOCS Runtime Analysis: Einspielphasen7STARTDATEEinspieldatum des Support Packagenvarchar80
TOPOverhead Cost Controlling
100PFFLDPeriod-End Partner: Organizational Log Information23STARTDATEStart Date of Processingnvarchar80
TOPPerformance Monitors TCC
101GVD_WPTOTALINFOOracle Monitoring: Workprocess Information snapshot table27STARTDATEOracle Monitoring: Start date for dialog stepnvarchar80
102SAPWLT000SAP workload: statistics data4STARTDATESAP Workload: Start date of meas. periodnvarchar80
103SAPWLT001SAP workload: Table statistics4STARTDATESAP Workload: Start date of meas. periodnvarchar80
104SAPWLT002SAP workload: RFC statistics data4STARTDATESAP Workload: Start date of meas. periodnvarchar80
TOPPool Asset Management
105PAMS_NEEDGraphical Planning Board: Requests (Objects to Schedule)9STARTDATEStart Datenvarchar80
106PAMS_SPLITGraphical Planning Board: Splits (Scheduled Objects)10STARTDATEStart Datenvarchar80
TOPPortfolio Analyzer
107BMA_BMOLD CFM Benchmarking: BM Central Master Data3STARTDATEEvaluation Datenvarchar80
TOPPosition Budgeting and Control
108HRFPM_RUNADMINSHRFPM: Administration Information for Commitment Runs3STARTDATEStart Date of Commitment Runnvarchar80
TOPProduct Cost Controlling
109CATDHCATT Test Data Memory, History15STARTDATESystem Datenvarchar80
TOPProduct Cost Planning
110TCWB_OBJECTS_HISHistorie zum Testobjekt12STARTDATESystemdatumnvarchar80
TOPProfitability Analysis
111TKENC5CO-PA Realignments: Execution Logs10STARTDATEStart datenvarchar80
TOPPublic Sector Contract Accounts Receivable and Payable
112TFMCA_PT_BRFPLUSBRFPlus Config Table3STARTDATEBRFPlus From Datenvarchar80
113TFMCA_TRM_BRFPLSTest BRFPlus Config Table3STARTDATEDatenvarchar80
TOPReal Estate Localization Czech Republic
114/CEERE/KOEFMPobsolete Koeficients for municipalities parts10STARTDATEStart Datenvarchar80
115/CEERE/KOEFMPSIMKoeficients for municipalities parts10STARTDATEStart Datenvarchar80
116/CEERE/KOEF_K15Koeficient 1,5 from § 11, 3b4STARTDATEStart Datenvarchar80
TOPRemote Control and Communication Framework
117RCCD_ENG_LOGLog Table for Engine Runs7STARTDATEStart Date of an Engine Run in RCCFnvarchar80
TOPSAP Business Workflow
118SWF_WFPRECWF: Recovery information for Workflow Wizards10STARTDATESystem Datenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
119TNNLTARIFFTariff7STARTDATEISH_NL: Anfang datumnvarchar80
TOPSAP Retail Store
120WSMAN_PT_BUFFERStore Manager Portal: Buffer for Availability Display3STARTDATEDate of availabilitynvarchar80
TOPSAP Utilities
121ISU_WUI_DOC_FLTRDocument filter criteria for user8STARTDATEDatenvarchar80
TOPService Data Download
122/SDF/CMO_T_62BCCMC Service: Period1STARTDATEField of type DATSnvarchar80
123/SDF/STADStatistical Records4STARTDATESystem Datenvarchar80
124/SDF/SWCM_AVERSDR/3 Add-On Product (DEV) Update Information4STARTDATEDatenvarchar80
125/SDF/SWCM_AVERSPR/3 Add-On Product (PRD) Update Information4STARTDATEDatenvarchar80
126/SDF/SWCM_AVERSQR/3 Add-On Product (QAS) Update Information4STARTDATEDatenvarchar80
TOPTime Sheet
127CATS_DEF_ACCOUNTCATS Default Accounting3STARTDATEStart Datenvarchar80
TOPTools
128HRPYO_D_CYCLCycles8STARTDATEStart Datenvarchar80
129HRPYO_D_CYSTPSteps of the cycles14STARTDATEStart Datenvarchar80
130HRPYO_D_SCHDLSchedule9STARTDATEStart Datenvarchar80
TOPTransaction Manager
131TERTVWERKOExecutable Rights (Header)5STARTDATETerm fromnvarchar80
TOPTranslation Tools
132INDPROTShort Text Conversion: Log4STARTDATEDate data element for SYSTnvarchar80
133LWRKLIDWork list ID for individual translator work lists4STARTDATEDatenvarchar80
134TRNL_WLWorklists of Translation (Header Data)5STARTDATEDate of Last Changenvarchar80
TOPTransport Management System
135CTWFTARGETTransport Proposal: Target Systems/Target Clients17STARTDATEnvarchar80
136TMSCTASKTMS: Task List6STARTDATESystem Datenvarchar80
TOPTransport Organizer
137GUPDLAYOUTList of Table Layouts that Need to Be Updated9STARTDATEDate of Last Changenvarchar80
TOPUI Services, Screen, Batch Input
138APQIQueue info definition19STARTDATEQueue start datenvarchar80
TOPUpgrade - General
139AVERSInformation About Updates of R/3 Add-On Products4STARTDATEDatenvarchar80
140GODIRLOCKSynchronization for Reports that Fill GODIR3STARTDATEDatenvarchar80
141MERGEHRequest List of the Transport Merger (Header)10STARTDATEMerge period - Start datenvarchar80
142NAVERSUPG: Information About Updates of R/3 Add-On Products5STARTDATEDatenvarchar80
143NAVERS2additional information about Addons in Upgrades/Updates4STARTDATEDatenvarchar80
144SUBST_UPGEV_HDRUpgrade Evaluation (Customer Side) Header Table3STARTDATEText field length 14nvarchar140
145UVERSUpgrade Information3STARTDATEDatenvarchar80
146UVERS_HISTUpgrade Information - History5STARTDATEDatenvarchar80
TOPUpgrade Tools
147DDCPRODD: Conversion projects4STARTDATESystem Datenvarchar80
TOPWaste Management
148EWAOBJHService Frequency -> Services (History for EWAOBJ)46STARTDATEDate on Which Waste Disposal Service Beginsnvarchar80
TOPWeb Service and SOAP - ABAP
149SRT_WSSELECTIONOBSOLETE Excerpt of Selection Criteria12STARTDATESystem Datenvarchar80