POSTOPERSONEXERRELSHP

12 Fields

POSTOPERSONEXERRELSHP is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY DfsObjectSubType DfsObjectSubType 1
KEY DfsObjectValdtyEndDate DfsPositionValdtyEndDate 1
KEY DfsObjectValdtyStartDate DfsPositionValdtyStartDate 1
KEY DfsPositionSequenceNumber DfsPositionSequenceNumber 1
KEY PersonnelNumber PersonnelNumber 1
DfsObjectShortName DfsObjectShortName 1
DfsPositionOpExerciseID DfsPositionOpExerciseID 1
DfsPositionRelatedObjectID DfsPositionRelatedObjectID 1
DfsPositionRelatedObjectType DfsPositionRelatedObjectType 1
DfsPositionRotationKey DfsPositionRotationKey 1
EmployeeName EmployeeName 1
PersonnelNumberFoEd PersonnelNumberFoEd 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 POSTOPERSONEXERRELSHP (
    DFSOBJECTSUBTYPE,
    DFSOBJECTVALDTYENDDATE,
    DFSOBJECTVALDTYSTARTDATE,
    DFSPOSITIONSEQUENCENUMBER,
    PERSONNELNUMBER,
    DFSOBJECTSHORTNAME,
    DFSPOSITIONOPEXERCISEID,
    DFSPOSITIONRELATEDOBJECTID,
    DFSPOSITIONRELATEDOBJECTTYPE,
    DFSPOSITIONROTATIONKEY,
    EMPLOYEENAME,
    PERSONNELNUMBERFOED,
    PRIMARY KEY (DFSOBJECTSUBTYPE, DFSOBJECTVALDTYENDDATE, DFSOBJECTVALDTYSTARTDATE, DFSPOSITIONSEQUENCENUMBER, PERSONNELNUMBER)
);

Learn More