P_POItemAcctInvoiceCalc
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)
| Source | Alias | Join Type |
|---|---|---|
| P_POItemAcctInvoice | P_POItemAcctInvoice | from |
Annotations (6)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA