
AbapCatalog.buffering.numberOfKeyFields
AbapCatalog.buffering.status
AbapCatalog.buffering.type
AbapCatalog.compiler.compareFilter
AbapCatalog.dbHints[ ].dbSystem
AbapCatalog.dbHints[ ].hint
AbapCatalog.preserveKey
AbapCatalog.sqlViewAppendName
AbapCatalog.sqlViewName
AbapCatalog.viewEnhancementCategory[ ]
AccessControl.authorizationCheck
ClientDependent
ClientHandling.algorithm
ClientHandling.type
Consumption.defaultValue
Consumption.derivation.binding[ ].targetElement
Consumption.derivation.binding[ ].targetParameter
Consumption.derivation.binding[ ].type
Consumption.derivation.binding[ ].value
Consumption.derivation.derivationFilter
Consumption.derivation.lookupEntity
Consumption.derivation.procedure
Consumption.derivation.resultElement
Consumption.filter.defaultValue
Consumption.filter.hidden
Consumption.filter.hierarchyBinding[ ].type
Consumption.filter.hierarchyBinding[ ].value
Consumption.filter.hierarchyBinding[ ].variableSequence
Consumption.filter.mandatory
Consumption.filter.multipleSelections
Consumption.filter.selectionType
Consumption.groupWithElement
Consumption.hidden
Consumption.labelElement
Consumption.quickInfoElement
Consumption.semanticObject
Consumption.valueHelp
DataAging.noAgingRestriction
EndUserText.label
EndUserText.quickInfo
Environment.sql.passValue
Environment.systemField
MappingRole
Metadata.allowExtensions
Metadata.ignorePropagatedAnnotations
Metadata.layer
OData.publish
ObjectModel.association.type[ ]
ObjectModel.compositionRoot
ObjectModel.createEnabled
ObjectModel.dataCategory
ObjectModel.deleteEnabled
ObjectModel.foreignKey.association
ObjectModel.mandatory
ObjectModel.modelCategory
ObjectModel.readOnly
ObjectModel.representativeKey
ObjectModel.semanticKey[ ]
ObjectModel.text.association
ObjectModel.text.element[ ]
ObjectModel.updateEnabled
ObjectModel.writeActivePersistence
ObjectModel.writeDraftPersistence
ObjectModel.writeEnabled
Semantics.address.city
Semantics.address.country
Semantics.address.label
Semantics.address.postBox
Semantics.address.region
Semantics.address.street
Semantics.address.subRegion
Semantics.address.type[ ]
Semantics.address.zipCode
Semantics.amount.currencyCode
Semantics.businessDate.at
Semantics.businessDate.createdAt
Semantics.businessDate.from
Semantics.businessDate.lastChangedAt
Semantics.businessDate.to
Semantics.calendar.dayOfMonth
Semantics.calendar.dayOfYear
Semantics.calendar.month
Semantics.calendar.quarter
Semantics.calendar.week
Semantics.calendar.year
Semantics.calendar.yearMonth
Semantics.calendar.yearQuarter
Semantics.calendar.yearWeek
Semantics.calendarItem.categories
Semantics.calendarItem.class
Semantics.calendarItem.completed
Semantics.calendarItem.contact
Semantics.calendarItem.description
Semantics.calendarItem.dtEnd
Semantics.calendarItem.dtStart
Semantics.calendarItem.due
Semantics.calendarItem.duration
Semantics.calendarItem.fbType
Semantics.calendarItem.location
Semantics.calendarItem.percentComplete
Semantics.calendarItem.priority
Semantics.calendarItem.status
Semantics.calendarItem.summary
Semantics.calendarItem.transparent
Semantics.calendarItem.wholeDay
Semantics.contact.birthDate
Semantics.contact.note
Semantics.contact.photo
Semantics.contact.type
Semantics.currencyCode
Semantics.eMail.address
Semantics.eMail.bcc
Semantics.eMail.body
Semantics.eMail.cc
Semantics.eMail.from
Semantics.eMail.keywords
Semantics.eMail.received
Semantics.eMail.sender
Semantics.eMail.subject
Semantics.eMail.to
Semantics.eMail.type[ ]
Semantics.fiscal.period
Semantics.fiscal.year
Semantics.fiscal.yearPeriod
Semantics.fiscal.yearVariant
Semantics.geoLocation.cartoId
Semantics.geoLocation.latitude
Semantics.geoLocation.longitude
Semantics.geoLocation.normalizedName
Semantics.language
Semantics.mimeType
Semantics.name.additionalName
Semantics.name.familyName
Semantics.name.fullName
Semantics.name.givenName
Semantics.name.jobTitle
Semantics.name.nickName
Semantics.name.prefix
Semantics.name.suffix
Semantics.organization.name
Semantics.organization.role
Semantics.organization.unit
Semantics.quantity.unitOfMeasure
Semantics.systemDate.createdAt
Semantics.systemDate.lastChangedAt
Semantics.telephone.type[ ]
Semantics.text
Semantics.time
Semantics.unitOfMeasure
Semantics.url.mimeType
Semantics.user.createdBy
Semantics.user.id
Semantics.user.lastChangedBy
Semantics.user.responsible
SELECT * FROM ABDOC_CDS_ANNOS where SPRAS = 'E'
//This is select statement
Select
* from
CDSVIEWANNOPOS
//But I want see Annotations of one CDS view so I added where clause as shown below
Select
* from
CDSVIEWANNOPOS
where cdsname = 'I_MATERIAL'
Select
* from
CDSVIEWANNOPOS
where cdsname = 'I_MATERIAL'
AND ANNOTATIONNAME LIKE '%.%'
select * from
CDS_FIELD_ANNOTATION
WHERE CDSNAME = 'I_MATERIAL'
and ANNOTATIONNAME LIKE '%.%'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
5 | |
3 | |
3 | |
3 | |
3 | |
2 | |
2 | |
2 | |
2 | |
2 |