P_BPPROTECTEDADDRUSAGECOUNT

CDS View

P_BPPROTECTEDADDRUSAGECOUNT is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPProtectedAddress view from COMPOSITE Business Partner Protected Addresses 
@AbapCatalog.sqlViewName: 'PBPPROADRUC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #REQUIRED
define view P_BPProtectedAddrUsageCount 
//as select from but020

as select from but021_fs
     //left outer join but021_fs on but020.partner   =  but021_fs.partner

                      //      and but020.addrnumber  =  but021_fs.addrnumber

                        //    and but020.nation      =  ' '

                            
     left outer join tb008u on tb008u.adr_kind = but021_fs.adr_kind
     left outer join tb008s on tb008s.operation = tb008u.operation
{
  key but021_fs.partner         as BusinessPartner,
  key but021_fs.addrnumber      as AddressID,
  sum(case when tb008s.protect = 'X' then 1 else 0 end) as BPProtectedAddrUsageCount
}
group by but021_fs.partner, but021_fs.addrnumber
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BUT021_FS",
"TB008S",
"TB008U"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More