Zi Soheader

Download as txt, pdf, or txt
Download as txt, pdf, or txt
You are on page 1of 1

@AbapCatalog.

sqlViewName: 'ZICDS_SOHEADER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Sales order header interface'
define view ZI_SOHEADER as select from vbak
{

key vbeln as sonumber,


erdat,
ernam,
auart,
netwr,
waerk,
vkorg,
vtweg,
spart,
kunnr,
bestk,
case bestk
when 'A' then 'Not yet processed'
when 'B' then 'Partially processed'
when 'C' then 'Completely processed'
else 'Not Relevant'
end as dlv_confirmation,

currency_conversion( amount => netwr,


source_currency => waerk,
target_currency => cast( 'INR'as waerk ),
exchange_rate_date => erdat) as price_inr

You might also like