P_ADDRESS_2

CDS View
86 Fields 1 CDS Views

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Address_2 view_entity from COMPOSITE Address of an Organization or a Person

Fields (86)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY AddressPersonID AddressPersonID 1
KEY AddressRepresentationCode AddressRepresentationCode 1
_AddressGroup _AddressGroup 1
_AddressObjectType _AddressObjectType 1
_AddressPersonName _AddressPersonName 1
_AddressRepresentationCode _AddressRepresentationCode 1
_CorrespondenceLanguage _CorrespondenceLanguage 1
_Country _Country 1
_DeliveryServiceTypeCode _DeliveryServiceTypeCode 1
_FormOfAddress _FormOfAddress 1
_POBoxAddrNonDeliverableReason _POBoxAddrNonDeliverableReason 1
_POBoxDeviatingCityCode _POBoxDeviatingCityCode 1
_POBoxDeviatingCountry _POBoxDeviatingCountry 1
_POBoxDeviatingRegion _POBoxDeviatingRegion 1
_PostalCity _PostalCity 1
_PrfrdCommMediumType _PrfrdCommMediumType 1
_Region _Region 1
_RegionalStructureCheckStatus _RegionalStructureCheckStatus 1
_SecondaryRegion _SecondaryRegion 1
_Street _Street 1
_StreetAddrNonDeliverableRsn _StreetAddrNonDeliverableRsn 1
_TertiaryRegion _TertiaryRegion 1
_TimeZone _TimeZone 1
_TransportationZone _TransportationZone 1
AddressChangedByUser AddressChangedByUser 1
AddressChangedOnDateTime AddressChangedOnDateTime 1
AddressCreatedByUser AddressCreatedByUser 1
AddressCreatedOnDateTime AddressCreatedOnDateTime 1
AddresseeFullName AddresseeFullName 1
AddressGroup AddressGroup 1
AddressObjectType AddressObjectType 1
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
AddressTimeZone AddressTimeZone 1
Building Building 1
CareOfName CareOfName 1
CityName CityName 1
CityNumber CityNumber 1
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
DistrictName DistrictName 1
DistrictNumber DistrictNumber 1
Floor Floor 1
FormOfAddress FormOfAddress 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
OrganizationName1 OrganizationName1 1
OrganizationName2 OrganizationName2 1
OrganizationName3 OrganizationName3 1
OrganizationName4 OrganizationName4 1
PersonFamilyName PersonFamilyName 1
PersonGivenName PersonGivenName 1
POBox POBox 1
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason 1
POBoxDeviatingCityCode POBoxDeviatingCityCode 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
PrfrdCommMediumType PrfrdCommMediumType 1
Region Region 1
RegionalStructureCheckStatus RegionalStructureCheckStatus 1
RegionalStructureGroup RegionalStructureGroup 1
RoomNumber RoomNumber 1
SecondaryRegion SecondaryRegion 1
SecondaryRegionName SecondaryRegionName 1
Street Street 1
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason 1
StreetName StreetName 1
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
TaxJurisdiction TaxJurisdiction 1
TertiaryRegion TertiaryRegion 1
TertiaryRegionName TertiaryRegionName 1
TransportZone TransportZone 1
Village Village 1
VillageName VillageName 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_ADDRESS_2 (
    ADDRESSID,
    ADDRESSPERSONID,
    ADDRESSREPRESENTATIONCODE,
    _ADDRESSGROUP,
    _ADDRESSOBJECTTYPE,
    _ADDRESSPERSONNAME,
    _ADDRESSREPRESENTATIONCODE,
    _CORRESPONDENCELANGUAGE,
    _COUNTRY,
    _DELIVERYSERVICETYPECODE,
    _FORMOFADDRESS,
    _POBOXADDRNONDELIVERABLEREASON,
    _POBOXDEVIATINGCITYCODE,
    _POBOXDEVIATINGCOUNTRY,
    _POBOXDEVIATINGREGION,
    _POSTALCITY,
    _PRFRDCOMMMEDIUMTYPE,
    _REGION,
    _REGIONALSTRUCTURECHECKSTATUS,
    _SECONDARYREGION,
    _STREET,
    _STREETADDRNONDELIVERABLERSN,
    _TERTIARYREGION,
    _TIMEZONE,
    _TRANSPORTATIONZONE,
    ADDRESSCHANGEDBYUSER,
    ADDRESSCHANGEDONDATETIME,
    ADDRESSCREATEDBYUSER,
    ADDRESSCREATEDONDATETIME,
    ADDRESSEEFULLNAME,
    ADDRESSGROUP,
    ADDRESSOBJECTTYPE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    DISTRICTNUMBER,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PERSONFAMILYNAME,
    PERSONGIVENNAME,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYCODE,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    REGIONALSTRUCTUREGROUP,
    ROOMNUMBER,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGE,
    VILLAGENAME,
    PRIMARY KEY (ADDRESSID, ADDRESSPERSONID, ADDRESSREPRESENTATIONCODE)
);

Learn More