I_STRPREPRUN

CDS View

General Information about Report Run

I_STRPREPRUN is a CDS View in S/4HANA. General Information about Report Run. It contains 18 fields. 45 CDS views read from this table.

Used by 45 CDS view(s) 18 fields

CDS Views using this table (45)

ViewTypeJoinVDMDescription
C_PL_StRpTxItmWithEUTxClCrrtnC view left_outer CONSUMPTION EU Sales Tax Item View - Correction Run
C_StRpRptdJournalEntry view left_outer CONSUMPTION Reported document for Statutory Reporting
I_IN_EDocReference view_entity inner COMPOSITE Electronic Document Reference
I_StRpCorrespondence view inner BASIC SRF Report Run Correspondence CDS
I_StRpRunDetails view inner COMPOSITE Reporting Periods of Reporting Documents
P_BE_StRpRptdWhldgTaxItem view_entity left_outer COMPOSITE Reported document for Statutory Reporting for Belgium
P_CZ_StRpRptdTxItmWithEUTxClfn view left_outer CONSUMPTION Previously Reported Tax Items - Corr.
P_Fr_StrpRptdWhldgTaxItem view_entity left_outer COMPOSITE Reported document for Statutory Reporting of WHLD for France
P_KR_LastRptdNoneDcblVATItmDet view inner COMPOSITE ACR Non Deduct Last Item Detail
P_KR_StRpRptdItem view left_outer COMPOSITE South Korea Reported Item
P_KZ_VATCDECLOGRUN view inner COMPOSITE submitted custom declarations
P_KZ_VATITEMLOGRUN view inner COMPOSITE Read log table for KZ VAT Decl
P_PE_StRpRptdJournalEntry view_entity inner CONSUMPTION Reported Journal Entries for Statutory Reporting
P_PH_StRpRptdWhldgTaxItem view_entity left_outer COMPOSITE Reported document for Statutory Reporting for Philippines
P_PL_StRpReportingGroupsCr view left_outer CONSUMPTION Reporting Groups - Correction Run
P_RU_DataSelVATCRQ view left_outer BASIC Data Selection for VAT Clarification Request
P_RU_DSVATCRQNotInSL view left_outer BASIC Clarification request (Not in Sell Book Section)
P_RU_DSVATReportingExclSubmd view from CONSUMPTION VAT Reporting: Submitted documents to exclude
P_RU_DSVATReportingExclSubmd view inner CONSUMPTION VAT Reporting: Submitted documents to exclude
P_RU_ExprtConfRegRptItemSOK view from COMPOSITE Submitted documents
P_RU_ExprtConfRINRptItemSOK view from COMPOSITE Submitted Documents
P_RU_LastSubmittedRun view from CONSUMPTION Get Last Submitted Run
P_RU_StRpJournalEntryLogRun view inner CONSUMPTION All Reported Documents with Report RUN
P_RU_StRpJournalEntryLogStat2 view from BASIC ACR Reported Tax Items Log Table Statistic-2
P_RU_StRpRepRun view from COMPOSITE RU General Information about Report Run
P_RU_UnfTxNtcAllSubmdGroups view_entity from COMPOSITE All Submitted UTN Groups
P_RU_UnfTxNtcAllSubmdGroups view_entity union_all COMPOSITE All Submitted UTN Groups
P_RU_UnfTxNtcDocHasFrthrSubmsn view_entity inner COMPOSITE UTN Docs of Grps Which Have Frthr Submsn
P_RU_UnfTxNtcDocLastSubmsn view_entity from COMPOSITE UTN Document Last Submission
P_RU_UnfTxNtcPaytDocSubmitted view inner COMPOSITE UTNP Submitted Documents
P_RU_UTNDocSubmdCurPerd view from COMPOSITE UTNP Submd Documents for Current Period
P_RU_UTNZeroGroupSubmdCurPerd view from COMPOSITE UTNP Submd Zero Grp for Current Period
P_RU_VATStRpRptdJournalEntry view from CONSUMPTION Reported document for Statutory Reporting
P_RU_VATStRpRptdJournalEntry view union_all CONSUMPTION Reported document for Statutory Reporting
P_SG_STRPRUNLOG2 view_entity from COMPOSITE Get Report Run Log
P_SK_StRpVATCSAccptRun view_entity from COMPOSITE SK VAT Control Statement Accepted Run
P_SK_StRpVATCSAccptRunMax view_entity from COMPOSITE SK VAT Control Statement Accepted Run Max
P_StRpRptdTaxItem view left_outer COMPOSITE Reported document for Statutory Reporting
P_TW_StRpRptdItem view left_outer COMPOSITE Reported Item for Taiwan VAT
P_TW_StRpRptdItemConsume view left_outer CONSUMPTION Consumption View for Taiwan reported item
P_UK_StRpRptdEUTaxClass view left_outer COMPOSITE Reported documents for Statutory Reporting of ECSL for UK
P_UK_StRpRptdWhldgTaxItem view_entity left_outer COMPOSITE Reported document for Statutory Reporting of WHLD for UK
R_StRpRunTP view_entity from TRANSACTIONAL Statutory Reporting Run - TP
SRF_Helper_MY_Amendment view from Check if this Reporting run is amendment
Srf_UsHelpAmendment view from Helper view to determine the correction run

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ReportingYear ReportingYear 2
KEY StatryRptCategory StatryRptCategory 12
KEY StatryRptgEntity StatryRptgEntity 12
KEY StatryRptRunID CurrentStatryRptRunID,StatryRptRunID,SubmittedStatryRptRunID 14
KEY StatryRptRunUUID StatryRptRunUUID 5
KEY StatryRptTaskPeriodEndDate StatryRptTaskPeriodEndDate 3
KEY StatryRptTaskPeriodStartDate StatryRptTaskPeriodStartDate 3
KEY StatryRptTaskUUID StatryRptTaskUUID 3
ApplicationJobName ApplicationJobName 1
Country Country 1
StatryRptActivityUUID StatryRptActivityUUID 2
StatryRptCatPhase StatryRptCatPhase 2
StatryRptDef StatryRptDef 2
StatryRptRunCreatedByUser StatryRptRunCreatedByUser 2
StatryRptRunStatus StatryRptRunStatus 33
StatryRptRunType CurrentStatryRptRunType,StatryRptRunType,SubmittedStatryRptRunType 6
StatryRptSubmittedDateTime StatryRptSubmittedDateTime 4
StatryRptTaskDueDate StatryRptTaskDueDate 1 
@AbapCatalog.sqlViewName: 'ISRREPRUN'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:#MIXED
@ObjectModel.sapObjectNodeType.name: 'StatutoryReportingRun'
@EndUserText.label: 'General Information about Report Run'
@AbapCatalog.preserveKey:true // Added for ATC check prio 2 error


