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

144 columns | Print definition?ERP 6.0  | ENDDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/FORECLOSUREForeclosures15ENDDATEEnd datenvarchar80
2/ATL/SHAAMWithholding tax for vendors from shaam4ENDDATEWithholding tax end datenvarchar80
3/CEERE/FUCTax Offices - time dependent4ENDDATEEND datenvarchar80
4/CEERE/FUKDCTax office: master data - time dependent4ENDDATEEND datenvarchar80
5/CEERE/FURRegional Tax Office Workplace5ENDDATEEND datenvarchar80
6/GEP/T_NEEDGraphischer Leitstand: Bedarfe (einzuplanende Objekte)11ENDDATEEnddatumnvarchar80
7/GEP/T_SPLITGraphischer Leitstand: Splits (eingeplante Objekte)12ENDDATEEnddatumnvarchar80
8/SOMO/JOBMON11Job schedule information44ENDDATEnvarchar80
9/XFT/EPA_BO_LEANLend Data8ENDDATESystem Datenvarchar80
10/XFT/EPA_DLEANLend Data7ENDDATESystem Datenvarchar80
11CNVA_00555_STATEState Table for Run Time Estimation9ENDDATEField of type DATSnvarchar80
12CNVA_CCD_ANA_STAState Table for CC Deletion Analysis Package10ENDDATEField of type DATSnvarchar80
13CNVCMISBACKUP_EXBackup Functionality - Runtime Information10ENDDATEnvarchar80
14CNVC_SCNG_EXTRExtracts6ENDDATEDatenvarchar80
15CNV_20308_CMPHeader Data for Package Comparison29ENDDATEDatenvarchar80
16CNV_20308_DLDownloads16ENDDATEDatenvarchar80
17CNV_ADT_DP_LOGT. Summary: Data provider execution log (single DP)7ENDDATEDatenvarchar80
18CNV_ADT_DP_LOGPT. Summary: Data provider execution log (whole package)7ENDDATEDatenvarchar80
19DMC_IU_UVERSMWB: Backup Copy of UVERS5ENDDATEDatenvarchar80
20DMC_MDS_AVERSMDS: Information About Updates of R/3 Add-On Products7ENDDATEDatenvarchar80
21DMC_MDS_UVERSMDS: Backup of Upgrade Information6ENDDATEDatenvarchar80
22DVM_BOF_RUNSBusiness Objects Footprint runs12ENDDATEDatenvarchar80
23REQHEADSTemporary Header Data: Requirement Coverage Request (Limit)54ENDDATETimeframenvarchar80
24SUBST_SLANA_HDRSL Analytics Header Data7ENDDATEnvarchar80
25TNNL_HT_THESAURSDiagnose Thesaurus Diagnose Konzepte4ENDDATEEnddatumnvarchar80
26TNNL_KT_DBCDiagnose Thesaurus Beziehung DBC Kode5ENDDATEEnddatumnvarchar80
27TNNL_KT_DOMEINENDomänen5ENDDATEEnddatumnvarchar80
28TNNL_KT_ICD10Diagnose Thesaurus Beziehung ICD10 Kode5ENDDATEEnddatumnvarchar80
29TNNL_RT_DBCDiagnose Thesaurus Beziehung DBC5ENDDATEEnddatumnvarchar80
30TNNL_RT_ICD10Diagnose Thesaurus Beziehung ICD104ENDDATEEnddatumnvarchar80
31ZSKCOURSEStraining courses5ENDDATEnvarchar80
32ZSKCSPHJ02csp3ENDDATESystemdatumnvarchar80
33ZSKSCHEDULECourse schedule for standard training6ENDDATEnvarchar80
34ZTR_COURSEStraining courses8ENDDATEnvarchar100
35HRP1774DB Table for Infotype 177423ENDDATEEnd Date of Individual Worknvarchar80
36T7PIQ_NL_ADMREQAdmission Requirements8ENDDATEEnd Datenvarchar80
37T7PIQ_NL_COUNTRYCountries5ENDDATEEnd Datenvarchar80
38T7PIQ_NL_EDUCEducation Details5ENDDATEEnd Datenvarchar80
39T7PIQ_NL_EDUPGMEducational Program Details9ENDDATEEnd Datenvarchar80
40T7PIQ_NL_INSBRINBRIN Number of the Institute5ENDDATEEnd Datenvarchar80
41T7PIQ_NL_INSTITInstitutes and Education Details7ENDDATEEnd Datenvarchar80
42T7PIQ_NL_LOTDRAWApplication period second lottery drawing7ENDDATEEnd Datenvarchar80
43T7PIQ_NL_NATITYNationalities5ENDDATEEnd Datenvarchar80
44T7PIQ_NL_PREEDUCPrevious Education Details4ENDDATEEnd Datenvarchar80
45T7PIQ_NL_SUBSubjects3ENDDATEEnd Datenvarchar80
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
46CRM_ECLOG_HEADTable for Replicated eCATT Log Header6ENDDATEEnd Datenvarchar80
TOPALE Integration Technology
47TBD00Views of customer model8ENDDATEEnd Datenvarchar80
48TBD03Communication relation between systems10ENDDATEEnd Datenvarchar80
TOPBackground Processing
49BTCOMSETDefinition of operation type sets and exception op. modes4ENDDATEStart or end data of operation modenvarchar80
50TBTCOJob Status Overview Table20ENDDATEJob start datenvarchar80
TOPBank Customer Accounts
51BKKBENCHBenchmark Results12ENDDATEEnd Datenvarchar80
52BKKBENCHACBALBenchmark Results Account Balancing16ENDDATEEnd Datenvarchar80
53BKKBENCHBKSTATBenchmark Results Bank Statement12ENDDATEEnd Datenvarchar80
TOPBusiness Consolidation
54UCST001SEM-BCS: Performance Statistics6ENDDATESystem Datenvarchar80
TOPBusiness Server Pages
55AUOFFERAuction Offer Table4ENDDATEAuction Date Formatnvarchar80
TOPClaims Management
56ICLDIAGNOSISDiagnoses Made17ENDDATEEnd Datenvarchar80
57ICLITEMClaim Item33ENDDATEEnd Datenvarchar80
58ICLITEMEVClaim Item Evaluation26ENDDATEEnd Datenvarchar80
59ICLITEMEVBClaim Item: Daily Rate Valuation12ENDDATEEnd Datenvarchar80
60ICLLITHEADERLitigation13ENDDATELitigation End Datenvarchar80
61ICL_WCMPHWorkers Comp - Header Data17ENDDATEInitial Return to Work Datenvarchar80
62ICSDIAGNOSISDiagnoses17ENDDATEEnd Datenvarchar80
63ICSITEMClaim Item33ENDDATEEnd Datenvarchar80
64ICSITEMEVClaim Item Evaluation26ENDDATEEnd Datenvarchar80
65ICSITEMEVBClaim Item: Daily Rate Valuation12ENDDATEEnd Datenvarchar80
66ICSLITHEADERLitigation13ENDDATELitigation End Datenvarchar80
67ICS_WCMPHWorkers Comp - Header Data17ENDDATEInitial Return to Work Datenvarchar80
TOPClinical System
68N1MATVMIS-H*MED: Medical info for material consumpt. documentation7ENDDATEClosing Datenvarchar80
69N2GL_TM_SCHEDULEpathways Patient Pathway28ENDDATEEnd Date of Patient Pathwaynvarchar80
TOPContract Accounts Receivable and Payable
70DFKKWLIWork Items48ENDDATEWork Item: Latest End Datenvarchar80
71DFKKWLIAWork Items (Work Item Type)48ENDDATEWork Item: Latest End Datenvarchar80
TOPDocument Builder
72/IPRO/TDOCMNTDocument Builder Documents28ENDDATEEnd Datenvarchar80
TOPeCATT Extended Computer Aided Test Tool
73ECLOG_AIDXTable for Log Archive Index13ENDDATEEnd Datenvarchar80
74ECLOG_HEADTable for Log Header5ENDDATEEnd Datenvarchar80
75ECLOG_HYDRASeveral Header Entries for Log14ENDDATEEnd Datenvarchar80
76ECTRACEeCATT Recordings14ENDDATESystem Datenvarchar80
77TZRR_EVCMDTestZone: Result Repository Event Command7ENDDATEEvent Datenvarchar80
78TZRR_EXECTestZone: Result Repository Start Activity Data12ENDDATEEnd Datenvarchar80
TOPEmployee Interaction Center
79THREIC_CAT_RES1EIC: Category and Resolution Assignment3ENDDATEEnd Datenvarchar80
80THREIC_CAT_RES2EIC: Categories3ENDDATEEnd Datenvarchar80
81THREIC_FOLLOWUPEIC Follow-Up11ENDDATEEIC: Follow-Up End Datenvarchar80
TOPFlexible Real Estate Management
82VIGBHVLUM: Grundbuch - Herrschvermerke6ENDDATEDatum Herrschvermerknvarchar80
83VIGBOOKLUM: Grundbuch24ENDDATESchließungsdatum Grundbuchnvarchar80
84VIGBVZUAB1LUM: Grundbuch - Zu-/Abschreibungen BV6ENDDATERötungsdatum BV-Nummernvarchar80
TOPGeneral Ledger Accounting
85NGLM_ANA_HDAnalysis Run Header6ENDDATEDatenvarchar80
TOPGlobal Performance Analysis Transaction ST3
86AMASTAGlobal Performance Analysis: Application Statistc (from 7.0)10ENDDATESAP Workload NW Collector: Datenvarchar80
87AMESISTAGlobal Performance Analysis: Statistics Main Rec + ESI Total10ENDDATESAP Workload NW Collector: Datenvarchar80
88AMSTAGlobal Performance Analysis: Statistical Data6ENDDATEEnd Date (Local) for Performance Log Statistical Recordnvarchar80
TOPI18N Unicode
89UMGTSKQSUMG: Worklist10ENDDATEEnd Datenvarchar80
TOPIndustry Solution Catch Weight Management
90/CWM/MIG_PROT_HMigration Log Header8ENDDATEnvarchar80
TOPKnowledge Warehouse
91KWDELTA_WLIWB: Worklist for Delta Delivery (Content)4ENDDATEDatenvarchar80
TOPLocalization
92J_1AOIFWVLOpen item foreign currency valuation: temp. storage14ENDDATEKey Date for OI Overviewnvarchar80
93J_3RSPASSDEALDeal Passport18ENDDATEDeal Passport Expiration Datenvarchar80
TOPMonitoring
94ALDWNTIMEDowntime of systems for availability calculations10ENDDATEDatenvarchar80
TOPOnline Correction Support Support Package and Add-On Tools
95PAT02Conflicts Between Patches and Add-Ons8ENDDATEDatenvarchar80
96PATHISTORYHistory of Imported SPAM/SAINT Queues7ENDDATESupport Package import datenvarchar80
97PATRTPHASEOCS Runtime Analysis: Einspielphasen9ENDDATEEinspieldatum des Support Packagenvarchar80
TOPOverhead Cost Controlling
98PFFLDPeriod-End Partner: Organizational Log Information25ENDDATEEnd Date for Processingnvarchar80
TOPPool Asset Management
99PAMS_NEEDGraphical Planning Board: Requests (Objects to Schedule)11ENDDATEEnd Datenvarchar80
100PAMS_SPLITGraphical Planning Board: Splits (Scheduled Objects)12ENDDATEEnd Datenvarchar80
TOPPortfolio Management
101RPM_FIDATAFinancial Information15ENDDATEStart Datenvarchar80
102RPM_PROJECT_COControlling Information about a project12ENDDATEStart Datenvarchar80
103RPM_SCENARIO_FINRPM : Scenario financial data10ENDDATEStart Datenvarchar80
TOPPosition Budgeting and Control
104HRFPM_RUNADMINSHRFPM: Administration Information for Commitment Runs5ENDDATEEnd Date of Commitment Runnvarchar80
TOPProduct Cost Controlling
105CATDHCATT Test Data Memory, History17ENDDATESystem Datenvarchar80
TOPProduct Cost Planning
106TCWB_OBJECTS_HISHistorie zum Testobjekt14ENDDATESystemdatumnvarchar80
TOPProduction and Revenue Accounting
107OIUP_PDM_JOBSPDM: Job Data21ENDDATEJob start datenvarchar80
TOPProfitability Analysis
108TKENC5CO-PA Realignments: Execution Logs12ENDDATEFinish datenvarchar80
TOPReal Estate Localization Czech Republic
109/CEERE/KOEFMPobsolete Koeficients for municipalities parts11ENDDATEEnd Datenvarchar80
110/CEERE/KOEFMPSIMKoeficients for municipalities parts11ENDDATEEnd Datenvarchar80
111/CEERE/KOEF_K15Koeficient 1,5 from § 11, 3b5ENDDATEEnd Datenvarchar80
TOPReal Estate Management
112VIGBUCHLand register25ENDDATEnvarchar80
TOPReuse Services for Country Development
113T5F99CDCalculation of duration in HR12ENDDATEIndicator of date adjustment for calculation of durationsnvarchar50
TOPSAP Business Workflow
114SWF_WFPRECWF: Recovery information for Workflow Wizards15ENDDATESystem Datenvarchar80
TOPSAP Healthcare - Industry-Specific Components for Hospitals
115TNNLTARIFFTariff8ENDDATEISH_NL: Ende datumnvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
116MEREP_208Replicator Run Control6ENDDATEJob start datenvarchar80
TOPSAP Records Management
117SRMWFPTHPSProcess Route Item for Workflow19ENDDATEDate Process Route Item Executednvarchar80
TOPSAP Utilities
118ISU_WUI_DOC_FLTRDocument filter criteria for user9ENDDATEDatenvarchar80
TOPScripting
119CRMD_IC_SCRATTRScript/Survey attributes (Interactive Script Editor)6ENDDATEDatenvarchar80
TOPService Data Download
120/SDF/BPM_ASTADBPMon Application Statistical Records2ENDDATESAP Workload: Workload: Datenvarchar80
121/SDF/BPM_ASTAD2BPMon Application Statistical Records2ENDDATESAP Workload: Workload: Datenvarchar80
122/SDF/BPM_TSTADBPMon Technical Statistical Records2ENDDATESAP Workload: Workload: Datenvarchar80
123/SDF/CMO_T_62BCCMC Service: Period2ENDDATEField of type DATSnvarchar80
124/SDF/SWCM_AVERSDR/3 Add-On Product (DEV) Update Information6ENDDATEDatenvarchar80
125/SDF/SWCM_AVERSPR/3 Add-On Product (PRD) Update Information6ENDDATEDatenvarchar80
126/SDF/SWCM_AVERSQR/3 Add-On Product (QAS) Update Information6ENDDATEDatenvarchar80
127/SOMO/JOSCHEDLJob scheduling table for business process monitoring24ENDDATEnvarchar80
TOPTime Sheet
128CATS_DEF_ACCOUNTCATS Default Accounting4ENDDATEEnd Datenvarchar80
TOPTools
129HRPYO_D_CYCLCycles9ENDDATEEnd Datenvarchar80
130HRPYO_D_CYSTPSteps of the cycles15ENDDATEEnd Datenvarchar80
131HRPYO_D_SCHDLSchedule10ENDDATEEnd Datenvarchar80
TOPTraining Management
132PA3225Personnel Record for Infotype 322528ENDDATECourse End Datenvarchar80
TOPTransaction Manager
133TERTVWERKOExecutable Rights (Header)6ENDDATETerm tonvarchar80
TOPTranslation Tools
134TRACOLHRequest list of transport collector (header)9ENDDATEDate of Last Changenvarchar80
TOPTransport Organizer
135GUPDLAYOUTList of Table Layouts that Need to Be Updated11ENDDATEDate of Last Changenvarchar80
TOPUpgrade - General
136AVERSInformation About Updates of R/3 Add-On Products6ENDDATEDatenvarchar80
137GODIRLOCKSynchronization for Reports that Fill GODIR5ENDDATEDatenvarchar80
138MERGEHRequest List of the Transport Merger (Header)12ENDDATEMerge period - End datenvarchar80
139NAVERSUPG: Information About Updates of R/3 Add-On Products7ENDDATEDatenvarchar80
140SUBST_UPGEV_HDRUpgrade Evaluation (Customer Side) Header Table4ENDDATEText field length 14nvarchar140
141UVERSUpgrade Information5ENDDATEDatenvarchar80
142UVERS_HISTUpgrade Information - History7ENDDATEDatenvarchar80
TOPUpgrade Tools
143DDCPRODD: Conversion projects6ENDDATESystem Datenvarchar80
TOPWeb Service and SOAP - ABAP
144SRT_WSSELECTIONOBSOLETE Excerpt of Selection Criteria13ENDDATESystem Datenvarchar80