P_IT_REPORTRUNPARAMETER

CDS View

Italy WHT Report Run Parameter

P_IT_REPORTRUNPARAMETER is a CDS View in S/4HANA. Italy WHT Report Run Parameter. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_IT_StRpWHTItemExcldAcctAmt view_entity inner COMPOSITE Italy WHT Excluded Account Amount 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity P_IT_ReportRunParameter
  as select from P_IT_ReportRunParameter2 as RepRunPar
{
  key RepRunPar.StatryRptRunParamUUID,
  key RepRunPar.StatryRptRunUUID,
      RepRunPar.StatryRptgEntity,
      RepRunPar.StatryRptCategory,
      RepRunPar.StatryRptRunID,
      RepRunPar.StatryRptRunParamID,
      RepRunPar.StatryRptRunParamRngeSign,
      RepRunPar.StatryRptRunParamRngeOption,
      RepRunPar.StatryRptRunParamRngeLowValue,
      RepRunPar.StatryRptRunParamRngeHighValue,

      case
      when RepRunPar.StatryRptRunParamID = 'SUPPLIER_ON_SPECIAL_REGIME'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as lifnr)
      else ''
      end                      as Supplier,

      case
      when RepRunPar.StatryRptRunParamID = 'IT_WHT_EXCLUDE_GL_ACCOUNT'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as hkont)
      else ''
      end                      as GLAccount,

      case
      when RepRunPar.StatryRptRunParamID = 'IT_WHT_CERTIFICATE_SIGN_DATE'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as date_sing_it)
      else ''
      end                      as WhldgTaxCertSgntrDate,

      case
      when RepRunPar.StatryRptRunParamID = 'IT_WHT_COMMITMENT_DATE'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as date_comm_it)
      else ''
      end                      as WhldgTxIntermediaryCmtmtDate,

      case
      when RepRunPar.StatryRptRunParamID = 'IT_WHT_REPORTING_YEAR'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as fiwtit_rpyear)
      end                      as WithholdingTaxReportingYear,

      case
      when RepRunPar.StatryRptRunParamID = 'IT_WHT_SUPPLIER_TYPE'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as it_send_type)
      else ''
      end                      as WithholdingTaxSupplierType,


      case
      when RepRunPar.StatryRptRunParamID = 'DELIVERYTYPE'
      then cast(RepRunPar.StatryRptRunParamRngeLowValue as it_del_type)
      else ''
      end                      as WithholdingTaxDeliveryType

}

Learn More