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

180 tablesERP 6.0 

Personnel Management :: Personnel Administration :: Spain
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0061851HR Master Record Infotype 0061 (Social Insurance - Spain)Spain
2ERP EHP76.0PA0062611HR master record Infotype 0062 (Tax Spain))Spain
3ERP EHP76.0PA0090401HR Master Record Infotype 0090 (Additional Income)Spain
4ERP EHP76.0PA0092491HR master record Infotype 0092 (Seniority Spain)Spain
5ERP EHP76.0PA04801091HR master record for infotype 0480Spain
6ERP EHP76.0PA0714321HR master record Infotype 0714Spain
7ERP EHP76.0PA0768481Personal dataSpain
8ERP EHP76.0PA0799641AFI message dataSpain
9ERP EHP76.0PA0887521HR master record, infotype 0887Spain
10ERP EHP76.0PA0968961HR master record infotype 0968Spain
11ERP EHP76.0PA3231441Personnel master record infotype 3231Spain
12ERP EHP76.0PB04801091HR master record infotype 0480 (Candidates)Spain
13ERP EHP76.0T5E01161Personnel areas and subareasSpain
14ERP EHP76.0T5E02101Company tax dataSpain
15ERP EHP76.0T5E0351IA/ID and NID healthcare companiesSpain
16ERP EHP76.0T5E0451Registered company and work center namesSpain
17ERP EHP76.0T5E0591Social Insurance branch officesSpain
18ERP EHP76.0T5E0651Social Insurance contributing companiesSpain
19ERP EHP76.0T5E07101Health services amounts for company contributing to S.I.Spain
20ERP EHP76.0T5E08231Time-dependent characteristics of CACsSpain
21ERP EHP76.0T5E1091Extension of pay scalesSpain
22ERP EHP76.0T5E1131Assignation of head office to corporate groupSpain
23ERP EHP76.0T5E12221Assignment of Social Insurance centerSpain
24ERP EHP76.0T5E1T41Corporate group textsSpain
25ERP EHP76.0T5E2051ProvincesSpain
26ERP EHP76.0T5E2541Operations for contract type changeSpain
27ERP EHP76.0T5E25T41Operation texts for contract category changeSpain
28ERP EHP76.0T5E2T51Contract type keys for Social insuranceSpain
29ERP EHP76.0T5E3091Adjust Social Insurance reasons and actionsSpain
30ERP EHP76.0T5E3141Actions and situations for affiliation messagesSpain
31ERP EHP76.0T5E3221Healthcare company codes - Social InsuranceSpain
32ERP EHP76.0T5E3361Assign countries to Social Insurance key (RED System)Spain
33ERP EHP76.0T5E3431Pay scale codesSpain
34ERP EHP76.0T5E3541Towns according to INEMSpain
35ERP EHP76.0T5E3621Reasons for legal situation of unemploymentSpain
36ERP EHP76.0T5E36T41Texts: Reasons for legal situation of unemploymentSpain
37ERP EHP76.0T5E37151Estimation of annual incomeSpain
38ERP EHP76.0T5E3831Reasons for IRPF percentage changeSpain
39ERP EHP76.0T5E3931Check digit for specifying taxpayer reference number (NIF)Spain
40ERP EHP76.0T5E3T41Keys for Social insurance contribution groupsSpain
41ERP EHP76.0T5E40391Employment tax deduction percentagesSpain
42ERP EHP76.0T5E4191Payment subkeysSpain
43ERP EHP76.0T5E42231Contract types for Social InsuranceSpain
44ERP EHP76.0T5E4381Contribution bases for non-industrial risksSpain
45ERP EHP76.0T5E4481Contribution bases for IA and ID quotasSpain
46ERP EHP76.0T5E4571Social Insurance contribution typesSpain
47ERP EHP76.0T5E4661Social Insurance epigraphsSpain
48ERP EHP76.0T5E4861Groups of professional categoriesSpain
49ERP EHP76.0T5E4B41Employment textsSpain
50ERP EHP76.0T5E4C61Employments (IA and ID contribution)Spain
51ERP EHP76.0T5E4D41CNAE textsSpain
52ERP EHP76.0T5E4E61CNAE: National Business Activities ClassificationSpain
53ERP EHP76.0T5E4F21CNAES entity tableSpain
54ERP EHP76.0T5E4G51CNAE ocupational permissibilitySpain
55ERP EHP76.0T5E4H41CNAE textsSpain
56ERP EHP76.0T5E4T41Description of Social Insurance branch-office typesSpain
57ERP EHP76.0T5E5071Minimum bases for part-time contractsSpain
58ERP EHP76.0T5E5191Seniority bonusesSpain
59ERP EHP76.0T5E5251Seniority calculation methodsSpain
60ERP EHP76.0T5E53131Amounts of seniority bonusesSpain
61ERP EHP76.0T5E5521Social Insurance office typesSpain
62ERP EHP76.0T5E5761Union duesSpain
63ERP EHP76.0T5E5T41Texts of Social Insurance contribution typesSpain
64ERP EHP76.0T5E60211Contract entity according to the companySpain
65ERP EHP76.0T5E61141Contract transformations allowedSpain
66ERP EHP76.0T5E6471Length of temporary contracts according to Soc. Ins. Admin.Spain
67ERP EHP76.0T5E6591Work schedule in part-time contracts according Soc. Ins. Ad.Spain
68ERP EHP76.0T5E6681Contract validity acc. to Soc. Insurance, laws and decreesSpain
69ERP EHP76.0T5E6791Special contracts according to Social InsuranceSpain
70ERP EHP76.0T5E6871Assignment of contracts to groupsSpain
71ERP EHP76.0T5E6A21Contract setSpain
72ERP EHP76.0T5E6B21Contract groupersSpain
73ERP EHP76.0T5E6C41Sets of contracts and associated wage typesSpain
74ERP EHP76.0T5E6D61Contribution calculation for sets of contractsSpain
75ERP EHP76.0T5E6F81Calculation methodsSpain
76ERP EHP76.0T5E6I81Contract texts according to companySpain
77ERP EHP76.0T5E6J41Contract texts according to Social InsuranceSpain
78ERP EHP76.0T5E6K41Contract grouper textsSpain
79ERP EHP76.0T5E6L41Calculation method textsSpain
80ERP EHP76.0T5E6M41Contract set textsSpain
81ERP EHP76.0T5E6T41Title textsSpain
82ERP EHP76.0T5E7091INEM officesSpain
83ERP EHP76.0T5E7531Work center commitment codeSpain
84ERP EHP76.0T5E7651Allowance group codeSpain
85ERP EHP76.0T5E7731Academic qualification according to INEM codeSpain
86ERP EHP76.0T5E7I41Spanish Office of Employment (INEM) branch textsSpain
87ERP EHP76.0T5E8M41Reasons for IRPF percentage changeSpain
88ERP EHP76.0T5E8S51Assignation of professional categories to modifiersSpain
89ERP EHP76.0T5E8T21Modifiers for professional categoriesSpain
90ERP EHP76.0T5E8U41Texts of professional categories modifiersSpain
91ERP EHP76.0T5E9141Assignation of customer subtypes to legal classesSpain
92ERP EHP76.0T5EA041Seniority calculation proceduresSpain
93ERP EHP76.0T5EA0T41Calculation procedure textsSpain
94ERP EHP76.0T5EA151Seniority payment methodsSpain
95ERP EHP76.0T5EA1T41Payment method textsSpain
96ERP EHP76.0T5EA241Seniority payment symbolsSpain
97ERP EHP76.0T5EA2T41Payment symbol textsSpain
98ERP EHP76.0T5EA321Definition of valuation methodsSpain
99ERP EHP76.0T5EA3T41Valuation method textsSpain
100ERP EHP76.0T5EA451Associate valuation wage type with valuation methodSpain
101ERP EHP76.0T5EA551Calculation sequences by payment methodSpain
102ERP EHP76.0T5EA661Actions and reasons affecting senioritySpain
103ERP EHP76.0T5EAE31Business activitiesSpain
104ERP EHP76.0T5ECP91Generation of personal calendarSpain
105ERP EHP76.0T5ED121Place typeSpain
106ERP EHP76.0T5ED1T41Place typeSpain
107ERP EHP76.0T5ED221VarianceSpain
108ERP EHP76.0T5ED2T41VarianceSpain
109ERP EHP76.0T5ED321Type of workSpain
110ERP EHP76.0T5ED3T41Work typeSpain
111ERP EHP76.0T5ED421Specific physical activitySpain
112ERP EHP76.0T5ED4T41Specific physical activitySpain
113ERP EHP76.0T5ED521Contact methodSpain
114ERP EHP76.0T5ED5T41Contact methodSpain
115ERP EHP76.0T5ED621Injured body partSpain
116ERP EHP76.0T5ED6T41Injured body partSpain
117ERP EHP76.0T5ED721Description of the injurySpain
118ERP EHP76.0T5ED7T41Description of the injurySpain
119ERP EHP76.0T5ED821Material agentsSpain
120ERP EHP76.0T5ED8T41Material agentsSpain
121ERP EHP76.0T5ED921Worker employment codesSpain
122ERP EHP76.0T5ED9T41Description of worker employment codesSpain
123ERP EHP76.0T5EDH121Local tax offices/authoritiesSpain
124ERP EHP76.0T5EF151Infotypes used to calculate DAQ fieldsSpain
125ERP EHP76.0T5EF261Directory of INEM forms generatedSpain
126ERP EHP76.0T5EF361Directory of INEM forms generatedSpain
127ERP EHP76.0T5EF441Templates for INEM formsSpain
128ERP EHP76.0T5EF551Definition of assignment treesSpain
129ERP EHP76.0T5EF631DDIC structures for logical formsSpain
130ERP EHP76.0T5EF7101DAQ fields definition extensionSpain
131ERP EHP76.0T5EFI71Severance payment calculationSpain
132ERP EHP76.0T5EG061Gross/net model featuresSpain
133ERP EHP76.0T5EG1101Special RuleSpain
134ERP EHP76.0T5EG241Special rule descriptionSpain
135ERP EHP76.0T5EG391Special rule calculationSpain
136ERP EHP76.0T5EG4121Features of non-exempt amount modelSpain
137ERP EHP76.0T5EG561Features of relationship with other debts modelSpain
138ERP EHP76.0T5EG631Default valuesSpain
139ERP EHP76.0T5EG9101Garnishee feeSpain
140ERP EHP76.0T5EI1101Employment tax deduction ratesSpain
141ERP EHP76.0T5EI291Wage exempt of employment tax deductionSpain
142ERP EHP76.0T5EI361Employment tax control constantsSpain
143ERP EHP76.0T5EI471Employment tax amount constantsSpain
144ERP EHP76.0T5EI5121Wage types valid for Spanish IRS evaluationsSpain
145ERP EHP76.0T5EI661Arrears by period and grouperSpain
146ERP EHP76.0T5EI731Default behaviour for arrears groupersSpain
147ERP EHP76.0T5EI891Lowering of deduction type for challenged personsSpain
148ERP EHP76.0T5EIA71Payment keysSpain
149ERP EHP76.0T5EII51Employment tax control constant textsSpain
150ERP EHP76.0T5EIJ51Texts of unemployment tax amount constantsSpain
151ERP EHP76.0T5EL1111Protected data access logSpain
152ERP EHP76.0T5EL231Protected data logical filesSpain
153ERP EHP76.0T5EL341Last record of access to protected data by userSpain
154ERP EHP76.0T5EL481Protected TemSe fieldsSpain
155ERP EHP76.0T5EL5111Protected data access logSpain
156ERP EHP76.0T5EL691LOPD. High-level data fields and structuresSpain
157ERP EHP76.0T5EL772Log for accessing protected data for XML filesSpain
158ERP EHP76.0T5EMA41Legal application message texts, SpainSpain
159ERP EHP76.0T5EP151Form managementSpain
160ERP EHP76.0T5EP231Forms management 2Spain
161ERP EHP76.0T5EPT51Forms management: Description of formSpain
162ERP EHP76.0T5ER1181Employment regulation filesSpain
163ERP EHP76.0T5ER241Calendar configuration for ERESpain
164ERP EHP76.0T5ES181Marine employees: Canary Is. recordSpain
165ERP EHP76.0T5ES2211Allowance formulasSpain
166ERP EHP76.0T5ES3151Contract processing methodsSpain
167ERP EHP76.0T5ES461Legal regulationsSpain
168ERP EHP76.0T5ES561Processing method keysSpain
169ERP EHP76.0T5ES691Allowance formulasSpain
170ERP EHP76.0T5ES721Incentive groupsSpain
171ERP EHP76.0T5ES841CAC typesSpain
172ERP EHP76.0T5ES951Processing method keysSpain
173ERP EHP76.0T5EST51Incentive groupsSpain
174ERP EHP76.0T5EU1171Payroll results containersSpain
175ERP EHP76.0T5EU231Generic table of situations and possible optionsSpain
176ERP EHP76.0T5EU351Assignation of options to situationsSpain
177ERP EHP76.0T5EU421Generic table of situations and possible optionsSpain
178ERP EHP76.0T5EUB51Generic table of situations and possible optionsSpain
179ERP EHP76.0T5EUD41Generic table of situations and possible optionsSpain
180ERP EHP76.0T5EVP31Street identifiersSpain