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

117 columns | Print definition?ERP 6.0  | BPLAN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P2RX_BENTABBenefits payroll results international6BPLANBenefit plannvarchar40
2T77BENPLANGRPBenefits Plan Archiving Object Subgroup5BPLANBenefit plannvarchar40
3T7AE17Benefit Plan Wage Type to Overwrite EE Cost3BPLANBenefit plannvarchar40
4T7SA27Benefit Plan Wage Type to Overwrite EE Cost3BPLANBenefit plannvarchar40
TOPBenefit Integration
5PA0496Payroll Infotype: US Benefits Data - Per Pay Period33BPLANBenefit plannvarchar40
6PA0497Payroll Infotype: US Benefits Data - MTD33BPLANBenefit plannvarchar40
7PA0498Payroll Infotype: US Benefits Data - QTD33BPLANBenefit plannvarchar40
8PA0499Payroll Infotype: US Benefits Data - YTD33BPLANBenefit plannvarchar40
9PA0500Payroll Infotype: US Benefits Data in Arrears (ARRRS)33BPLANBenefit plannvarchar40
10PA0501Payroll Infotype: US Benefits Data in Ded Not Taken (DDNTK)33BPLANBenefit plannvarchar40
11T7USBEN03Catch-up contribution for Savings plan3BPLANBenefit plannvarchar40
12T7USBEN04High Deductible Health Plan Contributions3BPLANBenefit plannvarchar40
13T7USBENH1For saving records of issued HIPAA certificates5BPLANBenefit plannvarchar40
14T7USBENPEUS pension related data (e.g. Soc. Sec. wages and taxes)4BPLANBenefit plannvarchar40
TOPBenefits
15PA0167HR Master Record: Infotype 0167 (Health Plans)26BPLANBenefit plannvarchar40
16PA0168HR Master Record: Infotype 0168 (Insurance Plans)26BPLANBenefit plannvarchar40
17PA0169HR Master Record: Infotype 0169 (Savings Plan)26BPLANBenefit plannvarchar40
18PA0170HR Master Record: Infotype 0170 (Flexible Spending Accounts)26BPLANBenefit plannvarchar40
19PA0172HR Master Record: Infotype 0172 (FSA Claims)26BPLANBenefit plannvarchar40
20PA0212HR Master Record: Infotpye 0212 (COBRA Health Plan)26BPLANBenefit plannvarchar40
21PA0236HR Master Record: Infotype 0236 (Credit Plans)26BPLANBenefit plannvarchar40
22PA0377HR Master Record: Infotype 0377 (Miscellaneous Plans)26BPLANBenefit plannvarchar40
23PA0379HR Master Record: Infotype 0379 (Stock Purchase Plans)26BPLANBenefit plannvarchar40
24PA0565HR Master Record: Infotype 0565 (Retirement Plan Val. Res.)25BPLANBenefit plannvarchar40
25PA0602HR Master Record: Infotype 0602 (Retirement Plan Cumulation)25BPLANBenefit plannvarchar40
26PA0671HR Master Record - Infotype 0671 (COBRA Flex. Spending Acct)26BPLANBenefit plannvarchar40
27T5UB6Benefit Standard Health Selection6BPLANBenefit plannvarchar40
28T5UB7Benefit standard insurance selection6BPLANBenefit plannvarchar40
29T5UBABenefit plan3BPLANBenefit plannvarchar40
30T5UBBBenefit health option/dependent coverage assignment3BPLANBenefit plannvarchar40
31T5UBCTo be deleted - no longer used!3BPLANBenefit plannvarchar40
32T5UBDTo be deleted - no longer used!3BPLANBenefit plannvarchar40
33T5UBEBenefit Health Plan Option3BPLANBenefit plannvarchar40
34T5UBGBenefit Flexible Spending Account3BPLANBenefit plannvarchar40
35T5UBHBenefit cost rule variant3BPLANBenefit plannvarchar40
36T5UBIBenefit cost rule3BPLANBenefit plannvarchar40
37T5UBUBenefit program5BPLANBenefit plannvarchar40
38T5UCABenefit plan texts4BPLANBenefit plannvarchar40
39T5UCCTo be deleted - no longer used!4BPLANBenefit plannvarchar40
40T5UCEBenefit health plan option texts4BPLANBenefit plannvarchar40
41T5UCHBenefit cost rule variant texts4BPLANBenefit plannvarchar40
42T5UDPTo be deleted - no longer used!3BPLANBenefit plannvarchar40
43T74FABenefit insurance plan3BPLANBenefit plannvarchar40
44T74FBBenefits Coverage Rule Variant3BPLANBenefit plannvarchar40
45T74FCBenefits Insurance Coverage Rule3BPLANBenefit plannvarchar40
46T74FDBenefit Savings Plan3BPLANBenefit plannvarchar40
47T74FEBenefit employer contribution rule variant3BPLANBenefit plannvarchar40
48T74FFBenefit employer contribution rule3BPLANBenefit plannvarchar40
49T74FGBenefit employee contribution rule variant3BPLANBenefit plannvarchar40
50T74FHBenefit employee contribution rule3BPLANBenefit plannvarchar40
51T74FIBenefit credit plan3BPLANBenefit plannvarchar40
52T74FJBenefit credit rule variant3BPLANBenefit plannvarchar40
53T74FKBenefit credit rule3BPLANBenefit plannvarchar40
54T74FLBenefit miscellaneous plan3BPLANBenefit plannvarchar40
55T74FMBenefit Standard Savings Selection6BPLANBenefit plannvarchar40
56T74FNBenefit Standard Spending Account Selection6BPLANBenefit plannvarchar40
57T74FOBenefit standard credit selection6BPLANBenefit plannvarchar40
58T74FPBenefit Standard Miscellaneous Selection6BPLANBenefit plannvarchar40
59T74FQBenefit standard stock purchase selection6BPLANBenefit plannvarchar40
60T74FRBenefit evidence of insurability3BPLANBenefit plannvarchar40
61T74FSBenefit evidence of insurability option assignment3BPLANBenefit plannvarchar40
62T74FTBenefit evidence of insurability option jump assignment3BPLANBenefit plannvarchar40
63T74FUBenefit combined coverage limit3BPLANBenefit plannvarchar40
64T74FVBenefit combined coverage limit expression3BPLANBenefit plannvarchar40
65T74FWBenefit combined contribution limit3BPLANBenefit plannvarchar40
66T74FXBenefit combined contribution limit expression3BPLANBenefit plannvarchar40
67T74FYBenefit prerequisite plan3BPLANBenefit plannvarchar40
68T74FZBenefit corequisite plan3BPLANBenefit plannvarchar40
69T74GABenefit insurance plan texts4BPLANBenefit plannvarchar40
70T74GBBenefit insurance coverage rule variant texts4BPLANBenefit plannvarchar40
71T74GEBenefit employer contribution rule variant texts4BPLANBenefit plannvarchar40
72T74GGBenefit employee contribution rule variant texts4BPLANBenefit plannvarchar40
73T74GJBenefit credit rule variant texts4BPLANBenefit plannvarchar40
74T74GLBenefit miscellaneous plan texts4BPLANBenefit plannvarchar40
75T74GUBenefit combined coverage limit text4BPLANBenefit plannvarchar40
76T74GWBenefit combined contribution limit text4BPLANBenefit plannvarchar40
77T74HDBenefit stock purchase plan3BPLANBenefit plannvarchar40
78T74HEBenefit payment model assignment3BPLANBenefit plannvarchar40
79T74HHTo be deleted - no longer used!3BPLANBenefit plannvarchar40
80T74HIBenefit reasons for off-cycle payroll assignment3BPLANBenefit plannvarchar40
81T74HOBenefit Equivalent Length of Service3BPLANBenefit plannvarchar40
TOPClaims Processing Asia
82T7XAS0Wage Type Assignment to Claim Plan3BPLANBenefit plannvarchar40
83T7XAS6Claim variant for Plan3BPLANBenefit plannvarchar40
84T7XAS7Text table for claim formula for Plan4BPLANBenefit plannvarchar40
85T7XAS8Claim rule for Plan3BPLANBenefit plannvarchar40
86T7XAS9Assignment of Claim formula and Panel doctors to Claim Plan3BPLANBenefit plannvarchar40
87T7XASGClaims processing Balance table4BPLANBenefit plannvarchar40
88T7XASTClaims processing transaction table4BPLANBenefit plannvarchar40
TOPGeneral Parts
89T74_FBN04Number of Holiday Buying or Selling for Holiday Plan3BPLANBenefit plannvarchar40
90T74_FBN05Flexible Benefits Holiday Buying or Selling Limitation3BPLANBenefit plannvarchar40
91T74_FBN07Flexible Benefits Holiday Plan Quota & Wage Type Setting3BPLANBenefit plannvarchar40
92T74_FBN08Annual Tax Free Boundary3BPLANBenefit plannvarchar40
93T74_FBN09Benefit Plan Option Jump Assignment3BPLANBenefit plannvarchar40
94T74_FBN13Benefit Insurance Plan Option Relevant Family3BPLANBenefit plannvarchar40
95T74_FBN16Annual Flexible Benefits Plan Cost Pro-rate for New Starter3BPLANBenefit plannvarchar40
96T74_FBN_GB01Flexible Benefits Plan General Attribute (GB)3BPLANBenefit plannvarchar40
97T74_FBN_GB02Flexible Benefits Plan Company Car Attribute (GB)3BPLANBenefit plannvarchar40
98T74_FBN_GB04Flexible Benefits Plan GB Pension Attribute3BPLANBenefit plannvarchar40
99T74_FBN_GB05Flexible Benefits Employee Pension Contribution Rule (GB)3BPLANBenefit plannvarchar40
100T74_FBN_GB08Option Salary Sacrifice of Flexible Benefit Plan GB Pension3BPLANBenefit plannvarchar40
101T74_FBN_GB11Email Data for GB Flexible Benefit3BPLANBenefit plannvarchar40
TOPJapan
102T5J98HR Conversion IT0144 to IT0169 JP5BPLANBenefit plannvarchar40
TOPMexico
103T7MX50Administration of investment period for savings fund3BPLANBenefit plannvarchar40
TOPNetherlands
104P05FBN_ADD_PLANFlexible Benefits NL: Additional Data Benefit Plans3BPLANBenefit Plannvarchar40
105P05FBN_AFWPLAdditional Data Absence Plans3BPLANBenefit plannvarchar40
106P05FBN_AFWPL_INDEntry Factor Absence Plans3BPLANBenefit plannvarchar40
107P05FBN_VERRCancellation3BPLANBenefit plannvarchar40
108P05FBN_WZR_PLANSet Changeable Plans for Adjustment Reasons5BPLANBenefit Plannvarchar40
109PA3200HR Master Record for Infotype 320025BPLANBenefit Plannvarchar40
TOPNon Profit Organizations
110T7UNBEN_T5UBANPO Benefit Plan Cost Rule Variant3BPLANBenefit plannvarchar40
111T7UNBEN_T5UBHNPO Benefit Cost Rule3BPLANBenefit plannvarchar40
112T7UNBEN_T5UCHNPO Benefit Cost Rule Text4BPLANBenefit plannvarchar40
TOPPublic sector Sweden
113T5SK0_CEKPA events8BPLANBenefit plannvarchar40
114T5SK1_CEKPA absences8BPLANBenefit plannvarchar40
115T5SK2_CEKPA income6BPLANBenefit plannvarchar40
TOPSweden
116T5SPPHR-SE: Information needed to be reported to Alecta16BPLANBenefit plannvarchar40
TOPUSA
117T5UPBSPA16Federal Health Plan Mapping (PS)4BPLANBenefit plannvarchar40