I_STRPREPRUN

CDS View
18 Fields 45 CDS Views

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.

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
P_CZ_StRpRptdTxItmWithEUTxClfn view left_outer CONSUMPTION Previously Reported Tax Items - Corr.
P_Fr_StrpRptdWhldgTaxItem view_entity left_outer COMPOSITE
P_KR_LastRptdNoneDcblVATItmDet view inner COMPOSITE
P_KR_StRpRptdItem view left_outer COMPOSITE
P_KZ_VATCDECLOGRUN view inner COMPOSITE
P_KZ_VATITEMLOGRUN view inner COMPOSITE
P_PE_StRpRptdJournalEntry view_entity inner CONSUMPTION
P_PH_StRpRptdWhldgTaxItem view_entity left_outer COMPOSITE
P_PL_StRpReportingGroupsCr view left_outer CONSUMPTION Reporting Groups - Correction Run
P_RU_DataSelVATCRQ view left_outer BASIC
P_RU_DSVATCRQNotInSL view left_outer BASIC
P_RU_DSVATReportingExclSubmd view from CONSUMPTION
P_RU_DSVATReportingExclSubmd view inner CONSUMPTION
P_RU_ExprtConfRegRptItemSOK view from COMPOSITE
P_RU_ExprtConfRINRptItemSOK view from COMPOSITE
P_RU_LastSubmittedRun view from CONSUMPTION
P_RU_StRpJournalEntryLogRun view inner CONSUMPTION
P_RU_StRpJournalEntryLogStat2 view from BASIC
P_RU_StRpRepRun view from COMPOSITE
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
P_RU_VATStRpRptdJournalEntry view union_all CONSUMPTION
P_SG_STRPRUNLOG2 view_entity from COMPOSITE
P_SK_StRpVATCSAccptRun view_entity from COMPOSITE
P_SK_StRpVATCSAccptRunMax view_entity from COMPOSITE
P_StRpRptdTaxItem view left_outer COMPOSITE
P_TW_StRpRptdItem view left_outer COMPOSITE
P_TW_StRpRptdItemConsume view left_outer CONSUMPTION Consumption View for Taiwan reported item
P_UK_StRpRptdEUTaxClass view left_outer COMPOSITE
P_UK_StRpRptdWhldgTaxItem view_entity left_outer COMPOSITE
R_StRpRunTP view_entity from TRANSACTIONAL Statutory Reporting Run - TP
SRF_Helper_MY_Amendment view from
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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- General Information about Report Run
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STRPREPRUN (
    REPORTINGYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    STATRYRPTRUNUUID,
    STATRYRPTTASKPERIODENDDATE,
    STATRYRPTTASKPERIODSTARTDATE,
    STATRYRPTTASKUUID,
    APPLICATIONJOBNAME,
    COUNTRY,
    STATRYRPTACTIVITYUUID,
    STATRYRPTCATPHASE,
    STATRYRPTDEF,
    STATRYRPTRUNCREATEDBYUSER,
    STATRYRPTRUNSTATUS,
    STATRYRPTRUNTYPE,
    STATRYRPTSUBMITTEDDATETIME,
    STATRYRPTTASKDUEDATE,
    PRIMARY KEY (REPORTINGYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, STATRYRPTRUNUUID, STATRYRPTTASKPERIODENDDATE, STATRYRPTTASKPERIODSTARTDATE, STATRYRPTTASKUUID)
);

Learn More