A_BuPaAddressUsage

DDL: A_BUPAADDRESSUSAGE SQL: ABPADDRESSUSAGE Type: view BASIC

Address Usage

A_BuPaAddressUsage is a Basic CDS View that provides data about "Address Usage" in SAP S/4HANA. It reads from 1 data source (I_Businesspartneraddressusage) and exposes 8 fields with key fields BusinessPartner, ValidityEndDate, AddressUsage, AddressID.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Businesspartneraddressusage I_Businesspartneraddressusage from

Annotations (15)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
KEY ValidityEndDate ValidityEndDate
KEY AddressUsage AddressUsage
KEY AddressID AddressNumber
ValidityStartDate ValidityStartDate
StandardUsage StandardUsage
_BusinessPartner _BusinessPartner
AuthorizationGroup AuthorizationGroup 
@AbapCatalog.sqlViewName: 'ABPADDRESSUSAGE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Address Usage'
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@ObjectModel.deleteEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BuPaAddressUsage as select from I_Businesspartneraddressusage 

  association[0..1] to A_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
  
{
  key BusinessPartner, 
  key ValidityEndDate, 
  key AddressUsage, 
  key AddressNumber as AddressID, 
      ValidityStartDate, 
      StandardUsage,
      _BusinessPartner,
      AuthorizationGroup
}

Learn More