I_ADDRESSPERSONNAME

CDS View
26 Fields 8 CDS Views

Person Name

I_ADDRESSPERSONNAME is a CDS View in S/4HANA. Person Name. It contains 26 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_BusEvtLogUserCntctCardVH view inner CONSUMPTION Business Event Log User
I_AccrObjResponsiblePerson view_entity inner COMPOSITE Responsible User
I_AddrPersnNameDfltRprstn view_entity from BASIC Default Representation for Person Name
I_JITOutbSqncCallCrtedByUsrVH view_entity from COMPOSITE Basic for Created By
I_WorkforcePersonTP view_entity inner TRANSACTIONAL BUM - Workforce Person TP
P_BillingAddressPersonName view_entity from COMPOSITE
V_Mmim_Ddl_Om_Or_Email view left_outer Output Management E-Mail
V_Mmim_Ddl_Om_Or_GR4PO_EMAIL view left_outer Output Management E-Mail GR4PO

Fields (26)

KeyField CDS FieldsUsed in Views
KEY AddressPersonID AddressPersonID 1
_AcademicTitle _AcademicTitle 1
_AcademicTitle2 _AcademicTitle2 1
_AddressRepresentationCode _AddressRepresentationCode 1
_FamilyNamePrefix _FamilyNamePrefix 1
_FamilyNameSecondPrefix _FamilyNameSecondPrefix 1
_FormOfAddress _FormOfAddress 1
_NameSupplement _NameSupplement 1
AcademicTitle AcademicTitle 1
AcademicTitle2 AcademicTitle2 1
AddressPersonSearchTerm1 AddressPersonSearchTerm1 1
AddressPersonSearchTerm2 AddressPersonSearchTerm2 1
AddressRepresentationCode AddressRepresentationCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
FamilyName FamilyName,LastName 2
FamilyNamePrefix FamilyNamePrefix 1
FamilyNameSecondPrefix FamilyNameSecondPrefix 1
FormOfAddress FormOfAddress 1
GivenName FirstName,GivenName 2
NameInitials NameInitials 1
PersonBirthName PersonBirthName 1
PersonFullName AccrObjPersonResponsibleName,FullName,FullNameOfPerson,PersonFullName 6
PersonMiddleName PersonMiddleName 1
PersonNameSupplementCode PersonNameSupplementCode 1
PersonNickname PersonNickname 1
SecondFamilyName SecondFamilyName 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.

-- Person Name
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSPERSONNAME (
    ADDRESSPERSONID,
    _ACADEMICTITLE,
    _ACADEMICTITLE2,
    _ADDRESSREPRESENTATIONCODE,
    _FAMILYNAMEPREFIX,
    _FAMILYNAMESECONDPREFIX,
    _FORMOFADDRESS,
    _NAMESUPPLEMENT,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ADDRESSPERSONSEARCHTERM1,
    ADDRESSPERSONSEARCHTERM2,
    ADDRESSREPRESENTATIONCODE,
    CORRESPONDENCELANGUAGE,
    FAMILYNAME,
    FAMILYNAMEPREFIX,
    FAMILYNAMESECONDPREFIX,
    FORMOFADDRESS,
    GIVENNAME,
    NAMEINITIALS,
    PERSONBIRTHNAME,
    PERSONFULLNAME,
    PERSONMIDDLENAME,
    PERSONNAMESUPPLEMENTCODE,
    PERSONNICKNAME,
    SECONDFAMILYNAME,
    PRIMARY KEY (ADDRESSPERSONID)
);

Learn More