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

42 columns | Print definition?ERP 6.0  | ERFME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BSEGAccounting Document Segment174ERFMEUnit of Entrynvarchar30
2BSSEGAccounting Document Segment163ERFMEUnit of Entrynvarchar30
3FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items22ERFMEUnit of Entrynvarchar30
4FUDT_VDOCBSEGVerification Document Item with Additional Info163ERFMEUnit of Entrynvarchar30
5FUDT_VDOCBSEGEVVerification Document Item in the Entry View163ERFMEUnit of Entrynvarchar30
6FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)163ERFMEUnit of Entrynvarchar30
TOPAccounting Interface
7GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)285ERFMEUnit of Entrynvarchar30
8GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)285ERFMEUnit of Entrynvarchar30
TOPBW Service API
9ROVERCUBE1Transaction Data for Verification Scenarios14ERFMEUnit of Entry for Verification Scenariosnvarchar30
10ROVERCUBE3Transaction Data for Verification Scenarios (from 4.0B)14ERFMEUnit of Entry for Verification Scenariosnvarchar30
TOPConfirmations
11AFFWGoods Movements with Errors from Confirmations21ERFMEUnit of Entrynvarchar30
12AFFWPROLog of deleted AFFW entries13ERFMEUnit of Entrynvarchar30
TOPDemand Management
13PBEDIndependent Requirements Data16ERFMEUnit of Entrynvarchar30
TOPFinancial Accounting
14ACCTITCompressed Data from FI/CO Document139ERFMEUnit of Entrynvarchar30
TOPFlow Manufacturing
15LDLBPLine balance items14ERFMEUnit of Entrynvarchar30
TOPHydrocarbon Product Management
16OIB09Log for missing MSEGO1 and MSEGO2 documents16ERFMEUnit of Entrynvarchar30
17OIB_MIGO_HQCIStore the QCI-GOITEM for MIGOs hold/restore feature19ERFMEUnit of Entrynvarchar30
TOPIndustry Solution Catch Weight Management
18/CWM/QM_COUNTCount Data Table for Insp. Lot-Related Phys. Inv. in CWM10ERFMEUnit of entry (physical inventory)nvarchar30
TOPInventory Management
19ISEGPhysical Inventory Document Items34ERFMEUnit of entry (physical inventory)nvarchar30
20MSEGDocument Segment: Material36ERFMEUnit of Entrynvarchar30
21MWXMSEGZMSEG: Interface for Posting of Value36ERFMEUnit of Entrynvarchar30
22MWZMSEGZMSEG:Interface for Posting of Value36ERFMEUnit of Entrynvarchar30
23RESBReservation/dependent requirements27ERFMEUnit of Entrynvarchar30
24T159ATest Data for Batch Input in Inventory Management15ERFMEUnit of Entrynvarchar30
25T159ITest Data for Batch Input in Inventory Management (Phys.Inv)19ERFMEUnit of Entrynvarchar30
TOPLocalization
26J_1IRAINDTLArticle Inward Note Detail12ERFMEUnit of Entrynvarchar30
TOPMaintenance Orders
27AUFMGoods movements for order23ERFMEUnit of Entrynvarchar30
TOPMaster Data
28MDSMSimulative dependent requirements31ERFMEUnit of Entrynvarchar30
29PLAFPlanned Order101ERFMEUnit of Entrynvarchar30
TOPMaterial Identification and Reconciliation
30BEREITMaterial identification: staging data15ERFMEUnit of Entrynvarchar30
TOPPegging, Grouping, and Distribution
31TBLPTransfer/Loan data log table9ERFMEUnit of Entrynvarchar30
32TBLP_PPayback data log table5ERFMEUnit of Entrynvarchar30
TOPProcess Management
33COMQTemporary Storage for Material Production Messages for QM6ERFMEUnit of Entrynvarchar30
TOPPurchasing
34EKBE_SCComponent Consumption History for Subcontracting15ERFMEUnit of Entrynvarchar30
TOPRemaining Beverage - Obsolete Objects
35/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1165ERFMEUnit of Entrynvarchar30
TOPRepetitive Manufacturing
36COMPMOVEGoods Movement of Components36ERFMEUnit of Entrynvarchar30
37RMIOInput Structure of Repetitive Manufacturing Confirmation18ERFMEUnit of measure for backflush quantity and for actual scrapnvarchar30
TOPSAP Retail Store
38WSTI_POS_EVENTPhysical Inventory in an Opened Store: POS Trans by Receipt19ERFMEUnit of Entrynvarchar30
TOPShipping
39LECOMPKomponenten für Lohnbearbeitungsanlieferungen10ERFMEUnit of Entrynvarchar30
TOPSimulation
40VSPLAF_CNVersion: Planned order102ERFMEUnit of Entrynvarchar30
41VSRESB_CNVersion: Reservation/Dependent requirements28ERFMEUnit of Entrynvarchar30
TOPTariffs, Duties and Permits
42OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature33ERFMEUnit of Entrynvarchar30