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

46 columns | Print definition?ERP 6.0  | STUFE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FAGL_011PCIFin. Statement Version: Items (Without Internal Node IDs)8STUFEFinancial statement item hierarchy levelnvarchar20
2FAGL_011PC_XBRLFin. Statement Version: Items in Financial Statement Version9STUFEFinancial statement item hierarchy levelnvarchar20
3FAGL_GCDPC_VERGCD Revision: Element Relationships11STUFEFinancial statement item hierarchy levelnvarchar20
4FAGL_GCDPC_XBRLGCD-Structure: Element Relationships9STUFEFinancial statement item hierarchy levelnvarchar20
5KONVConditions (Transaction Data)60STUFELevel (in multi-level BOM explosions)decimal20
6TKKR1Hierarchy Summarization (Fields)4STUFENumber of Hierarchy Levelnvarchar30
TOPAdvertising Management
7JJT179IS-M/AM: Product Hierarchy3STUFEIS-M/AM: Level Number in Product Hierarchynvarchar10
8TJJ99IS-M/AM: Control Dynamic Condition Maintenance5STUFEIS-M: Level Within a Conditions Groupingnvarchar20
TOPAllocation
9AUBFDocument Flow SAP Retail (Allocation Table, Promotions...)8STUFELevel of the document flow recordnvarchar20
TOPAustria
10T5A1WSI Age Levels1STUFENumbering of Age Levelnvarchar20
11T5A2JIncome Tax According to Effective Pay Scale3STUFESequence Numbernvarchar30
TOPBank Components
12JBTAUSVERDisbursement Procedure (Loans) - Customizing3STUFELevel Number (Short) for Internal Numberingnvarchar20
TOPBasic Functions
13VBFASales Document Flow20STUFELevel of the document flow recordnvarchar20
TOPContract Accounts Receivable and Payable
14FKK_PAYMENTRELFICA: Payment Release3STUFEFI Workflow Levelnvarchar20
TOPCross-Application Components
15VKONVConditions (Transaction Data)60STUFELevel (in multi-level BOM explosions)decimal20
16VVBFASales Document Flow20STUFELevel of the document flow recordnvarchar20
TOPData Collection
17TKED2Data mining display object4STUFEObject levelnvarchar60
TOPDenmark
18T5M8UHierarchy Structure for DA Statistics Job Key4STUFEHierarchy level for DA/DS statisticsnvarchar20
19T5M9KHierarchy Structure for DA Statistics Job Key5STUFEHierarchy level for DA/DS statisticsnvarchar20
20T5M9MHierarchy Structure for DS Statistics Training Key5STUFEHierarchy level for DA/DS statisticsnvarchar20
TOPFinancial Accounting
21VBWF09People with Release Authorization for Document Parking4STUFEFI Workflow Levelnvarchar20
22VBWF15People with Release Authorization for Document Parking4STUFEFI Workflow Levelnvarchar20
TOPGeneral Ledger Accounting
23FAGL_011PCFin. Statement Structure: Items in Fin. Statement Structure9STUFEFinancial statement item hierarchy levelnvarchar20
TOPMarketing, Accounting and Pricing
24OIC_KONVConditions (Procedure Data)80STUFELevel (in multi-level BOM explosions)decimal20
TOPMaterial Maintenance
25T179Materials: Product Hierarchies3STUFENumber of the level in the product hierarchynvarchar10
TOPMedia Product Sales and Distribution
26TJKSDHIERSTRUCHierarchy Levels4STUFEHierarchical Filter Levelnvarchar30
TOPOperative Structures
27PRPSWBS (Work Breakdown Structure) Element Master Data21STUFELevel in Project Hierarchytinyint30
TOPPeriodical Sales and Distribution
28JKONVIS-M/SD: Conditions (Transaction Data)60STUFELevel (in multi-level BOM explosions)decimal20
TOPProduction Orders
29AFKOOrder Header Data PP Orders92STUFELevel (in multi-level BOM explosions)decimal20
TOPPublic Sector
30T510QCost-of-Living Allowances3STUFEComponents of Family-Related Bonus and COLAnvarchar20
31T510QNGuaranteed Payments: COLA/Family-Related Bonus4STUFEComponents of Family-Related Bonusnvarchar20
32T5D77Maximum Remuneration for Official Housing3STUFEIndex for Official Housing Gross Amountnvarchar20
33T5DPBS3DTVoeD: Structural Adjustment10STUFECost-of-Living Allowance Level 1/2nvarchar40
TOPRecycling Administration Core Functions
34J_7LC66REA Data Filters: Doc. Flow Evaluation Single Access5STUFELevel of the document flow recordnvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
35NBQS_ZUSCHLBQS: Assignment of Module to Surcharge and Discount7STUFEBQS: Classification According to BQSnvarchar10
36NWCH91Fee Breakdown Results19STUFELevelnvarchar20
37TNWCH94LSFees: Limitation Levels5STUFELevelnvarchar20
38TNWCH98SFees: Limit Levels for Breakdown Codes4STUFELevelnvarchar20
39TNWCH99SFees: Breakdown Codes for Limit Levels4STUFELevelnvarchar20
40TNWCHHONPOS98SFee Item Data for Codes - Limit Levels5STUFELevelnvarchar20
41TNWCHHONPOS99SFee Item Data for Codes - Breakdown Code5STUFELevelnvarchar20
TOPScreen Sequence Control
42T185Screen sequence control: Paths between processing locations10STUFEIncrease or purge next screen memorydecimal10
TOPSimulation
43VSAFKO_CNVersion: Order header data for PP orders93STUFELevel (in multi-level BOM explosions)decimal20
44VSPRPS_CNVersion: WBS Element (Work Breakdwn Struc. Elem.) Mast. Data22STUFELevel in Project Hierarchytinyint30
TOPTemplates
45PRPSSStandard WBS Element (WBS element) - Master Data21STUFELevel in Project Hierarchytinyint30
TOPTransaction Management
46VTBRELE1Transaction release: Change history8STUFETransaction release: Number of stepsnvarchar10