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

83 columns | Print definition?ERP 6.0  | APPLC

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ICLUSCNTXTUser Context in Claim Applications3APPLCSave User-Dependent Data for Claims System Applicationnvarchar30
2TKCKCKC Applications1APPLCApplication class for drilldown reportingnvarchar40
3TKCKUKey Figure Assignment Groups1APPLCApplication class for DD objects (not used)nvarchar40
4TKCTULanguage Table: Key Figure Assignment Groups2APPLCApplication class for DD objects (not used)nvarchar40
TOPBusiness Planning
5UPB_CW_EP_UICost Center Wizard: Interfaces4APPLCPlanning Applicationnvarchar40
6UPB_IA_IMPLISTPlanning Applications: Object Lists of Planning Applications1APPLCPlanning Applicationnvarchar40
TOPBusiness Planning and Simulation
7UPB_AREA_ATRBalance Sheet Planning: Attributes of Application on Area2APPLCPlanning Applicationnvarchar40
8UPB_IA_SUBCLPlanning Applications: Subclass1APPLCPlanning Applicationnvarchar40
9UPB_IA_SUBCLTPlanning Applications: Subclass - Text Table2APPLCPlanning Applicationnvarchar40
10UPB_MAIN_PROFILEPlanning Profiles of Planning Applications2APPLCPlanning Applicationnvarchar40
11UPB_PM_APPLCApplication-Specific Attributes in Planning Folders1APPLCPlanning Applicationnvarchar40
12UPB_PM_DETAILTechnical Detail Settings of Folder2APPLCPlanning Applicationnvarchar40
13UPB_PM_GRAPHGraphic Settings for POBs of a Planning Folder2APPLCPlanning Applicationnvarchar40
14UPB_PM_POFO_PROPCustomizing of Portfolio Graphics2APPLCPlanning Applicationnvarchar40
15UPB_PM_POFO_XMLCustomizing of Portfolio Graphics2APPLCPlanning Applicationnvarchar40
16UPB_PM_SETTINGSPlanning Folders: Technical Settings of All Folders2APPLCPlanning Applicationnvarchar40
17UPB_PM_VARIABLEVariables of Planning Folders2APPLCPlanning Applicationnvarchar40
TOPCanada
18T5KT3Fields of a tax form8APPLCSubapplicationnvarchar40
TOPCollectionsDisbursements
19IBROSTMHISCD: Broker Report - Header Data18APPLCApplication areanvarchar10
TOPContract Accounts Receivable and Payable
20DFKKMDUGPMaster Data Lot: Items of the Groups of a Lot2APPLCCalling Applicationnvarchar50
21DFKKMDUGPPMaster Data Lot: Subitems of Group Item2APPLCCalling Applicationnvarchar50
22DFKKMDUKMaster Data Lot: Header Data2APPLCCalling Applicationnvarchar50
23MDU_APPLCTSMaster Data Update: Calling Application2APPLCCalling Applicationnvarchar50
TOPData Collection
24TKAFField catalog for Accounting1APPLCApplication class for drilldown reportingnvarchar40
25TKAFAField catalog: Accounting, table assignment1APPLCApplication class for DD objects (not used)nvarchar40
26TKAFDGeneral CO field catalog, compound characteristics1APPLCApplication class for drilldown reportingnvarchar40
27TKAQGeneral accounting attributes1APPLCApplication class for drilldown reportingnvarchar40
28TKCFGField groups for structure generation1APPLCApplication class for drilldown reportingnvarchar40
29TKCFGFFields of the field groups for structure generation1APPLCApplication class for drilldown reportingnvarchar40
30TKCFTGLanguage table for field groups2APPLCApplication class for drilldown reportingnvarchar40
31TKCHHSAP-EIS: Hierarchy header2APPLCApplication class for DD objects (not used)nvarchar40
32TKCHHTSAP-EIS: Texts for hierarchy header3APPLCApplication class for DD objects (not used)nvarchar40
33TKCHNSAP-EIS Hierarchy nodes2APPLCApplication class for DD objects (not used)nvarchar40
34TKCHNTSAP-EIS: Hierarchy node texts3APPLCApplication class for DD objects (not used)nvarchar40
35TKCHWSAP-EIS: Hierarchy data2APPLCApplication class for DD objects (not used)nvarchar40
36TKCJJoin (view) tables for CO drill down1APPLCApplication class for DD objects (not used)nvarchar40
37TKCKKey figures1APPLCApplication class for drilldown reportingnvarchar40
38TKCKAKey Figures, Aspect Assignment (SAP-EIS)1APPLCApplication class for drilldown reportingnvarchar40
39TKCKFKey Figure Formula Stages1APPLCApplication class for drilldown reportingnvarchar40
40TKCKTKey figures, Table assignment (SAP-EIS)1APPLCApplication class for DD objects (not used)nvarchar40
41TKCKUKKey figure assignment to groups1APPLCApplication class for DD objects (not used)nvarchar40
42TKCODSAP-EIS: Object types in the object list8APPLCApplication class for DD objects (not used)nvarchar40
43TKCTABFIEEC-EIS: Table-specific field properties1APPLCApplication class for DD objects (not used)nvarchar40
44TKCTKLanguage Table for Key Figures2APPLCApplication class for drilldown reportingnvarchar40
TOPFunds Management
45FM01DFunds Management Update Control3APPLCFunds management application indicatornvarchar10
46FM01NFollow-up posting info by FM area / application /data origin3APPLCSingle-Character Indicatornvarchar10
TOPInformation System
47FTI_NULL_ONOFFField Deactivated (for Hiding Zero Records of Logical DBs)2APPLCApplication class for drilldown reportingnvarchar40
48TKAFA_ONOFFField catalog: Accounting, table assignment2APPLCApplication class for DD objects (not used)nvarchar40
49TKAFA_USER_ONOFFField catalog: Accounting, table assignment3APPLCApplication class for DD objects (not used)nvarchar40
50TKAFD_USER_APPDDependencies for Customer Characteristics1APPLCApplication class for drilldown reportingnvarchar40
51TKAF_ONOFFField Catalog for General Accounting, Deactivate Fields2APPLCApplication class for drilldown reportingnvarchar40
52TKAF_USER_APPD_KField Catalog for Customer Key Figures1APPLCApplication class for drilldown reportingnvarchar40
53TKAF_USER_APPD_MField Catalog for Customer Characteristics1APPLCApplication class for drilldown reportingnvarchar40
54TKAF_USER_ONOFFField Catalog, Deactivate Fields (User-Specific)3APPLCApplication class for drilldown reportingnvarchar40
TOPInvestment Programs
55TAIFIM Drilldown: Characteristic Catalog1APPLCApplication class for drilldown reportingnvarchar40
56TAIFDIM Drilldown: Characteristic Dependencies1APPLCApplication class for drilldown reportingnvarchar40
TOPPatient Management
57TNR00IS-H: Report Control: Applications and Texts3APPLCIS-H: Report Control: Applicationnvarchar200
58TNR01IS-H: Report Control: Group - Application Asgmt.2APPLCIS-H: Report Control: Applicationnvarchar200
TOPProfitability Analysis
59TJBSBase Field Catalog IS-B-PA (Fixed Fields)51APPLCApplication class for DD objects (not used)nvarchar40
60TKEHA_VFIELDHANA Analytic View Keyfigures6APPLCApplication class for drilldown reportingnvarchar40
61TKESCO-PA Basis Field Catalog (fixed fields)51APPLCApplication class for DD objects (not used)nvarchar40
TOPRisk Analysis
62RMDRCLBCallback for Derivation1APPLCApplication class for drilldown reportingnvarchar40
TOPTask Resource Management
63LDPRFDisplay profile2APPLCApplicationnvarchar20
64LDPRFTDisplay profile - description3APPLCApplicationnvarchar20
65LEXTPExternal process - activity mapping2APPLCApplicationnvarchar20
66LFCPRFunction code profile per step2APPLCApplicationnvarchar20
67LFCTXPushbutton text3APPLCApplicationnvarchar20
68LIVPRInput verification profile2APPLCApplicationnvarchar20
69LMENUMenu tree2APPLCApplicationnvarchar20
70LMENUTMenu tree - description3APPLCApplicationnvarchar20
71LMNCTMenu item catalog2APPLCApplicationnvarchar20
72LMNCTTMenu item catalog - description3APPLCApplicationnvarchar20
73LPAPSApplication parameters3APPLCApplicationnvarchar20
74LPDVCPresentation device2APPLCApplicationnvarchar20
75LPRSNPersonalization2APPLCApplicationnvarchar20
76LPRSNTPersonalization - description3APPLCApplicationnvarchar20
77LSTLNLogical transaction step flow2APPLCApplicationnvarchar20
78LSTMPMapping Step Type to Step2APPLCApplicationnvarchar20
79LSTSCPhysical screen variant per logical step2APPLCApplicationnvarchar20
80LTRCTLogical transaction catalog2APPLCApplicationnvarchar20
81LTRCTTLogical transaction catalog - description3APPLCApplicationnvarchar20
TOPWarehouse Management
82LRF_WKQUAssignment User ->Queue14APPLCApplicationnvarchar20
TOPWork Center
83TC30AWork center categories2APPLCApplication of the task listnvarchar10