I_PurgInfoRecordUpdateCodeT

DDL: I_PURGINFORECORDUPDATECODET SQL: IINFORECUPDCODET Type: view BASIC

Update Code for Purg Info Record - Text

I_PurgInfoRecordUpdateCodeT is a Basic CDS View that provides data about "Update Code for Purg Info Record - Text" in SAP S/4HANA. It reads from 1 data source (dd07t) and exposes 6 fields with key fields PurchasingInfoRecordUpdateCode, Language. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
dd07t dd07t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (16)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName IINFORECUPDCODET view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Update Code for Purg Info Record - Text view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey PurchasingInfoRecordUpdateCode view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #TEXT view
Analytics.dataExtraction.enabled true view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecordUpdateCode
KEY Language ddlanguage Language
PurchasingInfoRecordDesc ddtext Info Record Update Code
DomainValue dd07t domvalue_l
_Language _Language
_PurgInfoRecordUpdateCode _PurgInfoRecordUpdateCode 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IINFORECUPDCODET'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Update Code for Purg Info Record - Text'
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.representativeKey: 'PurchasingInfoRecordUpdateCode'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.dataCategory: #TEXT
@Analytics.dataExtraction.enabled: true 
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true

define view I_PurgInfoRecordUpdateCodeT
  as select from dd07t
  association to parent I_PurgInfoRecordUpdateCode as _PurgInfoRecordUpdateCode on $projection.PurchasingInfoRecordUpdateCode = _PurgInfoRecordUpdateCode.PurchasingInfoRecordUpdateCode
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_PurgInfoRecordUpdateCode'
      @ObjectModel.text.element:  [ 'PurchasingInfoRecordDesc' ]
  key cast ( substring( domvalue_l, 1, 1 ) as spinf ) as PurchasingInfoRecordUpdateCode,
      @Semantics.language
      @ObjectModel.foreignKey.association: '_Language'
      @EndUserText.label: 'Language'      
  key ddlanguage                                      as Language,
      @Semantics.text
      @EndUserText.label: 'Info Record Update Code'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH     
      ddtext                                          as PurchasingInfoRecordDesc,
      @Consumption.hidden: true
      dd07t.domvalue_l                                  as DomainValue,
      _Language,
      _PurgInfoRecordUpdateCode
}
where
      domname  = 'SPINF'
  and as4local = 'A'
  and dd07t.as4vers = '0000'

Learn More