P_BE_StRpRptdWhldgTaxItem

DDL: P_BE_STRPRPTDWHLDGTAXITEM Type: view_entity COMPOSITE Package: GLO_FIN_IS_WHT_BE

Reported document for Statutory Reporting for Belgium

P_BE_StRpRptdWhldgTaxItem is a Composite CDS View that provides data about "Reported document for Statutory Reporting for Belgium" in SAP S/4HANA. It reads from 1 data source (I_StRpRepRun) and exposes 4 fields with key fields CompanyCode, AccountingDocument, FiscalYear. Part of development package GLO_FIN_IS_WHT_BE.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_StRpRepRun I_StRpRepRun left_outer

Parameters (2)

NameTypeDefault
P_ReportingEntity srf_reporting_entity
P_ReportCategory srf_rep_cat_id

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_Be_Strpwhldgtaxitem CompanyCode
KEY AccountingDocument I_Be_Strpwhldgtaxitem AccountingDocument
KEY FiscalYear I_Be_Strpwhldgtaxitem FiscalYear
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus 
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Reported document for Statutory Reporting of Withholding for Belgium'

@AccessControl.authorizationCheck: #NOT_REQUIRED
define view entity P_BE_StRpRptdWhldgTaxItem
  with parameters

    P_ReportingEntity : srf_reporting_entity,
    P_ReportCategory  : srf_rep_cat_id

  as select distinct from I_Be_Strpwhldgtaxitem

    left outer join       I_StRpRepRun on  I_StRpRepRun.StatryRptgEntity  = $parameters.P_ReportingEntity
                                       and I_StRpRepRun.StatryRptCategory = $parameters.P_ReportCategory
                                       and I_StRpRepRun.StatryRptRunID    = I_Be_Strpwhldgtaxitem.StatryRptRunID
{

  key I_Be_Strpwhldgtaxitem.CompanyCode,
  key I_Be_Strpwhldgtaxitem.AccountingDocument,
  key I_Be_Strpwhldgtaxitem.FiscalYear,
      I_StRpRepRun.StatryRptRunStatus as StatryRptRunStatus


}
where
      I_StRpRepRun.StatryRptRunStatus         = 'SOK'
  and I_Be_Strpwhldgtaxitem.StatryRptCategory = $parameters.P_ReportCategory
  and I_Be_Strpwhldgtaxitem.StatryRptgEntity  = $parameters.P_ReportingEntity

Learn More