SRF_RuHelperSPLedger

DDL: SRF_RUHELPERSPLEDGER SQL: SRFRUHELPSPL Type: view Package: GLO_FIN_IS_VAT_RU_SPL

Sales Purchase Ledgers Helper View

SRF_RuHelperSPLedger is a CDS View that provides data about "Sales Purchase Ledgers Helper View" in SAP S/4HANA. It reads from 1 data source (I_SAPClient) and exposes 2 fields. Part of development package GLO_FIN_IS_VAT_RU_SPL.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_SAPClient I_SAPClient from

Parameters (8)

NameTypeDefault
P_InvoiceDate abap.dats
P_RevisionNumberOrig j_3rfinv_revno_orig
P_RevisionDateOrig j_3rfinv_orig_revd
P_RevisionNumberCorr j_3rfinv_revno
P_RevisionDateCorr j_3rfinv_revd
P_CorrectionInvoiceDate abap.dats
P_VATAmount aflex17d2o23s
P_ItemsWithTax abap.int4

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SRFRUHELPSPL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Purchase Ledgers Helper View view
ObjectModel.usageType.serviceQuality #P view

Fields (2)

KeyFieldSource TableSource FieldDescription
P_InvoiceDateaschar814endasInvoiceDate
char25endasVATAmountStr 
@AbapCatalog.sqlViewName: 'SRFRUHELPSPL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales Purchase Ledgers Helper View'
@ObjectModel.usageType.serviceQuality: #P
define view SRF_RuHelperSPLedger
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_InvoiceDate           : abap.dats,
    P_RevisionNumberOrig    : j_3rfinv_revno_orig, //abap.numc( 3 ),

    P_RevisionDateOrig      : j_3rfinv_orig_revd, //abap.dats,

    P_RevisionNumberCorr    : j_3rfinv_revno, //abap.numc( 3 ),

    P_RevisionDateCorr      : j_3rfinv_revd, //abap.dats,

    P_CorrectionInvoiceDate : abap.dats,
    P_VATAmount             : aflex17d2o23s,
    P_ItemsWithTax          : abap.int4

  as select from I_SAPClient //dummy select, CDS view only used for calculations

  
{
  case $parameters.P_InvoiceDate
    when '00000000'
      then ''
    when ''
      then ''
    else concat( substring(cast($parameters.P_InvoiceDate as char8),7,2),
                    concat('.',
                            concat( substring(cast($parameters.P_InvoiceDate as char8),5,2),
                                    concat('.',substring(cast($parameters.P_InvoiceDate as char8),1,4))
                                  )
                          )
                  )
  end                                                                                                                         as InvoiceDate,



  case $parameters.P_RevisionNumberOrig
      when '000'
        then ''
        else cast($parameters.P_RevisionNumberOrig as char3)
  end                                                                                                                         as OriginalInvoiceRevisionNumber,

  case $parameters.P_RevisionDateOrig
    when '00000000'
      then ''
    when ''
      then ''
      else concat( substring(cast($parameters.P_RevisionDateOrig as char8),7,2),
                    concat('.',
                            concat( substring(cast($parameters.P_RevisionDateOrig as char8),5,2),
                                    concat('.',substring(cast($parameters.P_RevisionDateOrig as char8),1,4))
                                  )
                          )
                  )
  end                                                                                                                         as OriginalInvoiceRevisionDate,




  case $parameters.P_RevisionNumberCorr
      when '000'
        then ''
        else cast($parameters.P_RevisionNumberCorr as char3)
  end                                                                                                                         as CorrectionInvoiceRevisionNmbr,

  case $parameters.P_RevisionDateCorr
    when '00000000'
      then ''
    when ''
      then ''
      else concat( substring(cast($parameters.P_RevisionDateCorr as char8),7,2),
                    concat('.',
                            concat( substring(cast($parameters.P_RevisionDateCorr as char8),5,2),
                                    concat('.',substring(cast($parameters.P_RevisionDateCorr as char8),1,4))
                                  )
                          )
                  )
  end                                                                                                                         as CorrectionInvoiceRevisionDate,



  case $parameters.P_CorrectionInvoiceDate
    when '00000000'
      then ''
    when ''
      then ''
      else concat( substring(cast($parameters.P_CorrectionInvoiceDate as char8),7,2),
                    concat('.',
                            concat( substring(cast($parameters.P_CorrectionInvoiceDate as char8),5,2),
                                    concat('.',substring(cast($parameters.P_CorrectionInvoiceDate as char8),1,4))
                                  )
                          )
                  )
  end                                                                                                                         as CorrectionInvoiceDate,


  case $parameters.P_ItemsWithTax
    when 0
      then ''
      else cast($parameters.P_VATAmount as abap.char( 25 ))
  end                                                                                                                         as VATAmountStr
}

Learn More