C_EnvrmtWastePartnerDfltAddr

DDL: C_ENVRMTWASTEPARTNERDFLTADDR Type: view CONSUMPTION

Waste Partner Default Address

C_EnvrmtWastePartnerDfltAddr is a Consumption CDS View that provides data about "Waste Partner Default Address" in SAP S/4HANA. It reads from 1 data source (I_BPCurrentDefaultAddress) and exposes 9 fields with key field BusinessPartner. It has 1 association to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCurrentDefaultAddress BPDefaultAddress from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressNumber = _BusinessPartnerAddress.AddressNumber

Annotations (12)

NameValueLevelField
EndUserText.label Waste Partner Default Address view
AbapCatalog.sqlViewName CEWSTPRTNRADR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPCurrentDefaultAddress BusinessPartner
AddressNumber I_BPCurrentDefaultAddress AddressID
HouseNumber _BusinessPartnerAddress HouseNumber
StreetName _BusinessPartnerAddress StreetName
CityName _BusinessPartnerAddress CityName
Country _BusinessPartnerAddress Country
PostalCode _BusinessPartnerAddress PostalCode
PostalCode11endasCompleteAddress
_BusinessPartnerAddress _BusinessPartnerAddress 
@EndUserText.label: 'Waste Partner Default Address'

@AbapCatalog:
{
 sqlViewName: 'CEWSTPRTNRADR',
 compiler.compareFilter: true,
 preserveKey: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  personalData.blocking: #REQUIRED
}

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  representativeKey:  'BusinessPartner',
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #D
  }
}

@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_EnvrmtWastePartnerDfltAddr
  as select from I_BPCurrentDefaultAddress as BPDefaultAddress

  association [0..1] to I_BusinessPartnerAddress as _BusinessPartnerAddress on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                            and $projection.AddressNumber   = _BusinessPartnerAddress.AddressNumber
{
  key BPDefaultAddress.BusinessPartner    as BusinessPartner,
      BPDefaultAddress.AddressID          as AddressNumber,
      _BusinessPartnerAddress.HouseNumber as HouseNumber,
      _BusinessPartnerAddress.StreetName  as StreetName,
      _BusinessPartnerAddress.CityName    as CityName,
      _BusinessPartnerAddress.Country     as Country,
      _BusinessPartnerAddress.PostalCode  as PostalCode,
      case
       when _BusinessPartnerAddress.HouseNumber = '' and _BusinessPartnerAddress.StreetName = '' and _BusinessPartnerAddress.CityName = ''
         then concat_with_space(_BusinessPartnerAddress.Country,_BusinessPartnerAddress.PostalCode,1)
       when _BusinessPartnerAddress.HouseNumber = '' and _BusinessPartnerAddress.StreetName = ''
         then concat_with_space(concat(_BusinessPartnerAddress.CityName, ','), concat_with_space(_BusinessPartnerAddress.Country,_BusinessPartnerAddress.PostalCode,1), 1)
       else
         concat_with_space(concat(concat_with_space(concat_with_space(concat_with_space(_BusinessPartnerAddress.HouseNumber,_BusinessPartnerAddress.StreetName,1),',',1),_BusinessPartnerAddress.CityName,1),','),concat_with_space(_BusinessPartnerAddress.Country,_BusinessPartnerAddress.PostalCode,1),1)
      end                                 as CompleteAddress,


      //      case

      //      when _BusinessPartnerAddress.AddressNumber is not null

      //      then concat_with_space

      //        ( (concat_with_space

      //         (concat_with_space(_BusinessPartnerAddress.HouseNumber,_BusinessPartnerAddress.StreetName,1),

      //         _BusinessPartnerAddress.CityName,1)

      //         ),

      //         concat_with_space(_BusinessPartnerAddress.Country,_BusinessPartnerAddress.PostalCode,1), 1)

      //       end  as CompleteAddress,

      //



      //association

      _BusinessPartnerAddress
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNERADDRESS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERADDRESS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More