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

143 columns | Print definition?ERP 6.0  | PHASE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IAM/C_PHASEStep for Methodologies3PHASEStepnvarchar30
2/IAM/C_RL_PHASEObsolet ! Assignments of Phases and Party Roles4PHASEStepnvarchar30
3/IAM/D_ACT_ROOTRoot22PHASEStepnvarchar30
4/IAM/I_PHASEPhase Definitions for Methodologies3PHASEStepnvarchar30
5CNVACTIVE_PHASESConversion packages and their active phase3PHASEConversion: Phasenvarchar10
6CNVLTHCM_TP_MAPLT HCM: Time-point Mapping3PHASEPhase of the Migration Projectnvarchar400
7CNVMBTACTIVEactive packages and current phase4PHASEPhase of the Migration Projectnvarchar400
8CNVMBTACTLOGMBT PCL - Activity execution log3PHASEPhase of the Migration Projectnvarchar400
9CNVMBTACTPARLOGMBT PCL - Activity execution log3PHASEPhase of the Migration Projectnvarchar400
10CNVMBTAUTORESTRTTable for auto restart configurations3PHASEPhase of the Migration Projectnvarchar400
11CNVMBTCHECKIDDefinition of checks2PHASECheck IDnvarchar40
12CNVMBTCOPYCCopy Control Data for TDMS & CMIS packages4PHASEPhase of the Migration Projectnvarchar400
13CNVMBTCWBSUBACTSubactivities of CWB-activities3PHASESingle-Character Indicatornvarchar10
14CNVMBTDOCMGMTDocument Management3PHASEPhase of the Migration Projectnvarchar400
15CNVMBTIMGProcess plan, order of activities to be executed3PHASEPhase of the Migration Projectnvarchar400
16CNVMBTIMGEXCLUDEExclusion table for activities during package load3PHASEPhase of the Migration Projectnvarchar400
17CNVMBTIMGORDERAdditional order information for merge of different tree str3PHASEPhase of the Migration Projectnvarchar400
18CNVMBTJOBSCMBT PCL: Batch-related information3PHASEPhase of the Migration Projectnvarchar400
19CNVMBTJOBSCTMBT PCL: Batch-related technical control4PHASEPhase of the Migration Projectnvarchar400
20CNVMBTMEPACMAPSME CWB Interface - Mappings associated with Packages5PHASEConversion: Phasenvarchar10
21CNVMBTNONIMGProcess plan, activities that are not IMG-relevant3PHASEPhase of the Migration Projectnvarchar400
22CNVMBTPEBUnique ID for all process execution blocks3PHASEPhase of the Migration Projectnvarchar400
23CNVMBTPEBACTSETUnique ID for set of activities3PHASEPhase of the Migration Projectnvarchar400
24CNVMBTPEBNLOGPEB Notification Log3PHASEPhase of the Migration Projectnvarchar400
25CNVMBTPEBSTATEStatus table for execution of all process execution blocks3PHASEPhase of the Migration Projectnvarchar400
26CNVMBTPEBSTOPExecution Stop Definition3PHASEPhase of the Migration Projectnvarchar400
27CNVMBTPEBTText table for CNVMBTPEB3PHASEPhase of the Migration Projectnvarchar400
28CNVMBTPEMCONTENTProcess Execution Content of an Object4PHASEPhase of the Migration Projectnvarchar400
29CNVMBTRESETVARVariants for the reset activities3PHASEPhase of the Migration Projectnvarchar400
30CNVMBTSTATEStatus table for execution of all activities and history3PHASEPhase of the Migration Projectnvarchar400
31CNVMBTTSINCLEXCLInclude or exclude phases for executing activities3PHASEPhase of the Migration Projectnvarchar400
32CNVMBTTSPHASEMBT PCL Trouble shooting - include or exclude phases3PHASEPhase of the Migration Projectnvarchar400
33CNVTDMS_10_COPYCTDMS: copy control data for package and variant3PHASEPhase of the Migration Projectnvarchar400
34CNV_00300_MAPSCWB-ME Interface - Mappings associated with Packages5PHASEConversion: Phasenvarchar10
35CNV_12000_DEFINEDefinition for Text Conversion9PHASEConversion: Phasenvarchar10
36CNV_20308_PSACTPS: Actions3PHASEPS: Project Phasenvarchar120
37CNV_20308_PSPACKPS: Package Finding3PHASEPS: Project Phasenvarchar120
38CNV_20308_PSPHPS: Project Phases3PHASEPS: Project Phasenvarchar120
39CNV_20308_PSPHTPS: Project Phase Texts3PHASEPS: Project Phasenvarchar120
40CNV_MBT_SWITCH_DDetailed Table for storing values from Switch Framework15PHASEPhase of the Migration Projectnvarchar400
41FAGLFLEXDEMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT3PHASEConversion phasesnvarchar100
42IUUC_TABLEStables to be processed by IUUC35PHASEphase in which trigger is to be changed from delta to freezenvarchar10
43PA0899HR Master Record: Infotype 089925PHASECode of Special Mobility Phasenvarchar20
44QAM_L_BCV_AQIM: Temporary Storage Activities f. Business Context Viewer30PHASEStepnvarchar30
45SRT_CC_CHANGES_HCentral Configuration Med Changes - History5PHASESRT Central Configuration: Phasenvarchar100
46T5PPBS7PStandard Special Mobility Phases3PHASECode of Special Mobility Phasenvarchar20
47T5PPBS7PTSpecial Mobility Phases4PHASECode of Special Mobility Phasenvarchar20
48T77WWW_CLCNFIGMLCustomize Mail Configuration6PHASEPhase Of the Requestnvarchar10
49T77WWW_CLTRANSDCluster table for storing transaction data.18PHASEPhase Of the Requestnvarchar10
50T77WWW_CLTRAN_BUBackup Table for Storing Transaction Data18PHASEPhase Of the Requestnvarchar10
51T77WWW_GACCMLGeneric Application Customize Mail Configuration6PHASEPhase Of the Requestnvarchar10
52T77WWW_GACMLGeneric Application Customize Mail Configuration5PHASEPhase Of the Requestnvarchar10
53UCONHTTPSTAPHASEUCON: HTTP Phase table3PHASEPhase of an RFC Function module in CA fill processnvarchar10
54UCONRFCSTATEPHASUCON: RFC Service Header Table2PHASEPhase of an RFC Function module in CA fill processnvarchar10
55YMESSMesswerte6PHASEVorgangsnummernvarchar40
56ZEIM_VBAKSales Document: Header Data126PHASESales Phasenvarchar110
57ZPH_RESS_STATUSStatus table for resources (Logbook)10PHASEOperation/Activity Numbernvarchar40
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
58CRMCHKMSGPMeta Data: Check rule verdicts assigment to quality phases4PHASEPhase, Group, or Aspect for Purposes of Quality Assurancenvarchar20
59CRMCHKRUNCheck Run16PHASECheck Results Management: Processing Stepnvarchar10
60CRMCHKRUNJTasks/Jobs of a Check Run16PHASECheck Results Management: Processing Stepnvarchar10
61SCRM_Q_PHASEQuality Phases1PHASEPhase, Group, or Aspect for Purposes of Quality Assurancenvarchar20
62SCRM_Q_PHASE_TXQuality Phases text table2PHASEPhase, Group, or Aspect for Purposes of Quality Assurancenvarchar20
TOPASAP AcceleratedSAP
63SAPHASFILTSolution Architect/IA: Assign Filter to Phase2PHASEImplementation Assistent Phasenvarchar10
TOPBasic Functions
64T090NAZDepreciation Keys - Method Assignment5PHASEDepreciation phasenvarchar10
TOPBusiness Application Support
65CNVACTIVEActive conversion package3PHASEConversion: Phasenvarchar10
66CNVACTIVE_HISTCNVACTIVE history , activation and phase change3PHASEConversion: Phasenvarchar10
67CNVJOBPROFILERequirement profile by job3PHASEConversion: Phasenvarchar10
68CNVMESSAGEConversion: package-related control of message output3PHASEConversion: Phasenvarchar10
69CNVRUNTIMEHELPTemporary storage of runtime info for terminated programs3PHASEConversion: Phasenvarchar10
70CNVSTATEConversion: Status of programs3PHASEConversion: Phasenvarchar10
71CNVSUBSTATEConversion: Status of programs3PHASEConversion: Phasenvarchar10
TOPBusiness Package for Manager Self-Service FI
72FPB_EXP_STATExpress Planning: Status Management5PHASEExpress Planning Phasenvarchar10
73FPB_EXP_UINSTExpress Planning: User Instance5PHASEExpress Planning Phasenvarchar10
TOPControlling
74QISRCHAR_ADDCharacteristics: Additional Data for Form16PHASEPhasenvarchar10
TOPData Collection
75CF003Projects21PHASEProject phasenvarchar20
TOPDBOS Migrations
76TIMIGIMIG: Administration & Status8PHASEnvarchar100
TOPDistributed System Landscape
77/ISDFPS/SYNCBTCHDFPS Job Scheduling Table for Synchronization Report2PHASESynchronization Report Phasenvarchar40
TOPEngineering Change Management
78ECM_CTXTContext7PHASEPhasenvarchar300
79ECM_PHSPhases2PHASEPhasenvarchar300
80ECM_PHSTPhase Description2PHASEPhasenvarchar300
TOPExpenditure Certification
81FMEUFCATCertifiable Document Types3PHASECertification Phasenvarchar20
82FMEUFPHACertification Procedure Phases3PHASECertification Phasenvarchar20
83FMEUFPHATCertification Procedure Phases - Text Table3PHASECertification Phasenvarchar20
84FMEUFRUNCertification Run Parameter9PHASECertification Phasenvarchar20
TOPGeneral Ledger Accounting
85EWUFI_SPLITEMU Implementation: Table of FAGL_SPLINFO* to Be Corrected3PHASEConversion phasesnvarchar100
TOPGermany
86T5D46Flexible Working Hours Policy: Management of Disr.Ev. ITD6PHASEFlexible Working Hours Policy: Phasenvarchar10
TOPImplementation Guide
87TNONOCLProject class node type note type assignment3PHASEProject phasesnvarchar60
88TPHASEPProject phases1PHASEProject phasesnvarchar60
89TPHASETPProject phases text table2PHASEProject phasesnvarchar60
TOPLocal Currency Changeover
90EWUFI_BALEMU conversion: Logging transaction figures change3PHASEConversion phasesnvarchar100
91EWUFI_BALPEMU conversion: Logging transaction figures change3PHASEConversion phasesnvarchar100
92EWUFI_SCAEMU conversion: Table of the clearings to be adjusted3PHASEConversion phasesnvarchar100
93EWUPAKEuro conversion packages4PHASEConversion phasesnvarchar100
94EWUPGCTEMU: Program check for conversion3PHASEConversion phasesnvarchar100
95EWUPGFACHUser department tasks completed3PHASEConversion phasesnvarchar100
96EWUPGFACH1Collection of user department's EMU programs3PHASEConversion phasesnvarchar100
97EWUPGSTATConversion programs status3PHASEConversion phasesnvarchar100
TOPLogistics - General
98HBSPPHPermitted Development Phases4PHASEDevelopment Phase Allocated to the Lotnvarchar110
99HBSSPHPermitted Sales Phases4PHASESales Phasenvarchar110
TOPMaintenance Notifications
100QMELQuality Notification140PHASENotification Processing Phasenvarchar10
TOPMalaysia
101T5LESESS Malaysia: TP1 TP218PHASEPhase Of the Requestnvarchar10
TOPManagement of Internal Controls
102FOPCMTESTERASGNSMass Tester Assignment - Settings9PHASEProcessing Statusnvarchar10
TOPMaterial Identification and Reconciliation
103MISTATUSStatus Table for Material Identification on Mat./Batch Level8PHASEFlag for Material Identificationnvarchar10
TOPMedia Product Sales and Distribution
104JKSDGENRESTARTIS-M: Restart Log for Order Generation3PHASEIS-M: Update Phasenvarchar300
105TJKSDSBRPHASESCalculation Rules of Phases for Replenishment Planning3PHASESequence Number in Phase Delivery for Replenishment Planningnvarchar100
TOPPayroll
106T7SIBTVirman configuration (WT->Accounts)2PHASEPhase of Virman preparationnvarchar10
TOPPlant Maintenance
107Z9MISTPStillstandsplanung18PHASEEinstelliges Kennzeichennvarchar10
TOPPortfolio Management
108/RPM/ITEM_DOperational item persisted data8PHASEStagenvarchar40
109RPM_FIDATAFinancial Information27PHASEStagenvarchar40
110RPM_ITEM_D_CDItem details - Pseudo table for change documents8PHASEStagenvarchar40
111RPM_PROJECTProject data5PHASEStagenvarchar40
112RPM_PROJECT_COControlling Information about a project21PHASEStagenvarchar40
113RPM_PROJ_PHASEProject Phase3PHASEStagenvarchar40
114RPM_PROJ_PHASE_TPortfolio Item Stage Text4PHASEStagenvarchar40
115RPM_TASKProject Task Data23PHASEStagenvarchar40
TOPProcess Controls
116GRPCMTESTERASGNSObsolete: Mass Tester Assignment - Settings9PHASEProcessing Statusnvarchar10
TOPProcess Management
117COCQPPPI/QM Integration: Buffer Table for Reporting Results5PHASEOperation/Activity Numbernvarchar40
TOPPublic Sector
118T5D8PPrograms for Rehabilitation2PHASEPhase of Rehabilitationnvarchar60
119T5D8PTPrograms for Rehabilitation (Texts)3PHASEPhase of Rehabilitationnvarchar60
120T5D8QProperties of Rehabilitation Programs4PHASEPhase of Rehabilitationnvarchar60
TOPPublic Sector Contract Accounts Receivable and Payable
121DFMCA_BRF181BRF: Parameters for Value Request with Name of XML Node15PHASEForm Viewnvarchar10
122TFMCA_FORMFIELDSCustomizing Table for Specific Form Fields3PHASEForm Viewnvarchar10
123TFMCA_PHASECustomizing Table for Form Views2PHASEForm Viewnvarchar10
124TFMCA_PHASE_PRView Priority2PHASEForm Viewnvarchar10
TOPRuntime for ABAP based automated TC
125STC_CUST_PHASEAutomation Phases1PHASEAutomation Phasenvarchar120
126STC_CUST_PHASETAutomation Phase Text Table1PHASEAutomation Phasenvarchar120
127STC_SCN_TASKSTasks of a Task List5PHASEAutomation Phasenvarchar120
TOPSales
128VBAKSales Document: Header Data126PHASESales Phasenvarchar110
TOPSAP Healthcare - Industry-Specific Components for Hospitals
129/ISHFR/NTPKFR_AKIS-H FR: Asgt Serv. Master France => Activity + Phase6PHASEIS-H FR: Phasenvarchar10
130/ISHFR/NTPKFR_ASIS-H FR: Asgt Serv. Master France => Ass. Serv. + Code6PHASEIS-H FR: Phasenvarchar10
131/ISHFR/NTPKFR_MCIS-H FR: Asgt Service Master France => Modif. Codes6PHASEIS-H FR: Phasenvarchar10
TOPSAP Multiresource Scheduling
132/MRSS/C_CAP_RESTime dependent customizing table for capacity reserve4PHASECapacity Reserve Phasenvarchar30
133/MRSS/C_PHASETime dependent customizing table for Phase7PHASECapacity Reserve Phasenvarchar30
134/MRSS/C_PHASE_RLCustomizing table for defining phase and its release time2PHASECapacity Reserve Phasenvarchar30
135/MRSS/C_POT_PHPRMRS: Phase - Priority mapping2PHASECapacity Reserve Phasenvarchar30
TOPSAP Records Management
136ZPHDEMO_ATTRTABAttribute-Table for RM-Demo Pharma (for search)6PHASEDatenelement Phase für Pharma-Demonvarchar300
TOPTakeoverHandover of Technical Objects
137PHINHHeader Table for Take Over15PHASEProcessing Phasenvarchar10
TOPTranslation Tools
138TRACOLRRestart control, work list generator2PHASETransport collector phase for generating work listnvarchar20
TOPTransport Management System
139TSYIMPSTATTransport Request Import Status2PHASETSY: Transport Synchronization Phasenvarchar200
140TSYSYNCSYSSystems to Be Kept Synchronized2PHASETSY: Transport Synchronization Phasenvarchar200
TOPUpgrade - General
141DDYTFSubstitution Nametab (shadow-shadow-nametab for DDXTF)4PHASEDefines the import time for the entry -> ddxtt/ddxtfnvarchar10
142DDYTTSubstitution Nametab (shadow-shadow-nametab for DDXTT)4PHASEDefines the import time for the entry -> ddxtt/ddxtfnvarchar10
TOPWeb Service and SOAP - ABAP
143SRT_CC_CHANGESCentral Configuration Med Changes4PHASESRT Central Configuration: Phasenvarchar100