_PERSONNAME

26 Fields

_PERSONNAME is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed in Views
_AcademicTitle _AcademicTitle 1
_AcademicTitle2 _AcademicTitle2 1
_FamilyNamePrefix _FamilyNamePrefix 1
_FamilyNameSecondPrefix _FamilyNameSecondPrefix 1
_FormOfAddress _FormOfAddress 1
_NameSupplement _NameSupplement 1
AcademicTitle AcademicTitle,title_aca1 3
AcademicTitle2 AcademicTitle2,title_aca2 3
AddressPersonSearchTerm1 AddressPersonSearchTerm1,sort1 2
AddressPersonSearchTerm2 AddressPersonSearchTerm2,sort2 2
converted converted 2
CorrespondenceLanguage CorrespondenceLanguage,langu 3
FamilyName FamilyName,name_last 3
FamilyNamePrefix FamilyNamePrefix,prefix1 3
FamilyNameSecondPrefix FamilyNameSecondPrefix,prefix2 3
FormOfAddress FormOfAddress,title 3
GivenName GivenName,name_first 3
NameInitials initials,NameInitials 3
PersonBirthName name2,PersonBirthName 3
PersonFullName name_text,PersonFullName 3
PersonFullNameFormattingCntry namcountry,PersonFullNameFormattingCntry 2
PersonFullNameFormattingCode nameformat,PersonFullNameFormattingCode 2
PersonMiddleName namemiddle,PersonMiddleName 3
PersonNameSupplementCode PersonNameSupplementCode,title_sppl 3
PersonNickname nickname,PersonNickname 3
SecondFamilyName name_last2,SecondFamilyName 3

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 _PERSONNAME (
    _ACADEMICTITLE,
    _ACADEMICTITLE2,
    _FAMILYNAMEPREFIX,
    _FAMILYNAMESECONDPREFIX,
    _FORMOFADDRESS,
    _NAMESUPPLEMENT,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ADDRESSPERSONSEARCHTERM1,
    ADDRESSPERSONSEARCHTERM2,
    CONVERTED,
    CORRESPONDENCELANGUAGE,
    FAMILYNAME,
    FAMILYNAMEPREFIX,
    FAMILYNAMESECONDPREFIX,
    FORMOFADDRESS,
    GIVENNAME,
    NAMEINITIALS,
    PERSONBIRTHNAME,
    PERSONFULLNAME,
    PERSONFULLNAMEFORMATTINGCNTRY,
    PERSONFULLNAMEFORMATTINGCODE,
    PERSONMIDDLENAME,
    PERSONNAMESUPPLEMENTCODE,
    PERSONNICKNAME,
    SECONDFAMILYNAME
);

Learn More