I_JrnlPerdEndClsgRunLogResult

DDL: I_JRNLPERDENDCLSGRUNLOGRESULT SQL: IFICLSRUNLOGLT Type: view BASIC
47 Fields 1 Data Sources

Related results of period end closing run log entry

I_JrnlPerdEndClsgRunLogResult is a Basic CDS View that provides data about "Related results of period end closing run log entry" in SAP S/4HANA. It reads from 1 data source (fins_cls_run_rl2) and exposes 47 fields with key field JrnlPerdEndClsgRunResultUUID.

Data Sources (1)

SourceAliasJoin Type
fins_cls_run_rl2 fins_cls_run_rl2 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFICLSRUNLOGLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Related results of period end closing run log entry view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY JrnlPerdEndClsgRunResultUUID jrnlperdendclsgrunresultuuid Result List UUID
JrnlPeriodEndClosingRunLogUUID jrnlperiodendclosingrunloguuid Closing Run UUID
Ledger ledger Ledger
CompanyCode companycode Receiver Company Code
FiscalYear fiscalyear G/L Fiscal Year
AccountingDocument accountingdocument Journal Entry
LedgerGLLineItem ledgergllineitem Journal Entry Item
FinancialClosingLineItemStatus financialclosinglineitemstatus Status
FinClsgRunRsltAmtInFDCrcy1 finclsgrunrsltamtinfdcrcy1 Amount in Currency 1
FinClsgRunRsltAmtInFDCrcy2 finclsgrunrsltamtinfdcrcy2 Amount in Currency 2
FinClsgRunRsltAmtInFDCrcy3 finclsgrunrsltamtinfdcrcy3 Amount in Currency 3
FinClsgRunRsltAmtInFDCrcy4 finclsgrunrsltamtinfdcrcy4 Amount in Currency 4
FinClsgRunRsltAmtInFDCrcy5 finclsgrunrsltamtinfdcrcy5 Amount in Currency 5
FinClsgRunRsltAmtInFDCrcy6 finclsgrunrsltamtinfdcrcy6 Amount in Currency 6
FinClsgRunRsltAmtInFDCrcy7 finclsgrunrsltamtinfdcrcy7 Amount in Currency 7
FinClsgRunRsltAmtInFDCrcy8 finclsgrunrsltamtinfdcrcy8 Amount in Currency 8
FreeDefinedCurrency1 freedefinedcurrency1 Freely Defined Currency 1
FreeDefinedCurrency2 freedefinedcurrency2 Freely Defined Currency 2
FreeDefinedCurrency3 freedefinedcurrency3 Freely Defined Currency 3
FreeDefinedCurrency4 freedefinedcurrency4 Freely Defined Currency 4
FreeDefinedCurrency5 freedefinedcurrency5 Freely Defined Currency 5
FreeDefinedCurrency6 freedefinedcurrency6 Freely Defined Currency 6
FreeDefinedCurrency7 freedefinedcurrency7 Freely Defined Currency 7
FreeDefinedCurrency8 freedefinedcurrency8 Freely Defined Currency 8
ExchangeRate exchangerate Exchange rate
FinClosingRunIsTestExecution finclosingrunistestexecution Test Run
FinancialClosingLineItemType financialclosinglineitemtype Line Item Type
SubLedgerAcctLineItemType subledgeracctlineitemtype SLALineItemType
FinClosingEntryCalculationType finclosingentrycalculationtype Calc. Line Type
CreditRiskClass creditriskclass Credit Risk Class
GeneralLedgerAgingIncrement generalledgeragingincrement Increment
NetDueDate netduedate Net Due Date
OldestOpenItemNetDueDate oldestopenitemnetduedate Group Net Due Date
ExpectedCreditLossPercent expectedcreditlosspercent ECL Rate (%)
FinancialClosingGroupingRule grouping_rule Obsolete
FinClosingGroupingRuleStep grouping_rule_step Step of Grpng Rule
FinancialClosingGrouping group_id UUID
FinClosingLineItemDetailStatus line_item_status_detail Status Detail
InterestCalculationCode interest_indicator Interest Indic.
DiscountingAnnualInterestRate annual_interest_rate Interest Rate p.a.
DiscgFiscalPeriodInterestRate fis_period_interest_rate Rate per Period
DiscgDurationInFiscalPeriods discounting_duration Durations
NrOfDiscountedFiscalPeriods cummulative_periods Cum. Periods
LongTrmAstLbltyDiscountFactor discounting_factor Discounting Factor
FinancialClosingValuationRule valuation_rule Rule
FinClosingValuationRuleStep valuation_rule_step Rule Step
PrdcssrPerdEndClsgRunRsltUUID prdcssrperdendclsgrunrsltuuid Predecessor Result List UUID

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 I_JrnlPerdEndClsgRunLogResult.
-- 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: IFICLSRUNLOGLT

CREATE VIEW I_JrnlPerdEndClsgRunLogResult AS
SELECT
  JrnlPerdEndClsgRunResultUUID,
  JrnlPeriodEndClosingRunLogUUID,
  Ledger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  FinancialClosingLineItemStatus,
  FinClsgRunRsltAmtInFDCrcy1,
  FinClsgRunRsltAmtInFDCrcy2,
  FinClsgRunRsltAmtInFDCrcy3,
  FinClsgRunRsltAmtInFDCrcy4,
  FinClsgRunRsltAmtInFDCrcy5,
  FinClsgRunRsltAmtInFDCrcy6,
  FinClsgRunRsltAmtInFDCrcy7,
  FinClsgRunRsltAmtInFDCrcy8,
  FreeDefinedCurrency1,
  FreeDefinedCurrency2,
  FreeDefinedCurrency3,
  FreeDefinedCurrency4,
  FreeDefinedCurrency5,
  FreeDefinedCurrency6,
  FreeDefinedCurrency7,
  FreeDefinedCurrency8,
  ExchangeRate,
  FinClosingRunIsTestExecution,
  FinancialClosingLineItemType,
  SubLedgerAcctLineItemType,
  FinClosingEntryCalculationType,
  CreditRiskClass,
  GeneralLedgerAgingIncrement,
  NetDueDate,
  OldestOpenItemNetDueDate,
  ExpectedCreditLossPercent,
  grouping_rule AS FinancialClosingGroupingRule,
  grouping_rule_step AS FinClosingGroupingRuleStep,
  group_id AS FinancialClosingGrouping,
  line_item_status_detail AS FinClosingLineItemDetailStatus,
  interest_indicator AS InterestCalculationCode,
  annual_interest_rate AS DiscountingAnnualInterestRate,
  fis_period_interest_rate AS DiscgFiscalPeriodInterestRate,
  discounting_duration AS DiscgDurationInFiscalPeriods,
  cummulative_periods AS NrOfDiscountedFiscalPeriods,
  discounting_factor AS LongTrmAstLbltyDiscountFactor,
  valuation_rule AS FinancialClosingValuationRule,
  valuation_rule_step AS FinClosingValuationRuleStep,
  PrdcssrPerdEndClsgRunRsltUUID
FROM fins_cls_run_rl2
;

Learn More