I_PurgInfoRecdOrganizationNote

DDL: I_PURGINFORECDORGANIZATIONNOTE Type: view_entity BASIC Package: ODATA_MM_PUR_INFOREC_API

Purchasing Info Recd Organisation Notes

I_PurgInfoRecdOrganizationNote is a Basic CDS View that provides data about "Purchasing Info Recd Organisation Notes" in SAP S/4HANA. It reads from 1 data source (I_Text_Templates) and exposes 8 fields with key fields TextObjectType, TextObjectKey, Language, PurchasingInfoRecord, PurchasingOrganization. It has 2 associations to related views. Part of development package ODATA_MM_PUR_INFOREC_API.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_Text_Templates I_Text_Templates from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchasingInfoRecord _PurchasingInfoRecord _PurchasingInfoRecord.PurchasingInfoRecord = $projection.PurchasingInfoRecord
[1..1] I_PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData _PurgInfoRecdOrgPlantData.PurchasingInfoRecord = $projection.PurchasingInfoRecord and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecdOrgPlantData.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecdOrgPlantData.Plant = $projection.Plant

Annotations (8)

NameValueLevelField
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchasing Info Recd Organisation Notes view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY TextObjectType DocumentText
KEY TextObjectKey ArchitecturalObjectNumber
KEY Language Language
KEY PurchasingInfoRecord
KEY PurchasingOrganization
KEY PurchasingInfoRecordCategory
KEY Plant
NoteDescription NoteDescription 
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

@VDM.viewType : #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchasing Info Recd Organisation Notes'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_PurgInfoRecdOrganizationNote
  as select from I_Text_Templates
  association [1..1] to I_PurchasingInfoRecord     as _PurchasingInfoRecord     on  _PurchasingInfoRecord.PurchasingInfoRecord = $projection.PurchasingInfoRecord

  association [1..1] to I_PurgInfoRecdOrgPlantData as _PurgInfoRecdOrgPlantData on  _PurgInfoRecdOrgPlantData.PurchasingInfoRecord         = $projection.PurchasingInfoRecord
                                                                                and _PurgInfoRecdOrgPlantData.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory
                                                                                and _PurgInfoRecdOrgPlantData.PurchasingOrganization       = $projection.PurchasingOrganization
                                                                                and _PurgInfoRecdOrgPlantData.Plant                        = $projection.Plant

{
  key  DocumentText                                                as TextObjectType,
  key  ArchitecturalObjectNumber                                   as TextObjectKey,
  key  Language,

  key  cast (substring(ArchitecturalObjectNumber,1,10)  as infnr ) as PurchasingInfoRecord,
  key  cast (substring(ArchitecturalObjectNumber,11,14) as ekorg ) as PurchasingOrganization,
  key  cast (substring(ArchitecturalObjectNumber,15,15) as esokz ) as PurchasingInfoRecordCategory,
  key  cast (substring(ArchitecturalObjectNumber,16,19) as ewerk ) as Plant,
       NoteDescription
}
where
  TechnicalObjectType = 'EINE'

Learn More