T7BREFD_WRKPLC SAP (Workplace information) Table details

Dictionary Type: Table
Description: Workplace information




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




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

T7BREFD_WRKPLC is a standard SAP Table which is used to store Workplace information data and is available within R/3 SAP systems depending on the version and release level.

The T7BREFD_WRKPLC table consists of various fields, each holding specific information or linking keys about Workplace information data available in SAP. These include MANDT (Client), EVENT_ID (Event identifier), RECORD_ID (Record code), PARENT_ID (Parent record code).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP T7BREFD_WRKPLC 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
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20T7BREFD_EVENTHRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
WRKPLC_CODEWorkplace code HRPADBR_WRKPLC_CODECHAR30CHAR30
WRKPLC_DESCWorkplace description HRPADBR_WRKPLC_DESCCHAR100TEXT100
WRKPLC_TYPEWorkplace type HRPADBR_WRKPLC_TYPECHAR2CHAR2
WRKPLC_INSC_TYPERegistration type HRPADBR_WRKPLC_INSC_TYPECHAR1CHAR1
WRKPLC_INSC_NUMCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
ADDR_STREETStreet and House Number PAD_STRASCHAR60PAD_STRAS
ADDR_NUMHouse Number PAD_HSNMRCHAR10PAD_HSNMR
ADDR_COMPLSupplement HRPADBR_ADDR_COMPLCHAR30TEXT30
ADDR_DISTRICTDistrict PAD_ORT02CHAR40PAD_ORT01
ADDR_CITY_CODEMunicipality code HRPADBR_CITY_CODENUMC7NUMC07
ADDR_STATESTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
ADDR_TYPEStreet type HRPADBR_STREET_ADDRESS_TYPECHAR3CHAR3
ADDR_CEPCity postal code AD_PSTCD1CHAR10CHAR10
FPAS_CODESocial Assistance and Welfare Fund code PBR_FPASINUMC4NUMC4
THIRD_CODEThird-party code PBR_THIRINUMC4NUMC4
HIRER_INSC_TYPEContractor registration type HRPADBR_HIRER_INSC_TYPENUMC1NUMC1
HIRER_INSC_NUMContractor registration number HRPADBR_HIRER_INSC_NUMBERCHAR14CHAR14
CNO_OWNR_INSC_TYCNO owner registration type HRPADBR_CNO_OWNER_INSC_TYPENUMC1NUMC1
CNO_OWNR_INSC_NMCNO owner registration number HRPADBR_CNO_OWNER_INSC_NUMBERCHAR14CHAR14

Key field Non-key field



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

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

SELECT SINGLE *
FROM T7BREFD_WRKPLC
INTO CORRESPONDING FIELDS OF WA_T7BREFD_WRKPLC
WHERE...

How to access SAP table T7BREFD_WRKPLC

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