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

102 columns | Print definition?ERP 6.0  | APZNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results10APZNRPC205 assignmentvarbinary10
2HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results13APZNRPC205 assignmentvarbinary10
3P2AR_ARDIVCorrection of days according to month divisor5APZNRPC205 assignmentvarbinary10
4P2AR_ARWPBPInformation annexed to WPBP table5APZNRPC205 assignmentvarbinary10
5P2B2_ABHCM Declustering B2 - Absences9APZNRPC205 assignmentvarbinary10
6P2B2_WPBPHCM Declustering B2 - Payroll Results Work Center/Basic Pay7APZNRPC205 assignmentvarbinary10
7P2BR_BRCGCEmployment/basic pay: additional information5APZNRPC205 assignmentvarbinary10
8P2BR_LADIVStructure with information for process table Div306APZNRPC205 assignmentvarbinary10
9P2CN_CNREIPayroll result: structure for retro difference details10APZNRPC205 assignmentvarbinary10
10P2CN_CNREOPayroll result: structure for retro difference details10APZNRPC205 assignmentvarbinary10
11P2CO_COAVAPC2CO_AVA24APZNRPC205 assignmentvarbinary10
12P2CO_COBTRPC2CO_BTR5APZNRPC205 assignmentvarbinary10
13P2CO_COSEVPC2CO_SEV5APZNRPC205 assignmentvarbinary10
14P2CO_COSSAPC2CO_SSA5APZNRPC205 assignmentvarbinary10
15P2CO_COSSPPC2CO_SSP5APZNRPC205 assignmentvarbinary10
16P2CO_LADIVStructure with Information for Div30 Process Table6APZNRPC205 assignmentvarbinary10
17P2HK_RETIPayroll structure for retroactive accounting12APZNRPC205 assignmentvarbinary10
18P2HK_RETOPayroll structure for retroactive accounting12APZNRPC205 assignmentvarbinary10
19P2IN_EPFPayroll structure for Provident Fund Infotype5APZNRPC205 assignmentvarbinary10
20P2IN_GRYPayroll structure for Gratuity5APZNRPC205 assignmentvarbinary10
21P2IN_LWFPayroll India - Labor Welfare Fund7APZNRPC205 assignmentvarbinary10
22P2IN_PTXPayroll India - Professional Tax5APZNRPC205 assignmentvarbinary10
23P2IN_SANPayroll structure for Superannuation5APZNRPC205 assignmentvarbinary10
24P2IS_RETIPayroll structure for retroactive accounting12APZNRPC205 assignmentvarbinary10
25P2IS_RETOPayroll structure for retroactive accounting12APZNRPC205 assignmentvarbinary10
26P2KR_BEN_BPSPayroll result for benefit point request5APZNRPC205 assignmentvarbinary10
27P2KZ_FUPStructure for Table FUP - Future Periods10APZNRPC205 assignmentvarbinary10
28P2KZ_KZAVCumulations for Calculation of Averages11APZNRPC205 assignmentvarbinary10
29P2NZ_SALSACSalary Sacrifice Details9APZNRPC205 assignmentvarbinary10
30P2PL_ZLAGROSSGross of wagetypes for PLZLA operation5APZNRPC205 assignmentvarbinary10
31P2RA_DFRTPayroll Result for Other Payroll Periods10APZNRPC205 assignmentvarbinary10
32P2RA_SV_STHR-AT: Transfer Data SI -> Tax for Special Payments9APZNRPC205 assignmentvarbinary10
33P2RB_BEEVLPayroll Results: Belgium table for Evaluation8APZNRPC205 assignmentvarbinary10
34P2RB_CIPayroll Result: Complementary Indemnity- CI (BE)6APZNRPC205 assignmentvarbinary10
35P2RB_CIPPayroll Result: Complementary Indemnity Payments (BE)7APZNRPC205 assignmentvarbinary10
36P2RD_DOC0Payroll Results; Additional Data C0 (PSG)5APZNRPC205 assignmentvarbinary10
37P2RD_DOWPPayroll Results; Additional Data WPBP (PSG)5APZNRPC205 assignmentvarbinary10
38P2RF_FPWPPC2LF5APZNRPC205 assignmentvarbinary10
39P2RF_WPEPayroll results; additional WPBP data5APZNRPC205 assignmentvarbinary10
40P2RH_HU_HKIFP21PB7APZNRPC205 assignmentvarbinary10
41P2RI_IPCUMRI cluster structure for cumulations (IPCUM)7APZNRPC205 assignmentvarbinary10
42P2RI_ITIOTRI cluster structure for retroactive accounting9APZNRPC205 assignmentvarbinary10
43P2RJ_JWPKJAdd to working place and basic pay (Japan)5APZNRPC205 assignmentvarbinary10
44P2RK_DOC0Payroll Results: Additional C0 Data (PSG)5APZNRPC205 assignmentvarbinary10
45P2RK_DOWPPayroll Results: Additional WPBP Data (PSG)5APZNRPC205 assignmentvarbinary10
46P2RP_LADIVStructure with Information for Div30 Process Table6APZNRPC205 assignmentvarbinary10
47P2RQ_HTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
48P2RQ_NTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
49P2RQ_QSUPSuperannuation structure for Australia22APZNRPC205 assignmentvarbinary10
50P2RQ_SMTHSMTH and SQTR for Superannuation (Australia)7APZNRPC205 assignmentvarbinary10
51P2RQ_SQTRSMTH and SQTR for Superannuation (Australia)7APZNRPC205 assignmentvarbinary10
52P2RQ_SUPCOMSuperable salary components8APZNRPC205 assignmentvarbinary10
53P2RR_RMPayroll Results: Table for Master data (SG)70APZNRPC205 assignmentvarbinary10
54P2RR_SRTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
55P2RU_CLMOverpayments Processing structure33APZNRPC205 assignmentvarbinary10
56P2RU_CLM_PERSONOverpayments Processing structure35APZNRPC205 assignmentvarbinary10
57P2RU_DOC0Payroll Results: Additional C0 Data (PSG)5APZNRPC205 assignmentvarbinary10
58P2RU_DOWPPayroll Results: Additional WPBP Data (PSG)5APZNRPC205 assignmentvarbinary10
59P2RU_TAXPRAuthorities tax prorates5APZNRPC205 assignmentvarbinary10
60P2RX_ABCluster RD/B2: Table AB7APZNRPC205 assignmentvarbinary10
61P2RX_ABCCumulation of Absence Classes7APZNRPC205 assignmentvarbinary10
62P2RX_ACCRPayroll Result: Month End Accruals7APZNRPC205 assignmentvarbinary10
63P2RX_C0Cost Distribution5APZNRPC205 assignmentvarbinary10
64P2RX_CODISTDistribution opf Liabilities9APZNRPC205 assignmentvarbinary10
65P2RX_FUNDAccounting Structure for Funds Management5APZNRPC205 assignmentvarbinary10
66P2RX_GRTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
67P2RX_LIDICost-Distributed Liabilities6APZNRPC205 assignmentvarbinary10
68P2RX_MODIFHR-PAY: Modifiers5APZNRPC205 assignmentvarbinary10
69P2RX_RTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
70P2RX_RT_PERSONResults Table (Person)11APZNRPC205 assignmentvarbinary10
71P2RX_WPBPPayroll Results: Work Center/Basic Pay5APZNRPC205 assignmentvarbinary10
72P2TN_TWOTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
73P2UA_FUPtable FUP - future periods10APZNRPC205 assignmentvarbinary10
74P2UA_UAAVHR-PAY: Cumulations for calculation of averages9APZNRPC205 assignmentvarbinary10
75P2UA_UARFStructure for Ukrainian social insurance(PF) calculation10APZNRPC205 assignmentvarbinary10
76P2UA_UARTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
77P2UA_UATIStructure for Ukrainian social insurance(PF) calculation11APZNRPC205 assignmentvarbinary10
78P2UA_UATRStructure for Ukrainian social insurance(PF) calculation11APZNRPC205 assignmentvarbinary10
79P2UA_UATSStructure for Ukrainian social insurance(PF) calculation11APZNRPC205 assignmentvarbinary10
80P2UN_DSBPDuty Station basic pay split extension5APZNRPC205 assignmentvarbinary10
81P2UN_HTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
82P2UN_NTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
83P2UN_RSUN Rental Subsidy internal structure5APZNRPC205 assignmentvarbinary10
84P2UN_SUPCOMSuperable salary components For NPO8APZNRPC205 assignmentvarbinary10
85P2UR_FUPtable FUP - future periods10APZNRPC205 assignmentvarbinary10
86P2UR_RUAVECumulations for calculation of averages9APZNRPC205 assignmentvarbinary10
87P2UR_RURTPayroll Results: Results Table7APZNRPC205 assignmentvarbinary10
88P2UR_RUSTARussian Statuses5APZNRPC205 assignmentvarbinary10
TOPAustria
89HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results8APZNRPC205 assignmentvarbinary10
TOPGermany
90T5D0IFictitious Run Control: Wage Type Assignment12APZNRDelete Indicator for WPBP Splitnvarchar10
TOPPayroll
91T5T558_ABHRCZ - Tabulka pro prenos neprítomností pri upgrade na SAP6APZNRPrirazení PC205varbinary10
92T7SK558_ABTransfer absences (supplement to T558D) - SK6APZNRPC205 assignmentvarbinary10
TOPPayroll General Parts
93T558DTransfer Wage Types with Split Indicator6APZNRHR: Outsourcing: Split Indicator - PC205 Assignmentnvarchar20
TOPPersonnel Administration
94T7COT2Payroll external results transfer: COSSA5APZNRPC205 assignmentvarbinary10
95T7COT3Payroll external results transfer: COSEV5APZNRPC205 assignmentvarbinary10
96T7COT5Payroll external results transfer: COBTR5APZNRPC205 assignmentvarbinary10
97T7COT8Payroll external results transfer: COAVA24APZNRPC205 assignmentvarbinary10
TOPPersonnel Management
98/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen8APZNRZuordnung PC205varbinary10
99/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.7APZNRZuordnung PC205varbinary10
100/BKC/S21_RTC&T! - Table RT for the payroll comparison programs9APZNRPC205 assignmentvarbinary10
101/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs11APZNRPC205 assignmentvarbinary10
102/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs8APZNRPC205 assignmentvarbinary10