P_PERSONWORKAGRMTORGLDETAILS1

CDS View
13 Fields 1 CDS Views

ZI_PersonWorkAgrmtOrglDetails1

P_PERSONWORKAGRMTORGLDETAILS1 is a CDS View in S/4HANA. ZI_PersonWorkAgrmtOrglDetails1. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PERSONWORKAGRMTORGLDETAILS2 view_entity from COMPOSITE ZI_PersonWorkAgrmtOrglDetails2

Fields (13)

KeyField CDS FieldsUsed in Views
KEY EndDate EndDate 1
KEY PersonWorkAgreement PersonWorkAgreement 1
KEY StartDate StartDate 1
_CompanyCode _CompanyCode 1
_OrganizationalUnitText _OrganizationalUnitText 1
_PersonWorkAgrmtJobText _PersonWorkAgrmtJobText 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
Job Job 1
OrganizationalUnit OrganizationalUnit 1
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg 1
ValidityEndDate ValidityEndDate 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.

-- ZI_PersonWorkAgrmtOrglDetails1
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PERSONWORKAGRMTORGLDETAILS1 (
    ENDDATE,
    PERSONWORKAGREEMENT,
    STARTDATE,
    _COMPANYCODE,
    _ORGANIZATIONALUNITTEXT,
    _PERSONWORKAGRMTJOBTEXT,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    JOB,
    ORGANIZATIONALUNIT,
    PERSONWORKAGRMTAUTHZNGRPG,
    VALIDITYENDDATE,
    PRIMARY KEY (ENDDATE, PERSONWORKAGREEMENT, STARTDATE)
);

Learn More