P2RB_SV - Social Insurance payroll Belgium

Social Insurance payroll Belgium information is stored in SAP table P2RB_SV.
It is part of development package PC12 in software component PY-BE. This development package consists of objects that can be grouped under "HR accounting: Belgium".

Fields for table P2RB_SV

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
.INCLUDEXHRDCT_S_PAYKEY0
MANDTClientXMANDTCLNT6*
.INCLUDEPCLKEYXHRDCT_S_PYPCL2KEY0
DCT_PERNRPersonnel NumberXP_PERNRNUMC16
DCT_SEQNRSequence NumberXCDSEQNUMC10HRPY_RGDIR
DCT_ROWIDUnique Row NumberXHRDCT_ROWIDNUMC10
.INCLUDEPC2800
CNTR1National assignment indicatorCNTRNRAW1
CNTR2National assignment indicatorCNTRNRAW1
BEGDAStart DateBEGDADATS16
ENDDAEnd DateENDDADATS16
ANSTAEmployment statusANSTANUMC2
JUPERLegal PersonJUPERCHAR8
BUKRSCompany CodeBUKRSCHAR8T001
WERKSPersonnel AreaPERSACHAR8T500P
BTRTLPersonnel SubareaBTRTLCHAR8T001P
PERSGEmployee GroupPERSGCHAR2T501
PERSKEmployee SubgroupPERSKCHAR4T503K
PERIDPersonnel ID NumberPRDNICHAR40
ENTKMDistance in KilometersENTKMDEC2
WKWNGCompany HousingWKWNGCHAR2
TEILKIndicator Part-Time EmployeeTEILKCHAR2
EMPCTEmployment percentageEMPCTDEC3
DYSCHCreate Daily Work Schedule DynamicallyDYSCHCHAR2
SCHKZWork Schedule RuleSCHKNCHAR16T508A
WOSTDHours per weekWOSTDDEC3
MOSTDMonthly hoursMOSTDDEC3
ARBSTDaily Working HoursSTDTGDEC3
BSGRDCapacity Utilization LevelBSGRDDEC3
BESTEFrequency of paymentBESTECHAR2T5B71
BERGMWeekly Workdays ScheduleBERGMCHAR2T5B72
BEREGEmployment PercentageBEREGCHAR2T5B73
CTTYPContract TypeCTTYPCHAR4T547V
ARBERExpiration Date of Work PermitARBERDATS16
BEANCSeniorityBEANCDATS16
BEAANContract time amountBEAANDEC2
BETIMContract periodBETIMCHAR6
BEGWUUnemployment paymentBEGWUCURR5
WAERSCurrency KeyWAERSCUKY10TCURC
BEUWGContractual Mean Working Hours per weekBEUWGDEC3
BECAOCollective AgreementBECAOCHAR8T5B6B
BEGPCJoint Commission (00046)BEGPCCHAR14T5B6C
BECNRContract NumberBECNRCHAR30
BEMCHMeal voucherBEMCHCHAR2
BEGFBEarly Retirement with Fixed CompensationBEGFBCHAR2
BEGGHEntitled Family MemberBEGGHCHAR2
BREGMRegulation contract months per yearBREGMCHAR4
RSZBLObsolete: SI/Belcotax country/regionRSZBLCHAR8T5B0F
RSZGLPlace/Country/Region of Birth (00169)RSZGLCHAR8T5B0F
RSZKEProfession GroupRSZKENUMC6T5B07
RSZNAObsolete: SI NationalityRSZNACHAR2T5B08
RSZPNPension NumberRSZPNCHAR20
RSZRRINSS - National ID Number (00024)RSZRRNUMC22
RSZVWPersonnel NumberPERNR_DNUMC16
RSZCAEmployer Class (SI Employer Category) (00036)RSZCACHAR6T5B02
RSZFFSI Position Code (00057)RSZFFCHAR4T5B05
RSZFSFactory Shutdown FundRSZFSCHAR4
RSZKNWorker Code (SI Employee Category) (00037)RSZKNCHAR6T5B01
RSZLMWage ReductionRSZLMCHAR2
RSZNOEmployee Notification (00053)RSZNOCHAR2T5B04
RSZSPEmployee SpecificationRSZSPCHAR4T5B03
RSZWGSI Contribution ReductionRSZWGCHAR4T5B09
BVETLConversion flagBVETLCHAR2
BVFAMMarital StatusBVFAMCHAR2T5B14
BVEKIPartner's IncomeBVEKICHAR2
FIXVAWorkdays SystemP12_WREFVCHAR2
PPAIDPercentage of Remuneration on a Yearly BasisP12_PPAIDDEC3
BEUW2Mean Number of Hours per WeekP12_BEUW2DEC3
REMESReorganization Measure (00051)P12_REMESNUMC6
EMPLPEmployment Promotion Measure (00052)P12_EMPLPROMNUMC6
APTYPApprenticeship Type (00055)P12_APPRTYPENUMC2
RETIRRetired (00054)P12_RETIREDCHAR2
MODRMRemuneration Method (00056)P12_MODEREMNUMC2
REDSTStart Date for Employer�s Deduction (00090)P12_REDSTARTDATS16
OSSINSocial Security Number of Replaced Worker #00092#P12_ORIGPERNRNUMC16
OREDDStart Date Reduction Replaced WorkerP12_ORIGREDDDATS16
ASSINSocial Security ID Number of Applicant (00093)P12_APPLPERNRNUMC16
CORIGPlace of Issue of Certificate (00094)P12_CERTORIGNUMC6
RFSCHReference Person's Work ScheduleP12_REFPERS_WSCHEDCHAR16*
LOCUNLocal Unit ID (00042)P12_LOCUNNUMC20
RSKACActivity With Risk (00041)P12_RISKACTNUMC6
ALLCDAllowance CodeP12_ALLCDCHAR4*
ALLSTAllowance Start DateP12_ALLSTDATS16
BVCOALegal CohabitationP12_BVCOACHAR2
MARBRDmfA: Social Maribel (00794)P12_MARIBELNUMC4
NACECEmployee Activity Code (NACE) (00228)P12P_ONSSAPLCODE76NUMC10*
OLDRROld National ID NumberOLDRRNUMC22
EERSTStart Date for Employee�s Restructuration ReductionP12_EE_RED_STARTDATS16
RDCSTFirst Hiring Date (00896)P12_RED_CONT_STARTDATS16
REMTYReorganization Measure TypeP12_REMES_TYPECHAR4
CAPEXCapelo Eligibility (01012)P12_CAPELO_EXEMPTEDCHAR2
DISPDDismissal PeriodP12_DISPDCHAR2
CFWPTCounter Former Work Placement TraineeP12_CFWPTNUMC2
DISHWHistorical Dismissal WeeksP12_DISHWDEC3
RCAINReason for Career InterruptionP12_RCAINCHAR2*
STYPEContribution Type (00083)P12_STYPENUMC2
TMPFTTemporary Full-Time ContractP12_TMPFTCHAR2
NMEDTNew Maribel Employment Date (01148)P12_NMEDTDATS16
PSPCCPSP Contribution Calculation Basis Derogation (01176)P12_PSPCCCHAR2
ILLDTSix Month Illness Date (00728)P12_ILLDTDATS16
SEREXWork Exemption (00826)P12_SEREXCHAR2
CARMECareer Measure (01194)P12_CARMECHAR4
SEXSDService Exemption Start Date (01191)P12_SEXSDDATS16
TRASITraining Situation (01193)P12_TRASICHAR4
PERSMPercentage Social MaribelP12_PERSMDEC3
SECDTSector Detail (01215)P12_SECDTNUMC8*
SUPCEExemption/Supplementary Pension Scheme (01013)P12_SUPPLPENSIONCONTRIBUTIONEXCHAR2
FLYCLFlying Staff Class (00059)P12_FLYSTAFCLASSNUMC2
PSTWOPosted Worker (00893)P12_PSTWONUMC2
DENODDefinitive Nomination Date (01092)P12_DENODDATS16
ESWDSExceptional Working Days System (00393)P12_EXCWRKDAYSSYSNUMC6
ESMWHExceptional Mean Working Hours (00554)P12_EXCWRKHOURSNUMC8
RSZLAOfficial LanguageRSZLALANG2*
REAMERegional Aid Measure (01237)P12_REAMECHAR4
CAPFOForce Capelo dataP12_CAPFOCHAR2
Privacy Policy