I_ORGANIZATIONADDRESS

CDS View
86 Fields 12 CDS Views

Address of an Organization

I_ORGANIZATIONADDRESS is a CDS View in S/4HANA. Address of an Organization. It contains 86 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_PurchasingDeliveryAddressVH view from CONSUMPTION Master Delivery Addresses
I_KanbanContainerDeliveryAddr view inner BASIC Kanban Container Delivery Address
I_OrgAddressDefaultRprstn view_entity from COMPOSITE Default Representation of an Org Address
I_ProductionSupplyAreaAddrTP view inner TRANSACTIONAL Production Supply Area Address
P_Address_2 view_entity union_all COMPOSITE Union of Person and Organization Address
P_EG_CompanyCode_Address view inner COMPOSITE Returns concateneted fields from company code address
P_KR_BusinessPlace view left_outer COMPOSITE KR ACR: Business Place Information temp view
P_RU_CompanyCodeData view left_outer COMPOSITE Company Code Data
P_RU_CompanyCodeData_Lang view left_outer COMPOSITE Company Code Data in Logon Language
P_SA_CompanyCode_Address view inner COMPOSITE KSA VAT Company Code Address
R_BankAddressDepTP view_entity inner TRANSACTIONAL Bank Address
R_ProductionSupplyAreaAddrTP view_entity inner TRANSACTIONAL Production Supply Area Address - TP

Fields (86)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,ProductionSupplyAreaAddressID 4
KEY AddressRepresentationCode AddressRepresentationCode 4
_AddressGroup _AddressGroup 1
_AddressObjectType _AddressObjectType 1
_AddressPersonName _AddressPersonName 1
_AddressRepresentationCode _AddressRepresentationCode 3
_CorrespondenceLanguage _CorrespondenceLanguage 2
_Country _Country 3
_CurrentDfltEmailAddress _CurrentDfltEmailAddress 1
_CurrentDfltFaxNumber _CurrentDfltFaxNumber 1
_CurrentDfltLandlinePhoneNmbr _CurrentDfltLandlinePhoneNmbr 1
_CurrentDfltMobilePhoneNumber _CurrentDfltMobilePhoneNumber 1
_DeliveryServiceTypeCode _DeliveryServiceTypeCode 1
_EmailAddress _EmailAddress 1
_FaxNumber _FaxNumber 1
_FormOfAddress _FormOfAddress 2
_MainWebsiteURL _MainWebsiteURL 1
_PhoneNumber _PhoneNumber 1
_POBoxAddrNonDeliverableReason _POBoxAddrNonDeliverableReason 1
_POBoxDeviatingCityCode _POBoxDeviatingCityCode 1
_POBoxDeviatingCountry _POBoxDeviatingCountry 1
_POBoxDeviatingRegion _POBoxDeviatingRegion 1
_PostalCity _PostalCity 1
_PrfrdCommMediumType _PrfrdCommMediumType 1
_Region _Region 3
_RegionalStructureCheckStatus _RegionalStructureCheckStatus 1
_SecondaryRegion _SecondaryRegion 1
_Street _Street 1
_StreetAddrNonDeliverableRsn _StreetAddrNonDeliverableRsn 1
_TertiaryRegion _TertiaryRegion 1
_TimeZone _TimeZone 1
_TransportationZone _TransportationZone 1
_UniformResourceIdentifier _UniformResourceIdentifier 1
AddresseeFullName AddresseeFullName 3
AddresseeName1 AddresseeName1 4
AddresseeName2 AddresseeName2 4
AddresseeName3 AddresseeName3 2
AddresseeName4 AddresseeName4 2
AddressGroup AddressGroup 2
AddressObjectType AddressObjectType 2
AddressPersonID AddressPersonID 1
AddressSearchTerm1 AddressSearchTerm1 2
AddressSearchTerm2 AddressSearchTerm2 2
AddressTimeZone AddressTimeZone 2
Building Building 3
CareOfName CareOfName 2
CityName CityName 6
CityNumber CityNumber 1
CompanyPostalCode CompanyPostalCode 2
CorrespondenceLanguage CorrespondenceLanguage 2
Country Country 6
DeliveryServiceNumber DeliveryServiceNumber 2
DeliveryServiceTypeCode DeliveryServiceTypeCode 2
DistrictName DistrictName 2
Floor Floor 2
FormOfAddress FormOfAddress 2
HouseNumber HouseNumber 6
HouseNumberSupplementText HouseNumberSupplementText 2
POBox POBox 4
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason 2
POBoxDeviatingCityCode POBoxDeviatingCityCode 1
POBoxDeviatingCityName POBoxDeviatingCityName 2
POBoxDeviatingCountry POBoxDeviatingCountry 2
POBoxDeviatingRegion POBoxDeviatingRegion 2
POBoxIsWithoutNumber POBoxIsWithoutNumber 2
POBoxLobbyName POBoxLobbyName 2
POBoxPostalCode POBoxPostalCode 2
PostalCode PostalCode 4
PrfrdCommMediumType PrfrdCommMediumType 2
Region Region 6
RegionalStructureCheckStatus RegionalStructureCheckStatus 1
RoomNumber RoomNumber 2
SecondaryRegion SecondaryRegion 1
SecondaryRegionName SecondaryRegionName 2
Street Street 1
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason 2
StreetName StreetName 6
StreetPrefixName1 StreetPrefixName1 3
StreetPrefixName2 StreetPrefixName2 3
StreetSuffixName1 StreetSuffixName1 3
StreetSuffixName2 StreetSuffixName2 3
TaxJurisdiction TaxJurisdiction 2
TertiaryRegion TertiaryRegion 1
TertiaryRegionName TertiaryRegionName 2
TransportZone TransportZone 2
VillageName VillageName 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 of an Organization
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ORGANIZATIONADDRESS (
    ADDRESSID,
    ADDRESSREPRESENTATIONCODE,
    _ADDRESSGROUP,
    _ADDRESSOBJECTTYPE,
    _ADDRESSPERSONNAME,
    _ADDRESSREPRESENTATIONCODE,
    _CORRESPONDENCELANGUAGE,
    _COUNTRY,
    _CURRENTDFLTEMAILADDRESS,
    _CURRENTDFLTFAXNUMBER,
    _CURRENTDFLTLANDLINEPHONENMBR,
    _CURRENTDFLTMOBILEPHONENUMBER,
    _DELIVERYSERVICETYPECODE,
    _EMAILADDRESS,
    _FAXNUMBER,
    _FORMOFADDRESS,
    _MAINWEBSITEURL,
    _PHONENUMBER,
    _POBOXADDRNONDELIVERABLEREASON,
    _POBOXDEVIATINGCITYCODE,
    _POBOXDEVIATINGCOUNTRY,
    _POBOXDEVIATINGREGION,
    _POSTALCITY,
    _PRFRDCOMMMEDIUMTYPE,
    _REGION,
    _REGIONALSTRUCTURECHECKSTATUS,
    _SECONDARYREGION,
    _STREET,
    _STREETADDRNONDELIVERABLERSN,
    _TERTIARYREGION,
    _TIMEZONE,
    _TRANSPORTATIONZONE,
    _UNIFORMRESOURCEIDENTIFIER,
    ADDRESSEEFULLNAME,
    ADDRESSEENAME1,
    ADDRESSEENAME2,
    ADDRESSEENAME3,
    ADDRESSEENAME4,
    ADDRESSGROUP,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    CITYNUMBER,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYCODE,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    PRFRDCOMMMEDIUMTYPE,
    REGION,
    REGIONALSTRUCTURECHECKSTATUS,
    ROOMNUMBER,
    SECONDARYREGION,
    SECONDARYREGIONNAME,
    STREET,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGENAME,
    PRIMARY KEY (ADDRESSID, ADDRESSREPRESENTATIONCODE)
);

Learn More