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

67 columns | Print definition?ERP 6.0  | SETID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVMBTSELGRPVALMBT PCL Selection group values5SETIDID of One Set of Member Valuesnvarchar50
2FPM_ADAPT_SETAdaptation Sets1SETIDAdaptation Value Setnvarchar320
3T7CNRM_DECFCTDefine Determining Factors3SETIDDetermining Factor Item Setnvarchar80
4T7CNRM_DECSETDecision Factor SET - OBSOLETE2SETIDDetermining Factor Item Setnvarchar80
TOPBusiness Consolidation
5UCT100GSet: GUID2SETIDGUID for Identifying the Setnvarchar220
6UCT100TSet: Text3SETIDGUID for Identifying the Setnvarchar220
7UCT101CSet: Rows2SETIDGUID for Identifying the Setnvarchar220
8UCT101TSet: Text for Rows3SETIDGUID for Identifying the Setnvarchar220
9UCT3000Selection Condition: Characteristics6SETIDGUID for Identifying the Setnvarchar220
TOPBusiness Package for Manager Self-Service FI
10FPB_EXP_HIERExpress Planning: Object Hierarchies for Planning Instances5SETIDIdentification of a setnvarchar340
TOPBusiness Partner
11TIVBPCHECKAssignment: "Calling Application" BP for Dataset (see Docu)1SETIDBDT: Data Setnvarchar60
TOPBusiness Partner Enhancements for Financial Services
12TBDC002BP: Field Grouping Customer/Vendor2SETIDBDT: Data Setnvarchar60
TOPClaims Management
13ICL_CITEM_RFCHCKItem: Data Set Relevance for Extensive Required Field Check4SETIDBDT: Data Setnvarchar60
14ICL_CPROC_RFCHCKClaim Item Grouping: Data Set Relevant for Ext.RqrdFld Check3SETIDBDT: Data Setnvarchar60
15TICL028Hidden Data Sets3SETIDBDT: Data Setnvarchar60
16TICL071Data Sets for Which FMOD2A Is Not Executed4SETIDBDT: Data Setnvarchar60
17TICL106Assignment Data Set - Claim Subobject Category3SETIDBDT: Data Setnvarchar60
TOPClinical System
18N2DT_SETSDocument Categories to SET ID Assignment Table4SETIDKey of Text Module Setnvarchar200
19N2TBS_CAT_SETCategories for Text Modules for a Set3SETIDKey of Text Module Setnvarchar200
20N2TBS_SETText Module to Set Assignment3SETIDKey of Text Module Setnvarchar200
21N2TBS_SET_HEADHeader Data for a Text Module Set2SETIDKey of Text Module Setnvarchar200
22N2TBS_SET_HEADTHeader Data for a Text Module Set3SETIDKey of Text Module Setnvarchar200
23N2TBS_SM_TAG_SETMarker Tag Table for Sets2SETIDKey of Text Module Setnvarchar200
24N2TBS_SM_VAL_SETLTE: Marker Values for Sets3SETIDKey of Text Module Setnvarchar200
TOPClosing Operations
25FBRC0090CSets3SETIDSet IDnvarchar100
26FBRC0090TSets: Texts4SETIDSet IDnvarchar100
27FBRC0095Sets: Single Entries3SETIDSet IDnvarchar100
TOPConsolidation
28TF103ABreakdown Categories: Breakdown Info per Subassignment7SETIDIdentification of a setnvarchar340
29TF374Fields Used in Validation Rules8SETIDIdentification of a setnvarchar340
30TF584Assignment of Inventory Item to Product Group6SETIDIdentification of a setnvarchar340
TOPCost Center Accounting
31T811DHAllocations: Header Fields12SETIDIdentification of a setnvarchar340
32T811KAllocations: Key Fields12SETIDIdentification of a setnvarchar340
33T811XAllocations: Fixed Selection Values10SETIDIdentification of a setnvarchar340
34TKSR1Summarization - header data20SETIDIdentification of a setnvarchar340
TOPCross-Application Components
35MPO_CCMON_RULESCost Center Monitor: Rule Definition for Exception Reporting17SETIDIdentification of a setnvarchar340
TOPData Retention Tool
36TXW_C_V4Data view: Selection conditions7SETIDIdentification of a setnvarchar340
TOPFloorplan Manager Web Dynpro ABAP
37FPM_ADAPT_RULEAdaptation Rule4SETIDAdaptation Value Setnvarchar320
TOPFunds Management
38FMDERIVE_TRIGGERTriggers update of tables for the derivation tool2SETIDIdentification of a setnvarchar340
TOPGeneral Ledger Accounting
39FAGL_VAL_TRIGGERUpdate of Tables for Validation2SETIDIdentification of a setnvarchar340
TOPIndustry Solution Oil
40OIB_CONV_RDGRPTable for classification Conversiongrp - Readinggrp4SETIDNumber/character defining a set of physical properties datanvarchar20
41OIB_PPP_DATAPhysical properties data table2SETIDNumber/character defining a set of physical properties datanvarchar20
42OIB_PPP_HEADERHeader data: physical properties of hydrocarbons2SETIDNumber/character defining a set of physical properties datanvarchar20
43OIB_PPP_HEADERTHeader table: phys. properties of hydrocarb.: Description3SETIDNumber/character defining a set of physical properties datanvarchar20
TOPOverhead Cost Controlling
44REPPARMSReporting CO-OM : User settings7SETIDIdentification of a setnvarchar340
45T823KRevaluation key fields11SETIDIdentification of a setnvarchar340
TOPPatient Accounting
46NMSEOIS-H MM: Assignment of Material Catalog to OU3SETIDIS-H MM: Identification of a material setnvarchar80
47NMSEPIS-H MM: Material Catalog Items2SETIDIS-H MM: Identification of a material setnvarchar80
48NMSETIS-H MM: Material Catalogs2SETIDIS-H MM: Identification of a material setnvarchar80
49NMSETTIS-H MM: Material Catalogs3SETIDIS-H MM: Identification of a material setnvarchar80
50TNM20LIS-H: MM hierarchic material selection8SETIDIS-H MM: Identification of a material setnvarchar80
TOPProcess Controls
51GRPCRATINGSETVALRating set value2SETIDNatural Numberint100
TOPProfitability Analysis
52CESETSSet Administration in the Report Painter12SETIDIdentification of a setnvarchar340
TOPReal Estate Management
53TIV_OB_WORKLISTTable for Saving the List with Work Lists3SETIDIdentification of a setnvarchar340
TOPSAP Business Partner
54TBZ0QBDT Data Sets3SETIDBDT: Data Setnvarchar60
55TBZ0RBDT Data Sets: Texts4SETIDBDT: Data Setnvarchar60
56TBZ0SBDT Object Part -> BDT Data Sets Assignment4SETIDBDT: Data Setnvarchar60
57TBZ3EBDT Views19SETIDBDT: Data Setnvarchar60
TOPSets
58SETHANAHIER0101Hierarchy table for Cost Center Groups8SETIDIdentification of a setnvarchar340
59SETHANAHIER0102Hierarchy table for Cost Element Groups8SETIDIdentification of a setnvarchar340
60SETHANAHIER0103Hierarchy table for Order Groups8SETIDIdentification of a setnvarchar340
61SETHANAHIER0106Hierarchy table for Profit Center Groups8SETIDIdentification of a setnvarchar340
62SETHANAHIER0109Hierarchy table for Account Groups8SETIDIdentification of a setnvarchar340
63SETO2NTables and Set Names for Sets in New Storage Form4SETIDIdentification of a setnvarchar340
64SETUSE_BERSet Use in Authorizations (Area of Responsibility)2SETIDIdentification of a setnvarchar340
65SETUSE_REPSet Use in Reports and Libraries6SETIDIdentification of a setnvarchar340
66T802GU_SETUse of Variables in Sets2SETIDIdentification of a setnvarchar340
TOPValidation, Substitution and Rules
67GB903Mapping of shortname and SETID of sets used in boolean expr.4SETIDIdentification of a setnvarchar340