P_EMPLPRIVPOSTADDR

CDS View
16 Fields 1 CDS Views

P_EMPLPRIVPOSTADDR is a CDS View in S/4HANA. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EmplHomeAddress view inner BASIC Obsolete - DONOT USE_Employee Home Address

Fields (16)

KeyField CDS FieldsUsed in Views
_Country _Country 1
_Region _Region 1
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
CareOfName CareOfName 1
CityName CityName 1
Country Country 1
District District 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
PostalCode PostalCode 1
Region Region 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSuffixName StreetSuffixName 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_EMPLPRIVPOSTADDR (
    _COUNTRY,
    _REGION,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    CAREOFNAME,
    CITYNAME,
    COUNTRY,
    DISTRICT,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POSTALCODE,
    REGION,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME
);

Learn More