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

96 columns | Print definition?ERP 6.0  | LFGJA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table394LFGJAFiscal Year of Current Periodnvarchar40
2/SMERP/STG_MM002Data staging - Material storage location view complex table203LFGJAFiscal Year of Current Periodnvarchar40
3FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice36LFGJAFiscal Year of Current Periodnvarchar40
4ZEIM_LIPSSD document: Delivery: Item data231LFGJAFiscal Year of Current Periodnvarchar40
TOPBalance Sheet Valuation Procedures
5MYMP1RStorage for Invoice Differences (LIFO/FIFO)7LFGJAFiscal Year of Current Periodnvarchar40
TOPBatches
6WBEWActive Ingredient Valuation30LFGJAFiscal Year of Current Periodnvarchar40
TOPCross-Application Components
7MMARCPlant Data for Material198LFGJAFiscal Year of Current Periodnvarchar40
TOPFinancial Accounting
8VBSEGSDocument Segment for Document Parking - G/L Account Database60LFGJAMaterial Document Yearnvarchar40
TOPFunds Management-Specific Postings
9FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years59LFGJAMaterial Document Yearnvarchar40
10PSOSEGSRecurring Request Document Segment, G/L Accounts58LFGJAMaterial Document Yearnvarchar40
TOPHydrocarbon Product Management
11MARCHO1MARCH: Additional quantities appendix4LFGJAFiscal Year of Current Periodnvarchar40
12MARDHO1MARDH: Aditional quantities appendix5LFGJAFiscal Year of Current Periodnvarchar40
13MCHBHO1MCHBH: Additional quantities appendix6LFGJAFiscal Year of Current Periodnvarchar40
14MKOLHO1MKOLH: Additional quantities appendix8LFGJAFiscal Year of Current Periodnvarchar40
15MSKAHO1MSKAH: Additional quantities appendix9LFGJAFiscal Year of Current Periodnvarchar40
16MSKUHO1MSKUH: Additional quantities appendix7LFGJAFiscal Year of Current Periodnvarchar40
17MSLBHO1MSLB: Additional quantities appendix7LFGJAFiscal Year of Current Periodnvarchar40
18MSPRHO1MSPRH: Additional quantities appendix8LFGJAFiscal Year of Current Periodnvarchar40
19MSPRO1Project Stock additional quantities9LFGJAFiscal Year of Current Periodnvarchar40
TOPInventory Management
20MMINKON_UPCorrections due to Technical Problems with Stock18LFGJAFiscal Year of Current Periodnvarchar40
21MSTBStock in Transit7LFGJAFiscal Year of Current Periodnvarchar40
22MSTBHStock in Transit - History7LFGJAFiscal Year of Current Periodnvarchar40
23MSTEStock in Transit to Sales and Distribution Document9LFGJAFiscal Year of Current Periodnvarchar40
24MSTEHSiT to Sales and Distribution Document - History9LFGJAFiscal Year of Current Periodnvarchar40
25MSTQStock in Transit for Project8LFGJAFiscal Year of Current Periodnvarchar40
26MSTQHStock in Transit for Project - History8LFGJAFiscal Year of Current Periodnvarchar40
27MWXVM07MFields: Update Control of Module Pool SAPMM07M29LFGJAFiscal Year of Current Periodnvarchar40
28MWZVM07MFields: Update Control of Module Pool SAPMM07M29LFGJAFiscal Year of Current Periodnvarchar40
TOPInvoice Verification
29RBDRSEGBatch IV: Invoice Document Items24LFGJAFiscal Year of Current Periodnvarchar40
30RSEGDocument Item: Incoming Invoice49LFGJAFiscal Year of Current Periodnvarchar40
TOPLocalization
31IDEU_VATEU VAT Posting20LFGJAFiscal Year of a Reference Documentnvarchar40
TOPMaterial Master
32EBEWSales Order Stock Valuation32LFGJAFiscal Year of Current Periodnvarchar40
33EBEWHValuation of Sales Order Stock: History8LFGJAFiscal Year of Current Periodnvarchar40
34MARCPlant Data for Material198LFGJAFiscal Year of Current Periodnvarchar40
35MARCHMaterial Master C Segment: History4LFGJAFiscal Year of Current Periodnvarchar40
36MARC_TMPFile for Incorrect Data in Direct Input201LFGJAFiscal Year of Current Periodnvarchar40
37MARDStorage Location Data for Material7LFGJAFiscal Year of Current Periodnvarchar40
38MARDHMaterial Master Storage Location Segment: History5LFGJAFiscal Year of Current Periodnvarchar40
39MARD_TMPFile for Incorrect Data in Direct Input10LFGJAFiscal Year of Current Periodnvarchar40
40MARVMaterial Control Record3LFGJAFiscal Year of Current Periodnvarchar40
41MARVCDChange Document: Period Initialization when System in Op.9LFGJAFiscal Year of Current Periodnvarchar40
42MBEWMaterial Valuation30LFGJAFiscal Year of Current Periodnvarchar40
43MBEWHMaterial Valuation: History5LFGJAFiscal Year of Current Periodnvarchar40
44MBEW_TMPFile for Incorrect Data in Direct Input33LFGJAFiscal Year of Current Periodnvarchar40
45MCHBBatch Stocks11LFGJAFiscal Year of Current Periodnvarchar40
46MCHBHBatch Stocks: History6LFGJAFiscal Year of Current Periodnvarchar40
47MKOLSpecial Stocks from Vendor13LFGJAFiscal Year of Current Periodnvarchar40
48MKOLHSpecial Stocks from Vendor: History8LFGJAFiscal Year of Current Periodnvarchar40
49MSCASales Orders on Hand with Vendor9LFGJAFiscal Year of Current Periodnvarchar40
50MSCAHSales Order Stock at Vendor: History9LFGJAFiscal Year of Current Periodnvarchar40
51MSKASales Order Stock9LFGJAFiscal Year of Current Periodnvarchar40
52MSKAHSales Order Stock: History9LFGJAFiscal Year of Current Periodnvarchar40
53MSKUSpecial Stocks with Customer7LFGJAFiscal Year of Current Periodnvarchar40
54MSKUHSpecial Stocks at Customer: History7LFGJAFiscal Year of Current Periodnvarchar40
55MSLBSpecial Stocks with Vendor7LFGJAFiscal Year of Current Periodnvarchar40
56MSLBHSpecial Stocks at Vendor: History7LFGJAFiscal Year of Current Periodnvarchar40
57MSOATotal Sales Orders on Hand with Vendor8LFGJAFiscal Year of Current Periodnvarchar40
58MSPRProject Stock8LFGJAFiscal Year of Current Periodnvarchar40
59MSPRHProject Stock: History8LFGJAFiscal Year of Current Periodnvarchar40
60MSSATotal Customer Orders on Hand7LFGJAFiscal Year of Current Periodnvarchar40
61MSSAHTotal Sales Order Stocks: History7LFGJAFiscal Year of Current Periodnvarchar40
62MSSLTotal Special Stocks with Vendor6LFGJAFiscal Year of Current Periodnvarchar40
63MSSQProject Stock Total6LFGJAFiscal Year of Current Periodnvarchar40
64MSSQHTotal Project Stocks: History6LFGJAFiscal Year of Current Periodnvarchar40
65MVEWMaterial Valuation30LFGJAFiscal Year of Current Periodnvarchar40
66MVEWHMaterial Valuation: History5LFGJAFiscal Year of Current Periodnvarchar40
67MVRCCross-version fields for MARC198LFGJAFiscal Year of Current Periodnvarchar40
68MVRDStorage Location Data for Material7LFGJAFiscal Year of Current Periodnvarchar40
69OBEWValuated Stock with Subcontractor31LFGJAFiscal Year of Current Periodnvarchar40
70OBEWHValuated Stock with Subcontractor: History7LFGJAFiscal Year of Current Periodnvarchar40
71QBEWProject Stock Valuation31LFGJAFiscal Year of Current Periodnvarchar40
72QBEWHValuation of Project Stock: History7LFGJAFiscal Year of Current Periodnvarchar40
TOPPurchasing
73EKBEHistory per Purchasing Document24LFGJAFiscal Year of a Reference Documentnvarchar40
74EKBEHRemoved PO History Records24LFGJAFiscal Year of a Reference Documentnvarchar40
75EKBEH_MARemoved PO History Records at Account Assignment Level9LFGJAFiscal Year of Current Periodnvarchar40
76EKBE_MAHistory of Purchasing Document at Account Assignment Level9LFGJAFiscal Year of Current Periodnvarchar40
77EKBE_SCComponent Consumption History for Subcontracting9LFGJAFiscal Year of Current Periodnvarchar40
78EKDFDocument Flow for Logistics Differential Invoice7LFGJAFiscal Year of Current Periodnvarchar40
79EKRSERS Procedure: Goods (Merchandise) Movements to be Invoiced11LFGJAFiscal Year of a Reference Documentnvarchar40
TOPShipping
80LIPSSD document: Delivery: Item data231LFGJAFiscal Year of Current Periodnvarchar40
TOPSpare Part Sharing and Stock Providede by Customer
81MCSDCustomer Stock9LFGJAFiscal Year of Current Periodnvarchar40
82MCSDHCustomer Stock: History8LFGJAFiscal Year of Current Periodnvarchar40
83MCSSTotal Customer Stock7LFGJAFiscal Year of Current Periodnvarchar40
84MCSSHKundenbeistellbestand - Historie - Summe6LFGJAFiscal Year of Current Periodnvarchar40
85MSCDCustomer stock with vendor8LFGJAFiscal Year of Current Periodnvarchar40
86MSCDHCustomer stock with vendor - History8LFGJAFiscal Year of Current Periodnvarchar40
87MSCSCustomer stock with vendor - Total7LFGJAFiscal Year of Current Periodnvarchar40
88MSFDSales Order Stock with Vendor9LFGJAFiscal Year of Current Periodnvarchar40
89MSFDHSales Order Stock at Vendor: History9LFGJAFiscal Year of Current Periodnvarchar40
90MSFSSales Order Stock with Vendor - Total8LFGJAFiscal Year of Current Periodnvarchar40
91MSIDVendor Stock with Vendor8LFGJAFiscal Year of Current Periodnvarchar40
92MSIDHVendor Stock with Vendor - History8LFGJAFiscal Year of Current Periodnvarchar40
93MSISVendor Stock with Vendor - Total7LFGJAFiscal Year of Current Periodnvarchar40
94MSRDProject Stock with Vendor8LFGJAFiscal Year of Current Periodnvarchar40
95MSRDHProject Stock with Vendor - History8LFGJAFiscal Year of Current Periodnvarchar40
96MSRSProject Stock with Vendor - Total7LFGJAFiscal Year of Current Periodnvarchar40