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

42 columns | Print definition?ERP 6.0  | NUMKE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T167Number Range Management for Purchasing Master Data4NUMKENumber range in the case of external number assignmentnvarchar20
2T460DOrder/Purchase order types for planned order5NUMKEExternal number range for material requirements planningnvarchar20
3TVGAINumber range table for number range object COPA_IST5NUMKENumber range in the case of external number assignmentnvarchar20
4TVGAPNumber range table for number range object COPA_PLAN5NUMKENumber range in the case of external number assignmentnvarchar20
TOPAdvertising Management
5TJH05IS-M/AM: Billing: Document Types16NUMKENumber range in the case of external number assignmentnvarchar20
6TJHANUMIS-M/AM: No.Range Intervals for each S.Area and Order Type7NUMKENumber range in the case of external number assignmentnvarchar20
7TJHCNUMIS-M/AM: Number Range Interval per Sales Office4NUMKENumber range in the case of external number assignmentnvarchar20
8TJJ61IS-M/AM: Booking Unit Group4NUMKENumber range in the case of external number assignmentnvarchar20
TOPAgency Business Global Trade
9TMFKAgency Business: Billing Document Types6NUMKENumber range in the case of external number assignmentnvarchar20
TOPAllocation
10T620Allocation Table Document Types5NUMKENumber range in the case of external number assignmentnvarchar20
11T622Allocation Rule Document Types4NUMKENumber range in the case of external number assignmentnvarchar20
TOPBasic Functions
12TVAKSales Document Types8NUMKENumber range in the case of external number assignmentnvarchar20
13TVFKBilling: Document Types5NUMKENumber range in the case of external number assignmentnvarchar20
14TVLKDelivery Types8NUMKENumber range in the case of external number assignmentnvarchar20
TOPConditions
15T6B1Rebate : Rebate Agreement Types12NUMKENumber range in the case of external number assignmentnvarchar20
TOPContract Accounts Receivable and Payable
16TEEXTDOCBRIssuing branch (Nota Fiscal)5NUMKENumber range in the case of external number assignmentnvarchar20
TOPEquipment
17T370TEquipment categories5NUMKENumber range in the case of external number assignmentnvarchar20
TOPExternal Services
18T362Service Categories5NUMKENumber range in the case of external number assignmentnvarchar20
TOPFreight Processing
19TVTFShipment Cost Types5NUMKENumber range in the case of external number assignmentnvarchar20
TOPInventory Management
20T159ZInventory Management: XAB number range4NUMKENumber rangenvarchar20
TOPMaintenance History
21T370NObject link category5NUMKENumber range in the case of external number assignmentnvarchar20
TOPMaster Data
22TE130IS-U: Struc. Ind. and Cat. of Functional Loc.6NUMKENumber range for external number assignmentnvarchar20
TOPMaterial Master
23T134Material Types7NUMKENumber rangenvarchar20
TOPOrganizational Management
24T77IVNumber Assignment4NUMKENumber Range for External Number Assignmentnvarchar20
TOPPeriodical Sales and Distribution
25TJAKIS-M/SD: Sales Document Type7NUMKENumber range for external number assignmentnvarchar20
26TJD19IS-M/SD: Number Ranges for Publication Types4NUMKENumber range for external number assignmentnvarchar20
27TJFKIS-M/SD: Billing Document Types5NUMKENumber range in the case of external number assignmentnvarchar20
28TJL11IS-M/SD: Object Types for Document Flow etc.6NUMKENumber range in the case of external number assignmentnvarchar20
29TJY01Central Parameters for IS-M Number Assignment4NUMKENumber range in the case of external number assignmentnvarchar20
TOPPromotion
30TMFAMarkdown Planning - Markdown type10NUMKENumber range in the case of external number assignmentnvarchar20
31TWAAPromotion Type, IS-R13NUMKENumber range in the case of external number assignmentnvarchar20
TOPPurchasing
32T161Purchasing Document Types7NUMKENumber range in the case of external number assignmentnvarchar20
TOPRetail Demand Management
33RDMT_BBY_PROFBonus Buy: Bonus Buy Profiles4NUMKENumber range in the case of external number assignmentnvarchar20
TOPRetail Pricing
34TWMBCompetitor: Price Entry Types4NUMKENumber range in the case of external number assignmentnvarchar20
35TWWKAMarket-Basket Pricing Type11NUMKENumber range in the case of external number assignmentnvarchar20
TOPSales Activities
36TVKKSales Activity Types5NUMKENumber range in the case of internal number assignmentnvarchar20
TOPThird Party Remittance
37T51RVRemittance number range sub-objects4NUMKENumber Range for External Number Assignmentnvarchar20
TOPTransportation
38TVTKShipment Types5NUMKENumber range in the case of external number assignmentnvarchar20
TOPTransportation and Distribution
39TOIGSTD Shipment Types4NUMKENumber range in the case of external number assignmentnvarchar20
TOPVehicle Management System
40VLCMODELSNRVELO : Assignment of number ranges to models4NUMKENumber rangenvarchar20
TOPWarranties
41T790GWarranty Type5NUMKENumber range in the case of external number assignmentnvarchar20
TOPWarranty Claim Processing
42CWTY001Claim Types Warranty Claim4NUMKENumber rangenvarchar20