P_UK_StRpRptdEUTaxClass

DDL: P_UK_STRPRPTDEUTAXCLASS SQL: PSRUKRPTDECSLITM Type: view COMPOSITE Package: GLO_FIN_IS_ECSL_GB

Reported documents for Statutory Reporting of ECSL for UK

P_UK_StRpRptdEUTaxClass is a Composite CDS View that provides data about "Reported documents for Statutory Reporting of ECSL for UK" 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_ECSL_GB.

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 (5)

NameValueLevelField
AbapCatalog.sqlViewName PSRUKRPTDECSLITM view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_UK_StRpTaxItmWithEUTaxClass CompanyCode
KEY AccountingDocument I_UK_StRpTaxItmWithEUTaxClass AccountingDocument
KEY FiscalYear I_UK_StRpTaxItmWithEUTaxClass FiscalYear
StatryRptRunStatus I_StRpRepRun StatryRptRunStatus 
@AbapCatalog.sqlViewName: 'PSRUKRPTDECSLITM'
@VDM.viewType: #COMPOSITE
@VDM.private: true
//@EndUserText.label: 'Reported document for Statutory Reporting of ECSL for UK'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

////////////////////////////////////////////////////////////////////

// This private view is intended to derive reported document for Statutory Reporting of ECSL for UK//

////////////////////////////////////////////////////////////////////



define view P_UK_StRpRptdEUTaxClass
  with parameters

    P_ReportingEntity : srf_reporting_entity,
    P_ReportCategory  : srf_rep_cat_id

  as select distinct from I_UK_StRpTaxItmWithEUTaxClass

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

{
  key I_UK_StRpTaxItmWithEUTaxClass.CompanyCode,
  key I_UK_StRpTaxItmWithEUTaxClass.AccountingDocument,
  key I_UK_StRpTaxItmWithEUTaxClass.FiscalYear,
      I_StRpRepRun.StatryRptRunStatus
}

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

Learn More