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

125 columns | Print definition?ERP 6.0  | INPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVHCM_COMPARLOGTDMS4HCM: Protocoll information for payroll compare6INPERTDMS4HCM: In-period for payrollnvarchar60
2HRBW_REC_DTPY-XX-RECON : Country specific reports detailed results8INPERIn-period for payrollnvarchar60
3HRBW_REC_DT_NEWPY-XX-RECON : Country specific reports detailed results9INPERIn-period for payrollnvarchar60
4HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results12INPERIn-period for payrollnvarchar60
5HRPADDE_D_DN_CIDest. Rep. Data: Const. "Business Complete" Information3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
6P01PF_PFBB_DIRPO Rebuild: Transfer Garnishable Amount Directly6INPERIn-period for garnishmentsnvarchar60
7P2CO_COAVAPC2CO_AVA9INPERIn-period for payrollnvarchar60
8P2CO_COBTRPC2CO_BTR19INPERIn-period for payrollnvarchar60
9P2CO_COGARPC2CO_GAR8INPERIn-period for payrollnvarchar60
10P2CO_COSSAPC2CO_SSA9INPERIn-period for payrollnvarchar60
11P2KZ_FUPStructure for Table FUP - Future Periods5INPERPayroll periodnvarchar60
12P2NZ_EMSPayroll Result: Employer Monthly Schedule - NZ8INPERIn-period for payrollnvarchar60
13P2RA_DFRTPayroll Result for Other Payroll Periods6INPERIn-period for payrollnvarchar60
14P2RC_WHTPPC2CH027INPERIn-Periodnvarchar60
15P2RG_COSTSDistribution of Employer's Cost (Payroll Function XDEC)9INPERXDEC: In Pay Period (YYYYPP)nvarchar60
16P2RG_WEARNNI: payment history of affected wagetype8INPERIn-period for payrollnvarchar60
17P2RH_HU_CDIFDifferences spanning over year-limit7INPERIn-period for payrollnvarchar60
18P2RH_HU_DDIFDifferences spanning over year-limit6INPERIn-period for payrollnvarchar60
19P2RH_HU_JKORDifferences spanning over year-limit5INPERIn-period for payrollnvarchar60
20P2RH_HU_KDIFDifferences spanning over year-limit5INPERIn-period for payrollnvarchar60
21P2RH_HU_NRBEIrregular incomes from infotype 32345INPERIn-period for payrollnvarchar60
22P2RU_COSTSDistribution of Employer's Cost (Payroll Function XDEC)9INPERXDEC: In Pay Period (YYYYPP)nvarchar60
23P2RX_EVAL_PERIODIndex for Payroll Results Periods5INPERIn-period for payrollnvarchar60
24P2RX_VERSCPayroll Status Information15INPERIn-period for payrollnvarchar60
25P2UA_FUPtable FUP - future periods5INPERPayroll periodnvarchar60
26P2UR_FUPtable FUP - future periods5INPERPayroll periodnvarchar60
27T449USettings for Collective Display of MRP List20INPERInternal period indicatornvarchar10
28T5FDSNAB_FRTemp table for PAYFR_RESULT-AB_FR6INPERIn-period for payrollnvarchar60
29T5FDSNACTITemp table for PAYFR_RESULT-ACTI6INPERPériode courante de la paienvarchar60
30T5FDSNCTTemp table for PAYFR_RESULT-CT6INPERPériode courante de la paienvarchar60
31T5FDSNFPERSTemp table for PAYFR_RESULT-FPERS6INPERIn-period for payrollnvarchar60
32T5FDSNPAYMTemp table for PAYFR_RESULT-PAYM6INPERPériode courante de la paienvarchar60
33T5FDSNREMTemp table for PAYFR_RESULT-REM6INPERPériode courante de la paienvarchar60
34T5FDSNSUSPENSIONTemp table for PAYFR_RESULT-SUSPENSION6INPERIn-period for payrollnvarchar60
35T5H7VK100 data4INPERIn-period for payrollnvarchar60
36T5Q_SUPERSTREAMSuper Stream Master Table8INPERIn-period for payrollnvarchar60
37T5TPENSAVData for pension savings3INPERReported in periodnvarchar60
38T5TPENSAV_YSPension savings - annual reporting3INPERReported in periodnvarchar60
39T5UMRCross month retro-calculations9INPERIn-period for payrollnvarchar60
40T77PAYKZBTBank Transfer Table Image (BTKZ)8INPERIn-period for payrollnvarchar60
41T7ROA8Contr. G - Deducted Amount6INPERIn-period for payrollnvarchar60
42UMD01Default values for MRP16INPERInternal period indicatornvarchar10
TOPAustria
43HRPAYAT_PAYRSRESSaves Wage Types from Simulated Payroll Results5INPERIn-period for payrollnvarchar60
44T5A71L16 Consolidation File122INPERLast In-Period of Payroll in the Recordnvarchar60
45T5A72BGN(GKK) Consolidation File47INPERLast In-Period of Payroll in the Recordnvarchar60
46T5A73BGN(BVA) Consolidation File51INPERLast In-Period of Payroll in the Recordnvarchar60
47T5A74E18 Consolidation File69INPERLast In-Period of Payroll in the Recordnvarchar60
TOPCanada
48T5KRMCanadian Tax Remittance Form PD7A Data20INPERPayroll period IPnvarchar20
TOPConstruction Industry
49PDBKADCI: Social Fund Procedure: Records Management3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
50PDBKANConstruction Industry Social Fund Proced: ANMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
51PDBKAUConstruction Industry Social Fund Proced: AUMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
52PDBKBEConstr. Ind. Social Fund Procedure: BEMEL (PerNo) Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
53PDBKBESUMConstr. Ind. Social Fund Procedure: BEMEL Records (Total)3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
54PDBKLOConstruction Industry Social Fund Proced: LOMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
55PDBKNEConstruction Industry Social Fund Proced: NEMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
56PDBKNWConstruction Industry Social Fund Proced: Employee Statement3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
57PDBKRAConstruction Industry Social Fund Proced: RAMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
58PDBKURConstruction Industry Social Fund Proced: URMEL Data Records3INPERIn-Period for Evaluation for Social Fund Procedurenvarchar60
TOPGarnishmentCession
59P01PF_RT_EPGarnishment Pr. of Origin: Results of Garnishment Calc.3INPERIn-period for garnishmentsnvarchar60
60P01PF_TILGGarnishment of Principle of Origin: Repayment Amounts3INPERIn-period for garnishmentsnvarchar60
TOPItaly
61PA3206HR Master Record: Infotype 320629INPERIn-period for payrollnvarchar60
62T5ITF24Archive F244INPERYear/Monthnvarchar60
63T5ITF24AArchive F24 Administration4INPERYear/Monthnvarchar60
64T5ITPOS_AHeader table for traceability3INPERIn-period for payrollnvarchar60
TOPNew Zealand
65HNZLVPAYTable for modified LVPAY cluster table records4INPERIn-period for payrollnvarchar60
TOPPayroll
66T5H83Data of other legal relationships6INPERIn-period for payrollnvarchar60
67T5HNRHU_NREN payroll table data of the "current month"3INPERIn-period for payrollnvarchar60
68T5HPBS_HAVIBONTComm. - payments monthly breakdown by persons8INPERIn-period for payrollnvarchar60
69T5HS1HR-H: Havi bevallás - bevallási adatok4INPERBérszámfejtés tárgyperiódusanvarchar60
70T5HS4HR-H: Havi bevallás - Élesben futtatott hónapok (bárkód)3INPERBérszámfejtés tárgyperiódusanvarchar60
71T5HS7HR-H: Havi bevallás - bevallási adatok - adózónként3INPERBérszámfejtés tárgyperiódusanvarchar60
72T5HS8HR-H: Havi bevallás - adózót terhelo egyéb kötelezettségek3INPERBérszámfejtés tárgyperiódusanvarchar60
73T5HSE12. lap Önellenorzés3INPERBérszámfejtés tárgyperiódusanvarchar60
74T5HSHHR-H: Havi bevallás - Kijelölés helyesbítésre3INPERBérszámfejtés tárgyperiódusanvarchar60
75T5HSJHavi bevallás - bevallási adatok - munkavállalónként4INPERBérszámfejtés tárgyperiódusanvarchar60
76T5HSKHavi bevallás - külso bevallási adatok - adózónként3INPERBérszámfejtés tárgyperiódusanvarchar60
77T5HSMHavi bevallás - külso bevallási adatok magánszemély (I.né)4INPERBérszámfejtés tárgyperiódusanvarchar60
78T5HSNHavi bevallás - külso bevallási adatok - adózó (I.né)3INPERBérszámfejtés tárgyperiódusanvarchar60
79T5HSRHR-H: Havi bevallás - nemnegatív járulékbérelemek3INPERBérszámfejtés tárgyperiódusanvarchar60
80T5HSSHavi bevallás - külso-belso adatok összesítve - adózó3INPERBérszámfejtés tárgyperiódusanvarchar60
81T5HSTHavi bevallás- külso-belso adatok összesítve - személy4INPERBérszámfejtés tárgyperiódusanvarchar60
82T5HSVHR-H: Havi bevallás - bevallási adatok (negyedéves)4INPERBérszámfejtés tárgyperiódusanvarchar60
83T5HSWHR-H: Havi bevallás - bevallási adatok - adózó (n.éves)3INPERBérszámfejtés tárgyperiódusanvarchar60
84T5HSXHavi bevallás - külso-belso adatok összesítve adózó I. né3INPERBérszámfejtés tárgyperiódusanvarchar60
85T5HSYHavi bevallás- külso-belso adatok összesítve személy I.né4INPERBérszámfejtés tárgyperiódusanvarchar60
86T5HV0IHavi adóbevallás adatainak (T5HV0) index táblája5INPERBérszámfejtés tárgyperiódusanvarchar60
87T5HV0I_BCKHavi adóbevallás adatainak (T5HV0) index táblája backup5INPERBérszámfejtés tárgyperiódusanvarchar60
88T5HV4Élesben futtatott hónapok (BAR-kód) (havi adóbevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
89T5HV7Bevallási adatok adózónként (havi adóbevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
90T5HV8Vállalati összesíto egyéb adatok (havi bevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
91T5HVHKijelölés helyesbítésre (havi bevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
92T5HVKKülso bevallási adatok adózónként (havi bevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
93T5HVRNemnegatív járulékbérelemek (havi bevallás)3INPERBérszámfejtés tárgyperiódusanvarchar60
94T7ROA3Insurance result table - Person 1:1 with RGDIR10INPERIn-period for payrollnvarchar60
95T7ROA6Contr. H - received/deducted amount from the authorities6INPERIn-period for payrollnvarchar60
96T7ROERHR Cluster 2 - ER Insurances5INPERIn-period for payrollnvarchar60
TOPPayroll General Parts
97HRPY_RGDIRDirectory for Payroll Results10INPERIn-period for payrollnvarchar60
98HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results10INPERIn-period for payrollnvarchar60
99PYNOSCREENSelection Screen Fields (Only as Interface)2INPERIn-period for payrollnvarchar60
TOPPersonnel Administration
100T7COT2Payroll external results transfer: COSSA9INPERIn-period for payrollnvarchar60
101T7COT5Payroll external results transfer: COBTR19INPERIn-period for payrollnvarchar60
102T7COT6Payroll external results transfer: COGAR8INPERIn-period for payrollnvarchar60
103T7COT8Payroll external results transfer: COAVA9INPERIn-period for payrollnvarchar60
TOPPersonnel Management
104/BKC/S21_EVSol21: Vergleich von Abrechnungsergebnissen4INPERInperiode der Abrechnungnvarchar60
105/BKC/S21_EV1Sol21: Vergleich von Abrechnungsergebnissen - ohne PERNR.3INPERInperiode der Abrechnungnvarchar60
106/BKC/S21_RTC&T! - Table RT for the payroll comparison programs4INPERIn-period for payrollnvarchar60
107/BKC/S21_RT_NEUC&T! - Table RT for the payroll comparison programs4INPERIn-period for payrollnvarchar60
108/BKC/S21_RT_NOPNC&T! - Table RT for the payroll comparison programs3INPERIn-period for payrollnvarchar60
TOPPersonnel Time Management
109T559MReduction Rules for Absence Quota Generation8INPERReference period to determine inactive daysnvarchar10
TOPPublic Sector
110PDPBSZV363Estimated Tax-Free Contributions (Acc. to Sec.3 No.63)6INPERIn-Period for Payrollnvarchar60
111PDPBSZVADMAdministration Table for ZVE-PBS Notification Procedure9INPERIn-Period for Payrollnvarchar60
TOPPublic sector Sweden
112T5SA0_CEAlecta11INPERIn-period for payrollnvarchar60
113T5SK0_CEKPA events5INPERIn-period for payrollnvarchar60
114T5SK1_CEKPA absences6INPERIn-period for payrollnvarchar60
115T5SK2_CEKPA income4INPERIn-period for payrollnvarchar60
116T5SP0_CEPA91 periods8INPERIn-period for payrollnvarchar60
117T5SP1_CEPA91 absence8INPERIn-period for payrollnvarchar60
118T5SP2_CEPA91 income7INPERIn-period for payrollnvarchar60
119T5SS0_CEPA03 periods9INPERIn-period for payrollnvarchar60
120T5SS1_CEPA03 absences10INPERIn-period for payrollnvarchar60
121T5SS2_CEPA03 income7INPERIn-period for payrollnvarchar60
122T5SS3_CEPA03 pernr7INPERIn-period for payrollnvarchar60
TOPTax Reporter
123T51TXTransfer to be Evaluated9INPERIn-period for payrollnvarchar60
124T5UQRCross quarter retro-calculations8INPERIn-period for payrollnvarchar60
TOPUSA
125PA0909HR Master Record: Infotype 090929INPERIn-period for payrollnvarchar60