Arun_Po_Ralloc

DDL: ARUN_PO_RALLOC SQL: ARUN_V_PO_RALLOC Type: view

Requirement Allocated Qty of STO/RPO

Arun_Po_Ralloc is a CDS View that provides data about "Requirement Allocated Qty of STO/RPO" in SAP S/4HANA. It reads from 1 data source (arun_bdbs) and exposes 4 fields with key fields mandt, purchdoc_num.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
arun_bdbs arun_bdbs from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_PO_RALLOC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Requirement Allocated Qty of STO/RPO view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY purchdoc_num purchdoc_num
req_ind req_ind
alloc_qty 
@AbapCatalog.sqlViewName: 'ARUN_V_PO_RALLOC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Requirement Allocated Qty of STO/RPO'
define view Arun_Po_Ralloc
  as select from arun_bdbs
{
  key mandt,
  key purchdoc_num,
  key purchdoc_item,
  key requested_date,
  key material_avail_date,
      req_ind,
      sum(alloc_qty)  as alloc_qty
}
where arun_mode = '1'
group by
  mandt,
  purchdoc_num,
  purchdoc_item,
  requested_date,
  material_avail_date,
  req_ind
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARUN_BDBS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More