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

86 columns | Print definition?ERP 6.0  | FIENM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000485TKEF4FIENMnvarchar300
2/1CADMC/00000486TKEFE5FIENMnvarchar300
TOPAnalyzer
3AFWCH_FCAT_SAMPAFW: Sample Customizing Characteristics1FIENMField Namenvarchar300
4AFWCH_FDEP_SAMPAFW: Sample Customizing Characteristic Dependencies1FIENMField Namenvarchar300
5AFWCH_PHDEFALTAlternative Portfolio Hierarchy Definition5FIENMCharacteristicnvarchar300
6JBRHISPHBAUMSTree Structure for Deactivated Portfolio Hierarchies19FIENMField Namenvarchar300
7JBRHISPHTEXTRM: Portfolio Texts for Deactivated Portfolio Hierachy5FIENMField Namenvarchar300
8RDB_FIENM_POSEncryption of Key Figure ID in Field Name and Item No.6FIENMField Namenvarchar300
TOPAssetLiability Management
9JBAPHKMERKALM Assignment of Characteristics to PH Nodes6FIENMField Namenvarchar300
TOPBusiness Planning and Simulation
10UPB_SPFIEBalance Sheet Planning: Fields with Special Semantics4FIENMField Namenvarchar300
TOPConsolidation
11TF90FActive Field Catalog, Consolidation1FIENMField Namenvarchar300
12TF90FDActive Field Catalog - Consolidation, Char. Dependencies1FIENMField Namenvarchar300
13TF90QActive Attributes in Consolidation1FIENMField Namenvarchar300
14TF90QDConsolidation: Levels of Multilevel Attributes1FIENMField Namenvarchar300
15TF90QSAttributes Basis Field Catalog Consolidation (Fixed Fields)1FIENMField Namenvarchar300
16TF90SBasis Field Catalog Consolidation (Fixed Fields)1FIENMField Namenvarchar300
17TF90SDBasis Field Catalog - Consolidation, Char. Dependencies1FIENMField Namenvarchar300
18TF91FField Catalog, Consolidation1FIENMField Namenvarchar300
19TF91FDField Catalog - Consolidation, Characteristic Dependencies1FIENMField Namenvarchar300
20TF91QAttributes in Consolidation1FIENMField Namenvarchar300
TOPData Collection
21KCSLOSAP-EIS: Selection requirements for data slices3FIENMField Namenvarchar300
22KCSLVSAP-EIS: data slices - variables - parameters3FIENMField Namenvarchar300
23KCVARSAP-EIS: data slice variables2FIENMField Namenvarchar300
24KCVARTSAP-EIS: data slice variable meanings3FIENMField Namenvarchar300
25TKAFField catalog for Accounting2FIENMField Namenvarchar300
26TKAFAField catalog: Accounting, table assignment3FIENMField Namenvarchar300
27TKAFDGeneral CO field catalog, compound characteristics2FIENMField Namenvarchar300
28TKAQGeneral accounting attributes2FIENMField Namenvarchar300
29TKCFSAP-EIS Field Catalog1FIENMField Namenvarchar300
30TKCFASAP-EIS Field Catalog, Aspect Assignment2FIENMField Namenvarchar300
31TKCFDSAP-EIS Field Catalog, Dependencies between Characteristics1FIENMField Namenvarchar300
32TKCFGFFields of the field groups for structure generation3FIENMField Namenvarchar300
33TKCKUKKey figure assignment to groups4FIENMField Namenvarchar300
34TKCQAttributes SAP-EIS1FIENMField Namenvarchar300
35TKCQDSAP-EIS: levels of multilevel attributes1FIENMField Namenvarchar300
36TKCQSAttributes of basic field catalog SAP-EIS (fixed fields)1FIENMField Namenvarchar300
37TKCSBasic field catalog SAP-EIS (fixed fields)1FIENMField Namenvarchar300
38TKCSDBasic field catalog SAP-EIS, linked characteristics1FIENMField Namenvarchar300
39TKCTABFIEEC-EIS: Table-specific field properties3FIENMField Namenvarchar300
40TKEBYExceptions (reference to reporting object)21FIENMField Namenvarchar300
41TKEC1Comment management for characteristic attributes3FIENMField Namenvarchar300
42TKEC2Comment management for fields3FIENMField Namenvarchar300
43TKTFRSAP-EIS, table field assignment2FIENMField Namenvarchar300
TOPDefault Risk and Limit System
44ATLTKAFField Catatlog: Drilldown Reporting Link for Limit Mgmt2FIENMField Namenvarchar300
TOPIncentive and Commission Management ICM
45TCACSFCommissions: Field Catalog Search2FIENMField Namenvarchar300
46TCACSFACommissions: Field Catalog Search, Table Assignment3FIENMField Namenvarchar300
47TCACSFDCommissions: Field Catalog Search, Feature Dependencies2FIENMField Namenvarchar300
TOPInformation System
48FTI_NULL_ONOFFField Deactivated (for Hiding Zero Records of Logical DBs)3FIENMField Namenvarchar300
49TKAFD_USER_APPDDependencies for Customer Characteristics2FIENMField Namenvarchar300
50TKAF_ONOFFField Catalog for General Accounting, Deactivate Fields3FIENMField Namenvarchar300
51TKAF_USER_APPD_KField Catalog for Customer Key Figures2FIENMField Namenvarchar300
52TKAF_USER_APPD_MField Catalog for Customer Characteristics2FIENMField Namenvarchar300
53TKAF_USER_ONOFFField Catalog, Deactivate Fields (User-Specific)4FIENMField Namenvarchar300
54TNEISIS-H: Character, Key Figure Determination (FM) EIS2FIENMField Namenvarchar300
TOPInteractive Drilldown Reporting
55TKEBUUse of Fields in Reports6FIENMField Namenvarchar300
56TRSTHVBRST directory of hierarchies4FIENMField Namenvarchar300
57TRSTHVTBRST Texts for hierarchies5FIENMField Namenvarchar300
58TRSTHV_VPBRST Repository of Hierarchies - Virtual InfoProvider5FIENMField Namenvarchar300
TOPInvestment Programs
59TAIFIM Drilldown: Characteristic Catalog2FIENMField Namenvarchar300
60TAIFDIM Drilldown: Characteristic Dependencies2FIENMField Namenvarchar300
TOPProfitability Analysis
61TJBFField Catalog IS-B-PA1FIENMField Namenvarchar300
62TJBFDField Catalog IS-B-PA, Characteristic Dependencies1FIENMField Namenvarchar300
63TJBFEField Catalog IS-B-PA, Operating Concern Assignment2FIENMField Namenvarchar300
64TJBSBase Field Catalog IS-B-PA (Fixed Fields)1FIENMField Namenvarchar300
65TJBSDCO-PA Basis Field Catalog: Dependent Characteristics1FIENMField Namenvarchar300
66TKEBWLHNote Characteristics When Creating CO-PA Hierarchy DataSrce4FIENMField Namenvarchar300
67TKEFCO-PA field catalog1FIENMField Namenvarchar300
68TKEFACO-PA Archiving Management: Field Assignment2FIENMCharacteristic for Profitability Analysisnvarchar300
69TKEFDCO-PA field catalog, compound characteristics1FIENMField Namenvarchar300
70TKEFEField catalog, assignment to operating concern2FIENMField Namenvarchar300
71TKESCO-PA Basis Field Catalog (fixed fields)1FIENMField Namenvarchar300
72TKESDCO-PA Basis Field Catalog: Dependent Characteristics1FIENMField Namenvarchar300
73TKETE03Operating Concern Templates:Reference Values in Example Data2FIENMField Namenvarchar300
TOPRisk Analysis
74JBRCHARSELRM: Assignment of Parameter Names to Characteristics1FIENMField Namenvarchar300
75JBRDIFTKEFRM Compared to CO-PA - Fields that are to be changed1FIENMField Namenvarchar300
76JBRPHBAUMSStorage of Portfolio Hierarchy19FIENMField Namenvarchar300
77JBRRMTKEFRM: Copy of CO-PA Field Catalog1FIENMField Namenvarchar300
78JBRRMTKEFDRM: Copy of CO-PA Field Catalog, Characteristic Dependencies1FIENMField Namenvarchar300
79JBRRMTKESRM: Base Field Catalog CO-PA Fix.Char./Basic Key Figures1FIENMField Namenvarchar300
80JBRRMTKESDRM: Base Field Catalog CO-PA, Characteristic Dependencies1FIENMField Namenvarchar300
81JBRSVPHTEXTRM: Portfolio Texts for Saved Datasets (Backtesting)4FIENMField Namenvarchar300
TOPTreasury
82TTMRFField catalog for Risk Management1FIENMField Namenvarchar300
83TTMRFDField catalog for Risk Management, chracter. dependencies1FIENMField Namenvarchar300
84TTMRFEField catalog, allocation to Risk Management areas2FIENMField Namenvarchar300
85TTMRSBasis field catalog Risk Management (fixed fields)1FIENMField Namenvarchar300
86TTMRSDBasis field catalog Risk Management, character. dependencies1FIENMField Namenvarchar300