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

55 columns | Print definition?ERP 6.0  | PRGRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKK_MA_PRAProducts That Belong to a Product Group3PRGRPProduct Groupnvarchar40
2DFKK_MA_PRGProduct Groups for an Agreement3PRGRPProduct Groupnvarchar40
3DFKK_MA_PRGTShort Description of Product Group4PRGRPProduct Groupnvarchar40
4P2RP_SSHR-PT: Payroll Results: Social Security25PRGRPProfessional groupnvarchar10
TOPAgency Business Global Trade
5TMPAAgency Business: Control Data Profit Simulation3PRGRPProfit groupnvarchar40
TOPBusiness Consolidation
6UCFI10CIPI Customizing: Product Group (Check Table)2PRGRPProduct Groupnvarchar180
7UCFI10SIPI Customizing: Product Group (SID Table)3PRGRPProduct Groupnvarchar180
8UCFI10TIPI Customizing: Product Group (Text Table)3PRGRPProduct Groupnvarchar180
TOPCanada
9T5UBX_GTL_AWARTProcessing group for absence types6PRGRPProcessing group, North Americanvarchar20
10T5UBX_GTL_SUBTYProcessing group definition for Beneficiaries5PRGRPProcessing group, North Americanvarchar20
TOPCollectionsDisbursements
11TKKVHVTVFS-CD Transactions6PRGRPProduct Groupnvarchar20
12TKKVHVTVTFS-CD Transactions: Texts7PRGRPProduct Groupnvarchar20
13TKKVMAHNVDunning Proc. for Jurisdiction, Receivable, Product Group5PRGRPProduct Groupnvarchar20
14TKKVPRGRPProduct Groups3PRGRPProduct Groupnvarchar20
15TKKVPRGRPTLOB Texts4PRGRPProduct Groupnvarchar20
16TKKVVERDSummarization Control of FI-CA Line Items3PRGRPProduct Groupnvarchar20
17VVKKFOPSingle Doc in Posting Data Interface17PRGRPProduct Groupnvarchar20
18VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP17PRGRPProduct Groupnvarchar20
19VVKKMHISTContract-Related Dunning History21PRGRPProduct Groupnvarchar20
20VVKKTAXCORRTax Reporting ITA: Correction Totals for On Account/Clarif.4PRGRPProduct Groupnvarchar20
21VVKKTAXREPTax Reporting ITA: Data for Tax Report28PRGRPProduct Groupnvarchar20
22VVKK_TAX_TOTALSItalian Tax Reporting: Totals4PRGRPProduct Groupnvarchar20
23VVSCPOSPayment Plan Item26PRGRPProduct Groupnvarchar20
TOPConsolidation
24TF580Product Groups2PRGRPProduct groupnvarchar180
25TF581Product Groups: Description3PRGRPProduct groupnvarchar180
26TF583Dimension-Dep.Assignmt of CoA, Prod. Group to in(NOT USED)4PRGRPProduct groupnvarchar180
27TF584Assignment of Inventory Item to Product Group4PRGRPProduct groupnvarchar180
28TF584AAssignment of Inventory Item to Product Group (NOT USED)4PRGRPProduct groupnvarchar180
29TF585Inventory Data9PRGRPProduct groupnvarchar180
30TF586Supplier Data8PRGRPProduct groupnvarchar180
31TF592Elimination of IU Profit/Loss in Inventory: FS Items6PRGRPProduct groupnvarchar180
32TF592AElimination of IU Profit/Loss in Inventory: FS Items7PRGRPProduct groupnvarchar180
TOPKnowledge Base
33ISMITPRSDB: Symptom Trigger Problem7PRGRPSDB: Code Group - Problem Damagenvarchar80
TOPKorea
34T7KRS2Separation payment average calculation period3PRGRPPayroll groupingnvarchar20
35T7KRSAPayroll grouping2PRGRPPayroll groupingnvarchar20
36T7KRSBPayroll grouping text3PRGRPPayroll groupingnvarchar20
37T7KRSCAssign payrolls to payroll group2PRGRPPayroll groupingnvarchar20
TOPMaster Data
38MDDMAPMapping Table for External User for MRP Evaluations9PRGRPName of the product groupnvarchar180
TOPMaterial Master
39MPGD_TMPFile for Incorrect Data in Direct Input7PRGRPPlanning materialnvarchar180
40MVGDMaterial master/product group material version4PRGRPPlanning materialnvarchar180
TOPMaterial Requirements Planning
41MPNPGRLinking an MPN-MRP Set with a Product Group5PRGRPName of the product groupnvarchar180
TOPPortugal
42PA0337HR Master Record: Infotype 0337 (Prof.Classification - PT)29PRGRPProfessional groupnvarchar10
43T5PP2HR-PT: Professional categories7PRGRPProfessional groupnvarchar10
44T5PS2HR-PT: Professional categories6PRGRPProfessional groupnvarchar10
TOPProfitability Analysis
45CEPRINTTable for description of print statement for CO-PA forms24PRGRPCO-PA print groupnvarchar20
TOPPublic Sector
46T7PBSWB1BObsolete : Do not use6PRGRPProcess Groupnvarchar40
47T7PBSWB1EAssignment of process scenario7PRGRPProcess Groupnvarchar40
48T7PBSWB2EProcess group3PRGRPProcess Groupnvarchar40
49T7PBSWB2ETText for process group4PRGRPProcess Groupnvarchar40
50T7PBSWB4ASpecification of Process group3PRGRPProcess Groupnvarchar40
TOPSales Plan
51P445VSales and Operations Planning: Versions3PRGRPName of the product groupnvarchar180
52PGMIProduct Group/Member Allocation3PRGRPName of the product groupnvarchar180
53PGPLSales & Operations Planning (SOP)8PRGRPName of the product groupnvarchar180
54PGPLESOP Characteristic Values3PRGRPName of the product groupnvarchar180
55PGZUProduct Group/Member Quantity Conversions3PRGRPName of the product groupnvarchar180