PTDB_ANWS SAP (Construction Industry SFP: Employee Statement) Structure details

Dictionary Type: Structure
Description: Construction Industry SFP: Employee Statement




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




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

PTDB_ANWS 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 "Construction Industry SFP: Employee Statement" 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_PTDB_ANWS TYPE PTDB_ANWS.

The PTDB_ANWS table consists of various fields, each holding specific information or linking keys about Construction Industry SFP: Employee Statement data available in SAP. These include PERNR (Personnel Number), INPER (In-Period for Evaluation for Social Fund Procedure), FPPER (For-Period for Evaluation for Social Fund Procedure), SEQNO (Key Field Sequence Number for SFP Data Records).. 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: Can be enhanced (character-type or numeric)


SAP PTDB_ANWS 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
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INPERIn-Period for Evaluation for Social Fund Procedure P01B_BKINPACCP6P01B_BKPER
FPPERFor-Period for Evaluation for Social Fund Procedure P01B_BKFUPACCP6P01B_BKPER
SEQNOKey Field Sequence Number for SFP Data Records P01B_BKSEQNUMC2NUM2
KENIDIdentifier of Record P01B_BKSIDCHAR5P01B_BKSID
ZVKASSocial Fund P01B_ZVKASCHAR2Assigned to domainP01B_ZVKAS
STATSStatus of Data Record in Social Fund Procedure P01B_BKSTACHAR2P01B_BKSTA
BESCHIndicator for Certified Data Record P01B_BKBESCHAR2P01B_BKBES
WERKSSending Personnel Area P01B_BKPEBCHAR4Assigned to domainPERSA
BTRTLSending Personnel Subarea P01B_BKPTBCHAR4Assigned to domainBTRTL
ZVKANEmployee Number at a Construction Social Insurance Fund P01B_BKANRNUMC13NUM13
BNRSKCompany Number at a Social Fund - Construction Industry P01B_BKBNRNUMC8P01B_BKBNR
BEGDAStart of Notification Period P01B_BKBEGDATS8DATUM
ENDDAEnd of Notification Period P01B_BKENDDATS8DATUM
RVJUTNumber of Leave Days P01B_BKUTGDEC2DEC2S
RVJUVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
RVJGTNumber of Leave Days P01B_BKUTGDEC2DEC2S
RVJGVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
RVJVTNumber of Leave Days P01B_BKUTGDEC2DEC2S
RVJVVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
BTAGEEmployment Days for Employee Statement P01B_BKBTADEC3DEC03
BLOHNGross Wage for Employee Statement P01B_BKBLNCURR9(2) WERTV5
PSATZPercentage for Leave Remuneration P01B_BKPRSNUMC4NUM4
UVERGLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
AGLSTNumber of Lost Hours P01B_BKANSDEC6(2) DEC4_2
AGLBTAdjustment Amount P01B_BKAGBCURR7(2) WERTV4
ULJUTNumber of Leave Days P01B_BKUTGDEC2DEC2S
ULJUVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
ULJGTNumber of Leave Days P01B_BKUTGDEC2DEC2S
ULJGVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
ULJVTNumber of Leave Days P01B_BKUTGDEC2DEC2S
ULJVVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
LAGBTLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
ULJRTNumber of Leave Days P01B_BKUTGDEC2DEC2S
ULJRVLeave Remuneration P01B_BKUVGCURR7(2) WERTV4
WAERSCurrency Key CURCYCUKY5Assigned to domainWAERSFWS
MSCHLNotification Key for Data Record ANMEL P01B_BKMSANUMC4P01B_BKMSA
BTAGE_VAGEmployment Days for Employee Statement (Prev.ER, Current Yr) P01B_BKBTA_VAGDEC3DEC03
BLOHN_VAGGross Wage for Employee Statement (Prev. ER, Current Year) P01B_BKBLN_VAGCURR9(2) WERTV5
PSATZ_VAGPercentage for Leave Remuneration (Prev. ER, Current Year) P01B_BKPRS_VAGNUMC4NUM4
ULJUT_VAGNumber of Leave Days (Previous Employer, Current Year) P01B_BKUTG_VAGDEC2DEC2S
ULJUV_VAGLeave Remuneration (Previous Employer, Current Year) P01B_BKUVG_VAGCURR7(2) WERTV4
AGLST_VAGNumber of Lost Hours (Previous Employer, Current Year) P01B_BKANS_VAGDEC6(2) DEC4_2
AGLBT_VAGAdjustment Amount (Previous Employer, Current Year) P01B_BKAGB_VAGCURR7(2) WERTV4
ULJRT_VAGRemaining Leave Days (Previous Employer, Current Year) P01B_BKUTR_VAGDEC2DEC2S
ULJRV_VAGRemaining Leave Remunation (Previous Employer, Current Year) P01B_BKUVR_VAGCURR7(2) WERTV4
RVJUT_VAGLeave Days from Previous Year from Previous Employer P01B_BKRVT_VAGDEC2DEC2S
RVJUV_VAGLeave Remuneration from Previous Year from Previous Employer P01B_BKRVV_VAGCURR7(2) WERTV4
RVJGT_VAGLeave Days Granted in Previous Year by Previous Employer P01B_BKRGT_VAGDEC2DEC2S
RVJGV_VAGLeave Remuneration Granted in Previous Year by Previous ER P01B_BKRGV_VAGCURR7(2) WERTV4
DATUM_VAGDate for Infotype 0190 P01B_DATUM_VAGDATS8DATUM
BTAGE_INSGEmployment Days Current Year (PER + Current Work Relations.) P01B_BTAGE_INSGDEC3DEC03
BLOHN_INSGGross Wage Current Year (PER + Current Working Relationship) P01B_BLOHN_INSGCURR9(2) WERTV5
ULJUT_INSGLeave Days Entitlement (PER Curr. Yr + Curr. ER in Curr. Yr) P01B_BKUTG_G_LFDEC2DEC2S
ULJUV_INSGLeave Remuneration Entitl. (PER Curr. Year + CER Curr. Year) P01B_BKUVG_G_LFCURR7(2) WERTV4
ULJRT_NVG_LFDTotal Available Leave Days Entitlement Current Year P01B_BKUTR_G_LFDEC2DEC2S
ULJRV_NVG_LFDAvailable Total Entitlement Leave Remuneration in Current Yr P01B_BKUVR_G_LFCURR7(2) WERTV4
VA_T_VJ_LFDJTotal Available Leave Days Entitlement (Prev. + Curr. Years) P01B_BKUTG_VJ_LFDJDEC2DEC2S
VA_V_VJ_LFDJTotal Available Entitlement to Leave Remuneration (PY + CY) P01B_BKUTV_VJ_LFDJCURR7(2) WERTV4
UDIVIDivisor: Leave Accrual P01B_UDIVIDEC4(2) DEC2_2
UDIVI_VAGDivisor: Leave Accrual Previous Employer P01B_UDIVI_VAGDEC4(2) DEC2_2
UVERG_VAGLeave Remuneration from Gross Pay All Prev. ERs Current Year P01B_BKUVERG_VAGCURR7(2) WERTV4
ULJGT_VAGLeave Days Granted (Previous Employer, Current Year) P01B_BKUGT_VAGDEC2DEC2S
ULJGV_VAGLeave Remuneration Granted (Previous Employer, Current Year) P01B_BKUGV_VAGCURR7(2) WERTV4
ULJGT_INSGLeave Days Granted (PER Current Year + Current in Curr. Yr) P01B_BKUGT_G_LFDEC2DEC2S
ULJGV_INSGLeave Remuneration Granted (Prev. ER Curr. Year + Curr. Yr.) P01B_BKUGV_G_LFCURR7(2) WERTV4
BEGDA_AUSBStart Date of Traineeship P01B_BEG_AUSBDATS8DATUM
ENDDA_AUSBEnd Date of Traineeship P01B_END_AUSBDATS8DATUM
BEGDA_DPFLStart Date of Statutory Official Duty P01B_BEG_GDPFLDATS8DATUM
ENDDA_DPFLEnd Date of Statutory Official Duty P01B_END_GDPFLDATS8DATUM
BNRSK_VAGPrevious Employer's Company Number at CI Social Fund P01B_BKBNR_VAGNUMC8P01B_BKBNR
MKLJAMLR from Illness, Current Year, Entitlement P01B_MKLJACURR7(2) WERTV4
MKLJSMLR from Illness, Current Year, Lost Hours P01B_MKLJSDEC6(2) DEC4_2
MSLJAMLR from SRHC, Current Year, Entitlement P01B_MSLJACURR7(2) WERTV4
MSLJSMLR from SRHC, Current Year, Lost Hours P01B_MSLJSDEC5(2) DEC3_2
MKLJA_VAGMLR from Illness, Current Year, Entitlement Previous ER P01B_MKLJA_VAGCURR7(2) WERTV4
MKLJS_VAGMLR from Illness, Current Year, Lost Hours Previous ER P01B_MKLJS_VAGDEC6(2) DEC4_2
MSLJA_VAGMLR from SRHC, Current Year, Entitlement Previous ER P01B_MSLJA_VAGCURR7(2) WERTV4
MSLJS_VAGMLR from SRHC, Current Year, Lost Hours Previous ER P01B_MSLJS_VAGDEC5(2) DEC3_2
MKVJAMLR from Illness, Previous Year, Entitlement P01B_MKVJACURR7(2) WERTV4
MSVJAMLR from SRHC, Previous Year, Entitlement P01B_MSVJACURR7(2) WERTV4
MKVJA_VAGMLR from Illness, Previous Year, Entitlement Previous ER P01B_MKVJA_VAGCURR7(2) WERTV4
MSVJA_VAGMLR from SRHC, Previous Year, Entitlement Previous ER P01B_MSVJA_VAGCURR7(2) WERTV4
MKVVAMLR from Illness, 2 Years Ago, Entitlement P01B_MKVVACURR7(2) WERTV4
MKVVA_VAGMLR from Illness, 2 Years Ago, Entitlement, Previous ER P01B_MKVVA_VAGCURR7(2) WERTV4
AANRETitle ANREDCHAR15TEXT15
ANAM1Name 1 of an address NAME1_ADRSCHAR40TEXT40
ANAM2Name 2 of an address NAME2_ADRSCHAR40TEXT40
ASTRAHouse number and street STRAS_GPCHAR35TEXT35
APSTLPostal code PSTLZ_BASCHAR10PSTLZ
AORT1City ORT01_GPCHAR35TEXT35
AORT2City ORT01_GPCHAR35TEXT35
SANRETitle ANREDCHAR15TEXT15
SNAM1Name 1 of an address NAME1_ADRSCHAR40TEXT40
SNAM2Name 2 of an address NAME2_ADRSCHAR40TEXT40
SSTRAHouse number and street STRAS_GPCHAR35TEXT35
SPSTLPostal code PSTLZ_BASCHAR10PSTLZ
SORT1City ORT01_GPCHAR35TEXT35
SORT2City ORT01_GPCHAR35TEXT35
GBDATDate of Birth P01B_BKGBDDATS8DATUM
GBORTBirthplace P01B_BKGBOCHAR30CHAR30
BEAJAStatement Year - Current BEAJACHAR4
BEVJAStatement Year - Previous Year BEVJACHAR4
BEVVJStatement Year - 2 Years Ago P01B_BEVVJCHAR4
BEFJAStatement Year - Following Year BEFJACHAR4
ADJFMIndicator 'Leaving in SRHC Period' P01B_ADJFMCHAR1XFELD
MSLJS_GESMLR from SRHC, Current Year, Lost Hours P01B_MSLJSDEC5(2) DEC3_2
MSLJA_GESMLR from SRHC, Current Year, Entitlement P01B_MSLJACURR7(2) WERTV4
ADDRESS 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3Assigned to domainLAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
SENDER 0
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 of an address NAME1_ADRSCHAR40TEXT40
NAME2Name 2 of an address NAME2_ADRSCHAR40TEXT40
NAME3Name 3 of an address NAME3_ADRSCHAR40TEXT40
NAME4Name 4 of an address NAME4_ADRSCHAR40TEXT40
STRASHouse number and street STRAS_GPCHAR35TEXT35
PFACHPO box PFACH_BASCHAR10PFACH
PSTL2PO Box postal code PSTL2_BASCHAR10PSTLZ
PFORTPO Box city PFORT_ADRSCHAR40TEXT40
LAND1Country Key LAND1CHAR3Assigned to domainLAND1LND
PSTLZPostal code PSTLZ_BASCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02City ORT01_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
INLNDCountry Key LAND1CHAR3Assigned to domainLAND1LND
ANZZLNumber of lines in address ANZEIDEC2ANZEI
PRIORAddress lines priority PRITY_ADRSCHAR9CHAR9
WARENDelivery address ID WARENCHAR1WAREN
LINE0Address line LINESCHAR80LINES
LINE1Address line LINESCHAR80LINES
LINE2Address line LINESCHAR80LINES
LINE3Address line LINESCHAR80LINES
LINE4Address line LINESCHAR80LINES
LINE5Address line LINESCHAR80LINES
LINE6Address line LINESCHAR80LINES
LINE7Address line LINESCHAR80LINES
LINE8Address line LINESCHAR80LINES
LINE9Address line LINESCHAR80LINES
LINEKAddress line LINESCHAR80LINES
LINEDAddress line LINESCHAR80LINES
LINED0Address line LINESCHAR80LINES
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME

Key field Non-key field



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

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

How to access SAP table PTDB_ANWS

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