A_CustAddrDepdntExtIdentifier

DDL: A_CUSTADDRDEPDNTEXTIDENTIFIER SQL: ACUSTADDREXTID Type: view BASIC

Customer Address Dependent External Identifier

A_CustAddrDepdntExtIdentifier is a Basic CDS View that provides data about "Customer Address Dependent External Identifier" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntExtIdentifier) and exposes 4 fields with key fields Customer, AddressID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntExtIdentifier I_CustAddrDepdntExtIdentifier from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ACUSTADDREXTID view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API 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
EndUserText.label Customer Address Dependent External Identifier view

Fields (4)

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

define view A_CustAddrDepdntExtIdentifier as select from I_CustAddrDepdntExtIdentifier

  association [1..1] to A_Customer as _Customer on $projection.Customer = _Customer.Customer
  
{
  key Customer,
  key AddressID,
  CustomerExternalRefID,
  _Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTADDRDEPDNTEXTIDENTIFIER"
],
"ASSOCIATED":
[
"A_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/