C_BPAddrDepdntIntlLocNumber

DDL: C_BPADDRDEPDNTINTLLOCNUMBER SQL: CBUPADDRILN Type: view CONSUMPTION

Addr Dep InterLocNum

C_BPAddrDepdntIntlLocNumber is a Consumption CDS View that provides data about "Addr Dep InterLocNum" in SAP S/4HANA. It reads from 1 data source (I_BPAddrDepdntIntlLocNumberTP) and exposes 12 fields with key fields BusinessPartner, AddressID. It has 3 associations to related views.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_BPAddrDepdntIntlLocNumberTP BusinessPartnerAddrDepILN from

Associations (3)

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

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CBUPADDRILN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Addr Dep InterLocNum 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 Address-Dependent Organizational Data view
UI.headerInfo.typeNamePlural Address-Dependent Organizational Data view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BPAddrDepdntIntlLocNumberTP BusinessPartner
KEY AddressID I_BPAddrDepdntIntlLocNumberTP AddressID
InternationalLocationNumber1 I_BPAddrDepdntIntlLocNumberTP InternationalLocationNumber1
InternationalLocationNumber2 I_BPAddrDepdntIntlLocNumberTP InternationalLocationNumber2
InternationalLocationNumber3 I_BPAddrDepdntIntlLocNumberTP InternationalLocationNumber3
AuthorizationGroup I_BPAddrDepdntIntlLocNumberTP AuthorizationGroup
BusinessPartnerForEdit I_BPAddrDepdntIntlLocNumberTP BusinessPartnerForEdit
AddressIDForEdit I_BPAddrDepdntIntlLocNumberTP AddressIDForEdit
FormattedAddress I_BPAddrDepdntIntlLocNumberTP FormattedAddress
_BusinessPartner _BusinessPartner
_BusinessPartnerCustomer _BusinessPartnerCustomer
_BusinessPartnerSupplier _BusinessPartnerSupplier 
@AbapCatalog.sqlViewName: 'CBUPADDRILN'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Addr Dep InterLocNum'

@Metadata.allowExtensions: true
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@UI.headerInfo:{
  typeName: 'Address-Dependent Organizational Data',
  typeNamePlural: 'Address-Dependent Organizational Data' }

@Search.searchable: true
@VDM.viewType: #CONSUMPTION

define view C_BPAddrDepdntIntlLocNumber
  as select from I_BPAddrDepdntIntlLocNumberTP as BusinessPartnerAddrDepILN
  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
  association [1..1] to C_BusinessPartnerSupplier as _BusinessPartnerSupplier on $projection.BusinessPartner = _BusinessPartnerSupplier.BusinessPartner
  
{
  key BusinessPartnerAddrDepILN.BusinessPartner,
  key BusinessPartnerAddrDepILN.AddressID,
      BusinessPartnerAddrDepILN.InternationalLocationNumber1,
      BusinessPartnerAddrDepILN.InternationalLocationNumber2,
      BusinessPartnerAddrDepILN.InternationalLocationNumber3,
      BusinessPartnerAddrDepILN.AuthorizationGroup,
      BusinessPartnerAddrDepILN.BusinessPartnerForEdit,
      BusinessPartnerAddrDepILN.AddressIDForEdit,
      BusinessPartnerAddrDepILN.FormattedAddress,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BusinessPartner, 
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomer,
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT ]
      _BusinessPartnerSupplier
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPADDRDEPDNTINTLLOCNUMBERTP"
],
"ASSOCIATED":
[
"C_BUSINESSPARTNER",
"C_BUSINESSPARTNERCUSTOMER",
"C_BUSINESSPARTNERSUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More