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

111 columns | Print definition?ERP 6.0  | CURTP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____0057SID-Tabelle fuer Exchange rate difference key5CURTPValuation Area for FI Year-End Closingnvarchar20
2CNVA_PCREA_AA_RLT PC Reorg Analysis: Asset Reconciliation results (Level 1)8CURTPCurrency Type and Valuation Viewnvarchar20
3CNVA_PCREA_WIP_RLT PC Reorg Analysis: WIP Reconciliation results (Level 1)12CURTPCurrency Type and Valuation Viewnvarchar20
4CNV_10510_FCVMAPMappingtable for conversion of foreign currencies6CURTPCurrency Type and Valuation Viewnvarchar20
5CNV_40305_POST_AAggregated amount to be reposted14CURTPCurrency Type and Valuation Viewnvarchar20
6CNV_40305_SIM_PAAggregated amount to be reposted15CURTPCurrency Type and Valuation Viewnvarchar20
7DFKKFWKORRNCumul. Table for Adjustment and Inverse Postings (New)4CURTPCurrency Type and Valuation Viewnvarchar20
8DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars23CURTPCurrency Type And Valuation Viewnvarchar20
9DFKK_NEWACCADJObsolete: See DFKK_ACCADJ23CURTPCurrency Type And Valuation Viewnvarchar20
10FAGL_BSBW_HISTLGValuation History of Ledger-Group-Specific Items6CURTPCurrency Type and Valuation Viewnvarchar20
11FAGL_ORG_INFC_CTClass. General Ledger: Configuration Information (Crcy Type)3CURTPCurrency Type and Valuation Viewnvarchar20
12FAGL_ORG_INFO_CTNew General Ledger: Configuration Information (Crcy Type)4CURTPCurrency Type and Valuation Viewnvarchar20
13GLPCA_CTProfit Center Documents6CURTPCurrency Type and Valuation Viewnvarchar20
14GLPCA_T_CTProfit Center Documents22CURTPCurrency Type and Valuation Viewnvarchar20
15GLPOS_C_CTFI Document: Entry View6CURTPCurrency Type and Valuation Viewnvarchar20
16GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items6CURTPCurrency Type and Valuation Viewnvarchar20
17GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items6CURTPCurrency Type and Valuation Viewnvarchar20
18GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items6CURTPCurrency Type and Valuation Viewnvarchar20
19GLPOS_N_CTNew General Ledger: Line Item with Currency Type6CURTPCurrency Type and Valuation Viewnvarchar20
20GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type6CURTPCurrency Type and Valuation Viewnvarchar20
21MLAUFCRHHistory table for summerized MLAUFCR data9CURTPCurrency Type and Valuation Viewnvarchar20
22MLAUFKEPHHHistory table for summarized MLAUFKEPH data14CURTPCurrency Type and Valuation Viewnvarchar20
23T030HAcct Determ.for Open Item Exch.Rate Differences5CURTPCurrency Type and Valuation Viewnvarchar20
24T030SAccts for Foreign Currency Assets Exchange Rate Differences4CURTPValuation Area for FI Year-End Closingnvarchar20
25TBKOWValuation Difference Temporary Storage3CURTPCurrency Type and Valuation Viewnvarchar20
TOPAccounting Interface
26GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)434CURTPCurrency Type and Valuation Viewnvarchar20
27GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)434CURTPCurrency Type and Valuation Viewnvarchar20
TOPActual CostingMaterial Ledger
28CKMLCRMaterial Ledger: Period Totals Records Values6CURTPCurrency Type and Valuation Viewnvarchar20
29CKMLCRWIPMaterial Ledger: WIP Period Records (Values)6CURTPCurrency Type and Valuation Viewnvarchar20
30CKMLCTCurrency Types and Valuation Types in a Valuation Area3CURTPCurrency Type and Valuation Viewnvarchar20
31CKMLCURText for currency type and valuation type3CURTPCurrency Type and Valuation Viewnvarchar20
32CKMLKEPHMaterial Ledger: Cost Component Split (Elements)14CURTPCurrency Type and Valuation Viewnvarchar20
33CKMLKEVMaterial Ledger: Cost Component Split (Control Record)6CURTPCurrency Type and Valuation Viewnvarchar20
34CKMLLACRML Activity Type: Period Record/Currency Record6CURTPCurrency Type and Valuation Viewnvarchar20
35CKMLLACRWIPML Activity Types: Period/ Currency Records WIP (Values)6CURTPCurrency Type and Valuation Viewnvarchar20
36CKMLMYMPPeriodic Receipt Values for Consumption Sequence Procedure8CURTPCurrency Type and Valuation Viewnvarchar20
37CKMLPRMaterial Ledger: Prices3CURTPCurrency Type and Valuation Viewnvarchar20
38CKMLPRKEKOMaterial Ledger: Cost Component Split (Header) for Prices7CURTPCurrency Type and Valuation Viewnvarchar20
39CKMLPRKEPHMaterial Ledger: Cost Component Split (Elements) for Prices11CURTPCurrency Type and Valuation Viewnvarchar20
40CKMLPR_EBPrices for Ending Inventory/Balance Sheet Valuation7CURTPCurrency Type and Valuation Viewnvarchar20
41CKMLRUNPERIODMaterial ledger costing run for one month29CURTPCurrency Type and Valuation Viewnvarchar20
42CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 9129844CURTPCurrency Type and Valuation Viewnvarchar20
43FCML_CCS_REPHDB Reporting Structure for ML16CURTPCurrency Type and Valuation Viewnvarchar20
44FCML_REPML Reporting Structure13CURTPCurrency Type and Valuation Viewnvarchar20
45MLAUFCRMaterial Ledger Currency Table for Order History8CURTPCurrency Type and Valuation Viewnvarchar20
46MLAUFKEPHML: Cost Component Split (Components) for Order History13CURTPCurrency Type and Valuation Viewnvarchar20
47MLBECRMaterial Ledger Currency Table for GR/IR relevant transact.7CURTPCurrency Type and Valuation Viewnvarchar20
48MLBECRHMaterial Ledger Currency Table for GR/IR relevant transact.7CURTPCurrency Type and Valuation Viewnvarchar20
49MLBEKEPHML: Cost Comp. Split (Elements) for Purchase Order History12CURTPCurrency Type and Valuation Viewnvarchar20
50MLCDMaterial Ledger: Summarization Record (from Documents)9CURTPCurrency Type and Valuation Viewnvarchar20
51MLCRMaterial Ledger Document: Currencies and Values7CURTPCurrency Type and Valuation Viewnvarchar20
52MLCRFMaterial Ledger Document: Field Groups (Currencies)7CURTPCurrency Type and Valuation Viewnvarchar20
53MLCRPMaterial Ledger Document: Price Changes (Currencies, Prices)7CURTPCurrency Type and Valuation Viewnvarchar20
54MLKEPHML Document: Cost Component Split (Elements) for Values12CURTPCurrency Type and Valuation Viewnvarchar20
55MLPRKEKOML Document: Cost Component Split (Header)for Prices8CURTPCurrency Type and Valuation Viewnvarchar20
56MLPRKEPHML Document: Cost Component Split (Components)for Prices12CURTPCurrency Type and Valuation Viewnvarchar20
57TCKMLBNKSZAssignment of Delivery Costs Structure2CURTPCurrency Type and Valuation Viewnvarchar20
58TMLCCSCRAct.Cost Comp. Split: Data Range in Valuation Area (Curr)3CURTPCurrency Type and Valuation Viewnvarchar20
TOPAlternative Valuation Run
59CKMLAVRDOCCRCumulation Posting Document: Currency Information5CURTPCurrency Type and Valuation Viewnvarchar20
60CKMLRUNSCALERe-scaling Amounts in the AVR6CURTPCurrency Type and Valuation Viewnvarchar20
TOPBalance Sheet Valuation Procedures
61MYML1VLIFO: Transaction-Related Material Layer (Values)8CURTPCurrency Type and Valuation Viewnvarchar20
TOPBasic Functions
62T093AReal depreciation area17CURTPCurrency Type and Valuation Viewnvarchar20
63T881_KEYFIGFI-SL: Key Figures per Ledger4CURTPCurrency Type and Valuation Viewnvarchar20
TOPContract Accounts Receivable and Payable
64DFKKFWBEWManagement Data for Foreign Currency Valuations4CURTPCurrency Type and Valuation Viewnvarchar20
65DFKKFWBEW_LDManagement Data for Ledger-Specific Foreign Crcy Valuations5CURTPCurrency Type and Valuation Viewnvarchar20
66DFKKFWKORRCumulation Table for Adjustment and Inverse Postings3CURTPCurrency Type and Valuation Viewnvarchar20
67DFKKOPBEWFI-CA Foreign Currency Valuation5CURTPCurrency Type and Valuation Viewnvarchar20
68DFKKOPBEW_LDFI-CA Ledger-Specific Foreign Currency Valuation6CURTPCurrency Type and Valuation Viewnvarchar20
69DFKK_DUEGRIDOI - Reclassifications28CURTPCurrency Type And Valuation Viewnvarchar20
70DFKK_RECLASSOI - Reclassifications22CURTPCurrency Type And Valuation Viewnvarchar20
71TFK020VBFS Preparation: Summarization Co. Codes for Reclassification2CURTPCurrency Type and Valuation Viewnvarchar20
72TFK044DFI-CA Company Code Valuation5CURTPCurrency Type And Valuation Viewnvarchar20
TOPCustomer Bill of Services
73ADBOS_ECP_CKISBOS: Enhancement to Detailed Statement10CURTPCurrency Type and Valuation Viewnvarchar20
TOPData Transfer
74PPDITTransfer to Accounting: Lines in HR IDOCs34CURTPCurrency Type and Valuation Viewnvarchar20
75PPDSTTransfer to Accounting: Substituted Acc. Assig. Object19CURTPCurrency Type and Valuation Viewnvarchar20
TOPFinancial Accounting
76ACCTCRCompressed Data from FI/CO Document - Currencies6CURTPCurrency Type and Valuation Viewnvarchar20
77BSBMDocument Valuation Fields6CURTPCurrency Type and Valuation Viewnvarchar20
78BSBMTText for Valuation Adjustment or Deductible per Item6CURTPCurrency Type and Valuation Viewnvarchar20
79BSBWDocument Valuation Fields6CURTPCurrency Type and Valuation Viewnvarchar20
80F107_TPROVProvisions5CURTPCurrency Type and Valuation Viewnvarchar20
81SLPBLog Table for Valuation6CURTPCurrency Type and Valuation Viewnvarchar20
82T001AAdditional Local Currencies Control for Company Code3CURTPCurrency Type and Valuation Viewnvarchar20
83T033FI Depreciation Area3CURTPCurrency Type and Valuation Viewnvarchar20
84T044HTFlat-rate Value Adjustment of Individual Documents (Text)7CURTPCurrency Type and Valuation Viewnvarchar20
TOPFunds Management
85KBLEWItem development amounts in various currencies6CURTPCurrency Type and Valuation Viewnvarchar20
86KBLPWDocument item amounts in different currencies5CURTPCurrency Type and Valuation Viewnvarchar20
TOPGeneral Ledger Accounting
87FAGL_BSBW_HISTRYValuation History for Documents6CURTPCurrency Type and Valuation Viewnvarchar20
88FAGL_BSBW_HST_BLValuation History of Balances5CURTPCurrency Type and Valuation Viewnvarchar20
89FAGL_SPLINFO_VALSplitting Information of Open Item Values7CURTPCurrency Type and Valuation Viewnvarchar20
TOPGeneral Ledger Reorganization
90FAGL_R_APAR_VALReorg: Values for Receivables and Payables Object List13CURTPCurrency Type and Valuation Viewnvarchar20
91FAGL_R_BLNCE_VALReorganization: Balances to Be Transferred - Values14CURTPCurrency Type and Valuation Viewnvarchar20
92FAGL_R_SPL_VALReorganization: Splitting Information of Open Item Values7CURTPCurrency Type and Valuation Viewnvarchar20
TOPIndustry Solution Catch Weight Management
93/FMP/D_MP_HISTMaterial Price History5CURTPCurrency Type and Valuation Viewnvarchar20
94/FMP/D_MP_PRICMaterial Prices5CURTPCurrency Type and Valuation Viewnvarchar20
TOPInformation System
95BWKSAccounts Blocked by Valuation Selection5CURTPCurrency Type and Valuation Viewnvarchar20
96T044JPreference Key for Reading Valuation Results4CURTPCurrency Type and Valuation Viewnvarchar20
TOPLocal Currency Changeover
97EWUCKMLWEMU: Currencies for material ledger4CURTPCurrency Type and Valuation Viewnvarchar20
98EWUFIAASUMEWU conversion: Table for asset totals at account level8CURTPCurrency Type and Valuation Viewnvarchar20
99EWUMMFIEMU: transfer table for clearing entries MM-FI7CURTPCurrency Type and Valuation Viewnvarchar20
TOPMulti Currency Accounting
100GLE_MCA_RV_HSTRYFX Revaluation History7CURTPCurrency Type and Valuation Viewnvarchar20
101GLE_MCA_T030HGLE MCA Accounts Table7CURTPCurrency Type and Valuation Viewnvarchar20
TOPProduct Cost Planning
102TCK27Cost Component Split in Different Currency6CURTPCurrency Type for Controlling Areanvarchar20
TOPProfitability Analysis
103TKECHACOADChange of KOKRS/ERKRS Assignments: Administration17CURTPExchange Rate Typenvarchar40
104TKELCO-PA ledger3CURTPCurrency Type and Valuation Viewnvarchar20
TOPTechnical Application Support
105CNV_20425_AASUMEWU conversion: Table for asset totals at account level7CURTPCurrency Type and Valuation Viewnvarchar20
TOPTransfer Prices and Decentralized Responsibility
106KFPEWClearing Amounts in Various Currencies7CURTPCurrency Type and Valuation Viewnvarchar20
107KFPPWDocument Item Amounts in Different Currencies6CURTPCurrency Type and Valuation Viewnvarchar20
TOPTravel Expenses
108PTRV_DOC_ITTransfer Travel -> FI/CO: Lines of TRV interm. document36CURTPCurrency Type and Valuation Viewnvarchar20
109PTRV_DOC_TAXTransfer Travel -> FI/CO: Tax lines of TRV document13CURTPCurrency Type and Valuation Viewnvarchar20
TOPTreasury
110FLQCLNTLiquidity Calculation - Global Settings10CURTPLiquidity Calculation: Currency Type for Third Currencynvarchar20
111FLQCOMPANYLiquidity Calculation - Company Codes5CURTPLiquidity Calculation: Currency Type for Third Currencynvarchar20