P_EWM_Address

DDL: P_EWM_ADDRESS Type: view_entity COMPOSITE Package: VDM_EWM_CORE

Helper Reduced Organisation Address

P_EWM_Address is a Composite CDS View that provides data about "Helper Reduced Organisation Address" in SAP S/4HANA. It reads from 1 data source (I_AddrOrgNamePostalAddress) and exposes 8 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode. Part of development package VDM_EWM_CORE.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_AddrOrgNamePostalAddress I_AddrOrgNamePostalAddress from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AddressID AddressID
KEY AddressPersonID
KEY AddressRepresentationCode AddressRepresentationCode
AddresseeFullName
OrganizationName1 AddresseeName1
OrganizationName2 AddresseeName2
OrganizationName3 AddresseeName3
OrganizationName4 AddresseeName4 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_EWM_Address
  as select from I_AddrOrgNamePostalAddress                                                                            
{
  /* This view is intended to replace I_ADDRESS_2 view to improve performance */
  /* only Organisation Address are selected */
  key AddressID,
  key cast('' as ad_persnum ) as AddressPersonID,
  key AddressRepresentationCode,
  cast(concat_with_space(AddresseeName1, AddresseeName2, 1) as ad_namtext ) as AddresseeFullName,
  AddresseeName1          as OrganizationName1,
  AddresseeName2          as OrganizationName2,
  AddresseeName3          as OrganizationName3,
  AddresseeName4          as OrganizationName4           
}

Learn More