PTDB_ANWS SAP (Construction Industry SFP: Employee Statement) Structure details
Description: Construction Industry SFP: Employee Statement
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 |
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
INPER | In-Period for Evaluation for Social Fund Procedure | P01B_BKINP | ACCP | 6 | P01B_BKPER | ||||
FPPER | For-Period for Evaluation for Social Fund Procedure | P01B_BKFUP | ACCP | 6 | P01B_BKPER | ||||
SEQNO | Key Field Sequence Number for SFP Data Records | P01B_BKSEQ | NUMC | 2 | NUM2 | ||||
KENID | Identifier of Record | P01B_BKSID | CHAR | 5 | P01B_BKSID | ||||
ZVKAS | Social Fund | P01B_ZVKAS | CHAR | 2 | Assigned to domain | P01B_ZVKAS | |||
STATS | Status of Data Record in Social Fund Procedure | P01B_BKSTA | CHAR | 2 | P01B_BKSTA | ||||
BESCH | Indicator for Certified Data Record | P01B_BKBES | CHAR | 2 | P01B_BKBES | ||||
WERKS | Sending Personnel Area | P01B_BKPEB | CHAR | 4 | Assigned to domain | PERSA | |||
BTRTL | Sending Personnel Subarea | P01B_BKPTB | CHAR | 4 | Assigned to domain | BTRTL | |||
ZVKAN | Employee Number at a Construction Social Insurance Fund | P01B_BKANR | NUMC | 13 | NUM13 | ||||
BNRSK | Company Number at a Social Fund - Construction Industry | P01B_BKBNR | NUMC | 8 | P01B_BKBNR | ||||
BEGDA | Start of Notification Period | P01B_BKBEG | DATS | 8 | DATUM | ||||
ENDDA | End of Notification Period | P01B_BKEND | DATS | 8 | DATUM | ||||
RVJUT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJUV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
RVJGT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJGV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
RVJVT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
RVJVV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
BTAGE | Employment Days for Employee Statement | P01B_BKBTA | DEC | 3 | DEC03 | ||||
BLOHN | Gross Wage for Employee Statement | P01B_BKBLN | CURR | 9(2) | WERTV5 | ||||
PSATZ | Percentage for Leave Remuneration | P01B_BKPRS | NUMC | 4 | NUM4 | ||||
UVERG | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
AGLST | Number of Lost Hours | P01B_BKANS | DEC | 6(2) | DEC4_2 | ||||
AGLBT | Adjustment Amount | P01B_BKAGB | CURR | 7(2) | WERTV4 | ||||
ULJUT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJUV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJGT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJGV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJVT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJVV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
LAGBT | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
ULJRT | Number of Leave Days | P01B_BKUTG | DEC | 2 | DEC2S | ||||
ULJRV | Leave Remuneration | P01B_BKUVG | CURR | 7(2) | WERTV4 | ||||
WAERS | Currency Key | CURCY | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
MSCHL | Notification Key for Data Record ANMEL | P01B_BKMSA | NUMC | 4 | P01B_BKMSA | ||||
BTAGE_VAG | Employment Days for Employee Statement (Prev.ER, Current Yr) | P01B_BKBTA_VAG | DEC | 3 | DEC03 | ||||
BLOHN_VAG | Gross Wage for Employee Statement (Prev. ER, Current Year) | P01B_BKBLN_VAG | CURR | 9(2) | WERTV5 | ||||
PSATZ_VAG | Percentage for Leave Remuneration (Prev. ER, Current Year) | P01B_BKPRS_VAG | NUMC | 4 | NUM4 | ||||
ULJUT_VAG | Number of Leave Days (Previous Employer, Current Year) | P01B_BKUTG_VAG | DEC | 2 | DEC2S | ||||
ULJUV_VAG | Leave Remuneration (Previous Employer, Current Year) | P01B_BKUVG_VAG | CURR | 7(2) | WERTV4 | ||||
AGLST_VAG | Number of Lost Hours (Previous Employer, Current Year) | P01B_BKANS_VAG | DEC | 6(2) | DEC4_2 | ||||
AGLBT_VAG | Adjustment Amount (Previous Employer, Current Year) | P01B_BKAGB_VAG | CURR | 7(2) | WERTV4 | ||||
ULJRT_VAG | Remaining Leave Days (Previous Employer, Current Year) | P01B_BKUTR_VAG | DEC | 2 | DEC2S | ||||
ULJRV_VAG | Remaining Leave Remunation (Previous Employer, Current Year) | P01B_BKUVR_VAG | CURR | 7(2) | WERTV4 | ||||
RVJUT_VAG | Leave Days from Previous Year from Previous Employer | P01B_BKRVT_VAG | DEC | 2 | DEC2S | ||||
RVJUV_VAG | Leave Remuneration from Previous Year from Previous Employer | P01B_BKRVV_VAG | CURR | 7(2) | WERTV4 | ||||
RVJGT_VAG | Leave Days Granted in Previous Year by Previous Employer | P01B_BKRGT_VAG | DEC | 2 | DEC2S | ||||
RVJGV_VAG | Leave Remuneration Granted in Previous Year by Previous ER | P01B_BKRGV_VAG | CURR | 7(2) | WERTV4 | ||||
DATUM_VAG | Date for Infotype 0190 | P01B_DATUM_VAG | DATS | 8 | DATUM | ||||
BTAGE_INSG | Employment Days Current Year (PER + Current Work Relations.) | P01B_BTAGE_INSG | DEC | 3 | DEC03 | ||||
BLOHN_INSG | Gross Wage Current Year (PER + Current Working Relationship) | P01B_BLOHN_INSG | CURR | 9(2) | WERTV5 | ||||
ULJUT_INSG | Leave Days Entitlement (PER Curr. Yr + Curr. ER in Curr. Yr) | P01B_BKUTG_G_LF | DEC | 2 | DEC2S | ||||
ULJUV_INSG | Leave Remuneration Entitl. (PER Curr. Year + CER Curr. Year) | P01B_BKUVG_G_LF | CURR | 7(2) | WERTV4 | ||||
ULJRT_NVG_LFD | Total Available Leave Days Entitlement Current Year | P01B_BKUTR_G_LF | DEC | 2 | DEC2S | ||||
ULJRV_NVG_LFD | Available Total Entitlement Leave Remuneration in Current Yr | P01B_BKUVR_G_LF | CURR | 7(2) | WERTV4 | ||||
VA_T_VJ_LFDJ | Total Available Leave Days Entitlement (Prev. + Curr. Years) | P01B_BKUTG_VJ_LFDJ | DEC | 2 | DEC2S | ||||
VA_V_VJ_LFDJ | Total Available Entitlement to Leave Remuneration (PY + CY) | P01B_BKUTV_VJ_LFDJ | CURR | 7(2) | WERTV4 | ||||
UDIVI | Divisor: Leave Accrual | P01B_UDIVI | DEC | 4(2) | DEC2_2 | ||||
UDIVI_VAG | Divisor: Leave Accrual Previous Employer | P01B_UDIVI_VAG | DEC | 4(2) | DEC2_2 | ||||
UVERG_VAG | Leave Remuneration from Gross Pay All Prev. ERs Current Year | P01B_BKUVERG_VAG | CURR | 7(2) | WERTV4 | ||||
ULJGT_VAG | Leave Days Granted (Previous Employer, Current Year) | P01B_BKUGT_VAG | DEC | 2 | DEC2S | ||||
ULJGV_VAG | Leave Remuneration Granted (Previous Employer, Current Year) | P01B_BKUGV_VAG | CURR | 7(2) | WERTV4 | ||||
ULJGT_INSG | Leave Days Granted (PER Current Year + Current in Curr. Yr) | P01B_BKUGT_G_LF | DEC | 2 | DEC2S | ||||
ULJGV_INSG | Leave Remuneration Granted (Prev. ER Curr. Year + Curr. Yr.) | P01B_BKUGV_G_LF | CURR | 7(2) | WERTV4 | ||||
BEGDA_AUSB | Start Date of Traineeship | P01B_BEG_AUSB | DATS | 8 | DATUM | ||||
ENDDA_AUSB | End Date of Traineeship | P01B_END_AUSB | DATS | 8 | DATUM | ||||
BEGDA_DPFL | Start Date of Statutory Official Duty | P01B_BEG_GDPFL | DATS | 8 | DATUM | ||||
ENDDA_DPFL | End Date of Statutory Official Duty | P01B_END_GDPFL | DATS | 8 | DATUM | ||||
BNRSK_VAG | Previous Employer's Company Number at CI Social Fund | P01B_BKBNR_VAG | NUMC | 8 | P01B_BKBNR | ||||
MKLJA | MLR from Illness, Current Year, Entitlement | P01B_MKLJA | CURR | 7(2) | WERTV4 | ||||
MKLJS | MLR from Illness, Current Year, Lost Hours | P01B_MKLJS | DEC | 6(2) | DEC4_2 | ||||
MSLJA | MLR from SRHC, Current Year, Entitlement | P01B_MSLJA | CURR | 7(2) | WERTV4 | ||||
MSLJS | MLR from SRHC, Current Year, Lost Hours | P01B_MSLJS | DEC | 5(2) | DEC3_2 | ||||
MKLJA_VAG | MLR from Illness, Current Year, Entitlement Previous ER | P01B_MKLJA_VAG | CURR | 7(2) | WERTV4 | ||||
MKLJS_VAG | MLR from Illness, Current Year, Lost Hours Previous ER | P01B_MKLJS_VAG | DEC | 6(2) | DEC4_2 | ||||
MSLJA_VAG | MLR from SRHC, Current Year, Entitlement Previous ER | P01B_MSLJA_VAG | CURR | 7(2) | WERTV4 | ||||
MSLJS_VAG | MLR from SRHC, Current Year, Lost Hours Previous ER | P01B_MSLJS_VAG | DEC | 5(2) | DEC3_2 | ||||
MKVJA | MLR from Illness, Previous Year, Entitlement | P01B_MKVJA | CURR | 7(2) | WERTV4 | ||||
MSVJA | MLR from SRHC, Previous Year, Entitlement | P01B_MSVJA | CURR | 7(2) | WERTV4 | ||||
MKVJA_VAG | MLR from Illness, Previous Year, Entitlement Previous ER | P01B_MKVJA_VAG | CURR | 7(2) | WERTV4 | ||||
MSVJA_VAG | MLR from SRHC, Previous Year, Entitlement Previous ER | P01B_MSVJA_VAG | CURR | 7(2) | WERTV4 | ||||
MKVVA | MLR from Illness, 2 Years Ago, Entitlement | P01B_MKVVA | CURR | 7(2) | WERTV4 | ||||
MKVVA_VAG | MLR from Illness, 2 Years Ago, Entitlement, Previous ER | P01B_MKVVA_VAG | CURR | 7(2) | WERTV4 | ||||
AANRE | Title | ANRED | CHAR | 15 | TEXT15 | ||||
ANAM1 | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
ANAM2 | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
ASTRA | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
APSTL | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
AORT1 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
AORT2 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SANRE | Title | ANRED | CHAR | 15 | TEXT15 | ||||
SNAM1 | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
SNAM2 | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
SSTRA | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
SPSTL | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
SORT1 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
SORT2 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
GBDAT | Date of Birth | P01B_BKGBD | DATS | 8 | DATUM | ||||
GBORT | Birthplace | P01B_BKGBO | CHAR | 30 | CHAR30 | ||||
BEAJA | Statement Year - Current | BEAJA | CHAR | 4 | |||||
BEVJA | Statement Year - Previous Year | BEVJA | CHAR | 4 | |||||
BEVVJ | Statement Year - 2 Years Ago | P01B_BEVVJ | CHAR | 4 | |||||
BEFJA | Statement Year - Following Year | BEFJA | CHAR | 4 | |||||
ADJFM | Indicator 'Leaving in SRHC Period' | P01B_ADJFM | CHAR | 1 | XFELD | ||||
MSLJS_GES | MLR from SRHC, Current Year, Lost Hours | P01B_MSLJS | DEC | 5(2) | DEC3_2 | ||||
MSLJA_GES | MLR from SRHC, Current Year, Entitlement | P01B_MSLJA | CURR | 7(2) | WERTV4 | ||||
ADDRESS | 0 | ||||||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 of an address | NAME3_ADRS | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 of an address | NAME4_ADRS | CHAR | 40 | TEXT40 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO box | PFACH_BAS | CHAR | 10 | PFACH | ||||
PSTL2 | PO Box postal code | PSTL2_BAS | CHAR | 10 | PSTLZ | ||||
PFORT | PO Box city | PFORT_ADRS | CHAR | 40 | TEXT40 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
PSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
INLND | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ANZZL | Number of lines in address | ANZEI | DEC | 2 | ANZEI | ||||
PRIOR | Address lines priority | PRITY_ADRS | CHAR | 9 | CHAR9 | ||||
WAREN | Delivery address ID | WAREN | CHAR | 1 | WAREN | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
SENDER | 0 | ||||||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 of an address | NAME1_ADRS | CHAR | 40 | TEXT40 | ||||
NAME2 | Name 2 of an address | NAME2_ADRS | CHAR | 40 | TEXT40 | ||||
NAME3 | Name 3 of an address | NAME3_ADRS | CHAR | 40 | TEXT40 | ||||
NAME4 | Name 4 of an address | NAME4_ADRS | CHAR | 40 | TEXT40 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO box | PFACH_BAS | CHAR | 10 | PFACH | ||||
PSTL2 | PO Box postal code | PSTL2_BAS | CHAR | 10 | PSTLZ | ||||
PFORT | PO Box city | PFORT_ADRS | CHAR | 40 | TEXT40 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
PSTLZ | Postal code | PSTLZ_BAS | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
INLND | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
ANZZL | Number of lines in address | ANZEI | DEC | 2 | ANZEI | ||||
PRIOR | Address lines priority | PRITY_ADRS | CHAR | 9 | CHAR9 | ||||
WAREN | Delivery address ID | WAREN | CHAR | 1 | WAREN | ||||
LINE0 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE1 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE2 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE3 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE4 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE5 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE6 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE7 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE8 | Address line | LINES | CHAR | 80 | LINES | ||||
LINE9 | Address line | LINES | CHAR | 80 | LINES | ||||
LINEK | Address line | LINES | CHAR | 80 | LINES | ||||
LINED | Address line | LINES | CHAR | 80 | LINES | ||||
LINED0 | Address line | LINES | CHAR | 80 | LINES | ||||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME |
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects