I_ORGANIZATIONADDRESS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressID | AddressID,ProductionSupplyAreaAddressID | 4 |
| KEY | AddressRepresentationCode | AddressRepresentationCode | 3 |
| _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 |
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Analytics : {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true }
}
@AccessControl.privilegedAssociations: ['_EmailAddress', '_CurrentDfltEmailAddress', '_PhoneNumber', '_CurrentDfltLandlinePhoneNmbr', '_CurrentDfltMobilePhoneNumber', '_FaxNumber', '_CurrentDfltFaxNumber', '_UniformResourceIdentifier', '_MainWebsiteURL']
@EndUserText.label: 'Address of an Organization'
//@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE,
#EXTRACTION_DATA_SOURCE]
@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.sapObjectNodeType.name: 'OrganizationAddress'
@VDM: {
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
define view entity I_OrganizationAddress
as select from I_AddrOrgNamePostalAddress
association [0..*] to I_AddressEmailAddress_2 as _EmailAddress on _EmailAddress.AddressID = $projection.AddressID
and _EmailAddress.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDefaultEmailAddress as _CurrentDfltEmailAddress on _CurrentDfltEmailAddress.AddressID = $projection.AddressID
and _CurrentDfltEmailAddress.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressPhoneNumber_2 as _PhoneNumber on _PhoneNumber.AddressID = $projection.AddressID
and _PhoneNumber.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDfltLandlinePhoneNmbr as _CurrentDfltLandlinePhoneNmbr on _CurrentDfltLandlinePhoneNmbr.AddressID = $projection.AddressID
and _CurrentDfltLandlinePhoneNmbr.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDfltMobilePhoneNumber as _CurrentDfltMobilePhoneNumber on _CurrentDfltMobilePhoneNumber.AddressID = $projection.AddressID
and _CurrentDfltMobilePhoneNumber.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressFaxNumber_2 as _FaxNumber on _FaxNumber.AddressID = $projection.AddressID
and _FaxNumber.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddrCurDefaultFaxNumber as _CurrentDfltFaxNumber on _CurrentDfltFaxNumber.AddressID = $projection.AddressID
and _CurrentDfltFaxNumber.AddressPersonID = $projection.AddressPersonID
association [0..*] to I_AddressURI as _UniformResourceIdentifier on _UniformResourceIdentifier.AddressID = $projection.AddressID
and _UniformResourceIdentifier.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_AddressMainWebsiteURL as _MainWebsiteURL on _MainWebsiteURL.AddressID = $projection.AddressID
and _MainWebsiteURL.AddressPersonID = $projection.AddressPersonID
association [0..1] to I_Region as _Region on $projection.Region = _Region.Region
and $projection.Country = _Region.Country
association [0..1] to I_Country as _Country on $projection.Country = _Country.Country
association [0..1] to I_FormOfAddress as _FormOfAddress on $projection.FormOfAddress = _FormOfAddress.FormOfAddress
association [0..1] to I_AddressNonDeliverableReason as _POBoxAddrNonDeliverableReason on $projection.POBoxAddrNonDeliverableReason = _POBoxAddrNonDeliverableReason.AddressNonDeliverableReason
association [0..1] to I_AddressNonDeliverableReason as _StreetAddrNonDeliverableRsn on $projection.StreetAddrNonDeliverableReason = _StreetAddrNonDeliverableRsn.AddressNonDeliverableReason
association [0..1] to I_TransportationZone as _TransportationZone on $projection.TransportZone = _TransportationZone.TransportZone
and $projection.Country = _TransportationZone.CountryCode
association [0..1] to I_Region as _POBoxDeviatingRegion on $projection.POBoxDeviatingRegion = _POBoxDeviatingRegion.Region
and $projection.POBoxDeviatingCountry = _POBoxDeviatingRegion.Country
association [0..1] to I_Country as _POBoxDeviatingCountry on $projection.POBoxDeviatingCountry = _POBoxDeviatingCountry.Country
association [0..1] to I_AddressCommunicationMethod as _PrfrdCommMediumType on $projection.PrfrdCommMediumType = _PrfrdCommMediumType.CommunicationMediumType
association [0..1] to I_AddressDeliveryServiceType as _DeliveryServiceTypeCode on $projection.DeliveryServiceTypeCode = _DeliveryServiceTypeCode.DeliveryServiceTypeCode
association [0..1] to I_Language as _CorrespondenceLanguage on $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
association [0..1] to I_AddressRepresentation as _AddressRepresentationCode on $projection.AddressRepresentationCode = _AddressRepresentationCode.AddressRepresentationCode
association [0..1] to I_AddressObjectType as _AddressObjectType on $projection.AddressObjectType = _AddressObjectType.AddressObjectType
association [0..1] to I_TimeZone as _TimeZone on $projection.AddressTimeZone = _TimeZone.TimeZoneID
association [0..1] to I_SecondaryRegion as _SecondaryRegion on $projection.SecondaryRegion = _SecondaryRegion.SecondaryRegion
and $projection.Country = _SecondaryRegion.Country
and $projection.Region = _SecondaryRegion.Region
association [0..1] to I_TertiaryRegion as _TertiaryRegion on $projection.TertiaryRegion = _TertiaryRegion.TertiaryRegion
and $projection.SecondaryRegion = _TertiaryRegion.SecondaryRegion
and $projection.Country = _TertiaryRegion.Country
and $projection.Region = _TertiaryRegion.Region
association [0..1] to I_PostalCity as _PostalCity on $projection.CityNumber = _PostalCity.CityNumber
and $projection.Country = _PostalCity.Country
association [0..1] to I_PostalCity as _POBoxDeviatingCityCode on $projection.POBoxDeviatingCityCode = _POBoxDeviatingCityCode.CityNumber
and $projection.Country = _POBoxDeviatingCityCode.Country
association [0..1] to I_RegionalStructureCheckStatus as _RegionalStructureCheckStatus on $projection.RegionalStructureCheckStatus = _RegionalStructureCheckStatus.RegionalStructureCheckStatus
association [0..1] to I_Street as _Street on $projection.Country = _Street.Country
and $projection.Street = _Street.Street
association [0..1] to I_AddressGroup as _AddressGroup on $projection.AddressGroup = _AddressGroup.AddressGroup
association [0..1] to I_AddressPersonName as _AddressPersonName on $projection.AddressPersonID = _AddressPersonName.AddressPersonID
and $projection.AddressRepresentationCode = _AddressPersonName.AddressRepresentationCode
association [0..*] to I_AddressRemark_2 as _Addressremark on $projection.AddressID = _Addressremark.AddressID
and $projection.AddressRepresentationCode = _Addressremark.AddressRepresentationCode
{
key AddressID as AddressID,
@ObjectModel.foreignKey.association: '_AddressPersonName'
key cast('' as ad_persnum ) as AddressPersonID,
@ObjectModel.foreignKey.association: '_AddressRepresentationCode'
@ObjectModel.sapObjectNodeTypeReference: 'AddressRepresentationCode'
key AddressRepresentationCode as AddressRepresentationCode,
@ObjectModel.foreignKey.association: '_AddressObjectType'
@ObjectModel.sapObjectNodeTypeReference: 'AddressObjectType'
cast('1' as ad_adrtype) as AddressObjectType,
@ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
CorrespondenceLanguage,
@ObjectModel.foreignKey.association: '_PrfrdCommMediumType'
@ObjectModel.sapObjectNodeTypeReference: 'CommunicationMediumType'
PrfrdCommMediumType,
cast(concat_with_space(AddresseeName1, AddresseeName2, 1) as ad_namtext ) as AddresseeFullName,
@ObjectModel.foreignKey.association: '_PostalCity'
@ObjectModel.sapObjectNodeTypeReference: 'CityNumber'
CityNumber,
CityName,
DistrictName,
VillageName,
PostalCode,
CompanyPostalCode,
@ObjectModel.foreignKey.association: '_Street'
@ObjectModel.sapObjectNodeTypeReference: 'Street'
Street,
StreetName,
@ObjectModel.foreignKey.association: '_StreetAddrNonDeliverableRsn'
@ObjectModel.sapObjectNodeTypeReference: 'AddressNonDeliverableReason'
@EndUserText.label: 'Street Address Non-Deliverable Reason'
StreetAddrNonDeliverableReason,
StreetPrefixName1,
StreetPrefixName2,
StreetSuffixName1,
StreetSuffixName2,
HouseNumber,
HouseNumberSupplementText,
Building,
Floor,
RoomNumber,
@ObjectModel.foreignKey.association: '_Country'
@ObjectModel.sapObjectNodeTypeReference: 'Country'
Country,
@ObjectModel.foreignKey.association: '_Region'
@ObjectModel.sapObjectNodeTypeReference: 'Region'
Region,
@ObjectModel.foreignKey.association: '_FormOfAddress'
@ObjectModel.sapObjectNodeTypeReference: 'FormOfAddress'
FormOfAddress,
AddresseeName1,
AddresseeName2,
AddresseeName3,
AddresseeName4,
AddressSearchTerm1,
AddressSearchTerm2,
TaxJurisdiction,
@ObjectModel.foreignKey.association: '_TransportationZone'
@ObjectModel.sapObjectNodeTypeReference: 'TransportationZone'
TransportZone,
POBox,
@ObjectModel.foreignKey.association: '_POBoxAddrNonDeliverableReason'
@ObjectModel.sapObjectNodeTypeReference: 'AddressNonDeliverableReason'
@EndUserText.label: 'PO Box Address Non-Deliverable Reason'
POBoxAddrNonDeliverableReason,
POBoxIsWithoutNumber,
POBoxPostalCode,
POBoxLobbyName,
POBoxDeviatingCityName,
@ObjectModel.foreignKey.association: '_POBoxDeviatingCityCode'
@ObjectModel.sapObjectNodeTypeReference: 'CityNumber'
POBoxDeviatingCityCode,
@ObjectModel.foreignKey.association: '_POBoxDeviatingRegion'
@ObjectModel.sapObjectNodeTypeReference: 'Region'
POBoxDeviatingRegion,
@ObjectModel.foreignKey.association: '_POBoxDeviatingCountry'
@ObjectModel.sapObjectNodeTypeReference: 'Country'
POBoxDeviatingCountry,
CareOfName,
@ObjectModel.foreignKey.association: '_DeliveryServiceTypeCode'
@ObjectModel.sapObjectNodeTypeReference: 'DeliveryServiceTypeCode'
DeliveryServiceTypeCode,
DeliveryServiceNumber,
@ObjectModel.foreignKey.association: '_TimeZone'
@ObjectModel.sapObjectNodeTypeReference: 'TimeZone'
AddressTimeZone,
@ObjectModel.foreignKey.association: '_SecondaryRegion'
@ObjectModel.sapObjectNodeTypeReference: 'SecondaryRegion'
SecondaryRegion,
SecondaryRegionName,
@ObjectModel.foreignKey.association: '_TertiaryRegion'
@ObjectModel.sapObjectNodeTypeReference: 'TertiaryRegion'
TertiaryRegion,
TertiaryRegionName,
@ObjectModel.foreignKey.association: '_RegionalStructureCheckStatus'
@ObjectModel.sapObjectNodeTypeReference: 'RegionalStructureCheckStatus'
RegionalStructureCheckStatus,
@ObjectModel.foreignKey.association: '_AddressGroup'
@ObjectModel.sapObjectNodeTypeReference: 'AddressGroup'
AddressGroup,
DistrictNumber,
Village,
RegionalStructureGroup,
@Semantics.user.createdBy: true
AddressCreatedByUser,
@Semantics.systemDateTime.createdAt: true
@Analytics.hidden: true
AddressCreatedOnDateTime,
@Semantics.user.lastChangedBy: true
AddressChangedByUser,
@Semantics.systemDateTime.lastChangedAt: true
@Analytics.hidden: true
AddressChangedOnDateTime,
_EmailAddress,
_PhoneNumber,
_FaxNumber,
_UniformResourceIdentifier,
_CurrentDfltEmailAddress,
_CurrentDfltMobilePhoneNumber,
_CurrentDfltLandlinePhoneNmbr,
_CurrentDfltFaxNumber,
_MainWebsiteURL,
_Region,
_Country,
_FormOfAddress,
_StreetAddrNonDeliverableRsn,
_POBoxAddrNonDeliverableReason,
_TransportationZone,
_POBoxDeviatingRegion,
_POBoxDeviatingCountry,
_PrfrdCommMediumType,
_DeliveryServiceTypeCode,
_CorrespondenceLanguage,
_AddressObjectType,
_AddressRepresentationCode,
_TimeZone,
_SecondaryRegion,
_TertiaryRegion,
_PostalCity,
_RegionalStructureCheckStatus,
_Street,
_AddressGroup,
_AddressPersonName,
_POBoxDeviatingCityCode,
_Addressremark
}
where
AddressIsPersonAddress is initial