A_BPAddrDepdntIntlLocNumber

DDL: A_BPADDRDEPDNTINTLLOCNUMBER SQL: ABUPADDRILN Type: view BASIC Package: ODATA_MASTER_DATA_BP

Business Partner Address-Dependent ILN

A_BPAddrDepdntIntlLocNumber is a Basic CDS View that provides data about "Business Partner Address-Dependent ILN" in SAP S/4HANA. It reads from 1 data source (I_BPAddrDepdntIntlLocNumber) and exposes 7 fields with key fields BusinessPartner, AddressID. It has 2 associations to related views. Part of development package ODATA_MASTER_DATA_BP.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_BPAddrDepdntIntlLocNumber I_BPAddrDepdntIntlLocNumber from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[1..1] A_BusinessPartnerAddress _BusinessPartnerAddress $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner and $projection.AddressID = _BusinessPartnerAddress.AddressID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName ABUPADDRILN view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
EndUserText.label Business Partner Address-Dependent ILN view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY AddressID AddressID
InternationalLocationNumber1 InternationalLocationNumber1
InternationalLocationNumber2 InternationalLocationNumber2
InternationalLocationNumber3 InternationalLocationNumber3
_BusinessPartner _BusinessPartner
_BusinessPartnerAddress _BusinessPartnerAddress 
@AbapCatalog.sqlViewName: 'ABUPADDRILN'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm : #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@EndUserText.label: 'Business Partner Address-Dependent ILN'
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view A_BPAddrDepdntIntlLocNumber as select from I_BPAddrDepdntIntlLocNumber

  association [1..1] to A_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
  association [1..1] to A_BusinessPartnerAddress as _BusinessPartnerAddress on  $projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner
                                                                            and $projection.AddressID = _BusinessPartnerAddress.AddressID
              
{
  key BusinessPartner,
  key AddressID,
      InternationalLocationNumber1,
      InternationalLocationNumber2,
      InternationalLocationNumber3,
      _BusinessPartner,
      _BusinessPartnerAddress  
}

Learn More