P_FIVALUATIONRESULTLISTTMP

DDL: P_FIVALUATIONRESULTLISTTMP SQL: PFIVALTMP Type: view COMPOSITE

P_FIVALUATIONRESULTLISTTMP is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_TempGLAccountLineItem, I_JrnlPerdEndClsgRunLogResult) and exposes 129 fields with key field JrnlPerdEndClsgRunResultUUID.

Data Sources (2)

SourceAliasJoin Type
I_TempGLAccountLineItem acdoc_tmp from
I_JrnlPerdEndClsgRunLogResult result_list_tmp inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PFIVALTMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (129)

KeyFieldSource TableSource FieldDescription
KEY JrnlPerdEndClsgRunResultUUID JrnlPerdEndClsgRunResultUUID
Ledger I_TempGLAccountLineItem Ledger
CompanyCode I_TempGLAccountLineItem CompanyCode
FiscalYear I_TempGLAccountLineItem FiscalYear
AccountingDocument I_TempGLAccountLineItem AccountingDocument
LedgerGLLineItem I_TempGLAccountLineItem LedgerGLLineItem
JrnlPeriodEndClosingRunLogUUID I_TempGLAccountLineItem JrnlPeriodEndClosingRunLogUUID
BalanceTransactionCurrency I_TempGLAccountLineItem BalanceTransactionCurrency
AmountInBalanceTransacCrcy I_TempGLAccountLineItem AmountInBalanceTransacCrcy
CompanyCodeCurrency I_TempGLAccountLineItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_TempGLAccountLineItem AmountInCompanyCodeCurrency
GlobalCurrency I_TempGLAccountLineItem GlobalCurrency
AmountInGlobalCurrency I_TempGLAccountLineItem AmountInGlobalCurrency
FreeDefinedCurrency1 I_TempGLAccountLineItem FreeDefinedCurrency1
AmountInFreeDefinedCurrency1 I_TempGLAccountLineItem AmountInFreeDefinedCurrency1
FreeDefinedCurrency2 I_TempGLAccountLineItem FreeDefinedCurrency2
AmountInFreeDefinedCurrency2 I_TempGLAccountLineItem AmountInFreeDefinedCurrency2
FreeDefinedCurrency3 I_TempGLAccountLineItem FreeDefinedCurrency3
AmountInFreeDefinedCurrency3 I_TempGLAccountLineItem AmountInFreeDefinedCurrency3
FreeDefinedCurrency4 I_TempGLAccountLineItem FreeDefinedCurrency4
AmountInFreeDefinedCurrency4 I_TempGLAccountLineItem AmountInFreeDefinedCurrency4
FreeDefinedCurrency5 I_TempGLAccountLineItem FreeDefinedCurrency5
AmountInFreeDefinedCurrency5 I_TempGLAccountLineItem AmountInFreeDefinedCurrency5
FreeDefinedCurrency6 I_TempGLAccountLineItem FreeDefinedCurrency6
AmountInFreeDefinedCurrency6 I_TempGLAccountLineItem AmountInFreeDefinedCurrency6
FreeDefinedCurrency7 I_TempGLAccountLineItem FreeDefinedCurrency7
AmountInFreeDefinedCurrency7 I_TempGLAccountLineItem AmountInFreeDefinedCurrency7
FreeDefinedCurrency8 I_TempGLAccountLineItem FreeDefinedCurrency8
AmountInFreeDefinedCurrency8 I_TempGLAccountLineItem AmountInFreeDefinedCurrency8
FinancialTransactionType I_TempGLAccountLineItem FinancialTransactionType
ProfitCenter I_TempGLAccountLineItem ProfitCenter
SalesOrder I_TempGLAccountLineItem SalesOrder
SalesOrderItem I_TempGLAccountLineItem SalesOrderItem
Supplier I_TempGLAccountLineItem Supplier
Customer I_TempGLAccountLineItem Customer
HouseBank I_TempGLAccountLineItem HouseBank
HouseBankAccount I_TempGLAccountLineItem HouseBankAccount
CostCtrActivityType I_TempGLAccountLineItem CostCtrActivityType
OrderID I_TempGLAccountLineItem OrderID
WBSElementInternalID I_TempGLAccountLineItem WBSElementInternalID
ProjectNetwork I_TempGLAccountLineItem ProjectNetwork
RelatedNetworkActivity I_TempGLAccountLineItem RelatedNetworkActivity
BusinessProcess I_TempGLAccountLineItem BusinessProcess
CostCenter I_TempGLAccountLineItem CostCenter
FunctionalArea I_TempGLAccountLineItem FunctionalArea
BusinessArea I_TempGLAccountLineItem BusinessArea
ControllingArea I_TempGLAccountLineItem ControllingArea
Segment I_TempGLAccountLineItem Segment
PartnerCostCenter I_TempGLAccountLineItem PartnerCostCenter
PartnerProfitCenter I_TempGLAccountLineItem PartnerProfitCenter
PartnerFunctionalArea I_TempGLAccountLineItem PartnerFunctionalArea
PartnerBusinessArea I_TempGLAccountLineItem PartnerBusinessArea
PartnerCompany I_TempGLAccountLineItem PartnerCompany
CostObject I_TempGLAccountLineItem CostObject
PartnerSegment I_TempGLAccountLineItem PartnerSegment
JointVenture I_TempGLAccountLineItem JointVenture
JointVentureEquityGroup I_TempGLAccountLineItem JointVentureEquityGroup
JointVentureCostRecoveryCode I_TempGLAccountLineItem JointVentureCostRecoveryCode
JointVenturePartner I_TempGLAccountLineItem JointVenturePartner
PartnerVenture I_TempGLAccountLineItem PartnerVenture
FinancialValuationObjectType I_TempGLAccountLineItem FinancialValuationObjectType
FinancialValuationObject I_TempGLAccountLineItem FinancialValuationObject
FinancialValuationSubobject I_TempGLAccountLineItem FinancialValuationSubobject
REBusinessEntity REBusinessEntity
RealEstateBuilding RealEstateBuilding
RealEstateProperty RealEstateProperty
GLAccount I_TempGLAccountLineItem GLAccount
OffsettingAccount I_TempGLAccountLineItem OffsettingAccount
SubLedgerAcctLineItemType I_TempGLAccountLineItem SubLedgerAcctLineItemType
ChartOfAccounts I_TempGLAccountLineItem ChartOfAccounts
PostingDate I_TempGLAccountLineItem PostingDate
AccountingDocumentCategory I_TempGLAccountLineItem AccountingDocumentCategory
IsOpenItemManaged I_TempGLAccountLineItem IsOpenItemManaged
ClearingDate I_TempGLAccountLineItem ClearingDate
ClearingAccountingDocument I_TempGLAccountLineItem ClearingAccountingDocument
ClearingDocFiscalYear I_TempGLAccountLineItem ClearingDocFiscalYear
FiscalPeriod I_TempGLAccountLineItem FiscalPeriod
PrdcssrJournalEntryCompanyCode I_TempGLAccountLineItem PrdcssrJournalEntryCompanyCode
PrdcssrJournalEntryFiscalYear I_TempGLAccountLineItem PrdcssrJournalEntryFiscalYear
PredecessorJournalEntry I_TempGLAccountLineItem PredecessorJournalEntry
PredecessorJournalEntryItem I_TempGLAccountLineItem PredecessorJournalEntryItem
InvoiceItemReference I_TempGLAccountLineItem InvoiceItemReference
InvoiceReference I_TempGLAccountLineItem InvoiceReference
InvoiceReferenceFiscalYear I_TempGLAccountLineItem InvoiceReferenceFiscalYear
FollowOnDocumentType I_TempGLAccountLineItem FollowOnDocumentType
AccountingDocumentItem I_TempGLAccountLineItem AccountingDocumentItem
BusinessTransactionType I_TempGLAccountLineItem BusinessTransactionType
FinancialAccountType I_TempGLAccountLineItem FinancialAccountType
GeneralLedgerAgingScope I_TempGLAccountLineItem GeneralLedgerAgingScope
PostedAgingIncrement I_TempGLAccountLineItem GeneralLedgerAgingIncrement
FinClsgRunRsltFDCrcy1 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency1
FinClsgRunRsltAmtInFDCrcy1 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy1
FinClsgRunRsltFDCrcy2 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency2
FinClsgRunRsltAmtInFDCrcy2 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy2
FinClsgRunRsltFDCrcy3 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency3
FinClsgRunRsltAmtInFDCrcy3 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy3
FinClsgRunRsltFDCrcy4 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency4
FinClsgRunRsltAmtInFDCrcy4 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy4
FinClsgRunRsltFDCrcy5 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency5
FinClsgRunRsltAmtInFDCrcy5 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy5
FinClsgRunRsltFDCrcy6 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency6
FinClsgRunRsltAmtInFDCrcy6 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy6
FinClsgRunRsltFDCrcy7 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency7
FinClsgRunRsltAmtInFDCrcy7 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy7
FinClsgRunRsltFDCrcy8 I_JrnlPerdEndClsgRunLogResult FreeDefinedCurrency8
FinClsgRunRsltAmtInFDCrcy8 I_JrnlPerdEndClsgRunLogResult FinClsgRunRsltAmtInFDCrcy8
ExchangeRate I_JrnlPerdEndClsgRunLogResult ExchangeRate
FinClosingRunIsTestExecution I_JrnlPerdEndClsgRunLogResult FinClosingRunIsTestExecution
FinancialClosingLineItemType I_JrnlPerdEndClsgRunLogResult FinancialClosingLineItemType
FinancialClosingLineItemStatus I_JrnlPerdEndClsgRunLogResult FinancialClosingLineItemStatus
FinClosingEntryCalculationType I_JrnlPerdEndClsgRunLogResult FinClosingEntryCalculationType
CreditRiskClass I_JrnlPerdEndClsgRunLogResult CreditRiskClass
GeneralLedgerAgingIncrement I_JrnlPerdEndClsgRunLogResult GeneralLedgerAgingIncrement
NetDueDate I_JrnlPerdEndClsgRunLogResult NetDueDate
OldestOpenItemNetDueDate I_JrnlPerdEndClsgRunLogResult OldestOpenItemNetDueDate
ExpectedCreditLossPercent I_JrnlPerdEndClsgRunLogResult ExpectedCreditLossPercent
FinancialClosingGroupingRule I_JrnlPerdEndClsgRunLogResult FinancialClosingGroupingRule
FinClosingGroupingRuleStep I_JrnlPerdEndClsgRunLogResult FinClosingGroupingRuleStep
FinancialClosingGrouping I_JrnlPerdEndClsgRunLogResult FinancialClosingGrouping
FinClosingLineItemDetailStatus I_JrnlPerdEndClsgRunLogResult FinClosingLineItemDetailStatus
InterestCalculationCode I_JrnlPerdEndClsgRunLogResult InterestCalculationCode
DiscountingAnnualInterestRate I_JrnlPerdEndClsgRunLogResult DiscountingAnnualInterestRate
DiscgFiscalPeriodInterestRate I_JrnlPerdEndClsgRunLogResult DiscgFiscalPeriodInterestRate
DiscgDurationInFiscalPeriods I_JrnlPerdEndClsgRunLogResult DiscgDurationInFiscalPeriods
NrOfDiscountedFiscalPeriods I_JrnlPerdEndClsgRunLogResult NrOfDiscountedFiscalPeriods
LongTrmAstLbltyDiscountFactor I_JrnlPerdEndClsgRunLogResult LongTrmAstLbltyDiscountFactor
FinancialClosingValuationRule I_JrnlPerdEndClsgRunLogResult FinancialClosingValuationRule
FinClosingValuationRuleStep I_JrnlPerdEndClsgRunLogResult FinClosingValuationRuleStep
PrdcssrPerdEndClsgRunRsltUUID I_JrnlPerdEndClsgRunLogResult PrdcssrPerdEndClsgRunRsltUUID
@AbapCatalog.sqlViewName: 'PFIVALTMP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
define view P_FIVALUATIONRESULTLISTTMP
  as select from I_TempGLAccountLineItem       as acdoc_tmp
    inner join   I_JrnlPerdEndClsgRunLogResult as result_list_tmp on  acdoc_tmp.Ledger                         = result_list_tmp.Ledger
                                                                  and acdoc_tmp.CompanyCode                    = result_list_tmp.CompanyCode
                                                                  and acdoc_tmp.FiscalYear                     = result_list_tmp.FiscalYear
                                                                  and acdoc_tmp.AccountingDocument             = result_list_tmp.AccountingDocument
                                                                  and acdoc_tmp.LedgerGLLineItem               = result_list_tmp.LedgerGLLineItem
                                                                  and acdoc_tmp.JrnlPeriodEndClosingRunLogUUID = result_list_tmp.JrnlPeriodEndClosingRunLogUUID
{
  key JrnlPerdEndClsgRunResultUUID,
      acdoc_tmp.Ledger,
      acdoc_tmp.CompanyCode,
      acdoc_tmp.FiscalYear,
      acdoc_tmp.AccountingDocument,
      acdoc_tmp.LedgerGLLineItem,
      acdoc_tmp.JrnlPeriodEndClosingRunLogUUID,
      acdoc_tmp.BalanceTransactionCurrency,
      acdoc_tmp.AmountInBalanceTransacCrcy,
      acdoc_tmp.CompanyCodeCurrency,
      acdoc_tmp.AmountInCompanyCodeCurrency,
      acdoc_tmp.GlobalCurrency,
      acdoc_tmp.AmountInGlobalCurrency,
      acdoc_tmp.FreeDefinedCurrency1,
      acdoc_tmp.AmountInFreeDefinedCurrency1,
      acdoc_tmp.FreeDefinedCurrency2,
      acdoc_tmp.AmountInFreeDefinedCurrency2,
      acdoc_tmp.FreeDefinedCurrency3,
      acdoc_tmp.AmountInFreeDefinedCurrency3,
      acdoc_tmp.FreeDefinedCurrency4,
      acdoc_tmp.AmountInFreeDefinedCurrency4,
      acdoc_tmp.FreeDefinedCurrency5,
      acdoc_tmp.AmountInFreeDefinedCurrency5,
      acdoc_tmp.FreeDefinedCurrency6,
      acdoc_tmp.AmountInFreeDefinedCurrency6,
      acdoc_tmp.FreeDefinedCurrency7,
      acdoc_tmp.AmountInFreeDefinedCurrency7,
      acdoc_tmp.FreeDefinedCurrency8,
      acdoc_tmp.AmountInFreeDefinedCurrency8,
      acdoc_tmp.FinancialTransactionType,
      acdoc_tmp.ProfitCenter,
      acdoc_tmp.SalesOrder,
      acdoc_tmp.SalesOrderItem,
      acdoc_tmp.Supplier,
      acdoc_tmp.Customer,
      acdoc_tmp.HouseBank,
      acdoc_tmp.HouseBankAccount,
      acdoc_tmp.CostCtrActivityType,
      acdoc_tmp.OrderID,
      acdoc_tmp.WBSElementInternalID,
      acdoc_tmp.ProjectNetwork,
      acdoc_tmp.RelatedNetworkActivity,
      acdoc_tmp.BusinessProcess,
      acdoc_tmp.CostCenter,
      acdoc_tmp.FunctionalArea,
      acdoc_tmp.BusinessArea,
      acdoc_tmp.ControllingArea,
      acdoc_tmp.Segment,
      acdoc_tmp.PartnerCostCenter,
      acdoc_tmp.PartnerProfitCenter,
      acdoc_tmp.PartnerFunctionalArea,
      acdoc_tmp.PartnerBusinessArea,
      acdoc_tmp.PartnerCompany,
      acdoc_tmp.CostObject,
      acdoc_tmp.PartnerSegment,
      acdoc_tmp.JointVenture,
      acdoc_tmp.JointVentureEquityGroup,
      acdoc_tmp.JointVentureCostRecoveryCode,
      acdoc_tmp.JointVenturePartner,
      acdoc_tmp.PartnerVenture,
      acdoc_tmp.FinancialValuationObjectType,
      acdoc_tmp.FinancialValuationObject,
      acdoc_tmp.FinancialValuationSubobject,
      REBusinessEntity,
      RealEstateBuilding,
      RealEstateProperty,

      acdoc_tmp.GLAccount,
      acdoc_tmp.OffsettingAccount,

      acdoc_tmp.SubLedgerAcctLineItemType,
      acdoc_tmp.ChartOfAccounts,
      acdoc_tmp.PostingDate,
      acdoc_tmp.AccountingDocumentCategory,
      acdoc_tmp.IsOpenItemManaged,
      acdoc_tmp.ClearingDate,
      acdoc_tmp.ClearingAccountingDocument,
      acdoc_tmp.ClearingDocFiscalYear,
      acdoc_tmp.FiscalPeriod,

      acdoc_tmp.PrdcssrJournalEntryCompanyCode,
      acdoc_tmp.PrdcssrJournalEntryFiscalYear,
      acdoc_tmp.PredecessorJournalEntry,
      acdoc_tmp.PredecessorJournalEntryItem,

      acdoc_tmp.InvoiceItemReference,
      acdoc_tmp.InvoiceReference,
      acdoc_tmp.InvoiceReferenceFiscalYear,
      acdoc_tmp.FollowOnDocumentType,
      acdoc_tmp.AccountingDocumentItem,
      acdoc_tmp.BusinessTransactionType,
      acdoc_tmp.FinancialAccountType,
      acdoc_tmp.GeneralLedgerAgingScope,
      acdoc_tmp.GeneralLedgerAgingIncrement as PostedAgingIncrement,

      //      result_list_tmp.FreeDefinedCurrency1,

      result_list_tmp.FreeDefinedCurrency1  as FinClsgRunRsltFDCrcy1,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy1,

      //      result_list_tmp.FreeDefinedCurrency2,

      result_list_tmp.FreeDefinedCurrency2  as FinClsgRunRsltFDCrcy2,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy2,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency3  as FinClsgRunRsltFDCrcy3,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy3,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency4  as FinClsgRunRsltFDCrcy4,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy4,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency5  as FinClsgRunRsltFDCrcy5,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy5,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency6  as FinClsgRunRsltFDCrcy6,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy6,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency7  as FinClsgRunRsltFDCrcy7,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy7,
      
            //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list_tmp.FreeDefinedCurrency8  as FinClsgRunRsltFDCrcy8,
      result_list_tmp.FinClsgRunRsltAmtInFDCrcy8,

      result_list_tmp.ExchangeRate,
      result_list_tmp.FinClosingRunIsTestExecution,
      result_list_tmp.FinancialClosingLineItemType,
      result_list_tmp.FinancialClosingLineItemStatus,
      result_list_tmp.FinClosingEntryCalculationType,
      result_list_tmp.CreditRiskClass,
      result_list_tmp.GeneralLedgerAgingIncrement,
      result_list_tmp.NetDueDate,
      result_list_tmp.OldestOpenItemNetDueDate,
      result_list_tmp.ExpectedCreditLossPercent,
      result_list_tmp.FinancialClosingGroupingRule,
      result_list_tmp.FinClosingGroupingRuleStep,
      result_list_tmp.FinancialClosingGrouping,
      result_list_tmp.FinClosingLineItemDetailStatus,
      result_list_tmp.InterestCalculationCode,
      result_list_tmp.DiscountingAnnualInterestRate,
      result_list_tmp.DiscgFiscalPeriodInterestRate,
      result_list_tmp.DiscgDurationInFiscalPeriods,
      result_list_tmp.NrOfDiscountedFiscalPeriods,
      result_list_tmp.LongTrmAstLbltyDiscountFactor,
      result_list_tmp.FinancialClosingValuationRule,
      result_list_tmp.FinClosingValuationRuleStep, 
      result_list_tmp.PrdcssrPerdEndClsgRunRsltUUID
}

where
 result_list_tmp.FinancialClosingLineItemStatus = 'T' //posted to acdoctemp

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JRNLPERDENDCLSGRUNLOGRESULT",
"I_TEMPGLACCOUNTLINEITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/