P_FIVALUATIONRESULTLIST
Output common FI valuation
P_FIVALUATIONRESULTLIST is a Composite CDS View that provides data about "Output common FI valuation" in SAP S/4HANA. It reads from 2 data sources (P_FIVALUATIONRESULTLISTORI, P_FIVALUATIONRESULTLISTTMP) and exposes 258 fields with key field JrnlPerdEndClsgRunResultUUID. Part of development package FINS_FI_CLS_VAL_COMMON.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| P_FIVALUATIONRESULTLISTORI | P_FIVALUATIONRESULTLISTORI | from |
| P_FIVALUATIONRESULTLISTTMP | P_FIVALUATIONRESULTLISTTMP | union_all |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_ALLOWED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (258)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | JrnlPerdEndClsgRunResultUUID | JrnlPerdEndClsgRunResultUUID | Result List UUID | |
| Ledger | Ledger | Ledger | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| FiscalYear | FiscalYear | G/L Fiscal Year | ||
| AccountingDocument | AccountingDocument | Journal Entry | ||
| LedgerGLLineItem | LedgerGLLineItem | Journal Entry Item | ||
| IsReversed | IsReversed | Reversed? | ||
| JrnlPeriodEndClosingRunLogUUID | JrnlPeriodEndClosingRunLogUUID | Closing Run UUID | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| CompanyCodeCurrency | CompanyCodeCurrency | Local Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| AmountInGlobalCurrency | AmountInGlobalCurrency | Amount in Global Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FinancialTransactionType | FinancialTransactionType | Transact. Type | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| SalesOrder | SalesOrder | SD Document | ||
| SalesOrderItem | SalesOrderItem | Sales Order Item | ||
| Supplier | Supplier | Supplier | ||
| Customer | Customer | Sold-to Party | ||
| HouseBank | HouseBank | House Bank | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| OrderID | OrderID | Order ID | ||
| WBSElementInternalID | WBSElementInternalID | WBS Internal ID | ||
| ProjectNetwork | ProjectNetwork | Order | ||
| RelatedNetworkActivity | RelatedNetworkActivity | Netwk activity | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| CostCenter | CostCenter | Cost Center | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| BusinessArea | BusinessArea | Business Area | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| Segment | Segment | Segment number | ||
| PartnerCostCenter | PartnerCostCenter | Sender Cost Ctr | ||
| PartnerProfitCenter | PartnerProfitCenter | Profit Center | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Rec. Fntcl Area | ||
| PartnerBusinessArea | PartnerBusinessArea | Trdg Part.BA | ||
| PartnerCompany | PartnerCompany | Trading Partner | ||
| CostObject | CostObject | Cost Object | ||
| PartnerSegment | PartnerSegment | Partner Segment | ||
| JointVenture | JointVenture | Joint venture | ||
| JointVentureEquityGroup | JointVentureEquityGroup | Joint Venture Equity Group | ||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | Recovery Ind. | ||
| JointVenturePartner | JointVenturePartner | Joint Venture Partner | ||
| PartnerVenture | PartnerVenture | PartnerVenture | ||
| FinancialValuationObjectType | FinancialValuationObjectType | Type of Fin.Val.Obj. | ||
| FinancialValuationObject | FinancialValuationObject | Fin Valuation Object | ||
| FinancialValuationSubobject | FinancialValuationSubobject | Fin.Val.Sub.Object | ||
| REBusinessEntity | REBusinessEntity | RE Business Entity | ||
| RealEstateBuilding | RealEstateBuilding | Building | ||
| RealEstateProperty | RealEstateProperty | Land | ||
| GLAccount | GLAccount | General Ledger | ||
| OffsettingAccount | OffsettingAccount | Offsetting Acct | ||
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | SLALineItemType | ||
| ChartOfAccounts | ChartOfAccounts | Node Class | ||
| PostingDate | PostingDate | Posting Date for GR | ||
| AccountingDocumentCategory | AccountingDocumentCategory | Journal Entry Category | ||
| IsOpenItemManaged | IsOpenItemManaged | Open Item Management | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry | ||
| ClearingDocFiscalYear | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| FiscalPeriod | FiscalPeriod | Tax period | ||
| PrdcssrJournalEntryCompanyCode | PrdcssrJournalEntryCompanyCode | Predecessor Journal Entry Company Code | ||
| PrdcssrJournalEntryFiscalYear | PrdcssrJournalEntryFiscalYear | Predecessor Journal Entry Fiscal Year | ||
| PredecessorJournalEntry | PredecessorJournalEntry | Predecessor Journal Entry | ||
| PredecessorJournalEntryItem | PredecessorJournalEntryItem | Predecessor Journal Entry Item | ||
| InvoiceItemReference | InvoiceItemReference | Item | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| AccountingDocumentItem | AccountingDocumentItem | Posting View Item | ||
| BusinessTransactionType | BusinessTransactionType | Bus.transaction | ||
| FinClsgRunRsltFDCrcy1 | FinClsgRunRsltFDCrcy1 | Freely Defined Currency 1 | ||
| FinClsgRunRsltAmtInFDCrcy1 | FinClsgRunRsltAmtInFDCrcy1 | Amount in Currency 1 | ||
| FinClsgRunRsltFDCrcy2 | FinClsgRunRsltFDCrcy2 | Freely Defined Currency 2 | ||
| FinClsgRunRsltAmtInFDCrcy2 | FinClsgRunRsltAmtInFDCrcy2 | Amount in Currency 2 | ||
| FinClsgRunRsltFDCrcy3 | FinClsgRunRsltFDCrcy3 | Freely Defined Currency 3 | ||
| FinClsgRunRsltAmtInFDCrcy3 | FinClsgRunRsltAmtInFDCrcy3 | Amount in Currency 3 | ||
| FinClsgRunRsltFDCrcy4 | FinClsgRunRsltFDCrcy4 | Freely Defined Currency 4 | ||
| FinClsgRunRsltAmtInFDCrcy4 | FinClsgRunRsltAmtInFDCrcy4 | Amount in Currency 4 | ||
| FinClsgRunRsltFDCrcy5 | FinClsgRunRsltFDCrcy5 | Freely Defined Currency 5 | ||
| FinClsgRunRsltAmtInFDCrcy5 | FinClsgRunRsltAmtInFDCrcy5 | Amount in Currency 5 | ||
| FinClsgRunRsltFDCrcy6 | FinClsgRunRsltFDCrcy6 | Freely Defined Currency 6 | ||
| FinClsgRunRsltAmtInFDCrcy6 | FinClsgRunRsltAmtInFDCrcy6 | Amount in Currency 6 | ||
| FinClsgRunRsltFDCrcy7 | FinClsgRunRsltFDCrcy7 | Freely Defined Currency 7 | ||
| FinClsgRunRsltAmtInFDCrcy7 | FinClsgRunRsltAmtInFDCrcy7 | Amount in Currency 7 | ||
| FinClsgRunRsltFDCrcy8 | FinClsgRunRsltFDCrcy8 | Freely Defined Currency 8 | ||
| FinClsgRunRsltAmtInFDCrcy8 | FinClsgRunRsltAmtInFDCrcy8 | Amount in Currency 8 | ||
| ExchangeRate | ExchangeRate | Exchange rate | ||
| FinClosingRunIsTestExecution | FinClosingRunIsTestExecution | Test Run | ||
| FinancialClosingLineItemType | FinancialClosingLineItemType | Line Item Type | ||
| FinancialClosingLineItemStatus | FinancialClosingLineItemStatus | Status | ||
| 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 | FinancialClosingGroupingRule | |||
| FinClosingGroupingRuleStep | FinClosingGroupingRuleStep | |||
| FinancialClosingGrouping | FinancialClosingGrouping | |||
| FinClosingLineItemDetailStatus | FinClosingLineItemDetailStatus | Status Detail | ||
| InterestCalculationCode | InterestCalculationCode | Interest Indic. | ||
| DiscountingAnnualInterestRate | DiscountingAnnualInterestRate | |||
| DiscgFiscalPeriodInterestRate | DiscgFiscalPeriodInterestRate | |||
| DiscgDurationInFiscalPeriods | DiscgDurationInFiscalPeriods | |||
| NrOfDiscountedFiscalPeriods | NrOfDiscountedFiscalPeriods | |||
| LongTrmAstLbltyDiscountFactor | LongTrmAstLbltyDiscountFactor | |||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| FinancialClosingValuationRule | FinancialClosingValuationRule | |||
| FinClosingValuationRuleStep | FinClosingValuationRuleStep | |||
| GeneralLedgerAgingScope | GeneralLedgerAgingScope | Aging | ||
| PostedAgingIncrement | PostedAgingIncrement | Increment | ||
| Ledger | Ledger | Ledger | ||
| CompanyCode | CompanyCode | Receiver Company Code | ||
| FiscalYear | FiscalYear | G/L Fiscal Year | ||
| AccountingDocument | AccountingDocument | Journal Entry | ||
| LedgerGLLineItem | LedgerGLLineItem | Journal Entry Item | ||
| IsReversed | Reversed? | |||
| JrnlPeriodEndClosingRunLogUUID | JrnlPeriodEndClosingRunLogUUID | Closing Run UUID | ||
| BalanceTransactionCurrency | BalanceTransactionCurrency | Currency | ||
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | ||
| CompanyCodeCurrency | CompanyCodeCurrency | Local Currency | ||
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | Local Crcy Amt | ||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| AmountInGlobalCurrency | AmountInGlobalCurrency | Amount in Global Currency | ||
| FreeDefinedCurrency1 | FreeDefinedCurrency1 | Freely Defined Currency 1 | ||
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | ||
| FreeDefinedCurrency2 | FreeDefinedCurrency2 | Freely Defined Currency 2 | ||
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | ||
| FreeDefinedCurrency3 | FreeDefinedCurrency3 | Freely Defined Currency 3 | ||
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | ||
| FreeDefinedCurrency4 | FreeDefinedCurrency4 | Freely Defined Currency 4 | ||
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | ||
| FreeDefinedCurrency5 | FreeDefinedCurrency5 | Freely Defined Currency 5 | ||
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | ||
| FreeDefinedCurrency6 | FreeDefinedCurrency6 | Freely Defined Currency 6 | ||
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | ||
| FreeDefinedCurrency7 | FreeDefinedCurrency7 | Freely Defined Currency 7 | ||
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | ||
| FreeDefinedCurrency8 | FreeDefinedCurrency8 | Freely Defined Currency 8 | ||
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | ||
| FinancialTransactionType | FinancialTransactionType | Transact. Type | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| SalesOrder | SalesOrder | SD Document | ||
| SalesOrderItem | SalesOrderItem | Sales Order Item | ||
| Supplier | Supplier | Supplier | ||
| Customer | Customer | Sold-to Party | ||
| HouseBank | HouseBank | House Bank | ||
| HouseBankAccount | HouseBankAccount | House Bank Account | ||
| CostCtrActivityType | CostCtrActivityType | Activity Type | ||
| OrderID | OrderID | Order ID | ||
| WBSElementInternalID | WBSElementInternalID | WBS Internal ID | ||
| ProjectNetwork | ProjectNetwork | Order | ||
| RelatedNetworkActivity | RelatedNetworkActivity | Netwk activity | ||
| BusinessProcess | BusinessProcess | Business Process | ||
| CostCenter | CostCenter | Cost Center | ||
| FunctionalArea | FunctionalArea | Sendr Fctl Area | ||
| BusinessArea | BusinessArea | Business Area | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| Segment | Segment | Segment number | ||
| PartnerCostCenter | PartnerCostCenter | Sender Cost Ctr | ||
| PartnerProfitCenter | PartnerProfitCenter | Profit Center | ||
| PartnerFunctionalArea | PartnerFunctionalArea | Rec. Fntcl Area | ||
| PartnerBusinessArea | PartnerBusinessArea | Trdg Part.BA | ||
| PartnerCompany | PartnerCompany | Trading Partner | ||
| CostObject | CostObject | Cost Object | ||
| PartnerSegment | PartnerSegment | Partner Segment | ||
| JointVenture | JointVenture | Joint venture | ||
| JointVentureEquityGroup | JointVentureEquityGroup | Joint Venture Equity Group | ||
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | Recovery Ind. | ||
| JointVenturePartner | JointVenturePartner | Joint Venture Partner | ||
| PartnerVenture | PartnerVenture | PartnerVenture | ||
| FinancialValuationObjectType | FinancialValuationObjectType | Type of Fin.Val.Obj. | ||
| FinancialValuationObject | FinancialValuationObject | Fin Valuation Object | ||
| FinancialValuationSubobject | FinancialValuationSubobject | Fin.Val.Sub.Object | ||
| REBusinessEntity | REBusinessEntity | RE Business Entity | ||
| RealEstateBuilding | RealEstateBuilding | Building | ||
| RealEstateProperty | RealEstateProperty | Land | ||
| GLAccount | GLAccount | General Ledger | ||
| OffsettingAccount | OffsettingAccount | Offsetting Acct | ||
| SubLedgerAcctLineItemType | SubLedgerAcctLineItemType | SLALineItemType | ||
| ChartOfAccounts | ChartOfAccounts | Node Class | ||
| PostingDate | PostingDate | Posting Date for GR | ||
| AccountingDocumentCategory | AccountingDocumentCategory | Journal Entry Category | ||
| IsOpenItemManaged | IsOpenItemManaged | Open Item Management | ||
| ClearingDate | ClearingDate | Clearing Date | ||
| ClearingAccountingDocument | ClearingAccountingDocument | Clearing Journal Entry | ||
| ClearingDocFiscalYear | ClearingDocFiscalYear | Fiscal Year of Clearing Journal Entry | ||
| FiscalPeriod | FiscalPeriod | Tax period | ||
| PrdcssrJournalEntryCompanyCode | PrdcssrJournalEntryCompanyCode | Predecessor Journal Entry Company Code | ||
| PrdcssrJournalEntryFiscalYear | PrdcssrJournalEntryFiscalYear | Predecessor Journal Entry Fiscal Year | ||
| PredecessorJournalEntry | PredecessorJournalEntry | Predecessor Journal Entry | ||
| PredecessorJournalEntryItem | PredecessorJournalEntryItem | Predecessor Journal Entry Item | ||
| InvoiceItemReference | InvoiceItemReference | Item | ||
| InvoiceReference | InvoiceReference | Invoice Reference | ||
| InvoiceReferenceFiscalYear | InvoiceReferenceFiscalYear | Invoice Reference Fiscal Year | ||
| FollowOnDocumentType | FollowOnDocumentType | Follow-On Document Type | ||
| AccountingDocumentItem | AccountingDocumentItem | Posting View Item | ||
| BusinessTransactionType | BusinessTransactionType | Bus.transaction | ||
| FinClsgRunRsltFDCrcy1 | FinClsgRunRsltFDCrcy1 | Freely Defined Currency 1 | ||
| FinClsgRunRsltAmtInFDCrcy1 | FinClsgRunRsltAmtInFDCrcy1 | Amount in Currency 1 | ||
| FinClsgRunRsltFDCrcy2 | FinClsgRunRsltFDCrcy2 | Freely Defined Currency 2 | ||
| FinClsgRunRsltAmtInFDCrcy2 | FinClsgRunRsltAmtInFDCrcy2 | Amount in Currency 2 | ||
| FinClsgRunRsltFDCrcy3 | FinClsgRunRsltFDCrcy3 | Freely Defined Currency 3 | ||
| FinClsgRunRsltAmtInFDCrcy3 | FinClsgRunRsltAmtInFDCrcy3 | Amount in Currency 3 | ||
| FinClsgRunRsltFDCrcy4 | FinClsgRunRsltFDCrcy4 | Freely Defined Currency 4 | ||
| FinClsgRunRsltAmtInFDCrcy4 | FinClsgRunRsltAmtInFDCrcy4 | Amount in Currency 4 | ||
| FinClsgRunRsltFDCrcy5 | FinClsgRunRsltFDCrcy5 | Freely Defined Currency 5 | ||
| FinClsgRunRsltAmtInFDCrcy5 | FinClsgRunRsltAmtInFDCrcy5 | Amount in Currency 5 | ||
| FinClsgRunRsltFDCrcy6 | FinClsgRunRsltFDCrcy6 | Freely Defined Currency 6 | ||
| FinClsgRunRsltAmtInFDCrcy6 | FinClsgRunRsltAmtInFDCrcy6 | Amount in Currency 6 | ||
| FinClsgRunRsltFDCrcy7 | FinClsgRunRsltFDCrcy7 | Freely Defined Currency 7 | ||
| FinClsgRunRsltAmtInFDCrcy7 | FinClsgRunRsltAmtInFDCrcy7 | Amount in Currency 7 | ||
| FinClsgRunRsltFDCrcy8 | FinClsgRunRsltFDCrcy8 | Freely Defined Currency 8 | ||
| FinClsgRunRsltAmtInFDCrcy8 | FinClsgRunRsltAmtInFDCrcy8 | Amount in Currency 8 | ||
| ExchangeRate | ExchangeRate | Exchange rate | ||
| FinClosingRunIsTestExecution | FinClosingRunIsTestExecution | Test Run | ||
| FinancialClosingLineItemType | FinancialClosingLineItemType | Line Item Type | ||
| FinancialClosingLineItemStatus | FinancialClosingLineItemStatus | Status | ||
| 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 | FinancialClosingGroupingRule | |||
| FinClosingGroupingRuleStep | FinClosingGroupingRuleStep | |||
| FinancialClosingGrouping | FinancialClosingGrouping | |||
| FinClosingLineItemDetailStatus | FinClosingLineItemDetailStatus | Status Detail | ||
| InterestCalculationCode | InterestCalculationCode | Interest Indic. | ||
| DiscountingAnnualInterestRate | DiscountingAnnualInterestRate | |||
| DiscgFiscalPeriodInterestRate | DiscgFiscalPeriodInterestRate | |||
| DiscgDurationInFiscalPeriods | DiscgDurationInFiscalPeriods | |||
| NrOfDiscountedFiscalPeriods | NrOfDiscountedFiscalPeriods | |||
| LongTrmAstLbltyDiscountFactor | LongTrmAstLbltyDiscountFactor | |||
| FinancialAccountType | FinancialAccountType | Fin. Account Type | ||
| FinancialClosingValuationRule | FinancialClosingValuationRule | |||
| FinClosingValuationRuleStep | FinClosingValuationRuleStep | |||
| GeneralLedgerAgingScope | GeneralLedgerAgingScope | Aging | ||
| PostedAgingIncrement | PostedAgingIncrement | Increment | ||
| 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 P_FIVALUATIONRESULTLIST.
-- 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.
CREATE VIEW P_FIVALUATIONRESULTLIST AS
SELECT
JrnlPerdEndClsgRunResultUUID,
Ledger,
CompanyCode,
FiscalYear,
AccountingDocument,
LedgerGLLineItem,
IsReversed,
JrnlPeriodEndClosingRunLogUUID,
BalanceTransactionCurrency,
AmountInBalanceTransacCrcy,
CompanyCodeCurrency,
AmountInCompanyCodeCurrency,
GlobalCurrency,
AmountInGlobalCurrency,
FreeDefinedCurrency1,
AmountInFreeDefinedCurrency1,
FreeDefinedCurrency2,
AmountInFreeDefinedCurrency2,
FreeDefinedCurrency3,
AmountInFreeDefinedCurrency3,
FreeDefinedCurrency4,
AmountInFreeDefinedCurrency4,
FreeDefinedCurrency5,
AmountInFreeDefinedCurrency5,
FreeDefinedCurrency6,
AmountInFreeDefinedCurrency6,
FreeDefinedCurrency7,
AmountInFreeDefinedCurrency7,
FreeDefinedCurrency8,
AmountInFreeDefinedCurrency8,
FinancialTransactionType,
ProfitCenter,
SalesOrder,
SalesOrderItem,
Supplier,
Customer,
HouseBank,
HouseBankAccount,
CostCtrActivityType,
OrderID,
WBSElementInternalID,
ProjectNetwork,
RelatedNetworkActivity,
BusinessProcess,
CostCenter,
FunctionalArea,
BusinessArea,
ControllingArea,
Segment,
PartnerCostCenter,
PartnerProfitCenter,
PartnerFunctionalArea,
PartnerBusinessArea,
PartnerCompany,
CostObject,
PartnerSegment,
JointVenture,
JointVentureEquityGroup,
JointVentureCostRecoveryCode,
JointVenturePartner,
PartnerVenture,
FinancialValuationObjectType,
FinancialValuationObject,
FinancialValuationSubobject,
REBusinessEntity,
RealEstateBuilding,
RealEstateProperty,
GLAccount,
OffsettingAccount,
SubLedgerAcctLineItemType,
ChartOfAccounts,
PostingDate,
AccountingDocumentCategory,
IsOpenItemManaged,
ClearingDate,
ClearingAccountingDocument,
ClearingDocFiscalYear,
FiscalPeriod,
PrdcssrJournalEntryCompanyCode,
PrdcssrJournalEntryFiscalYear,
PredecessorJournalEntry,
PredecessorJournalEntryItem,
InvoiceItemReference,
InvoiceReference,
InvoiceReferenceFiscalYear,
FollowOnDocumentType,
AccountingDocumentItem,
BusinessTransactionType,
FinClsgRunRsltFDCrcy1,
FinClsgRunRsltAmtInFDCrcy1,
FinClsgRunRsltFDCrcy2,
FinClsgRunRsltAmtInFDCrcy2,
FinClsgRunRsltFDCrcy3,
FinClsgRunRsltAmtInFDCrcy3,
FinClsgRunRsltFDCrcy4,
FinClsgRunRsltAmtInFDCrcy4,
FinClsgRunRsltFDCrcy5,
FinClsgRunRsltAmtInFDCrcy5,
FinClsgRunRsltFDCrcy6,
FinClsgRunRsltAmtInFDCrcy6,
FinClsgRunRsltFDCrcy7,
FinClsgRunRsltAmtInFDCrcy7,
FinClsgRunRsltFDCrcy8,
FinClsgRunRsltAmtInFDCrcy8,
ExchangeRate,
FinClosingRunIsTestExecution,
FinancialClosingLineItemType,
FinancialClosingLineItemStatus,
FinClosingEntryCalculationType,
CreditRiskClass,
GeneralLedgerAgingIncrement,
NetDueDate,
OldestOpenItemNetDueDate,
ExpectedCreditLossPercent,
FinancialClosingGroupingRule,
FinClosingGroupingRuleStep,
FinancialClosingGrouping,
FinClosingLineItemDetailStatus,
InterestCalculationCode,
DiscountingAnnualInterestRate,
DiscgFiscalPeriodInterestRate,
DiscgDurationInFiscalPeriods,
NrOfDiscountedFiscalPeriods,
LongTrmAstLbltyDiscountFactor,
FinancialAccountType,
FinancialClosingValuationRule,
FinClosingValuationRuleStep,
GeneralLedgerAgingScope,
PostedAgingIncrement,
PrdcssrPerdEndClsgRunRsltUUID
FROM P_FIVALUATIONRESULTLISTORI
-- UNION ALL with additional select branch(es): P_FIVALUATIONRESULTLISTTMP
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA