C_MMPurchasingInfoRecordHelp

DDL: C_MMPURCHASINGINFORECORDHELP SQL: PMMPURINFRECHELP Type: view CONSUMPTION Package: ODATA_MM_COMMONS_VH

Purchasing Info Record Help

C_MMPurchasingInfoRecordHelp is a Consumption CDS View that provides data about "Purchasing Info Record Help" in SAP S/4HANA. It reads from 2 data sources (I_PurgInfoRecdOrgPlantData, I_PurchasingInfoRecord) and exposes 14 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant. It has 3 associations to related views. Part of development package ODATA_MM_COMMONS_VH.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgInfoRecdOrgPlantData OrgPlantData left_outer
I_PurchasingInfoRecord PurchasingInfoRecord from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_MaterialGroupText _MaterialGroupText $projection.materialgroup = _MaterialGroupText.MaterialGroup
[0..*] I_SupplierPurchasingOrg _SupplierPurchasingOrg $projection.Supplier = _SupplierPurchasingOrg.Supplier

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 (14)

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 Material Group
_MaterialGroupText _MaterialGroupText
_SupplierPurchasingOrg _SupplierPurchasingOrg
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
   association [0..*] to I_SupplierPurchasingOrg        as _SupplierPurchasingOrg    on $projection.Supplier = _SupplierPurchasingOrg.Supplier
  {
  @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 }    
      @EndUserText.label: 'Material Group'
     PurchasingInfoRecord._MaterialGroup.MaterialGroup,
     _MaterialGroupText,
     _SupplierPurchasingOrg,
     @Consumption.hidden: true
     @UI.hidden: true
     OrgPlantData.PurchasingGroup as PurchasingGroup
    
  }

Learn More