What is I_OrgAddressDefaultRprstn in SAP S/4HANA?

I_OrgAddressDefaultRprstn is a composite CDS view in SAP S/4HANA. Default Representation of an Org Address It contains 87 fields.

Which tables does I_OrgAddressDefaultRprstn read from?

I_OrgAddressDefaultRprstn reads data from: I_OrganizationAddress.

What VDM layer is I_OrgAddressDefaultRprstn?

I_OrgAddressDefaultRprstn is classified as a Composite view that combines data from multiple basic views.

I_OrgAddressDefaultRprstn

DDL: I_ORGADDRESSDEFAULTRPRSTN Type: view_entity COMPOSITE

87 Fields 1 Data Sources 1 Associations

Default Representation of an Org Address

I_OrgAddressDefaultRprstn (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

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.

SAP Help Documentation

Category	CDS Views for Business Address Service
Data Category	Dimension
Status	City File Test Status

Purpose
This CDS view returns the address of an organization/company in the default (typically Latin) representation. This CDS view provides the data to answer the following business questions: What is the default representation of an organization/company address? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Important Fields Important fields in this view include the following: Field Name Description AddressID AddressPersonID AddressRepresentationCode AddressObjectType Address Number Person Number Version ID for International Addresses Address Type (1=Organization, 2=Person, 3=Contact person) CorrespondenceLanguage Language Key PrfrdCommMediumType Communication Method Key AddresseeFullName Full Name of a Person CityNumber CityName City Code for City/Street File City DistrictName District VillageName City (different from postal city) PostalCode CompanyPostalCode City Postal Code Company Postal Code Street StreetName StreetAddrNonDeliverableReason StreetPrefixName1 StreetPrefixName2 StreetSuffixName1 StreetSuffixName2 Street Number for City/Street File Street Street Address Undeliverable Flag Street 2 Street 3 Street 4 Street 5 HouseNumber HouseNumberSupplementText Building Floor RoomNumber House Number House Number Supplement Building (Number or Code) Floor in Building Room or Apartment Number Country Region Country/Region Key Region (State, Province, County) FormOfAddress Form of Address Key AddresseeName1 AddresseeName2 AddresseeName3 AddresseeName4 AddressSearchTerm1 AddressSearchTerm2 Name 1 Name 2 Name 3 Name 4 Search Term 1 Search Term 2 TaxJurisdiction Tax Jurisdiction TransportZone Transportation zone to or from which the goods are delivered POBox POBoxAddrNonDeliverableReason POBoxIsWithoutNumber POBoxPostalCode POBoxLobbyName POBoxDeviatingCityName POBoxDeviatingCityCode POBoxDeviatingRegion POBoxDeviatingCountry PO Box PO Box Address Non-Deliverable Reason PO Box without Number PO Box Postal Code PO Box Lobby PO Box City City PO Box Code (City file) PO Box Region (Country/Region, State, Province) PO Box of Country/Region CareOfName Care of Name DeliveryServiceTypeCode DeliveryServiceNumber Type of Delivery Service Number of Delivery Service AddressTimeZone Address Time Zone SecondaryRegion SecondaryRegionName TertiaryRegion TertiaryRegionName County Code County Township Code Township RegionalStructureCheckStatus City File Test Status AddressGroup Address Group Key

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	BC-SRV-ADR
Capabilities	Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

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	Ship-to address
	AddressPersonID	I_OrganizationAddress	AddressPersonID	Person Number
	AddressRepresentationCode	I_OrganizationAddress	AddressRepresentationCode	Version ID for International Addresses
	AddressObjectType	I_OrganizationAddress	AddressObjectType	Address type (1=Organization, 2=Person, 3=Contact person)
	CorrespondenceLanguage	I_OrganizationAddress	CorrespondenceLanguage	Language Key
	PrfrdCommMediumType	I_OrganizationAddress	PrfrdCommMediumType	Communication Method (Key) (Business Address Services)
	AddresseeFullName	I_OrganizationAddress	AddresseeFullName	Full Name of Person
	CityNumber	I_OrganizationAddress	CityNumber	City code for city/street file
	CityName	I_OrganizationAddress	CityName	Name
	DistrictName	I_OrganizationAddress	DistrictName	District
	VillageName	I_OrganizationAddress	VillageName	City (different from postal city)
	PostalCode	I_OrganizationAddress	PostalCode	City postal code
	CompanyPostalCode	I_OrganizationAddress	CompanyPostalCode	Company Postal Code (for Large Customers)
	Street	I_OrganizationAddress	Street	Street Number for City/Street File
	StreetName	I_OrganizationAddress	StreetName	Street
	StreetAddrNonDeliverableReason	I_OrganizationAddress	StreetAddrNonDeliverableReason	Street Address Non-Deliverable Reason
	StreetPrefixName1	I_OrganizationAddress	StreetPrefixName1	Street 2
	StreetPrefixName2	I_OrganizationAddress	StreetPrefixName2	Street 3
	StreetSuffixName1	I_OrganizationAddress	StreetSuffixName1	Street 4
	StreetSuffixName2	I_OrganizationAddress	StreetSuffixName2	Street 5
	HouseNumber	I_OrganizationAddress	HouseNumber	House Number
	HouseNumberSupplementText	I_OrganizationAddress	HouseNumberSupplementText	House number supplement
	Building	I_OrganizationAddress	Building	Building (Number or Code)
	Floor	I_OrganizationAddress	Floor	Floor in building
	RoomNumber	I_OrganizationAddress	RoomNumber	Room or Apartment Number
	Country	I_OrganizationAddress	Country	Country/Region Key
	Region	I_OrganizationAddress	Region	Region (State, Province, County)
	FormOfAddress	I_OrganizationAddress	FormOfAddress	Form-of-Address Key
	AddresseeName1	I_OrganizationAddress	AddresseeName1	Name 1
	AddresseeName2	I_OrganizationAddress	AddresseeName2	Name 2
	AddresseeName3	I_OrganizationAddress	AddresseeName3	Name 3
	AddresseeName4	I_OrganizationAddress	AddresseeName4	Name 4
	AddressSearchTerm1	I_OrganizationAddress	AddressSearchTerm1	Search Term 1
	AddressSearchTerm2	I_OrganizationAddress	AddressSearchTerm2	Search Term 2
	TaxJurisdiction	I_OrganizationAddress	TaxJurisdiction	Tax Jurisdiction
	TransportZone	I_OrganizationAddress	TransportZone	Transportation zone to or from which the goods are delivered
	POBox	I_OrganizationAddress	POBox	PO Box
	POBoxAddrNonDeliverableReason	I_OrganizationAddress	POBoxAddrNonDeliverableReason	PO Box Address Non-Deliverable Reason
	POBoxIsWithoutNumber	I_OrganizationAddress	POBoxIsWithoutNumber	Flag: PO Box Without Number
	POBoxPostalCode	I_OrganizationAddress	POBoxPostalCode	PO Box Postal Code
	POBoxLobbyName	I_OrganizationAddress	POBoxLobbyName	PO Box Lobby
	POBoxDeviatingCityName	I_OrganizationAddress	POBoxDeviatingCityName	PO Box City
	POBoxDeviatingCityCode	I_OrganizationAddress	POBoxDeviatingCityCode	City PO box code (City file)
	POBoxDeviatingRegion	I_OrganizationAddress	POBoxDeviatingRegion	Region for PO Box (Country/Region, State, Province, ...)
	POBoxDeviatingCountry	I_OrganizationAddress	POBoxDeviatingCountry	PO Box of Country/Region
	CareOfName	I_OrganizationAddress	CareOfName	c/o name
	DeliveryServiceTypeCode	I_OrganizationAddress	DeliveryServiceTypeCode	Type of Delivery Service
	DeliveryServiceNumber	I_OrganizationAddress	DeliveryServiceNumber	Number of Delivery Service
	AddressTimeZone	I_OrganizationAddress	AddressTimeZone	Address Time Zone
	SecondaryRegion	I_OrganizationAddress	SecondaryRegion	County code for county
	SecondaryRegionName	I_OrganizationAddress	SecondaryRegionName	County
	TertiaryRegion	I_OrganizationAddress	TertiaryRegion	Township code for Township
	TertiaryRegionName	I_OrganizationAddress	TertiaryRegionName	Township
	RegionalStructureCheckStatus	I_OrganizationAddress	RegionalStructureCheckStatus	City file test status
	AddressGroup	I_OrganizationAddress	AddressGroup	Address Group (Key) (Business Address Services)
	_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_OrgAddressDefaultRprstn.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_OrgAddressDefaultRprstn AS
SELECT
  OrganizationAddress.AddressID AS AddressID,
  OrganizationAddress.AddressPersonID AS AddressPersonID,
  OrganizationAddress.AddressRepresentationCode AS AddressRepresentationCode,
  OrganizationAddress.AddressObjectType AS AddressObjectType,
  OrganizationAddress.CorrespondenceLanguage AS CorrespondenceLanguage,
  OrganizationAddress.PrfrdCommMediumType AS PrfrdCommMediumType,
  OrganizationAddress.AddresseeFullName AS AddresseeFullName,
  OrganizationAddress.CityNumber AS CityNumber,
  OrganizationAddress.CityName AS CityName,
  OrganizationAddress.DistrictName AS DistrictName,
  OrganizationAddress.VillageName AS VillageName,
  OrganizationAddress.PostalCode AS PostalCode,
  OrganizationAddress.CompanyPostalCode AS CompanyPostalCode,
  OrganizationAddress.Street AS Street,
  OrganizationAddress.StreetName AS StreetName,
  OrganizationAddress.StreetAddrNonDeliverableReason AS StreetAddrNonDeliverableReason,
  OrganizationAddress.StreetPrefixName1 AS StreetPrefixName1,
  OrganizationAddress.StreetPrefixName2 AS StreetPrefixName2,
  OrganizationAddress.StreetSuffixName1 AS StreetSuffixName1,
  OrganizationAddress.StreetSuffixName2 AS StreetSuffixName2,
  OrganizationAddress.HouseNumber AS HouseNumber,
  OrganizationAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  OrganizationAddress.Building AS Building,
  OrganizationAddress.Floor AS Floor,
  OrganizationAddress.RoomNumber AS RoomNumber,
  OrganizationAddress.Country AS Country,
  OrganizationAddress.Region AS Region,
  OrganizationAddress.FormOfAddress AS FormOfAddress,
  OrganizationAddress.AddresseeName1 AS AddresseeName1,
  OrganizationAddress.AddresseeName2 AS AddresseeName2,
  OrganizationAddress.AddresseeName3 AS AddresseeName3,
  OrganizationAddress.AddresseeName4 AS AddresseeName4,
  OrganizationAddress.AddressSearchTerm1 AS AddressSearchTerm1,
  OrganizationAddress.AddressSearchTerm2 AS AddressSearchTerm2,
  OrganizationAddress.TaxJurisdiction AS TaxJurisdiction,
  OrganizationAddress.TransportZone AS TransportZone,
  OrganizationAddress.POBox AS POBox,
  OrganizationAddress.POBoxAddrNonDeliverableReason AS POBoxAddrNonDeliverableReason,
  OrganizationAddress.POBoxIsWithoutNumber AS POBoxIsWithoutNumber,
  OrganizationAddress.POBoxPostalCode AS POBoxPostalCode,
  OrganizationAddress.POBoxLobbyName AS POBoxLobbyName,
  OrganizationAddress.POBoxDeviatingCityName AS POBoxDeviatingCityName,
  OrganizationAddress.POBoxDeviatingCityCode AS POBoxDeviatingCityCode,
  OrganizationAddress.POBoxDeviatingRegion AS POBoxDeviatingRegion,
  OrganizationAddress.POBoxDeviatingCountry AS POBoxDeviatingCountry,
  OrganizationAddress.CareOfName AS CareOfName,
  OrganizationAddress.DeliveryServiceTypeCode AS DeliveryServiceTypeCode,
  OrganizationAddress.DeliveryServiceNumber AS DeliveryServiceNumber,
  OrganizationAddress.AddressTimeZone AS AddressTimeZone,
  OrganizationAddress.SecondaryRegion AS SecondaryRegion,
  OrganizationAddress.SecondaryRegionName AS SecondaryRegionName,
  OrganizationAddress.TertiaryRegion AS TertiaryRegion,
  OrganizationAddress.TertiaryRegionName AS TertiaryRegionName,
  OrganizationAddress.RegionalStructureCheckStatus AS RegionalStructureCheckStatus,
  OrganizationAddress.AddressGroup AS AddressGroup,
  OrganizationAddress._AddressGroup AS _AddressGroup,
  OrganizationAddress._AddressObjectType AS _AddressObjectType,
  OrganizationAddress._AddressPersonName AS _AddressPersonName,
  OrganizationAddress._AddressRepresentationCode AS _AddressRepresentationCode,
  OrganizationAddress._CorrespondenceLanguage AS _CorrespondenceLanguage,
  OrganizationAddress._Country AS _Country,
  OrganizationAddress._CurrentDfltEmailAddress AS _CurrentDfltEmailAddress,
  OrganizationAddress._CurrentDfltFaxNumber AS _CurrentDfltFaxNumber,
  OrganizationAddress._CurrentDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr,
  OrganizationAddress._CurrentDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber,
  OrganizationAddress._DeliveryServiceTypeCode AS _DeliveryServiceTypeCode,
  OrganizationAddress._EmailAddress AS _EmailAddress,
  OrganizationAddress._FaxNumber AS _FaxNumber,
  OrganizationAddress._FormOfAddress AS _FormOfAddress,
  OrganizationAddress._MainWebsiteURL AS _MainWebsiteURL,
  OrganizationAddress._PhoneNumber AS _PhoneNumber,
  OrganizationAddress._POBoxAddrNonDeliverableReason AS _POBoxAddrNonDeliverableReason,
  OrganizationAddress._POBoxDeviatingCityCode AS _POBoxDeviatingCityCode,
  OrganizationAddress._POBoxDeviatingCountry AS _POBoxDeviatingCountry,
  OrganizationAddress._POBoxDeviatingRegion AS _POBoxDeviatingRegion,
  OrganizationAddress._PostalCity AS _PostalCity,
  OrganizationAddress._PrfrdCommMediumType AS _PrfrdCommMediumType,
  OrganizationAddress._Region AS _Region,
  OrganizationAddress._RegionalStructureCheckStatus AS _RegionalStructureCheckStatus,
  OrganizationAddress._SecondaryRegion AS _SecondaryRegion,
  OrganizationAddress._Street AS _Street,
  OrganizationAddress._StreetAddrNonDeliverableRsn AS _StreetAddrNonDeliverableRsn,
  OrganizationAddress._TertiaryRegion AS _TertiaryRegion,
  OrganizationAddress._TimeZone AS _TimeZone,
  OrganizationAddress._TransportationZone AS _TransportationZone,
  OrganizationAddress._UniformResourceIdentifier AS _UniformResourceIdentifier
FROM I_OrganizationAddress AS OrganizationAddress
LEFT OUTER JOIN I_OrganizationAddress AS _AddrAdditionalRepresentation ON AddressID = _AddrAdditionalRepresentation.AddressID AND AddressPersonID = _AddrAdditionalRepresentation.AddressPersonID AND _AddrAdditionalRepresentation.AddressRepresentationCode is not initial  -- association [0..*]
;

Depth:

I_OrgAddressDefaultRprstn view_entity

I_OrganizationAddress view_entity