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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

163 tablesERP 6.0 

Payroll :: Germany :: Net :: GarnishmentCession
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0P01PF_RT_EP91Garnishment Pr. of Origin: Results of Garnishment Calc.GarnishmentCession
2ERP EHP76.0P01PF_TILG61Garnishment of Principle of Origin: Repayment AmountsGarnishmentCession
3ERP EHP76.0T5D6H61Garnishment Pension Scheme Age Pay ScalesGarnishmentCession
4ERP EHP76.0T5DRC71AVmG (BVV): Assignment Pay Scale to Contract ModelGarnishmentCession
Payroll :: Germany :: Net :: Social Insurance
ProductVersionTableColumnsIndexesDescriptionModule
5ERP EHP76.0P01BD_DBFE41Data Module Error in Notification Proc. Business Data Maint.Social Insurance
6ERP EHP76.0P01BD_DBKA121Data Module Different Correspondence AddressSocial Insurance
7ERP EHP76.0P01BD_DSBD371Business Data Maintenance Data RecordSocial Insurance
8ERP EHP76.0P01BD_HIST161History Management for Business Data MaintenanceSocial Insurance
9ERP EHP76.0P01BD_STAT192Data Module Alternative Correspondence AddressSocial Insurance
10ERP EHP76.0P01BM_DBAN81Address Data Modules for PPO DEUEV NotificationsSocial Insurance
11ERP EHP76.0P01BM_DBEU41Data Modules EU Insurance Number of PPO DEUEV NotificationsSocial Insurance
12ERP EHP76.0P01BM_DBFE41Data Modules - Errors from PPO DEUEV ConfirmationsSocial Insurance
13ERP EHP76.0P01BM_DBGB81Data Modules Birth Details of PPO DEUEV NotificationsSocial Insurance
14ERP EHP76.0P01BM_DBME131Data Modules Reporting Facts of PPO DEUEV NotificationsSocial Insurance
15ERP EHP76.0P01BM_DBNA81Data Modules Name of PPO DEUEV NotificationsSocial Insurance
16ERP EHP76.0P01BM_DSME321Data Records Notification of PPO DEUEV NotificationsSocial Insurance
17ERP EHP76.0P01BM_HIST161Management of Status History for PPO DEUEV NotificationsSocial Insurance
18ERP EHP76.0P01BM_STAT272Control Records for PPO DEUEV NotificationsSocial Insurance
19ERP EHP76.0P01BV_DBFE41Error Data Module for PPO Contribution Collection Proced.Social Insurance
20ERP EHP76.0P01BV_HIST161History Admin. for PPO Contribution Survey ProcedureSocial Insurance
21ERP EHP76.0P01BV_KEAN32Management of Employee IDSocial Insurance
22ERP EHP76.0P01BV_MELD471Data Record for PPO Collection of ContributionsSocial Insurance
23ERP EHP76.0P01BV_STAT222Status Table for PPO Contribution Collect. Notif. ProcedureSocial Insurance
24ERP EHP76.0P01D3_DBAN81DEUEV Confirmation: Address Data ModuleSocial Insurance
25ERP EHP76.0P01D3_DBEU41DEUEV Confirmation: Europ. Insurance Number Data ModuleSocial Insurance
26ERP EHP76.0P01D3_DBFE41DEUEV Confirmtion: Data Module - ErrorSocial Insurance
27ERP EHP76.0P01D3_DBGB81DEUEV Confirmation: Birth Details Data ModuleSocial Insurance
28ERP EHP76.0P01D3_DBGZ91DEUEV Confirmation: Data Module Slide ZoneSocial Insurance
29ERP EHP76.0P01D3_DBKS81DEUEV Confirmation: Miners'/Sailors' Insurance Data ModuleSocial Insurance
30ERP EHP76.0P01D3_DBKV201DEUEV Confirmation: Data Module Health InsuranceSocial Insurance
31ERP EHP76.0P01D3_DBME131DEUEV Confirmation: Data Module - Reporting FactsSocial Insurance
32ERP EHP76.0P01D3_DBMM61DEUEV Confirmation: Data Module SHI Monthly DeclarationSocial Insurance
33ERP EHP76.0P01D3_DBMS61DEUEV Confirmation: Data Module SI AdjustmentSocial Insurance
34ERP EHP76.0P01D3_DBNA81DEUV Confirmation: Data Module - NameSocial Insurance
35ERP EHP76.0P01D3_DBUV51DEUEV Confirmation: DBUV Data Module - Accident InsuranceSocial Insurance
36ERP EHP76.0P01D3_DBUV_DAT101DEUEV Confirmation: Data for DBUV Data ModuleSocial Insurance
37ERP EHP76.0P01D3_DSAP192DEUEV Confirmation: Control Record for NotificationsSocial Insurance
38ERP EHP76.0P01D3_DSKK231DEUEV Confirmation: Data Record HI Fund NotificationSocial Insurance
39ERP EHP76.0P01D3_DSME321DEUEV Confirmation: Notification Data RecordSocial Insurance
40ERP EHP76.0P01D3_FLAG161DEUEV Confirmation: Notification IndicatorsSocial Insurance
41ERP EHP76.0P01DS_DBAN81Data Modules Address of DEUEV Immediate NotificationsSocial Insurance
42ERP EHP76.0P01DS_DBEU41Data Modules EU Insurance No. (DEUEV Immed. Notifications)Social Insurance
43ERP EHP76.0P01DS_DBFE41Data Modules Error of DEUEV Confirmations (Immediate Notif.)Social Insurance
44ERP EHP76.0P01DS_DBGB81Data Modules Birth Details of DEUEV Immediate NotificationsSocial Insurance
45ERP EHP76.0P01DS_DBNA81Data Module Name of DEUEV Immediate NotificationsSocial Insurance
46ERP EHP76.0P01DS_DBSO41Data Modules Immediate Notif. of DEUEV Immediate NotifsSocial Insurance
47ERP EHP76.0P01DS_DBVR51Module DBVR of DEUEV Immediate NotificationsSocial Insurance
48ERP EHP76.0P01DS_DSME321DEUEV Immediate Notification: Data Record NotificationSocial Insurance
49ERP EHP76.0P01DS_HIST161Management of Status History for DEUEV Immediate NotifsSocial Insurance
50ERP EHP76.0P01DS_STAT262Control Records for DEUEV Immediate NotificationsSocial Insurance
51ERP EHP76.0P01EA_DBFE41Data Module Error for Reimbursement ProcessSocial Insurance
52ERP EHP76.0P01EA_HIST161History Administration for the Reimbursement ProcessSocial Insurance
53ERP EHP76.0P01EA_MELD1031Data Record and Data Modules for the Reimbursement ProcessSocial Insurance
54ERP EHP76.0P01EA_STAT202Status Table for Reimbursement ProcessSocial Insurance
55ERP EHP76.0P01EE_DBAE241Data Module DBAE RemunerationSocial Insurance
56ERP EHP76.0P01EE_DBAL221Data Module DBAL GeneralSocial Insurance
57ERP EHP76.0P01EE_DBAN81Data Module DBAN AddressSocial Insurance
58ERP EHP76.0P01EE_DBAV41Data Module DBAV Request for Notif. of Preexisting ConditionSocial Insurance
59ERP EHP76.0P01EE_DBAW111Data Module DBAW Absences Without RemunerationSocial Insurance
60ERP EHP76.0P01EE_DBBE51Data Module DBBE Amount fo Income Liable for ContributionsSocial Insurance
61ERP EHP76.0P01EE_DBFE41Data Modules Error of DEUEV Confirmations (Immediate Notif.)Social Insurance
62ERP EHP76.0P01EE_DBFR321Data Module DBFR Entry Release from Work Illness of ChildSocial Insurance
63ERP EHP76.0P01EE_DBHE61Data Module DBHE Amount of Compensation BenefitsSocial Insurance
64ERP EHP76.0P01EE_DBLT291Data Module DBLT Addit. Data Calculation of Transitional PaySocial Insurance
65ERP EHP76.0P01EE_DBMU431Data Module DBMU Remuneration Statement Maternity AllowanceSocial Insurance
66ERP EHP76.0P01EE_DBNA81Data Module DBNA NameSocial Insurance
67ERP EHP76.0P01EE_DBTK81Data Module DBTK Addit. Data of Transfer Reduced Hours Comp.Social Insurance
68ERP EHP76.0P01EE_DBUN161Data Module DBUN Work/School/Preschool AccidentSocial Insurance
69ERP EHP76.0P01EE_DBVO391Data Module DBVO Periods for Preexisting ConditionSocial Insurance
70ERP EHP76.0P01EE_DBZA131Data Module DBZA Working TimeSocial Insurance
71ERP EHP76.0P01EE_DBZE161Data Module DBZE Working Time Illness/InjurySocial Insurance
72ERP EHP76.0P01EE_DSLW462Data Record Benefits of Compensation Benefits NotificationSocial Insurance
73ERP EHP76.0P01EE_HIST161Status History for Compensation Benefits NotificationsSocial Insurance
74ERP EHP76.0P01EE_STAT252Admin. Records for Data Exchange for Compensation BenefitsSocial Insurance
75ERP EHP76.0P01EL_DBAB51Data Module Alternative Place of Employment of ELENA Notif.Social Insurance
76ERP EHP76.0P01EL_DBAG141Data Module Employer Details of ELENA NotificationsSocial Insurance
77ERP EHP76.0P01EL_DBAN81Data Module Address of ELENA NotificationsSocial Insurance
78ERP EHP76.0P01EL_DBAS61Data Module Education/Training of ELENA NotificationsSocial Insurance
79ERP EHP76.0P01EL_DBEN391Data Modules ELENA Basic Data for Employer and EmployeeSocial Insurance
80ERP EHP76.0P01EL_DBFE41Data Module Error in ELENA ProcedureSocial Insurance
81ERP EHP76.0P01EL_DBFZ61Data Module Absence Times of ELENA NotificationsSocial Insurance
82ERP EHP76.0P01EL_DBGB81Data Module Birth Details of ELENA NotificationsSocial Insurance
83ERP EHP76.0P01EL_DBHA61Data Module Homeworker for ELENA NotificationsSocial Insurance
84ERP EHP76.0P01EL_DBKE511Data Module Notice/Dismissal (DBKE) ELENASocial Insurance
85ERP EHP76.0P01EL_DBNA81Data Module Name of ELENA NotificationsSocial Insurance
86ERP EHP76.0P01EL_DBSB71Data Module Tax-Exempt Payments of ELENA NotificationsSocial Insurance
87ERP EHP76.0P01EL_DBSE71Data Module Taxable One-Off Payment of ELENA NotificationsSocial Insurance
88ERP EHP76.0P01EL_DBZD221Data Module Additional Data of ELENA NotificationsSocial Insurance
89ERP EHP76.0P01EL_DSVV401Data Record Assignment of Insurance No./Process No. ELENASocial Insurance
90ERP EHP76.0P01EL_HIST161History Administration for the ELENA ProcedureSocial Insurance
91ERP EHP76.0P01EL_MVDS401Data Record Multifunctional Remun. Rec. (MVDS) ELENASocial Insurance
92ERP EHP76.0P01EL_PROT162Log Table for the ELENA ProcedureSocial Insurance
93ERP EHP76.0P01EL_STAT202Status Table for the ELENA Notification ProcedureSocial Insurance
94ERP EHP76.0P01SV_B2ATRNS231Status Table Transfer to Social Insurance AgencySocial Insurance
95ERP EHP76.0P01SV_DSID32Administration Data Record IdentificationSocial Insurance
96ERP EHP76.0P01SV_IT700_A41Assignment Infotype Structure 0700 to Data ModuleSocial Insurance
97ERP EHP76.0P01SV_IT700_B21Assignment IT 0700 Dynpro to Infotype StructureSocial Insurance
98ERP EHP76.0P01SV_MLDAUFR51Control of Recalculation in SI ReportingSocial Insurance
99ERP EHP76.0P01SV_MLDTRNS102Assignment of Notifications to File CountersSocial Insurance
100ERP EHP76.0P01ZS_AZKK41Management of HI Fund Record Number (Paying Office Proced.)Social Insurance
101ERP EHP76.0P01ZS_AZVU72Management Record No. of Employer (Paying Office Procedure)Social Insurance
102ERP EHP76.0P01ZS_DBFE41Error Data Module for Paying Office ProcedureSocial Insurance
103ERP EHP76.0P01ZS_HIST161Administration of the Paying Office Procedure HistorySocial Insurance
104ERP EHP76.0P01ZS_INFT231Administration of Master Data Status (Paying Office Proc.)Social Insurance
105ERP EHP76.0P01ZS_MELD651Data Record and Data Modules for Paying Office ProcedureSocial Insurance
106ERP EHP76.0P01ZS_STAT202Status Table for Paying Office ProcedureSocial Insurance
107ERP EHP76.0PA0700291HR Master Record for Infotype 0700Social Insurance
108ERP EHP76.0PA0942271HR Master Record Infotype 0942Social Insurance
109ERP EHP76.0PD3DBKV221DEUEV: Data Module Health InsuranceSocial Insurance
110ERP EHP76.0PD3HIST181Status History Management for DEUEV NotificationsSocial Insurance
111ERP EHP76.0T5D1771Subsequent Administration of Locked HI FundsSocial Insurance
112ERP EHP76.0T5D18151Processing of Assessment ThresholdsSocial Insurance
113ERP EHP76.0T5D31201Professionals Pension Organization (PPO)Social Insurance
114ERP EHP76.0T5D32_GT61Workers' Compensation Associations Hazard Pay ScalesSocial Insurance
115ERP EHP76.0T5D32_UV231Workers' Compensation AssociationsSocial Insurance
116ERP EHP76.0T5D3331ELENA: Employment Agencies' Key DirectorySocial Insurance
117ERP EHP76.0T5D3A_ABWUV21Alternative Determination of Responsible AI CarrierSocial Insurance
118ERP EHP76.0T5D3A_ABWUVT41Texts for Alternative Determination of AI CarrierSocial Insurance
119ERP EHP76.0T5D3A_MSL61Membership Key for AI Data of CompanySocial Insurance
120ERP EHP76.0T5D3P191HR Technical Assignments for Workers' Compensation Assoc.Social Insurance
121ERP EHP76.0T5D4ATS21DEUEV Occupational Code 2010Social Insurance
122ERP EHP76.0T5D4ATS_BRF31DEUEV Occupational Code 2010 OccupationsSocial Insurance
123ERP EHP76.0T5D4ATS_UMS3521DEUEV Occupational Code 2010 Conversion Table Old(3)->New(5)Social Insurance
124ERP EHP76.0T5D4ATS_VAL51DEUEV Occupational Code 2010 Input HelpSocial Insurance
125ERP EHP76.0T5D4EL41DEUEV Country CodesSocial Insurance
Payroll :: Germany :: Net :: Tax
ProductVersionTableColumnsIndexesDescriptionModule
126ERP EHP76.0P01E2_ABMELDUNG81ELStAM Procedure: Tables of Deregistration DataTax
127ERP EHP76.0P01E2_ADM334ELStAM Procedure: Administration DataTax
128ERP EHP76.0P01E2_ANMELDUNG91ELStAM Procedure: Table of Registration DataTax
129ERP EHP76.0P01E2_ELSTAM241ELStAM Procedure: Table of Change ListsTax
130ERP EHP76.0P01E2_HIST151ELStAM Procedure: Table for Status HistoryTax
131ERP EHP76.0P01E2_INFT231ELStAM Procedure: Table with Data Changes for Infotype 0012Tax
132ERP EHP76.0P01E2_LISTMTL_ST251ELStAM: Status Table for Monthly Change ListsTax
133ERP EHP76.0P01E2_LIST_ST171Status Table for ELStAM Procedure Change ListsTax
134ERP EHP76.0P01E2_STATUS173ELStAM Procedure: Status TableTax
135ERP EHP76.0P01E2_TRANS41Relationship Between GLBID/Proc. Data Ticket/Transfer TicketTax
136ERP EHP76.0P01E2_TRANS_ST193Status Table Transfer for ELStAM ProcedureTax
137ERP EHP76.0P01T_ADMIN161ETSmt: Administration of Employment Tax StatementTax
138ERP EHP76.0P01T_ADMIN_STAT121ETStmt: Status Management Employment Tax StatementsTax
139ERP EHP76.0P01T_ADMST121ETStmt: Status Management - Employment Tax Statements (Old)Tax
140ERP EHP76.0P01T_A_ADM91ETNotif.: Administration - Employment Tax NotificationTax
141ERP EHP76.0P01T_A_ADS141ETNotif.: Status Administration/Employment Tax NotificationTax
142ERP EHP76.0P01T_A_BTG81ETNotif.: Tax Amounts in Employment Tax NotificationTax
143ERP EHP76.0P01T_A_DAT121ETNotif.: General Data for Employment Tax NotificationTax
144ERP EHP76.0P01T_A_EXT111ETNotif.: External DataTax
145ERP EHP76.0P01T_ELSTAM191ETStmt: ELStAM (as of 2012)Tax
146ERP EHP76.0P01T_FRBJ71Employment Tax Statement: Tax-Free Annual AmountsTax
147ERP EHP76.0P01T_HINZ71ETStmt: Additional AmountsTax
148ERP EHP76.0P01T_KIFB71ETStmt: Tax Exemptions for ChildrenTax
149ERP EHP76.0P01T_KIST81ETStmt: Church Tax DataTax
150ERP EHP76.0P01T_LST571ETStmt: General Employment Tax DataTax
151ERP EHP76.0P01T_LST171ETStmt: Tax Bases on Employment Tax StatementTax
152ERP EHP76.0P01T_LST291ETStmt: Addnl Data on Employment Tax StatementTax
153ERP EHP76.0P01T_STKL81ETStmt: Tax Class DataTax
154ERP EHP76.0P01T_SVBEZ91ETStmt: Other Pension PaymentsTax
155ERP EHP76.0P01T_TRANS121ETStmt: Administration/Processing Data TicketsTax
156ERP EHP76.0P01T_VBEZ131Employment Tax Statment: Pension BasisTax
157ERP EHP76.0T5D2I91StADUEV Notifications: Transfer NumbersTax
158ERP EHP76.0T5D2J71StADUEV Form ControlTax
159ERP EHP76.0T5D2O81ETNotif.: Asssignment - Cumulation Wage Type to Key FigureTax
160ERP EHP76.0T5D2P81ETNotif.: Key FiguresTax
161ERP EHP76.0T5D2Q71ETNotif.: Totals Formation for Key FiguresTax
162ERP EHP76.0T5D2R71ETStmt: Additional Data with Required TagTax
163ERP EHP76.0T5D2Z111StADUEV Key FiguresTax