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  | P2RD_VERSORGUNG
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
1ERP EHP76.0P2RD_VERSORGUNG1101Payroll Result: Pension Payment (PS)
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, DCT_PERNR, DCT_SEQNR, KVBEZ, PNRVE, EINVF, EINBV, GRDVF, STATV, VHSMX, VHSVB, VHSVA, ERH14, SBERE, KNZER, VHSER, TRGER, KUZHL, KUENE, ANTKZ, KNZVR, KNZRG, ANZKD, OZFKD, OZAEG, KGBSL, KNZBV, KNZE2, VHSE2, TRGE2, KNZE3, VHSE3, TRGE3, VHSAB, VHSWI, BOXAB, STAT2, VHSVB_VRGL, VHSMX_CAL, VHSVB_CAL, VHSAB_CAL, VHSVB_VRGL_CAL, RGBGD, DURYYP69, DURMMP69, DURDDP69, BOXP69, DURYYP6C, DURMMP6C, DURDDP6C, ANZ_MON_GES, ANZ_MON_ABW_LE36, ANZ_MON_ABW_GT36, BES_RGSK_F1991, GRD1_KUERZ_Z_N, GRD2_KUERZ_Z_N, ZUSTZL_KNZRG, DURYYZRN, DURMMZRN, DURDDZRN, DURYYZRU, DURMMZRU, DURDDZRU, DURYYZRA, DURMMZRA, DURDDZRA, KNZRGP18, ANTL_Z_P18, ANTL_N_P18, DURYYZRZ, DURMMZRZ, DURDDZRZ, KNZE4, VHSE4, TRGE4, KNZE5, VHSE5, TRGE5, KNZE6, VHSE6, TRGE6, KNZE7, VHSE7, TRGE7, KNZE8, VHSE8, TRGE8, ANZ_MON_P14A, ANZ_MON_P14A_CAL, UNTERH_BEITRAG, KUZHL_2, KUENE_2, EHENUMMER, DATUM_URTEIL_VOM, VERSAUSGL_MAN, VERSAUSGL_MAN_WA, VERSAUSGL_MAN_DT, KEINE_AUT_ANPSNG, VERS_AUFSCHL_CAL, VERS_AUFSCHL_MAN, VERS_AUFSCHL_BOX, VERS_MKM, ZUSCHLAG_WITWE, ZUSCHLAG_WITWE_W, ERHOEHUNG_RGVH, GRUND_WAISENGELD, KEINE_ZAHLUNG, ALTERSGELD, ANTRAGSDATUM, EP_RENTE FROM P2RD_VERSORGUNG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DCT_PERNRPersonnel Numbernvarchar80NUMC(N'00000000')NoP_PERNR Allow NULL? 
3DCT_SEQNRSequence Numbernvarchar50NUMC(N'00000')NoHRPY_RGDIRCDSEQ Allow NULL? 
4KVBEZPension Payment Indicatornvarchar40CHAR(N' ')Yes*KVBEZ Allow NULL? 
5PNRVEPersonnel Number of Pension Holder (HR-PSG)nvarchar80NUMC(N'00000000')Yes*PNRVE Allow NULL? 
6EINVFEntry: Pension Eventnvarchar80DATS(N'00000000')YesEINVF Allow NULL? 
7EINBVDate of Creation of Status of Public Officernvarchar80DATS(N'00000000')YesEINBV Allow NULL? 
8GRDVFReason for Incidence of Pension Eventnvarchar20CHAR(N' ')YesGRDVF Allow NULL? 
9STATVStatistics Indicator for Pensionsnvarchar20CHAR(N' ')YesSTATV Allow NULL? 
10VHSMXUpper Limit Percentage Pension 55decimal52DEC((0))YesVHSMX
11VHSVBPersonal Pension Percentagedecimal52DEC((0))YesVHSVB
12VHSVAPercentage for Pension Equalization Paymentdecimal52DEC((0))YesVHSVA
13ERH14Exception: No Increase Amountchar10CHAR(N' ')YesERH14 Allow NULL? 
14SBERESpecial Processing of Minimum Pensionchar10CHAR(N' ')YesSBERE Allow NULL? 
15KNZERBasis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
16VHSERPercentage Reimbursementdecimal52DEC((0))YesVHSER
17TRGERProvider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
18KUZHLNumerator for Reduction 1decimal84DEC((0))YesKUZHL_1
19KUENEDenominator for Reduction 1decimal62DEC((0))YesKUENE_1
20ANTKZProportional Family Reductionnvarchar30NUMC(N'000')YesANTKZ Allow NULL? 
21KNZVREarly Retirement Indicatorchar10CHAR(N' ')YesKNZVR Allow NULL? 
22KNZRGLegal Basis of Pension Calculationnvarchar20CHAR(N' ')YesKNZRG Allow NULL? 
23ANZKDNumber of Childrendecimal30DEC((0))YesANZKD
24OZFKDNumber of Children Entitled to Cost-of-Living Allowancedecimal30DEC((0))YesOZFKD
25OZAEGNumerator for Competition: Spouse Componentdecimal84DEC((0))YesKEHEZ
26KGBSLEntitlement Reasonnvarchar20CHAR(N' ')YesKGBSL Allow NULL? 
27KNZBVIndicator: Special Pension Calculationnvarchar20CHAR(N' ')YesKNZBV Allow NULL? 
28KNZE2Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
29VHSE2Percentage Reimbursementdecimal52DEC((0))YesVHSER
30TRGE2Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
31KNZE3Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
32VHSE3Percentage Reimbursementdecimal52DEC((0))YesVHSER
33TRGE3Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
34VHSABReduction of Pension Percentage Pensiondecimal52DEC((0))YesVHSAB
35VHSWIPercentage: Widow's Pensiondecimal52DEC((0))YesVHSWI
36BOXABCheckbox: Specify Pension Reductionchar10CHAR(N' ')YesBOXAB Allow NULL? 
37STAT2Statistics Indicator for Pensionsnvarchar20CHAR(N' ')YesSTATV Allow NULL? 
38VHSVB_VRGLComparison Pension Percentagedecimal52DEC((0))YesVHSVB_VRGL
39VHSMX_CALAutomatically Calculated Upper Limit Percentagedecimal52DEC((0))YesVHSMX_CAL
40VHSVB_CALAutomatic Personal Pension Percentagedecimal52DEC((0))YesVHSVB_CAL
41VHSAB_CALAutomatic Percentage Reduction of Pension BeamtVG Sec.14 P.3decimal52DEC((0))YesVHSAB_CAL
42VHSVB_VRGL_CALAutomatic Comparison Pension Percentage BeamtVG Sec.14 Par.4decimal52DEC((0))YesVHSVB_VRGL_CAL
43RGBGDCalculation Base of Pension Percentagechar10CHAR(N' ')YesPDE_PBSVAVG_RGBGD Allow NULL? 
44DURYYP69Employment Period of PS Employee Acc. to Sec69d Par4 (Years)decimal30DEC((0))YesPDE_PBSVAVG_P69DA4_DURYY
45DURMMP69Employment Period of PS Employee Acc. to Sec69d Par4 (Mnths)decimal20DEC((0))YesPDE_PBSVAVG_P69DA4_DURMM
46DURDDP69Employment Period of PS Employee Acc. to Sec69d Par4 (Days)decimal74DEC((0))YesPDE_PBSVAVG_P69DA4_DURDD
47BOXP69Checkbox: Standard Employment Period Sec.69d Para.4char10CHAR(N' ')YesPDE_PBSVAVG_P69DA4_BOX Allow NULL? 
48DURYYP6CEmployment Period of PS Employee Acc. to Sec69d Par4 (Years)decimal30DEC((0))YesPDE_PBSVAVG_P69DA4_DURYY_CAL
49DURMMP6CEmployment Period of PS Employee Acc. to Sec69d Par4 (Mnths)decimal20DEC((0))YesPDE_PBSVAVG_P69DA4_DURMM_CAL
50DURDDP6CEmployment Period of PS Employee Acc. to Sec69d Par4 (Days)decimal74DEC((0))YesPDE_PBSVAVG_P69DA4_DURDD_CAL
51ANZ_MON_GESNo. of Months with Entitlemt Child Bonus for Widow's Pensiondecimal30DEC((0))YesPDE_PBSVAVG_P50C_ANZ_MON_GES
52ANZ_MON_ABW_LE36No. of Months with Diff. Pay Scale Area in First 36 Monthsdecimal30DEC((0))YesPDE_PBSVAVG_P50C_MON_ABW_LE36
53ANZ_MON_ABW_GT36No. of Months with Diff. Pay Scale Area After First 36 Mnthsdecimal30DEC((0))YesPDE_PBSVAVG_P50C_MON_ABW_GT36
54BES_RGSK_F1991Specific Pension Scale Section 14, 1991 Versionchar10CHAR(N' ')YesPDE_PBSVAVG_P14_BES_RGSK_F1991 Allow NULL? 
55GRD1_KUERZ_Z_NReduction Reason 1 Numerator/Denominatornvarchar20CHAR(N' ')YesPDE_PBSVAVG_GRUND_1_Z_N Allow NULL? 
56GRD2_KUERZ_Z_NReduction Reason 2 Numerator/Denominatornvarchar20CHAR(N' ')YesPDE_PBSVAVG_GRUND_2_Z_N Allow NULL? 
57ZUSTZL_KNZRGAdditional Legal Basis of Pension Calculationnvarchar20CHAR(N' ')YesPDE_PBSVAVG_ZUSTZL_KNZRG Allow NULL? 
58DURYYZRNTotal Actual Time of Earlier Assessment (Years)decimal30DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURYY
59DURMMZRNTotal Actual Time of Earlier Assessment (Months)decimal20DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURMM
60DURDDZRNTotal Actual Time of Earlier Assessment (Days)decimal74DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURDD
61DURYYZRUTotal Actual Time of Earlier Assessment (Years)decimal30DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURYY
62DURMMZRUTotal Actual Time of Earlier Assessment (Months)decimal20DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURMM
63DURDDZRUTotal Actual Time of Earlier Assessment (Days)decimal74DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURDD
64DURYYZRATotal Actual Time of Earlier Assessment (Years)decimal30DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURYY
65DURMMZRATotal Actual Time of Earlier Assessment (Months)decimal20DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURMM
66DURDDZRATotal Actual Time of Earlier Assessment (Days)decimal74DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURDD
67KNZRGP18Legal Basis Sec.18 Death Benefitnvarchar20CHAR(N' ')YesPDE_PBSVAVG_P18_RGRNDL Allow NULL? 
68ANTL_Z_P18Proportion of Death Benefit Acc. to Sec. 18 Numeratordecimal30DEC((0))YesPDE_PBSVAVG_P18_ANTL_ZAEHLER
69ANTL_N_P18Proportion of Death Benefit According to Sec. 18 Denominatordecimal30DEC((0))YesPDE_PBSVAVG_P18_ANTL_NENNER
70DURYYZRZTotal Actual Time of Earlier Assessment (Years)decimal30DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURYY
71DURMMZRZTotal Actual Time of Earlier Assessment (Months)decimal20DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURMM
72DURDDZRZTotal Actual Time of Earlier Assessment (Days)decimal74DEC((0))YesPDE_PBSVAVG_REAK_P13A1_DURDD
73KNZE4Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
74VHSE4Percentage Reimbursementdecimal52DEC((0))YesVHSER
75TRGE4Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
76KNZE5Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
77VHSE5Percentage Reimbursementdecimal52DEC((0))YesVHSER
78TRGE5Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
79KNZE6Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
80VHSE6Percentage Reimbursementdecimal52DEC((0))YesVHSER
81TRGE6Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
82KNZE7Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
83VHSE7Percentage Reimbursementdecimal52DEC((0))YesVHSER
84TRGE7Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
85KNZE8Basis for Reimbursementnvarchar20CHAR(N' ')YesKNZER Allow NULL? 
86VHSE8Percentage Reimbursementdecimal52DEC((0))YesVHSER
87TRGE8Provider of Reimbursementnvarchar20CHAR(N' ')YesTRGER Allow NULL? 
88ANZ_MON_P14ALeading Months - Pension Percentage Increase (Manual)decimal30DEC((0))YesPDE_PBSVAVG_P14A_ANZ_MON
89ANZ_MON_P14A_CALAppl. Months - Pension Percentage Increase Sec.14a (Calc.)decimal30DEC((0))YesPDE_PBSVAVG_P14A_ANZ_MON_CAL
90UNTERH_BEITRAGBasis for Maintenance Paymentnvarchar20CHAR(N' ')YesPDE_PBSVAVG_UB Allow NULL? 
91KUZHL_2Numerator for Reduction 2decimal84DEC((0))YesKUZHL_2
92KUENE_2Denominator for Reduction 2decimal62DEC((0))YesKUENE_2
93EHENUMMERMarriage Numbernvarchar20CHAR(N' ')YesPDE_PBSVAVG_EHENUMMER Allow NULL? 
94DATUM_URTEIL_VOMStart Datenvarchar80DATS(N'00000000')YesBEGDA Allow NULL? 
95VERSAUSGL_MANPension Eqlztn Paymt Specified Manually Acc. to VersAusglGdecimal92CURR((0))YesPDE_PBS_VERSAUSGL_MAN
96VERSAUSGL_MAN_WACurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
97VERSAUSGL_MAN_DTKey Date of Pension Equalization Payment Specified Manuallychar10CHAR(N' ')YesPDE_PBS_VERSAUSGL_MAN_DATE Allow NULL? 
98KEINE_AUT_ANPSNGIndicator: No Automatic Adjustment Pension Equalztn Paymentchar10CHAR(N' ')YesPDE_PBS_KEINE_AUT_ANPS Allow NULL? 
99VERS_AUFSCHL_CALPercentage of Automatically Calculated Pension Pay Increasedecimal52DEC((0))YesPDE_PBSVAVG_VERS_AUFS_CAL
100VERS_AUFSCHL_MANPercentage of Manual Entry of Pension Pay Increasedecimal52DEC((0))YesPDE_PBSVAVG_VERS_AUFS_MAN
101VERS_AUFSCHL_BOXCheckbox: Manual Entry of Pension Pay Increasechar10CHAR(N' ')YesPDE_PBSVAVG_VERS_AUFS_BOX Allow NULL? 
102VERS_MKMPension Featurenvarchar20CHAR(N' ')YesPDE_PBSVAVG_VERS_MKM Allow NULL? 
103ZUSCHLAG_WITWEManually Entered Child Bonus for Widow's Pensiondecimal92CURR((0))YesPDE_PBSVAVG_ZUSCHLAG_WITWE
104ZUSCHLAG_WITWE_WCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
105ERHOEHUNG_RGVHIncrease of Pension Percent Due to Stat. Insurance Periodschar10CHAR(N' ')YesPDE_PBSVAVG_ERHOEHUNG_RGVH Allow NULL? 
106GRUND_WAISENGELDReason for Orphan's Benefitnvarchar20CHAR(N' ')YesPDE_PBSVAVG_GRD_WAISENGELD Allow NULL? 
107KEINE_ZAHLUNGInterruption of Paymentchar10CHAR(N' ')YesPDE_PBSVAVG_VA_KEINE_ZAHLUNG Allow NULL? 
108ALTERSGELDRetirement Pensionnvarchar20CHAR(N' ')YesPDE_PBSVAVG_ALTERSGELD Allow NULL? 
109ANTRAGSDATUMApplication Datenvarchar80DATS(N'00000000')YesPDE_PBSVAVG_ANTRAGSDATUM Allow NULL? 
110EP_RENTERemuneration Pointsdecimal74DEC((0))YesPDE_PBSVAVG_EP_RENTE
NamePrimaryUniqueTypeColumns
P2RD_VERSORGUNG~0YesYesCLUSTEREDDCT_SEQNR, DCT_PERNR, MANDT

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