I_PurchasingDeliveryAddressTP

DDL: I_PURCHASINGDELIVERYADDRESSTP SQL: IPURDELADDR Type: view TRANSACTIONAL

Purchasing Delivery Address - TP

I_PurchasingDeliveryAddressTP is a Transactional CDS View that provides data about "Purchasing Delivery Address - TP" in SAP S/4HANA. It reads from 1 data source (I_Address_2) and exposes 68 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_Address_2 Address from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LanguageText _LanguageText _LanguageText.Language = $projection.CorrespondenceLanguage and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPURDELADDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchasing Delivery Address - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_Address_2 AddressID
KEY AddressPersonID I_Address_2 AddressPersonID
KEY AddressRepresentationCode I_Address_2 AddressRepresentationCode
AddressObjectType I_Address_2 AddressObjectType
CorrespondenceLanguage I_Address_2 CorrespondenceLanguage
PrfrdCommMediumType I_Address_2 PrfrdCommMediumType
AddresseeFullName I_Address_2 AddresseeFullName
PersonGivenName I_Address_2 PersonGivenName
PersonFamilyName I_Address_2 PersonFamilyName
OrganizationName1 I_Address_2 OrganizationName1
OrganizationName2 I_Address_2 OrganizationName2
OrganizationName3 I_Address_2 OrganizationName3
OrganizationName4 I_Address_2 OrganizationName4
AddressSearchTerm1 I_Address_2 AddressSearchTerm1
AddressSearchTerm2 I_Address_2 AddressSearchTerm2
CityNumber I_Address_2 CityNumber
CityName I_Address_2 CityName
DistrictName I_Address_2 DistrictName
VillageName I_Address_2 VillageName
PostalCode I_Address_2 PostalCode
CompanyPostalCode I_Address_2 CompanyPostalCode
Street I_Address_2 Street
StreetName I_Address_2 StreetName
StreetAddrNonDeliverableReason I_Address_2 StreetAddrNonDeliverableReason
StreetPrefixName1 I_Address_2 StreetPrefixName1
StreetPrefixName2 I_Address_2 StreetPrefixName2
StreetSuffixName1 I_Address_2 StreetSuffixName1
StreetSuffixName2 I_Address_2 StreetSuffixName2
HouseNumber I_Address_2 HouseNumber
HouseNumberSupplementText I_Address_2 HouseNumberSupplementText
Building I_Address_2 Building
Floor I_Address_2 Floor
RoomNumber I_Address_2 RoomNumber
Country I_Address_2 Country
Region I_Address_2 Region
FormOfAddress I_Address_2 FormOfAddress
TaxJurisdiction I_Address_2 TaxJurisdiction
TransportZone I_Address_2 TransportZone
POBox I_Address_2 POBox
POBoxAddrNonDeliverableReason I_Address_2 POBoxAddrNonDeliverableReason
POBoxIsWithoutNumber I_Address_2 POBoxIsWithoutNumber
POBoxPostalCode I_Address_2 POBoxPostalCode
POBoxLobbyName I_Address_2 POBoxLobbyName
POBoxDeviatingCityName I_Address_2 POBoxDeviatingCityName
POBoxDeviatingRegion I_Address_2 POBoxDeviatingRegion
POBoxDeviatingCountry I_Address_2 POBoxDeviatingCountry
CareOfName I_Address_2 CareOfName
DeliveryServiceTypeCode I_Address_2 DeliveryServiceTypeCode
DeliveryServiceNumber I_Address_2 DeliveryServiceNumber
AddressTimeZone I_Address_2 AddressTimeZone
SecondaryRegion I_Address_2 SecondaryRegion
SecondaryRegionName I_Address_2 SecondaryRegionName
TertiaryRegion I_Address_2 TertiaryRegion
TertiaryRegionName I_Address_2 TertiaryRegionName
RegionalStructureCheckStatus I_Address_2 RegionalStructureCheckStatus
AddressGroup I_Address_2 AddressGroup
_OrganizationAddress _OrganizationAddress
_PersonAddress _PersonAddress
_EmailAddress _EmailAddress
_PhoneNumber _PhoneNumber
_FaxNumber _FaxNumber
_UniformResourceIdentifier _UniformResourceIdentifier
_CurrentDfltEmailAddress _CurrentDfltEmailAddress
_CurrentDfltMobilePhoneNumber _CurrentDfltMobilePhoneNumber
_CurrentDfltLandlinePhoneNmbr _CurrentDfltLandlinePhoneNmbr
_CurrentDfltFaxNumber _CurrentDfltFaxNumber
_MainWebsiteURL _MainWebsiteURL
_LanguageText _LanguageText
@AbapCatalog.sqlViewName: 'IPURDELADDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchasing Delivery Address - TP'

