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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

220 columns | Print definition?ERP 6.0  | TXTMI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1MD/MD______01Q0F Texts BDCSET8TXTMIDescription (medium text)nvarchar400
2/1MD/MD______01V0F Texts SUBMPACK8TXTMIDescription (medium text)nvarchar400
3/1MD/MD______01Z0F Texts CCOA8TXTMIDescription (medium text)nvarchar400
4/1MD/MD______0230F Texts COA8TXTMIDescription (medium text)nvarchar400
5/1MD/MD______0260F Texts FCRS9TXTMIDescription (medium text)nvarchar400
6/1MD/MD______02C0F Texts BDC9TXTMIDescription (medium text)nvarchar400
7/1MD/MD______02D0F Texts FRS9TXTMIDescription (medium text)nvarchar400
8/1MD/MD______02J0F Texts ACCOUNT9TXTMIDescription (medium text)nvarchar400
9/1MD/MD______02K0F Texts FSI9TXTMIDescription (medium text)nvarchar400
10/1MD/MD______02P0F Texts FRSI10TXTMIDescription (medium text)nvarchar400
11/1MD/MD______02R0F Texts TEXTITEM10TXTMIDescription (medium text)nvarchar400
12/1MD/MD______03Z0G Texts FSI9TXTMIDescription (medium text)nvarchar400
13/1MD/MD______0450G Texts BDC9TXTMIDescription (medium text)nvarchar400
14/1MD/MD______0480G Texts CELEMG8TXTMIDescription (medium text)nvarchar400
15/1MD/MD______0490G Texts CELEMH9TXTMIDescription (medium text)nvarchar400
16/1MD/MD______04F0G Texts CELEM9TXTMIDescription (medium text)nvarchar400
17/1MD/MD______04G0G Texts BDCSET8TXTMIDescription (medium text)nvarchar400
18/1MD/MD______04J0G Texts CCTRH9TXTMIDescription (medium text)nvarchar400
19/1MD/MD______04P0G Texts CCTRG8TXTMIDescription (medium text)nvarchar400
20/1MD/MD______04T0G Texts CCTR9TXTMIDescription (medium text)nvarchar400
21/1MD/MD______04V0G Texts CONSUTYP4TXTMIDescription (medium text)nvarchar400
22/1MD/MD______04W0G Texts COMPANY6TXTMIDescription (medium text)nvarchar400
23/1MD/MD______04X0G Texts CURRCONV4TXTMIDescription (medium text)nvarchar400
24/1MD/MD______04Z0G Texts CURRTYP4TXTMIDescription (medium text)nvarchar400
25/1MD/MD______0520G Texts DIMENS4TXTMIDescription (medium text)nvarchar400
26/1MD/MD______0560G Texts DIVISION4TXTMIDescription (medium text)nvarchar400
27/1MD/MD______0570G Texts PCTRH9TXTMIDescription (medium text)nvarchar400
28/1MD/MD______0590G Texts GRPCURR4TXTMIDescription (medium text)nvarchar400
29/1MD/MD______05A0G Texts MGMTUNIT4TXTMIDescription (medium text)nvarchar400
30/1MD/MD______05B0G Texts MVMNTY4TXTMIDescription (medium text)nvarchar400
31/1MD/MD______05D0G Texts SUBCAT4TXTMIDescription (medium text)nvarchar400
32/1MD/MD______05F0G Texts CONSCHAR7TXTMIDescription (medium text)nvarchar400
33/1MD/MD______05H0G Texts VALVERS4TXTMIDescription (medium text)nvarchar400
34/1MD/MD______05I0G Texts FSIH9TXTMIDescription (medium text)nvarchar400
35/1MD/MD______05N0G Texts TRANSTYPE8TXTMIDescription (medium text)nvarchar400
36/1MD/MD______05O0G Texts PCTR9TXTMIDescription (medium text)nvarchar400
37/1MD/MD______05R0G Texts CATEG4TXTMIDescription (medium text)nvarchar400
38/1MD/MD______05U0G Texts SUBMPACK8TXTMIDescription (medium text)nvarchar400
39/1MD/MD______05W0G Texts PCTRG8TXTMIDescription (medium text)nvarchar400
40/1MD/MD______05Z0G Texte CNTXT4TXTMIBezeichnung (Mitteltext)nvarchar400
41/1MD/MD______0630G Texts FSIT10TXTMIDescription (medium text)nvarchar400
42/1MD/MD______0650G Texts CONSGRP9TXTMIDescription (medium text)nvarchar400
43/1MD/MD______0690G Texts CONSGRPH9TXTMIDescription (medium text)nvarchar400
44/1MD/MD______06C0G Texts CONSUNIT9TXTMIDescription (medium text)nvarchar400
45/1MD/MD______06NMM Texts MATERIAL6TXTMIDescription (medium text)nvarchar400
46/1MD/MD______08XMM Texts AWSLS4TXTMIDescription (medium text)nvarchar400
47/1MD/MD______094MM Texts PRCTR5TXTMIDescription (medium text)nvarchar400
48/1MD/MD______095MM Texts MYPOL5TXTMIDescription (medium text)nvarchar400
49/1MD/MD______098MM Texts RDPRF5TXTMIDescription (medium text)nvarchar400
50/1MD/MD______099MM Texts HRKFT5TXTMIDescription (medium text)nvarchar400
51/1MD/MD______09BMM Texts MOGRU5TXTMIDescription (medium text)nvarchar400
52/1MD/MD______09DMM Texts RDPRFMVKE5TXTMIDescription (medium text)nvarchar400
53/1MD/MD______09IMM Texts STAWN5TXTMIDescription (medium text)nvarchar400
54/1MD/MD______0BDMM Texts LWMKB6TXTMIDescription (medium text)nvarchar400
55/1MD/MD______0BOMM Texts KOSGR5TXTMIDescription (medium text)nvarchar400
56/SMD/MD_____001MSID-Tabelle fuer TXTMI3TXTMIMedium Textnvarchar400
57FINBTEST_T1TTransport Tool Unit Tests: Testinhalt Transport6TXTMIFeldbezeichner langnvarchar400
58FUCNR001TReporting Type Text Table3TXTMIText Description of Current Objectnvarchar400
59MDGHDB001HTText Table for HANA View Generation Header data3TXTMISearch View Descriptionnvarchar1000
TOPAccounting Engine
60/EACC/ITEMCAT0TItem Types in the Accounting Engine4TXTMIMedium Textnvarchar400
TOPApplication Framework
61MDG_MDF000TMaster Data Applications - Texts3TXTMIMedium Textnvarchar400
62MDG_MDF300TNames of Master Data Hierarchies (Texts)6TXTMIMedium Textnvarchar400
63MDG_MDFTRTXTText Table for Translation of Master Data Content6TXTMIMedium Textnvarchar400
64MDG_MDFTRTXT2Text Table for Translation of Master Data Content8TXTMIMedium Textnvarchar400
65MDG_TR_TXTGeneral Text Table for Master Data Transport8TXTMIMedium Textnvarchar400
66USMD001TData Model: Text Table4TXTMIDescription (medium text)nvarchar400
67USMD010TType of Edition4TXTMIDescription (medium text)nvarchar400
68USMD020TEdition4TXTMIDescription (medium text)nvarchar400
69USMD100TUI Model: Text Table4TXTMIDescription (medium text)nvarchar400
70USMD110TType of Change Request4TXTMIDescription (medium text)nvarchar400
71USMD130TStatus of Change Request4TXTMIDescription (medium text)nvarchar400
72USMD160TBusiness Activity: Text Table3TXTMIDescription (medium text)nvarchar400
73USMD170TAction Texts3TXTMIDescription of Logical Actionnvarchar400
74USMD202TDefinition of Workflow Steps4TXTMIDescription (medium text)nvarchar400
75USMD202T_2Definition of Workflow Steps5TXTMIDescription (medium text)nvarchar400
76USMD202T_SSWStep Definition Text for SSWF5TXTMIDescription (medium text)nvarchar400
77USMD2041TSearch Apps: Assignment of Search Type - Search Help TextTbl5TXTMIDescription (medium text)nvarchar400
78USMD204TSearch Applications: Text Table3TXTMIDescription (medium text)nvarchar400
79USMD210TChange Request: Priority4TXTMIDescription (medium text)nvarchar400
80USMD211TChange Request: Reason5TXTMIDescription (medium text)nvarchar400
81USMD212TChange Request: Reason for Rejection5TXTMIDescription (medium text)nvarchar400
82USMD600TData Transfer: Texts5TXTMIDescription (medium text)nvarchar400
83USMD680TSelection Condition Texts6TXTMIDescription (medium text)nvarchar400
TOPBusiness Analytics
84UACOSTVARTText Table Costing Variant4TXTMIMedium Textnvarchar400
TOPBusiness Consolidation
85UCF000TApplications: Text3TXTMIMedium Textnvarchar400
86UCF001TMethods: Text4TXTMIMedium Textnvarchar400
87UCF002TMethod Steps: Text5TXTMIMedium Textnvarchar400
88UCF003TLayouts: Text4TXTMIMedium Textnvarchar400
89UCF004TLayout Steps: Text5TXTMIMedium Textnvarchar400
90UCF005TMethod Categories: Texts3TXTMIMedium Textnvarchar400
91UCF210TC/T: Custom Exchange Rate Sources: Texts5TXTMIMedium Textnvarchar400
92UCF211TC/T: E/R Indicators: Texts4TXTMIMedium Textnvarchar400
93UCF220TC/T: Currency Translation Keys: Texts4TXTMIMedium Textnvarchar400
94UCF221TC/T: Translation Time Frames: Texts5TXTMIMedium Textnvarchar400
95UCF222TC/T: Translation Procedure: Texts5TXTMIMedium Textnvarchar400
96UCF223TC/T: Times for Exchange Rate Determination: Texts5TXTMIMedium Textnvarchar400
97UCF224TC/T: Procedure for Exchange Rate Determination: Texts5TXTMIMedium Textnvarchar400
98UCF610TConsolidation of Investments: Activities3TXTMIMedium Textnvarchar400
99UCF620TC/I: Activities - Equity Holdings Adjustments4TXTMIMedium Textnvarchar400
100UCF700TUpload Method Categories: Texts3TXTMIMedium Textnvarchar400
101UCFA10TElim. of IU Profit/Loss in Transferred Assets: Activities3TXTMIMedium Textnvarchar400
102UCFI10TIPI Customizing: Product Group (Text Table)4TXTMIMedium Textnvarchar400
103UCL200TAudit Trail Type: Text4TXTMIMedium Textnvarchar400
104UCL201TAudit Trail: Text4TXTMIMedium Textnvarchar400
105UCM001TData Basis Name4TXTMIMedium Textnvarchar400
106UCM002TData Stream Name4TXTMIMedium Textnvarchar400
107UCM003TConsolidation Area Name4TXTMIMedium Textnvarchar400
108UCM100TExplicit Values: Text4TXTMIMedium Textnvarchar400
109UCM600TOrganizational Change Number4TXTMIMedium Textnvarchar400
110UCMA10TType of Assets/Liabilities4TXTMIMedium Textnvarchar400
111UCMI10TBreakdown Categories: Name5TXTMIMedium Textnvarchar400
112UCMI30TDeferred Tax Items5TXTMIMedium Textnvarchar400
113UCML00TMonitor Layouts: Name6TXTMIMedium Textnvarchar400
114UCMP01TText Table for Parameter Set5TXTMIMedium Textnvarchar400
115UCMT00TPeriod Category Group: Name4TXTMIMedium Textnvarchar400
116UCMT01TPeriod Category: Name4TXTMIMedium Textnvarchar400
117UCMT10TCons Frequency: Name4TXTMIMedium Textnvarchar400
118UCMT20TConsolidation Cycle4TXTMIMedium Textnvarchar400
119UCMV01TSEM-BCS: Special Versions: Name5TXTMIMedium Textnvarchar400
120UCS010TTasks: Text6TXTMIMedium Textnvarchar400
121UCS020TTask Groups: Text6TXTMIMedium Textnvarchar400
122UCS030TCycle: Text4TXTMIMedium Textnvarchar400
123UCT100TSet: Text4TXTMIMedium Textnvarchar400
124UCT101TSet: Text for Rows5TXTMIMedium Textnvarchar400
125UCT200TSingle Field Selection: Text4TXTMIMedium Textnvarchar400
126UCT300TSelection Conditions5TXTMIMedium Textnvarchar400
127UCT400TTarget Account Assignment: GUID5TXTMIMedium Textnvarchar400
128UCT900TWorkflow Variant5TXTMIMedium Textnvarchar400
129UCUM03TFavorites in Web Dynpro Monitor5TXTMIMedium Textnvarchar400
130UCUM04TFavorites in Web Dynpro Monitor5TXTMIMedium Textnvarchar400
TOPConsolidation
131TF101FS Items: Short and Medium Texts7TXTMIMedium text for FS itemsnvarchar500
132TF116Subitems: Short and Medium Texts6TXTMIMedium textnvarchar300
133TF151Dimensions: Texts and User-Specific Names5TXTMIMedium textnvarchar300
134TF161Consolidation Units: Texts6TXTMIMedium textnvarchar300
135TF174Reasons for Inclusion: Short and Medium Texts5TXTMIMedium textnvarchar300
136TF181Consolidation Groups: Texts6TXTMIMedium textnvarchar300
137TF191Hierarchies: texts6TXTMIMedium textnvarchar300
138TF196Hierarchy Levels: Texts6TXTMIMedium textnvarchar300
139TF199DChar. Values of Organizational Elements: Texts6TXTMIMedium textnvarchar300
TOPConsolidation Functions
140UCFV10TValidation: Checks - Texts5TXTMIMedium Textnvarchar400
141UCFV11TValidation: Selection Conditions - Texts5TXTMIMedium Textnvarchar400
142UCFV21TValidation Check: Text4TXTMIMedium Textnvarchar400
143UCFV22TValidation Check: Selection Condition: Text5TXTMIMedium Textnvarchar400
TOPFinancials
144ACCSYSTEM0TTexts of Accounting Systems5TXTMIMedium Textnvarchar400
145FINBTATYPE0TBusiness Transaction Categories4TXTMIMedium Textnvarchar400
146FINCHOFACCT0TTexts of Document Types5TXTMIMedium Textnvarchar400
147FINCLOSESTEP0TClosing Phases4TXTMIMedium Textnvarchar400
148FINCOMPEL0TComposition Element5TXTMIMedium Textnvarchar400
149FINCOMPELCASH0TComposition Element Cash5TXTMIMedium Textnvarchar400
150FINCOMPELDUE0TComposition Element AP/AR5TXTMIMedium Textnvarchar400
151FINCURRTYPE0TText for Currency Type4TXTMIMedium Textnvarchar400
152FINDOCTYPE0TTexts of Document Types5TXTMIMedium Textnvarchar400
153FINDUEAGINGGRP0TAging Group5TXTMIMedium Textnvarchar400
154FINDUETYPE0TType of receivable/payable4TXTMIMedium Textnvarchar400
155FINFUNCAREA0TTexts of Functional Areas5TXTMIMedium Textnvarchar400
156FINGLACCT0TTexts for G/L Account6TXTMIMedium Textnvarchar400
157FINGLACCTGRP0TTexts of Account Groups5TXTMIMedium Textnvarchar400
158FINGLTRATYPE0TTexts for Transaction Types of General Ledger5TXTMIMedium Textnvarchar400
159FINJOURNAL0TTexts for Journals5TXTMIMedium Textnvarchar400
160FINORDITMTYPE0TTexts of Order Item Categories4TXTMIMedium Textnvarchar400
161FINORDTYPE0TTexts for Order Categories4TXTMIMedium Textnvarchar400
162FINPAYTYPE0TPayment type4TXTMIMedium Textnvarchar400
163FINPOSTYPE0TTexts of Item Categories4TXTMIMedium Textnvarchar400
164FINPRCVARIANT0TPrice Variants5TXTMIMedium Textnvarchar400
165FINPRICELABEL0TText Table for Price Types6TXTMIMedium Textnvarchar400
166FINPVALADJKEY0TAging Group5TXTMIMedium Textnvarchar400
167FINVALLEVEL0TTexts for Valuation Levels5TXTMIMedium Textnvarchar400
168FINXCASHLOC0TLocal Texts for FIN_CASHLOC (Not Used in Live System)5TXTMIMedium Textnvarchar400
169FINXCOMPANY0TLocal Texts for FIN_COMPANY (Not Used in Live System)5TXTMIMedium Textnvarchar400
170FINXCONDTYPE0TLocal Texts for FIN_CONDTYPE (Not Used in Live System)5TXTMIMedium Textnvarchar400
171FINXCOSTCTR0CLocal Values for FIN_COSTCTR (Not Used in Live System)4TXTMIMedium Textnvarchar400
172FINXLOCATION0CLocal Values for FIN_LOCATION (Not Used in Live System)3TXTMIMedium Textnvarchar400
173FINXLREPUNIT0CLocal Values for FIN_PROFITCTR (Not Used in Live System)3TXTMIMedium Textnvarchar400
174FINXPARTYID0TLocal Texts for FIN_CASHLOC (Not Used in Live System)5TXTMIMedium Textnvarchar400
175FINXPRODUCT0CLocal Values for FIN_PRODUCT (Not Used in Live System)3TXTMIMedium Textnvarchar400
176FINXPROFITCTR0TLocal Texts for FIN_PROFITCTR (Not Used in Live System)6TXTMIMedium Textnvarchar400
TOPFinancials Basis
177ACCACCOUNT0TG/L account6TXTMIMedium Textnvarchar400
178ACCACCTGROUP0TAccount Group5TXTMIMedium Textnvarchar400
179ACCASSTYPE0TAccount Assignment Category6TXTMIMedium Textnvarchar400
180ACCBUSTRANS0TTexts for Business Transaction Types4TXTMIMedium Textnvarchar400
181ACCCFG0TTexts for Accounting Configuration4TXTMIMedium Textnvarchar400
182ACCCHRTACCTS0TChart of Accounts5TXTMIMedium Textnvarchar400
183ACCCURTYPE0TCurrency ID5TXTMIMedium Textnvarchar400
184ACCDBS0TData Basis Name5TXTMIMedium Textnvarchar400
185ACCDOCTYPE0TDocument Type5TXTMIMedium Textnvarchar400
186ACCDOM0TTexts for Business Domain5TXTMIMedium Textnvarchar400
187ACCJOURNAL0TObsolete: Former Text Table for the Journals in the ACC Doc.4TXTMIMedium Textnvarchar400
188ACCLEGENT0TTexts for Legal Entities5TXTMIMedium Textnvarchar400
189ACCLOGOBJCAT0TLogistical Object Categories4TXTMIMedium Textnvarchar400
190ACCLSYS0TTexts for Logical System IDs5TXTMIMedium Textnvarchar400
191ACCMP0TAccounting Component Texts4TXTMIMedium Textnvarchar400
192ACCROLE0TApplication Role3TXTMIMedium Textnvarchar400
193ACCSYS0TName of Accounting System5TXTMIMedium Textnvarchar400
194ACCTRANTYPE0TTransaction Type5TXTMIMedium Textnvarchar400
195ACC_JOURNAL0TText Table for the Journals in the ACC Document5TXTMIMedium Textnvarchar400
196FINB_TR_TXTFINB Transport: General Text Table8TXTMIMedium Textnvarchar400
197UGCM0001TObject Types of Change Objects4TXTMIMedium Textnvarchar400
198UGMD000TFIN Master Data: Applications - Texts3TXTMIMedium Textnvarchar400
199UGMD2144FIN Master Data: Texts of Field Names6TXTMIMedium Textnvarchar400
200UGMD2146FIN Master Data: Field Prop.: Texts of Nav. Attributes7TXTMIMedium Textnvarchar400
201UGMD2154FIN Master Data: Active Texts of Field Names5TXTMIMedium Textnvarchar400
202UGMD2156FIN Master Data: Active Prop.: Texts of Nav. Attributes6TXTMIMedium Textnvarchar400
203UGMD300TFIN Master Data: Hierarchy Names6TXTMIMedium Textnvarchar400
204UGMD310TFIN Master Data: Text Node7TXTMIMedium Textnvarchar400
205UGMDDEMO02TFIN Master Data: Demo, Text Table5TXTMIMedium Textnvarchar400
206UGMDDEMO03TFIN Master Data: Demo, Text Table4TXTMIMedium Textnvarchar400
207UGMDTRTXTFIN Master Data: Text Table for Content Translation6TXTMIMedium Textnvarchar400
208UGMDTRTXT2FIN Master Data: Text Table for Content Translation8TXTMIMedium Textnvarchar400
209UGR31021FIN Master Data: Buffer Table for DataSource Properties11TXTMIMedium Textnvarchar400
210UGR31023FIN Master Data: Buffer Table for Texts of DS Fields5TXTMIMedium Textnvarchar400
TOPIndustry Solution Catch Weight Management
211/FMP/C_MP_PTYP_TPrice Types5TXTMIMedium Textnvarchar400
212CON_FIN_BUSTR0TBusiness Transaction Category - Texts4TXTMIMedium Textnvarchar400
TOPInventory Accounting
213UAIQSVERSIONTText for Quantity Structure Version4TXTMIMedium Textnvarchar400
TOPWorkbench
214UGWB020TPossible Jump Targets for Report-Report Interface3TXTMIMedium Textnvarchar400
TOPXBRL Reporting
215UGX001TData Basis Text Table4TXTMIMedium Textnvarchar400
216UGX002TTaxonomy Text Table4TXTMIMedium Textnvarchar400
217UGX003TReport Category Text Table4TXTMIMedium Textnvarchar400
218UGX004TValue Selection Text Table6TXTMIMedium Textnvarchar400
219UGX005TDimension Mapping Text Table6TXTMIMedium Textnvarchar400
220UGXV00TVariant Text Table5TXTMIMedium Textnvarchar400