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

74 columns | Print definition?ERP 6.0  | VORGA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPF15/XXBPDJF15 FI DUMMY7VORGAnvarchar40
2T066Screen Selection, Invoice Verification2VORGATransaction/eventnvarchar20
3T069QControl Data for Source Determination and Checking2VORGATransaction/eventnvarchar20
4T160SAP Transaction Control, Purchasing7VORGATransaction/eventnvarchar20
5T165KCopying Options: Header Texts2VORGATransaction/eventnvarchar20
6T165PCopying Options: Item texts2VORGATransaction/eventnvarchar20
7T167Number Range Management for Purchasing Master Data2VORGATransaction/eventnvarchar20
8T167TTransaction Description3VORGATransaction/eventnvarchar20
9T168Screen Control, Purchasing2VORGATransaction/eventnvarchar20
10T168FFunction Codes, Purchasing2VORGATransaction/eventnvarchar20
11T169WPosting Strings (Values) for SAPMM08R1VORGATransaction Type in AG08 (Internal Document Type)nvarchar20
12T340WM Transactions4VORGATransaction typenvarchar20
13T342Control of Screen Sequence in WM6VORGATransaction typenvarchar20
14T450PTransaction control for maintaining ind. requirements4VORGATransaction/eventnvarchar20
15TABWVDefault transaction types2VORGAPosting transactions in Asset Accountingnvarchar20
16TMQ1Number Ranges for Quota Arrangement2VORGATransaction/eventnvarchar20
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
17CRM_CATJCATT - Log Index4VORGACATT - Process descriptionnvarchar120
TOPAccounting
18RPSCOProject info database: Costs, revenues, finances8VORGABudget Type Budgeting/Planningnvarchar40
19RPSQTProject info database: quantities7VORGABudget Type Budgeting/Planningnvarchar40
TOPBasic Functions
20T012AAllocation pmnt methods -> Bank trans.9VORGATransaction type for determining bank termsnvarchar80
21T012BDescription of trans. types5VORGATransaction type for determining bank termsnvarchar80
22T012CTerms for bank transactions5VORGATransaction type for determining bank termsnvarchar80
23T028HAllocate Manual to Internal Transactions8VORGATransaction type for determining bank termsnvarchar80
24TVRMAVRepairs Procedure: Times4VORGARepair procedure: Actionnvarchar30
TOPBudgeting
25BUVORGAMapping rules for migration from FBS to BCS - Field VORGA1VORGABudget Type Budgeting/Planningnvarchar40
TOPBudgeting and Availability Control
26FMKOBPLocal Authority Funds Management Additional Data8VORGABudget Type Budgeting/Planningnvarchar40
TOPBusiness Navigator
27DF40DDiagam Management Information14VORGAOrganization viewnvarchar10
TOPCATT Computer Aided Test Tool
28CATJCATT - Log archive index3VORGACATT - Process descriptionnvarchar120
29CATKCATT: Log Process Data2VORGACATT - Process descriptionnvarchar120
TOPContract Accounts Receivable and Payable
30TFK012AAllocation pmnt methods -> Bank trans.6VORGACarteiranvarchar80
TOPFinancial Accounting
31T076AAssign Payment Advice Notes to Posting Rules12VORGATransaction type for determining bank termsnvarchar80
TOPFunds Management
32BPBKDoc.Header Controlling Obj.4VORGABudget Type Budgeting/Planningnvarchar40
33BPDGTotal Values Entry Document7VORGABudget Type Budgeting/Planningnvarchar40
34BPDJAnnual Values Entry Document7VORGABudget Type Budgeting/Planningnvarchar40
35BPDPPeriod Values Entry Document7VORGABudget Type Budgeting/Planningnvarchar40
36BPEGLine Item Overall Values Controlling Obj.15VORGABudget Type Budgeting/Planningnvarchar40
37BPEJLine Item Annual Values Controlling Obj.17VORGABudget Type Budgeting/Planningnvarchar40
38BPEPLine Item Period Values Controlling Obj.45VORGABudget Type Budgeting/Planningnvarchar40
39BPGETotals Record for Total Value Controlling obj.9VORGABudget Type Budgeting/Planningnvarchar40
40BPGVPrel.entry, overall11VORGABudget Type Budgeting/Planningnvarchar40
41BPJATotals Record for Annual Total Controlling Obj.10VORGABudget Type Budgeting/Planningnvarchar40
42BPJVPrel.entry - annual values12VORGABudget Type Budgeting/Planningnvarchar40
43BPPETotals Record for Period Values Controlling Obj.10VORGABudget Type Budgeting/Planningnvarchar40
44BPTXBudgeting Text9VORGABudget Type Budgeting/Planningnvarchar40
45FM01DFBudget Type: Assignment to Cover Eligibility4VORGABudget Type Budgeting/Planningnvarchar40
46FM01FRG2Assign Release Approval Groups to Activity4VORGABudget Type Groupnvarchar40
47FMBEFI-FM Cash Levels7VORGACO Business Transactionnvarchar40
48FMEPFI-FM Line Items8VORGACO Business Transactionnvarchar40
49FMFRGASGNAssign Transactions to Release Approval Groups4VORGABudget Type Groupnvarchar40
50FMREFActive availability ctrl: Cross commitments reference table7VORGABudget Type Budgeting/Planningnvarchar40
51FMSUFI-FM Totals Records8VORGACO Business Transactionnvarchar40
52TBP4BAssignment of Budget Subtypes to Budget Types2VORGABudget Type Budgeting/Planningnvarchar40
53TBP4CSelect Budget Types for Subdivision3VORGABudget Type Budgeting/Planningnvarchar40
54TBPCEPVCover Eligility Profile: Control4VORGABudget Type Budgeting/Planningnvarchar40
55TBUDVGIS-PS Budget Types for Payment/Commitment Budget1VORGABudget Type Budgeting/Planningnvarchar40
56TBUDVGTIS-PS Budget Types: Texts2VORGABudget Type Budgeting/Planningnvarchar40
TOPInformation System
57BIWTCSH_CVTexts: Payment Characteristics3VORGABudget Type Budgeting/Planningnvarchar40
58BIW_CSH_CVConversion Table for Payments3VORGABudget Type Budgeting/Planningnvarchar40
TOPInformation system
59FMKF_REPTERMKey Figure Terms for Reporting Because of New Budget Tables7VORGAKey Figures - Budget Typenvarchar40
TOPMaintenance History
60/OLC/PMCO_OPOLC: PMCO for operations10VORGABudget Type Budgeting/Planningnvarchar40
61PMCOCost structure of maintenance order10VORGABudget Type Budgeting/Planningnvarchar40
62PMCO_OPCost structure of maintenance order10VORGABudget Type Budgeting/Planningnvarchar40
TOPMaintenance Orders
63PMCOQTQuantity structure for the maintenance order10VORGABudget Type Budgeting/Planningnvarchar40
64PMCOQT_OPQuantity structure for the maintenance order10VORGABudget Type Budgeting/Planningnvarchar40
TOPOrders for Projects
65FMSPCopy FMSU table order to project9VORGACO Business Transactionnvarchar40
TOPPayment Transactions
66T045TUser ID for bank transactions4VORGAType of Banking Transactionnvarchar20
TOPPegging, Grouping, and Distribution
67DIS_TOBJS_FMSUDistribution: Objects distributed to per Group WBS (Cash)9VORGACO Business Transactionnvarchar40
TOPPurchasing
68TMEDPurchasing Various Control Parameters2VORGATransaction/eventnvarchar20
TOPRetail Pricing
69WKBKPricing document: header12VORGAProcedure in sales price calculationsnvarchar20
TOPSales
70TVRMAVKRepair Procedure: Actions2VORGARepair procedure: Actionnvarchar30
71TVRMAVTRepair Procedure: Action Texts3VORGARepair procedure: Actionnvarchar30
TOPSimulation
72VSRPSCO_CNVersion: Cumulation table for project reporting9VORGABudget Type Budgeting/Planningnvarchar40
TOPWarehouse Management
73LTAPTransfer order item40VORGATransfer procedurenvarchar20
74T342TAssignment of Title Bar to PF Status5VORGATransaction typenvarchar20