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

104 columns | Print definition?ERP 6.0  | PABRP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_RIDHHCM-FSCD: List of HCM Posting runs to be processed8PABRPPayroll Periodnvarchar20
2P01BN_STATStatus Table for Contribution Statements29PABRPPayroll period for determining time periodnvarchar20
3P01PF_REBUILDGarnishment Principle of Origin: Results of Rebuild15PABRPPayroll Periodnvarchar20
4P01PF_REB_HISTGarnishment Principle of Origin: Results of Rebuild History15PABRPPayroll Periodnvarchar20
5P2BG_BG_CUXDifference table of payroll results7PABRPPayroll period for determining time periodnvarchar20
6P2BG_BG_DIFDifference table of payroll results7PABRPPayroll period for determining time periodnvarchar20
7P2CO_COSSOPC2CO_SSO9PABRPPayroll Periodnvarchar20
8P2CO_COTAXPC2CO_TAX8PABRPPayroll Periodnvarchar20
9P2MX_GRORDMaintenance payment order14PABRPPayroll Periodnvarchar20
10P2NZ_P5NZBPayroll Result: Leave Balance P5NZB - NZ5PABRPPay period Numbernvarchar20
11P2PH_SSSBHR-PH: Include for SSS structure - Philippines7PABRPPayroll Periodnvarchar20
12P2RA_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
13P2RB_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
14P2RD_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
15P2RE_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
16P2RH_HU_NRENP21PA21PABRPPayroll Periodnvarchar20
17P2RI_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
18P2RJ_KGTKijungai time occured in for-period with Position info12PABRPPayroll period for determining time periodnvarchar20
19P2RK_GRORDPayroll results Canada: Garnishment order15PABRPPayroll Periodnvarchar20
20P2RK_VC2Vacation pay entitlement per reference year8PABRPPayroll Periodnvarchar20
21P2RN_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
22P2RO_RO_CUXDifference table of payroll results7PABRPPayroll period for determining time periodnvarchar20
23P2RO_RO_DIFDifference table of payroll results7PABRPPayroll period for determining time periodnvarchar20
24P2RQ_LSLPRPayroll Results: LSLPR Table6PABRPPayroll Periodnvarchar20
25P2RQ_LVEPRPayroll Results: LVEPR Table6PABRPPayroll Periodnvarchar20
26P2RQ_P5BALPayroll Results: P5BAL Table5PABRPPayroll Periodnvarchar20
27P2RQ_PASUMPayment summary components8PABRPPayroll Periodnvarchar20
28P2RQ_SUPCOMSuperable salary components6PABRPPayroll Periodnvarchar20
29P2RR_CAWPayroll Results: Table for CPF on AW/SG8PABRPPayroll Periodnvarchar20
30P2RR_RMPayroll Results: Table for Master data (SG)28PABRPPayroll Periodnvarchar20
31P2RR_SPPayroll Results: Special Payments34PABRPPayroll Periodnvarchar20
32P2RU_GRDOCPayroll Results: Garnishment for US Document24PABRPPayroll Periodnvarchar20
33P2RX_ARRRSPayroll Results: Arrears Table7PABRPPayroll Periodnvarchar20
34P2UA_UARFStructure for Ukrainian social insurance(PF) calculation7PABRPPayroll Periodnvarchar20
35P2UN_SUPCOMSuperable salary components For NPO6PABRPPayroll Periodnvarchar20
36T549QPayroll Periods4PABRPPayroll Periodnvarchar20
37T549SPersonnel Date Specifications Per Payroll Period6PABRPPayroll Periodnvarchar20
TOPAustria
38PA0978HR Master Record for Infotype 097825PABRPPayroll Periodnvarchar20
TOPCanada
39T5K8EHR-CA: Transfer additional external payroll results7PABRPPayroll Periodnvarchar20
TOPChile
40T7CL05Payment Distribution3PABRPPayroll Periodnvarchar20
TOPCompany Pension Scheme Germany
41P01CABRActions from Payroll Accounting5PABRPPayroll Periodnvarchar20
TOPConstruction Industry
42T5DBYConstruction Pay Data Center Numbers / SFP Data Medium9PABRPPayroll period for determining time periodnvarchar20
TOPDenmark
43T5M49Date Identifiers for Special Payroll6PABRPPayroll Periodnvarchar20
44T5M5YAssignment of Year and PBS Track to an Original Payroll3PABRPPayroll Periodnvarchar20
45T5M7DStatus Line for Payroll Run6PABRPPayroll Periodnvarchar20
46T5M7TPBS File Entries (HR DK Payroll)3PABRPPayroll Periodnvarchar20
47T5M7URetrieval of DA-DS Statistics3PABRPPayroll Periodnvarchar20
48T5M7WFile Entries Assignment from T5M7V5PABRPPayroll Periodnvarchar20
49T5M7XEntries for Form X1 - Special Payment Days3PABRPPayroll Periodnvarchar20
50T5M7ZField Values from Last Payroll3PABRPPayroll Periodnvarchar20
51T5M8EVerify Changes to Wage Type Texts3PABRPPayroll Periodnvarchar20
52T5M8SEmployer assignment in original period11PABRPPayroll Periodnvarchar20
53T5M8ZEmployer Assignment in Original Period14PABRPPayroll Periodnvarchar20
54T5MFDRetrieval of Official Statistics for DA/DS and FA4PABRPPayroll Periodnvarchar20
55T5MFHSpecial Transfer Days for Wage Types4PABRPPayroll Periodnvarchar20
56T5MFJCorrect FA Absence Statistics4PABRPPayroll Periodnvarchar20
57T5MP1General Messages for the PBS Remuneration Statement4PABRPPayroll Periodnvarchar20
TOPFinland
58T7FI549QFinnish pay periods to average calculation relevance4PABRPPayroll Periodnvarchar20
TOPGermany
59T5D15EDI Funds14PABRPPayroll Periodnvarchar20
60T5D16Advanced Payment - Statement of Contributions Paid5PABRPPayroll Periodnvarchar20
61T5D47Correction of Contributions on Basis of Previous Month3PABRPPayroll Periodnvarchar20
62T5D4UFile Numbers for E-Mail Procedure with Health Ins. Funds10PABRPPayroll Periodnvarchar20
TOPInterface to External Payroll Systems
63T5UOTTax Services: Terminations and Inactives9PABRPPayroll Periodnvarchar20
TOPOff-Cycle
64T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program12PABRPPayroll Periodnvarchar20
TOPPayroll
65P18_06Tabulka pre prenos vypocet koeficientov PPD v r.20012PABRPZúctovací období pro urcení cas.obdobínvarchar20
66PA3234HR master record, infotype 323436PABRPPayroll Periodnvarchar20
67T7SIRI8Index valorizacije od 20083PABRPObracunsko obdobjenvarchar20
TOPPayroll General Parts
68PA0267HR Master Record: Infotype 0267 (One time Payment off-cycle)34PABRPPayroll Periodnvarchar20
69T549MMonthly Assignment: Payroll Period (no longer used)4PABRPPayroll Periodnvarchar20
70T549ZCalendar for payment model5PABRPPayroll Periodnvarchar20
71T54C1Calendar for Cumulation5PABRPPayroll Periodnvarchar20
72T558BPayroll Account Transfer: Payroll Periods9PABRPPayroll Periodnvarchar20
73T569ULogs for Control Records8PABRPPayroll Periodnvarchar20
74T569VControl Records5PABRPPayroll Periodnvarchar20
TOPPension fund General Parts
75T5CPBHR-CH: Pension fund postings8PABRPPayroll Periodnvarchar20
76T72FAHR-PF: FI Index Table27PABRPPayroll Periodnvarchar20
TOPPension fund Netherlands
77T5ND1HR-CH: Pension fund postings8PABRPPayroll Periodnvarchar20
TOPPersonnel Administration
78PA0015HR Master Record: Infotype 0015 (Additional Payments)34PABRPPayroll Periodnvarchar20
79PA0832HR master record for infotypes 083225PABRPPayroll Periodnvarchar20
80T549URecurr. Pymts/Deducs: Payment Periods per Payment Interval4PABRPAccounting periodnvarchar20
81T7COT1Payroll external results transfer: COSSO9PABRPPayroll Periodnvarchar20
82T7COT7Payroll external results transfer: COTAX8PABRPPayroll Periodnvarchar20
83T7SIRSAverage republika Slovenia5PABRPPayroll Periodnvarchar20
TOPPersonnel Management
84/BKC/S21_COMPBC&T! - Time evaluation results3PABRPPayroll Periodnvarchar20
85/BKC/S21_COMPBNPC&T! - Time evaluation results2PABRPPayroll Periodnvarchar20
TOPPublic Sector
86T5PBSR2FSpecial MSO Calculation Rules6PABRPPayroll Periodnvarchar20
TOPRecruitment
87PB0015Applicant Master Record Infotype 0015 (Additional Payments)34PABRPPayroll Periodnvarchar20
TOPReporting
88P05T_CVZ_REGHCIB: Registration table4PABRPHCIB for periodnvarchar20
89P05T_CVZ_REG_DAT(De)registration data for HCIB4PABRPHCIB for periodnvarchar20
90P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand4PABRPHCIB for periodnvarchar20
TOPReuse Services for Country Development
91PA0262HR Master Record: Infotype 026226PABRPPayroll Periodnvarchar20
TOPSocial Insurance
92P01BD_STATData Module Alternative Correspondence Address17PABRPPayroll period for determining time periodnvarchar20
93P01BM_STATControl Records for PPO DEUEV Notifications21PABRPPayroll period for determining time periodnvarchar20
94P01BV_STATStatus Table for PPO Contribution Collect. Notif. Procedure20PABRPPayroll period for determining time periodnvarchar20
95P01D3_DSAPDEUEV Confirmation: Control Record for Notifications13PABRPPayroll period for determining time periodnvarchar20
96P01DS_STATControl Records for DEUEV Immediate Notifications21PABRPPayroll period for determining time periodnvarchar20
97P01EA_STATStatus Table for Reimbursement Process18PABRPPayroll period for determining time periodnvarchar20
98P01EE_STATAdmin. Records for Data Exchange for Compensation Benefits19PABRPPayroll period for determining time periodnvarchar20
99P01EL_PROTLog Table for the ELENA Procedure13PABRPPayroll period for determining time periodnvarchar20
100P01EL_STATStatus Table for the ELENA Notification Procedure18PABRPPayroll period for determining time periodnvarchar20
101P01ZS_STATStatus Table for Paying Office Procedure18PABRPPayroll period for determining time periodnvarchar20
TOPSpain
102T5EI6Arrears by period and grouper4PABRPPayroll Periodnvarchar20
TOPTools
103HRPYO_D_CYCLCycles7PABRPPayroll Periodnvarchar20
TOPUSA
104T5U8ATransfer ext.payroll result: Tax cumulation data (USA)4PABRPPayroll Periodnvarchar20