I_BUSINESSPARTNERADDRESSUSAGE

CDS View

Busineess Partner Address Usage Core View

I_BUSINESSPARTNERADDRESSUSAGE is a CDS View in S/4HANA. Busineess Partner Address Usage Core View. It contains 6 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 6 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_BuPaAddressUsage view from BASIC Address Usage
C_PurgCustomerBPShipToAddrVH view inner CONSUMPTION Customer Ship to Addresses
I_BusinessPartnerAddrUsageTP view from TRANSACTIONAL Business Partner Address Usage BOPF View
I_BusinessPartnerAddrUsageTP_2 view_entity from TRANSACTIONAL Business Partner Addresses Usages
I_BusPartAddressUsageGov view union_all COMPOSITE Basic view for BP address usage
P_BPCurrentDefaultAddress_2 view from COMPOSITE XXDEFAULT Addr Valid in Current Timestamp
P_BPNextDefaultAddress_2 view from COMPOSITE XXDEFAULT Addr Valid in Nearest Future
P_BPPreviousDefaultAddress_2 view from COMPOSITE XXDEFAULT Addr Valid in Recent Past
P_CAContrPartCurDefaultAddress view from CONSUMPTION Contract Partner Current Default Address
P_KR_WhldgInhabitanttxitm view_entity left_outer COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY AddressNumber AddressNumber,AddressNumberForEdit,BusinessPartnerAddressID 2
KEY AddressUsage AddressUsage,AddressUsageForEdit 3
KEY BusinessPartner BusinessPartner,BusinessPartnerForEdit 1
StandardUsage StandardUsage 2
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 1 
@AbapCatalog.sqlViewName: 'IBPADDRESSUSAGE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
@EndUserText.label: 'Busineess Partner Address Usage Core View'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view I_Businesspartneraddressusage as select from but021_fs 

association[1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{
    key but021_fs.partner   as BusinessPartner,
    key but021_fs.valid_to  as ValidityEndDate, 
    key but021_fs.adr_kind  as AddressUsage, 
    key but021_fs.addrnumber as AddressNumber, 
    but021_fs.valid_from    as ValidityStartDate, 
    but021_fs.xdfadu as StandardUsage,
    _BusinessPartner.AuthorizationGroup,
    _BusinessPartner
}          
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"BUT021_FS"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More