Which tables does I_OrgAddressDefaultRprstn use?

I_OrgAddressDefaultRprstn reads from 1 data source(s): I_OrganizationAddress.

How many fields does I_OrgAddressDefaultRprstn have?

I_OrgAddressDefaultRprstn has 87 fields. Key fields: AddressID.

I_OrgAddressDefaultRprstn

DDL: I_ORGADDRESSDEFAULTRPRSTN Type: view_entity COMPOSITE Package: S_ADDRESS_VDM

Default Representation of an Org Address

I_OrgAddressDefaultRprstn is a Composite CDS View (Dimension) that provides data about "Default Representation of an Org Address" in SAP S/4HANA. It reads from 1 data source (I_OrganizationAddress) and exposes 87 fields with key field AddressID. It has 1 association to related views. Part of development package S_ADDRESS_VDM.

Data Sources (1)

Source	Alias	Join Type
I_OrganizationAddress	OrganizationAddress	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_OrganizationAddress	_AddrAdditionalRepresentation	`$projection.AddressID = _AddrAdditionalRepresentation.AddressID and $projection.AddressPersonID = _AddrAdditionalRepresentation.AddressPersonID and _AddrAdditionalRepresentation.AddressRepresentationCode is not initial`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
Analytics.dataCategory	#DIMENSION	view
EndUserText.label	Default Representation of an Org Address	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.representativeKey	AddressID	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view

Fields (87)

