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

64 columns | Print definition?ERP 6.0  | FORML

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T5C1FTotal Transaction Types9FORMLFormulanvarchar20
2T5D2GTax Procedure (D)11FORMLEstimation Formula for Annual Wagenvarchar10
3T7RU2PHR-RU Forms - background4FORMLForm Namenvarchar40
4T7RU8PHR-RU Forms - Fields4FORMLForm Indicatornvarchar40
5T7RU9PHR-RU Forms - Helps4FORMLForm Indicatornvarchar40
6T7RUFAFlexible Employee Payroll Data (Totals)3FORMLVolume Name for Formnvarchar40
7T7RUFBFlexible Employee Data (Contants)3FORMLVolume Name for Formnvarchar40
8T7RUFCFlexible Employee Payroll Data (Forms Name)3FORMLVolume Name for Formnvarchar40
9T7RUFORMCONSTInitial Values for Form Fields (Russia)5FORMLForm Namenvarchar40
TOPAustria
10T5A9ACreated Statement of Employment (A)7FORMLForm Namenvarchar160
TOPConsolidation
11TF325Period Categories3FORMLFormulanvarchar600
TOPData Collection
12T242DData transfer control12FORMLKey figure formula linenvarchar600
TOPData Transfer
13KCDRFData Transfer Rules: Formulas5FORMLKey figure formula linenvarchar600
TOPNetherlands
14T5N2SSpecial Indicator Codes (Tax Authority)3FORMLWage Type for Special Tax Indicatornvarchar40
TOPPayroll
15T5H1JSI cumulation report control table from 19972FORMLSI summary form codenvarchar40
16T5H1KT5H1J texts3FORMLForm Indicatornvarchar40
17T5H1OControl table to private pension fund monthly report2FORMLPrivate pension report form codenvarchar40
18T5H2BYear-end (tax) certificates elements2FORMLForm Indicatornvarchar40
19T5H3APayroll journal parameter table2FORMLPayroll journal form codenvarchar40
20T5H3BText table of payroll journal parameter table3FORMLPayroll journal form codenvarchar40
21T5HS2HR-H: Havi bevallás - változók paraméterei (M lap)2FORMLUrlap-kódnvarchar40
22T5HS3HR-H: Havi bevallás - APEH lapok megfeleltetése urlapoknak3FORMLUrlap-kódnvarchar40
23T5HS6HR-H: Havi bevallás - változók paraméterei (A lap)2FORMLUrlap-kódnvarchar40
24T5HV7Bevallási adatok adózónként (havi adóbevallás)7FORMLUrlap-kódnvarchar40
25T5HV9Bérelemek váll.összesíto ellenorzéshez (havi adóbevallás)2FORMLUrlapnévnvarchar40
26T5HVANyomtatvány és SAP urlap összerendelése (havi bevallás)5FORMLUrlap-kódnvarchar40
27T5HVBHavi adó EAZON és mezokódok összerendelése1FORMLUrlap-kódnvarchar40
28T5HVCÉrvényes nyomtatványkódok (havi bevallás)6FORMLUrlap-kódnvarchar40
29T5HVFVállalati összesíto - tábla szelekciós képernyohöz3FORMLUrlapnévnvarchar40
30T5HVIÖsszegmezok képzése - vállalati összesíto (havi bev. v2)6FORMLUrlapnévnvarchar40
31T5HVKKülso bevallási adatok adózónként (havi bevallás)7FORMLUrlap-kódnvarchar40
32T5T4ALines of forms2FORMLForm Indicatornvarchar40
33T5T4BText of lines of forms3FORMLForm Indicatornvarchar40
34T5T4GParameter configuration personal reportts for output by ALV4FORMLForm Indicatornvarchar40
35T7BG4AForms - field content2FORMLForm Indicatornvarchar40
36T7BG4BForms - field properties3FORMLForm Indicatornvarchar40
37T7BG4CRecap - Groups3FORMLForm Indicatornvarchar40
38T7BG4DRecap - Subgroups3FORMLForm Indicatornvarchar40
39T7BG4ERecap - Field content2FORMLForm Indicatornvarchar40
40T7RO4AForms - field content2FORMLForm Indicatornvarchar40
41T7RO4BForms - field properties3FORMLForm Indicatornvarchar40
42T7RO4GReporting engine - optional field names6FORMLForm Indicatornvarchar40
43T7SK4AItems of payroll form2FORMLForm Indicatornvarchar40
44T7SK4BTexts of summary groups of payroll form3FORMLForm Indicatornvarchar40
45T7SK4GKonfigurace parametru personálních sestav pro výpis v ALV4FORMLZnak formuláranvarchar40
46T7UAFORMCONSTInitial Values for Form Fields (Ukraine)3FORMLOutput form variant (reporting)nvarchar200
47T7UAFORMCONST_TInitial Values for Form Fields (Ukraine)4FORMLOutput form variant (reporting)nvarchar200
TOPPayroll General Parts
48T512DLine Layout in Window3FORMLForm namenvarchar40
49T512EForm-Related Control of Wage Types3FORMLForm namenvarchar40
50T512FForm Windows3FORMLForm namenvarchar40
51T512GSupplementary Group Texts4FORMLForm namenvarchar40
52T512NRule Table for Form3FORMLForm namenvarchar40
53T512PForm Background4FORMLForm namenvarchar40
54T512QInformation in Fixed Positions3FORMLForm namenvarchar40
55T512RCumulation Wage Types in Forms3FORMLForm namenvarchar40
56T512STexts for Cumulation Wage Types in Forms4FORMLForm namenvarchar40
57T514DForm Index3FORMLForm namenvarchar40
58T514VForm Name Texts4FORMLForm namenvarchar40
TOPSweden
59T5SXMXML Node Mapping with Payslip Form3FORMLForm namenvarchar40
TOPTime Tickets
60T703FIncentive Wages: Calculation Rules for Premium Formulas5FORMLFormula for determining premiumnvarchar700
TOPTraining and Event Management
61T77VBOutput Sequence of Text Elements2FORMLForm Namenvarchar160
62T77VDOutput Control: Correspondence4FORMLForm Namenvarchar160
63T77VPLog File: Correspondence in Training and Event Management17FORMLForm Namenvarchar160
TOPWork Center
64CRCOAssignment of Work Center to Cost Center14FORMLFormula key for costingnvarchar60