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

70 columns | Print definition?ERP 6.0  | SELID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PAHI_PARAM_SELSelect the Parameters to Be recorded1SELIDNatural Numberint100
2T77PAOSQUINFOQuery Information for Category6SELIDID for Selection Conditionnvarchar200
TOPBalanced Scorecard
3UMB_RB104Report Builder: Selection Elements for Report4SELIDSelection Elements - Technical Namenvarchar150
4UMB_RB_BB103Report Builder: Elements - Selections3SELIDSelection Elements - Technical Namenvarchar150
5UMB_RB_SB100Report Builder: Selection Elements2SELIDSelection Elements - Technical Namenvarchar150
6UMB_RB_SB101OBSOLETE! Report Builder: Selection Elements - Texts2SELIDSelection Elements - Technical Namenvarchar150
7UMB_RB_SB102Report Builder: Selection Elements - Selection Types2SELIDSelection Elements - Technical Namenvarchar150
TOPBases
8T77OMAHQ_GARBAGETable with Selections/Queries to be Deleted3SELIDnvarchar200
TOPBatches
9TBICSELSelection Enhancement in the Batch Information Cockpit2SELIDEnhanced Selection: Batch Information Cockpitnvarchar40
10TBICSELTEnhanced Selections in Batch Information Cockpit Texts3SELIDEnhanced Selection: Batch Information Cockpitnvarchar40
11TBICSELUAssign User Group to Enhanced Selection: BIC3SELIDEnhanced Selection: Batch Information Cockpitnvarchar40
TOPBusiness Analytics
12UACRCRUNCosting Run: Costing Run7SELIDCosting Run: Selection IDnvarchar640
TOPBusiness Consolidation
13UCF0021Method Steps: Selection Condition5SELIDGUID for Identifying the Selection Conditionnvarchar220
14UCF221CC/T: Currency Translation Time Frames3SELIDGUID for Identifying the Selection Conditionnvarchar220
15UCF223CC/T: Times for Exchange Rate Determination3SELIDGUID for Identifying the Selection Conditionnvarchar220
16UCFE04GSAP Cons: GUID Table for Headers of Online Data Entry5SELIDGUID for Identifying the Selection Conditionnvarchar220
17UCMI300Deferred Tax Items5SELIDGUID for Identifying the Selection Conditionnvarchar220
18UCT200GSingle Field Selection: GUID6SELIDGUID for Identifying the Selection Conditionnvarchar220
19UCT3000Selection Condition: Characteristics2SELIDGUID for Identifying the Selection Conditionnvarchar220
20UCT300CSelection Conditions4SELIDGUID for Identifying the Selection Conditionnvarchar220
21UCT300GSelection Condition: GUID2SELIDGUID for Identifying the Selection Conditionnvarchar220
22UCT8011Mapping Rule: Details of Condition4SELIDGUID for Identifying the Selection Conditionnvarchar220
23UCT9000Workflow Variant5SELIDGUID for Identifying the Selection Conditionnvarchar220
TOPConsolidation Functions
24UCFV103Validation: Selection Conditions in FoBu Editor4SELIDGUID for Identifying the Selection Conditionnvarchar220
25UCFV110Validation: Selection Conditions3SELIDGUID for Identifying the Selection Conditionnvarchar220
26UCFV11TValidation: Selection Conditions - Texts3SELIDGUID for Identifying the Selection Conditionnvarchar220
27UCFV220Validation Check: Selection Conditions3SELIDGUID for Identifying the Selection Conditionnvarchar220
28UCFV22TValidation Check: Selection Condition: Text4SELIDGUID for Identifying the Selection Conditionnvarchar220
TOPControlling
29COBK_INDXIndex in COBK for ORGVG9SELIDProfitability Segment Number (CO-PA)nvarchar100
TOPDay-to-Day Activities
30LSOCRPRECROLERecipient Roles3SELIDID for Selection Conditionnvarchar200
TOPEmployee Self-Service
31T77WWW_WHOControl Table for Selection and Output Fields in Who's Who4SELIDID for Selection Conditionnvarchar200
32T77WWW_WHO_PARAESS Who's Who: Parameters per Country Grpg and Appl. Type7SELIDID for Selection Conditionnvarchar200
TOPFinancials Basis
33ACCSEL01Selection Condition: Characteristics2SELIDGUID for Identifying the Selection Conditionnvarchar220
34ACCSEL0CSelection Condition2SELIDGUID for Identifying the Selection Conditionnvarchar220
35ACCSYS02Accounting System: Assignment to Selection Condition3SELIDGUID for Identifying the Selection Conditionnvarchar220
TOPFlexible Real Estate Management
36TIVLDSELIDDEFDefault Status Selection per Object Type3SELIDSelection IDnvarchar70
TOPGeneral status management
37TJ48Check Table for Selection IDs2SELIDSelection IDnvarchar70
38TJ48TText Table for Selection IDs3SELIDSelection IDnvarchar70
39TJ49Table for Selection Conditions per SELID2SELIDSelection IDnvarchar70
TOPHR Information Systems
40HRSEL_COMBINERelationship of Selection IDs2SELIDID for Selection Conditionnvarchar200
41HRSEL_FUNCTIONSSelection Functions2SELIDID for Selection Conditionnvarchar200
42HRSEL_FUNC_DATAGeneral Data for Selecting by FM2SELIDID for Selection Conditionnvarchar200
43HRSEL_GROUPINGSelection Grouping5SELIDID for Selection Conditionnvarchar200
44HRSEL_IDSHR Selection IDs2SELIDID for Selection Conditionnvarchar200
45HRSEL_IDS_TEXTTexts for HR Selection IDs2SELIDID for Selection Conditionnvarchar200
46HRSEL_RANGESSelection Condition Ranges2SELIDID for Selection Conditionnvarchar200
47HRSEL_ROOTOBJRoot Object Set for Structural Reporting2SELIDID for Selection Conditionnvarchar200
48HRSEL_STRUCTUREStructural Reporting2SELIDID for Selection Conditionnvarchar200
49HRSEL_TABFIELDSTable Name and Field Name of Selection2SELIDID for Selection Conditionnvarchar200
TOPInformation System
50COCF_MD_ADM_SYSTMandash System Status Customization table3SELIDSelection IDnvarchar70
51TCNDProject Info System: Overview Settings30SELIDSelection ID for status filternvarchar70
52TCNTProject Information System: PS Info Profile60SELIDSelection ID for status filternvarchar70
TOPOrganizational Management
53HRPAD007Additional Data PAD00711SELIDChar 20nvarchar200
TOPProduction Orders
54T441CProfile - availability check15SELIDSelection IDnvarchar70
55TCOADObject profile - detail list - order information system19SELIDSelection IDnvarchar70
56TCOFProfile for missing parts info system16SELIDSelection IDnvarchar70
TOPProduction Planning and Control PP enhancements
57MILLOCCUSTCustomizing Table Combination for Selection Profile2SELIDSelection Profile for Order Combinationnvarchar40
58MILLOCSPRASelection Profile Texts3SELIDSelection Profile for Order Combinationnvarchar40
59VMILLOCCUSTCustomizing Table Combination2SELIDSelection Profile for Order Combinationnvarchar40
TOPReal Estate Management
60TIVB5Default Values for Selection acc. to Status of Object4SELIDSelection IDnvarchar70
TOPReport Selection for Product Costing
61TKKR0Hierarchy Summarization (Header)6SELIDStatus Selection Profilenvarchar70
62TKKR4Hierarchy Summarization (Summarized Object Types)6SELIDStatus Selection Profilenvarchar70
TOPSAP Healthcare - Industry-Specific Components for Hospitals
63NKSKSELHIV/TC-Selection - Header3SELIDIV/TC-Selection - Idnvarchar200
64NKSKSELIIV/TC-Selection - Item3SELIDIV/TC-Selection - Idnvarchar200
65TNA30AIS-H AT: Selektionsschema für Krankenanst.-Statistiken3SELIDIS-H: selectieschemanvarchar70
66TNA30BIS-H: Selection procedure - bed classes and services3SELIDnvarchar70
67TNA30CIS-H AT: Selektionsschema für KH-Stat A2 Fall.klass.3SELIDIS-H: selectieschemanvarchar70
68TNA30EIS-H: Geographical areas - locations (AT)3SELIDnvarchar70
69TNA30SIS-H: Line texts for age structure3SELIDnvarchar70
70TNA30VIS-H: Insurance statistics (AT)3SELIDnvarchar70