I_StRpRunDetails

Q: Which tables does I_StRpRunDetails use?

I_StRpRunDetails reads from 3 data source(s): I_StRpJournalEntryLog, I_StRpRepRun, I_StRpTaskDetails.

Q: How many fields does I_StRpRunDetails have?

I_StRpRunDetails has 18 fields. Key fields: StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument.

DDL: I_STRPRUNDETAILS SQL: ISTRPTRUNDET Type: view COMPOSITE

Reporting Periods of Reporting Documents

I_StRpRunDetails is a Composite CDS View (Cube) that provides data about "Reporting Periods of Reporting Documents" in SAP S/4HANA. It reads from 3 data sources (I_StRpJournalEntryLog, I_StRpRepRun, I_StRpTaskDetails) and exposes 18 fields with key fields StatryRptgEntity, StatryRptCategory, StatryRptRunID, CompanyCode, AccountingDocument. It has 2 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_StRpJournalEntryLog	_StRpJournalEntryLog	from
I_StRpRepRun	_StRpRepRun	inner
I_StRpTaskDetails	_StRpTaskDetails	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_StRpCategoryPhaseText	_PhaseText	`$projection.StatryRptCategory = _PhaseText.StatryRptCategory and _StRpRepRun.StatryRptRunType = _PhaseText.StatryRptCatPhase and _PhaseText.StatryRptCatVersion = 'ACT' and _PhaseText.Language = $session.system_language`
[0..1]	I_StRpCategoryText	_CategoryText	`$projection.StatryRptCategory = _CategoryText.StatryRptCategory and _CategoryText.StatryRptCatVersion = 'ACT' and _CategoryText.Language = $session.system_language`

Annotations (10)

Name	Value	Level
EndUserText.label	Reporting Periods of Reporting Documents	view
AbapCatalog.sqlViewName	ISTRPTRUNDET	view
VDM.viewType	#COMPOSITE	view
Analytics.dataCategory	#CUBE	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Metadata.allowExtensions	true	view

Fields (18)

Key	Field	Source Table	Source Field
KEY	StatryRptgEntity	I_StRpJournalEntryLog	StatryRptgEntity
KEY	StatryRptCategory	I_StRpJournalEntryLog	StatryRptCategory
KEY	StatryRptRunID	I_StRpJournalEntryLog	StatryRptRunID
KEY	CompanyCode	I_StRpJournalEntryLog	CompanyCode
KEY	AccountingDocument	I_StRpJournalEntryLog	AccountingDocument
KEY	FiscalYear	I_StRpJournalEntryLog	FiscalYear
	StatryRptRunUUID	I_StRpRepRun	StatryRptRunUUID
	StatryRptActivityUUID	I_StRpRepRun	StatryRptActivityUUID
	StatryRptRunStatus	I_StRpRepRun	StatryRptRunStatus
	StatryRptRunType	I_StRpRepRun	StatryRptRunType
	StatryRptSubmittedDateTime	I_StRpRepRun	StatryRptSubmittedDateTime
	ReportingYear	I_StRpTaskDetails	ReportingYear
	StatryRptTaskPeriod	I_StRpTaskDetails	StatryRptTaskPeriod
	StatryRptTaskPeriodStartDate	I_StRpTaskDetails	StatryRptTaskPeriodStartDate
	StatryRptTaskPeriodEndDate	I_StRpTaskDetails	StatryRptTaskPeriodEndDate
	_PhaseText		_PhaseText
	_TransactionalTaxItem	I_StRpJournalEntryLog	_TransactionalTaxItem
	_CategoryText		_CategoryText

@EndUserText.label: 'Reporting Periods of Reporting Documents'
@AbapCatalog.sqlViewName: 'ISTRPTRUNDET'
@VDM.viewType: #COMPOSITE
@Analytics: { dataCategory: #CUBE }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.allowExtensions: true

define view I_StRpRunDetails
  as select from I_StRpJournalEntryLog as _StRpJournalEntryLog
    inner join   I_StRpRepRun          as _StRpRepRun      on(
           _StRpJournalEntryLog.StatryRptCategory    = _StRpRepRun.StatryRptCategory
           and _StRpJournalEntryLog.StatryRptgEntity = _StRpRepRun.StatryRptgEntity
           and _StRpJournalEntryLog.StatryRptRunID   = _StRpRepRun.StatryRptRunID
         )
    inner join   I_StRpTaskDetails     as _StRpTaskDetails on(
      _StRpRepRun.StatryRptTaskUUID = _StRpTaskDetails.StatryRptTaskUUID
    )
  association [0..1] to I_StRpCategoryPhaseText as _PhaseText    on  $projection.StatryRptCategory  = _PhaseText.StatryRptCategory
                                                                 and _StRpRepRun.StatryRptRunType   = _PhaseText.StatryRptCatPhase
                                                                 and _PhaseText.StatryRptCatVersion = 'ACT'
                                                                 and _PhaseText.Language            = $session.system_language

  association [0..1] to I_StRpCategoryText      as _CategoryText on  $projection.StatryRptCategory     = _CategoryText.StatryRptCategory
                                                                 and _CategoryText.StatryRptCatVersion = 'ACT'
                                                                 and _CategoryText.Language            = $session.system_language
{
  key _StRpJournalEntryLog.StatryRptgEntity   as StatryRptgEntity,
  key _StRpJournalEntryLog.StatryRptCategory  as StatryRptCategory,
  key _StRpJournalEntryLog.StatryRptRunID     as StatryRptRunID,
  key _StRpJournalEntryLog.CompanyCode        as CompanyCode,
  key _StRpJournalEntryLog.AccountingDocument as AccountingDocument,
  key _StRpJournalEntryLog.FiscalYear         as FiscalYear,
      _StRpRepRun.StatryRptRunUUID,
      _StRpRepRun.StatryRptActivityUUID,
      _StRpRepRun.StatryRptRunStatus,
      _StRpRepRun.StatryRptRunType,
      _StRpRepRun.StatryRptSubmittedDateTime,
      _StRpTaskDetails.ReportingYear,
      _StRpTaskDetails.StatryRptTaskPeriod,
      _StRpTaskDetails.StatryRptTaskPeriodStartDate,
      _StRpTaskDetails.StatryRptTaskPeriodEndDate,
      _PhaseText,
      _StRpJournalEntryLog._TransactionalTaxItem,
      _CategoryText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_STRPJOURNALENTRYLOG",
"I_STRPREPRUN",
"I_STRPTASKDETAILS"
],
"ASSOCIATED":
[
"I_STRPCATEGORYPHASETEXT",
"I_STRPCATEGORYTEXT",
"I_TRANSACTIONALTAXITEM"
],
"BASE":
[
"I_STRPJOURNALENTRYLOG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_StRpRunDetails view