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

Home | ERP 6.0 
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

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

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy