VAL_START_DATE in SNWD_STAFFING
Valid From (DE: Gültig ab)
VAL_START_DATE is a field in SAP table SNWD_STAFFING (EPM: Staff assignments to org units). It represents "Valid From". Data element: SNWD_VALIDITY_START_DATE. Available in 16 CDS view(s) as StartDate, AssignmentStartDate, validity_start_date.
Business Meaning
| Description (EN) | Valid From |
|---|---|
| Beschreibung (DE) | Gültig ab |
| Data Element | SNWD_VALIDITY_START_DATE |
| Key Field | No |
CDS Views & Technical Names (16)
SNWD_STAFFING.VAL_START_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.
StartDate
(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 |
AssignmentStartDate
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| SEPM_I_EmployeeOrgAssignment | direct | EPM Demo: Employee Org Unit Assignment |
validity_start_date
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| sepm_sddl_staffing | direct |
ValidityStartDate
(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_START_DATE (7)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /ACCGO/T_STRG_QH | /ACCGO/E_VAL_START_DATE | Comingle: Quantity History for Application Document Item | |
| 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_START_DATE | EPM: Address Table | |
| SNWD_EMPLOYEES | SNWD_VALIDITY_START_DATE | EPM: Employee Data | |
| VEC_GRP_ASSGMT | VE_VAL_START_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