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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

115 columns | Print definition?ERP 6.0  | PABRJ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GSINS/INH_RIDHHCM-FSCD: List of HCM Posting runs to be processed7PABRJPayroll Yearnvarchar40
2CNVHCM_COMPARL_TTDMS4HCM: Protocoll information for payroll compare6PABRJPayroll Yearnvarchar40
3P01BN_STATStatus Table for Contribution Statements30PABRJPayroll year for determining time periodnvarchar40
4P01PF_REBUILDGarnishment Principle of Origin: Results of Rebuild16PABRJPayroll Yearnvarchar40
5P01PF_REB_HISTGarnishment Principle of Origin: Results of Rebuild History16PABRJPayroll Yearnvarchar40
6P2BG_BG_CUXDifference table of payroll results6PABRJPayroll year for determining time periodnvarchar40
7P2BG_BG_DIFDifference table of payroll results6PABRJPayroll year for determining time periodnvarchar40
8P2CO_COSSOPC2CO_SSO8PABRJPayroll Yearnvarchar40
9P2CO_COTAXPC2CO_TAX7PABRJPayroll Yearnvarchar40
10P2MX_GRORDMaintenance payment order15PABRJPayroll Yearnvarchar40
11P2NZ_P5NZBPayroll Result: Leave Balance P5NZB - NZ6PABRJPay Period Yearnvarchar40
12P2PH_SSSBHR-PH: Include for SSS structure - Philippines8PABRJPayroll Yearnvarchar40
13P2RA_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
14P2RB_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
15P2RD_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
16P2RE_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
17P2RH_HU_NRENP21PA20PABRJPayroll Yearnvarchar40
18P2RI_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
19P2RJ_KGTKijungai time occured in for-period with Position info11PABRJPayroll year for determining time periodnvarchar40
20P2RK_GRORDPayroll results Canada: Garnishment order16PABRJPayroll Yearnvarchar40
21P2RK_VC2Vacation pay entitlement per reference year7PABRJPayroll Yearnvarchar40
22P2RN_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
23P2RO_RO_CUXDifference table of payroll results6PABRJPayroll year for determining time periodnvarchar40
24P2RO_RO_DIFDifference table of payroll results6PABRJPayroll year for determining time periodnvarchar40
25P2RQ_LSLPRPayroll Results: LSLPR Table5PABRJPayroll Yearnvarchar40
26P2RQ_LVEPRPayroll Results: LVEPR Table5PABRJPayroll Yearnvarchar40
27P2RQ_P5BALPayroll Results: P5BAL Table6PABRJPayroll Yearnvarchar40
28P2RQ_PASUMPayment summary components7PABRJPayroll Yearnvarchar40
29P2RQ_SUPCOMSuperable salary components5PABRJPayroll Yearnvarchar40
30P2RR_CAWPayroll Results: Table for CPF on AW/SG7PABRJPayroll Yearnvarchar40
31P2RR_RMPayroll Results: Table for Master data (SG)27PABRJPayroll Yearnvarchar40
32P2RR_SPPayroll Results: Special Payments33PABRJPayroll Yearnvarchar40
33P2RU_GRDOCPayroll Results: Garnishment for US Document25PABRJPayroll Yearnvarchar40
34P2RX_ARRRSPayroll Results: Arrears Table6PABRJPayroll Yearnvarchar40
35P2UA_UARFStructure for Ukrainian social insurance(PF) calculation6PABRJPayroll Yearnvarchar40
36P2UN_SUPCOMSuperable salary components For NPO5PABRJPayroll Yearnvarchar40
37T549QPayroll Periods3PABRJPayroll Yearnvarchar40
38T549SPersonnel Date Specifications Per Payroll Period5PABRJPayroll Yearnvarchar40
39T7RU51AV_PRelation between Year and WType for income for this year4PABRJPayroll Yearnvarchar40
TOPAustria
40PA0978HR Master Record for Infotype 097824PABRJPayroll Yearnvarchar40
41T5A8DRevaluation Factor/Number4PABRJPayroll Yearnvarchar40
TOPBelgium
42T5BVPDefinition of SI periods3PABRJPayroll Yearnvarchar40
TOPCanada
43T5K8EHR-CA: Transfer additional external payroll results6PABRJPayroll Yearnvarchar40
TOPCompany Pension Scheme Germany
44P01CABRActions from Payroll Accounting4PABRJPayroll Yearnvarchar40
TOPConstruction Industry
45T5DBYConstruction Pay Data Center Numbers / SFP Data Medium8PABRJPayroll year for determining time periodnvarchar40
TOPDenmark
46T5M49Date Identifiers for Special Payroll5PABRJPayroll Yearnvarchar40
47T5M5YAssignment of Year and PBS Track to an Original Payroll4PABRJPayroll Yearnvarchar40
48T5M7DStatus Line for Payroll Run5PABRJPayroll Yearnvarchar40
49T5M7TPBS File Entries (HR DK Payroll)4PABRJPayroll Yearnvarchar40
50T5M7URetrieval of DA-DS Statistics4PABRJPayroll Yearnvarchar40
51T5M7WFile Entries Assignment from T5M7V6PABRJPayroll Yearnvarchar40
52T5M7XEntries for Form X1 - Special Payment Days4PABRJPayroll Yearnvarchar40
53T5M7ZField Values from Last Payroll4PABRJPayroll Yearnvarchar40
54T5M8EVerify Changes to Wage Type Texts4PABRJPayroll Yearnvarchar40
55T5M8PSAP-PBS interface: Transfer year-end values3PABRJPayroll Yearnvarchar40
56T5M8SEmployer assignment in original period10PABRJPayroll Yearnvarchar40
57T5M8ZEmployer Assignment in Original Period13PABRJPayroll Yearnvarchar40
58T5M9ASAP-PBS Interface: Transfer of New Year Values3PABRJPayroll Yearnvarchar40
59T5M9BSAP-PBS: Year End Values (Revision)3PABRJPayroll Yearnvarchar40
60T5M9CSAP-PBS Interface: New Year Values (Revision)3PABRJPayroll Yearnvarchar40
61T5MFDRetrieval of Official Statistics for DA/DS and FA5PABRJPayroll Yearnvarchar40
62T5MFHSpecial Transfer Days for Wage Types5PABRJPayroll Yearnvarchar40
63T5MFJCorrect FA Absence Statistics5PABRJPayroll Yearnvarchar40
64T5MP1General Messages for the PBS Remuneration Statement5PABRJPayroll Yearnvarchar40
TOPFinland
65T7FI549QFinnish pay periods to average calculation relevance3PABRJPayroll Yearnvarchar40
TOPGermany
66T5D15EDI Funds15PABRJPayroll Yearnvarchar40
67T5D16Advanced Payment - Statement of Contributions Paid4PABRJPayroll Yearnvarchar40
68T5D47Correction of Contributions on Basis of Previous Month2PABRJPayroll Yearnvarchar40
69T5D4UFile Numbers for E-Mail Procedure with Health Ins. Funds11PABRJPayroll Yearnvarchar40
TOPInterface to External Payroll Systems
70T5UOTTax Services: Terminations and Inactives8PABRJPayroll Yearnvarchar40
TOPOff-Cycle
71T52OCGOff-Cycle: Indicators for Batch: Payroll, Subsequent Program11PABRJPayroll Yearnvarchar40
TOPPayroll
72PA3234HR master record, infotype 323435PABRJPayroll Yearnvarchar40
73T7SIRIIndex valorizacije2PABRJObracunsko letonvarchar40
74T7SIRI8Index valorizacije od 20082PABRJObracunsko letonvarchar40
TOPPayroll General Parts
75PA0267HR Master Record: Infotype 0267 (One time Payment off-cycle)33PABRJPayroll Yearnvarchar40
76T549MMonthly Assignment: Payroll Period (no longer used)3PABRJPayroll Yearnvarchar40
77T549ZCalendar for payment model4PABRJPayroll Yearnvarchar40
78T54C1Calendar for Cumulation4PABRJPayroll Yearnvarchar40
79T558BPayroll Account Transfer: Payroll Periods8PABRJPayroll Yearnvarchar40
80T569ULogs for Control Records7PABRJPayroll Yearnvarchar40
81T569VControl Records4PABRJPayroll Yearnvarchar40
TOPPension fund General Parts
82T5CPBHR-CH: Pension fund postings9PABRJPayroll Yearnvarchar40
83T72FAHR-PF: FI Index Table28PABRJPayroll Yearnvarchar40
TOPPension fund Netherlands
84T5ND1HR-CH: Pension fund postings9PABRJPayroll Yearnvarchar40
TOPPersonnel Administration
85PA0015HR Master Record: Infotype 0015 (Additional Payments)33PABRJPayroll Yearnvarchar40
86PA0832HR master record for infotypes 083226PABRJPayroll Yearnvarchar40
87T549URecurr. Pymts/Deducs: Payment Periods per Payment Interval3PABRJPayroll Yearnvarchar40
88T549XRecurr. Pymts/Deducs: Payment Periods3PABRJPayroll Yearnvarchar40
89T7COT1Payroll external results transfer: COSSO8PABRJPayroll Yearnvarchar40
90T7COT7Payroll external results transfer: COTAX7PABRJPayroll Yearnvarchar40
91T7SIRSAverage republika Slovenia6PABRJPayroll Yearnvarchar40
TOPPersonnel Management
92/BKC/S21_COMPBC&T! - Time evaluation results2PABRJPayroll Yearnvarchar40
93/BKC/S21_COMPBNPC&T! - Time evaluation results1PABRJPayroll Yearnvarchar40
TOPPublic Sector
94T5PBSR2FSpecial MSO Calculation Rules5PABRJPayroll Yearnvarchar40
TOPRecruitment
95PB0015Applicant Master Record Infotype 0015 (Additional Payments)33PABRJPayroll Yearnvarchar40
TOPReporting
96P05T_CVZ_REGHCIB: Registration table3PABRJHCIB for year periodnvarchar40
97P05T_CVZ_REG_DAT(De)registration data for HCIB3PABRJHCIB for year periodnvarchar40
98P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand3PABRJHCIB for year periodnvarchar40
TOPReuse Services for Country Development
99PA0262HR Master Record: Infotype 026227PABRJPayroll Yearnvarchar40
TOPSocial Insurance
100P01BD_STATData Module Alternative Correspondence Address18PABRJPayroll year for determining time periodnvarchar40
101P01BM_STATControl Records for PPO DEUEV Notifications22PABRJPayroll year for determining time periodnvarchar40
102P01BV_STATStatus Table for PPO Contribution Collect. Notif. Procedure21PABRJPayroll year for determining time periodnvarchar40
103P01D3_DSAPDEUEV Confirmation: Control Record for Notifications14PABRJPayroll year for determining time periodnvarchar40
104P01DS_STATControl Records for DEUEV Immediate Notifications22PABRJPayroll year for determining time periodnvarchar40
105P01EA_STATStatus Table for Reimbursement Process19PABRJPayroll year for determining time periodnvarchar40
106P01EE_STATAdmin. Records for Data Exchange for Compensation Benefits20PABRJPayroll year for determining time periodnvarchar40
107P01EL_PROTLog Table for the ELENA Procedure14PABRJPayroll year for determining time periodnvarchar40
108P01EL_STATStatus Table for the ELENA Notification Procedure19PABRJPayroll year for determining time periodnvarchar40
109P01ZS_STATStatus Table for Paying Office Procedure19PABRJPayroll year for determining time periodnvarchar40
TOPSpain
110T5EI6Arrears by period and grouper3PABRJPayroll Yearnvarchar40
TOPTaiwan
111T7TW1NSequence number of LI/NHI reporting2PABRJPayroll Yearnvarchar40
112T7TW2FSequence number of income tax return reporting3PABRJPayroll Yearnvarchar40
113T7TW2GTax media filing sequence number reservation4PABRJPayroll Yearnvarchar40
TOPTools
114HRPYO_D_CYCLCycles6PABRJPayroll Yearnvarchar40
TOPUSA
115T5U8ATransfer ext.payroll result: Tax cumulation data (USA)3PABRJPayroll Yearnvarchar40