A_CustAddrDepdntInformation

DDL: A_CUSTADDRDEPDNTINFORMATION SQL: ACUSTADDRDEPDNT Type: view BASIC

Customer Address Dependent Infomation

A_CustAddrDepdntInformation is a Basic CDS View that provides data about "Customer Address Dependent Infomation" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntInformation) and exposes 7 fields with key fields Customer, AddressID. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntInformation I_CustAddrDepdntInformation from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] E_CustAddrDepdntInformation _CustAddrDepdntInformationExt $projection.Customer = _CustAddrDepdntInformationExt.Customer and $projection.AddressID = _CustAddrDepdntInformationExt.AddressID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACUSTADDRDEPDNT view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Customer Address Dependent Infomation view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Customer Customer
KEY AddressID AddressID
ExpressTrainStationName ExpressTrainStationName
TrainStationName TrainStationName
CityCode CityCode
County County
_Customer _Customer 
@AbapCatalog.sqlViewName: 'ACUSTADDRDEPDNT'
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY
@AbapCatalog.compiler.compareFilter: true
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Customer Address Dependent Infomation'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true 
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_CustAddrDepdntInformation as select from I_CustAddrDepdntInformation

  association [1..1] to A_Customer as _Customer on $projection.Customer = _Customer.Customer
  
  association [0..1] to E_CustAddrDepdntInformation as _CustAddrDepdntInformationExt on  $projection.Customer = _CustAddrDepdntInformationExt.Customer 
                                                                                     and $projection.AddressID = _CustAddrDepdntInformationExt.AddressID
{
  key Customer,
  key AddressID,
  ExpressTrainStationName, 
  TrainStationName,
  CityCode,
  County,
  _Customer
}

Learn More