I_BANKORGANIZATIONADDRESS
Address of an Organization used for Bank
I_BANKORGANIZATIONADDRESS is a CDS View in S/4HANA. Address of an Organization used for Bank. It contains 72 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_BankAddressDepTP | view_entity | inner | TRANSACTIONAL | Bank Address |
| R_BankAddressTP | view_entity | left_outer | TRANSACTIONAL | Bank Address |
| R_BankScriptedAddressTP | view_entity | inner | TRANSACTIONAL | Bank Scripted Address |
Fields (72)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressRepresentationCode | AddressRepresentationCode | 3 |
| _AddressObjectType | _AddressObjectType | 1 | |
| _AddressPersonName | _AddressPersonName | 1 | |
| _AddressRepresentationCode | _AddressRepresentationCode | 3 | |
| _CorrespondenceLanguage | _CorrespondenceLanguage | 3 | |
| _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 | 3 | |
| _MainWebsiteURL | _MainWebsiteURL | 1 | |
| _PhoneNumber | _PhoneNumber | 1 | |
| _POBoxAddrNonDeliverableReason | _POBoxAddrNonDeliverableReason | 1 | |
| _POBoxDeviatingCountry | _POBoxDeviatingCountry | 1 | |
| _POBoxDeviatingRegion | _POBoxDeviatingRegion | 1 | |
| _PrfrdCommMediumType | _PrfrdCommMediumType | 1 | |
| _Region | _Region | 2 | |
| _StreetAddrNonDeliverableRsn | _StreetAddrNonDeliverableRsn | 1 | |
| _TimeZone | _TimeZone | 1 | |
| _TransportationZone | _TransportationZone | 1 | |
| _UniformResourceIdentifier | _UniformResourceIdentifier | 1 | |
| AddresseeFullName | AddresseeFullName | 3 | |
| AddresseeName1 | AddresseeName1 | 1 | |
| AddresseeName2 | AddresseeName2 | 1 | |
| AddresseeName3 | AddresseeName3 | 1 | |
| AddresseeName4 | AddresseeName4 | 1 | |
| AddressID | AddressID | 3 | |
| AddressObjectType | AddressObjectType | 3 | |
| AddressPersonID | AddressPersonID | 2 | |
| AddressSearchTerm1 | AddressSearchTerm1 | 2 | |
| AddressSearchTerm2 | AddressSearchTerm2 | 2 | |
| AddressTimeZone | AddressTimeZone | 3 | |
| Building | Building | 3 | |
| CareOfName | CareOfName | 3 | |
| CityName | CityName | 2 | |
| CompanyPostalCode | CompanyPostalCode | 3 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 3 | |
| Country | Country | 3 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 3 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 3 | |
| DistrictName | DistrictName | 3 | |
| Floor | Floor | 3 | |
| FormOfAddress | FormOfAddress | 3 | |
| HouseNumber | HouseNumber | 3 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 3 | |
| POBox | POBox | 3 | |
| POBoxAddrNonDeliverableReason | POBoxAddrNonDeliverableReason | 3 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 3 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 3 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 3 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 3 | |
| POBoxLobbyName | POBoxLobbyName | 3 | |
| POBoxPostalCode | POBoxPostalCode | 3 | |
| PostalCode | PostalCode | 3 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 3 | |
| Region | Region | 2 | |
| RoomNumber | RoomNumber | 3 | |
| SecondaryRegionName | SecondaryRegionName | 3 | |
| StreetAddrNonDeliverableReason | StreetAddrNonDeliverableReason | 3 | |
| StreetName | StreetName | 2 | |
| StreetPrefixName1 | StreetPrefixName1 | 3 | |
| StreetPrefixName2 | StreetPrefixName2 | 3 | |
| StreetSuffixName1 | StreetSuffixName1 | 3 | |
| StreetSuffixName2 | StreetSuffixName2 | 3 | |
| TaxJurisdiction | TaxJurisdiction | 3 | |
| TertiaryRegionName | TertiaryRegionName | 3 | |
| TransportZone | TransportZone | 3 | |
| VillageName | VillageName | 3 |
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_EmailAddress', '_CurrentDfltEmailAddress', '_PhoneNumber', '_CurrentDfltLandlinePhoneNmbr', '_CurrentDfltMobilePhoneNumber', '_FaxNumber', '_CurrentDfltFaxNumber', '_UniformResourceIdentifier', '_MainWebsiteURL']
@EndUserText.label: 'Address of an Organization used for Bank'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
define view entity I_BankOrganizationAddress
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
{
key AddressID as AddressID,
@ObjectModel.foreignKey.association: '_AddressPersonName'
key case when $projection.AddressID is not initial then cast('' as ad_persnum ) end as AddressPersonID,
@ObjectModel.foreignKey.association: '_AddressRepresentationCode'
@ObjectModel.sapObjectNodeTypeReference: 'AddressRepresentationCode'
key AddressRepresentationCode as AddressRepresentationCode,
@ObjectModel.foreignKey.association: '_AddressObjectType'
@ObjectModel.sapObjectNodeTypeReference: 'AddressObjectType'
case when $projection.AddressID is not initial then cast('1' as ad_adrtype) end 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
}
where
AddressIsPersonAddress is initial