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

193 tablesERP 6.0 

Personnel Management :: Personnel Administration :: Japan
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0PA0140331HR Master Record: Infotype 0140 (SI Basic Data JP)Japan
2ERP EHP76.0PA0141311HR Master Record: Infotype 0141 (SI Premium Data JP)Japan
3ERP EHP76.0PA0142291HR Master Record: Infotype 0142 (Residence Tax JP)Japan
4ERP EHP76.0PA0143341HR Master Record: Infotype 0143 (Life Insurance JP)Japan
5ERP EHP76.0PA0144341HR Master Record: Infotype 0144 (Property Accum. JP)Japan
6ERP EHP76.0PA0145461HR Master Record: Infotype 0145 (Personnel Tax Status JP)Japan
7ERP EHP76.0PA01463911HR Master Record: Infotype 0146 (Y.E.A. Data JP)Japan
8ERP EHP76.0PA01472261HR Master Record: Infotype 0147Japan
9ERP EHP76.0PA0148601HR Master Record: Infotype 0148 (Family JP)Japan
10ERP EHP76.0PA0162291HR Master Record: Infotype 0162 (Ins. Y.E.T.A Data JP)Japan
11ERP EHP76.0PA0268361HR Master Record Infortype view 0045 and 0268 (Loan JPN)Japan
12ERP EHP76.0PA0373341HR loan repayment plan JP (for P0268)Japan
13ERP EHP76.0PA0388301HR Master Record: Infotype 0388 (Union JP)Japan
14ERP EHP76.0PA0559581HR Master Record: Infotype 0559 (Commuting allowance Info.)Japan
15ERP EHP76.0PA05602091HR Master Record: Infotype 0560Japan
16ERP EHP76.0PA08511261HR Master Record: Infotype 0851Japan
17ERP EHP76.0PA0852281HR Master Record: Infotype 0852Japan
18ERP EHP76.0PA0853361HR Master Record: Infotype 0853Japan
19ERP EHP76.0PA3140721HR Master Record: Infotype 3140Japan
20ERP EHP76.0PA32031191HR Master Record: Infotype 3203Japan
21ERP EHP76.0PA3204971HR Master Record: Infotype 3204Japan
22ERP EHP76.0PA3208301HR Master Record: Infotype 3208Japan
23ERP EHP76.0PA3239311HR Master Record: Infotype 3239Japan
24ERP EHP76.0PB3208301Applicant data infotype 3208 (model)Japan
25ERP EHP76.0PTJPFWS_ITEMDATA102(Obsolete) Request Item Data for Flexible Work Schedule JPJapan
26ERP EHP76.0T51T3T91Text table for T51T3Japan
27ERP EHP76.0T51T5T71Text table for T51T5Japan
28ERP EHP76.0T5J0021HR Union JPJapan
29ERP EHP76.0T5J0141HR Union texts JPJapan
30ERP EHP76.0T5J0221HR Union Member Category JPJapan
31ERP EHP76.0T5J0341Person Group/Subgroup JPJapan
32ERP EHP76.0T5J0441HR Union Member Category Text JPJapan
33ERP EHP76.0T5J05121HR Union due calculation master JPJapan
34ERP EHP76.0T5J0P91Personnel Area / Personnel Subarea JPJapan
35ERP EHP76.0T5J1021HR Appraisal Main Feature JPNJapan
36ERP EHP76.0T5J1141HR Text for Appraisal Main Feature JPNJapan
37ERP EHP76.0T5J1231HR Appraisal Detail Feature JPNJapan
38ERP EHP76.0T5J1351HR Text for Appraisal Detail Feature JPNJapan
39ERP EHP76.0T5J1471HR Pay Scale Level for Appraisal Point Criteria JPNJapan
40ERP EHP76.0T5J1561HR Pay Scale Level for Appraisal Rank Criteria JPNJapan
41ERP EHP76.0T5J1641HR Text for Appraisal Rank Criteria JPNJapan
42ERP EHP76.0T5J1741HR Combination for Income Tax Deduction JPNJapan
43ERP EHP76.0T5J1871HR Amount for Income Tax Deduction JPNJapan
44ERP EHP76.0T5J1C21HR-J: Car typeJapan
45ERP EHP76.0T5J1CT41HR-J: Car type textJapan
46ERP EHP76.0T5J1D71HR Nursing Insurance cost JPJapan
47ERP EHP76.0T5J1E11HR Grade No. of standard compensation for health ins. JPJapan
48ERP EHP76.0T5J1F11HR Grade No. of standard compensation for EE's pension JPJapan
49ERP EHP76.0T5J2121HR Insurance Company Key Master JPNJapan
50ERP EHP76.0T5J2241HR Insurance Company Name JPNJapan
51ERP EHP76.0T5J2341HR Indicator SI Insured JPNJapan
52ERP EHP76.0T5J2451HR Text for Indicator SI Insured JPNJapan
53ERP EHP76.0T5J2521HR Indicator of Labour Insurance Premium Rate JPNJapan
54ERP EHP76.0T5J2641HR Text for Indicator of Labour Insurance Premium Rate JPNJapan
55ERP EHP76.0T5J2721HR Indicator of Social Insurance Premium Rate JPNJapan
56ERP EHP76.0T5J2841HR Text for Indicator of Social Insurance Premium Rate JPNJapan
57ERP EHP76.0T5J2921HR SI Entitlement Acquired/Lost JPNJapan
58ERP EHP76.0T5J3041HR Text for SI Entitlement Acquired/Lost JPNJapan
59ERP EHP76.0T5J3141HR SI Entitlement JPNJapan
60ERP EHP76.0T5J3261HR Social Insurance Entitlement JPNJapan
61ERP EHP76.0T5J3321HR Insurance company type JPNJapan
62ERP EHP76.0T5J3441HR Insurance company type text JPNJapan
63ERP EHP76.0T5J4621HR Appraisal Rank Criteria JPNJapan
64ERP EHP76.0T5J4731HR Combination Insurance Type/Insurance Company JPNJapan
65ERP EHP76.0T5J5671HR Weighting for Appraisal Main Feature JPNJapan
66ERP EHP76.0T5J59111HR Job promotion - pay scale level ordering JPNJapan
67ERP EHP76.0T5J60121HR Parameters for pay scale recreation JPNJapan
68ERP EHP76.0T5J61261HR Address Information of Pers. Subarea for Residence TaxJapan
69ERP EHP76.0T5J62261HR Address Information of Personnel Subarea for Income TaxJapan
70ERP EHP76.0T5J6371HR Municipal City Codes JPJapan
71ERP EHP76.0T5J6571HR School JapanJapan
72ERP EHP76.0T5J65T61HR School JapanJapan
73ERP EHP76.0T5J6621HR Institution/school type JPNJapan
74ERP EHP76.0T5J6741HR Institution/school type text JPJapan
75ERP EHP76.0T5J6841HR Faculty JPJapan
76ERP EHP76.0T5J68T41HR Faculty JPJapan
77ERP EHP76.0T5J7021HR Retirement Reason Category JPJapan
78ERP EHP76.0T5J7141HR Retirement Reason Category JPJapan
79ERP EHP76.0T5J7251HR Supplements to Reason for Events JPJapan
80ERP EHP76.0T5J7341HR Retirement Allowance Modifier JPJapan
81ERP EHP76.0T5J73T41HR Retirement Allowance Modifier JPJapan
82ERP EHP76.0T5J7451HR Retirement Allowance Unit Amount JPJapan
83ERP EHP76.0T5J7521HR Santei/Geppen Form remarks column text ID JPJapan
84ERP EHP76.0T5J7641HR Santei/Geppen Form remarks column text JPJapan
85ERP EHP76.0T5J7731HR Katakana writing for Country Names JPJapan
86ERP EHP76.0T5J7851HR Taxable amount reduction for retirement allowance JPJapan
87ERP EHP76.0T5J7951HR Syoyo payemnt rate per pay scale JPJapan
88ERP EHP76.0T5J8061HR Definition of Service Years - Factor - Patterns JPJapan
89ERP EHP76.0T5J8151HR Associate retirement reason category to service years JPJapan
90ERP EHP76.0T5J8251HR Associate pay scale to service years JPJapan
91ERP EHP76.0T5J8351HR Service Years - Factor - Patterns for Retirement JPJapan
92ERP EHP76.0T5J8431HR Service Years - Factor - Patterns for Retirement JPJapan
93ERP EHP76.0T5J9861HR Conversion IT0144 to IT0169 JPJapan
94ERP EHP76.0T5JA281HR Weighting for Appraisal Detail Feature JPNJapan
95ERP EHP76.0T5JAD131HR company office address JPJapan
96ERP EHP76.0T5JBK41HR Bank key for Property accumulation savings JPJapan
97ERP EHP76.0T5JGR21Employee Group for Leaving (JAPAN)Japan
98ERP EHP76.0T5JGRT41Employee Group for Leaving Text (JAPAN)Japan
99ERP EHP76.0T5JL1141HR Address Infomation 1 of Personnel Subarea for LI JPJapan
100ERP EHP76.0T5JL2131HR Address Infomation 2 of Personnel Subarea for LI JPJapan
101ERP EHP76.0T5JLG91Premium amount for employment insuranceJapan
102ERP EHP76.0T5JLR71HR Rate of Premium for Labour Insurance JPNJapan
103ERP EHP76.0T5JLT21Leaving Type (JAPAN)Japan
104ERP EHP76.0T5JLTT41Leaving Type Text (JAPAN)Japan
105ERP EHP76.0T5JMD51Module for Liquidation/Allowance Items (JP)Japan
106ERP EHP76.0T5JOT21Overtime Liquidation Indicator (JAPAN)Japan
107ERP EHP76.0T5JOTT41Overtime Liquidation Indicator Text (JAPAN)Japan
108ERP EHP76.0T5JR081Definition of Retirement Liquidation/Allowance Items(JP)Japan
109ERP EHP76.0T5JR0T51Text table for Retirement Liquidation/Allowance Items (JP)Japan
110ERP EHP76.0T5JR181Configuration of Retirement Liquidation/Allowance Items (JP)Japan
111ERP EHP76.0T5JR251Default Items for Retirement Liquidation/Allowance (JP)Japan
112ERP EHP76.0T5JRA91HR Collector Number for Residence Tax JPJapan
113ERP EHP76.0T5JRH21Action types for Leaving-ReentryJapan
114ERP EHP76.0T5JRN31Reason (JAPAN)Japan
115ERP EHP76.0T5JRNT51Reason Text (JAPAN)Japan
116ERP EHP76.0T5JSC91HR SI Grade of standard compensation JPJapan
117ERP EHP76.0T5JSI261HR Branch Office Information for Social Insurance JPJapan
118ERP EHP76.0T5JSP21Social Insurance Premiums Liquidation Indicator (JAPAN)Japan
119ERP EHP76.0T5JSPT41Social Insurance Premiums Liquidation Indicator Text (JAPAN)Japan
120ERP EHP76.0T5JSR71HR Rate of Premium for Social Insurance JPNJapan
121ERP EHP76.0T7JPBT_BSOFFICET41Business Establishment Text TableJapan
122ERP EHP76.0T7JPBT_BUSOFFICE81Define Business EstablishmentsJapan
123ERP EHP76.0T7JPBT_EXCLUDEWT21Determine Wage Types to be excluded from Business Office TaxJapan
124ERP EHP76.0T7JPEI_RESSTA31Define Residence StatusJapan
125ERP EHP76.0T7JPEI_RESSTAT41Text Table for Residence StatusJapan
126ERP EHP76.0T7JPLA_COVRT71Define OT Accu. Target & Time Off Conversion RateJapan
127ERP EHP76.0T7JPLA_OTGRP21Define employee group for overtimeJapan
128ERP EHP76.0T7JPLA_OTGRPT41Text table for employee group for overtimeJapan
129ERP EHP76.0T7JPLA_OTLIM81Define overtime extension limitsJapan
130ERP EHP76.0T7JPLA_VADPD41Define Leave Quota Validity for Time Off from OvertimeJapan
131ERP EHP76.0T7JPLA_WKHRS51Define Hours of Time Off from OvertimeJapan
132ERP EHP76.0T7JPLA_WTASN51Assign Overtime Accumulation Wage TypesJapan
133ERP EHP76.0T7JPLA_WTGRP21Define Wage Type GroupJapan
134ERP EHP76.0T7JPLA_WTGRPT41Text table for Wage Type GroupJapan
135ERP EHP76.0T7JPLV_DATALAY21Define Data LayoutJapan
136ERP EHP76.0T7JPLV_DATALAYT41Text Table to Define Data LayoutJapan
137ERP EHP76.0T7JPLV_FILESTRU71Define File StructureJapan
138ERP EHP76.0T7JPLV_FILETYPE61Define File TypeJapan
139ERP EHP76.0T7JPLV_FILETYPET61Text Table of T7JPLV_FILETYPETJapan
140ERP EHP76.0T7JPLV_GIAJI_J2131Define Relationship between GIAJ specific Insurance CompanyJapan
141ERP EHP76.0T7JPLV_GIAJI_TYP41Define Insurance Type RelationshipJapan
142ERP EHP76.0T7JPLV_GIAJ_INS21Define GIAJ specific insurer codesJapan
143ERP EHP76.0T7JPLV_GIAJ_INST41Define GIAJ Specific Insurer Company NameJapan
144ERP EHP76.0T7JPLV_GIAJ_TYPE31Define Insurance Type Relationship for GIAJ companyJapan
145ERP EHP76.0T7JPLV_INSCC21Define LINC Insurance CompanyJapan
146ERP EHP76.0T7JPLV_INSCCCT41Define Insurance Company Insurance Product TypeJapan
147ERP EHP76.0T7JPLV_INSCCT41Text Table for T7JPLV_INSCCJapan
148ERP EHP76.0T7JPLV_INSCC_J2131Define Relationship between LINC Insurance Company and T5J21Japan
149ERP EHP76.0T7JPLV_RECDSTRU171Define Record StructureJapan
150ERP EHP76.0T7JPSI_INR_ASN31Assign Health Insurance Insurer to Social Insurance ModifierJapan
151ERP EHP76.0T7JPSI_INSURER21Define Health Insurance InsurerJapan
152ERP EHP76.0T7JPSI_INSURERT41Define Health Insurance InsurerJapan
153ERP EHP76.0T7JPSK_CCPRL11Shukko Cost Charging Prorating RulesJapan
154ERP EHP76.0T7JPSK_CCPRL_T31Shukko Cost Charging Prorating RulesJapan
155ERP EHP76.0T7JPSK_CCRL31Shukko Cost Charging RulesJapan
156ERP EHP76.0T7JPSK_CCRL_C71Shukko Cost Charging Rule CharacteristicsJapan
157ERP EHP76.0T7JPSK_CCRL_T41Shukko Cost Charging RulesJapan
158ERP EHP76.0T7JPSK_CCWT61Shukko Cost Charging WagetypeJapan
159ERP EHP76.0T7JPSK_CONTT131Shukko Contract TemplateJapan
160ERP EHP76.0T7JPSK_CONTTY21Shukko Contract TypesJapan
161ERP EHP76.0T7JPSK_CONTTY_T41Shukko Contract TypesJapan
162ERP EHP76.0T7JPSK_PARTNER31Shukko PartnersJapan
163ERP EHP76.0T7JPSK_PARTNER_T41Shukko Partner TextsJapan
164ERP EHP76.0T7JP_ACCINF21Infotype Monitor for Access LogJapan
165ERP EHP76.0T7JP_ACCLOG211Access LogJapan
166ERP EHP76.0T7JP_ACCOPN111Infotype Operation Monitor for Access LogJapan
167ERP EHP76.0T7JP_ACCSUB41Subtype Monitor for Access LogJapan
168ERP EHP76.0T7JP_CHARRNG41Range of characters in a character setJapan
169ERP EHP76.0T7JP_CHARSET11Character setJapan
170ERP EHP76.0T7JP_CHARSET_T31Text for character setJapan
171ERP EHP76.0T7JP_LVE_ATT111Attachment InformationJapan
172ERP EHP76.0T7JP_LVE_CLB191Child Care Leave BenefitsJapan
173ERP EHP76.0T7JP_LVE_CLN151Child Care Leave (Termination) NotificationJapan
174ERP EHP76.0T7JP_LVE_DRE31Determine Relationship from subtypesJapan
175ERP EHP76.0T7JP_LVE_JSH41Determine Jisshi from subtypes and relationshipsJapan
176ERP EHP76.0T7JP_LVE_NLB191Nursing Leave BenefitsJapan
177ERP EHP76.0T7JP_LVE_STF141Application and Notification Forms for Special TreatmentJapan
178ERP EHP76.0T7JP_UPDFLD41Fields Monitor for Update LogJapan
179ERP EHP76.0T7JP_UPDINF21Infotype Monitor for Update LogJapan
180ERP EHP76.0T7JP_UPDOPN91Infotype Operation Monitor for Update LogJapan
181ERP EHP76.0T7JP_UPDSUB41Subtype Monitor for Update LogJapan
182ERP EHP76.0T7JP_UPTLOG261Update LogJapan
183ERP EHP76.0TJPESST_INTERVAL41JP ESS IT0559 Interval DescriptionJapan
184ERP EHP76.0TJPESS_COM_GROUP31JP ESS IT0559 Subtype GroupingJapan
185ERP EHP76.0TJPESS_COM_MEANS21JP ESS IT0559 Means of Transportation DefinitionJapan
186ERP EHP76.0TJPESS_INTERVAL21JP ESS IT0559 Interval DefinitionJapan
187ERP EHP76.0TJPESS_INT_GROUP31JP ESS IT0559 Interval GroupingJapan
188ERP EHP76.0TJPESS_MEANS_TYP41JP ESS IT0559 Combination of Means of TransportationJapan
189ERP EHP76.0TJPESS_PERKM_AMT41JP ESS IT0559 Per KM Amount SettingJapan
190ERP EHP76.0TJPESS_TXT_MEANS41JP ESS IT0559 Means of Transportation DescriptionJapan
191ERP EHP76.0TPTJPFWS_ITEMDAT102Request Item Data for Flexible Work Schedule JPJapan
192ERP EHP76.0TPTJPFWS_RULEATT131ESS Flexible Work Schedule: Attributes for rule groupJapan
193ERP EHP76.0TPTJPFWS_SUBSTI101ESS Flexible Work Schedule: Substitution linkageJapan