Key	Field	Source Table	Source Field	Description
KEY	AddressID	I_OrganizationAddress	AddressID
	AddressPersonID	I_OrganizationAddress	AddressPersonID
	AddressRepresentationCode	I_OrganizationAddress	AddressRepresentationCode
	AddressObjectType	I_OrganizationAddress	AddressObjectType
	CorrespondenceLanguage	I_OrganizationAddress	CorrespondenceLanguage
	PrfrdCommMediumType	I_OrganizationAddress	PrfrdCommMediumType
	AddresseeFullName	I_OrganizationAddress	AddresseeFullName
	CityNumber	I_OrganizationAddress	CityNumber
	CityName	I_OrganizationAddress	CityName
	DistrictName	I_OrganizationAddress	DistrictName
	VillageName	I_OrganizationAddress	VillageName
	PostalCode	I_OrganizationAddress	PostalCode
	CompanyPostalCode	I_OrganizationAddress	CompanyPostalCode
	Street	I_OrganizationAddress	Street
	StreetName	I_OrganizationAddress	StreetName
	StreetAddrNonDeliverableReason	I_OrganizationAddress	StreetAddrNonDeliverableReason	Street Address Non-Deliverable Reason
	StreetPrefixName1	I_OrganizationAddress	StreetPrefixName1
	StreetPrefixName2	I_OrganizationAddress	StreetPrefixName2
	StreetSuffixName1	I_OrganizationAddress	StreetSuffixName1
	StreetSuffixName2	I_OrganizationAddress	StreetSuffixName2
	HouseNumber	I_OrganizationAddress	HouseNumber
	HouseNumberSupplementText	I_OrganizationAddress	HouseNumberSupplementText
	Building	I_OrganizationAddress	Building
	Floor	I_OrganizationAddress	Floor
	RoomNumber	I_OrganizationAddress	RoomNumber
	Country	I_OrganizationAddress	Country
	Region	I_OrganizationAddress	Region
	FormOfAddress	I_OrganizationAddress	FormOfAddress
	AddresseeName1	I_OrganizationAddress	AddresseeName1
	AddresseeName2	I_OrganizationAddress	AddresseeName2
	AddresseeName3	I_OrganizationAddress	AddresseeName3
	AddresseeName4	I_OrganizationAddress	AddresseeName4
	AddressSearchTerm1	I_OrganizationAddress	AddressSearchTerm1
	AddressSearchTerm2	I_OrganizationAddress	AddressSearchTerm2
	TaxJurisdiction	I_OrganizationAddress	TaxJurisdiction
	TransportZone	I_OrganizationAddress	TransportZone
	POBox	I_OrganizationAddress	POBox
	POBoxAddrNonDeliverableReason	I_OrganizationAddress	POBoxAddrNonDeliverableReason	PO Box Address Non-Deliverable Reason
	POBoxIsWithoutNumber	I_OrganizationAddress	POBoxIsWithoutNumber
	POBoxPostalCode	I_OrganizationAddress	POBoxPostalCode
	POBoxLobbyName	I_OrganizationAddress	POBoxLobbyName
	POBoxDeviatingCityName	I_OrganizationAddress	POBoxDeviatingCityName
	POBoxDeviatingCityCode	I_OrganizationAddress	POBoxDeviatingCityCode
	POBoxDeviatingRegion	I_OrganizationAddress	POBoxDeviatingRegion
	POBoxDeviatingCountry	I_OrganizationAddress	POBoxDeviatingCountry
	CareOfName	I_OrganizationAddress	CareOfName
	DeliveryServiceTypeCode	I_OrganizationAddress	DeliveryServiceTypeCode
	DeliveryServiceNumber	I_OrganizationAddress	DeliveryServiceNumber
	AddressTimeZone	I_OrganizationAddress	AddressTimeZone
	SecondaryRegion	I_OrganizationAddress	SecondaryRegion
	SecondaryRegionName	I_OrganizationAddress	SecondaryRegionName
	TertiaryRegion	I_OrganizationAddress	TertiaryRegion
	TertiaryRegionName	I_OrganizationAddress	TertiaryRegionName
	RegionalStructureCheckStatus	I_OrganizationAddress	RegionalStructureCheckStatus
	AddressGroup	I_OrganizationAddress	AddressGroup
	_AddressGroup	I_OrganizationAddress	_AddressGroup
	_AddressObjectType	I_OrganizationAddress	_AddressObjectType
	_AddressPersonName	I_OrganizationAddress	_AddressPersonName
	_AddressRepresentationCode	I_OrganizationAddress	_AddressRepresentationCode
	_CorrespondenceLanguage	I_OrganizationAddress	_CorrespondenceLanguage
	_Country	I_OrganizationAddress	_Country
	_CurrentDfltEmailAddress	I_OrganizationAddress	_CurrentDfltEmailAddress
	_CurrentDfltFaxNumber	I_OrganizationAddress	_CurrentDfltFaxNumber
	_CurrentDfltLandlinePhoneNmbr	I_OrganizationAddress	_CurrentDfltLandlinePhoneNmbr
	_CurrentDfltMobilePhoneNumber	I_OrganizationAddress	_CurrentDfltMobilePhoneNumber
	_DeliveryServiceTypeCode	I_OrganizationAddress	_DeliveryServiceTypeCode
	_EmailAddress	I_OrganizationAddress	_EmailAddress
	_FaxNumber	I_OrganizationAddress	_FaxNumber
	_FormOfAddress	I_OrganizationAddress	_FormOfAddress
	_MainWebsiteURL	I_OrganizationAddress	_MainWebsiteURL
	_PhoneNumber	I_OrganizationAddress	_PhoneNumber
	_POBoxAddrNonDeliverableReason	I_OrganizationAddress	_POBoxAddrNonDeliverableReason
	_POBoxDeviatingCityCode	I_OrganizationAddress	_POBoxDeviatingCityCode
	_POBoxDeviatingCountry	I_OrganizationAddress	_POBoxDeviatingCountry
	_POBoxDeviatingRegion	I_OrganizationAddress	_POBoxDeviatingRegion
	_PostalCity	I_OrganizationAddress	_PostalCity
	_PrfrdCommMediumType	I_OrganizationAddress	_PrfrdCommMediumType
	_Region	I_OrganizationAddress	_Region
	_RegionalStructureCheckStatus	I_OrganizationAddress	_RegionalStructureCheckStatus
	_SecondaryRegion	I_OrganizationAddress	_SecondaryRegion
	_Street	I_OrganizationAddress	_Street
	_StreetAddrNonDeliverableRsn	I_OrganizationAddress	_StreetAddrNonDeliverableRsn
	_TertiaryRegion	I_OrganizationAddress	_TertiaryRegion
	_TimeZone	I_OrganizationAddress	_TimeZone
	_TransportationZone	I_OrganizationAddress	_TransportationZone
	_UniformResourceIdentifier	I_OrganizationAddress	_UniformResourceIdentifier
	_AddrAdditionalRepresentation		_AddrAdditionalRepresentation

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@Analytics.dataCategory: #DIMENSION
@AccessControl.privilegedAssociations: ['_AddrAdditionalRepresentation', '_EmailAddress', '_CurrentDfltEmailAddress', '_PhoneNumber', '_CurrentDfltLandlinePhoneNmbr', '_CurrentDfltMobilePhoneNumber', '_FaxNumber', '_CurrentDfltFaxNumber', '_UniformResourceIdentifier', '_MainWebsiteURL']
@EndUserText.label: 'Default Representation of an Org Address'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType:{
    serviceQuality: #C,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity I_OrgAddressDefaultRprstn
  as select from I_OrganizationAddress as OrganizationAddress
  association [0..*] to I_OrganizationAddress as _AddrAdditionalRepresentation on  $projection.AddressID                                   = _AddrAdditionalRepresentation.AddressID
                                                                               and $projection.AddressPersonID                             = _AddrAdditionalRepresentation.AddressPersonID
                                                                               and _AddrAdditionalRepresentation.AddressRepresentationCode is not initial
{
  key OrganizationAddress.AddressID,
      @ObjectModel.foreignKey.association: '_AddressPersonName'
      OrganizationAddress.AddressPersonID,
      @ObjectModel.foreignKey.association: '_AddressRepresentationCode'
      @ObjectModel.sapObjectNodeTypeReference: 'AddressRepresentationCode'
      OrganizationAddress.AddressRepresentationCode,
      @ObjectModel.foreignKey.association: '_AddressObjectType'
      @ObjectModel.sapObjectNodeTypeReference: 'AddressObjectType'
      OrganizationAddress.AddressObjectType,
      @ObjectModel.foreignKey.association: '_CorrespondenceLanguage'
      OrganizationAddress.CorrespondenceLanguage,
      @ObjectModel.foreignKey.association: '_PrfrdCommMediumType'
      @ObjectModel.sapObjectNodeTypeReference: 'CommunicationMediumType'
      OrganizationAddress.PrfrdCommMediumType,
      OrganizationAddress.AddresseeFullName,
      @ObjectModel.foreignKey.association: '_PostalCity'
      @ObjectModel.sapObjectNodeTypeReference: 'CityNumber'
      OrganizationAddress.CityNumber,
      OrganizationAddress.CityName,
      OrganizationAddress.DistrictName,
      OrganizationAddress.VillageName,
      OrganizationAddress.PostalCode,
      OrganizationAddress.CompanyPostalCode,
      @ObjectModel.foreignKey.association: '_Street'
      @ObjectModel.sapObjectNodeTypeReference: 'Street'
      OrganizationAddress.Street,
      OrganizationAddress.StreetName,
      @ObjectModel.foreignKey.association: '_StreetAddrNonDeliverableRsn'
      @ObjectModel.sapObjectNodeTypeReference: 'AddressNonDeliverableReason'
      @EndUserText.label: 'Street Address Non-Deliverable Reason'
      OrganizationAddress.StreetAddrNonDeliverableReason,
      OrganizationAddress.StreetPrefixName1,
      OrganizationAddress.StreetPrefixName2,
      OrganizationAddress.StreetSuffixName1,
      OrganizationAddress.StreetSuffixName2,
      OrganizationAddress.HouseNumber,
      OrganizationAddress.HouseNumberSupplementText,
      OrganizationAddress.Building,
      OrganizationAddress.Floor,
      OrganizationAddress.RoomNumber,
      @ObjectModel.foreignKey.association: '_Country'
      @ObjectModel.sapObjectNodeTypeReference: 'Country'
      OrganizationAddress.Country,
      @ObjectModel.foreignKey.association: '_Region'
      @ObjectModel.sapObjectNodeTypeReference: 'Region'
      OrganizationAddress.Region,
      @ObjectModel.foreignKey.association: '_FormOfAddress'
      @ObjectModel.sapObjectNodeTypeReference: 'FormOfAddress'
      OrganizationAddress.FormOfAddress,
      OrganizationAddress.AddresseeName1,
      OrganizationAddress.AddresseeName2,
      OrganizationAddress.AddresseeName3,
      OrganizationAddress.AddresseeName4,
      OrganizationAddress.AddressSearchTerm1,
      OrganizationAddress.AddressSearchTerm2,
      OrganizationAddress.TaxJurisdiction,
      @ObjectModel.foreignKey.association: '_TransportationZone'
      @ObjectModel.sapObjectNodeTypeReference: 'TransportationZone'
      OrganizationAddress.TransportZone,
      OrganizationAddress.POBox,
      @ObjectModel.foreignKey.association: '_POBoxAddrNonDeliverableReason'
      @ObjectModel.sapObjectNodeTypeReference: 'AddressNonDeliverableReason'
      @EndUserText.label: 'PO Box Address Non-Deliverable Reason'
      OrganizationAddress.POBoxAddrNonDeliverableReason,
      OrganizationAddress.POBoxIsWithoutNumber,
      OrganizationAddress.POBoxPostalCode,
      OrganizationAddress.POBoxLobbyName,
      OrganizationAddress.POBoxDeviatingCityName,
      @ObjectModel.foreignKey.association: '_POBoxDeviatingCityCode'
      @ObjectModel.sapObjectNodeTypeReference: 'CityNumber'
      OrganizationAddress.POBoxDeviatingCityCode,
      @ObjectModel.foreignKey.association: '_POBoxDeviatingRegion'
      @ObjectModel.sapObjectNodeTypeReference: 'Region'
      OrganizationAddress.POBoxDeviatingRegion,
      @ObjectModel.foreignKey.association: '_POBoxDeviatingCountry'
      @ObjectModel.sapObjectNodeTypeReference: 'Country'
      OrganizationAddress.POBoxDeviatingCountry,
      OrganizationAddress.CareOfName,
      @ObjectModel.foreignKey.association: '_DeliveryServiceTypeCode'
      @ObjectModel.sapObjectNodeTypeReference: 'DeliveryServiceTypeCode'
      OrganizationAddress.DeliveryServiceTypeCode,
      OrganizationAddress.DeliveryServiceNumber,
      @ObjectModel.foreignKey.association: '_TimeZone'
      @ObjectModel.sapObjectNodeTypeReference: 'TimeZone'
      OrganizationAddress.AddressTimeZone,
      @ObjectModel.foreignKey.association: '_SecondaryRegion'
      @ObjectModel.sapObjectNodeTypeReference: 'SecondaryRegion'
      OrganizationAddress.SecondaryRegion,
      OrganizationAddress.SecondaryRegionName,
      @ObjectModel.foreignKey.association: '_TertiaryRegion'
      @ObjectModel.sapObjectNodeTypeReference: 'TertiaryRegion'
      OrganizationAddress.TertiaryRegion,
      OrganizationAddress.TertiaryRegionName,
      @ObjectModel.foreignKey.association: '_RegionalStructureCheckStatus'
      @ObjectModel.sapObjectNodeTypeReference: 'RegionalStructureCheckStatus'
      OrganizationAddress.RegionalStructureCheckStatus,
      @ObjectModel.foreignKey.association: '_AddressGroup'
      @ObjectModel.sapObjectNodeTypeReference: 'AddressGroup'
      OrganizationAddress.AddressGroup,

      /* Associations */
      OrganizationAddress._AddressGroup,
      OrganizationAddress._AddressObjectType,
      OrganizationAddress._AddressPersonName,
      OrganizationAddress._AddressRepresentationCode,
      OrganizationAddress._CorrespondenceLanguage,
      OrganizationAddress._Country,
      OrganizationAddress._CurrentDfltEmailAddress,
      OrganizationAddress._CurrentDfltFaxNumber,
      OrganizationAddress._CurrentDfltLandlinePhoneNmbr,
      OrganizationAddress._CurrentDfltMobilePhoneNumber,
      OrganizationAddress._DeliveryServiceTypeCode,
      OrganizationAddress._EmailAddress,
      OrganizationAddress._FaxNumber,
      OrganizationAddress._FormOfAddress,
      OrganizationAddress._MainWebsiteURL,
      OrganizationAddress._PhoneNumber,
      OrganizationAddress._POBoxAddrNonDeliverableReason,
      OrganizationAddress._POBoxDeviatingCityCode,
      OrganizationAddress._POBoxDeviatingCountry,
      OrganizationAddress._POBoxDeviatingRegion,
      OrganizationAddress._PostalCity,
      OrganizationAddress._PrfrdCommMediumType,
      OrganizationAddress._Region,
      OrganizationAddress._RegionalStructureCheckStatus,
      OrganizationAddress._SecondaryRegion,
      OrganizationAddress._Street,
      OrganizationAddress._StreetAddrNonDeliverableRsn,
      OrganizationAddress._TertiaryRegion,
      OrganizationAddress._TimeZone,
      OrganizationAddress._TransportationZone,
      OrganizationAddress._UniformResourceIdentifier,
      _AddrAdditionalRepresentation
}
where
  OrganizationAddress.AddressRepresentationCode is initial

Depth:

I_OrgAddressDefaultRprstn view_entity

I_OrganizationAddress view_entity