_POSPERSSTRUCRELSHP

6 Fields

_POSPERSSTRUCRELSHP is an SAP database table in S/4HANA. It contains 6 fields.

Fields (6)

KeyField CDS FieldsUsed in Views
KEY DfsObjectValdtyEndDate DfsPositionValdtyEndDate 3
KEY DfsObjectValdtyStartDate DfsPositionValdtyStartDate 3
KEY DfsPositionValdtyEndDate DfsPositionValdtyEndDate 5
KEY DfsPositionValdtyStartDate DfsPositionValdtyStartDate 5
KEY PersonnelNumber EmployeePersonnelNumber 3
EmployeeName EmployeeName 8

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 _POSPERSSTRUCRELSHP (
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    DFSPOSITIONVALDTYENDDATE,
    DFSPOSITIONVALDTYSTARTDATE,
    PERSONNELNUMBER,
    EMPLOYEENAME,
    PRIMARY KEY (DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONVALDTYENDDATE, DFSPOSITIONVALDTYSTARTDATE, PERSONNELNUMBER)
);

Learn More