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

36 columns | Print definition?ERP 6.0  | BPRME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VIM_1ITEM_SDocument Item11BPRMEOrder Price Unit (Purchasing)nvarchar30
2/OPT/VIM_TITEMDocument Item11BPRMEOrder Price Unit (Purchasing)nvarchar30
3BSEGAccounting Document Segment176BPRMEOrder Price Unit (Purchasing)nvarchar30
4BSSEGAccounting Document Segment165BPRMEOrder Price Unit (Purchasing)nvarchar30
5FUDT_VDOCBSEGVerification Document Item with Additional Info165BPRMEOrder Price Unit (Purchasing)nvarchar30
6FUDT_VDOCBSEGEVVerification Document Item in the Entry View165BPRMEOrder Price Unit (Purchasing)nvarchar30
7FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)165BPRMEOrder Price Unit (Purchasing)nvarchar30
8MEV_D_AD_ITEM_MMPeriod-End Valuation: Accruals Document Item MM16BPRMEOrder Price Unit (Purchasing)nvarchar30
9MEV_D_WL_MMPeriod-end valuation: Worklist - Materials Management Data16BPRMEOrder Price Unit (Purchasing)nvarchar30
10YVIM_1ITEMDocument Item11BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPAccounting Interface
11GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)145BPRMEOrder Price Unit (Purchasing)nvarchar30
12GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)145BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPFinancial Accounting
13/OPT/VIM_1ITEMDocument Item11BPRMEOrder Price Unit (Purchasing)nvarchar30
14ACCTITCompressed Data from FI/CO Document41BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPFunctions for U.S. Federal Government
15FMFG_VEKPOJFMIP: Pending PO Line Item Changes Table9BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPFunds Management-Specific Postings
16FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years133BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPInventory Management
17MSEGDocument Segment: Material38BPRMEOrder Price Unit (Purchasing)nvarchar30
18MWXMSEGZMSEG: Interface for Posting of Value38BPRMEOrder Price Unit (Purchasing)nvarchar30
19MWZMSEGZMSEG:Interface for Posting of Value38BPRMEOrder Price Unit (Purchasing)nvarchar30
20T159ATest Data for Batch Input in Inventory Management17BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPInvoice Verification
21RBDRSEGBatch IV: Invoice Document Items7BPRMEOrder Price Unit (Purchasing)nvarchar30
22RBVDMATInvoice Verification - Aggregation Data, Material8BPRMEOrder Price Unit (Purchasing)nvarchar30
23RSEGDocument Item: Incoming Invoice20BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPLocalization
24J_1BNFEPARKLINNota fiscal electronica: Invoice create failed24BPRMEOrder Price Unit (Purchasing)nvarchar30
25J_1IRAINDTLArticle Inward Note Detail33BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPMaterials Management MM enhancements
26/SAPMP/MIGOBPMNGBAdI in MIGO: Cumulated Order Price Quantity6BPRMEQuantity in Purchase Order Price Unitnvarchar30
TOPPerishables Procurement
27FIP_D_ORDER_LINEOrder lines for FIP18BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPPurchasing
28EINEPurchasing Info Record: Purchasing Organization Data37BPRMEOrder Price Unit (Purchasing)nvarchar30
29EIPAOrder Price History: Info Record11BPRMEOrder Price Unit (Purchasing)nvarchar30
30EKPOPurchasing Document Item20BPRMEOrder Price Unit (Purchasing)nvarchar30
31WDFR_POSPerishables Planninng Item41BPRMEOrder Price Unit (Purchasing)nvarchar30
32WRF_POHF_POLOrder list18BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPRemaining Beverage - Obsolete Objects
33/BEV3/CH1030BSG1Document Segment CH Event Ledger Part1167BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPRepetitive Manufacturing
34COMPMOVEGoods Movement of Components40BPRMEQuantity in Purchase Order Price Unitnvarchar30
TOPTariffs, Duties and Permits
35OIH_MIGO_HTDPStore the TDP-GOITEM for MIGOs hold/restore feature35BPRMEOrder Price Unit (Purchasing)nvarchar30
TOPVendor Evaluation
36ABS_IV_KEYFI_ITMAbsolute Key Figures at Item Level18BPRMEOrder Price Unit (Purchasing)nvarchar30