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

42 columns | Print definition?ERP 6.0  | SETCLASS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10100_SETCLAFI Set Data Relation between SETCLASS and appl. Table1SETCLASSSet classnvarchar40
2CNV_10100_SETCLS(Obsolete for Package 10100)1SETCLASSSet classnvarchar40
3CNV_10100_SETCLTFI Set Data Relation between SETCLASS and appl. Table1SETCLASSSet classnvarchar40
4CNV_10100_SETCONFI Set Data Relation between SETCLASS and appl. package3SETCLASSSet classnvarchar40
5CNV_10100_SETLEAFI Set values for interval break down, according SETLEAF3SETCLASSSet classnvarchar40
6CNV_20100SETLEAFBackup copy - SETLEAF (0102,0109)3SETCLASSnvarchar40
7CNV_20305_SETNODLower-level sets in sets3SETCLASSSet classnvarchar40
8CNV_20375_SETLFBackup for SETLEAF before modification3SETCLASSSet classnvarchar40
9CNV_20400_SETNLower-level sets in sets3SETCLASSSet classnvarchar40
TOPBasic Data
10VIEXSETSETs2SETCLASSSet classnvarchar40
TOPCapacity and Resource Planning
11/MRSS/SETHEADERTShort description of Sets2SETCLASSSet classnvarchar40
12/MRSS/SETNODELower-level sets in sets2SETCLASSSet classnvarchar40
TOPConsolidation
13TFMIG13Migration: Control Sets2SETCLASSSet classnvarchar40
TOPControlling
14FCOMT_INASETInactive Groups2SETCLASSSet classnvarchar40
15MDSEC_TREE_IMPLImplementation Settings for Master Data Tree1SETCLASSSet classnvarchar40
TOPFunds Management
16FMDERIVE_SETSSets for different Strategies8SETCLASSSet classnvarchar40
TOPGeneral Ledger Accounting
17FAGL_VAL_GRPSets for the Validation of Account Assignment Combinations8SETCLASSSet classnvarchar40
TOPLocalization
18J_3R_PBU_SETCLSSet Classes Assignment to Source Tables Fields3SETCLASSSet classnvarchar40
TOPProduction and Revenue Accounting
19OIU_CM_HIER_EXPPRA Entity group expand table2SETCLASSSet classnvarchar40
TOPReal Estate Management
20TIV_OB_WORKLISTTable for Saving the List with Work Lists4SETCLASSSet classnvarchar40
TOPSets
21HDB_SETLEAF1Leaf view for SLT hierarchy replication (primary)2SETCLASSSet classnvarchar40
22HDB_SETLEAF2Leaf view for SLT hierarchy replication (secondary)2SETCLASSSet classnvarchar40
23HDB_SETNODENode view for SLT hierarchy replication2SETCLASSSet classnvarchar40
24RWSHEADERReport Writer Data for Set Header2SETCLASSSet classnvarchar40
25RWSLINEReport Writer Data for the Set Line2SETCLASSSet classnvarchar40
26SETCLSSet Classes1SETCLASSSet classnvarchar40
27SETCLSTSet Class Descriptions2SETCLASSSet classnvarchar40
28SETCLS_CDChange document indicator per set class2SETCLASSSet classnvarchar40
29SETHANAHIER0101Hierarchy table for Cost Center Groups2SETCLASSSet classnvarchar40
30SETHANAHIER0102Hierarchy table for Cost Element Groups2SETCLASSSet classnvarchar40
31SETHANAHIER0103Hierarchy table for Order Groups2SETCLASSSet classnvarchar40
32SETHANAHIER0106Hierarchy table for Profit Center Groups2SETCLASSSet classnvarchar40
33SETHANAHIER0109Hierarchy table for Account Groups2SETCLASSSet classnvarchar40
34SETHANA_HIERStatus of set hierarchies in HANA2SETCLASSSet classnvarchar40
35SETHANA_STATUSStatus of set hierarchies in HANA2SETCLASSSet classnvarchar40
36SETHEADERSet Header and Directory2SETCLASSSet classnvarchar40
37SETHEADERTShort Description of Sets2SETCLASSSet classnvarchar40
38SETHEADERTRANSChanges Made to Sets by Transports2SETCLASSSet classnvarchar40
39SETLEAFValues in Sets2SETCLASSSet classnvarchar40
40SETLINETShort Description of Set Line2SETCLASSSet classnvarchar40
41SETNODELower-level sets in sets2SETCLASSSet classnvarchar40
42T802GSets: Variables20SETCLASSSet classnvarchar40