I_JRNLPERDENDCLSGRUNLOGRESULT

CDS View

Related results of period end closing run log entry

I_JRNLPERDENDCLSGRUNLOGRESULT is a CDS View in S/4HANA. Related results of period end closing run log entry. It contains 47 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 47 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_FIVALUATIONRESULTLISTORI view_entity inner COMPOSITE fi valuation result list original
P_FIVALUATIONRESULTLISTTMP view inner COMPOSITE fi valuation result list temporary
P_FXRUNFROM00 view_entity from COMPOSITE FX Run result lists source from 00
P_FXRUNNOTFROM00 view_entity from COMPOSITE FX Run result lists not source from 00

Fields (47)

KeyField CDS FieldsUsed in Views
KEY JrnlPerdEndClsgRunResultUUID JrnlPerdEndClsgRunResultUUID 3
AccountingDocument AccountingDocument 2
CompanyCode CompanyCode 2
CreditRiskClass CreditRiskClass 2
DiscgDurationInFiscalPeriods DiscgDurationInFiscalPeriods 2
DiscgFiscalPeriodInterestRate DiscgFiscalPeriodInterestRate 2
DiscountingAnnualInterestRate DiscountingAnnualInterestRate 2
ExchangeRate ExchangeRate 2
ExpectedCreditLossPercent ExpectedCreditLossPercent 2
FinancialClosingGrouping FinancialClosingGrouping 4
FinancialClosingGroupingRule FinancialClosingGroupingRule 4
FinancialClosingLineItemStatus FinancialClosingLineItemStatus 4
FinancialClosingLineItemType FinancialClosingLineItemType 4
FinancialClosingValuationRule FinancialClosingValuationRule 4
FinClosingEntryCalculationType FinClosingEntryCalculationType 4
FinClosingGroupingRuleStep FinClosingGroupingRuleStep 4
FinClosingLineItemDetailStatus FinClosingLineItemDetailStatus 4
FinClosingRunIsTestExecution FinClosingRunIsTestExecution 4
FinClosingValuationRuleStep FinClosingValuationRuleStep 4
FinClsgRunRsltAmtInFDCrcy1 FinClsgRunRsltAmtInFDCrcy1 2
FinClsgRunRsltAmtInFDCrcy2 FinClsgRunRsltAmtInFDCrcy2 2
FinClsgRunRsltAmtInFDCrcy3 FinClsgRunRsltAmtInFDCrcy3 2
FinClsgRunRsltAmtInFDCrcy4 FinClsgRunRsltAmtInFDCrcy4 2
FinClsgRunRsltAmtInFDCrcy5 FinClsgRunRsltAmtInFDCrcy5 2
FinClsgRunRsltAmtInFDCrcy6 FinClsgRunRsltAmtInFDCrcy6 2
FinClsgRunRsltAmtInFDCrcy7 FinClsgRunRsltAmtInFDCrcy7 2
FinClsgRunRsltAmtInFDCrcy8 FinClsgRunRsltAmtInFDCrcy8 2
FiscalYear FiscalYear 2
FreeDefinedCurrency1 FinClsgRunRsltFDCrcy1 2
FreeDefinedCurrency2 FinClsgRunRsltFDCrcy2 2
FreeDefinedCurrency3 FinClsgRunRsltFDCrcy3 2
FreeDefinedCurrency4 FinClsgRunRsltFDCrcy4 2
FreeDefinedCurrency5 FinClsgRunRsltFDCrcy5 2
FreeDefinedCurrency6 FinClsgRunRsltFDCrcy6 2
FreeDefinedCurrency7 FinClsgRunRsltFDCrcy7 2
FreeDefinedCurrency8 FinClsgRunRsltFDCrcy8 2
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement 2
InterestCalculationCode InterestCalculationCode 2
JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID 3
Ledger Ledger 2
LedgerGLLineItem LedgerGLLineItem 2
LongTrmAstLbltyDiscountFactor LongTrmAstLbltyDiscountFactor 2
NetDueDate NetDueDate 4
NrOfDiscountedFiscalPeriods NrOfDiscountedFiscalPeriods 2
OldestOpenItemNetDueDate OldestOpenItemNetDueDate 4
PrdcssrPerdEndClsgRunRsltUUID PrdcssrPerdEndClsgRunRsltUUID 4
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 2 
@AbapCatalog.sqlViewName: 'IFICLSRUNLOGLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Related results of period end closing run log entry'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
                usageType.serviceQuality: #B,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #TRANSACTIONAL }
@VDM.viewType: #BASIC

define view I_JrnlPerdEndClsgRunLogResult
  as select from fins_cls_run_rl2
{
  key jrnlperdendclsgrunresultuuid   as JrnlPerdEndClsgRunResultUUID,
      jrnlperiodendclosingrunloguuid as JrnlPeriodEndClosingRunLogUUID,
      ledger                         as Ledger,
      companycode                    as CompanyCode,
      fiscalyear                     as FiscalYear,
      accountingdocument             as AccountingDocument,
      ledgergllineitem               as LedgerGLLineItem,
      financialclosinglineitemstatus as FinancialClosingLineItemStatus,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      finclsgrunrsltamtinfdcrcy1     as FinClsgRunRsltAmtInFDCrcy1,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      finclsgrunrsltamtinfdcrcy2     as FinClsgRunRsltAmtInFDCrcy2,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      finclsgrunrsltamtinfdcrcy3     as FinClsgRunRsltAmtInFDCrcy3,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      finclsgrunrsltamtinfdcrcy4     as FinClsgRunRsltAmtInFDCrcy4,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      finclsgrunrsltamtinfdcrcy5     as FinClsgRunRsltAmtInFDCrcy5,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      finclsgrunrsltamtinfdcrcy6     as FinClsgRunRsltAmtInFDCrcy6,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      finclsgrunrsltamtinfdcrcy7     as FinClsgRunRsltAmtInFDCrcy7,
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      finclsgrunrsltamtinfdcrcy8     as FinClsgRunRsltAmtInFDCrcy8,
      freedefinedcurrency1           as FreeDefinedCurrency1,
      freedefinedcurrency2           as FreeDefinedCurrency2,
      freedefinedcurrency3           as FreeDefinedCurrency3,
      freedefinedcurrency4           as FreeDefinedCurrency4,
      freedefinedcurrency5           as FreeDefinedCurrency5,
      freedefinedcurrency6           as FreeDefinedCurrency6,
      freedefinedcurrency7           as FreeDefinedCurrency7,
      freedefinedcurrency8           as FreeDefinedCurrency8,
      exchangerate                   as ExchangeRate,
      finclosingrunistestexecution   as FinClosingRunIsTestExecution,
      financialclosinglineitemtype   as FinancialClosingLineItemType,
      subledgeracctlineitemtype      as SubLedgerAcctLineItemType,
      finclosingentrycalculationtype as FinClosingEntryCalculationType,
      creditriskclass                as CreditRiskClass,
      generalledgeragingincrement    as GeneralLedgerAgingIncrement,
      netduedate                     as NetDueDate,
      oldestopenitemnetduedate       as OldestOpenItemNetDueDate,
      expectedcreditlosspercent      as 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  as PrdcssrPerdEndClsgRunRsltUUID
}

Learn More