I_SpecIdentifierLongText

DDL: I_SPECIDENTIFIERLONGTEXT SQL: ISPECIDENTLTX Type: view BASIC Package: VDM_PLMB_SPC_BAS

Specification Identifier Long Text

I_SpecIdentifierLongText is a Basic CDS View that provides data about "Specification Identifier Long Text" in SAP S/4HANA. It reads from 1 data source (/plmb/sea_objmap) and exposes 4 fields with key fields SpecIdfgDescInternalID, SpecIdfgDescChangeState. It has 1 association to related views. Part of development package VDM_PLMB_SPC_BAS.

Data Sources (1)

SourceAliasJoin Type
/plmb/sea_objmap objmap from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.SpecIdfgDescUniqueID and _TextObjectPlainLongText.TextObjectCategory = 'C_SHES_TRI' and _TextObjectPlainLongText.TextObjectType = '0001'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECIDENTLTX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
EndUserText.label Specification Identifier Long Text view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SpecIdfgDescInternalID value_char3
KEY SpecIdfgDescChangeState value_char4
SpecIdfgDescUniqueID value_char1
_TextObjectPlainLongText _TextObjectPlainLongText
@AbapCatalog.sqlViewName: 'ISPECIDENTLTX'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.privilegedAssociations: ['_TextObjectPlainLongText']

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MIXED

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

@EndUserText.label: 'Specification Identifier Long Text'
define view I_SpecIdentifierLongText
  as select from /plmb/sea_objmap as objmap
  association [0..*] to I_TextObjectPlainLongText as _TextObjectPlainLongText on  _TextObjectPlainLongText.TextObjectKey      = $projection.SpecIdfgDescUniqueID
                                                                              and _TextObjectPlainLongText.TextObjectCategory = 'C_SHES_TRI'
                                                                              and _TextObjectPlainLongText.TextObjectType     = '0001'
{
  key value_char3                            as  SpecIdfgDescInternalID,
  key value_char4                            as  SpecIdfgDescChangeState,
      value_char1                            as  SpecIdfgDescUniqueID,

      _TextObjectPlainLongText
}
where
      object_type = 'PLM_RSPSUB'
  and value_char2 = 'ESTRI'