U_17207 SAP (Generated Table for View U_17207) Table View details

Dictionary Type: Table View
Description: Generated Table for View U_17207




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




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

U_17207 is a standard SAP Table View which is used to store Generated Table for View U_17207 data and is available within R/3 SAP systems depending on the version and release level.

The U_17207 table consists of various fields, each holding specific information or linking keys about Generated Table for View U_17207 data available in SAP. These include PERNR (Personnel number), SUBTY (Subtype), OBJPS (Object Identification), SPRPS (Lock Indicator for HR Master Data Record).. 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: Not classified


SAP U_17207 table view 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
PERNRPersonnel number PERSNONUMC8PA0003PERSNOPER
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
PREASReason for Changing Master Data PREASCHAR2T530EPREAS
KVKZ1Indicator for Health Insurance KVKZ1CHAR1T5D1YSVSCH
RVKZ1Indicator: Pension Insurance RVKZ1CHAR1T5D1YSVSCH
AVKZ1Indicator: Unemployment Insurance AVKZ1CHAR1T5D1YSVSCH
RVNUMPension Insurance Number RVNUMCHAR12RVNUM
KVSFRHI Fund Key for Compulsory Health Insurance Fund KVSCHCHAR8T5D11KVSCH
KVGSTHI Fund Branch Office KVGSTCHAR6T5D1KKVGST
KVBKLContribution Scale BTRKLCHAR6T5D1OP011_BTRKL
KVFBTHI Amount KVFBTCURR7(2) SVBTR
ZUSKAAdditional Health Insurance Fund DZUSKACHAR8T5D11KVSCH
SELKVIndicator Self-Payer HI SELKVCHAR1XFELD
SELRVSelf-Payer Pension Insurance SELRVCHAR1XFELD
KVBFGReason for HI exemption KVBFGCHAR1T5D12P011_KVSVA
RVBFGReason for PI Exemption RVBFGCHAR1T5D12P011_KVSVA
AVBFGReason for UI Exemption AVBFGCHAR1T5D12P011_KVSVA
MAXKVMaximum HI Gross for Pensioners MAXKVCURR7(2) SVBTR
MITNRMembership Number MITNRCHAR15CHAR15
KVBATHI Contribution Distribution KVBATCHAR1SVBAT
RVBATPI Contribution Distribution RVBATCHAR1SVBAT
AVBATUI Contribution Distribution AVBATCHAR1SVBAT
PVKZ1Care Insurance Indicator PVKZ1CHAR1T5D1YSVSCH
PVBKLCare Insurance Contribution Scales for Voluntary Insurees P011_PVBKLCHAR6T5D1ZP011_PVBKL
PVFBTCare Insurance Amount PVFBTCURR7(2) SVBTR
SELPVIndicator Self-Payer CI SELPVCHAR1XFELD
PVBFGReason for CI Exemption PVBFGCHAR1T5D12P011_KVSVA
PVBATCI Contribution Distribution PVBATCHAR1SVBAT
MAXPVMaxiumum CI Gross for Pensioners MAXPVCURR7(2) SVBTR

Key field Non-key field



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

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

SELECT SINGLE *
FROM U_17207
INTO CORRESPONDING FIELDS OF WA_U_17207
WHERE...

How to access SAP table U_17207

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