SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8BSEG345Accounting Document Segment
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

1OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction - the webs number one PHP Function reference tool

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
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
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