I_MaterialGroup

DDL: I_MATERIALGROUP Type: view BASIC

Material Group

I_MaterialGroup is a Basic CDS View (Dimension) that provides data about "Material Group" in SAP S/4HANA. It reads from 1 data source (t023) and exposes 3 fields with key field MaterialGroup. It has 1 association to related views. It is exposed through 8 OData services (MM_PUR_PROCESS_PR_V4, UI_CUSTOMERRETURNMANAGE, UI_INBOUNDDELIVERYMANAGE, ...). It is used in 2 Fiori applications: Manage Purchase Orders - Fashion, Review Service Entry Sheet Accruals.

1 data source(s) Exposed by 8 service(s) Used in 2 Fiori app(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
t023 t023 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialGroupText _Text $projection.MaterialGroup = _Text.MaterialGroup

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMATGROUP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Material Group view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MaterialGroup view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view

OData Services (8)

ServiceBindingVersionContractRelease
MM_PUR_PROCESS_PR_V4 MM_PUR_PR_PROCESS_V4 V4 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_INBOUNDDELIVERYMANAGE UI_INBOUNDDELIVERYMANAGE V4 C1 NOT_RELEASED
UI_PURCHASEORDERACCRS_DISPLAY UI_PURCHASEORDERACCRS_DSP V2 C1 NOT_RELEASED
UI_RFM_PO_MNG UI_RFM_PO_MNG V2 C1 NOT_RELEASED
UI_SOURCING_PROJECT_COMPARE UI_SRCGPROJ_COMPARE V2 C1 NOT_RELEASED
UI_SSACPERDCAMOUNTS_REVIEW UI_SSACPERDCAMOUNTS_REVIEW V2 C1 NOT_RELEASED
UI_SUPLRUSRDFNDCRITRA_MANAGE UI_SUPLRUSRDFNDCRITRA V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5391 Manage Purchase Orders - Fashion Transactional
F6108 Review Service Entry Sheet Accruals Transactional Review service entry sheet accrual amount for each period.

Manage Purchase Orders - Fashion

Business Role: Purchaser (Retail)

With this app, you can now consolidate purchase order items into an existing purchase order based on the settings in the rule maintained using the Configure Purchase Order Consolidation Rule app.

Review Service Entry Sheet Accruals

Business Role: Cost Accountant - Overhead

For service purchasing, you need to post accruals for costs that come from unapproved service entry sheets. A purchase order item could have multiple service entry sheets with different account assignments. The Service Entry Sheet Accruals application enables you to calculate and post accruals in General Ledger Accounting automatically. The relevant data can be transferred from Service Purchasing and Recording of the Materials Management component to the Accrual Engine and automatically converted from purchase order items into accrual subobjects. The system calculates the accruals for each account assignment specified in the items of service entry sheets. In each period, you can start an accrual run, which posts all accruals for the service transactions.

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroup
MaterialAuthorizationGroup t023 begru
_Text _Text 
@AbapCatalog: {
  sqlViewName: 'IMATGROUP',
  preserveKey: true,
  compiler.compareFilter: true
  }
@Analytics: { dataCategory: #DIMENSION }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Material Group'
@Search.searchable: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'MaterialGroup'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Consumption.ranked: true

define view I_MaterialGroup
  as select from t023
  association [0..*] to I_MaterialGroupText as _Text on $projection.MaterialGroup = _Text.MaterialGroup
{
      @ObjectModel.text.association: '_Text'

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key cast(t023.matkl as productgroup preserving type ) as MaterialGroup,
      @UI.hidden: true
      @Consumption.hidden: true
      t023.begru                                        as MaterialAuthorizationGroup,

      _Text
}

Learn More