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

26 columns | Print definition?ERP 6.0  | STOCK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ATL/SMR1Inventory value in "hard" currency7STOCKTotal Valuated Stockdecimal133
2ZCATT_VMI_STKSLSInput Data for CATT PC_TPVS_TA_DEMAND17STOCKMaterial Numbernvarchar180
TOPAddress ManagementBusiness Address
3SADRAddress Management: Company Data17STOCKFloornvarchar60
TOPBank Customer Accounts
4BKKPOGISPEDI Payments: Reporting Data to Clearing, Segm. E1EDLA132STOCKFloornvarchar60
TOPCommand and Support Relationships
5/ISDFPS/FRC_IDXIndex for Changes to Force Assignments10STOCKOwn Provisionsnvarchar10
TOPConsumption-Based Planning See Also PP-MRP
6WRPLReplenishment: quantities per customer/material4STOCK- obsolete -decimal133
7WRPTReplenishment: movement data4STOCKStock level of recipientdecimal133
TOPCross-Application Components
8TSERIALSerial Number Profile7STOCKSerial Number Requirementnvarchar10
TOPData Collection
9CF720Top EIS Aspect40STOCKstocksdecimal152
TOPDistribution Requirements Planning
10S075DRP node information18STOCKOpening Stock Levelfloat1516
TOPForce Element
11/ISDFPS/FORCEPMaterial Packages6STOCKOwn Provisionsnvarchar10
12/ISDFPS/FORVPAAttributes of the Force Element - PPA Relationships15STOCKOwn Provisionsnvarchar10
TOPLocalization
13J_1BNFDOCNota Fiscal Header94STOCKFloornvarchar60
14J_1BNFNADNota Fiscal partners34STOCKFloornvarchar60
15J_3RFANKAFI-AA class settings for CIS8STOCKWarehousenvarchar10
TOPMaster Data
16JGTSADRIS-M: Extended Address Management36STOCKFloornvarchar60
17JSTALIASIS-M: Alias Table for Streets22STOCKFloornvarchar60
TOPMaterials Management
18/ISDFPS/FRC_IDX1Index for Changes to Force Assignments11STOCKOwn Provisionsnvarchar10
TOPPrice Planning Workbench
19WRF_PPW_PPDSTOCKPPD Stock Set4STOCKCurrent Stockdecimal173
20WRF_PPW_WORKLERRPPW Worklist Error Table19STOCKCurrent Stockdecimal173
21WRF_PPW_WORKLISTPPW Worklist20STOCKCurrent Stockdecimal173
TOPPurchasing
22WDFR_DISPPerishables Planning Header82STOCKExclude stock from checknvarchar10
23WDFR_POSPerishables Planninng Item260STOCKExclude stock from checknvarchar10
TOPReal Estate Management
24VIMI01Rental unit - Master data16STOCKDummy (previously storey, replaced by VVSSTOCKW)nvarchar20
25VIOB18Comparative apartments for rent adjustment, external accomm.6STOCKDummy (previously storey, replaced by VVSSTOCKW)nvarchar20
TOPRecycling Administration Core Functions
26J_7LSADRAddress Management: Company Data17STOCKFloornvarchar60