T7GR3SIB SAP (Social Insurance Branches) Table details

Dictionary Type: Table
Description: Social Insurance Branches




ABAP Code to SELECT data from T7GR3SIB
Related tables to T7GR3SIB
Access table T7GR3SIB




Table field list including key, data, relationships and ABAP select examples

T7GR3SIB is a standard SAP Table which is used to store Social Insurance Branches data and is available within R/3 SAP systems depending on the version and release level.

The T7GR3SIB table consists of various fields, each holding specific information or linking keys about Social Insurance Branches data available in SAP. These include SIBCO (Social Insurance Branch Code), ENDDA (End Date), BEGDA (Start Date), BRTYP (SI Branch Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

Text table = T7GR3SIBT

Text table = T7GR3SIBT


SAP T7GR3SIB table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
SIBCOSocial Insurance Branch Code PGR_SIBCHAR20CHAR20
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
BRTYPSI Branch Type PGR_BR_TYPECHAR2T7GR3STDALLCHAR2
WT_EEEmployee's Wage type PGR_WT_EECHAR4T512WLGART
WT_ERER's Wage Type PGR_WT_ERCHAR4T512WLGART
CF_EEEE's Calculation Formula PGR_CFORM_EECHAR2T7GR3STDALLCHAR2
CF_ERER's Calculation Formula PGR_CFORM_ERCHAR2T7GR3STDALLCHAR2
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
PEREEPercentage EE PGR_PERC_EE4DEC6(3) DEC3_3V
PERERPercentage ER PGR_PERC_ER4DEC6(3) DEC3_3V
AMTEEEE's Amount PGR_AMOU_EECURR8(2) PGR_CURR8_2
AMTERER's Amount PGR_AMOU_ERCURR8(2) PGR_CURR8_2
SCAEEEE's Scale PGR_SCAL_EECHAR20T7GR3SCHCHAR20
SCAERER's Scale PGR_SCAL_ERCHAR20T7GR3SCHCHAR20
INLIEEE's Insurable Limit PGR_INSU_LIM_EECHAR20CHAR20
MNLIEEE's Minimum Insurable Limit PGR_MIN_INS_LIM_EECHAR20CHAR20
INLIRER's Insurable Limit PGR_INSU_LIM_ERCHAR20CHAR20
MNLIRER's Minimum Insurable Limit PGR_MIN_INS_LIM_ERCHAR20CHAR20
ILMPDInsurance Limit Calculated on Maximum Payroll Days PGR_INSU_LIM_PDCHAR2T7GR3STDALLCHAR2
ILMIDInsurance Limit Calculated on Maximum Insurance Days PGR_INSU_LIM_IDCHAR2T7GR3STDALLCHAR2
BASIDBased on Insurance Days PGR_BASED_IDCHAR2T7GR3STDALLCHAR2
BASRWBased on Payroll Run Weight PGR_BASED_RUNCHAR2T7GR3STDALLCHAR2
CHK35Check for 10 years entry and 35 years age PGR_10_35_TSMECHAR1PGR_10_35_TSME
SIBIDcSocial Insurance Branch Indicator PGR_SIB_INDCHAR2T7GR3STDALLCHAR2
JANEEJanuary EE PGR_01_EECHAR1PGR_MON_IND
FEBEEFebruary EE PGR_02_EECHAR1PGR_MON_IND
MAREEMarch EE PGR_03_EECHAR1PGR_MON_IND
APREEApril EE PGR_04_EECHAR1PGR_MON_IND
MAYEEMay EE PGR_05_EECHAR1PGR_MON_IND
JUNEEJune EE PGR_06_EECHAR1PGR_MON_IND
JULEEJule EE PGR_07_EECHAR1PGR_MON_IND
AUGEEAugust EE PGR_08_EECHAR1PGR_MON_IND
SEPEESeptember EE PGR_09_EECHAR1PGR_MON_IND
OCTEEOctober EE PGR_10_EECHAR1PGR_MON_IND
NOVEENovember EE PGR_11_EECHAR1PGR_MON_IND
DECEEDecember EE PGR_12_EECHAR1PGR_MON_IND
EB_EEEaster Bonus EE PGR_EB_EECHAR1PGR_MON_IND
CB_EEChristmas Bonus EE PGR_CB_EECHAR1PGR_MON_IND
LB_EELeave Bonus EE PGR_LB_EECHAR1PGR_MON_IND
JANERJanuary ER PGR_01_ERCHAR1PGR_MON_IND
FEBERFebruary ER PGR_02_ERCHAR1PGR_MON_IND
MARERMarch ER PGR_03_ERCHAR1PGR_MON_IND
APRERApril ER PGR_04_ERCHAR1PGR_MON_IND
MAYERMay ER PGR_05_ERCHAR1PGR_MON_IND
JUNERJune ER PGR_06_ERCHAR1PGR_MON_IND
JULERJule ER PGR_07_ERCHAR1PGR_MON_IND
AUGERAugust ER PGR_08_ERCHAR1PGR_MON_IND
SEPERSeptember ER PGR_09_ERCHAR1PGR_MON_IND
OCTEROctober ER PGR_10_ERCHAR1PGR_MON_IND
NOVERNovember ER PGR_11_ERCHAR1PGR_MON_IND
DECERDecember ER PGR_12_ERCHAR1PGR_MON_IND
EB_EREaster Bonus ER PGR_EB_ERCHAR1PGR_MON_IND
CB_ERChristmas Bonus ER PGR_CB_ERCHAR1PGR_MON_IND
LB_ERLeave Bonus ER PGR_LB_ERCHAR1PGR_MON_IND
WTIEEEmployee's Insurable Wage type PGR_WT_IEECHAR4Assigned to domainLGART
WTIERER's Insurable Wage Type PGR_WT_IERCHAR4Assigned to domainLGART

Key field Non-key field



How do I retrieve data from SAP table T7GR3SIB using ABAP code

The following ABAP code Example will allow you to do a basic selection on T7GR3SIB to SELECT all data from the table
DATA: WA_T7GR3SIB TYPE T7GR3SIB.

SELECT SINGLE *
FROM T7GR3SIB
INTO CORRESPONDING FIELDS OF WA_T7GR3SIB
WHERE...

How to access SAP table T7GR3SIB

Within an ECC or HANA version of SAP you can also view further information about T7GR3SIB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!