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

137 columns | Print definition?ERP 6.0  | BWKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SMR1Inventory value in "hard" currency5BWKEYValuation Areanvarchar40
2/OPT/VIM_1ITEM_SDocument Item90BWKEYValuation Areanvarchar40
3/OPT/VIM_TITEMDocument Item90BWKEYValuation Areanvarchar40
4/SMD/MD_____00UVSID-Tabelle fuer Valuation Area3BWKEYValuation Areanvarchar40
5BSEGAccounting Document Segment183BWKEYValuation Areanvarchar40
6BSIM_BAKSecondary Index, Documents for Material3BWKEYValuation Areanvarchar40
7BSSEGAccounting Document Segment172BWKEYValuation Areanvarchar40
8CNV_20000_RSEGBackup copy of RSEG (line item for incoming invoice)5BWKEYValuation Areanvarchar40
9CNV_20100_T001KCNV backup copy for T001K3BWKEYValuation Areanvarchar40
10CNV_20100_T001WCNV backup copy for T001W4BWKEYValuation Areanvarchar40
11FUDT_VDOCBSEGVerification Document Item with Additional Info172BWKEYValuation Areanvarchar40
12FUDT_VDOCBSEGEVVerification Document Item in the Entry View172BWKEYValuation Areanvarchar40
13FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)172BWKEYValuation Areanvarchar40
14GLPCA_CTProfit Center Documents56BWKEYValuation Areanvarchar40
15GLPCA_T_CTProfit Center Documents72BWKEYValuation Areanvarchar40
16GLPOS_C_CTFI Document: Entry View74BWKEYValuation Areanvarchar40
17GLPOS_C_DEB_CTGLPOS_C_CT Customer Line Items74BWKEYValuation Areanvarchar40
18GLPOS_C_GL_CTGLPOS_C_CT G/L Line Items74BWKEYValuation Areanvarchar40
19GLPOS_C_VEN_CTGLPOS_C_CT Vendor Line Items74BWKEYValuation Areanvarchar40
20GLPOS_N_CTNew General Ledger: Line Item with Currency Type74BWKEYValuation Areanvarchar40
21GLPOS_N_GL_CTNew General Ledger: Line Item with Currency Type74BWKEYValuation Areanvarchar40
22MYMBEW_BUKRSIndex Table for Material Company Code4BWKEYValuation Areanvarchar40
23TCKM2Valuation Area Control Table2BWKEYValuation Areanvarchar40
24TCO10Valuation variant for order costing2BWKEYValuation Areanvarchar40
25TKA3CAutomatic Acct. Assignment: Specific Assignments4BWKEYValuation Areanvarchar40
26USRMMUser settings: material master10BWKEYValuation Areanvarchar40
27YVIM_1ITEMDocument Item90BWKEYValuation Areanvarchar40
TOPAccounting - General
28TFC_ALL_ORGExtracted Master Data8BWKEYValuation Areanvarchar40
29TFC_INST_ALL_ORExtracted Master Data10BWKEYValuation Areanvarchar40
30TFC_TEMPL_ALL_ORExtracted Master Data10BWKEYValuation Areanvarchar40
TOPAccounting Interface
31GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)204BWKEYValuation Areanvarchar40
32GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)204BWKEYValuation Areanvarchar40
TOPActual CostingMaterial Ledger
33CKMI1Index for Accounting Documents for Material13BWKEYValuation Areanvarchar40
34CKML2Material Ledger Header Record (Release 3.xx)4BWKEYValuation Areanvarchar40
35CKMLAB02Material Update Structure (Assignment to Valuation Area)2BWKEYValuation Areanvarchar40
36CKMLCTCurrency Types and Valuation Types in a Valuation Area2BWKEYValuation Areanvarchar40
37CKMLHDMaterial Ledger: Header Record9BWKEYValuation Areanvarchar40
38CKMLHD_AGGRMaterial Ledger: Header Record9BWKEYValuation Areanvarchar40
39CKMLKEVMaterial Ledger: Cost Component Split (Control Record)2BWKEYValuation Areanvarchar40
40CKMLMV001Procurement alternatives4BWKEYValuation Areanvarchar40
41CKMLMV002Assignments material / procurement alternatives6BWKEYValuation Areanvarchar40
42CKMLMV003Process model: Receipts / mixing strategies13BWKEYValuation Areanvarchar40
43CKMLMV004Process model: Withdrawals10BWKEYValuation Areanvarchar40
44CKMLMV005Consumption alternatives4BWKEYValuation Areanvarchar40
45CKMLMV011Costing run: Object list5BWKEYValuation Areanvarchar40
46CKMLMV011FCosting Run: Filter Table for Object List5BWKEYValuation Areanvarchar40
47CKMLMV015Naming rule assignment for materials (header)4BWKEYValuation Areanvarchar40
48CKMLMV_AUX_KALNRCost Estimate Numbers for Valuated Objects in QST4BWKEYValuation Areanvarchar40
49CKMLOMaterial Ledger: Organizational Jobs2BWKEYValuation Areanvarchar40
50CKMLRUNPLANTOrganizational units in a material ledger costing run8BWKEYValuation Areanvarchar40
51CKMLRUNTYPEBWKEYObsolete From Release 4.6A3BWKEYValuation Areanvarchar40
52CKMLVMaterial Ledger Control Records2BWKEYValuation Areanvarchar40
53CKMLWMaterial Ledger Currencies in Valuation Area2BWKEYValuation Areanvarchar40
54CKML_PRICE_SENDCustomizing Material Price Dispatch2BWKEYValuation Areanvarchar40
55CKMVFM_BSEG_OUTDisplay of FI Documents, Transaction CKMVFM, SAP Note 9129844BWKEYValuation Areanvarchar40
56CKMVFM_EXTRACTTransaction CKMVFM, Extracts, see SAP Note 91298411BWKEYValuation Areanvarchar40
57CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298412BWKEYValuation Areanvarchar40
58FCML_ALTAlternatives3BWKEYValuation Area (Alternative)nvarchar40
59FCML_MATML Characteristics for Material (Selection Criteria)6BWKEYValuation Areanvarchar40
60FCML_PROCBusiness Processes3BWKEYValuation Area (Process)nvarchar40
61MLARC_IDXIndex for ML Document4BWKEYValuation Areanvarchar40
62MLITMaterial Ledger Document: Items8BWKEYValuation Areanvarchar40
63TCKMLBNKSZAssignment of Delivery Costs Structure4BWKEYValuation Areanvarchar40
64TMLCCSCRAct.Cost Comp. Split: Data Range in Valuation Area (Curr)2BWKEYValuation Areanvarchar40
65TMLCCSHDAct.Cost Comp. Split: Data Range in Valuation Area (General)2BWKEYValuation Areanvarchar40
TOPAlternative Valuation Run
66CKMLAVRDOCITLines for Cumulation Posting Document13BWKEYValuation Areanvarchar40
TOPBalance Sheet Valuation Procedures
67MYLAUFITObject Table for Delta Run Using MRN99BWKEYValuation Areanvarchar40
68TNIW5WLowest Value: Devaluatn by Range of Cov. for Each Val. Area2BWKEYValuation Areanvarchar40
69TNIW6WLowest Value: Devaluation for Slow/Non-movement by Val.Area2BWKEYValuation Areanvarchar40
70TNIW9Reduction of Sales Prices (Lowest Value)2BWKEYValuation Areanvarchar40
TOPBatches
71WBEWActive Ingredient Valuation3BWKEYValuation Areanvarchar40
TOPElectronic Bank Statement
72FEB_ACCNT_SAVESaving of Posting Lines for Postprocessing (Account Assign.)40BWKEYValuation Areanvarchar40
73FEB_ACTAcct Assignment Templates40BWKEYValuation Areanvarchar40
TOPFinancial Accounting
74/OPT/VIM_1ITEMDocument Item90BWKEYValuation Areanvarchar40
75ACCTITCompressed Data from FI/CO Document76BWKEYValuation Areanvarchar40
76J_1GZSPVATAccounts substitutions for VAT report3BWKEYValuation Areanvarchar40
77VBSEGSDocument Segment for Document Parking - G/L Account Database61BWKEYValuation Areanvarchar40
TOPFunds Management-Specific Postings
78FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years60BWKEYValuation Areanvarchar40
79PSOSEGSRecurring Request Document Segment, G/L Accounts59BWKEYValuation Areanvarchar40
TOPGeneral Ledger Accounting
80BSEG_ADDEntry View of Accounting Document for Additional Ledgers111BWKEYValuation Areanvarchar40
TOPGL Account Posting
81TCJ_POSITIONSCash Journal Document Items47BWKEYValuation Areanvarchar40
TOPIndustry Solution Catch Weight Management
82/CWM/MIG_MBEWMUTMBEW Master Segments3BWKEYValuation Areanvarchar40
TOPInventory Management
83MMINKONWorklist for Inconsistent Materials2BWKEYValuation Areanvarchar40
84MMINKON_UPCorrections due to Technical Problems with Stock7BWKEYValuation Areanvarchar40
85MWXVM07MFields: Update Control of Module Pool SAPMM07M32BWKEYValuation Areanvarchar40
86MWZVM07MFields: Update Control of Module Pool SAPMM07M32BWKEYValuation Areanvarchar40
87ORIG_PR_MBEWSales Price Origin of Last Total Revaluation at Retail3BWKEYValuation Areanvarchar40
88T134HOrganiz. Unit: Business Area Determ. - MM View2BWKEYValuation Areanvarchar40
89T134MControl of Qty/Value Update2BWKEYValuation Areanvarchar40
90TASSIGN_MM_T001WAux. Table for Status Info SD Maintenance View: Key VKORG2BWKEYValuation Areanvarchar40
91USEGRetail Revaluation Document: Revaluation Segment7BWKEYValuation Areanvarchar40
TOPInvoice Verification
92BSIMSecondary Index, Documents for Material3BWKEYValuation Areanvarchar40
93RBMADocument Item: Incoming Invoice for Material8BWKEYValuation Areanvarchar40
94RSEGDocument Item: Incoming Invoice9BWKEYValuation Areanvarchar40
TOPJoint Venture und Production Sharing Accounting
95T8JDValuation type with JV-information2BWKEYValuation Areanvarchar40
TOPLocal Currency Changeover
96EWUCKMLWEMU: Currencies for material ledger3BWKEYValuation Areanvarchar40
TOPLocalization
97J_1AINFINVInflation: Invoices for Replacement Value Determination8BWKEYValuation Areanvarchar40
98J_1AINFMBWMaterial Master - Inflation3BWKEYValuation Areanvarchar40
99J_1AINFT16Warehouse report ( data of previous fiscal years )3BWKEYValuation Areanvarchar40
100J_1BLPPAverage Tax Rates for Reimbursement3BWKEYValuation Areanvarchar40
101J_1BNFLINNota Fiscal line items5BWKEYValuation Areanvarchar40
TOPLogistics Basic Data
102DMF_D_T001WTransferred Sites4BWKEYValuation Areanvarchar40
TOPMaterial Master
103EBEWSales Order Stock Valuation3BWKEYValuation Areanvarchar40
104EBEWHValuation of Sales Order Stock: History3BWKEYValuation Areanvarchar40
105MABWManagement of Differently Maintained Material Data in Retail10BWKEYValuation Areanvarchar40
106MBEWMaterial Valuation3BWKEYValuation Areanvarchar40
107MBEWHMaterial Valuation: History3BWKEYValuation Areanvarchar40
108MBEW_TMPFile for Incorrect Data in Direct Input6BWKEYValuation Areanvarchar40
109MOFFOutstanding Material Master Records8BWKEYValuation Areanvarchar40
110MSTAMaterial Master Status15BWKEYValuation Areanvarchar40
111MVEWMaterial Valuation3BWKEYValuation Areanvarchar40
112MVEWHMaterial Valuation: History3BWKEYValuation Areanvarchar40
113OBEWValuated Stock with Subcontractor3BWKEYValuation Areanvarchar40
114OBEWHValuated Stock with Subcontractor: History3BWKEYValuation Areanvarchar40
115QBEWProject Stock Valuation3BWKEYValuation Areanvarchar40
116QBEWHValuation of Project Stock: History3BWKEYValuation Areanvarchar40
117T149Valuation type/valuation class2BWKEYValuation Areanvarchar40
118T149AValuation types for valuation area2BWKEYValuation Areanvarchar40
119T149BValuation Category/Valuation type2BWKEYValuation Areanvarchar40
120USRM1Material Master User Settings: Organizational Levels11BWKEYValuation Areanvarchar40
TOPMaterials Management
121/SAPNEA/J_SC_ACTActivate Subcontracting with Chargeable Components2BWKEYValuation Areanvarchar40
122J_1GVL_WHB015FI reposting settings2BWKEYValuation Areanvarchar40
TOPOverhead Cost Controlling
123PFFLDPeriod-End Partner: Organizational Log Information13BWKEYValuation Areanvarchar40
TOPPlant Master
124T001KValuation area2BWKEYValuation Areanvarchar40
125T001WPlants/Branches4BWKEYValuation Areanvarchar40
TOPProduct Cost Planning
126KEKOProduct Costing - Header Data11BWKEYValuation Areanvarchar40
127KNOBAssignment of Cost Est. Number to Config. Object3BWKEYValuation Areanvarchar40
128TCK14Overhead Groups2BWKEYValuation Areanvarchar40
129TCK15Descriptions for Overhead Groups3BWKEYValuation Areanvarchar40
130TCK33Assignment of Condition Types to Origin Group8BWKEYValuation Areanvarchar40
TOPProfit Center Accounting
131GLPCAEC-PCA: Actual Line Items59BWKEYValuation Areanvarchar40
132GLPCPEC-PCA: Plan Line Items120BWKEYValuation Areanvarchar40
TOPReal Estate Management
133VIAKBSEGDocument Line Item from SCS for Interface38BWKEYValuation Areanvarchar40
TOPRemaining Beverage - Obsolete Objects
134/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1174BWKEYValuation Areanvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
135NWCHGALDATIS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)10BWKEYArea valorizzazionenvarchar40
TOPTariffs, Duties and Permits
136OIH_TAX_REVExcise Duty Revaluation Documents9BWKEYValuation Areanvarchar40
TOPVehicle Management System
137VLCBATCHACTVELO : Variant for Action Execution in Batch5BWKEYValuation Areanvarchar40