PERNR in EKPA
Personnel No. (DE: Personalnr)
PERNR is a field in SAP table EKPA (Partner Roles in Purchasing). It represents "Personnel No.". Data element: PERNR_D. Available in 27 CDS view(s) as EmploymentInternalID, PersonWorkAgreement, pernr.
Business Meaning
| Description (EN) | Personnel No. |
|---|---|
| Beschreibung (DE) | Personalnr |
| Data Element | PERNR_D |
| Key Field | No |
CDS Views & Technical Names (27)
EKPA.PERNR is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
EmploymentInternalID
(23 views)
Personnel Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_PurchasingDocumentPartner | direct | BASIC | I_PurchasingDocumentPartner | |
| I_PurchaseOrderPartner | via 2 level | BASIC | Purchase Order Partner | |
| I_PurgDocumentPartnerEnh | via 2 level | COMPOSITE | Purchasing Document Partner Enhanced | |
| R_PurchaseOrderPartner | via 2 level | BASIC | Purchase Order Partner | |
| I_PurchaseOrderPartnerAPI01 | via 3 levels | BASIC | Purchase Order Partner | |
| I_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner - TP | |
| I_Purctrpartners | via 3 levels | COMPOSITE | Interface view for partners | |
| I_SchedgAgrmtPartner | via 3 levels | COMPOSITE | Scheduling Agreement Partners | |
| R_PPS_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner - TP | |
| R_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner TP View | |
| A_PurchaseOrderPartner_2 | via 4 levels | CONSUMPTION | Partner | |
| C_MassUpdtPurchasingDocPart | via 4 levels | CONSUMPTION | Purchase Contract Partner | |
| C_MassUpdtSchedgAgrmtPartner | via 4 levels | CONSUMPTION | Scheduling Agreement Partner | |
| C_PPS_PurchaseOrderPartnerTP | via 4 levels | CONSUMPTION | Purchase Order Partner | |
| I_PurchaseOrderPartnerTP_2 | via 4 levels | TRANSACTIONAL | Purchase Order Partner Projection | |
| I_PurctrpartnersWithDraft | via 4 levels | TRANSACTIONAL | Interface view for partners with Draft | |
| I_SchedgAgrmtPartnWD | via 4 levels | TRANSACTIONAL | Scheduling Agreement Partners with Draft | |
| R_PurContrPartnersTP | via 4 levels | TRANSACTIONAL | Purchase Contract Partners | |
| R_SchedgAgrmtPartnerTP | via 4 levels | TRANSACTIONAL | Scheduling Agreement Partner | |
| A_SchAgrmtPartner_2 | via 5 levels | CONSUMPTION | Scheduling Agreement Partner | |
| C_PurCtrPartners | via 5 levels | CONSUMPTION | Consumption View for partners | |
| I_PurContrPartnersTP | via 5 levels | TRANSACTIONAL | Purchase Contract Partners - TP | |
| I_SchedgAgrmtPartnerTP_2 | via 5 levels | TRANSACTIONAL | Scheduling Agreement Partner |
PersonWorkAgreement
(18 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_PurchasingDocumentPartner | direct | BASIC | I_PurchasingDocumentPartner | |
| I_PurchaseOrderPartner | via 2 level | BASIC | Purchase Order Partner | |
| I_PurgDocumentPartnerEnh | via 2 level | COMPOSITE | Purchasing Document Partner Enhanced | |
| R_PurchaseOrderPartner | via 2 level | BASIC | Purchase Order Partner | |
| C_PurOrderPartnerFactSheet | via 3 levels | CONSUMPTION | Purchase Order Partner Fact Sheet | |
| I_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner - TP | |
| I_SchedgAgrmtPartner | via 3 levels | COMPOSITE | Scheduling Agreement Partners | |
| R_PPS_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner - TP | |
| R_PurchaseOrderPartnerTP | via 3 levels | TRANSACTIONAL | Purchase Order Partner TP View | |
| A_PurchaseOrderPartner_2 | via 4 levels | CONSUMPTION | Partner | |
| C_PPS_PurchaseOrderPartnerTP | via 4 levels | CONSUMPTION | Purchase Order Partner | |
| C_PurchaseOrderPartnerTP | via 4 levels | CONSUMPTION | Purchase Order Partner | |
| I_PurchaseOrderPartnerTP_2 | via 4 levels | TRANSACTIONAL | Purchase Order Partner Projection | |
| I_SchedgAgrmtPartnWD | via 4 levels | TRANSACTIONAL | Scheduling Agreement Partners with Draft | |
| R_SchedgAgrmtPartnerTP | via 4 levels | TRANSACTIONAL | Scheduling Agreement Partner | |
| A_SchAgrmtPartner_2 | via 5 levels | CONSUMPTION | Scheduling Agreement Partner | |
| C_SchedgAgrmtPartner | via 5 levels | CONSUMPTION | Scheduling Agreement Partner | |
| I_SchedgAgrmtPartnerTP_2 | via 5 levels | TRANSACTIONAL | Scheduling Agreement Partner |
pernr
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| FNDEI_EKPA_FILTER | direct | Filter View for table EKPA |
Other Tables with Field PERNR (49)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /SHCM/D_CNT_WRK | PERNR_D | KEY | Contingent Worker Identifier |
| /SYCLO/MDW00 | /SYCLO/CORE_PERNR_DTE | Syclo Middleware User Registry | |
| AFRU | CO_PERNR | Order Confirmations | |
| ANLZ | PERNR_D | Valutierte Anlagen-Zuordnungen | |
| BSEG | PERNR_D | Belegsegment Buchhaltung | |
| DFKKMOP | PERNR_D | Positionen zum Musterkontokorrentbeleg | |
| DFKKOP | PERNR_D | Positionen zum Kontokorrentbeleg | |
| EWA_ORDER_RESOBJ | PERNR_D | Ressourcentabelle des Entsorgungsauftrags | |
| FINIJU_CASEJEITM | PERNR_D | Proposed JE Item | |
| FTPT_REQ_HEAD | PERNR_D | KEY | Rahmendaten des Reiseantrages |
| 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 |
| HRPY_RGDIR | P_PERNR | KEY | Directory für Abrechnungsergebnisse |
| KNB1 | PERNR_D | Customer Master (Company Code) | |
| KNB1_PRC | PERNR_D | Master Data Consolidation: Process Table for KNB1 | |
| KNVP | PERNR_D | Customer Master Partner Functions | |
| KNVP_PRC | PERNR_D | Master Data Consolidation: Process Table for KNVP | |
| LFB1 | PERNR_D | Vendor Master (Company Code) | |
| LFB1_PRC | PERNR_D | Master Data Consolidation: Process Table for LFB1 | |
| LTAK | LTAK_PERNR | WM transfer order header | |
| OIGSPA | PERNR_D | Partner in TD-shipment | |
| PA0003 | PERSNO | KEY | Personal-Stammsatz Infotyp 0003 (Abrechnungsstatus) |
| PAYR | PERNR_D | Zahlungsträgerdatei | |
| PYC_D_PY_MSG | PERNR_D | KEY | Payroll Control Center: Payroll Messages |
| PYT_D_OC_REG | PERNR_D | Ad-hoc Off-Cycle Registration | |
| REGUH | PERNR_D | Regulierungsdaten aus Zahlprogramm | |
| SWXFORMABS | AD_PERSNUM | Formular: Abwesenheitsmitteilung | |
| T77TMCPIC_URLS | PERNR_D | KEY | Buffer for Photo URLs |
| TE115 | PERNR_D | Ableser | |
| TEVEN | PERNR_D | Zeitereignisse | |
| TRVS4_ADVANCE | PERNR_D | KEY | Travel Advance |
| TRVS4_COSTASS | PERNR_D | KEY | Travel Cost Assignment |
| TRVS4_DEST | PERNR_D | KEY | Travel Destination |
| TRVS4_EDITOR | PERNR_D | KEY | Travel Editor - Additional Information |
| TRVS4_ESTCOST | PERNR_D | KEY | Travel Estimated Cost |
| TRVS4_MILEAGE | PERNR_D | KEY | Travel Mileage |
| TRVS4_PERDIEM | PERNR_D | KEY | Travel Per-Diem deductions |
| TRVS4_RECEIPT | PERNR_D | KEY | Travel Receipt |
| TRVS4_SRVREQ | PERNR_D | KEY | Travel Service |
| VBPA | PERNR_D | Sales Document: Partner | |
| VBSEGA | PERNR_D | Belegsegment Belegvorerfassung - Datenbank für Anlagen - | |
| VBSEGS | PERNR_D | Belegsegment Belegvorerfassung - Datenbank für Sachkonten | |
| WBHP | PERNR_D | Trading Contract: Partner Assignment | |
| WBPA | PERNR_D | Business Partner Assignment | |
| WBRK | PERNR_D | Settlement Management Document Header | |
| WYT3 | PERNR_D | Partner Functions | |
| WYT3_PRC | PERNR_D | Master Data Consolidation: Process Table for WYT3 |
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