HRPAYBR_S_RAIS_11_REC1 SAP (SIAL: record type 1 (V. 2011)) Structure details

Dictionary Type: Structure
Description: SIAL: record type 1 (V. 2011)




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




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

HRPAYBR_S_RAIS_11_REC1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "SIAL: record type 1 (V. 2011)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_HRPAYBR_S_RAIS_11_REC1 TYPE HRPAYBR_S_RAIS_11_REC1.

The HRPAYBR_S_RAIS_11_REC1 table consists of various fields, each holding specific information or linking keys about SIAL: record type 1 (V. 2011) data available in SAP. These include CGCEI (Sial: CNPJ or SRS number), PREFI (SIAL: prefix of file's first establishment), TIPOR (Sial: record type), RAZAO (SIAL: responsible person's name or firm name).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP HRPAYBR_S_RAIS_11_REC1 structure 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
SEQUESIAL: file record sequence number PBR_SEQURNUMC6NUMC6
CGCEISial: CNPJ or SRS number PBR_CGCERNUMC14NUMC14
PREFISIAL: prefix of file's first establishment PBR_PREFICHAR2CHAR2
TIPORSial: record type PBR_TIPORCHAR1CHAR1
RAZAOSIAL: responsible person's name or firm name PBR_RAZAOCHAR52CHAR52
ENDERSIAL: responsible person's address PBR_ENDERCHAR40CHAR40
ENNUMSIAL: address number PBR_ENNUMNUMC6NUMC6
ENCOMSIAL: address affix PBR_ENCOMCHAR21CHAR21
ENBAISIAL: zone PBR_ENBAICHAR19CHAR19
ENCEPSIAL: postal code (PC) PBR_ENCEPCHAR8CHAR8
CDMUNSial: municipality code PBR_CDMUNCHAR7CHAR7
NOMUNSIAL: municipality name PBR_NOMUNCHAR30CHAR30
ENESTSIAL: FU identification code PBR_ENESTCHAR2CHAR2
DDDRASIAL: responsible person's telephone DDD PBR_DDDRANUMC2NUMC2
TELRASIAL: responsible person's telephone number PBR_TELRANUMC8NUMC8
EMAILSIAL: company e-mail PBR_EMAIL45CHAR45CHAR45
ECOATSIAL: economic activity (CNAE 2.0) PBR_ECOAT07NUMC7NUM7
NTJURSIAL: legal category PBR_NTJURCHAR4CHAR4
NPROPSIAL: number of owners PBR_PROPNUMC2NUMC2
DTBASSIAL: basic date PBR_DTBASCHAR2CHAR2
TPINSSIAL: establishment registration type PBR_TPINSCHAR1CHAR1
TRAISSIAL: SIAL type PBR_TRAISCHAR1CHAR1
CZEROSIAL: field with zeros PBR_ZEROSNUMC2NUMC2
NUCEISial: SRS number PBR_NUCEINUMC12NUMC12
ANORFSial: reference year PBR_ANOVGCHAR4CHAR4
INEMPCompany size indicator PBR_INEMPCHAR1PBR_INEMP
OPSIMSIAL: Indicator of optant for INSTMSC PBR_OPSIMCHAR1CHAR01
INPATSIAL: MAPW participation indicator (Meal All.Prog.at Work) PBR_INPATCHAR1CHAR01
NEL5SNo.of employees participating in MAPW up to 5 mininum wages PBR_NEL5SNUMC6NUMC6
NEM5SNo.of employees participating in MAPW w/more 5 mininum wages PBR_NEM5SNUMC6NUMC6
OWNSCOwn services - % regarding the total no.of employees PBR_OWNSCNUMC3NUMC3
KITADKitchen services - % regarding the total no.of employees PBR_KITADNUMC3NUMC3
MELAGMeal agreement - % regarding total no.of employees PBR_MELAGNUMC3NUMC3
MELTRMeal carried forward - % regarding total no.of employees PBR_MELTRNUMC3NUMC3
CEALI'Meals basket' - % regarding total no.of employees PBR_CEALINUMC3NUMC3
ALIAGMeals agreement - % regarding total no.of employees PBR_ALIAGNUMC3NUMC3
EDINDCompany's activities closing indicator PBR_EDINDCHAR1CHAR1
EDATECompany's activities closing date PBR_EDATEDATS8DATS
CNPJPATASCCNPJ of union which benefits from association contribution PBR_CNPJPATASCNUMC14NUMC14
CONTPATASCTotal amount of union association PBR_CONTPATASC_2010NUMC9NUM9
CNPJPATSINDCNPJ of union which benefits from union contribution PBR_CNPJPATSINDNUMC14NUMC14
CONTPATSINDTotal amount of union PBR_CONTPATSIND_2010NUMC9NUM9
CNPJPATASTCNPJ of union which benefits from assistance contribution PBR_CNPJPATASTNUMC14NUMC14
CONTPATASTTotal amount of union assistance PBR_CONTPATAST_2010NUMC9NUM9
CNPJPATCONFCNPJ of union which benefits from confederate contribution PBR_CNPJPATCONFNUMC14NUMC14
CONTPATCONFTotal amount of union confederate PBR_CONTPATCONF_2010NUMC9NUM9
COMPMOVEstablishment/entity with activity during basis year PBR_COMPMOVNUMC1NUMC1
CENTCOMPSIAL: union dues centralization indicator PBR_CENTCOMPNUMC1NUMC1
CNPJCENTCOMPCNPJ centralizing company PBR_CNPJCENTCOMPNUMC14NUMC14
INDICSINDIndicator - union worker PBR_INDICSINDNUMC1NUMC1
FILLER Blanks (93)0
USEMPSIAL: company exclusive use PBR_USEMP12CHAR12CHAR12
CRLFCRLF PBR_CRLFRAW2HEX002

Key field Non-key field



How do I retrieve data from SAP structure HRPAYBR_S_RAIS_11_REC1 using ABAP code?

As HRPAYBR_S_RAIS_11_REC1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on HRPAYBR_S_RAIS_11_REC1 as there is no data to select.

How to access SAP table HRPAYBR_S_RAIS_11_REC1

Within an ECC or HANA version of SAP you can also view further information about HRPAYBR_S_RAIS_11_REC1 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!