P_EMPLOYEEUNION

CDS View
6 Fields 2 CDS Views

P_EMPLOYEEUNION is a CDS View in S/4HANA. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Employmentshlp view inner BASIC Search Help for Personnel Assignments of Employee
P_O_Employee view from BASIC

Fields (6)

KeyField CDS FieldsUsed in Views
KEY PersonnelNumber PersonnelNumber 1
BusinessPartnerName GivenName 1
Employee Employee 1
EmployeeFullName EmployeeFullName 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastName FamilyName 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EMPLOYEEUNION (
    PERSONNELNUMBER,
    BUSINESSPARTNERNAME,
    EMPLOYEE,
    EMPLOYEEFULLNAME,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    PRIMARY KEY (PERSONNELNUMBER)
);

Learn More