I_OrgNamePostlAddrDfltRprstn

DDL: I_ORGNAMEPOSTLADDRDFLTRPRSTN Type: view_entity COMPOSITE Package: S_ADDRESS_VDM

Dflt Addr Rprstn for Org and Postal

I_OrgNamePostlAddrDfltRprstn is a Composite CDS View (Dimension) that provides data about "Dflt Addr Rprstn for Org and Postal" in SAP S/4HANA. It reads from 1 data source (I_AddrOrgNamePostalAddress) and exposes 58 fields with key field AddressID. It has 1 association to related views. Part of development package S_ADDRESS_VDM.

1 data source(s) 58 fields

Data Sources (1)

SourceAliasJoin Type
I_AddrOrgNamePostalAddress PostalAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AddrOrgNamePostalAddress _DfltRprstnPostalAddress $projection.AddressID = _DfltRprstnPostalAddress.AddressID and _DfltRprstnPostalAddress.AddressRepresentationCode is not initial

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.dataCategory #DIMENSION view
EndUserText.label Dflt Addr Rprstn for Org and Postal 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 (58)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_AddrOrgNamePostalAddress AddressID
AddressRepresentationCode I_AddrOrgNamePostalAddress AddressRepresentationCode
AddressIsPersonAddress I_AddrOrgNamePostalAddress AddressIsPersonAddress
CorrespondenceLanguage I_AddrOrgNamePostalAddress CorrespondenceLanguage
PrfrdCommMediumType I_AddrOrgNamePostalAddress PrfrdCommMediumType
CityNumber I_AddrOrgNamePostalAddress CityNumber
CityName I_AddrOrgNamePostalAddress CityName
DistrictName I_AddrOrgNamePostalAddress DistrictName
VillageName I_AddrOrgNamePostalAddress VillageName
PostalCode I_AddrOrgNamePostalAddress PostalCode
CompanyPostalCode I_AddrOrgNamePostalAddress CompanyPostalCode
POBox I_AddrOrgNamePostalAddress POBox
POBoxAddrNonDeliverableReason I_AddrOrgNamePostalAddress POBoxAddrNonDeliverableReason PO Box Address Non-Deliverable Reason
POBoxIsWithoutNumber I_AddrOrgNamePostalAddress POBoxIsWithoutNumber
POBoxPostalCode I_AddrOrgNamePostalAddress POBoxPostalCode
POBoxLobbyName I_AddrOrgNamePostalAddress POBoxLobbyName
POBoxDeviatingCityName I_AddrOrgNamePostalAddress POBoxDeviatingCityName
POBoxDeviatingCityCode I_AddrOrgNamePostalAddress POBoxDeviatingCityCode
POBoxDeviatingRegion I_AddrOrgNamePostalAddress POBoxDeviatingRegion
POBoxDeviatingCountry I_AddrOrgNamePostalAddress POBoxDeviatingCountry
Street I_AddrOrgNamePostalAddress Street
StreetName I_AddrOrgNamePostalAddress StreetName
StreetAddrNonDeliverableReason I_AddrOrgNamePostalAddress StreetAddrNonDeliverableReason Street Address Non-Deliverable Reason
StreetPrefixName1 I_AddrOrgNamePostalAddress StreetPrefixName1
StreetPrefixName2 I_AddrOrgNamePostalAddress StreetPrefixName2
StreetSuffixName1 I_AddrOrgNamePostalAddress StreetSuffixName1
StreetSuffixName2 I_AddrOrgNamePostalAddress StreetSuffixName2
HouseNumber I_AddrOrgNamePostalAddress HouseNumber
HouseNumberSupplementText I_AddrOrgNamePostalAddress HouseNumberSupplementText
Building I_AddrOrgNamePostalAddress Building
Floor I_AddrOrgNamePostalAddress Floor
RoomNumber I_AddrOrgNamePostalAddress RoomNumber
Country I_AddrOrgNamePostalAddress Country
Region I_AddrOrgNamePostalAddress Region
CareOfName I_AddrOrgNamePostalAddress CareOfName
FormOfAddress I_AddrOrgNamePostalAddress FormOfAddress
AddresseeName1 I_AddrOrgNamePostalAddress AddresseeName1
AddresseeName2 I_AddrOrgNamePostalAddress AddresseeName2
AddresseeName3 I_AddrOrgNamePostalAddress AddresseeName3
AddresseeName4 I_AddrOrgNamePostalAddress AddresseeName4
TaxJurisdiction I_AddrOrgNamePostalAddress TaxJurisdiction
TransportZone I_AddrOrgNamePostalAddress TransportZone
DeliveryServiceTypeCode I_AddrOrgNamePostalAddress DeliveryServiceTypeCode
DeliveryServiceNumber I_AddrOrgNamePostalAddress DeliveryServiceNumber
AddressTimeZone I_AddrOrgNamePostalAddress AddressTimeZone
SecondaryRegion I_AddrOrgNamePostalAddress SecondaryRegion
SecondaryRegionName I_AddrOrgNamePostalAddress SecondaryRegionName
TertiaryRegion I_AddrOrgNamePostalAddress TertiaryRegion
TertiaryRegionName I_AddrOrgNamePostalAddress TertiaryRegionName
AddressSearchTerm1 I_AddrOrgNamePostalAddress AddressSearchTerm1
AddressSearchTerm2 I_AddrOrgNamePostalAddress AddressSearchTerm2
RegionalStructureCheckStatus I_AddrOrgNamePostalAddress RegionalStructureCheckStatus
AddressGroup I_AddrOrgNamePostalAddress AddressGroup
_Country I_AddrOrgNamePostalAddress _Country
_FormOfAddress I_AddrOrgNamePostalAddress _FormOfAddress
_Region I_AddrOrgNamePostalAddress _Region
_TransportationZone I_AddrOrgNamePostalAddress _TransportationZone
_DfltRprstnPostalAddress _DfltRprstnPostalAddress 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_Region', '_Country', '_FormOfAddress', '_TransportationZone']
@Analytics.dataCategory: #DIMENSION
@EndUserText.label: 'Dflt Addr Rprstn for Org and Postal'
@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_OrgNamePostlAddrDfltRprstn 
     as select from I_AddrOrgNamePostalAddress as PostalAddress
     association [0..*] to I_AddrOrgNamePostalAddress as _DfltRprstnPostalAddress on $projection.AddressID = _DfltRprstnPostalAddress.AddressID
                                                                                  and _DfltRprstnPostalAddress.AddressRepresentationCode is not initial
{
 key PostalAddress.AddressID,
  PostalAddress.AddressRepresentationCode,
  PostalAddress.AddressIsPersonAddress,
  PostalAddress.CorrespondenceLanguage,
  PostalAddress.PrfrdCommMediumType,
  PostalAddress.CityNumber,
  PostalAddress.CityName,
  PostalAddress.DistrictName,
  PostalAddress.VillageName,
  PostalAddress.PostalCode,
  PostalAddress.CompanyPostalCode,
  PostalAddress.POBox,
  @EndUserText.label: 'PO Box Address Non-Deliverable Reason'
  PostalAddress.POBoxAddrNonDeliverableReason,
  PostalAddress.POBoxIsWithoutNumber,
  PostalAddress.POBoxPostalCode,
  PostalAddress.POBoxLobbyName,
  PostalAddress.POBoxDeviatingCityName,
  PostalAddress.POBoxDeviatingCityCode,
  PostalAddress.POBoxDeviatingRegion,
  PostalAddress.POBoxDeviatingCountry,
  PostalAddress.Street,
  PostalAddress.StreetName,
  @EndUserText.label: 'Street Address Non-Deliverable Reason'
  PostalAddress.StreetAddrNonDeliverableReason,
  PostalAddress.StreetPrefixName1,
  PostalAddress.StreetPrefixName2,
  PostalAddress.StreetSuffixName1,
  PostalAddress.StreetSuffixName2,
  PostalAddress.HouseNumber,
  PostalAddress.HouseNumberSupplementText,
  PostalAddress.Building,
  PostalAddress.Floor,
  PostalAddress.RoomNumber,
  @ObjectModel.foreignKey.association: '_Country'  
  PostalAddress.Country,
  PostalAddress.Region,
  PostalAddress.CareOfName,
  @ObjectModel.foreignKey.association: '_FormOfAddress' 
  PostalAddress.FormOfAddress,
  PostalAddress.AddresseeName1,
  PostalAddress.AddresseeName2,
  PostalAddress.AddresseeName3,
  PostalAddress.AddresseeName4,
  PostalAddress.TaxJurisdiction,
  @ObjectModel.foreignKey.association: '_TransportationZone'  
  PostalAddress.TransportZone,
  PostalAddress.DeliveryServiceTypeCode,
  PostalAddress.DeliveryServiceNumber,
  PostalAddress.AddressTimeZone,
  PostalAddress.SecondaryRegion,
  PostalAddress.SecondaryRegionName,
  PostalAddress.TertiaryRegion,
  PostalAddress.TertiaryRegionName,
  PostalAddress.AddressSearchTerm1,
  PostalAddress.AddressSearchTerm2,
  PostalAddress.RegionalStructureCheckStatus,
  PostalAddress.AddressGroup,
  PostalAddress._Country,
  PostalAddress._FormOfAddress,
  PostalAddress._Region,
  PostalAddress._TransportationZone,
  _DfltRprstnPostalAddress
}
where
  AddressRepresentationCode is initial

Learn More