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

57 columns | Print definition?ERP 6.0  | SETNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/RODW_SRolldown Rules to Copy Sets3SETNAMEName of the Setnvarchar300
2CNV_10100_SETLEAFI Set values for interval break down, according SETLEAF5SETNAMESetname, Set ID like SETNAMENEWnvarchar240
3CNV_20100SETLEAFBackup copy - SETLEAF (0102,0109)5SETNAMEnvarchar240
4CNV_20305_SETNODLower-level sets in sets5SETNAMESet IDnvarchar240
5CNV_20375_SETLFBackup for SETLEAF before modification5SETNAMESet namenvarchar240
6CNV_20400_SETNLower-level sets in sets5SETNAMESetname, Set ID like SETNAMENEWnvarchar240
TOPActivity Types
7TSC0CTable of selection criteria for assignments7SETNAMEGroup Namenvarchar150
8TSC0ITable of selection criteria for rules6SETNAMEGroup Namenvarchar150
TOPBackground Processing
9BTCOMSETDefinition of operation type sets and exception op. modes1SETNAMEOperation mode set namenvarchar160
TOPBasic Data
10VIEXSETSETs3SETNAMESet Namenvarchar240
TOPCapacity and Resource Planning
11/MRSS/SETHEADERTShort description of Sets4SETNAMESet Namenvarchar240
12/MRSS/SETNODELower-level sets in sets4SETNAMESet Namenvarchar240
TOPControlling
13FCOMT_INASETInactive Groups4SETNAMESet Namenvarchar240
TOPCost Center Accounting
14T811KAllocations: Key Fields9SETNAMESet IDnvarchar120
15T811XAllocations: Fixed Selection Values7SETNAMESet IDnvarchar120
TOPInformation System
16T803GReport Writer: Key Figure Blocks (Cells in Formulas)7SETNAMEIdentification of a setnvarchar340
TOPMonitoring
17ALCLASTOOLAlert: Assignment of tools to object class3SETNAMEAlert: Name of monitoring properties variantnvarchar200
18ALCUSTSETAlert: Monitoring Properties Variants1SETNAMEAlert: Name of monitoring properties variantnvarchar200
19ALGRPCUSGEAlert: General Customizing for MTE classes2SETNAMEAlert: Name of monitoring properties variantnvarchar200
20ALGRPCUSMCAlert: Message container Customizing for Cust. groups2SETNAMEAlert: Name of monitoring properties variantnvarchar200
21ALGRPCUSMGAlert: Group Customizing data single message class2SETNAMEAlert: Name of monitoring properties variantnvarchar200
22ALGRPCUSPFAlert: Group Customizing data performance class2SETNAMEAlert: Name of monitoring properties variantnvarchar200
23ALGRPMCFILAlert: Message container filter for Cust. groups2SETNAMEAlert: Name of monitoring properties variantnvarchar200
24ALMTCUSGENAlert: MT-specific Customizing Class-independent6SETNAMEAlert: Name of monitoring properties variantnvarchar200
25ALMTCUSMSCAlert: MTE-specific Customizing: message container6SETNAMEAlert: Name of monitoring properties variantnvarchar200
26ALMTCUSPERAlert: MT-specific Customizing Performance-Class6SETNAMEAlert: Name of monitoring properties variantnvarchar200
27ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class6SETNAMEAlert: Name of monitoring properties variantnvarchar200
28ALMTMSCFILAlert: MTE-Specific Message Container Filter6SETNAMEAlert: Name of monitoring properties variantnvarchar200
29ALTIDTOOLAlert: Assignment of tools to Tid7SETNAMEAlert: Name of monitoring properties variantnvarchar200
30CSMTOOLASGCCMS Monitoring: Assignment of Methods Started Centrally4SETNAMEAlert: Name of monitoring properties variantnvarchar200
TOPOverhead Cost Controlling
31T823KRevaluation key fields8SETNAMESet IDnvarchar120
TOPPersonnel Management
32/BKC/S21_ANON_DC&T! - Anonymization table - data areas2SETNAMEC&T! - Name of anonymization setnvarchar300
33/BKC/S21_ANON_RC&T! - Anonymization table - random values2SETNAMEC&T! - Name of anonymization setnvarchar300
34/BKC/S21_ANON_TC&T! - Anonymization table - comments2SETNAMEC&T! - Name of anonymization setnvarchar300
35/BKC/S21_EXT_FC&T! - Definition of external anonymization routines2SETNAMEC&T! - Name of anonymization setnvarchar300
TOPProduction and Revenue Accounting
36OIU_CM_HIER_EXPPRA Entity group expand table4SETNAMESet Namenvarchar240
TOPProfitability Analysis
37TKECRMCCRM: Transfer of CRM Cost Element Group4SETNAMEGroup Namenvarchar150
TOPReal Estate Management
38TIV_OB_WORKLISTTable for Saving the List with Work Lists6SETNAMEName of a set of Real Estate objectsnvarchar150
39VIAK05Allocation of rental units to calculation unit8SETNAMESet ID for rental unit allocation (incid.expns.acct sttlmnt)nvarchar120
TOPRevenues and Earnings
40AD01C_MATADIP profile: Material determination criteria10SETNAMESet Namenvarchar240
41AD01C_SELADIP profile: Selection criteria10SETNAMESet Namenvarchar240
TOPSets
42HDB_SETLEAF1Leaf view for SLT hierarchy replication (primary)4SETNAMESet Namenvarchar240
43HDB_SETLEAF2Leaf view for SLT hierarchy replication (secondary)4SETNAMESet Namenvarchar240
44HDB_SETNODENode view for SLT hierarchy replication4SETNAMESet Namenvarchar240
45RWSHEADERReport Writer Data for Set Header4SETNAMESet Namenvarchar240
46RWSLINEReport Writer Data for the Set Line4SETNAMESet Namenvarchar240
47SETHANAHIER0101Hierarchy table for Cost Center Groups9SETNAMESet Namenvarchar240
48SETHANAHIER0102Hierarchy table for Cost Element Groups9SETNAMESet Namenvarchar240
49SETHANAHIER0103Hierarchy table for Order Groups9SETNAMESet Namenvarchar240
50SETHANAHIER0106Hierarchy table for Profit Center Groups9SETNAMESet Namenvarchar240
51SETHANAHIER0109Hierarchy table for Account Groups9SETNAMESet Namenvarchar240
52SETHEADERSet Header and Directory4SETNAMESet Namenvarchar240
53SETHEADERTShort Description of Sets4SETNAMESet Namenvarchar240
54SETHEADERTRANSChanges Made to Sets by Transports4SETNAMESet Namenvarchar240
55SETLEAFValues in Sets4SETNAMESet Namenvarchar240
56SETLINETShort Description of Set Line4SETNAMESet Namenvarchar240
57SETNODELower-level sets in sets4SETNAMESet Namenvarchar240