UPOV_ALC_BASIS_FOR_PRA

CDS View

Allocation Basis for PRA

UPOV_ALC_BASIS_FOR_PRA is a CDS View in S/4HANA. Allocation Basis for PRA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
UPOV_PR_DNVD_UOM view left_outer Delivery Network Variable Data_UOM 
@AbapCatalog.sqlViewName: 'UPOS_PR_ALBAS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Allocation Basis for PRA'
define view UPOV_ALC_BASIS_FOR_PRA
  as select distinct from UPOV_GET_ALLOCATION_BASIS as alloc_basis
    inner join   UPOV_ALC_BASIS_CD_CNT     as basis_cdcnt on  basis_cdcnt.tplnr          = alloc_basis.tplnr
                                                          and basis_cdcnt.effective_from = alloc_basis.effective_from
                                                          and basis_cdcnt.effective_to   = alloc_basis.effective_to
{
  alloc_basis.tplnr,
  alloc_basis.effective_from,
  alloc_basis.effective_to,
  case
  when  basis_cdcnt.al_basis_cdcnt = 1 then alloc_basis.al_basis_cd
  when  basis_cdcnt.al_basis_cdcnt > 1 then 'D'
  end as al_basis_cd
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"UPOV_ALC_BASIS_CD_CNT",
"UPOV_GET_ALLOCATION_BASIS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More