I_CUSTADDRDEPDNTEXTIDENTIFIER

CDS View

Customer External Identifier for Address

I_CUSTADDRDEPDNTEXTIDENTIFIER is a CDS View in S/4HANA. Customer External Identifier for Address. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CustAddrDepdntExtIdentifier view from BASIC Customer Address Dependent External Identifier
I_CustAddrDepdntIdentifierTP view from TRANSACTIONAL TP view of I_CustAddrDepdntExtIdentifier

Fields (3)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressIDForEdit 1
KEY Customer Customer,CustomerForEdit 1
CustomerExternalRefID CustomerExternalRefID 1 
@AbapCatalog.sqlViewName: 'ICUSTADDREXTID'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.privilegedAssociations: ['_AddressDefaultRepresentation']
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.representativeKey: 'AddressID'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@EndUserText.label: 'Customer External Identifier for Address'

define view I_CustAddrDepdntExtIdentifier
  as select from knaddr_ext
  association [1..1] to I_Customer                as _Customer                     on  $projection.Customer = _Customer.Customer
  association [1..1] to I_Address_2               as _AddressDefaultRepresentation on  $projection.AddressID                                   = _AddressDefaultRepresentation.AddressID
                                                                                   and _AddressDefaultRepresentation.AddressRepresentationCode = ' '
  association [1..1] to I_BusinessPartnerCustomer as _BusinessPartnerCustomer      on  $projection.Customer = _BusinessPartnerCustomer.Customer
{
      @ObjectModel.foreignKey.association: '_Customer'
  key knaddr_ext.kunnr      as Customer,
  key knaddr_ext.adrnr      as AddressID,
      knaddr_ext.ext_ref_id as CustomerExternalRefID,
      _BusinessPartnerCustomer,
      _Customer,
      _AddressDefaultRepresentation
}

Learn More