C_MMPurchasingInfoRecordHelp

DDL: C_MMPURCHASINGINFORECORDHELP SQL: PMMPURINFRECHELP Type: view CONSUMPTION

C_MMPurchasingInfoRecordHelp is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurgInfoRecdOrgPlantData, I_PurchasingInfoRecord) and exposes 13 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant. It has 2 associations to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgInfoRecdOrgPlantData OrgPlantData left_outer
I_PurchasingInfoRecord PurchasingInfoRecord from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMMPURINFRECHELP view
Analytics.dataExtraction.enabled false view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord I_PurchasingInfoRecord PurchasingInfoRecord
KEY PurchasingOrganization PurchasingOrganization
KEY PurchasingInfoRecordCategory PurchasingInfoRecordCategory
KEY Plant Plant
Supplier Supplier
SupplierName _Supplier SupplierName
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName
PlantName _Plant PlantName
Material Material
_MaterialText _MaterialText
MaterialGroup MaterialGroup
_MaterialGroupText _MaterialGroupText
PurchasingGroup I_PurgInfoRecdOrgPlantData PurchasingGroup 
@AbapCatalog.sqlViewName: 'PMMPURINFRECHELP'
@Analytics.dataExtraction.enabled : false 
@AccessControl.authorizationCheck:#CHECK
@VDM.viewType : #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@Search.searchable: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED


define view C_MMPurchasingInfoRecordHelp
  as select from I_PurchasingInfoRecord as PurchasingInfoRecord
  left outer join I_PurgInfoRecdOrgPlantData as OrgPlantData
   on PurchasingInfoRecord.PurchasingInfoRecord = OrgPlantData.PurchasingInfoRecord
   association [0..*] to I_MaterialText                 as _MaterialText      on $projection.Material = _MaterialText.Material
   association [0..*] to I_MaterialGroupText            as _MaterialGroupText on $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
  
  {
  @Search: { defaultSearchElement: true, ranking: #HIGH }
     key PurchasingInfoRecord.PurchasingInfoRecord,
     key PurchasingOrganization,
     key PurchasingInfoRecordCategory,
     key Plant,
   @Search: { defaultSearchElement: true, ranking: #HIGH }  
     Supplier,
     _Supplier.SupplierName,   
     _PurchasingOrganization.PurchasingOrganizationName,
   @Search: { defaultSearchElement: true, ranking: #HIGH }    
     _Plant.PlantName,
   @Search: { defaultSearchElement: true, ranking: #HIGH }    
     Material,   
    _MaterialText,
   @Search: { defaultSearchElement: true, ranking: #HIGH }    
     MaterialGroup,  
     _MaterialGroupText,
     
     @Consumption.hidden: true
     @UI.hidden: true
     OrgPlantData.PurchasingGroup as PurchasingGroup
    
  }

Learn More