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

54 columns | Print definition?ERP 6.0  | TABNM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPD_MDG_FLDMAPMDG: Assignment Entity/Database Field Name5TABNMTable name, 16 charactersnvarchar160
2J_1BAKHAssignment of Field to Field Group (Header)1TABNMTable Namenvarchar300
3J_1BAKITAssignment of Field to Field Group (Item)1TABNMTable Namenvarchar300
4T242ISender information16TABNMTable Namenvarchar300
5T7CNRM_GRPDIMGrouping Dimension10TABNMName of Text Tablenvarchar160
6TIVXCITCADFLDDatabase fields to transfer3TABNMBP: Table name (screen)nvarchar300
7TKEDPSAP tables for use when defining characteristics (CO)3TABNMTable name for field selection from external tablenvarchar100
8TKEPTTexts for SAP tables(entry aid for defining characteristics)4TABNMTable name for field selection from external tablenvarchar100
TOPApplications
9MDG_ECC_CUST_FGAttribution Entity/DB/Modification group (Customer)5TABNMTable Name (4 Characters)nvarchar300
TOPBasic Functions
10T080AStructure definition work list suffix3TABNMTable Name (4 Characters)nvarchar300
11T082FField groups asset data1TABNMTable Namenvarchar300
TOPBusiness Partner Enhancements for Financial Services
12TPZ3RBP Fields -> BP Field group Assignment2TABNMTable Namenvarchar300
TOPData Basis
13RSMDUCMUTMetadata of Master Data Usage Type (for Usage Check)3TABNMHandling table for the Master Data Usage Typenvarchar300
TOPData Collection
14KCSLASAP-EIS: assigning data slices to tables3TABNMTable Namenvarchar300
15TKAFAField catalog: Accounting, table assignment2TABNMTable Namenvarchar300
16TKCAAspects2TABNMTable namenvarchar300
17TKCCOComment tables2TABNMComment tablenvarchar300
18TKCJJoin (view) tables for CO drill down2TABNMTable namenvarchar300
19TKCKTKey figures, Table assignment (SAP-EIS)2TABNMTable Namenvarchar300
20TKCTABFIEEC-EIS: Table-specific field properties2TABNMTable Namenvarchar300
21TKEBYExceptions (reference to reporting object)20TABNMTable Namenvarchar300
22TKTFRSAP-EIS, table field assignment1TABNMTable Namenvarchar300
TOPFinancial Accounting
23TMODUCross Reference Field Name - MODIF13TABNMTable Name (4 Characters)nvarchar300
24TNAMNPuffer for Keywords (NAMETAB)2TABNMTable Name (4 Characters)nvarchar300
TOPFunds Management
25TREFFields for Field Selection String in Funds Reservations3TABNMPermitted table names for field status in funds reservationnvarchar300
26TREWFFIELDFiels in Group Keys for Workflow (Obsolete Since 4.70)3TABNMPermitted table names for workflow-rel.fields in fds resvtnnvarchar100
TOPIncentive and Commission Management ICM
27TCACSFACommissions: Field Catalog Search, Table Assignment2TABNMTable Namenvarchar300
28TCACS_STDREPCommissions: Assign Report Name to Service4TABNMTable Namenvarchar300
TOPInformation System
29TKAFA_ONOFFField catalog: Accounting, table assignment3TABNMTable Namenvarchar300
30TKAFA_USER_ONOFFField catalog: Accounting, table assignment4TABNMTable Namenvarchar300
31TNEISIS-H: Character, Key Figure Determination (FM) EIS1TABNMTable Namenvarchar300
TOPInteractive Drilldown Reporting
32TRSTHVBRST directory of hierarchies3TABNMTable Namenvarchar300
33TRSTHVTBRST Texts for hierarchies4TABNMTable Namenvarchar300
34TRSTHV_VPBRST Repository of Hierarchies - Virtual InfoProvider4TABNMTable Namenvarchar300
TOPLocalization
35J_1BAKField assignment2TABNMTable Namenvarchar300
TOPMDG Business Partner Central Part
36MDG_BS_BP_FLDGRPAttribution Entity/DB/Fieldgroups8TABNMTable name, 16 charactersnvarchar160
37MDG_ECC_BPFLDMAPMapping of CVI-structures to modif-groups3TABNMTable Name (4 Characters)nvarchar300
38MDG_FND_BPFLDMAPMapping of BP-bapistructures and fields to BDT fieldgroups4TABNMTable name, 16 charactersnvarchar160
TOPMDG Supplier Central Parts
39MDG_BS_SUPPL_FGAttribution Entity/DB/Modification group (Supplier)5TABNMTable Name (4 Characters)nvarchar300
TOPPegging, Grouping, and Distribution
40TBLP_MODUCross Reference Field Name - MODIF13TABNMTable Name (4 Characters)nvarchar300
TOPProduction and Revenue Accounting
41OIU_ME_RTYPE_CHReading Type Characteristics24TABNMTable Namenvarchar300
TOPProduction Orders
42T496ZCIM order: Table-controlled table access4TABNMTable Namenvarchar300
TOPRemote Logistics Management
43OIO_FS_FLDField status screen fields2TABNMTable name for field status handlingnvarchar300
TOPSAP Business Partner
44TB040BDT: Database Tables of Evaluation3TABNMTable Namenvarchar300
45TB040FBDT: Selection and Display Fields of Evaluation3TABNMTable Namenvarchar300
46TBZ1HBDT Tables3TABNMTable Namenvarchar300
47TBZ3RAssign BDT Field Group -> BDT Field3TABNMBP: Table name (screen)nvarchar300
48TBZ3R_CAssign BDT Field Group -> BDT Field3TABNMBP: Table name (screen)nvarchar300
49TBZ9CBDT Differentiation Type Elements7TABNMTable Namenvarchar300
50TBZ9HBP Relationships: Assign Rel. Category to Database Tables3TABNMTable Namenvarchar300
TOPTransaction Manager
51TMODVField Selection: Assign Fields to Field Groups3TABNMTable Namenvarchar300
TOPUSA
52T5UPBSPA02Nature of Action Attributes8TABNMTable Namenvarchar300
53T5UPBSPA04Legal Authority Attributes (PS)8TABNMTable Namenvarchar300
54T5UPBSPA06Remark Code Attributes (PS)8TABNMTable Namenvarchar300