I_MaterialWthPurInfoRecd

DDL: I_MATERIALWTHPURINFORECD Type: view_entity BASIC Package: VDM_QM_PLANNING

Materials With Purchase Info Record

I_MaterialWthPurInfoRecd is a Basic CDS View that provides data about "Materials With Purchase Info Record" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field PurchaseInfoRecordIsCreated. It has 1 association to related views. Part of development package VDM_QM_PLANNING.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialWthPurInfoRecdTxt _MaterialWthPurInfoRecdTxt $projection.PurchaseInfoRecordIsCreated = _MaterialWthPurInfoRecdTxt.PurchaseInfoRecordIsCreated

Annotations (9)

NameValueLevelField
EndUserText.label Materials With Purchase Info Record view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey PurchaseInfoRecordIsCreated view
Analytics.technicalName IMATLWITHPIR view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchaseInfoRecordIsCreated
_MaterialWthPurInfoRecdTxt _MaterialWthPurInfoRecdTxt
@EndUserText.label: 'Materials With Purchase Info Record'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
    dataClass: #META,
    sizeCategory: #S,
   serviceQuality: #A
}

@ObjectModel.representativeKey: 'PurchaseInfoRecordIsCreated'
@Analytics.technicalName: 'IMATLWITHPIR'
define view entity I_MaterialWthPurInfoRecd as select from dd07l 

association [0..*] to I_MaterialWthPurInfoRecdTxt as _MaterialWthPurInfoRecdTxt on $projection.PurchaseInfoRecordIsCreated = _MaterialWthPurInfoRecdTxt.PurchaseInfoRecordIsCreated
{

key cast ( substring(domvalue_l, 1, 1 ) as vdm_qeinf  preserving type ) as PurchaseInfoRecordIsCreated,

//Association

_MaterialWthPurInfoRecdTxt
    
}

where
      domname  = 'VDM_QM_MATL_PIR'
  and as4local = 'A'