I_PRAMaterial

DDL: I_PRAMATERIAL SQL: IPRAMATERIAL Type: view BASIC Package: OIU_LO

PRA Material

I_PRAMaterial is a Basic CDS View that provides data about "PRA Material" in SAP S/4HANA. It reads from 1 data source (I_Material) and exposes 12 fields with key field PRAMaterial. It has 1 association to related views. Part of development package OIU_LO.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_Material I_Material from

Associations (1)

CardinalityTargetAliasCondition
[1] I_PRAMatlMjrProdMappg _PRAMaterialMapping $projection.PRAMaterial = _PRAMaterialMapping.Material

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRAMATERIAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PRA Material view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PRAMaterial Material
MaterialName
MajorProduct _PRAMaterialMapping MajorProduct
MinorProduct _PRAMaterialMapping MinorProduct
MaterialType MaterialType
MaterialGroup MaterialGroup
MaterialBaseUnit MaterialBaseUnit
AuthorizationGroup AuthorizationGroup
_Text _Text
_BaseUnit _BaseUnit
_MaterialGroup _MaterialGroup
_MaterialType _MaterialType 
@AbapCatalog.sqlViewName: 'IPRAMATERIAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'PRA Material'

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_PRAMaterial
  as select from I_Material
  association [1] to I_PRAMatlMjrProdMappg as _PRAMaterialMapping on $projection.PRAMaterial = _PRAMaterialMapping.Material
{

      @ObjectModel.text.association: '_Text'
  key Material                                                as PRAMaterial,

      @Semantics.text: true
      _Text[Language = $session.system_language].MaterialName as MaterialName,

      _PRAMaterialMapping.MajorProduct                        as MajorProduct,

      _PRAMaterialMapping.MinorProduct                        as MinorProduct,

      MaterialType                                            as MaterialType,

      MaterialGroup                                           as MaterialGroup,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      MaterialBaseUnit                                        as MaterialBaseUnit,

      @Consumption.hidden: true
      AuthorizationGroup                                      as AuthorizationGroup,

      _Text,
      _BaseUnit,
      _MaterialGroup,
      _MaterialType

}

Learn More