P_Purgrequisitionacctvaluehelp

DDL: P_PURGREQUISITIONACCTVALUEHELP SQL: PPURGREQNACCT_VH Type: view CONSUMPTION

Value help for purchase requisition

P_Purgrequisitionacctvaluehelp is a Consumption CDS View that provides data about "Value help for purchase requisition" in SAP S/4HANA. It reads from 1 data source (I_Purchaserequisitionitem) and exposes 23 fields with key fields PurchaseRequisition, PurchaseRequisitionItem. It has 3 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_Purchaserequisitionitem PurchaseRequisitionItem from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_Supplier _DesiredSupplier $projection.Supplier = _DesiredSupplier.Supplier

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPURGREQNACCT_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PurchaseRequisition view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Value help for purchase requisition view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_Purchaserequisitionitem PurchaseRequisition
KEY PurchaseRequisitionItem I_Purchaserequisitionitem PurchaseRequisitionItem
PurchaseRequisitionItemText I_Purchaserequisitionitem PurchaseRequisitionItemText
ProcessingStatus I_Purchaserequisitionitem ProcessingStatus
Material I_Purchaserequisitionitem Material
Plant I_Purchaserequisitionitem Plant
PlantName _Plant PlantName
PurchasingDocumentCategory I_Purchaserequisitionitem PurchasingDocumentCategory
IsPurReqnBlocked I_Purchaserequisitionitem IsPurReqnBlocked
IsPurReqnCmplt I_Purchaserequisitionitem IsPurReqnCmplt
Supplier I_Purchaserequisitionitem Supplier
FixedSupplier I_Purchaserequisitionitem FixedSupplier
IsDeleted I_Purchaserequisitionitem IsDeleted
IsClosed I_Purchaserequisitionitem IsClosed
OrderedQuantity I_Purchaserequisitionitem OrderedQuantity
RequestedQuantity
PurchasingDocumentItemCategory I_Purchaserequisitionitem PurchasingDocumentItemCategory
PurchasingDocumentSubtype I_Purchaserequisitionitem PurchasingDocumentSubtype
IsBusinessPurposeCompleted
_MaterialText _MaterialText
PurchaseRequisitionType I_Purchaserequisitionitem PurchaseRequisitionType
PurchasingGroup I_Purchaserequisitionitem PurchasingGroup
PurchasingOrganization I_Purchaserequisitionitem PurchasingOrganization 
@AbapCatalog.sqlViewName: 'PPURGREQNACCT_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true

@ObjectModel.semanticKey: ['PurchaseRequisition', 'PurchaseRequisitionItem']
@ObjectModel.representativeKey: 'PurchaseRequisition'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Value help for purchase requisition'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_Purgrequisitionacctvaluehelp
  as select from I_Purchaserequisitionitem as PurchaseRequisitionItem

  association [0..*] to I_MaterialText as _MaterialText on $projection.Material = _MaterialText.Material

  association [0..1] to I_Plant        as _Plant        on $projection.Plant = _Plant.Plant
  
   association [0..1] to I_Supplier                     as _DesiredSupplier             on  $projection.Supplier = _DesiredSupplier.Supplier

{

     // @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }

  key PurchaseRequisitionItem.PurchaseRequisition         as PurchaseRequisition,

     // @ObjectModel.foreignKey.association

  key PurchaseRequisitionItem.PurchaseRequisitionItem     as PurchaseRequisitionItem,

     // @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }

      PurchaseRequisitionItem.PurchaseRequisitionItemText as PurchaseRequisitionItemText,

      PurchaseRequisitionItem.ProcessingStatus            as ProcessingStatus,

     // @ObjectModel.text.association: '_MaterialText'

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }

      PurchaseRequisitionItem.Material                    as Material,

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM}

      PurchaseRequisitionItem.Plant                       as Plant,

     // @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.7 }

      _Plant.PlantName,
      
     // @UI.hidden: true

     //@Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentCategory,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsPurReqnBlocked,
      //@UI.hidden: true

      //@Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsPurReqnCmplt,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.Supplier,
      
     // _DesiredSupplier.IsBusinessPurposeCompleted,

      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.FixedSupplier,
      
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsDeleted,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.IsClosed,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.OrderedQuantity,
      
      //@UI.hidden: true

      cast(PurchaseRequisitionItem.RequestedQuantity as abap.dec( 25, 2 ))                                                                                   as       RequestedQuantity,
      
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentItemCategory,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem.PurchasingDocumentSubtype,
      //@UI.hidden: true

     // @Consumption.filter.hidden: true

      PurchaseRequisitionItem._Supplier.IsBusinessPurposeCompleted,
      
      _MaterialText,
      
      PurchaseRequisitionItem.PurchaseRequisitionType,
      
      PurchaseRequisitionItem.PurchasingGroup,
      
      PurchaseRequisitionItem.PurchasingOrganization

}
where
      PurchaseRequisitionItem.PurchasingDocumentCategory = 'B'
      and PurchaseRequisitionItem.IsDeleted = ''
      and PurchaseRequisitionItem.ProcurementHubSourceSystem = '' // 3364862

      and PurchaseRequisitionItem.ExtPlantForPurg = ''
      and PurchaseRequisitionItem.ExtCompanyCodeForPurg = ''  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"I_PURCHASEREQUISITIONITEM",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"I_PLANT",
"I_SUPPLIER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More