P_OpenTargetQuantity

DDL: P_OPENTARGETQUANTITY SQL: POPENTARGETQ Type: view CONSUMPTION

Open Target Quantity

P_OpenTargetQuantity is a Consumption CDS View that provides data about "Open Target Quantity" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractHistory) and exposes 3 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractHistory _PurchaseContractHistory from

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName POPENTARGETQ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Open Target Quantity view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractHistory PurchaseContract
KEY PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem
QuantityReleasedTillDate 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'POPENTARGETQ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Open Target Quantity'
@VDM.private: true
@VDM.viewType: #CONSUMPTION

define view P_OpenTargetQuantity
  as select from I_PurchaseContractHistory as _PurchaseContractHistory

{

  key _PurchaseContractHistory.PurchaseContract,

  key _PurchaseContractHistory.PurchaseContractItem,

      sum(_PurchaseContractHistory.ReleaseOrderItemOrderQuantity) as QuantityReleasedTillDate

}
group by
  _PurchaseContractHistory.PurchaseContract,
  _PurchaseContractHistory.PurchaseContractItem

Learn More