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

42 columns | Print definition?ERP 6.0  | ERFMG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment173ERFMGQuantity in Unit of Entrydecimal133
2BSSEGAccounting Document Segment162ERFMGQuantity in Unit of Entrydecimal133
3FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items21ERFMGQuantity in Unit of Entrydecimal133
4FUDT_VDOCBSEGVerification Document Item with Additional Info162ERFMGQuantity in Unit of Entrydecimal133
5FUDT_VDOCBSEGEVVerification Document Item in the Entry View162ERFMGQuantity in Unit of Entrydecimal133
6FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)162ERFMGQuantity in Unit of Entrydecimal133
7ZSTOCKINPUTUtility table to assist with loading of Initial Stock (561)10ERFMGQuantity in Unit of Entrydecimal133
TOPAccounting Interface
8GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)284ERFMGQuantity in Unit of Entrydecimal133
9GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)284ERFMGQuantity in Unit of Entrydecimal133
TOPConfirmations
10AFFWGoods Movements with Errors from Confirmations20ERFMGQuantity in Unit of Entrydecimal133
11AFFWPROLog of deleted AFFW entries12ERFMGQuantity in Unit of Entrydecimal133
TOPDemand Management
12PBEDIndependent Requirements Data17ERFMGQuantity in Unit of Entrydecimal133
TOPFinancial Accounting
13ACCTITCompressed Data from FI/CO Document138ERFMGQuantity in Unit of Entrydecimal133
TOPHydrocarbon Product Management
14OIB09Log for missing MSEGO1 and MSEGO2 documents17ERFMGQuantity in Unit of Entrydecimal133
15OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature18ERFMGQuantity in Unit of Entrydecimal133
TOPIndustry Solution Catch Weight Management
16/CWM/QM_COUNTCount Data Table for Insp. Lot-Related Phys. Inv. in CWM9ERFMGQuantity in unit of entry (physical inventory)decimal133
TOPInventory Management
17ISEGPhysical Inventory Document Items33ERFMGQuantity in unit of entry (physical inventory)decimal133
18MSEGDocument Segment: Material35ERFMGQuantity in Unit of Entrydecimal133
19MWXMSEGZMSEG: Interface for Posting of Value35ERFMGQuantity in Unit of Entrydecimal133
20MWZMSEGZMSEG:Interface for Posting of Value35ERFMGQuantity in Unit of Entrydecimal133
21RESBReservation/dependent requirements26ERFMGQuantity in Unit of Entrydecimal133
22T159ATest Data for Batch Input in Inventory Management14ERFMGQuantity (Batch Input Field)nvarchar170
23T159ITest Data for Batch Input in Inventory Management (Phys.Inv)18ERFMGQuantity (Batch Input Field)nvarchar170
24USEGRetail Revaluation Document: Revaluation Segment29ERFMGQuantity in unit of entry for revaluation at retaildecimal133
TOPLocalization
25J_1IRAINDTLArticle Inward Note Detail11ERFMGQuantity in Unit of Entrydecimal133
TOPMaintenance Orders
26AUFMGoods movements for order22ERFMGQuantity in Unit of Entrydecimal133
TOPMaster Data
27MDSMSimulative dependent requirements30ERFMGQuantity in Unit of Entrydecimal133
28PLAFPlanned Order100ERFMGQuantity in Unit of Entrydecimal133
TOPMaterial Identification and Reconciliation
29BEREITMaterial identification: staging data14ERFMGQuantity in Unit of Entrydecimal133
TOPPegging, Grouping, and Distribution
30TBLPTransfer/Loan data log table8ERFMGQuantity in Unit of Entrydecimal133
31TBLP_PPayback data log table4ERFMGQuantity in Unit of Entrydecimal133
32TBLP_SORTTBLP Sort criteris configuration table6ERFMGSingle-Character Indicatornvarchar10
TOPProcess Management
33COMQTemporary Storage for Material Production Messages for QM5ERFMGQuantity in Unit of Entrydecimal133
TOPPurchasing
34EKBE_SCComponent Consumption History for Subcontracting17ERFMGQuantity in Unit of Entrydecimal133
TOPRemaining Beverage - Obsolete Objects
35/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1164ERFMGQuantity in Unit of Entrydecimal133
TOPRepetitive Manufacturing
36COMPMOVEGoods Movement of Components35ERFMGQuantity in Unit of Entrydecimal133
37RMIOInput Structure of Repetitive Manufacturing Confirmation17ERFMGBackflush quantity in repetitive manufacturingdecimal133
TOPSAP Retail Store
38WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt18ERFMGQuantity in Unit of Entrydecimal133
TOPShipping
39LECOMPKomponenten für Lohnbearbeitungsanlieferungen11ERFMGQuantity in Unit of Entrydecimal133
TOPSimulation
40VSPLAF_CNVersion: Planned order101ERFMGQuantity in Unit of Entrydecimal133
41VSRESB_CNVersion: Reservation/Dependent requirements27ERFMGQuantity in Unit of Entrydecimal133
TOPTariffs, Duties and Permits
42OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature32ERFMGQuantity in Unit of Entrydecimal133