Arun_Purchreq_Bdbs

DDL: ARUN_PURCHREQ_BDBS SQL: ARUN_V_PR_BDBS Type: view

Aggregatation of assigned quantities for purchase requisition in preview mode

Arun_Purchreq_Bdbs is a CDS View that provides data about "Aggregatation of assigned quantities for purchase requisition in preview mode" in SAP S/4HANA. It reads from 1 data source (arun_preview) and exposes 4 fields.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
arun_preview arun_preview from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_PR_BDBS 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 Aggregatation of assigned quantities for purchase requisition in preview mode view

Fields (4)

KeyFieldSource TableSource FieldDescription
material material
plant plant
purchord_num purchord_num
alloc_qty 
@AbapCatalog.sqlViewName: 'ARUN_V_PR_BDBS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Aggregatation of assigned quantities for purchase requisition in preview mode'
define view Arun_Purchreq_Bdbs 
as select from arun_preview {
    material,
    plant,
    purchord_num,
    purchord_item,
    sum(alloc_qty) as alloc_qty,
    material_baseunit
}

where arun_preview.stock_source = 'A'  and
      arun_preview.arun_mode = '2'
group by material, plant, purchord_num,purchord_item,material_baseunit
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ARUN_PREVIEW"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More