P_FIVALUATIONRESULTLIST

CDS View
103 Fields 6 CDS Views

P_FIVALUATIONRESULTLIST is a CDS View in S/4HANA. It contains 103 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
P_DiscountingResultListBase view_entity from COMPOSITE
P_DiscountingResultListBase view_entity union COMPOSITE
P_FI_CLS_FXV_RL view_entity from COMPOSITE
P_FI_CLS_IMP_RL view_entity from COMPOSITE
P_FI_CLS_REC_RL_base view_entity from COMPOSITE
P_FI_CLS_REC_RL_SRC_doc_base view_entity from COMPOSITE

Fields (103)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,key1,PrimaryKey1 4
KEY CompanyCode CompanyCode 5
KEY FiscalYear FiscalYear 5
KEY JrnlPerdEndClsgRunResultUUID JrnlPerdEndClsgRunResultUUID 4
KEY JrnlPeriodEndClosingRunLogUUID JrnlPeriodEndClosingRunLogUUID 4
KEY Ledger Ledger 5
KEY LedgerGLLineItem DISJrEntItforInterest,DISJrEntItforNPV,key2,LedgerGLLineItem,PrimaryKey2 4
AccountingDocumentCategory AccountingDocumentCategory 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 1
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 1
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 1
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 1
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 1
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 1
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
BalanceTransactionCurrency BalanceTransactionCurrency 2
BusinessArea BusinessArea 1
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 2
CompanyCodeCurrency CompanyCodeCurrency 2
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostCtrActivityType CostCtrActivityType 1
CostObject CostObject 1
CreditRiskClass CreditRiskClass 1
Customer Customer 5
DiscgFiscalPeriodInterestRate DiscgFiscalPeriodInterestRate 1
DiscountingAnnualInterestRate DiscountingAnnualInterestRate 1
ExchangeRate ValuationExchangeRate 1
FinancialClosingGrouping FinancialClosingGrouping 1
FinancialClosingGroupingRule FinancialClosingGroupingRule 1
FinancialClosingLineItemStatus FinancialClosingLineItemStatus 4
FinancialClosingLineItemType FinancialClosingLineItemType 4
FinancialClosingValuationRule FinancialClosingValuationRule 1
FinancialTransactionType FinancialTransactionType 1
FinancialValuationObject FinancialValuationObject 1
FinancialValuationObjectType FinancialValuationObjectType 1
FinancialValuationSubobject FinancialValuationSubobject 1
FinClosingEntryCalculationType FinClosingEntryCalculationType 1
FinClosingGroupingRuleStep FinClosingGroupingRuleStep 1
FinClosingLineItemDetailStatus FinClosingLineItemDetailStatus 3
FinClosingRunIsTestExecution FinClosingRunIsTestExecution 3
FinClosingValuationRuleStep FinClosingValuationRuleStep 1
FinClsgRunRsltAmtInFDCrcy1 FinClsgRunRsltAmtInFDCrcy1 2
FinClsgRunRsltAmtInFDCrcy2 FinClsgRunRsltAmtInFDCrcy2 1
FinClsgRunRsltAmtInFDCrcy3 FinClsgRunRsltAmtInFDCrcy3 1
FinClsgRunRsltAmtInFDCrcy4 FinClsgRunRsltAmtInFDCrcy4 1
FinClsgRunRsltAmtInFDCrcy5 FinClsgRunRsltAmtInFDCrcy5 1
FinClsgRunRsltAmtInFDCrcy6 FinClsgRunRsltAmtInFDCrcy6 1
FinClsgRunRsltFDCrcy1 FinClsgRunRsltFDCrcy1 1
FiscalPeriod FiscalPeriod 1
FreeDefinedCurrency1 FreeDefinedCurrency1 2
FreeDefinedCurrency2 FreeDefinedCurrency2 2
FreeDefinedCurrency3 FreeDefinedCurrency3 2
FreeDefinedCurrency4 FreeDefinedCurrency4 2
FreeDefinedCurrency5 FreeDefinedCurrency5 2
FreeDefinedCurrency6 FreeDefinedCurrency6 2
FreeDefinedCurrency7 FreeDefinedCurrency7 2
FreeDefinedCurrency8 FreeDefinedCurrency8 2
FunctionalArea FunctionalArea 1
GeneralLedgerAgingIncrement GeneralLedgerAgingIncrement 1
GLAccount GLAccount 2
GlobalCurrency GlobalCurrency 2
HouseBank HouseBank 1
HouseBankAccount HouseBankAccount 1
InterestCalculationCode InterestCalculationCode 1
InvoiceItemReference InvoiceItemReference 2
InvoiceReference InvoiceReference 2
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 2
JointVenture JointVenture 1
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
JointVentureEquityGroup JointVentureEquityGroup 1
JointVenturePartner JointVenturePartner 1
NetDueDate NetDueDate 2
OffsettingAccount OffsetAccountforInterest,OffsetAccountforNPV,OffsettingAccount 2
OldestOpenItemNetDueDate OldestOpenItemNetDueDate 1
OrderID OrderID 1
PartnerBusinessArea PartnerBusinessArea 1
PartnerCompany PartnerCompany 1
PartnerCostCenter PartnerCostCenter 1
PartnerFunctionalArea PartnerFunctionalArea 1
PartnerProfitCenter PartnerProfitCenter 1
PartnerSegment PartnerSegment 1
PartnerVenture PartnerVenture 1
PostingDate PostingDate 1
PrdcssrJournalEntryCompanyCode PrdcssrJournalEntryCompanyCode 1
PrdcssrJournalEntryFiscalYear PrdcssrJournalEntryFiscalYear 1
PrdcssrPerdEndClsgRunRsltUUID PrdcssrPerdEndClsgRunRsltUUID 1
PredecessorJournalEntry PredecessorJournalEntry 1
PredecessorJournalEntryItem PredecessorJournalEntryItem 1
ProfitCenter ProfitCenter 1
ProjectNetwork ProjectNetwork 1
RelatedNetworkActivity RelatedNetworkActivity 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
Segment Segment 1
SubLedgerAcctLineItemType SubLedgerAcctLineItemType 4
Supplier Supplier 5
WBSElementInternalID WBSElementInternalID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_FIVALUATIONRESULTLIST (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    JRNLPERDENDCLSGRUNRESULTUUID,
    JRNLPERIODENDCLOSINGRUNLOGUUID,
    LEDGER,
    LEDGERGLLINEITEM,
    ACCOUNTINGDOCUMENTCATEGORY,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    CREDITRISKCLASS,
    CUSTOMER,
    DISCGFISCALPERIODINTERESTRATE,
    DISCOUNTINGANNUALINTERESTRATE,
    EXCHANGERATE,
    FINANCIALCLOSINGGROUPING,
    FINANCIALCLOSINGGROUPINGRULE,
    FINANCIALCLOSINGLINEITEMSTATUS,
    FINANCIALCLOSINGLINEITEMTYPE,
    FINANCIALCLOSINGVALUATIONRULE,
    FINANCIALTRANSACTIONTYPE,
    FINANCIALVALUATIONOBJECT,
    FINANCIALVALUATIONOBJECTTYPE,
    FINANCIALVALUATIONSUBOBJECT,
    FINCLOSINGENTRYCALCULATIONTYPE,
    FINCLOSINGGROUPINGRULESTEP,
    FINCLOSINGLINEITEMDETAILSTATUS,
    FINCLOSINGRUNISTESTEXECUTION,
    FINCLOSINGVALUATIONRULESTEP,
    FINCLSGRUNRSLTAMTINFDCRCY1,
    FINCLSGRUNRSLTAMTINFDCRCY2,
    FINCLSGRUNRSLTAMTINFDCRCY3,
    FINCLSGRUNRSLTAMTINFDCRCY4,
    FINCLSGRUNRSLTAMTINFDCRCY5,
    FINCLSGRUNRSLTAMTINFDCRCY6,
    FINCLSGRUNRSLTFDCRCY1,
    FISCALPERIOD,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    GENERALLEDGERAGINGINCREMENT,
    GLACCOUNT,
    GLOBALCURRENCY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREPARTNER,
    NETDUEDATE,
    OFFSETTINGACCOUNT,
    OLDESTOPENITEMNETDUEDATE,
    ORDERID,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PARTNERVENTURE,
    POSTINGDATE,
    PRDCSSRJOURNALENTRYCOMPANYCODE,
    PRDCSSRJOURNALENTRYFISCALYEAR,
    PRDCSSRPERDENDCLSGRUNRSLTUUID,
    PREDECESSORJOURNALENTRY,
    PREDECESSORJOURNALENTRYITEM,
    PROFITCENTER,
    PROJECTNETWORK,
    RELATEDNETWORKACTIVITY,
    SALESORDER,
    SALESORDERITEM,
    SEGMENT,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, JRNLPERDENDCLSGRUNRESULTUUID, JRNLPERIODENDCLOSINGRUNLOGUUID, LEDGER, LEDGERGLLINEITEM)
);

Learn More