I_SCRIPTEDPERSONADDRESS

CDS View
59 Fields 1 CDS Views

Interational Address Version for Persons

I_SCRIPTEDPERSONADDRESS is a CDS View in S/4HANA. Interational Address Version for Persons. It contains 59 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusPartScriptedPersonAddress view inner COMPOSITE International version of a business partner address

Fields (59)

KeyField CDS FieldsUsed in Views
KEY AddressRepresentationCode AddressRepresentationCode 1
AcademicTitle AcademicTitle 1
AcademicTitle2 AcademicTitle2 1
AdditionalLastName AdditionalLastName 1
AdditionalStreetPrefixName AdditionalStreetPrefixName 1
AdditionalStreetSuffixName AdditionalStreetSuffixName 1
AddressNonDeliverableReason AddressNonDeliverableReason 1
AddressTimeZone AddressTimeZone 1
BPFirstNameSearchHelp BPFirstNameSearchHelp 1
BPLastNameSearchHelp BPLastNameSearchHelp 1
Building Building 1
BusinessPartnerBirthName BusinessPartnerBirthName 1
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel 1
BusinessPartnerSupplementName BusinessPartnerSupplementName 1
CareOfName CareOfName 1
CityFileTestStatus CityFileTestStatus 1
CityName CityName 1
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
County BPCountyText,County 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
District District,DistrictName 1
FirstName FirstName 1
Floor Floor 1
FormOfAddress FormOfAddress 1
FullName FullName 1
HomeCityName HomeCityName 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
Initials Initials 1
LastName LastName 1
LastNamePrefix LastNamePrefix 1
LastNameSecondPrefix LastNameSecondPrefix 1
MiddleName MiddleName 1
NameCountry NameCountry 1
NameFormat NameFormat 1
Person Person 1
PersonFullName PersonFullName 1
POBox POBox 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PostBoxNonDeliverableReason PostBoxNonDeliverableReason 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
RoomNumber RoomNumber 1
SearchTerm1 SearchTerm1 1
SearchTerm2 SearchTerm2 1
StreetName StreetName 1
StreetPrefixName StreetPrefixName 1
StreetSuffixName StreetSuffixName 1
TaxJurisdiction TaxJurisdiction 1
TransportZone TransportZone 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.

-- Interational Address Version for Persons
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SCRIPTEDPERSONADDRESS (
    ADDRESSREPRESENTATIONCODE,
    ACADEMICTITLE,
    ACADEMICTITLE2,
    ADDITIONALLASTNAME,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSNONDELIVERABLEREASON,
    ADDRESSTIMEZONE,
    BPFIRSTNAMESEARCHHELP,
    BPLASTNAMESEARCHHELP,
    BUILDING,
    BUSINESSPARTNERBIRTHNAME,
    BUSINESSPARTNERNICKNAMELABEL,
    BUSINESSPARTNERSUPPLEMENTNAME,
    CAREOFNAME,
    CITYFILETESTSTATUS,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    FIRSTNAME,
    FLOOR,
    FORMOFADDRESS,
    FULLNAME,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INITIALS,
    LASTNAME,
    LASTNAMEPREFIX,
    LASTNAMESECONDPREFIX,
    MIDDLENAME,
    NAMECOUNTRY,
    NAMEFORMAT,
    PERSON,
    PERSONFULLNAME,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTBOXNONDELIVERABLEREASON,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SEARCHTERM1,
    SEARCHTERM2,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TRANSPORTZONE,
    PRIMARY KEY (ADDRESSREPRESENTATIONCODE)
);

Learn More