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

52 columns | Print definition?ERP 6.0  | PREIS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/TT_DATATest Data for SRM Test Tool23PREISNet Pricedecimal132
2NBMI_SRV_UPLOADKeep the upload status5PREISIS-H: Indiv. Price of Service Different from Service Masterdecimal112
TOPBasic Functions
3FDS1Cash Management & Forecast: Line Items of SD Documents29PREISUnit price in foreign currency per unit quantitydecimal152
TOPBills of Material
4STPOBOM item48PREISPricedecimal112
TOPContract Billing
5DBERCHVConsumption History10PREISPricenvarchar100
6DBERCHZIndividual Line Items40PREISPricenvarchar100
7DBERCHZ3Individual line items (amount and price data)10PREISPricenvarchar100
8DBERCHZ7Document line items (amount/price data, unimportant rows)10PREISPricenvarchar100
9EPPM_QS08Changes to Meter Rate Data18PREISPricenvarchar100
10EPREIMstr Pricing Table for All Prices2PREISPricenvarchar100
11EPREIHHistory Table for All Prices3PREISPricenvarchar100
12EPREIIHistory Table for All Index Prices2PREISPricenvarchar100
13EPREITMstr Pricing Table for All Prices (Texts)3PREISPricenvarchar100
14ERCHZ_SHORTBilling Document Individual Lines Extract59PREISPricenvarchar100
TOPCross-Application Components
15PLLPOTask list - operation/activity102PREISNet Price in Purchasing Info Recorddecimal112
TOPData Collection
16S520Test22PREISPrice in Purchase Requisitiondecimal112
TOPData Staging
17RSSMSHAREACTActions5PREISDecimal Fielddecimal172
TOPDefense Forces and Public Security
18/ISDFPS/ZEBANCopy of EBAN33PREISPrice in Purchase Requisitiondecimal112
TOPFunds Management
19KBLPDocument Item: Manual Document Entry16PREISPricedecimal152
TOPInformation System
20MCSFISR/2 SFIS Data: Old140PREISTotal Price in Local Currencydecimal152
TOPInventory Management
21SLGHElements of Stock Population14PREISPricedecimal112
TOPInvoicing
22DBERDZDB Table: Individ. Lines - Print Document66PREISPricenvarchar100
TOPMaintenance History
23HIVGPM order history - operations38PREISPricedecimal112
TOPMaster Data
24EKONHMax. Prices/Quantities8PREISPrice Limit for Franchise Contractnvarchar100
TOPMaster Data Distribution
25/ISDFPS/TL1Task List - Operation/Activity102PREISNet Price in Purchasing Info Recorddecimal112
TOPMaterials Management
26/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions38PREISPrice in Purchase Requisitiondecimal112
27/SAPNEA/ROWAChargeable component consumptions35PREISNet Price in Purchasing Info Recorddecimal112
28ROWAIndex table : Chargeable component consumptions35PREISNet Price in Purchasing Info Recorddecimal112
TOPOverhead Cost Orders
29TKB1ASettlement Profile3PREISIdentifier for "cost component structure"nvarchar10
TOPPatient Accounting
30NLEVIS-H: Preliminary entered services47PREISIS-H: Indiv. Price of Service Different from Service Masterdecimal112
31NMATOIS-H: Material requisition by nurse station12PREISIS-H MM: Price of Materialdecimal112
32NMATPIS-H: Material planned for case15PREISIS-H MM: Price of Materialdecimal112
33NMATVIS-H: Material Entered for Case16PREISIS-H MM: Price of Materialdecimal112
34NMCOIS-H MM: CO Transfer Information8PREISIS-H MM: Price of Materialdecimal112
TOPPatient Management
35NLEIIS-H: Services Performed15PREISIS-H: Indiv. Price of Service Different from Service Masterdecimal112
TOPPeriodical Sales and Distribution
36JRTROUTEIS-M/SD: Truck Route Master Data47PREISTruck route price (for statistical purposes)decimal132
37JRTTROUTEIS-M/SD: Daily Truck Routes73PREISTruck route price (for statistical purposes)decimal132
TOPProduct Cost Planning
38CKBSBase Planning Object - Unit Costing23PREISPrice per Unit of Measure Calculated in Cost Estimatedecimal152
39CKTC_CBEWCosting Master Data - Attributes9PREISPricedecimal152
TOPProduction Orders
40AFVCOperation within an order55PREISPricedecimal112
TOPPurchasing
41EBANPurchase Requisition33PREISPrice in Purchase Requisitiondecimal112
42EIPAOrder Price History: Info Record9PREISNet Price in Purchasing Document (in Document Currency)decimal112
43MEREQXPurchase Requisition Change Parameter33PREISUpdated information in related user data fieldnvarchar10
TOPRouting
44PLPOTask list - operation/activity102PREISNet Price in Purchasing Info Recorddecimal112
TOPSAP Healthcare - Industry-Specific Components for Hospitals
45/ISHFR/NTPKFR_AKIS-H FR: Asgt Serv. Master France => Activity + Phase9PREISIS-H: Indiv. Price of Service Different from Service Masterdecimal112
46NNLRAIS-H NL: Auf Leistungen angewendete Regeln5PREISIS-H: Indiv. prijs van verrichting afwijkend van ver.stamdecimal112
47NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)63PREISIS-H: prezzo (per utà misura)decimal112
48TNA21RIS-H: Flat rate rules (AT)8PREISIS-H: Amountdecimal112
49TNA21SIS-H: Scaled flate rates (VERA)10PREISIS-H: Amountdecimal112
TOPSimulation
50VSAFVC_CNVersion: Operation in order56PREISPricedecimal112
51VSEBAN_CNVersion: Purchase requisition34PREISPrice in Purchase Requisitiondecimal112
TOPWaste Management
52EEWA_BULK_DATABulk refuse order data13PREISStandard pricedecimal112