I_PurchasingInfoRecordNote

DDL: I_PURCHASINGINFORECORDNOTE Type: view_entity BASIC Package: ODATA_MM_PUR_INFOREC_API

Purchasing Info Record General Notes

I_PurchasingInfoRecordNote is a Basic CDS View that provides data about "Purchasing Info Record General Notes" in SAP S/4HANA. It reads from 2 data sources (I_PurchasingInfoRecord, I_Text_Templates) and exposes 7 fields with key fields TextObjectType, TextObjectKey, Language, PurchasingInfoRecord. Part of development package ODATA_MM_PUR_INFOREC_API.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchasingInfoRecord _PurchasingInfoRecord inner
I_Text_Templates _Text_Templates from

Annotations (9)

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.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchasing Info Record General Notes view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TextObjectType I_Text_Templates DocumentText
KEY TextObjectKey I_Text_Templates ArchitecturalObjectNumber
KEY Language I_Text_Templates Language
KEY PurchasingInfoRecord
NoteDescription I_Text_Templates NoteDescription
Supplier I_PurchasingInfoRecord Supplier
_SupplierPurchasingOrg I_PurchasingInfoRecord _SupplierPurchasingOrg 
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER

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

@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchasing Info Record General Notes'
@Metadata.ignorePropagatedAnnotations: true
define view entity I_PurchasingInfoRecordNote
  as select from I_Text_Templates       as _Text_Templates
    inner join   I_PurchasingInfoRecord as _PurchasingInfoRecord on _PurchasingInfoRecord.PurchasingInfoRecord = _Text_Templates.ArchitecturalObjectNumber
{
  key  _Text_Templates.DocumentText                                                as TextObjectType,
  key  _Text_Templates.ArchitecturalObjectNumber                                   as TextObjectKey,
  key  _Text_Templates.Language,

  key  cast (substring(_Text_Templates.ArchitecturalObjectNumber,1,10)  as infnr ) as PurchasingInfoRecord,
       _Text_Templates.NoteDescription,
       
       //Supplier fields are used in DCL, hence exposed here.

       _PurchasingInfoRecord.Supplier,
       _PurchasingInfoRecord._SupplierPurchasingOrg
}
where
  _Text_Templates.TechnicalObjectType = 'EINA'

Learn More