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

37 columns | Print definition?ERP 6.0  | SORTF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_FAVFavorites7SORTFSort Fieldint100
2T047FSorting of dunning letters3SORTFSort field sequencenvarchar10
3T130DScreen data6SORTFSort sequencenvarchar20
4T138AFields for Mass Change: Material Master Records3SORTFSort sequencenvarchar20
5T139AException Messages: Period Closing Program4SORTFSort sequencenvarchar20
6T5D2FGross Taxable Amounts (D)7SORTFSort Fieldnvarchar10
7TPAERBusiness Partner: Functions in Partner Determination Proced.8SORTFSequence in which partners are determined in the sales doc.nvarchar20
TOPAdvertising Management
8JHTASIS-M/AM: Sales Documents for Collective Processing4SORTFSort sequencenvarchar40
9TJJ89IS-M: Business Partner: Part.Roles in Partner Det.Proc. TPAE8SORTFSequence in which partners are determined in the sales doc.nvarchar20
TOPAssortment Maintenance
10TWWVLayout area / area share4SORTFLayout area numbernvarchar100
TOPBasic Data
11TN10IIS-H: Inter-Dept. Bed Asgmts in an OU by Another OU9SORTFIS-H: Sort Field for Organizational Unitsnvarchar30
TOPBasic Functions
12TVUVFIncompletion Control: Fields8SORTFProcessing sequence of incompletion lognvarchar40
13VBSSCollective Processing: Sales Documents4SORTFSort sequencenvarchar40
TOPBills of Material
14STPOBOM item20SORTFSort Stringnvarchar100
TOPCondition
15BKK81Bank Condition23SORTFSort stringnvarchar100
16BKK84Bank Account - Individual Condition25SORTFSort stringnvarchar100
TOPConfiguration management
17IBINCMIB: Config.Mang.: Component/Instance9SORTFSort stringnvarchar100
TOPHandling Unit Management
18TVTYPackaging Material Types6SORTFSort Sequence for Displaying Handling Unitnvarchar40
TOPIndustry-Specific Component Automotive
19MHIO_UNPACKEDCopy of database table MHIO (Data cat.INT4 replaced by NUMC)11SORTFSort field for maintenance item scheduling callnvarchar300
TOPInstalled Base
20IBINIB: IBase Components - Condition9SORTFSort stringnvarchar100
TOPInventory Management
21RESBReservation/dependent requirements76SORTFSort Stringnvarchar100
TOPMaintenance Task Lists
22MHIOCall Object from Maintenance Order11SORTFSort field for maintenance item scheduling callnvarchar300
TOPMaster Data
23MDSMSimulative dependent requirements8SORTFSort Stringnvarchar100
TOPMeasuring Points and Counters
24IMEPItems in the Entry List5SORTFSort Field for Item in Entry Listnvarchar200
TOPPatient Management
25TNR02IS-H: Report Control: Report - Group Asgmt4SORTFIS-H: General Sort Ordernvarchar20
TOPPeriodical Sales and Distribution
26JLSSIS-M/SD: Settlements in Collective Processing4SORTFSort sequencenvarchar40
TOPPlant Maintenance
27Z9I_STK_IF_NPVPM/PS-Schnittstelle: Netzplanvorgänge16SORTFSortierfeldnvarchar300
28Z9I_STK_IF_NPV_WPM/PS-Schnittstelle: Netzplanvorgänge Werkstattsicht21SORTFSortierfeldnvarchar300
29Z9I_STK_VORGANGTerminkontrolle Stillstandsplanung: Relevante Vorgänge22SORTFSortierfeldnvarchar300
TOPProduct Catalog
30TWGLVLayout Area3SORTFLayout area numbernvarchar100
31TWGLVTLayout area description3SORTFLayout area numbernvarchar100
TOPProduction Orders
32DRAD_PORDERAttributes for Links: Document to Production Order19SORTFSort Stringnvarchar100
TOPRemaining Beverage - Obsolete Objects
33/BEV3/CHCIVBSSSales Documents of Collective Run for CH Billing Documents6SORTFSort sequencenvarchar40
TOPSerial Numbers
34OBJKPlant Maintenance Object List8SORTFObject list sort fieldnvarchar200
TOPSimulation
35VSRESB_CNVersion: Reservation/Dependent requirements77SORTFSort Stringnvarchar100
TOPWarehouse Management
36T311ACross-Reference WM Group for Documents10SORTFSort sequencenvarchar40
TOPWarranties
37BGMPMaster Warranty Item21SORTFSorting ordernvarchar60