P_POItemAcctInvoiceCalc

DDL: P_POITEMACCTINVOICECALC Type: view_entity CONSUMPTION Package: ODATA_MM_PUR_POITEMACCT_MNTR

PO Item Account Assignment Invoice calculation

P_POItemAcctInvoiceCalc is a Consumption CDS View that provides data about "PO Item Account Assignment Invoice calculation" in SAP S/4HANA. It reads from 1 data source (P_POItemAcctInvoice) 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_POItemAcctInvoice P_POItemAcctInvoice 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 _PurchaseOrderHistory PurchaseOrder
KEY PurchaseOrderItem _PurchaseOrderHistory PurchaseOrderItem
KEY AccountAssignmentNumber AccountAssignmentNumber
InvoiceReceiptQuantity
@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_POItemAcctInvoiceCalc
  as select from P_POItemAcctInvoice
{
  key _PurchaseOrderHistory.PurchaseOrder     as PurchaseOrder,
  key _PurchaseOrderHistory.PurchaseOrderItem as PurchaseOrderItem,
  key AccountAssignmentNumber,

      sum(  InvoiceReceiptQuantity )          as InvoiceReceiptQuantity
}
group by
  _PurchaseOrderHistory.PurchaseOrder,
  _PurchaseOrderHistory.PurchaseOrderItem,
  AccountAssignmentNumber