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

47 columns | Print definition?ERP 6.0  | INFNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/QMPPAPT001QM Sampling Header Table20INFNRNumber of Purchasing Info Recordnvarchar100
2A015Not Used in Standard6INFNRNumber of Purchasing Info Recordnvarchar100
3A025Info Record for Non-Stock Item (Plant-Specific)7INFNRNumber of Purchasing Info Recordnvarchar100
4A028Info Record for Non-Stock Item7INFNRNumber of Purchasing Info Recordnvarchar100
5A4AAPurchOrg/Vendor/Plant/Info Record/Material/Segment7INFNRNumber of Purchasing Info Recordnvarchar100
6EINSGTPurchasing Info Record: Segmentation Specific Data2INFNRNumber of Purchasing Info Recordnvarchar100
TOPAgency Business Global Trade
7WBRPAgency business: Item62INFNRNumber of Purchasing Info Recordnvarchar100
TOPCross-Application Components
8PLLPOTask list - operation/activity106INFNRNumber of Purchasing Info Recordnvarchar100
TOPData Collection
9S012Purchasing14INFNRNumber of Purchasing Info Recordnvarchar100
10S012BIW1S012BIW1 * Purchasing14INFNRNumber of Purchasing Info Recordnvarchar100
11S012BIW2S012BIW2 * Purchasing14INFNRNumber of Purchasing Info Recordnvarchar100
12S012ES012 - Structural Information9INFNRNumber of Purchasing Info Recordnvarchar100
13S013PURCHIS: Statistics for Vendor Evaluation13INFNRNumber of Purchasing Info Recordnvarchar100
14S013BIW1PURCHIS: Statistics for Vendor Evaluation13INFNRNumber of Purchasing Info Recordnvarchar100
15S013BIW2S013BIW2 * PURCHIS: Statistics for vendor evaluation8INFNRNumber of Purchasing Info Recordnvarchar100
16S013ES013 - Structural Information8INFNRNumber of Purchasing Info Recordnvarchar100
TOPDefense Forces and Public Security
17/ISDFPS/ZEBANCopy of EBAN50INFNRNumber of Purchasing Info Recordnvarchar100
TOPInventory Management
18MWZDM07M2ZDM07M2124INFNRNumber of Purchasing Info Recordnvarchar100
19RESBReservation/dependent requirements161INFNRNumber of Purchasing Info Recordnvarchar100
TOPMaintenance History
20HIVGPM order history - operations47INFNRNumber of Purchasing Info Recordnvarchar100
TOPMaintenance Notifications
21QMFEQuality notification - items51INFNRNumber of Purchasing Info Recordnvarchar100
TOPMarketing, Accounting and Pricing
22OIC_FORM_ATTRIBAttributes of Business Context for F&A Formula28INFNRNumber of Purchasing Info Recordnvarchar100
TOPMaster Data Distribution
23/ISDFPS/TL1Task List - Operation/Activity106INFNRNumber of Purchasing Info Recordnvarchar100
TOPMaterial Master
24WRF_DISCONT_ERRError Log and Valuation Levels - Seas. Proc. Discontinuation12INFNRNumber of Purchasing Info Recordnvarchar100
25WRF_DISCONT_POSWorklist Items: Discontinuation for Seasonal Procurement9INFNRNumber of Purchasing Info Recordnvarchar100
TOPMaterials Management
26/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions55INFNRNumber of Purchasing Info Recordnvarchar100
TOPOverhead Cost Controlling
27CSKRResource master record13INFNRNumber of Purchasing Info Recordnvarchar100
TOPProduct Cost Planning
28CKISItems Unit Costing/Itemization Product Costing68INFNRNumber of Purchasing Info Recordnvarchar100
TOPProduction Orders
29AFVCOperation within an order59INFNRNumber of Purchasing Info Recordnvarchar100
TOPPurchase Orders
30WBO2Log item file for simulative list for load building11INFNRNumber of Purchasing Info Recordnvarchar100
TOPPurchasing
31EBANPurchase Requisition50INFNRNumber of Purchasing Info Recordnvarchar100
32EINAPurchasing Info Record: General Data2INFNRNumber of Purchasing Info Recordnvarchar100
33EINEPurchasing Info Record: Purchasing Organization Data2INFNRNumber of Purchasing Info Recordnvarchar100
34EIPAOrder Price History: Info Record2INFNRNumber of Purchasing Info Recordnvarchar100
35EKPOPurchasing Document Item15INFNRNumber of Purchasing Info Recordnvarchar100
36INFREC_ARCHIVEArchiving Index for info records2INFNRNumber of Purchasing Info Recordnvarchar100
37MEREQXPurchase Requisition Change Parameter50INFNRUpdated information in related user data fieldnvarchar10
38WDFR_POSPerishables Planninng Item61INFNRNumber of Purchasing Info Recordnvarchar100
TOPRouting
39PLPOTask list - operation/activity106INFNRNumber of Purchasing Info Recordnvarchar100
TOPSCM Basis
40CIF_IMSRCIIMod Reference Table for Purchasing Info Records2INFNRNumber of Purchasing Info Recordnvarchar100
41CPVINFRPurchasing info record and production version assignment2INFNRNumber of Purchasing Info Recordnvarchar100
42CPV_MPVUsed production version for Multiple PV2INFNRNumber of Purchasing Info Recordnvarchar100
TOPSelf-Service Procurement
43/SRMERP/D_SC_ITMShopping Cart Item59INFNRNumber of Purchasing Info Recordnvarchar100
TOPSimulation
44VSAFVC_CNVersion: Operation in order60INFNRNumber of Purchasing Info Recordnvarchar100
45VSEBAN_CNVersion: Purchase requisition51INFNRNumber of Purchasing Info Recordnvarchar100
46VSRESB_CNVersion: Reservation/Dependent requirements162INFNRNumber of Purchasing Info Recordnvarchar100
TOPVendor Evaluation
47ELBMVendor Evaluation: Material-Related Item3INFNRNumber of Purchasing Info Recordnvarchar100