P_PDRELATION

CDS View
8 Fields 9 CDS Views

P_PDRELATION is a CDS View in S/4HANA. It contains 8 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_EmployeePositionOP view inner BASIC Employee Position for OnPremise
P_EmployeePositionOP view inner BASIC
P_EmploymentManagerOP view inner BASIC
P_EmploymentOp view inner BASIC
P_EmploymentOp_001 view inner BASIC
P_EMPLREPORTINGSTRUCTUREOP view inner BASIC
P_O_EmployeeOp view inner BASIC
P_O_EmploymentManager view left_outer BASIC
P_PDOBJECTRELATION view from BASIC

Fields (8)

KeyField CDS FieldsUsed in Views
KEY ObjectID EmploymentInternalID,ObjectID,PersonnelNumber 6
KEY ObjectType ObjectType 1
KEY PlanVersion PlanVersion 1
EndDate EndDate,RelationEndDate 1
RelatedObjectID RelatedObjectID 1
RelatedObjectType RelatedObjectType 1
RelationStatus RelationStatus 1
StartDate RelationStartDate,StartDate 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_PDRELATION (
    OBJECTID,
    OBJECTTYPE,
    PLANVERSION,
    ENDDATE,
    RELATEDOBJECTID,
    RELATEDOBJECTTYPE,
    RELATIONSTATUS,
    STARTDATE,
    PRIMARY KEY (OBJECTID, OBJECTTYPE, PLANVERSION)
);

Learn More