@ObjectModel: { semanticKey: ['AddressID'],
                usageType.dataClass: #TRANSACTIONAL,
                usageType.serviceQuality:  #C,
                usageType.sizeCategory: #L }
                
@Metadata.ignorePropagatedAnnotations: true
                
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

define view I_PurchasingDeliveryAddressTP
  as select from I_Address_2 as Address
  association [0..1] to I_LanguageText as _LanguageText on  _LanguageText.Language     = $projection.CorrespondenceLanguage
                                                        and _LanguageText.LanguageCode = $projection.CorrespondenceLanguage
{


  key Address.AddressID,
  key Address.AddressPersonID,
  key Address.AddressRepresentationCode,
  
  
      Address.AddressObjectType,
      Address.CorrespondenceLanguage,
      Address.PrfrdCommMediumType,
      Address.AddresseeFullName,
      Address.PersonGivenName,
      Address.PersonFamilyName,
      Address.OrganizationName1,
      Address.OrganizationName2,
      Address.OrganizationName3,
      Address.OrganizationName4,
      Address.AddressSearchTerm1,
      Address.AddressSearchTerm2,
      Address.CityNumber,
      Address.CityName,
      Address.DistrictName,
      Address.VillageName,
      Address.PostalCode,
      Address.CompanyPostalCode,
      Address.Street,
      Address.StreetName,
//      @EndUserText.label: 'Street Address Non-Deliverable Reason'

      Address.StreetAddrNonDeliverableReason,
      Address.StreetPrefixName1,
      Address.StreetPrefixName2,
      Address.StreetSuffixName1,
      Address.StreetSuffixName2,
      Address.HouseNumber,
      Address.HouseNumberSupplementText,
      Address.Building,
      Address.Floor,
      Address.RoomNumber,
      Address.Country,
      Address.Region,
      Address.FormOfAddress,
      Address.TaxJurisdiction,
      Address.TransportZone,

      Address.POBox,
//      @EndUserText.label: 'PO Box Address Non-Deliverable Reason'

      Address.POBoxAddrNonDeliverableReason,
      Address.POBoxIsWithoutNumber,
      Address.POBoxPostalCode,
      Address.POBoxLobbyName,
      Address.POBoxDeviatingCityName,
      Address.POBoxDeviatingRegion,
      Address.POBoxDeviatingCountry,

      Address.CareOfName,
      Address.DeliveryServiceTypeCode,
      Address.DeliveryServiceNumber,
      Address.AddressTimeZone,

      Address.SecondaryRegion,
      Address.SecondaryRegionName,
      Address.TertiaryRegion,
      Address.TertiaryRegionName,
      Address.RegionalStructureCheckStatus,
      Address.AddressGroup,

      _OrganizationAddress,
      _PersonAddress,

      _EmailAddress,
      _PhoneNumber,
      _FaxNumber,
      _UniformResourceIdentifier,

      _CurrentDfltEmailAddress,
      _CurrentDfltMobilePhoneNumber,
      _CurrentDfltLandlinePhoneNmbr,
      _CurrentDfltFaxNumber,
      _MainWebsiteURL,
      _LanguageText
}