HRDEBW_ARBEIT SAP (Structure for Statement of Employment, Section 312 SGB III) Structure details

Dictionary Type: Structure
Description: Structure for Statement of Employment, Section 312 SGB III




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




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

HRDEBW_ARBEIT 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 "Structure for Statement of Employment, Section 312 SGB III" 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_HRDEBW_ARBEIT TYPE HRDEBW_ARBEIT.

The HRDEBW_ARBEIT table consists of various fields, each holding specific information or linking keys about Structure for Statement of Employment, Section 312 SGB III data available in SAP. These include LINE0 (Address line), LINE1 (Address line), LINE2 (Address line), LINE3 (Address line).. 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 HRDEBW_ARBEIT 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
ABSENDER 0
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE_SHORTAddress line LINESCHAR80LINES
ADRESSE 0
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE_SHORTAddress line LINESCHAR80LINES
PERSDATEN 0
RVNUMPension Insurance Number RVNUMCHAR12RVNUM
GBDATDate of Birth GBDATDATS8PDATEGBDAT
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ASKNRApplicant: Customer Number P01W_ASKNRCHAR15CHAR15
STEUERKARTE 0
BEGDA1Start Date BEGDADATS8DATUM
STRKL1Tax Class (D) STRKLCHAR1STRKL
KDFBT1Number of Tax Exemptions for Children (D) KDFBTDEC3(1) DEC2_1
FAKTR1Factor for Factor Procedure P01_TX_FDEC4(3)
BEGDA0Start Date BEGDADATS8DATUM
STRKL0Tax Class (D) STRKLCHAR1STRKL
KDFBT0Number of Tax Exemptions for Children (D) KDFBTDEC3(1) DEC2_1
FAKTR0Factor for Factor Procedure P01_TX_FDEC4(3)
BESCHZEITRAUM 0
BESCHORTStatement of Employment: Last Place of Employment HRDEBW_BESCHORTCHAR48TEXT48
FEHLZEITEN 0
AVFREI 0
GESRV 0
GESRVYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KNAPPRVYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KUENDIGUNG 0
KDGAMTermination On P01W_KDGAMDATS8DATUM
KDZUMTermination On P01W_KDZUMDATS8DATUM
KUEND_TXTText (30 Characters) TEXT30CHAR30TEXT30
SCHRIFTLICHYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
BETRIEBSBEDYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KDSCHUTZKLYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
VERTRAGSWDYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
VERTRAGSWD_TXTTermination: Details P01W_KDSCHCHAR70TEXT70
ABMAHNUNGYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ABMAHNUNG_DATDate of Written Warning P01W_AMDATDATS8DATUM
ZUSVEREINBYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ZUSTELLUNGCommunication Type of Termination P01W_KDGSZCHAR40TEXT40
AGHAETTEYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
AGHAETTE_AMEmployer Would Have Terminated Work Relationship On P01_HKDAMDATS8DATUM
AGHAETTE_ZUMER Would Have Terminated Work Relationship Starting From P01_HKDZMDATS8DATUM
AGHAETTE_BBYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
AGHAETTE_VWYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KUENDIGUNG_SOZ 0
SOZAUSWYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
SAMMELYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ARGARBHR-DBW: Employment Office P01W_AMTGPCHAR30TEXT30
BEFRISTUNG 0
CTEDTContract End Date CTEDTDATS8DATUM
ABSCHLUSSDate of Temporary Work Relationship P01W_DATFRDATS8DATS
VERLAENGExtension of Employment Contract P01W_AVVRLDATS8DATUM
SCHRIFTLICHYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
WEITERBESCHYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
AUSBVERHYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
AVFORT 0
AVFORTYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
GRUNDWork/Employment Relationship: Reasons P01W_BVAVGCHAR70TEXT70
ZEITRAUMWork Relationship and Employment Relationship: Period P01W_BVAVZCHAR70TEXT70
ARBEITSZEIT 0
WOSTDHours per week WOSTDDEC5(2) STDAZ
TXT_VZTZText 14 HRDEBW_TXT14CHAR14HRDEBW_TXT14
JN_AZPZGYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
AZPZG_BEGStart Date BEGDADATS8DATUM
AZPZG_ENDEnd Date ENDDADATS8DATUM
JN_AZBSVYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
BSBEGStart of Agreement to Preserve Employment P01_BSBEGDATS8DATUM
BSENDEnd of Agreement to Preserve Employment P01_BSENDDATS8DATUM
BSAZTWorking Time with No Agreement to Preserve Employment P01_BSAZTDEC5(2) STDAZ
JN_AZSONYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ABEG1Deviations - Weekly Working Time: Start Date P01W_AWBEGDATS8DATUM
AEND1Deviations - Weekly Working Time: End Date P01W_AWENDDATS8DATUM
ASTW1Deviations - Weekly Working Time: Hours/Week P01W_AWSTWDEC5(2) STDAZ
ABEG2Deviations - Weekly Working Time: Start Date P01W_AWBEGDATS8DATUM
AEND2Deviations - Weekly Working Time: End Date P01W_AWENDDATS8DATUM
ASTW2Deviations - Weekly Working Time: Hours/Week P01W_AWSTWDEC5(2) STDAZ
AZGRDDeviations - Weekly Working Time: Reason P01W_AZGRDCHAR70TEXT70
VVOLLWorking Time of Comparable Full-Time Employee P01W_VVOLLDEC5(2) STDAZ
ENTGELT 0
ENTGELT_SUMME 0
BETRGHR Payroll: Amount MAXBTCURR15(2) PRBETRG
EINMALZ_JNYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
EINMALZ 0
NEUESBLANDYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
HEIMARBEIT 0
HAURJHomeworker: Vacation per Year P01W_HAURJNUMC3NUM03
HAURBHomeworker: Statemented Vacation Days P01W_HAURBNUMC3NUM03
HAUREHomeworker: Vacation Pay Included in Gross Remuneration P01W_HAURECURR13(2) P_AMT07V
HABEZText length 25 TEXT25CHAR25TEXT25
PFLEGEZGYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
PFLEGEZG_TAB 0
ZUSLEIST 0
ZULEIText (12 characters) TEXT12CHAR12TEXT12
ZLGRDReason for Unknown Supplementary Benefits P01W_ZLGRDCHAR40TEXT40
ZUSENTGELT 0
WEIAEYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
WADATContinued Remuneration To P01W_WADATDATS8DATUM
ZUSURLABG 0
URLABGYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
NEW_LEAVEEnd Date ENDDADATS8DATUM
ZUSABFINDUNG 0
ABFNDYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
LEISTUNGStatement Wage Type Text P01_BLATXCHAR70P01_BLATX
BETRGHR Payroll: Amount MAXBTCURR15(2) PRBETRG
UZUGHLength of Service P01_UZUGHDEC4P01_UZUGH
AUFBEYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ABF05Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
ZUSVRHSTD 0
VRUGDYes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
VRBEGEarly Retirement Pension: Start of Payment P01W_VRBEGDATS8DATUM
VRPRZEarly Retirement Pension: Rate P01W_VRPRZDEC5(2) P01W_VRPRZ
KDGFRText, 40 Characters Long TEXT40CHAR40TEXT40
KDGAUS 0
KDON0Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KDON2Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KDOGR1Exception Reasons for Termination P01W_KDOGRCHAR30TEXT30
KDON3Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KDOGR2Exception Reasons for Termination P01W_KDOGRCHAR30TEXT30
KHDABF 0
KDOA0Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
KDOA1Yes/No HRDEBW_TEXT4CHAR4HRDEBW_TEXT4
HINWEISEText for translation TEXT200CHAR200TEXT200
SIGNATUR 0
FIRMANAMEName 1 of an address NAME1_ADRSCHAR40TEXT40
FIRMAORTCity ORT01_GPCHAR35TEXT35
SACHNAMEName of authorized signatory SACN1CHAR32TEXT32
SACHANREDTitle ANREDCHAR15TEXT15
SACHTELTelephone Number for Queries STEL1CHAR14TELNR
AKTENZEICHENCharacter field of length 40 CHAR40CHAR40CHAR40
SWITCHES 0
ABSENDERCheckbox XFELDCHAR1XFELD
ADRESSECheckbox XFELDCHAR1XFELD
PERSDATENCheckbox XFELDCHAR1XFELD
STEUERKARTECheckbox XFELDCHAR1XFELD
BESCHZEITRAUMCheckbox XFELDCHAR1XFELD
BESCHORTCheckbox XFELDCHAR1XFELD
FEHLZEITENCheckbox XFELDCHAR1XFELD
BESTCLSTCheckbox XFELDCHAR1XFELD
TEILNPROJCheckbox XFELDCHAR1XFELD
AVFREICheckbox XFELDCHAR1XFELD
GESRVCheckbox XFELDCHAR1XFELD
KUENDIGUNGCheckbox XFELDCHAR1XFELD
KUENDIGUNG_SOZCheckbox XFELDCHAR1XFELD
BEFRISTUNGCheckbox XFELDCHAR1XFELD
AUSBVERHCheckbox XFELDCHAR1XFELD
AVFORTCheckbox XFELDCHAR1XFELD
ARBEITSZEITCheckbox XFELDCHAR1XFELD
ENTGELTCheckbox XFELDCHAR1XFELD
ENTGELT_SUMMECheckbox XFELDCHAR1XFELD
EINMALZCheckbox XFELDCHAR1XFELD
NEUESBLANDCheckbox XFELDCHAR1XFELD
HEIMARBEITCheckbox XFELDCHAR1XFELD
PFLEGEZGCheckbox XFELDCHAR1XFELD
ZUSLEISTCheckbox XFELDCHAR1XFELD
ZUSENTGELTCheckbox XFELDCHAR1XFELD
ZUSURLABGCheckbox XFELDCHAR1XFELD
ZUSABFINDUNGCheckbox XFELDCHAR1XFELD
ZUSVRHSTDCheckbox XFELDCHAR1XFELD
KDGFRCheckbox XFELDCHAR1XFELD
KDGAUSCheckbox XFELDCHAR1XFELD
KHDABFCheckbox XFELDCHAR1XFELD
HINWEISECheckbox XFELDCHAR1XFELD
SIGNATURCheckbox XFELDCHAR1XFELD
AKTENZEICHENCheckbox XFELDCHAR1XFELD

Key field Non-key field



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

As HRDEBW_ARBEIT 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 HRDEBW_ARBEIT as there is no data to select.

How to access SAP table HRDEBW_ARBEIT

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