C_AnalyzeClsgRunRsltTP

DDL: C_ANALYZECLSGRUNRSLTTP SQL: CACLSGRUNRSLTTP Type: view CONSUMPTION Package: ODATA_FI_CLS_ACT_LIST

Closing runs

C_AnalyzeClsgRunRsltTP is a Consumption CDS View that provides data about "Closing runs" in SAP S/4HANA. It reads from 1 data source (R_AnalyzeClsgRunRsltTP) and exposes 25 fields with key field JrnlPeriodEndClosingRunLogUUID. Part of development package ODATA_FI_CLS_ACT_LIST.

Data Sources (1)

SourceAliasJoin Type
R_AnalyzeClsgRunRsltTP R_AnalyzeClsgRunRsltTP from

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName CACLSGRUNRSLTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Closing runs view
Search.searchable true view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value JrnlPeriodEndClosingRunLogID view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value JrnlPeriodEndClosingRunLogID view
UI.headerInfo.typeName Closing Runs view
UI.headerInfo.typeNamePlural Closing Runs view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID Closing Run UUID
JrnlPeriodEndClosingRunLogID JrnlPeriodEndClosingRunLogID Run ID
BusinessTransactionCategory BusinessTransactionCategory Business Transaction Category
BusTransactionCategoryName BusTransactionCategoryName
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Tax period
FiscalYearPeriod FiscalYearPeriod Period/Year
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
FinClsgRunProcessingOptionName FinClsgRunProcessingOptionName
FinClsgRunExecutionStatusName FinClsgRunExecutionStatusName Run Status
FinClosingRunExecutionStatus FinClosingRunExecutionStatus Execution Status
JrnlPerdEndClsgRunCrtedByUser JrnlPerdEndClsgRunCrtedByUser Created By
KeyDate KeyDate Maturity Key Date
FinancialClosingRunDuration FinancialClosingRunDuration Duration
NmbrOfSuccssflObjectsInClsgRun NmbrOfSuccssflObjectsInClsgRun Successful Objects
NmbrOfFailedObjectsInClsgRun NmbrOfFailedObjectsInClsgRun Failed Objects
NumberOfErrorMessages NumberOfErrorMessages Errors
NumberOfWarningMessages NumberOfWarningMessages Warnings
FinClsgRunConfignJSONString FinClsgRunConfignJSONString Configuration
FinClsgRunInputParamJSONStr FinClsgRunInputParamJSONStr Configuration
FinClosingRunBatchJobName FinClosingRunBatchJobName Job Name
_CompanyCode _CompanyCode
_LedgerText _LedgerText
_Ledger _Ledger

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_AnalyzeClsgRunRsltTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CACLSGRUNRSLTTP

CREATE VIEW C_AnalyzeClsgRunRsltTP AS
SELECT
  JrnlPeriodEndClosingRunLogUUID,
  JrnlPeriodEndClosingRunLogID,
  BusinessTransactionCategory,
  BusTransactionCategoryName,
  FiscalYear,
  FiscalPeriod,
  FiscalYearPeriod,
  Ledger,
  CompanyCode,
  FinClsgRunProcessingOptionName,
  FinClsgRunExecutionStatusName,
  FinClosingRunExecutionStatus,
  JrnlPerdEndClsgRunCrtedByUser,
  KeyDate,
  FinancialClosingRunDuration,
  NmbrOfSuccssflObjectsInClsgRun,
  NmbrOfFailedObjectsInClsgRun,
  NumberOfErrorMessages,
  NumberOfWarningMessages,
  FinClsgRunConfignJSONString,
  FinClsgRunInputParamJSONStr,
  FinClosingRunBatchJobName
FROM R_AnalyzeClsgRunRsltTP
;