P_FIVALUATIONRESULTLIST

CDS View
114 Fields 7 CDS Views

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

CDS Views using this table (7)

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_mig_RL_BASE 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 (114)

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

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,
    ACCOUNTINGDOCUMENTITEM,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    CREDITRISKCLASS,
    CUSTOMER,
    DISCGFISCALPERIODINTERESTRATE,
    DISCOUNTINGANNUALINTERESTRATE,
    EXCHANGERATE,
    EXPECTEDCREDITLOSSPERCENT,
    FINANCIALCLOSINGGROUPING,
    FINANCIALCLOSINGGROUPINGRULE,
    FINANCIALCLOSINGLINEITEMSTATUS,
    FINANCIALCLOSINGLINEITEMTYPE,
    FINANCIALCLOSINGVALUATIONRULE,
    FINANCIALTRANSACTIONTYPE,
    FINANCIALVALUATIONOBJECT,
    FINANCIALVALUATIONOBJECTTYPE,
    FINANCIALVALUATIONSUBOBJECT,
    FINCLOSINGENTRYCALCULATIONTYPE,
    FINCLOSINGGROUPINGRULESTEP,
    FINCLOSINGLINEITEMDETAILSTATUS,
    FINCLOSINGRUNISTESTEXECUTION,
    FINCLOSINGVALUATIONRULESTEP,
    FINCLSGRUNRSLTAMTINFDCRCY1,
    FINCLSGRUNRSLTAMTINFDCRCY2,
    FINCLSGRUNRSLTAMTINFDCRCY3,
    FINCLSGRUNRSLTAMTINFDCRCY4,
    FINCLSGRUNRSLTAMTINFDCRCY5,
    FINCLSGRUNRSLTAMTINFDCRCY6,
    FINCLSGRUNRSLTFDCRCY1,
    FINCLSGRUNRSLTFDCRCY2,
    FISCALPERIOD,
    FOLLOWONDOCUMENTTYPE,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    GENERALLEDGERAGINGINCREMENT,
    GLACCOUNT,
    GLOBALCURRENCY,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    INTERESTCALCULATIONCODE,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    ISOPENITEMMANAGED,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREPARTNER,
    NETDUEDATE,
    OFFSETTINGACCOUNT,
    OLDESTOPENITEMNETDUEDATE,
    ORDERID,
    PARTNERBUSINESSAREA,
    PARTNERCOMPANY,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREA,
    PARTNERPROFITCENTER,
    PARTNERSEGMENT,
    PARTNERVENTURE,
    POSTINGDATE,
    PRDCSSRJOURNALENTRYCOMPANYCODE,
    PRDCSSRJOURNALENTRYFISCALYEAR,
    PRDCSSRPERDENDCLSGRUNRSLTUUID,
    PREDECESSORJOURNALENTRY,
    PREDECESSORJOURNALENTRYITEM,
    PROFITCENTER,
    PROJECTNETWORK,
    REALESTATEBUILDING,
    REALESTATEPROPERTY,
    REBUSINESSENTITY,
    RELATEDNETWORKACTIVITY,
    SALESORDER,
    SALESORDERITEM,
    SEGMENT,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, JRNLPERDENDCLSGRUNRESULTUUID, JRNLPERIODENDCLOSINGRUNLOGUUID, LEDGER, LEDGERGLLINEITEM)
);

Learn More