P_Emplprivpostaddr

DDL: P_EMPLPRIVPOSTADDR SQL: PEMPLPRVPOSTADDR Type: view BASIC

P_Emplprivpostaddr is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (adrc) and exposes 17 fields with key field AddressID. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
adrc postaladdress from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[0..1] I_Country _Country $projection.Country = _Country.Country

Annotations (3)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PEMPLPRVPOSTADDR view
VDM.viewType #BASIC view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY AddressID adrc addrnumber
Country adrc country
Region adrc region
CityName adrc city1
HomeCityName adrc home_city
District adrc city2
PostalCode adrc post_code1
StreetName adrc street
StreetPrefixName adrc str_suppl1
StreetSuffixName adrc str_suppl3
AdditionalStreetPrefixName adrc str_suppl2
AdditionalStreetSuffixName adrc location
HouseNumber adrc house_num1
HouseNumberSupplementText adrc house_num2
CareOfName adrc name_co
_Region _Region
_Country _Country 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PEMPLPRVPOSTADDR'
@VDM.viewType: #BASIC
define view P_Emplprivpostaddr 
as select from adrc as postaladdress

association [0..1] to I_Region as _Region 
  on $projection.Region = _Region.Region and 
     $projection.Country = _Region.Country
     
association [0..1] to I_Country as _Country
  on $projection.Country = _Country.Country 


{

key postaladdress.addrnumber as AddressID,
    postaladdress.country    as Country,
    postaladdress.region     as Region,    
    postaladdress.city1      as CityName,
    postaladdress.home_city  as HomeCityName,
    postaladdress.city2      as District,
    postaladdress.post_code1 as PostalCode,
    postaladdress.street     as StreetName,
    postaladdress.str_suppl1 as StreetPrefixName,
    postaladdress.str_suppl3 as StreetSuffixName,
    postaladdress.str_suppl2 as AdditionalStreetPrefixName,
    postaladdress.location   as AdditionalStreetSuffixName,
    postaladdress.house_num1 as HouseNumber,
    postaladdress.house_num2 as HouseNumberSupplementText,
    postaladdress.name_co    as CareOfName,
    
    _Region,
    _Country
  
}                  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ADRC"
],
"ASSOCIATED":
[
"I_COUNTRY",
"I_REGION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More