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

63 columns | Print definition?ERP 6.0  | BKLAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____00U8SID-Tabelle fuer VC: Sales order stk3BKLASValuation Classnvarchar40
2/SMD/MD_____00URSID-Tabelle fuer Valuation Class3BKLASValuation Classnvarchar40
3/SMD/MD_____00XJSID-Tabelle fuer Proj. stk val. class3BKLASValuation Classnvarchar40
4/SMD/MD_____019WSID-Tabelle fuer Valuation Class3BKLASValuation Classnvarchar40
5BBPT_T023Material groups11BKLASValuation classnvarchar40
6CNV_20100_T030CNV backup copy for T0307BKLASnvarchar40
7J_1UF_TAXDEC_SELSelections for tax declaration17BKLASValuation Classnvarchar40
8T030Standard Accounts Table6BKLASValuation Classnvarchar40
TOPAccounting Interface
9GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)235BKLASValuation Classnvarchar40
10GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)235BKLASValuation Classnvarchar40
TOPActual CostingMaterial Ledger
11CKMLMV011Costing run: Object list8BKLASValuation Classnvarchar40
12CKMLMV011FCosting Run: Filter Table for Object List8BKLASValuation Classnvarchar40
13CKMVFM_OUTOutput for the Value_Flow_Monitor, see SAP Note 91298415BKLASValuation Classnvarchar40
14FCML_MATML Characteristics for Material (Selection Criteria)14BKLASValuation Classnvarchar40
15MLPPMaterial Ledger Document: Posting Periods and Quantities12BKLASValuation Classnvarchar40
TOPAlternative Valuation Run
16CKMLAVRDOCITLines for Cumulation Posting Document20BKLASValuation Classnvarchar40
TOPAssortment Maintenance
17TWPAGeneral Parameters for Retail Control17BKLASDefault valuation class for value-only materialnvarchar40
TOPBalance Sheet Valuation Procedures
18MYLAUFITObject Table for Delta Run Using MRN910BKLASValuation Classnvarchar40
TOPBasic Settings
19T8A62Activate Representative Material4BKLASValuation Classnvarchar40
TOPBatches
20WBEWActive Ingredient Valuation12BKLASValuation Classnvarchar40
TOPData Collection
21S032Statistics: Current Stock and Grouping Terms24BKLASValuation Classnvarchar40
22S039Statistics: Inventory Controlling92BKLASValuation Classnvarchar40
TOPExternal Services
23ASMDService Master: Basic Data18BKLASValuation Classnvarchar40
24ESLAService Type Editions16BKLASValuation Classnvarchar40
25ESLZService Type Lines11BKLASValuation Classnvarchar40
TOPFinancial Accounting
26ACCTITCompressed Data from FI/CO Document94BKLASValuation Classnvarchar40
27J_1GZSPVATAccounts substitutions for VAT report4BKLASValuation Classnvarchar40
28J_1UF_MR_CUSTExch.diff.accounting customizing4BKLASValuation Classnvarchar40
29T856LAssignment of LO Transaction Type to FI Transaction Type3BKLASValuation Classnvarchar40
TOPFreight Processing
30TVFTKDetermination: Shipment Cost Item Categories6BKLASValuation Classnvarchar40
31VFKPShipment Costs: Item Data34BKLASValuation Classnvarchar40
TOPFunds Management
32FMMM1Assignment Table for Warehouse Funds Center3BKLASValuation Classnvarchar40
TOPIndustry Solution Catch Weight Management
33/FMP/C_MP_DYNRELCustomizing for the Dynamic Price Release FMP3BKLASValuation Classnvarchar40
TOPInventory Management
34MWZDM07M1ZDM07M133BKLASValuation Classnvarchar40
TOPInvoice Verification
35RSEGDocument Item: Incoming Invoice26BKLASValuation Classnvarchar40
TOPLocalization
36J_3RFANKAFI-AA class settings for CIS4BKLASValuation Classnvarchar40
TOPLogistics - General
37OIG_TVFTKTD-F Determination: Valuation Class of Shipment Cost Items6BKLASValuation Classnvarchar40
TOPMaterial Groups
38T023Material Groups11BKLASValuation Classnvarchar40
TOPMaterial Master
39EBEWSales Order Stock Valuation14BKLASValuation Classnvarchar40
40EBEWHValuation of Sales Order Stock: History16BKLASValuation Classnvarchar40
41MBEWMaterial Valuation12BKLASValuation Classnvarchar40
42MBEWHMaterial Valuation: History13BKLASValuation Classnvarchar40
43MBEW_TMPFile for Incorrect Data in Direct Input15BKLASValuation Classnvarchar40
44MVEWMaterial Valuation12BKLASValuation Classnvarchar40
45MVEWHMaterial Valuation: History13BKLASValuation Classnvarchar40
46OBEWValuated Stock with Subcontractor13BKLASValuation Classnvarchar40
47OBEWHValuated Stock with Subcontractor: History15BKLASValuation Classnvarchar40
48QBEWProject Stock Valuation13BKLASValuation Classnvarchar40
49QBEWHValuation of Project Stock: History15BKLASValuation Classnvarchar40
50T025Valuation Classes2BKLASValuation Classnvarchar40
51T025TValuation Class Descriptions3BKLASValuation Classnvarchar40
TOPMaterials Management
52/SAPNEA/ROWAChargeable component consumptions32BKLASValuation Classnvarchar40
53J_1GPU32RULESMap of accounts 32 to 203BKLASValuation Classnvarchar40
54J_1GPURULESSource / Target G/L Accounts4BKLASValuation Classnvarchar40
55J_1GTSB01Text for Valuation Class2BKLASValuation Classnvarchar40
56J_1GVL_MLMaterial Ledger29BKLASValuation Classnvarchar40
57J_1GVL_WHB003Valid Materials4BKLASValuation Classnvarchar40
58J_1GVL_WHB013Analytical ledger material postings after valuation6BKLASValuation Classnvarchar40
59J_1GVL_WHB015FI reposting settings3BKLASValuation Classnvarchar40
60ROWAIndex table : Chargeable component consumptions32BKLASValuation Classnvarchar40
TOPMedia Product
61TJP_VAL_DATAValuation Template for Unit Costs Transfer9BKLASValuation Classnvarchar40
TOPProfit Center Accounting
62T8A00Account Determination for Profit Center Accounting4BKLASValuation Classnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
63NWCHGALDATIS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)8BKLASClasse di valor.nvarchar40