define view entity zsd_i_article_valuation as select from I_ProductValuationBasic { key Product as Article, key ValuationArea as ValuationArea, key ValuationType as ValuationType, @Semantics.amount.currencyCode: ‘CurrencyCode’ StandardPrice as Читать дальше …
Рубрика: CDS
SAP ABAP CDS Convert Date and Time from YYYYMMDD to DD/MM/YYYY Example
Create Date in format DD/MM/YYYY cast( concat_with_space( Concat( Concat( Concat(substring(tstmp_to_dats(even_tstfr, even_zonfr, $session.client, ‘NULL’), 5, 2), ‘/’), Concat(substring(tstmp_to_dats(even_tstfr, even_zonfr, $session.client, ‘NULL’), 7, 2), ‘/’) ), Substring(tstmp_to_dats(even_tstfr, Читать дальше …
SAP CDS How get GUID from /BOBF/UUID for ODATA Query
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960@AbapCatalog.sqlViewName: ‘/ZHM/CQIMAGEMAT’ @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: ‘Consumption CDS for /ZHM/I_T_IMAGE_MAT’ @OData.publish: true @Metadata.allowExtensions @ObjectModel:{ transactionalProcessingDelegated: true, compositionRoot: true, Читать дальше …