I_CustAddrDepdntIdentifierTP

DDL: I_CUSTADDRDEPDNTIDENTIFIERTP SQL: IADDREXTIDTP Type: view TRANSACTIONAL Package: VDM_MD_BP

TP view of I_CustAddrDepdntExtIdentifier

I_CustAddrDepdntIdentifierTP is a Transactional CDS View that provides data about "TP view of I_CustAddrDepdntExtIdentifier" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntExtIdentifier) and exposes 11 fields with key fields Customer, BusinessPartner, AddressID. It has 1 association to related views. Part of development package VDM_MD_BP.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntExtIdentifier CustAddrDepdntExtIdentifier from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartnerTP _BusinessPartner $projection.businesspartner = _BusinessPartner.BusinessPartner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IADDREXTIDTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP view of I_CustAddrDepdntExtIdentifier view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.writeDraftPersistence ADDREXTID_D view
ObjectModel.draftEnabled true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustAddrDepdntExtIdentifier Customer
KEY BusinessPartner
KEY AddressID I_CustAddrDepdntExtIdentifier AddressID
CustomerExternalRefID I_CustAddrDepdntExtIdentifier CustomerExternalRefID
CustomerForEdit I_CustAddrDepdntExtIdentifier Customer
AddressIDForEdit I_CustAddrDepdntExtIdentifier AddressID
FormattedAddress
BusinessPartnerForEdit
BusinessPartnerUUID
_Customer _Customer
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'IADDREXTIDTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP view of I_CustAddrDepdntExtIdentifier'
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL

@ObjectModel.writeDraftPersistence: 'ADDREXTID_D'
@ObjectModel.semanticKey: ['BusinessPartner', 'AddressID', 'Customer']
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled
@ObjectModel.updateEnabled
@ObjectModel.deleteEnabled
@Search.searchable: true

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view I_CustAddrDepdntIdentifierTP as select from I_CustAddrDepdntExtIdentifier as CustAddrDepdntExtIdentifier
  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.businesspartner = _BusinessPartner.BusinessPartner
{
  key CustAddrDepdntExtIdentifier.Customer,
  key CustAddrDepdntExtIdentifier._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
  key CustAddrDepdntExtIdentifier.AddressID,
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustAddrDepdntExtIdentifier.CustomerExternalRefID,

      CustAddrDepdntExtIdentifier.Customer  as CustomerForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      CustAddrDepdntExtIdentifier.AddressID as AddressIDForEdit,
      
      cast( '                                           ' as  abap.sstring( 260 ) )                       as FormattedAddress,
       
      CustAddrDepdntExtIdentifier._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
      
      CustAddrDepdntExtIdentifier._Customer._CustomerToBusinessPartner.BusinessPartnerUUID,
      /* Associations */
      _Customer,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner
      }

Learn More