C_CustAddrDepdntExtIdentifier

DDL: C_CUSTADDRDEPDNTEXTIDENTIFIER SQL: CADDRDEXTID Type: view CONSUMPTION

Consumption view for External Identifier

C_CustAddrDepdntExtIdentifier is a Consumption CDS View that provides data about "Consumption view for External Identifier" in SAP S/4HANA. It reads from 1 data source (I_CustAddrDepdntIdentifierTP) and exposes 12 fields with key fields Customer, BusinessPartner, AddressID. It has 2 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_CustAddrDepdntIdentifierTP CustAddrDepdntExtIdentifier from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] C_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CADDRDEXTID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for External Identifier view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName Seller-Defined Customer Address IDs for EDI view
UI.headerInfo.typeNamePlural Seller-Defined Customer Address IDs for EDI view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustAddrDepdntIdentifierTP Customer
KEY BusinessPartner I_CustAddrDepdntIdentifierTP BusinessPartner
KEY AddressID I_CustAddrDepdntIdentifierTP AddressID
CustomerExternalRefID I_CustAddrDepdntIdentifierTP CustomerExternalRefID
CustomerForEdit I_CustAddrDepdntIdentifierTP CustomerForEdit
AddressIDForEdit
FormattedAddress I_CustAddrDepdntIdentifierTP FormattedAddress
BusinessPartnerForEdit I_CustAddrDepdntIdentifierTP BusinessPartnerForEdit
BusinessPartnerUUID I_CustAddrDepdntIdentifierTP BusinessPartnerUUID
_Customer _Customer
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer 
@AbapCatalog.sqlViewName: 'CADDRDEXTID'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption view for External Identifier'
@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    semanticKey: ['BusinessPartner', 'AddressIDForEdit', 'Customer'],
    createEnabled,
    updateEnabled,
    deleteEnabled
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@UI.headerInfo:{
  typeName: 'Seller-Defined Customer Address IDs for EDI',
  typeNamePlural: 'Seller-Defined Customer Address IDs for EDI' }

//@Search.searchable: true

@VDM.viewType: #CONSUMPTION
define view C_CustAddrDepdntExtIdentifier as select from I_CustAddrDepdntIdentifierTP as CustAddrDepdntExtIdentifier
  association [1..1] to C_BusinessPartner         as _BusinessPartner         on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  association [1..1] to C_BusinessPartnerCustomer as _BusinessPartnerCustomer on $projection.BusinessPartner = _BusinessPartnerCustomer.BusinessPartner
{
  key CustAddrDepdntExtIdentifier.Customer,
  key CustAddrDepdntExtIdentifier.BusinessPartner,
  key CustAddrDepdntExtIdentifier.AddressID,
      CustAddrDepdntExtIdentifier.CustomerExternalRefID,
      CustAddrDepdntExtIdentifier.CustomerForEdit,
      @ObjectModel.readOnly: true
      cast(CustAddrDepdntExtIdentifier.AddressIDForEdit as char10) as AddressIDForEdit,
      CustAddrDepdntExtIdentifier.FormattedAddress,
      CustAddrDepdntExtIdentifier.BusinessPartnerForEdit,
      CustAddrDepdntExtIdentifier.BusinessPartnerUUID,
      /* Associations */
      _Customer,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTADDRDEPDNTIDENTIFIERTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"I_CUSTOMER"
],
"BASE":
[
"I_CUSTADDRDEPDNTIDENTIFIERTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More