P_POItemAcctMatDocCalc

DDL: P_POITEMACCTMATDOCCALC Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_POITEMACCT_MNTR

PO Item and Material Document Account Assignment calculation

P_POItemAcctMatDocCalc is a Consumption CDS View that provides data about "PO Item and Material Document Account Assignment calculation" in SAP S/4HANA. It reads from 1 data source (P_POItemAcctMatDoc) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem, AccountAssignmentNumber. Part of development package ODATA_MM_PUR_POITEMACCT_MNTR.

Data Sources (1)

SourceAliasJoin Type
P_POItemAcctMatDoc P_POItemAcctMatDoc from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
KEY AccountAssignmentNumber AccountAssignmentNumber
GoodsReceiptQuantity
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM: { private: true,
        viewType: #CONSUMPTION
      }
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view entity P_POItemAcctMatDocCalc
  as select from P_POItemAcctMatDoc
{
  key PurchaseOrder,
  key PurchaseOrderItem,
  key AccountAssignmentNumber,
      sum (GoodsReceiptQuantity) as GoodsReceiptQuantity
}
group by
  PurchaseOrder,
  PurchaseOrderItem,
  AccountAssignmentNumber