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

38 columns | Print definition?ERP 6.0  | QUANTITY_UNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010MIItems for Class SD01 - Raw Data24QUANTITY_UNITQuantity Unitnvarchar30
2/1RA/0SD012MIItems for Class SD01 - Processable24QUANTITY_UNITQuantity Unitnvarchar30
3/1RA/0SD014MIItems for Class SD01 - Processed24QUANTITY_UNITQuantity Unitnvarchar30
4/1RA/0SD020MIItems for Class SD02 - Raw Data16QUANTITY_UNITQuantity Unitnvarchar30
5/1RA/0SD022MIItems for Class SD02 - Processable16QUANTITY_UNITQuantity Unitnvarchar30
6/1RA/0SD024MIItems for Class SD02 - Processed16QUANTITY_UNITQuantity Unitnvarchar30
7/1RA/0SD030MIItems for Class SD03 - Raw Data22QUANTITY_UNITQuantity Unitnvarchar30
8/1RA/0SD032MIItems for Class SD03 - Processable22QUANTITY_UNITQuantity Unitnvarchar30
9/1RA/0SD034MIItems for Class SD03 - Processed22QUANTITY_UNITQuantity Unitnvarchar30
10FARR_D_DEFITEMDeferral item table12QUANTITY_UNITQuantity Unitnvarchar30
11FARR_D_LEGACYLegacy data for initial load of revenue accounting items8QUANTITY_UNITQuantity Unitnvarchar30
12FARR_D_LEGACYSFlegacy data for scheduled fulfillments (time based)10QUANTITY_UNITQuantity Unitnvarchar30
13FARR_D_POBPerformance Obligation16QUANTITY_UNITQuantity Unitnvarchar30
14TLRT_TARO_CNTTrade Repository: Content83QUANTITY_UNITCommodity Data: Quantity Unitdecimal105
15ZCM_LINKAGEStores the Linkages between Financial Transactions5QUANTITY_UNITUnit of Measure for the Commoditynvarchar30
TOPElectronic Data Interchange
16PRICAT_K004PRICAT:Cat. item units of measure, dimensions, weights,EANs11QUANTITY_UNITPRICAT: No. of base units containednvarchar150
17PRICAT_K004_PROIndication of Data to be Adopted from PRICAT_K0046QUANTITY_UNITIndicator for copying catalog datanvarchar10
TOPInvoicing in Contract Accounts Receivable and Payable
18TFK2671QInvoicing Document Check: Limit Values for Quantities4QUANTITY_UNITBase Unit of Measurenvarchar30
19TFK2672QSource Document Check: Limit Values for Quantities5QUANTITY_UNITBase Unit of Measurenvarchar30
TOPNetWeaver Demonstration
20SDEMO_PD_STOCKStock of products4QUANTITY_UNITQuantity Unit Codenvarchar30
21SDEMO_PO_SLPurchase Order Item Schedule Line6QUANTITY_UNITQuantity Unit Codenvarchar30
22SDEMO_SO_SLSAP NetWeaver Demo Model - Sales Order Item Schedule Line6QUANTITY_UNITQuantity Unit Codenvarchar30
23SNWD_GI_IEPM: Goods Issue Item Table6QUANTITY_UNITEPM: Quantity Unitnvarchar30
24SNWD_GR_IEPM: Goods Received Item Table6QUANTITY_UNITEPM: Quantity Unitnvarchar30
25SNWD_PO_INV_ITEMEPM: Purchase Order Invoice Items Table6QUANTITY_UNITEPM: Quantity Unitnvarchar30
26SNWD_PO_SLEPM: Purchase Order Schedule Line Table5QUANTITY_UNITEPM: Quantity Unitnvarchar30
27SNWD_PR_I_TPLEPM: Purchase Requisition Item Database Table Template8QUANTITY_UNITEPM: Quantity Unitnvarchar30
28SNWD_SO_INV_ITEMEPM: Sales Order Invoice Items Table6QUANTITY_UNITEPM: Quantity Unitnvarchar30
29SNWD_SO_SLEPM: Sales Order Schedule Line Table5QUANTITY_UNITEPM: Quantity Unitnvarchar30
30SNWD_STOCKEPM: Stock Table6QUANTITY_UNITEPM: Quantity Unitnvarchar30
TOPProduct and Process Modeling
31RLMFWOLCMPRelease Order - Items - Component Variants14QUANTITY_UNITUnit of Measurenvarchar30
TOPSales and Distribution
32IPM_RAWRECDue Pre-List for Product Sales18QUANTITY_UNITThe unit for the cumulation quantitynvarchar30
TOPSAP Media
33JPTRAWRECDue Pre-List for Product Sales18QUANTITY_UNITUnit of Measure in Which Product is Soldnvarchar30
TOPTrading Contract
34WB2_D_STRINGLogistical string,circle and washout18QUANTITY_UNITOpen Quantity Unitnvarchar30
TOPTreasury
35VTIDERIMaster Data Listed Options and Futures48QUANTITY_UNITUnit of measurenvarchar30
TOPWaste Management
36EWA_ORDER_WEIGHWeighing Data for Waste Disposal Order39QUANTITY_UNITUnit/Type For Quantity in Weighing Transactionnvarchar30
37EWA_WA_WEIGHOFFLOffline Weighing61QUANTITY_UNITUnit/Type For Quantity in Weighing Transactionnvarchar30
38EWA_WA_WEIGHPROCWeighing Transaction40QUANTITY_UNITUnit/Type For Quantity in Weighing Transactionnvarchar30