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

60 columns | Print definition?ERP 6.0  | BUNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____005MSID-Tabelle fuer Partner unit4BUNITConsolidation unitnvarchar180
2HRP1691DB Table for Infotype 169126BUNITReference unitnvarchar10
3ZRP1036Infotype 1036 DB table22BUNITReference unitnvarchar10
TOPBelgium
4T5BX6Assign Description texts to BELCOTAX forms, BOW9BUNITUnit for Belcotax on Web print formsnvarchar30
5T5BX7Unit for BELCOTAX forms, BOW2BUNITUnit for Belcotax on Web print formsnvarchar30
6T5BX7TUnit for BELCOTAX forms, BOW3BUNITUnit for Belcotax on Web print formsnvarchar30
TOPConsolidation
7ECMCOSAP Cons.: Object Table Assignment Fields (Object/Partner)9BUNITConsolidation unitnvarchar180
8EWUCS10SAP Cons.-EURO: Consolidation Units for Euro Conversion4BUNITConsolidation unitnvarchar180
9TF080List Directory of MCDX9BUNITConsolidation unitnvarchar180
10TF160Consolidation Units3BUNITConsolidation unitnvarchar180
11TF161Consolidation Units: Texts4BUNITConsolidation unitnvarchar180
12TF162Consolidation Unit Correspondence3BUNITConsolidation unitnvarchar180
13TF163Consolidation Units, Version/Period-Based Attributes4BUNITConsolidation unitnvarchar180
14TF164Consolidation Unit Year-Dependent3BUNITConsolidation unitnvarchar180
15TF165Consolidation Units Version-Dependent4BUNITConsolidation unitnvarchar180
16TF166Consolidation Units Version- and Period Category-Dependent4BUNITConsolidation unitnvarchar180
17TF167Consolidation Units Version- and Period-Dependent4BUNITConsolidation unitnvarchar180
18TF168Consolidation Units Ledger-Dependent4BUNITConsolidation unitnvarchar180
19TF169Version/Period-Dependent Cons. Units: Tax Rates4BUNITConsolidation unitnvarchar180
20TF172Contact Person Assignments3BUNITConsolidation unitnvarchar180
21TF189Assignment of CG/CU, Version- and Period-Dependent5BUNITConsolidation group / Consolidation unitnvarchar180
22TF189AInactive Consolidation Units per Consolidation Group5BUNITConsolidation unitnvarchar180
23TF250Periods, Opened/Closed7BUNITConsolidation unitnvarchar180
24TF260Overall Status of CG/CU - Data Monitor7BUNITConsolidation unitnvarchar180
25TF261CG/CU: Detail Status of Tasks - Data Monitor8BUNITConsolidation unitnvarchar180
26TF262History of Data Entry Layouts7BUNITConsolidation unitnvarchar180
27TF270CG/CU Overall Status of Consolidation Monitor7BUNITConsolidation unitnvarchar180
28TF271CG/CU: Detail Status of Tasks - Consolidation Monitor8BUNITConsolidation unitnvarchar180
29TF292Cons Units to be Copied3BUNITConsolidation unitnvarchar180
30TF362Download: Selection Parameters for Downloading Fin. Data7BUNITConsolidation unitnvarchar180
31TF370Equivalency Table in MC Validations3BUNITConsolidation unitnvarchar180
32TF545Consolidation Tasks: Exceptions for Cons Units5BUNITConsolidation unitnvarchar180
33TF585Inventory Data7BUNITConsolidation unitnvarchar180
34TF586Supplier Data6BUNITConsolidation unitnvarchar180
35TF605C/I Methods: Assignments7BUNITConsolidation unitnvarchar180
36TF620Changes in Investments9BUNITConsolidation unitnvarchar180
37TF625Group Shares7BUNITConsolidation group / Consolidation unitnvarchar180
38TF635Goodwill/Neg.Goodwill10BUNITConsolidation unitnvarchar180
39TF635AGoodwill/Neg.Goodwill9BUNITConsolidation unitnvarchar180
40TF640Fair Value Adjustments3BUNITConsolidation unitnvarchar180
41TF641Fair Value Adjustments: Subnumber3BUNITConsolidation unitnvarchar180
42TF642Fair Value Adjustments: Name4BUNITConsolidation unitnvarchar180
43TF643Fair Value Adjustments: Version/Date-Sensitive4BUNITConsolidation unitnvarchar180
44TF644Fair Value Adjustments: Cons Chart of Accounts-Sensitive4BUNITConsolidation unitnvarchar180
45TF646Recorded Fair Value Adjustments9BUNITConsolidation unitnvarchar180
46TF661Equity Holdings Adjustments by Upper Unit9BUNITConsolidation unitnvarchar180
47TFIN010Consolidation Unit Integration3BUNITConsolidation unitnvarchar180
48TFMIG02Allocation: Company -> Consolidation Unit3BUNITConsolidation unitnvarchar180
TOPCross-Application Components
49PDS_OPERPDS Data for Operations and Dependent Data20BUNITUnit for Bucket Consumptionnvarchar30
TOPData Collection
50CF709Consolidation Basic6BUNITConsolidation unitnvarchar180
51CF710IDES FPI6BUNITConsolidation unitnvarchar180
52CF711KPI6BUNITConsolidation unitnvarchar180
53CF712EC Integration: EVA7BUNITConsolidation unitnvarchar180
54CF714Strategic Planning7BUNITConsolidation unitnvarchar180
55KCK710Comments for FPI10BUNITConsolidation unitnvarchar180
TOPPayroll
56T7SIBUBank Units Slovenia4BUNITPolje z dolžino 3 bajtovnvarchar30
TOPTalent Needs Management
57HRP1689DB Table for Infotype 168924BUNITReference unitnvarchar10
TOPTraining and Event Management
58HRP1036Infotype 1036 DB table22BUNITReference unitnvarchar10
59T77KBCost Items7BUNITReference unitnvarchar10
60T77REFDOCReference Document Table: Training and Event Management24BUNITReference unitnvarchar10