VAL_END_DATE in SNWD_STAFFING
Valid Until (DE: Gültig bis)
VAL_END_DATE is a field in SAP table SNWD_STAFFING (EPM: Staff assignments to org units). It represents "Valid Until". Data element: SNWD_VALIDITY_END_DATE. Available in 16 CDS view(s) as EndDate, AssignmentEndDate, validity_end_date.
Business Meaning
| Description (EN) | Valid Until |
|---|---|
| Beschreibung (DE) | Gültig bis |
| Data Element | SNWD_VALIDITY_END_DATE |
| Key Field | No |
CDS Views & Technical Names (16)
SNWD_STAFFING.VAL_END_DATE 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.
EndDate
(12 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| REPM_EmployeeStaffingV1 | direct | Employee Staffing View | ||
| REPM_DepemHierarchyQV1 | via 2 level | Number of Employees in Department | ||
| REPM_EmployeeInDepartmentQV1 | via 2 level | Departments an Employee has worked | ||
| REPM_EmployeeStaffingV2 | via 3 levels | Employee Staffing View | ||
| REPM_EmpStaffing | via 3 levels | Employee Staffing View | ||
| REPM_DepEmpHierarchyQ | via 4 levels | No. Of Employees in a Department | ||
| Repm_Emp_Valid_Enddate | via 4 levels | REPM_EMP_VALID_ENDDATE | ||
| REPM_EmpInDeptQ | via 4 levels | Employee with Dept. Details Query View | ||
| REPM_EmployeeInDepartmentQV2 | via 4 levels | Departments an Employee has worked | ||
| REPM_EmpValidEndDate | via 4 levels | Validate Employee EndDate | ||
| REPM_EmpValidDates | via 5 levels | Employee Validity Dates | ||
| REPM_DeptEmpServiceQ | via 6 levels | Employee Service in Department Query View |
AssignmentEndDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| SEPM_I_EmployeeOrgAssignment | direct | EPM Demo: Employee Org Unit Assignment |
validity_end_date
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| sepm_sddl_staffing | direct |
ValidityEndDate
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| SEPM_I_EmployeeOrgAssignment_E | via 2 level | EPM Demo: Empl. to Org with Ext IDs | ||
| SEPMRA_I_EmployeeOrgAssigment | via 3 levels | Employee-to-OrgUnit Assignment |
Other Tables with Field VAL_END_DATE (6)
| Table | Data Element | Key | Description |
|---|---|---|---|
| ACMTST_DB_EMPL | ABAP.DATS | ACMTST: Employee (DB-Table) | |
| CLMS_LICENSE_INF | ABAP.DATS | CLMS: License Information | |
| FPM_IDA_TEST_ADR | ABAP.DATS | FPM IDA: Address Table | |
| SNWD_AD | SNWD_VALIDITY_END_DATE | EPM: Address Table | |
| SNWD_EMPLOYEES | SNWD_VALIDITY_END_DATE | EPM: Employee Data | |
| VEC_GRP_ASSGMT | VE_VAL_END_DATE | Validation Assignment and Group Mapping |
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