ARUN_SO_ITEM_QTY

DDL: ARUN_SO_ITEM_QTY SQL: ARUN_V_ITEM_QTY Type: view

Fetch Sup Assgmt status of a sales order

ARUN_SO_ITEM_QTY is a CDS View that provides data about "Fetch Sup Assgmt status of a sales order" in SAP S/4HANA. It reads from 3 data sources (vbap, marc, vbep) and exposes 4 fields.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
vbap item from
marc mat inner
vbep sch inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_ITEM_QTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Fetch Sup Assgmt status of a sales order view

Fields (4)

KeyFieldSource TableSource FieldDescription
vbeln vbap vbeln
posnr vbap posnr
delivery_qty
status 
@AbapCatalog.sqlViewName: 'ARUN_V_ITEM_QTY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Fetch Sup Assgmt status of a sales order'
define view ARUN_SO_ITEM_QTY
  as select from vbap as item
    inner join   vbep as sch on item.posnr = sch.posnr
    inner join   marc as mat on  item.matnr          = mat.matnr
                             and item.werks          = mat.werks
                             and mat.fsh_mg_arun_req = '1'

{
  item.vbeln,
  item.posnr,
  sum(sch.lmeng)                                   as confirmed_qty,
  sum(sch.dlvqty_bu)                               as delivery_qty,
  case when mat.matnr is null then '' else 'X' end as status

}
where
  sch.lmeng > 0
group by
  item.vbeln,
  item.posnr,
  mat.matnr
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARC",
"VBAP",
"VBEP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More