I_RO_SAFTPurInvoiceItemAmount

DDL: I_RO_SAFTPURINVOICEITEMAMOUNT SQL: IROSAFTPURINAMT Type: view BASIC

RO SAFT Purchase Invoice Item Amount

I_RO_SAFTPurInvoiceItemAmount is a Basic CDS View that provides data about "RO SAFT Purchase Invoice Item Amount" in SAP S/4HANA. It reads from 1 data source (bseg) and exposes 8 fields.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
bseg bseg from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IROSAFTPURINAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label RO SAFT Purchase Invoice Item Amount view

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode bseg bukrs
AccountingDocument bseg belnr
FiscalYear bseg gjahr
AccountingDocumentItem bseg buzei
TransactionAmountInLocalCrcy bseg dmbtr
TransactionCurrency bkpf waers
InvoiceAmountInInvoiceDocCrcy bseg wrbtr
ExchangeRate 
@AbapCatalog.sqlViewName: 'IROSAFTPURINAMT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'RO SAFT Purchase Invoice Item Amount'
define view I_RO_SAFTPurInvoiceItemAmount as select from bseg
  join bkpf
    on bseg.bukrs = bkpf.bukrs
    and bseg.belnr = bkpf.belnr
    and bseg.gjahr = bkpf.gjahr
  {
    bseg.bukrs as CompanyCode,
    bseg.belnr as AccountingDocument,
    bseg.gjahr as FiscalYear,
    bseg.buzei as AccountingDocumentItem,
    
    bseg.dmbtr as TransactionAmountInLocalCrcy,//Amount,

    bkpf.waers as TransactionCurrency,//CurrencyCode,

    bseg.wrbtr as InvoiceAmountInInvoiceDocCrcy,//CurrencyAmount,

    //bkpf.kursf as ExchangeRate     

    cast(round(bkpf.kursf, 4) as saft_ro_exchange_rate) as ExchangeRate
    
}

Learn More