C_PurchasingDeliveryAddressVH

DDL: C_PURCHASINGDELIVERYADDRESSVH SQL: CPURDELADDRVH Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2

Master Delivery Addresses

C_PurchasingDeliveryAddressVH is a Consumption CDS View that provides data about "Master Delivery Addresses" in SAP S/4HANA. It reads from 1 data source (I_OrganizationAddress) and exposes 16 fields with key field AddressID. It has 1 association to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_OrganizationAddress I_OrganizationAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_AddressGroupText _AddressGroupText $projection.AddressGroup = _AddressGroupText.AddressGroup

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CPURDELADDRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey AddressID view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
EndUserText.label Master Delivery Addresses view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AddressID I_OrganizationAddress AddressID
AddressGroup I_OrganizationAddress AddressGroup Address Group
AddressGroupName
AddresseeFullName I_OrganizationAddress AddresseeFullName
AddresseeName1 I_OrganizationAddress AddresseeName1
AddresseeName2 I_OrganizationAddress AddresseeName2
CityName I_OrganizationAddress CityName
StreetName I_OrganizationAddress StreetName
Region I_OrganizationAddress Region
Country I_OrganizationAddress Country
PostalCode I_OrganizationAddress PostalCode
HouseNumber I_OrganizationAddress HouseNumber
AddressSearchTerm1 I_OrganizationAddress AddressSearchTerm1
AddressSearchTerm2 I_OrganizationAddress AddressSearchTerm2
_AddressGroup _AddressGroup
_AddressGroupText _AddressGroupText 
@AbapCatalog.sqlViewName: 'CPURDELADDRVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@VDM.viewType: #CONSUMPTION

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'AddressID'

@ObjectModel.modelingPattern:#NONE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@Search.searchable: true
@Consumption.ranked: true

@ObjectModel.text.control: #ASSOCIATED_TEXT_UI_HIDDEN
@EndUserText.label: 'Master Delivery Addresses'

define view C_PurchasingDeliveryAddressVH
  as select from I_OrganizationAddress
    
association [0..*] to I_AddressGroupText                as _AddressGroupText                  on  $projection.AddressGroup = _AddressGroupText.AddressGroup
     
{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key I_OrganizationAddress.AddressID,
      @EndUserText.label: 'Address Group'
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element: ['AddressGroupName']
//      @ObjectModel.text.association: '_AddressGroupText'

      I_OrganizationAddress.AddressGroup,
        
      @Semantics.text:true  
      @Consumption.filter.hidden: true
      _AddressGroupText[1:Language=$session.system_language].AddressGroupName,
      
      I_OrganizationAddress.AddresseeFullName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.AddresseeName1,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.AddresseeName2,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.CityName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.StreetName,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.Region,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.Country,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.PostalCode,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      I_OrganizationAddress.HouseNumber,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      I_OrganizationAddress.AddressSearchTerm1,
      
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #MEDIUM
      I_OrganizationAddress.AddressSearchTerm2,
      
      _AddressGroup,
      _AddressGroupText
      
   
      
      
      
} where ( AddressGroup = 'ME01' 
     or AddressGroup = 'BP' 
     or AddressGroup = 'CA01'
     or AddressGroup = 'ME02'
     or AddressGroup = 'ME03'
     or AddressGroup = 'PM01'
     or AddressGroup = 'PS02'
     or AddressGroup = 'PSL2'
     or AddressGroup = 'SCTM' )
and AddressRepresentationCode = ' '
and AddressPersonID = ' '

Learn More