define view I_StRpRepRun

  as select from srf_rep_run

    inner join   I_StRpActivity    on srf_rep_run.parent_key = I_StRpActivity.StatryRptActivityUUID
    inner join   I_StRpPhase       on I_StRpActivity.StatryRptPhaseUUID = I_StRpPhase.StatryRptPhaseUUID
    inner join   I_StRpTaskDetails on I_StRpPhase.StatryRptTaskUUID = I_StRpTaskDetails.StatryRptTaskUUID

{
  key srf_rep_run.db_key                             as StatryRptRunUUID,
      srf_rep_run.parent_key                         as StatryRptActivityUUID,
      srf_rep_run.root_key                           as StatryRptTaskUUID,
      srf_rep_run.reporting_entity                   as StatryRptgEntity,
      srf_rep_run.rep_cat_id                         as StatryRptCategory,
      srf_rep_run.report_run_id                      as StatryRptRunID,
      srf_rep_run.report_run_status                  as StatryRptRunStatus,
      srf_rep_run.report_run_type                    as StatryRptRunType,
      srf_rep_run.submitted_on                       as StatryRptSubmittedDateTime,
      srf_rep_run.created_by                         as StatryRptRunCreatedByUser,
      srf_rep_run.created_on                         as StatryRptRunCreatedOnDate,
      I_StRpPhase.StatryRptCatPhase                  as StatryRptCatPhase,
      srf_rep_run.report_id                          as StatryRptDef,
      I_StRpTaskDetails.Country                      as Country,
      I_StRpTaskDetails.ReportingYear                as ReportingYear,
      I_StRpTaskDetails.StatryRptTaskPeriodStartDate as StatryRptTaskPeriodStartDate,
      I_StRpTaskDetails.StatryRptTaskPeriodEndDate   as StatryRptTaskPeriodEndDate,
      I_StRpTaskDetails.StatryRptTaskDueDate         as StatryRptTaskDueDate,
      I_StRpTaskDetails.StatryRptIntegScenario       as StatryRptIntegScenario,
      srf_rep_run.job_name                           as ApplicationJobName
}

Learn More