P_ThirdPartyPurReqnAvaily

DDL: P_THIRDPARTYPURREQNAVAILY SQL: PSCPURREQN Type: view CONSUMPTION

Third Party Pur Reqn Availability

P_ThirdPartyPurReqnAvaily is a Consumption CDS View that provides data about "Third Party Pur Reqn Availability" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 5 fields with key fields Material, Plant, Subcontractor.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem I_Purchaserequisitionitem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSCPURREQN view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Third Party Pur Reqn Availability view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY Plant Plant
KEY Subcontractor Subcontractor
RequestedQuantity
BaseUnit BaseUnit 
@AbapCatalog.sqlViewName: 'PSCPURREQN'
@VDM.private: true
@VDM.viewType: #CONSUMPTION

@AbapCatalog.compiler.compareFilter: true
--@AccessControl.authorizationCheck: #NOT_ALLOWED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Third Party Pur Reqn Availability'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@Metadata.ignorePropagatedAnnotations: true

define view P_ThirdPartyPurReqnAvaily
  as select from I_Purchaserequisitionitem
{
  key Material,
  key Plant,
  key Subcontractor,
  
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      sum (RequestedQuantity) as RequestedQuantity,

      @Semantics.unitOfMeasure: true
      BaseUnit
      
}
where
      //PurchasingDocumentItemCategory = '5' //Third Party Item category  

       Subcontractor <> ''
group by
  Material,
  Plant,
  Subcontractor,
  BaseUnit
 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEREQUISITIONITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More