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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

142 tablesERP 6.0 

Financial Accounting :: Lease Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/LSIERP/COND_MAP61Assign FI-CA Transactions to CRM ConditionsLease Accounting
2ERP EHP76.0/LSIERP/DELINQ61Delinquency Process for Each Company Code and StatusLease Accounting
3ERP EHP76.0/LSIERP/DELINQ_C21To Be DeletedLease Accounting
4ERP EHP76.0/LSIERP/DELI_PRC21Delinquency ProcessLease Accounting
5ERP EHP76.0/LSIERP/DELI_PRT41Description of Delinquency ProcessLease Accounting
6ERP EHP76.0/LSIERP/DELI_STA21Delinquency Process and StatusLease Accounting
7ERP EHP76.0/LSIERP/DELI_STT41Description of Delinquency StatusLease Accounting
8ERP EHP76.0/LSIERP/EXCL_NA51Transactions Not Assigned a Non-Accrual StatusLease Accounting
9ERP EHP76.0/LSIERP/LATE_FEE141Leasing Late Fee Matrix: Calc. Based on Responsibility AreaLease Accounting
10ERP EHP76.0/LSIERP/PROC_LOG201Persistence for Payment Trigger Containing ErrorsLease Accounting
11ERP EHP76.0/LSIERP/PROC_TYP41Definition Table for Payment Triggers + Handler ClassesLease Accounting
12ERP EHP76.0/LSIERP/REPT_RUN41Log Table for Reports on Handling of Payment TriggersLease Accounting
13ERP EHP76.0/LSIERP/STOP_NA21Defines If Treaty No Longer Set to Non-AccrualLease Accounting
14ERP EHP76.0/LSIERP/STOP_NAB31Stop Non-Accrual Characteristic for Each Company CodeLease Accounting
15ERP EHP76.0/LSIERP/STOP_NAT41Describes If Treaty No Longer Set to Non-AccrualLease Accounting
16ERP EHP76.0/LSIERP/TQ_P_DET121Payment Details and Test Results for Cost EstimateLease Accounting
17ERP EHP76.0/LSIERP/TQ_P_HDR122Payment StatusLease Accounting
18ERP EHP76.0/LSIERP/TRIG_NA71Leases Not Set to Non-AccrualLease Accounting
19ERP EHP76.0/LSIERP/WL162WorklistLease Accounting
20ERP EHP76.0/LSIERP/WLI205Work ItemsLease Accounting
21ERP EHP76.0/LSIERP/WLIGUIDS31GUIDs for WorklistLease Accounting
22ERP EHP76.0/LSIERP/WLIH111DO NOT USE -> Can Be DeletedLease Accounting
23ERP EHP76.0/LSIERP/WLI_IL182Item List of Work ItemLease Accounting
24ERP EHP76.0/LSIERP/WL_STAT41Worklist - Status for CollectorLease Accounting
25ERP EHP76.0/LSIERP/WL_TASK31Specimen Tasks for WorklistLease Accounting
26ERP EHP76.0FIEH_STATUS141Object Status for Restart Exception HandlingLease Accounting
27ERP EHP76.0FILA_GF_ITEMCHAH181Object Data: Value ID Change Header InformationLease Accounting
28ERP EHP76.0FILA_GF_ITEMDATA601Process DataLease Accounting
29ERP EHP76.0FILA_GF_ITEMDOCS141Assignment of Process - FI/CO Document NumbersLease Accounting
30ERP EHP76.0FILA_GF_ITEMLINK161Assignment of Objects to AssetsLease Accounting
31ERP EHP76.0FILA_GF_ITEMPARM81Object Data: Additional InformationLease Accounting
32ERP EHP76.0FILA_GF_ITEMVALC101Object Data: Changed Value IDsLease Accounting
33ERP EHP76.0FILA_GF_ITEMVALS91Object Data: Value IDs and their Values/ContentsLease Accounting
34ERP EHP76.0FILA_GF_PROCINFO101Object Data: Processing Info for ProcessLease Accounting
35ERP EHP76.0FILA_MIG_RESTART61Restart Legacy Data Transfer for Lease AccountingLease Accounting
36ERP EHP76.0FILA_MIG_SYNC81Synchronization of CRM and LAE Legacy DataLease Accounting
37ERP EHP76.0FILA_RE_LNK162Link Between Leasing <-> RefinancingLease Accounting
38ERP EHP76.0FILA_RE_PRG231Refinancing ProgramLease Accounting
39ERP EHP76.0FILA_RE_PRGT41Text for Refinancing ProgramLease Accounting
40ERP EHP76.0FILA_RE_TR_H201Tranche Header: Selection Result for RefinancingLease Accounting
41ERP EHP76.0FILA_RE_TR_I392Tranche Item: Selection Result for RefinancingLease Accounting
42ERP EHP76.0FIOTPOH121One-Time Postings: HeaderLease Accounting
43ERP EHP76.0FIOTPOI162One-Time Postings: ItemsLease Accounting
44ERP EHP76.0FSLC_ACTIVE_INV21FSL: BillingLease Accounting
45ERP EHP76.0FSL_IDOTYPM_CUST31Mapping Table for ID Object Type (AB) and ID Object Type(BP)Lease Accounting
46ERP EHP76.0FSL_STAT_CUST31FSL: User Status for ItemLease Accounting
47ERP EHP76.0FSL_STAT_CUST_T41FSL: User Status Text for ItemLease Accounting
48ERP EHP76.0LAE_BILLING_DAT111Payment ScheduleLease Accounting
49ERP EHP76.0LAE_BILLING_DATA111Payment ScheduleLease Accounting
50ERP EHP76.0LAE_CRM_BILLPLAN291Payment ScheduleLease Accounting
51ERP EHP76.0LAE_CRM_CLASS81Contract ClassificationLease Accounting
52ERP EHP76.0LAE_CRM_CONDS91Lease-Accounting-Relevant ConditionsLease Accounting
53ERP EHP76.0LAE_CRM_HEADER113LAE: CRM Contract HeaderLease Accounting
54ERP EHP76.0LAE_CRM_ITEMS686LAE: Contract ItemsLease Accounting
55ERP EHP76.0LAE_CRM_LNK72Link between LAE and CRM Contract ItemsLease Accounting
56ERP EHP76.0LAE_CRM_PRODS62Product InformationLease Accounting
57ERP EHP76.0LAE_VICN01_AD121Additional Contract Data for LAELease Accounting
58ERP EHP76.0TFIEH_GF_00191Handling MethodsLease Accounting
59ERP EHP76.0TFIEH_GF_00231Methods for Retrieval of Object DataLease Accounting
60ERP EHP76.0TFILAFM_IRCM61Assignment of Acct Prin. to Interest Rate Calc. MethodsLease Accounting
61ERP EHP76.0TFILA_ACCRULE41Accounting Principles for Classification in CRMLease Accounting
62ERP EHP76.0TFILA_ACCRULET61Accounting Principles for CRM Classification -TextsLease Accounting
63ERP EHP76.0TFILA_COMPONENT31Application Components of Accounting EngineLease Accounting
64ERP EHP76.0TFILA_EXPL_00151Structure of Tree Controls in Leasing ExplorerLease Accounting
65ERP EHP76.0TFILA_FA_00171Process+Accounting Principle -> Transaction TypeLease Accounting
66ERP EHP76.0TFILA_FA_00251Assignment Accounting Principle -> Depreciation AreaLease Accounting
67ERP EHP76.0TFILA_FA_00371Control of Useful Life Adjustment for UpgradesLease Accounting
68ERP EHP76.0TFILA_GF_00061Process Mapping for Processs from External SystemsLease Accounting
69ERP EHP76.0TFILA_GF_000C51Posting Periods Closed for Processes in LAELease Accounting
70ERP EHP76.0TFILA_GF_000M21MethodsLease Accounting
71ERP EHP76.0TFILA_GF_000MT31Method TextsLease Accounting
72ERP EHP76.0TFILA_GF_000P31ProcessesLease Accounting
73ERP EHP76.0TFILA_GF_000PT51Process TextsLease Accounting
74ERP EHP76.0TFILA_GF_000R31Reasons for ChangesLease Accounting
75ERP EHP76.0TFILA_GF_000RT51Change Reason TextsLease Accounting
76ERP EHP76.0TFILA_GF_00171Assignment Process -> SubprocessLease Accounting
77ERP EHP76.0TFILA_GF_001A61SYST: Allowed Change EventsLease Accounting
78ERP EHP76.0TFILA_GF_001C41Control Table for Value IDs to Be Changed or AddedLease Accounting
79ERP EHP76.0TFILA_GF_001CE81Specifications for Change ProcessesLease Accounting
80ERP EHP76.0TFILA_GF_001E51Processes for Changing Value ID ContentsLease Accounting
81ERP EHP76.0TFILA_GF_001M61Assignment Subprocess -> Processing MethodsLease Accounting
82ERP EHP76.0TFILA_GF_001MC71Assignment- Subprocesses to User-Defined Processing MethodsLease Accounting
83ERP EHP76.0TFILA_GF_001S51SubprocessesLease Accounting
84ERP EHP76.0TFILA_GF_001ST51SubprocessesLease Accounting
85ERP EHP76.0TFILA_GF_00361Value IDs and their DeterminationLease Accounting
86ERP EHP76.0TFILA_GF_003CF61Assignment of Value ID -> Payment Schedule for CalculationLease Accounting
87ERP EHP76.0TFILA_GF_003M71For Later Use of Value IDs for RetrievalLease Accounting
88ERP EHP76.0TFILA_GF_003MV61Assignment Value ID <-> Processing MethodLease Accounting
89ERP EHP76.0TFILA_GF_003R101Value IDs Referenced from MethodLease Accounting
90ERP EHP76.0TFILA_GF_003RB31Values/Data Required by MethodLease Accounting
91ERP EHP76.0TFILA_GF_003RM61Values/Data Required by MethodLease Accounting
92ERP EHP76.0TFILA_GF_003T51Value IDsLease Accounting
93ERP EHP76.0TFILA_GF_004121Assignment Value ID -> Accrual MethodLease Accounting
94ERP EHP76.0TFILA_GF_004BT61Assignment of Value ID -> Accrual Method for Determ. BalanceLease Accounting
95ERP EHP76.0TFILA_GF_004CF71Assignment of Payment Schedule for Accrual PostingsLease Accounting
96ERP EHP76.0TFILA_GF_00591Specifications for One-Time Postings per Value IDLease Accounting
97ERP EHP76.0TFILA_GF_00641Assignment Company Code -> Accounting PrinciplesLease Accounting
98ERP EHP76.0TFILA_GF_00771Assignment Condition Type -> Value IDLease Accounting
99ERP EHP76.0TFILA_GF_007C91Value IDs to Be Included in Payment ScheduleLease Accounting
100ERP EHP76.0TFILA_GF_007CF31Payment SchedulesLease Accounting
101ERP EHP76.0TFILA_GF_007CFA71Payment Schedule DefinitionLease Accounting
102ERP EHP76.0TFILA_GF_007CFT51Payment Schedule NamesLease Accounting
103ERP EHP76.0TFILA_GF_00841Assignment of Company Code to Grouping KeyLease Accounting
104ERP EHP76.0TFILA_GF_008G31Grouping KeyLease Accounting
105ERP EHP76.0TFILA_GF_008GT51Name of Grouping KeyLease Accounting
106ERP EHP76.0TFILA_GF_009101Assignment of Value IDs to Structure FieldLease Accounting
107ERP EHP76.0TFILA_GF_009F91Assignment of Field Transfer of Two StructuresLease Accounting
108ERP EHP76.0TFILA_GF_009V101Mapping Table for Structure Fields in Value IDsLease Accounting
109ERP EHP76.0TFILA_GF_01131Option IDsLease Accounting
110ERP EHP76.0TFILA_GF_011T51Option IDsLease Accounting
111ERP EHP76.0TFILA_GF_020S61Assign Value IDs for Determining Residual ValueLease Accounting
112ERP EHP76.0TFILA_GF_020T61Fill New Residual Values in ConditionsLease Accounting
113ERP EHP76.0TFILA_GF_02141Controls Number of ProcessesLease Accounting
114ERP EHP76.0TFILA_GF_10081Assignment of Derivations for Validations/SubstitutionsLease Accounting
115ERP EHP76.0TFILA_GF_11041Check Sequences in Financing ClassificationLease Accounting
116ERP EHP76.0TFILA_GF_110T51Texts of Check Sequences in Financing ClassificationLease Accounting
117ERP EHP76.0TFILA_GF_11161Check Steps in Financing ClassificationLease Accounting
118ERP EHP76.0TFILA_LC_00121Class GroupsLease Accounting
119ERP EHP76.0TFILA_LC_001T41Class GroupsLease Accounting
120ERP EHP76.0TFILA_LC_00241Financing ClassesLease Accounting
121ERP EHP76.0TFILA_LC_002AK61Assignment of Access Keys to Financing ClassesLease Accounting
122ERP EHP76.0TFILA_LC_002T41Texts for Financing ClassesLease Accounting
123ERP EHP76.0TFILA_LC_002TO71Specification Asset Values Copied for Following BusinessLease Accounting
124ERP EHP76.0TFILA_LC_00351Assignmt of Value IDs to Fields of FILA_LCS_PARAM StructureLease Accounting
125ERP EHP76.0TFILA_LC_00621Option IDsLease Accounting
126ERP EHP76.0TFILA_LC_006T41Option Indicators: NamesLease Accounting
127ERP EHP76.0TFILA_LDB_00091Assignment of Value IDs to Fields of Logical DBLease Accounting
128ERP EHP76.0TFILA_LDB_00181Determination of Data Basis for ReportsLease Accounting
129ERP EHP76.0TFILA_RE_CAT31Define Refinancing CategoryLease Accounting
130ERP EHP76.0TFILA_RE_CATT41Text for Refinancing CategoryLease Accounting
131ERP EHP76.0TFILA_RE_CAT_C141Assign Sales Tax Flag and Clearing Account to Refi. Categ.Lease Accounting
132ERP EHP76.0TFILA_RE_CHGPR41Assign Refinancing Categ. and Change Process to Cluster TypeLease Accounting
133ERP EHP76.0TFILA_RE_EVENT41Assign Refinancing Category and Process Type to ProcessesLease Accounting
134ERP EHP76.0TFILA_RE_RFF81Mapping for Payment Schedule ForfaitingLease Accounting
135ERP EHP76.0TFILA_RE_TNR41Number Range per Company Code and Refinancing TypeLease Accounting
136ERP EHP76.0TFILA_RE_TNRT51Text for Number Range per Refinancing Type and Company CodeLease Accounting
137ERP EHP76.0TFILA_RE_VAL81Assign Refinancing Category and Value IdentifierLease Accounting
138ERP EHP76.0TFIOTP_00151Document Group CharacteristicLease Accounting
139ERP EHP76.0TFIOTP_001T51Document Group Characteristic NameLease Accounting
140ERP EHP76.0TFIOTP_00231Account Determination RuleLease Accounting
141ERP EHP76.0TFIOTP_002T51Document Group Characteristic NameLease Accounting
142ERP EHP76.0TFIOTP_00371Posting Key for Document Grouping CharacteristicLease Accounting