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

82 columns | Print definition?ERP 6.0  | NUMKR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_20000_MAPPMapping for the errneous table7NUMKRNumber rangenvarchar20
2CNV_20800_T077DCNV table that states which customer account groups match8NUMKRNumber rangenvarchar20
3CNV_20900_T077KVendor account groups8NUMKRNumber rangenvarchar20
4CNV_40305_ANKABackup of ANKA from prior to the conversion5NUMKRNumber rangenvarchar20
5CNV_40305_ANKA_BBackup of ANKA from prior to the conversion5NUMKRNumber rangenvarchar20
6COPC_ACCDCOPC: Cash Account Group Names3NUMKRNumber rangenvarchar20
7FKKNUMKRHelp structure for lock object EFKKNUMKR2NUMKRNumber rangenvarchar20
8ISUERDKHelp Structure for Lock Object Eisuerdk2NUMKRNumber rangenvarchar20
9ISUNUMKRHelp Structure for Lock Object IS-U Document Number Range3NUMKRNumber rangenvarchar20
10PYONUMKRAuxiliary structure for lock object EPYONUMKR2NUMKRNumber rangenvarchar20
11T003MTransaction/Event Types for SAPMM07M/SAPMM07I3NUMKRNumber rangenvarchar20
12T037Planning Types6NUMKRNumber rangenvarchar20
13TFKKWL_NRWorklists: Assignment of Number Range Interval3NUMKRNumber rangenvarchar20
14TKKEAUnit Costing Types6NUMKRNumber rangenvarchar20
15TQ33Relevant fields for origin3NUMKRNumber range numbernvarchar20
16TVARNSelection parameters for archiving in sales and distribution3NUMKRNumber rangenvarchar20
17TZ10Customer application type3NUMKRNumber rangenvarchar20
18TZN01Product type numbers9NUMKRNumber rangenvarchar20
TOPActual CostingMaterial Ledger
19T003LTransaction Type for Material Ledger3NUMKRNumber rangenvarchar20
TOPAppropriation Requests
20TAIF1Appropriation request types8NUMKRNumber rangenvarchar20
TOPBasic Functions
21ANKAAsset classes: general data10NUMKRNumber rangenvarchar20
TOPBusiness Analytics
22UANRGRNumber Range Groups Costing Platform3NUMKRNumber rangenvarchar20
TOPBusiness Partner Enhancements for Financial Services
23BPUM_CTLBusiness partner: Conversion control9NUMKRNumber rangenvarchar20
24TPZ2Business Partner: Customizing BP Grouping3NUMKRNumber rangenvarchar20
TOPContract Accounts Receivable and Payable
25DFKKDISPEDispute Case (Help Table Block Object EFKKNUMKR_DIS)2NUMKRNumber rangenvarchar20
26DFKKIP_NUMPayment Specification (for Lock Object EFKKNUMKR_IP)2NUMKRNumber rangenvarchar20
27DFKKPAEPayment Notification (Aux. Table EFKKNUMKR_PA)2NUMKRNumber rangenvarchar20
28DFKKPOEPayment Order (Help Table Lock Object EFKKNUMKR_PO)2NUMKRNumber rangenvarchar20
29DFKKREPTNRKRInternal Table for Lock Object EFKKNUMKR_REPT2NUMKRNumber rangenvarchar20
30DFKKZRHPayment document (help table for lock object EFKKNUMKR_PF)2NUMKRNumber rangenvarchar20
31TFK003Document types4NUMKRNumber range for individual postingsnvarchar20
32TFK003BParallel number ranges for FI-CA documents4NUMKRNumber range for mass postingsnvarchar20
33TFK003DParallel Number Ranges for Individual Postings4NUMKRParallel Number Range for Individual Postingsnvarchar20
TOPContract Billing
34TE093Document Types3NUMKRNumber rangenvarchar20
TOPCost Object
35CKPHSControl for Cost Object Category11NUMKRNumber rangenvarchar20
TOPDownstream
36OI001Company Code Parameters15NUMKRNumber range for tracking recordsnvarchar20
TOPExchanges
37OIA01Exchange header (IS-Oil EXG standard/core object)11NUMKRNumber range for exchanges documentnvarchar20
38TOIA2Exchange types9NUMKRNumber range for exchanges documentnvarchar20
39TOIAULIA Control Parameters5NUMKRNumber rangenvarchar20
TOPExternal Services
40T165Default Values for Purchasing/Services5NUMKRNumber range for entry sheetsnvarchar20
41T165EDefault Values: Service per Purchasing Organization6NUMKRNumber range for entry sheetsnvarchar20
TOPFinancial Accounting
42NKUKNumber range for change documents2NUMKRNumber rangenvarchar20
43T003Document Types3NUMKRNumber rangenvarchar20
TOPFunds Management
44TKBBADocument Types4NUMKRNumber range for earmarked fundsnvarchar20
TOPFunds Management-Specific Postings
45PSOTNAssign Request Categories to Number Range3NUMKRNumber rangenvarchar20
TOPGeneral Ledger Accounting
46FAGL_BELNR_LDDocument Types for Entry View in a Ledger4NUMKRNumber rangenvarchar20
47FAGL_DOCNR_LDDocument Types for General Ledger View in a Ledger4NUMKRNumber rangenvarchar20
TOPInvoice Verification
48T003RNumber Ranges RE_BELEG (Logistics Invoice Verification)3NUMKRNumber rangenvarchar20
TOPInvoicing
49TE003Document Number Assignment: Document Type4NUMKRNumber range for individual postingsnvarchar20
50TE003BDocument Number Assignment: Parallel Number Range4NUMKRNumber range for mass postingsnvarchar20
51TE003DDoc. No. Assignment: Parallel No. Range for Single Postings4NUMKRParallel Number Range for Individual Postingsnvarchar20
52TE004Document Number Assignment for Budget Billing Plan3NUMKRNumber range for individual postingsnvarchar20
TOPMaintenance Orders
53/CUM/CMTYPECU: Construction Measure Type4NUMKRNumber rangenvarchar20
TOPOverhead Cost Orders
54T003NNumber Ranges for Order Types3NUMKRNumber rangenvarchar20
55T003OOrder Types4NUMKRNumber rangenvarchar20
TOPPayment Transactions
56T077DCustomer account groups6NUMKRNumber rangenvarchar20
57T077KVendor account groups6NUMKRNumber rangenvarchar20
TOPPayments
58DFKKBLTOBoleto (help table for lock object EFKKNR_BOLETO)2NUMKRNumber rangenvarchar20
59DFKKBOLXTBoleto (Help table for lock object EFKKNR_BOLEXT2NUMKRNumber rangenvarchar20
TOPPeriodical Sales and Distribution
60TJL29IS-M/SD: Postal Settlement Types6NUMKRIS-M: Num.range for condition docs for postal settlementnvarchar20
61TJNF1IS-M/SD: Invoice Printout, Attributes for Message Type3NUMKRNumber rangenvarchar20
TOPProduct Cost Planning
62TCK03Costing Variants13NUMKRNumber rangenvarchar20
63TCMF6Error Management IDs (SAP)4NUMKRNumber rangenvarchar20
TOPRecycling Administration Core Functions
64J_7LC43REA Data Filter: Filter Type Definition9NUMKRNumber rangenvarchar20
TOPRetail Pricing
65TWBAPricing document type3NUMKRNumber rangenvarchar20
TOPSample Management
66TQ40Definition of sample types3NUMKRNumber of the Number Range for Physical Samplesnvarchar20
TOPSamples and SPC
67QPSHControl chart types12NUMKRNumber range numbernvarchar20
TOPTransaction Manager
68AT10Transaction Types5NUMKRNumber Range for Transactionsnvarchar20
69AT50Future/Option Groups11NUMKRNumber rangenvarchar20
70AT72Customizing: Unit Types4NUMKRNumber rangenvarchar20
71ATMAType of Master Agreement3NUMKRNumber rangenvarchar20
72ATPATreasury: Product Type Supplements5NUMKRNumber rangenvarchar20
73THAC_HD_SETUPConfig for the (Implicit) hypothetical Derivative3NUMKRNumber Range for Offers/Quotationsnvarchar20
74THMC_HEDGE_SETUPConfiguration Parameters for Hedge3NUMKRNumber Range for Offers/Quotationsnvarchar20
75THMC_HR_SETUPConfig for the hedging relationship3NUMKRNumber Range for Offers/Quotationsnvarchar20
76THMC_PLAN_SETUPConfiguration Parameters for Hedge Plan4NUMKRNumber Range for Offers/Quotationsnvarchar20
77THMC_TRANS_SETUPConfiguration parameters for hedge managment transaction4NUMKRNumber Range for Offers/Quotationsnvarchar20
78TZBKMDefine Types of Corporate Actions4NUMKRNumber rangenvarchar20
TOPTreasury
79TZPAFinancial Assets Management Product Types10NUMKRNumber rangenvarchar20
80TZPABFinancial Assets Management product types11NUMKRNumber rangenvarchar20
TOPWarehouse Management
81NKLVNumber ranges in WM4NUMKRNumber rangenvarchar20
TOPWarranties
82T790GWarranty Type4NUMKRNumber rangenvarchar20