I_ADDRESS

CDS View
67 Fields 18 CDS Views

Address

I_ADDRESS is a CDS View in S/4HANA. Address. It contains 67 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
A_BusinessPartnerAddress view inner BASIC Address
C_CorrespondenceAddress view from CONSUMPTION Address with printable lines for an address label
C_CustomerAddressIDValueHelp view left_outer CONSUMPTION Customer Address ID Value Help
C_ProcmtHubRefDeliveryAddrIDVH view from CONSUMPTION Reference Delivery Addr ID Value Help from Connected System
C_PurOrdMaintainUserDetail view left_outer CONSUMPTION PO Maintenance: User Detail
C_SupplierAddressIDValueHelp view left_outer CONSUMPTION Supplier Address ID Value Help
CRMS4_IU_P_ADDRESS view from I_Address + additional fields from ADRC
FAC_AUDIT_Z3_SDPARTNER view inner Sales Document Partner
FAC_DART_Z3_C_BP_ADDRESS view inner Business Partner Address for Customer
FAC_DART_Z3_S_BP_ADDRESS view inner Business Partner Address for Supplier
I_BusinessPartnerAddressDsp view_entity inner BASIC Business Partner Address Display
I_BusinessPartnerAddressGov view inner COMPOSITE Business Partner Address (Governance)
I_EmployeeHomeAddress view inner BASIC Employee Home Address
I_PT_SAFTDeliveryOneTimeCust view left_outer COMPOSITE SAF-T PT Billing One Time Custmer
P_Cpbupafaxall view inner CONSUMPTION Business Partner Emails from all sources
P_PurOrdMaintainHeaderActAddr view left_outer CONSUMPTION
P_PurOrdMaintainItemActAddr view left_outer CONSUMPTION
P_Supplier_Fs view left_outer BASIC

Fields (67)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 4
KEY Branch Branch 2
KEY CompanyCode CompanyCode 2
AdditionalStreetPrefixName AdditionalStreetPrefixName 7
AdditionalStreetSuffixName AdditionalStreetSuffixName 5
AddressCreatedByUser AddressCreatedByUser 2
AddressObjectType AddressObjectType 2
AddressRepresentationCode AddressRepresentationCode 2
AddressTimeZone AddressTimeZone 4
BranchLongCode BranchLongCode 2
Building Building 4
BusinessPartnerName1 AddressName,BusinessPartnerName1 4
BusinessPartnerName2 BusinessPartnerName2 3
BusinessPartnerName3 BusinessPartnerName3 2
BusinessPartnerName4 BusinessPartnerName4 2
BusinessPlaceName BusinessPlaceName 1
CareOfName CareOfName 5
CityCode CityCode 3
CityFileTestStatus CityFileTestStatus 1
CityName CityDisplayName,CityName 11
CitySearch CitySearch 2
CompanyPostalCode CompanyPostalCode 4
CorrespondenceLanguage CorrespondenceLanguage,Language 4
Country Country,CountryForDisplay 11
County County 3
CountyCode CountyCode 1
DeliveryServiceNumber DeliveryServiceNumber 4
DeliveryServiceTypeCode DeliveryServiceTypeCode 4
District District,DistrictName 7
FaxNumber FaxNumber 2
Floor Floor 4
FormOfAddress FormOfAddress 4
FullName FullName 3
HomeCityName HomeCityName 7
HouseNumber HouseNumber 12
HouseNumberSupplementText HouseNumberSupplementText 5
Nation Nation 3
OrganizationName1 OrganizationName1 1
OrganizationName2 OrganizationName2 1
OrganizationName3 OrganizationName3 1
OrganizationName4 OrganizationName4 1
Person Person 3
PhoneNumber PhoneNumber 4
POBox POBox 4
POBoxDeviatingCityName POBoxDeviatingCityName 4
POBoxDeviatingCountry POBoxDeviatingCountry 4
POBoxDeviatingRegion POBoxDeviatingRegion 4
POBoxIsWithoutNumber POBoxIsWithoutNumber 4
POBoxLobbyName POBoxLobbyName 4
POBoxPostalCode POBoxPostalCode 4
PostalCode PostalCode,PostalCodeForDisplay 13
PrfrdCommMediumType PrfrdCommMediumType 4
Region Region 9
RoomNumber RoomNumber 4
SearchTerm1 SearchTerm1 3
SearchTerm2 SearchTerm2 1
Street Street 2
StreetName StreetDisplayName,StreetName 11
StreetPrefixName StreetPrefixName 7
StreetSearch StreetSearch 2
StreetSuffixName StreetSuffixName 7
TaxJurisdiction TaxJurisdiction 4
TaxPayerName TaxPayerName 1
TownshipCode TownshipCode 1
TownshipName TownshipName 1
TransportZone TransportZone 4
VATRegistration VATRegistration 2

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.

-- Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESS (
    ADDRESSID,
    BRANCH,
    COMPANYCODE,
    ADDITIONALSTREETPREFIXNAME,
    ADDITIONALSTREETSUFFIXNAME,
    ADDRESSCREATEDBYUSER,
    ADDRESSOBJECTTYPE,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSTIMEZONE,
    BRANCHLONGCODE,
    BUILDING,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    BUSINESSPARTNERNAME3,
    BUSINESSPARTNERNAME4,
    BUSINESSPLACENAME,
    CAREOFNAME,
    CITYCODE,
    CITYFILETESTSTATUS,
    CITYNAME,
    CITYSEARCH,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    COUNTY,
    COUNTYCODE,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICT,
    FAXNUMBER,
    FLOOR,
    FORMOFADDRESS,
    FULLNAME,
    HOMECITYNAME,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    NATION,
    ORGANIZATIONNAME1,
    ORGANIZATIONNAME2,
    ORGANIZATIONNAME3,
    ORGANIZATIONNAME4,
    PERSON,
    PHONENUMBER,
    POBOX,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    ROOMNUMBER,
    SEARCHTERM1,
    SEARCHTERM2,
    STREET,
    STREETNAME,
    STREETPREFIXNAME,
    STREETSEARCH,
    STREETSUFFIXNAME,
    TAXJURISDICTION,
    TAXPAYERNAME,
    TOWNSHIPCODE,
    TOWNSHIPNAME,
    TRANSPORTZONE,
    VATREGISTRATION,
    PRIMARY KEY (ADDRESSID, BRANCH, COMPANYCODE)
);

Learn More