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

18 columns | Print definition?ERP 6.0  | SORTORDER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IXOS/OA_T_VIEWMsorted sequence for parameters viewerMode2SORTORDERsort order in docAccess secKeyint100
TOPCross-Application Components
2/IXOS/DC_TAHAHitlist Administrator maintenance (hierachy/separat)16SORTORDERSort sequence of fields in hitlistnvarchar30
3/IXOS/DC_TAHUHitlist User maintenance (hierachy/separat)18SORTORDERSort sequence of fields in hitlistnvarchar30
TOPExpense-Related Billing
4PRSD_GRPGrouping, Sorting values for DLI6SORTORDERSort Order for Groupingnvarchar60
TOPFlexible Real Estate Management
5TIVCAPROCREPReport on Process6SORTORDERSort Sequencetinyint30
6TIVSCISREPORTSOBSOLETE7SORTORDEROBSOLETE: Sort Sequencetinyint30
TOPMaster Data
7EPDPRODHIS-U Master data Generator: Master Data Template Hierarchy13SORTORDERMaintenance and Processing Sequencenvarchar40
8EPDTYPEHIS-U Master Data Generator: Hierarchy for MDT Category8SORTORDERMaintenance and Processing Sequencenvarchar40
TOPRent Adjustment
9TIVAJATTYPEType of Adjustment Measure2SORTORDERSort Sequencesmallint50
10TIVAJCOSTSGRPCosts Item Group3SORTORDERSort Sequencesmallint50
11TIVAJCOSTSPOSCosts Item5SORTORDERSort Sequencesmallint50
12TIVAJEXPPOSExpense Item11SORTORDERSort Sequencesmallint50
13TIVAJEXPPOSGRPExpense Item Group6SORTORDERSort Sequencesmallint50
14TIVAJFINPOSFinancing Item4SORTORDERSort Sequencesmallint50
15TIVAJFINPOSGRPFinancing Item Group4SORTORDERSort Sequencesmallint50
TOPSales Promotions
16SADLSTSORTSort Fields for Address List6SORTORDERUse in CAS: Sort sequence (ascending or descending)nvarchar10
TOPStakeholder Relationship Management
17USS_TREE_DEFAULTSRM: User-Specific Settings for Transactions usth0 and ucon05SORTORDERVersion Number Componentnvarchar20
TOPTranslation Tools
18LXE_SLLS_PREFSTranslation Statistics - User Settings7SORTORDERtinyint30