P_PurOrderItemCastedNetAmount

DDL: P_PURORDERITEMCASTEDNETAMOUNT SQL: PPOITEMNETAMNT Type: view CONSUMPTION Package: ODATA_MM_PUR_POITEMS_MONI

Purchase Order Item Casted NetAmount

P_PurOrderItemCastedNetAmount is a Consumption CDS View that provides data about "Purchase Order Item Casted NetAmount" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 6 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_PUR_POITEMS_MONI.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem I_PurchaseOrderItem from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPOITEMNETAMNT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Order Item Casted NetAmount view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem PurchaseOrderItem
OrderQuantity OrderQuantity
NetAmount
DocumentCurrency DocumentCurrency
PurchaseOrderDate _PurchaseOrder PurchaseOrderDate
@AbapCatalog.sqlViewName: 'PPOITEMNETAMNT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Order Item Casted NetAmount'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_PurOrderItemCastedNetAmount 
  as select from I_PurchaseOrderItem
{
  key PurchaseOrder,

  key PurchaseOrderItem,

      OrderQuantity,

      cast(NetAmount as abap.curr(15,2)) as NetAmount,

      DocumentCurrency,

      _PurchaseOrder.PurchaseOrderDate
}