HRDEPBSVAVGS_VLTSV_AVIS SAP (Transfer Structure for Payment Summary for Retro. Pens. Ins.) Structure details

Dictionary Type: Structure
Description: Transfer Structure for Payment Summary for Retro. Pens. Ins.




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




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

HRDEPBSVAVGS_VLTSV_AVIS 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 "Transfer Structure for Payment Summary for Retro. Pens. Ins." 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_HRDEPBSVAVGS_VLTSV_AVIS TYPE HRDEPBSVAVGS_VLTSV_AVIS.

The HRDEPBSVAVGS_VLTSV_AVIS table consists of various fields, each holding specific information or linking keys about Transfer Structure for Payment Summary for Retro. Pens. Ins. data available in SAP. These include WERKS (Personnel Area), BTRTL (Personnel Subarea), NEUER_DIENSTHERR (New Public Sector Employer), DIENSTHERR_TXT (Public Sector Employer 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: Can Be Enhanced (Deep)


SAP HRDEPBSVAVGS_VLTSV_AVIS 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
RESULT 0
WERKSPersonnel Area PERSACHAR4PERSAPBR
BTRTLPersonnel Subarea BTRTLCHAR4BTRTLPBS
NEUER_DIENSTHERRNew Public Sector Employer PDE_PBS_VLTSV_NEUER_DIENSTHERRCHAR8ANSSL
DIENSTHERR_TXTPublic Sector Employer Name PDE_PBS_VLTSV_DH_BEZEICHNUNGCHAR30TEXT30
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ENAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
APRFNRApplication reference number P00_PBS_APRFNRNUMC6NUMC06
BERECH_ARTCalculation Type of Severance Pay Process PDE_PBS_VLTSV_BERECH_ARTCHAR2PDE_PBS_VLTSV_BERECH_ART
BATXTCalculation Type Text PDE_PBS_VLTSV_BERECH_ART_TXTCHAR40TEXT40
ERGARTResults Type Retro. Pension Insur./Treaty Sharing Pens.Costs PDE_PBSNV_ERGARTCHAR2PDE_PBSNV_ERGART
BETRAGHR Payroll: Amount MAXBTCURR15(2) PRBETRG
WAERSCurrency Key WAERSCUKY5WAERSFWS
VZWECKNote to Payee PDE_PBS_VLTSV_PAY_VZWECKCHAR30TEXT30
ADDRESS 0
ADDR_NOAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
FORMOFADDRForm of address text AD_TITLE_TCHAR20TEXT20
NAMEName 1 AD_NAME1CHAR40TEXT40
NAME_2Name 2 AD_NAME2CHAR40TEXT40
NAME_3Name 3 AD_NAME3CHAR40TEXT40
NAME_4Name 4 AD_NAME4CHAR40TEXT40
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
CITY_NOCity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
DELIV_DIS(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
STREETStreet AD_STR_OLDCHAR40TEXT40
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGold: building (no. or abbreviation) AD_BLD_OLDCHAR10TEXT10
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1CHAR20CHAR20
SORT2Search Term 2 AD_SORT2CHAR20CHAR20
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADR_NOTESAddress notes AD_REMARK1CHAR50TEXT50
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3AD_COMM
TEL1_NUMBRFirst telephone no.: dialling code+number AD_TLNMBR1CHAR30CHAR30
TEL1_EXTFirst Telephone No.: Extension AD_TLXTNS1CHAR10CHAR10
FAX_NUMBERFirst fax no.: dialling code+number AD_FXNMBR1CHAR30CHAR30
FAX_EXTENSFirst fax no.: extension AD_FXXTNS1CHAR10CHAR10
STREET_LNGStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
E_MAILE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
TITLETitle text AD_TITLETXCHAR30TEXT30
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
LANGU_ISO2-Character SAP Language Code LAISOCHAR2LAISO
BUILD_LONGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3LAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
HOMEPAGEURI, e.g. Homepage or ftp Address AD_URISCRCHAR132AD_URISCR
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
LANGU_CRAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
LANGUCRISO2-Character SAP Language Code LAISOCHAR2LAISO
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
URI_TYPEURI type flag AD_URITYPECHAR3AD_URITYPE
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
BANK 0
ANARTAddress Type ANARTCHAR2CHAR2
ANKEYAddress key ANKEYCHAR8ANSSL
BANKSBank country key BANKSCHAR3LAND1BKL
BANKLBank Keys BANKKCHAR15BANKKBNK
BKKTOBank account number BANKNCHAR18BANKN
BKREFReference specifications for bank details BKREFCHAR20CHAR20
BKONTBank Control Key BKONTCHAR2BKONT
ZLSCHPayment Method PCODECHAR1ZLSCH
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
BANKAName of bank BANKACHAR60TEXT60
P0001 0
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4INFOTYPITP
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2PREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
WERKSPersonnel Area PERSACHAR4PERSAPBR
PERSGEmployee Group PERSGCHAR1PERSGPRG
PERSKEmployee Subgroup PERSKCHAR2PERSKPKR
VDSK1Organizational Key VDSK1CHAR14VDSK1
GSBERBusiness Area GSBERCHAR4GSBERGSB
BTRTLPersonnel Subarea BTRTLCHAR4BTRTLPBS
JUPERLegal Person JUPERCHAR4JUPER
ABKRSPayroll Area ABKRSCHAR2ABKRSABK
ANSVHWork Contract ANSVHCHAR2ANSVH
KOSTLCost Center KOSTLCHAR10ALPHAKOSTLKOS
ORGEHOrganizational Unit ORGEHNUMC8ORGEH
PLANSPosition PLANSNUMC8PLANS
STELLJob STELLNUMC8STELL
MSTBRSupervisor Area MSTBRCHAR8MSTBR
SACHAPayroll Administrator SACHACHAR3SACHA
SACHPAdministrator for HR Master Data SACHPCHAR3SACHA
SACHZAdministrator for Time Recording SACHZCHAR3SACHA
SNAMEEmployee's Name (Sortable by LAST NAME FIRST NAME) SMNAMCHAR30CHAR30
ENAMEFormatted Name of Employee or Applicant EMNAMCHAR40TEXT40
OTYPEObject Type OTYPECHAR2OTYPEPOT
SBMODAdministrator Group SBMODCHAR4CHAR4SGR
KOKRSControlling Area KOKRSCHAR4CACCDCAC
FISTLFunds Center FISTLCHAR16FISTLFIS
GEBERFund BP_GEBERCHAR10BP_GEBERFIC
FKBERFunctional Area FKBERCHAR16FKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
SGMNTSegment for Segmental Reporting FB_SEGMENTCHAR10ALPHAFB_SEGMENT
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10FM_BUDGET_PERIODBUDPER
P0002 0
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
INFTYInfotype INFTYCHAR4INFOTYPITP
SUBTYSubtype SUBTYCHAR4SUBTYSUB
OBJPSObject Identification OBJPSCHAR2OBJPSOPS
SPRPSLock Indicator for HR Master Data Record SPRPSCHAR1SPRPS
ENDDAEnd Date ENDDADATS8DATUM
BEGDAStart Date BEGDADATS8DATUM
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged On AEDATDATS8DATUM
UNAMEName of Person Who Changed Object AENAMCHAR12USNAM
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXEXText Exists for Infotype ITXEXCHAR1XFELD
REFEXReference Fields Exist (Primary/Secondary Costs) PRFEXCHAR1XFELD
ORDEXConfirmation Fields Exist ORDEXCHAR1XFELD
ITBLDInfotype Screen Control ITBLDCHAR2CHAR2
PREASReason for Changing Master Data PREASCHAR2PREAS
FLAG1Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG2Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG3Reserved Field/Unused Field NUSEDCHAR1NUSED
FLAG4Reserved Field/Unused Field NUSEDCHAR1NUSED
RESE1Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
RESE2Reserved Field/Unused Field of Length 2 NUSED2CHAR2NUSED2
GRPVLGrouping Value for Personnel Assignments PCCE_GPVALCHAR4PCCE_GPVAL
INITSInitials INITSCHAR10TEXT10
NACHNLast Name PAD_NACHNCHAR40PAD_NACHN
NAME2Name at Birth PAD_NAME2CHAR40PAD_NACHN
NACH2Second Name PAD_NACH2CHAR40PAD_NACHN
VORNAFirst Name PAD_VORNACHAR40PAD_VORNM
CNAMEComplete Name PAD_CNAMECHAR80TEXT80
TITELTitle TITELCHAR15TITEL
TITL2Second Title TITL2CHAR15TITEL
NAMZUOther Title NAMZUCHAR15TITEL
VORSWName Prefix VORSWCHAR15TITEL
VORS2Second Name Prefix VORS2CHAR15TITEL
RUFNMNickname PAD_RUFNMCHAR40PAD_VORNM
MIDNMMiddle Name PAD_MIDNMCHAR40PAD_VORNM
KNZNMName Format Indicator for Employee in a List KNZNMNUMC2KNZN2
ANREDForm-of-Address Key ANRDECHAR1ANRDE
GESCHGender Key GESCHCHAR1GESCH
GBDATDate of Birth GBDATDATS8PDATEGBDAT
GBLNDCountry of Birth GBLNDCHAR3LAND1
GBDEPState GBDEPCHAR3REGIO
GBORTBirthplace PAD_GBORTCHAR40PAD_ORT01
NATIONationality NATSLCHAR3LAND1NAT
NATI2Second Nationality NATS2CHAR3LAND1
NATI3Third Nationality NATS3CHAR3LAND1
SPRSLCommunication Language PAD_SPRASLANG1ISOLASPRASSPRH_T002
KONFEReligious Denomination Key KONFECHAR2KONFE
FAMSTMarital Status Key FAMSTCHAR1FAMST
FAMDTValid From Date of Current Marital Status FAMDTDATS8DATUM
ANZKDNumber of Children ANZKDDEC3DEC03
NACONName Connection NACONCHAR1CHAR1
PERMOModifier for Personnel Identifier PIDMOCHAR2CHAR2
PERIDPersonnel ID Number PRDNICHAR20CHAR20
GBPASDate of Birth According to Passport GBPASDATS8DATUM
FNAMKFirst name (Katakana) P22J_PFNMKCHAR40P22J_PNAME
LNAMKLast name (Katakana) P22J_PLNMKCHAR40P22J_PNAME
FNAMRFirst Name (Romaji) P22J_PFNMRCHAR40P22J_PNAME
LNAMRLast Name (Romaji) P22J_PLNMRCHAR40P22J_PNAME
NABIKName of Birth (Katakana) P22J_PNBIKCHAR40P22J_PNAME
NABIRName of Birth (Romaji) P22J_PNBIRCHAR40P22J_PNAME
NICKKKoseki (Katakana) P22J_PNCKKCHAR40P22J_PNAME
NICKRKoseki (Romaji) P22J_PNCKRCHAR40P22J_PNAME
GBJHRYear of Birth GBJHRNUMC4GJAHRGJAHR
GBMONMonth of Birth GBMONNUMC2NUM2
GBTAGBirth Date (to Month/Year) GBTAGNUMC2NUM2
NCHMCLast Name (Field for Search Help) NACHNMCCHAR25CHAR25
VNAMCFirst Name (Field for Search Help) VORNAMCCHAR25CHAR25
NAMZ2Name Affix for Name at Birth NAMZ2CHAR15TITEL

Key field Non-key field



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

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

How to access SAP table HRDEPBSVAVGS_VLTSV_AVIS

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