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

107 columns | Print definition?ERP 6.0  | JUPER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVLTHCM_APLNOApplication Number Organisational data (Before Conversion)13JUPERLegal Personnvarchar40
2CNVLTHCM_PERNRPersonnel Number Organisational data (Before Conversion)13JUPERLegal Personnvarchar40
3HRDCT_TPY_RGDIRDeclustering - Directory for Test Payroll Results14JUPERLegal Personnvarchar40
4P05TPRNL_EE_RGPension Return: Income Relationship - Sector Risk Group3JUPERLegal Personnvarchar40
5P05TPRNL_PR_OUTPension Return: PR - Output Data4JUPERLegal Personnvarchar40
6P05TPRNL_SYCHIRPension Return: System Change - IR Number per PERNR3JUPERLegal Personnvarchar40
7P2RB_STTax payroll Belgium10JUPERLegal Personnvarchar40
8P2RB_SVSocial Insurance payroll Belgium10JUPERLegal Personnvarchar40
9P2RD_STPayroll Result: Tax (G)8JUPERLegal Personnvarchar40
10P2RD_SVPayroll Result: Social Insurance8JUPERLegal Personnvarchar40
11P2RD_SVZPayroll Result: Supplementary Social Insurance10JUPERLegal Personnvarchar40
12P2RP_MFHR-PT: Payroll Results: Membership fees5JUPERLegal Personnvarchar40
13P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)5JUPERLegal Personnvarchar40
14P2RP_SSHR-PT: Payroll Results: Social Security35JUPERLegal Personnvarchar40
15P2RP_TXHR-PT: Payroll Results: Tax24JUPERLegal Personnvarchar40
16P2RT_SVStructure SV - insurance CZ8JUPERLegal Personnvarchar40
17P2RU_BALPayroll Results: Tax Retro Differences -(USA)18JUPERLegal Personnvarchar40
18P2RU_CLMOverpayments Processing structure16JUPERLegal Personnvarchar40
19P2RU_CLM_PERSONOverpayments Processing structure18JUPERLegal Personnvarchar40
20P2RU_DFRTPayroll Results: Retroaccounting Differences -DFRT- (USA)14JUPERLegal Personnvarchar40
21P2RU_UNBPayroll Results: Tax Retro Differences -(USA)18JUPERLegal Personnvarchar40
22P2RU_XDFRTPayroll Results: Tax Retro Differences -(USA)18JUPERLegal Personnvarchar40
23P2RV_STST for Norway (Cluster for tax)8JUPERLegal Personnvarchar40
24P2RX_VERSCPayroll Status Information6JUPERLegal Personnvarchar40
25P2SK_SVStructure of table SV - insurance SK8JUPERLegal Personnvarchar40
26P2VE_INC_EVALHRMS-VE: INCE Payment Results6JUPERLegal Personnvarchar40
27P2VE_LPH_EVALHRMS-VE: Results from Housing Scheme (RPVH)8JUPERLegal Personnvarchar40
28P2VE_SI_EVALHRMS-VE: Cumulated Social Insurance Results8JUPERLegal Personnvarchar40
29P2VE_TAX_EVALHRMS-VE: Information on Income Tax8JUPERLegal Personnvarchar40
30T5REGEmployee Information Log for Destruction of Data15JUPERLegal Personnvarchar40
31T5RPDPersonnel Data Deletion Log25JUPERLegal Personnvarchar40
32T77PAYKZBTBank Transfer Table Image (BTKZ)10JUPERLegal Personnvarchar40
33T7RU9AAddresses of organizations3JUPERLegal Personnvarchar40
34T7RUADVNADV-6-2 external sums4JUPERLegal Personnvarchar40
35T7RUDSV3RDSV-3: Run16JUPERLegal Personnvarchar40
36T7RUPACKGRPFR Packages group14JUPERLegal Personnvarchar40
TOPBelgium
37T5BVHSocial Balance Data3JUPERLegal Personnvarchar40
TOPCompany Pension Scheme Germany
38P01CVHActuarial CPS Header Records31JUPERLegal Personnvarchar40
TOPCross-Application Objects in HR
39HRP5581DB Table for Infotype 558130JUPERLegal Personnvarchar40
TOPNetherlands
40T5N5DNSI: Created Data Records2JUPERLegal Personnvarchar40
41T5N9AAuthority Addresses (NL)3JUPERLegal Personnvarchar40
TOPPayroll
42T5TA1External transfers10JUPERLegal Personnvarchar40
43T7SKA1External transfers10JUPERLegal Personnvarchar40
TOPPayroll General Parts
44HRPY_RGDIRDirectory for Payroll Results12JUPERLegal Personnvarchar40
45HRPY_RGDIR_TEMPInternal TEMPORARY Directory for Payroll Results12JUPERLegal Personnvarchar40
46PYORGSCREENPNP900 Selection Screen: Fields for Organizational Selection10JUPERLegal Personnvarchar40
TOPPersonnel Administration
47PA0001HR Master Record: Infotype 0001 (Org. Assignment)31JUPERLegal Personnvarchar40
48T001PPersonnel Area/Subarea14JUPERLegal Personnvarchar40
TOPPortugal
49T5P1JHR-PT: Grouping and characteristics of legal entity (JUPER2JUPERLegal Personnvarchar40
TOPPublic Sector
50P01O_TVOED_SZ_RREarlier December Data for RA Trigger: ASP TVoeD/TVAoeD4JUPERLegal Person on December 1 for Last November Payrollnvarchar40
51PDPBSZV363Estimated Tax-Free Contributions (Acc. to Sec.3 No.63)3JUPERLegal Personnvarchar40
TOPRecruitment
52PB0001HR Master Record: Infotype 0001 (Org. Assignment)31JUPERLegal Personnvarchar40
TOPReporting
53P05TPRNL_EE_ADMPension Return: Admin Income Relationship - Pers Level3JUPERLegal Personnvarchar40
54P05TPRNL_EE_ADMSPension Return: Admin of Status Income Relationship - Pers L3JUPERLegal Personnvarchar40
55P05TPRNL_EE_IRIPension Return: Income Relationship Indicators3JUPERLegal Personnvarchar40
56P05TPRNL_EE_IRPPension Return: Income Relationship - Income Period - Pers L3JUPERLegal Personnvarchar40
57P05TPRNL_EE_PDPension Return: Personal Data - Pers Level3JUPERLegal Personnvarchar40
58P05TPRNL_EE_PRPension Return: Income Relationship Pens/Ins Relationship PL3JUPERLegal Personnvarchar40
59P05TPRNL_EE_PRPPension Return: Income Rel - Pens/Ins Relation Period - PL3JUPERLegal Personnvarchar40
60P05TPRNL_EE_PRPIPension Return: Income Rel - Pens/Ins Rel Period Indic PL3JUPERLegal Personnvarchar40
61P05TPRNL_LP_ADMPension Return: Administration - Legal Pers Level3JUPERLegal Personnvarchar40
62P05TPRNL_LP_ADMSPension Return: Administration of Status - Legal Pers Level3JUPERLegal Personnvarchar40
63P05TPRNL_LP_COLLPension Return: Collective Return - Legal Pers Level3JUPERLegal Personnvarchar40
64P05T_AE_AANGIFTEWage Return: Administrative Unit - Collective Return2JUPERLegal Personnvarchar40
65P05T_AE_AANG_CUMWage Return: Cumulated Values Collective2JUPERLegal Personnvarchar40
66P05T_AE_ADMWage Return: Administrative Unit - Admin. Table2JUPERLegal Personnvarchar40
67P05T_AE_ADM_STATWage Return: Administrative Unit - Status Table2JUPERLegal Personnvarchar40
68P05T_AE_CORSALDOWage Return: Administrative Unit - Balance Adjustments2JUPERLegal Personnvarchar40
69P05T_AE_WGFWage Return: Administrative Unit - Redundancy Pay Scheme2JUPERLegal Personnvarchar40
70P05T_AE_WGF_CUMWage Return: Administrative Unit: Sect/Risk Group Cumulated2JUPERLegal Personnvarchar40
71P05T_A_EXTWage Return: Collective Employer Data - Wage Return2JUPERLegal Personnvarchar40
72P05T_CVZ_REGHCIB: Registration table2JUPERRepresenting Legal Personnvarchar40
73P05T_CVZ_REG_DAT(De)registration data for HCIB2JUPERRepresenting Legal Personnvarchar40
74P05T_CVZ_UITWCVZ: Tabel voor uitwisselingsbestand2JUPERRepresenting Legal Personnvarchar40
75P05T_EDM_PERSOONPersonal data for Day-one-announcement (EDM)2JUPERLegal Personnvarchar40
76P05T_IV_AANGIFTEWage Return: Income Relationship - Nominative Return2JUPERLegal Personnvarchar40
77P05T_IV_AANG_CUMWage Return: Cumulated Values per Income Relationship2JUPERLegal Personnvarchar40
78P05T_IV_AA_BSNWage Return: Cumulated Values for BSN Changers2JUPERLegal Personnvarchar40
79P05T_IV_ADMWage Return: Income Relationship - Admin. Table2JUPERLegal Personnvarchar40
80P05T_IV_ADM_STATWage Return: Income Relationship - Status Table2JUPERLegal Personnvarchar40
81P05T_IV_DAWage Return: Income Relationship - Return Data2JUPERLegal Personnvarchar40
82P05T_IV_DA_BSNWage Return: Other Cumulated Return Data2JUPERLegal Personnvarchar40
83P05T_IV_DA_CUMWage Return: Other Cumulated Return Data2JUPERLegal Personnvarchar40
84P05T_IV_INKPERWage Return: Income Relationship - Income Period2JUPERLegal Personnvarchar40
85P05T_IV_INKPERSAWage Return: Income Relationship - Income Period SI2JUPERLegal Personnvarchar40
86P05T_IV_PERSOONWage Return: Income Relationship - Personal Data2JUPERLegal Personnvarchar40
87P05T_IV_RGWage Return: Income Relationship - Risk Group Sector2JUPERLegal Personnvarchar40
88P05T_IV_RG_CUMWage Return: Income Relationship: Sect./Riskgrp. cumulated2JUPERLegal Personnvarchar40
89P05T_RESP2LAWage Return: Rel. between Response Message and Wage Return2JUPERLegal Personnvarchar40
90P05T_T_WCR_CODECodes for the Work Cost Regulation2JUPERLegal Personnvarchar40
91P05T_T_WCR_CODETWCR Code Description3JUPERLegal Personnvarchar40
92P05T_UITS_KENTIndicator Exclusion2JUPERRepresenting Legal Personnvarchar40
93P05T_WCR_CWTWCR Code for wage type2JUPERLegal Personnvarchar40
94P05T_WCR_EE_DATAWCR Data on Employee Level2JUPERLegal Personnvarchar40
95P05T_WCR_ER_DATAWCR Data on Employer Level2JUPERLegal Personnvarchar40
96P05T_WCR_ER_INFOWCR Info on Employer Level2JUPERLegal Personnvarchar40
97P05T_WCR_FLWCR: Final Levy and Final Settlement2JUPERLegal Personnvarchar40
98P05T_WCR_PROTWCR Protocol Table2JUPERLegal Personnvarchar40
99P05T_WCR_STATWCR Status Table2JUPERLegal Personnvarchar40
100T5N1LSocial Insurance Contribution Data2JUPERLegal Personnvarchar40
101T77PRNL_SYCHNGPension Return: System Change3JUPERLegal Personnvarchar40
TOPRussia
102T7RU9A_GRPAssignment groups to Organization3JUPERLegal Personnvarchar40
TOPSpain
103T5E02Company tax data2JUPERLegal Personnvarchar40
TOPVenezuela
104T7VEI2Transfer of external payroll results: INC contribution6JUPERLegal Personnvarchar40
105T7VEL1Transfer of ext. payroll res.: Housing Scheme (RPVH) contr.8JUPERLegal Personnvarchar40
106T7VES4Transfer of External Payroll Results: SSO/RPE8JUPERLegal Personnvarchar40
107T7VET1Transfer of External Payroll Results: Income Tax8JUPERLegal Personnvarchar40