PERNR in PA0009
Personnel No. (DE: Personalnr)
PERNR is a field in SAP table PA0009 (HR Master Record: Infotype 0009 (Bank Details)). It represents "Personnel No.". Data element: PERSNO. Available in 86 CDS view(s) as HCMPersonnelNumber.
Business Meaning
| Description (EN) | Personnel No. |
|---|---|
| Beschreibung (DE) | Personalnr |
| Data Element | PERSNO |
| Key Field | Yes |
CDS Views & Technical Names (86)
PA0009.PERNR is exposed in CDS views under the following technical name. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
HCMPersonnelNumber
(86 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| E_HCMBankData | direct | EXTENSION | HCM Bank Data - Extension | |
| I_HCMBankData | direct | BASIC | HCM Bank Data | |
| I_HCM_ESSBankData | via 2 level | COMPOSITE | My Bank Data | |
| I_BE_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data BE - TP | |
| I_BG_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data BG - TP | |
| I_CH_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data CH - TP | |
| I_CL_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data CL - TP | |
| I_CO_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data CO - TP | |
| I_CZ_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data CZ - TP | |
| I_GB_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data GB - TP | |
| I_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data International - TP | |
| I_HR_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data HR - TP | |
| I_HU_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data HU - TP | |
| I_JP_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data JP - TP | |
| I_KW_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data KW - TP | |
| I_NZ_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data NZ - TP | |
| I_OM_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data OM - TP | |
| I_PL_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data PL - TP | |
| I_RO_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data RO - TP | |
| I_RU_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data RU - TP | |
| I_SI_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data SI - TP | |
| I_SK_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data SK - TP | |
| I_TR_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data TR - TP | |
| I_UN_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data UN - TP | |
| I_US_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data US - TP | |
| I_VE_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data VE - TP | |
| I_ZA_HCM_ESSBankDataTP | via 3 levels | TRANSACTIONAL | My Bank Data ZA - TP | |
| C_AE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data AE | |
| C_AR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data AR | |
| C_AT_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data AT | |
| C_AU_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data AU | |
| C_BE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data BE | |
| C_BG_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data BG | |
| C_BR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data BR | |
| C_CA_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CA | |
| C_CH_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CH | |
| C_CL_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CL | |
| C_CN_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CN | |
| C_CO_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CO | |
| C_CZ_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data CZ | |
| C_DE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data DE | |
| C_EG_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data EG | |
| C_ES_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data ES | |
| C_FI_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data FI | |
| C_FR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data FR | |
| C_GB_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data GB | |
| C_GR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data GR | |
| C_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data International | |
| C_HK_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data HK | |
| C_HR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data HR | |
| C_HU_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data HU | |
| C_ID_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data ID | |
| C_IE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data IE | |
| C_IN_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data IN | |
| C_IT_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data IT | |
| C_JP_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data JP | |
| C_KR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data KR | |
| C_KW_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data KW | |
| C_KZ_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data KZ | |
| C_MX_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data MX | |
| C_MY_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data MY | |
| C_NL_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data NL | |
| C_NO_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data NO | |
| C_NZ_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data NZ | |
| C_OM_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data OM | |
| C_PH_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data PH | |
| C_PL_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data PL | |
| C_PT_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data PT | |
| C_QA_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data QA | |
| C_RO_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data RO | |
| C_RU_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data RU | |
| C_SA_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data SA | |
| C_SE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data SE | |
| C_SG_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data SG | |
| C_SI_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data SI | |
| C_SK_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data SK | |
| C_TH_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data TH | |
| C_TR_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data TR | |
| C_TW_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data TW | |
| C_UA_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data UA | |
| C_UN_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data UN | |
| C_US_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data US | |
| C_VE_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data VE | |
| C_ZA_HCM_ESSBankDataTP | via 4 levels | CONSUMPTION | My Bank Data ZA | |
| I_HCMProfileBankData | via 4 levels | TRANSACTIONAL | My Profile Bank Data | |
| C_HCMProfileBankData | via 5 levels | CONSUMPTION | My Profile Bank Data |
Other Tables with Field PERNR (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /SAPCEM/V_BD | J_3GPERNR | Generated Table for View | |
| /SHCM/D_CNT_WRK | PERNR_D | KEY | Contingent Worker Identifier |
| /SHCM/PA3406 | PERSNO | KEY | HR Master Record: Infotype 3406 |
| /SYCLO/MDW00 | /SYCLO/CORE_PERNR_DTE | Syclo Middleware User Registry | |
| ACCOSTRATE | PERNR_D | Cost Rate | |
| ACDOCA | PERNR_D | Universal Journal Entry Line Items | |
| ACDOCD | PERNR_D | Universal Journal: Aged Details | |
| ACDOCP | PERNR_D | Plan Data Line Items | |
| ACDOCP_DATA | PERNR_D | Staging Area for Plan data in Internal Format | |
| ACDOCTEMP | PERNR_D | Universal Journal: Temporary Data | |
| AD01DLI | HR_PERNR | Dynamic items (DI) | |
| AFRP0 | CO_PERNR | Table of planned changes for confirmation (PDC) | |
| AFRU | CO_PERNR | Order Confirmations | |
| AFRV | PERNR_D | Confirmation pool | |
| AFVC | CO_PERNR | Operation within an order | |
| ALLOC_RUN_RES | PERNR_D | Allocation run result | |
| ANLZ | PERNR_D | Time-Dependent Asset Allocations | |
| BSEG | PERNR_D | Accounting Document Segment | |
| BSIK | PERNR_D | Generated Table for View | |
| CATSDB | PERNR_D | CATS: Database Table for Time Sheet | |
| CATSMM | PERNR_D | Cross-Application Time Sheet (CATS): Transfer to MM | |
| COEP | PERNR_D | CO Object: Line Items (by Period) | |
| COEPL | PERNR_D | CO Object: Line Items for Activity Types (by Period) | |
| COEPR | PERNR_D | CO Object: Line Items for Stat. Key Figs (by Period) | |
| COKEY | PERNR_D | CO key sub-numbers | |
| COVPR | PERNR_D | Generated Table for View | |
| CTE_D_FIN_T_ITEM | PERNR_D | Target Item mapping table | |
| DB_WBRK_WBRL | PERNR_D | KEY | Generated Table for View |
| DB_WBRK_WBRP_NEW | PERNR_D | KEY | Generated Table for View |
| DFKKMOP | PERNR_D | Items in contract account document | |
| DFKKOP | PERNR_D | Items in contract account document | |
| DFKKOP_LISTP | PERNR_D | FI-CA: Open Item List (Items) | |
| EKPA | PERNR_D | Partner Roles in Purchasing | |
| ESLL | PERNR_D | Lines of Service Package | |
| EWA_ORDER_RESOBJ | PERNR_D | Resource Table for Waste Disposal Order | |
| FINIJU_CASEJEITM | PERNR_D | Proposed JE Item | |
| FINS_PLAN_DELSC | PERNR_D | Table for delete scope | |
| FINSUBVALCOBL | PERNR_D | Metadata Container for FIN Rule engine | |
| FINSUBVALCOBLPSM | PERNR_D | Metadata Container for FIN Rule engine - Public Sector Manag | |
| FINSUBVALFICAPSM | PERNR_D | Metadata Container for FIN Rule engine - Public Sector Manag | |
| FKKVK | PERNR_D | Contract Account Header | |
| FTPT_PLAN | PERNR_D | KEY | General Plan Data |
| FTPT_REQ_HEAD | PERNR_D | KEY | Framework Data of Travel Request |
| GLE_FI_ITEM_MODF | PERNR_D | ECS: Modified FI Line Items (Header/Item/Currency Data) | |
| GLE_FI_ITEM_ORIG | PERNR_D | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | |
| HRFIO_D_FSA_CLMS | PERNR_D | KEY | Table for Fsa claims |
| HRFIO_D_FSAPLANS | PERNR_D | KEY | Table for fsa plans |
| HRFIO_D_REPVAR | PERNR_D | KEY | My Reporting: Variants |
| HRFIO_TEVEN_FAV | PERNR_D | KEY | HCM Time Events: Favorites for Time Event Types |
| HRPT_D_OVT_CORE | PERSNO | My Overtime Quota: Core Request Data |
Showing the first 50 tables. Search all occurrences →
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA