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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

60 columns | Print definition?ERP 6.0  | NUMKI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T167Number Range Management for Purchasing Master Data3NUMKINumber range in the case of internal number assignmentnvarchar20
2T460DOrder/Purchase order types for planned order4NUMKIInternal numer range for material requirements planningnvarchar20
3TMQ1Number Ranges for Quota Arrangement3NUMKINumber range in the case of internal number assignmentnvarchar20
4TVGAINumber range table for number range object COPA_IST4NUMKINumber range in the case of internal number assignmentnvarchar20
5TVGAPNumber range table for number range object COPA_PLAN4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPAdvertising Management
6TJH81IS-M/AM: Group Type for Collective Processing3NUMKIIS-M: Coll.Processing Number Range (Billing/Settlement)nvarchar20
7TJHANUMIS-M/AM: No.Range Intervals for each S.Area and Order Type6NUMKINumber range in the case of internal number assignmentnvarchar20
8TJHCNUMIS-M/AM: Number Range Interval per Sales Office3NUMKINumber range in the case of internal number assignmentnvarchar20
9TJHE0IS-M/AM: Revenue Distribution Settings for an Entire Client4NUMKIIS-M: Internal Number Range for Revenue Object Documentnvarchar20
10TJJ61IS-M/AM: Booking Unit Group3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPAgency Business Global Trade
11TCWBCRAB-CWB: Reasons for Complaint6NUMKINumber range in the case of internal number assignmentnvarchar20
12TMFKAgency Business: Billing Document Types5NUMKINumber range in the case of internal number assignmentnvarchar20
TOPAllocation
13T620Allocation Table Document Types4NUMKINumber range in the case of internal number assignmentnvarchar20
14T622Allocation Rule Document Types3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPBasic Functions
15T323VError handling (Host)- Decentralized SD (Definition of mail)9NUMKIDummy, undefined field consisting of 2 digitsnvarchar20
16TVAKSales Document Types7NUMKINumber range in the case of internal number assignmentnvarchar20
17TVFKBilling: Document Types4NUMKINumber range in the case of internal number assignmentnvarchar20
18TVLKDelivery Types7NUMKINumber range in the case of internal number assignmentnvarchar20
19TVLKNDeliveries: Number Range per Warehouse Number and Dlv. Type4NUMKINumber range in the case of internal number assignmentnvarchar20
20TVSASD Documents: Processing Groups3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPBilling
21TVFKDBilling Document: Billing Date by Number Range2NUMKINumber range in the case of internal number assignmentnvarchar20
TOPConditions
22T6B1Rebate : Rebate Agreement Types11NUMKINumber range in the case of internal number assignmentnvarchar20
TOPConstruction Equipment Management
23J_3GBELARTDocument Types3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPContract Accounts Receivable and Payable
24TEEXTDOCBRIssuing branch (Nota Fiscal)4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPEquipment
25T370TEquipment categories4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPExternal Services
26T165Default Values for Purchasing/Services4NUMKINumber range for service packagenvarchar20
27T165EDefault Values: Service per Purchasing Organization5NUMKINumber range for service packagenvarchar20
28T362Service Categories4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPFreight Processing
29TVTFShipment Cost Types4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPGoods Issue Process
30/SPE/DLVRY_RECDelivery Numbers Available for Recycling2NUMKINumber range in the case of internal number assignmentnvarchar20
TOPInventory Management
31T159ZInventory Management: XAB number range3NUMKINumber rangenvarchar20
TOPLocalization
32J_1IEWTNONo range for certificate Printing-EWT India3NUMKINumber range in the case of internal number assignmentnvarchar20
33J_1IEWTNUMINTERNAL NO RANGE FOR CHALLANS- EWT INDIA3NUMKINumber range in the case of internal number assignmentnvarchar20
34J_1IEWT_CERTNONumber Ranges for Withholding Tax Certificates3NUMKINumber range in the case of internal number assignmentnvarchar20
35J_1IRG1RNGGroup table for RG1 - Number Range Object3NUMKINumber range in the case of internal number assignmentnvarchar20
36J_1ITDSSECTDS Sections6NUMKINumber range in the case of internal number assignmentnvarchar20
TOPLogistics - General
37TB2BETrading Contract: Trading Contract Type10NUMKINumber range in the case of internal number assignmentnvarchar20
TOPMaintenance History
38T370NObject link category4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPMaster Data
39TE130IS-U: Struc. Ind. and Cat. of Functional Loc.5NUMKINumber range for internal number assignmentnvarchar20
TOPMaterial Master
40T134Material Types6NUMKINumber rangenvarchar20
TOPOrganizational Management
41T77IVNumber Assignment3NUMKINumber Range for Internal Number Assignmentnvarchar20
TOPPeriodical Sales and Distribution
42TJAKIS-M/SD: Sales Document Type6NUMKINumber range for internal number assignmentnvarchar20
43TJD19IS-M/SD: Number Ranges for Publication Types3NUMKINumber range for internal number assignmentnvarchar20
44TJFKIS-M/SD: Billing Document Types4NUMKINumber range in the case of internal number assignmentnvarchar20
45TJL05IS-M/SD: Document Types for Transfer to Financial Accounting3NUMKINumber range in the case of internal number assignmentnvarchar20
46TJL11IS-M/SD: Object Types for Document Flow etc.5NUMKINumber range in the case of internal number assignmentnvarchar20
47TJN01IS-M/SD: Research Type3NUMKINumber range in the case of internal number assignmentnvarchar20
48TJY01Central Parameters for IS-M Number Assignment3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPPromotion
49TMFAMarkdown Planning - Markdown type9NUMKINumber range in the case of internal number assignmentnvarchar20
50TWAAPromotion Type, IS-R12NUMKINumber range in the case of internal number assignmentnvarchar20
TOPPurchasing
51T161Purchasing Document Types6NUMKINumber range in the case of internal number assignmentnvarchar20
TOPRetail Demand Management
52RDMT_BBY_PROFBonus Buy: Bonus Buy Profiles3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPRetail Pricing
53TWMBCompetitor: Price Entry Types3NUMKINumber range in the case of internal number assignmentnvarchar20
54TWWKAMarket-Basket Pricing Type10NUMKINumber range in the case of internal number assignmentnvarchar20
TOPThird Party Remittance
55T51RVRemittance number range sub-objects3NUMKINumber Range for Internal Number Assignmentnvarchar20
TOPTransportation
56TVTKShipment Types4NUMKINumber range in the case of internal number assignmentnvarchar20
TOPTransportation and Distribution
57TOIGSTD Shipment Types3NUMKINumber range in the case of internal number assignmentnvarchar20
TOPVehicle Management System
58VLCMODELSNRVELO : Assignment of number ranges to models3NUMKINumber rangenvarchar20
59VLC_MODELSNRVELO : Assignment of number ranges to models3NUMKINumber rangenvarchar20
TOPWarranty Claim Processing
60CWTY001Claim Types Warranty Claim3NUMKINumber rangenvarchar20