C_JVAYearToDateDetObjPg
JVA Year To Date Detail Object Page
C_JVAYearToDateDetObjPg is a Consumption CDS View that provides data about "JVA Year To Date Detail Object Page" in SAP S/4HANA. It reads from 1 data source (I_JVALineItemCube) and exposes 61 fields with key fields CompanyCode, Ledger, FiscalYear, AccountingDocument, LedgerGLLineItem. It is exposed through 2 OData services (ASQL_F4498, UI_JVA_COST_ANALYSIS). It is used in 1 Fiori application: JVA Cost Analysis. Part of development package GJVA_UI_BACKEND.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_JVALineItemCube | JVItem | from |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CYRTODTEDET | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | JVA Year To Date Detail Object Page | view | |
| VDM.viewType | #CONSUMPTION | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.representativeKey | UniqueItemIdentifier | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
OData Services (2)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F4498 | ASQL_F4498 | C2 | NOT_RELEASED | |
| UI_JVA_COST_ANALYSIS | UI_JVA_COST_ANALYSIS | V2 | C1 | NOT_TO_BE_RELEASED_STABLE |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| F4498 | JVA Cost Analysis | Transactional | You use this feature to display information on gross or net cost and working capital for a venture and equity group by company code, period, year to date and inception to date basis. The default configuration variant consists only billable expenses for the gross and net expense and working capital values. The partner share percentages are displayed by partner for the selected equity group. A pie chart displays the working interest of the venture partners for the selected equity group. |
JVA Cost Analysis
Business Role: Others
Fields (61)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | I_JVALineItemCube | CompanyCode | Receiver Company Code |
| KEY | Ledger | I_JVALineItemCube | Ledger | Ledger |
| KEY | FiscalYear | I_JVALineItemCube | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | I_JVALineItemCube | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | I_JVALineItemCube | LedgerGLLineItem | Journal Entry Item |
| KEY | UniqueItemIdentifier | |||
| FiscalPeriod | I_JVALineItemCube | FiscalPeriod | Tax period | |
| LedgerFiscalYear | I_JVALineItemCube | LedgerFiscalYear | ||
| FiscalYearVariant | I_JVALineItemCube | FiscalYearVariant | FY Variant | |
| JointVenture | I_JVALineItemCube | JointVenture | Joint venture | |
| JointVentureType | ||||
| JointVentureEquityGroup | I_JVALineItemCube | JointVentureEquityGroup | Joint Venture Equity Group | |
| JointVentureEquityType | I_JVALineItemCube | JointVentureEquityType | Joint Venture Equity Type | |
| JointVentureBillingType | I_JVALineItemCube | JointVentureBillingType | ||
| JntVntrRcvryCodeIsBillable | I_JVALineItemCube | JntVntrRcvryCodeIsBillable | ||
| JointVentureAccountingActivity | I_JVALineItemCube | JointVentureAccountingActivity | ||
| GLAccountType | I_JVALineItemCube | GLAccountType | G/L Account Type | |
| TransactionCurrency | I_JVALineItemCube | TransactionCurrency | Transaction Currency | |
| CompanyCodeCurrency | I_JVALineItemCube | CompanyCodeCurrency | Local Currency | |
| GlobalCurrency | I_JVALineItemCube | GlobalCurrency | GM Billing Element: Global Currency | |
| BalanceTransactionCurrency | I_JVALineItemCube | BalanceTransactionCurrency | Currency | |
| FreeDefinedCurrency1 | I_JVALineItemCube | FreeDefinedCurrency1 | Freely Defined Currency 1 | |
| FreeDefinedCurrency2 | I_JVALineItemCube | FreeDefinedCurrency2 | Freely Defined Currency 2 | |
| FreeDefinedCurrency3 | I_JVALineItemCube | FreeDefinedCurrency3 | Freely Defined Currency 3 | |
| FreeDefinedCurrency4 | I_JVALineItemCube | FreeDefinedCurrency4 | Freely Defined Currency 4 | |
| FreeDefinedCurrency5 | I_JVALineItemCube | FreeDefinedCurrency5 | Freely Defined Currency 5 | |
| FreeDefinedCurrency6 | I_JVALineItemCube | FreeDefinedCurrency6 | Freely Defined Currency 6 | |
| FreeDefinedCurrency7 | I_JVALineItemCube | FreeDefinedCurrency7 | Freely Defined Currency 7 | |
| FreeDefinedCurrency8 | I_JVALineItemCube | FreeDefinedCurrency8 | Freely Defined Currency 8 | |
| YrToDteAmtInTransacCrcy | I_JVALineItemCube | AmountInTransactionCurrency | Pt Crcy Amt | |
| YearToDateAmountInCoCodeCrcy | I_JVALineItemCube | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| YearToDateAmountInGlobalCrcy | I_JVALineItemCube | AmountInGlobalCurrency | Amount in Global Currency | |
| YearToDateAmountInBalTransCrcy | I_JVALineItemCube | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | |
| YearToDateAmountInFDCrcy1 | I_JVALineItemCube | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| YearToDateAmountInFDCrcy2 | I_JVALineItemCube | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| YearToDateAmountInFDCrcy3 | I_JVALineItemCube | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| YearToDateAmountInFDCrcy4 | I_JVALineItemCube | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| YearToDateAmountInFDCrcy5 | I_JVALineItemCube | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| YearToDateAmountInFDCrcy6 | I_JVALineItemCube | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| YearToDateAmountInFDCrcy7 | I_JVALineItemCube | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| YearToDateAmountInFDCrcy8 | I_JVALineItemCube | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | |
| _CompanyCode | I_JVALineItemCube | _CompanyCode | ||
| _FiscalPeriodForVariant | I_JVALineItemCube | _FiscalPeriodForVariant | ||
| _FiscalYear | I_JVALineItemCube | _FiscalYear | ||
| _FiscalYearVariant | I_JVALineItemCube | _FiscalYearVariant | ||
| _JointVentureMasterFld | I_JVALineItemCube | _JointVentureMasterFld | ||
| _JournalEntry | I_JVALineItemCube | _JournalEntry | ||
| _Ledger | I_JVALineItemCube | _Ledger | ||
| _LedgerFiscalYearForVariant | I_JVALineItemCube | _LedgerFiscalYearForVariant | ||
| _TransactionCurrency | I_JVALineItemCube | _TransactionCurrency | ||
| _CompanyCodeCurrency | I_JVALineItemCube | _CompanyCodeCurrency | ||
| _GlobalCurrency | I_JVALineItemCube | _GlobalCurrency | ||
| _BalanceTransactionCurrency | I_JVALineItemCube | _BalanceTransactionCurrency | ||
| _FreeDefinedCurrency1 | I_JVALineItemCube | _FreeDefinedCurrency1 | ||
| _FreeDefinedCurrency2 | I_JVALineItemCube | _FreeDefinedCurrency2 | ||
| _FreeDefinedCurrency3 | I_JVALineItemCube | _FreeDefinedCurrency3 | ||
| _FreeDefinedCurrency4 | I_JVALineItemCube | _FreeDefinedCurrency4 | ||
| _FreeDefinedCurrency5 | I_JVALineItemCube | _FreeDefinedCurrency5 | ||
| _FreeDefinedCurrency6 | I_JVALineItemCube | _FreeDefinedCurrency6 | ||
| _FreeDefinedCurrency7 | I_JVALineItemCube | _FreeDefinedCurrency7 | ||
| _FreeDefinedCurrency8 | I_JVALineItemCube | _FreeDefinedCurrency8 |
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 C_JVAYearToDateDetObjPg.
-- 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.
-- SQL view name: CYRTODTEDET
CREATE VIEW C_JVAYearToDateDetObjPg AS
SELECT
JVItem.CompanyCode AS CompanyCode,
JVItem.Ledger AS Ledger,
JVItem.FiscalYear AS FiscalYear,
JVItem.AccountingDocument AS AccountingDocument,
JVItem.LedgerGLLineItem AS LedgerGLLineItem,
cast( '05' as abap.char(2) ) AS UniqueItemIdentifier,
JVItem.FiscalPeriod AS FiscalPeriod,
JVItem.LedgerFiscalYear AS LedgerFiscalYear,
JVItem.FiscalYearVariant AS FiscalYearVariant,
JVItem.JointVenture AS JointVenture,
JVItem._JointVentureMasterFld.JointVentureType AS JointVentureType,
JVItem.JointVentureEquityGroup AS JointVentureEquityGroup,
JVItem.JointVentureEquityType AS JointVentureEquityType,
JVItem.JointVentureBillingType AS JointVentureBillingType,
JVItem.JntVntrRcvryCodeIsBillable AS JntVntrRcvryCodeIsBillable,
JVItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
JVItem.GLAccountType AS GLAccountType,
JVItem.TransactionCurrency AS TransactionCurrency,
JVItem.CompanyCodeCurrency AS CompanyCodeCurrency,
JVItem.GlobalCurrency AS GlobalCurrency,
JVItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
JVItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
JVItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
JVItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
JVItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
JVItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
JVItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
JVItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
JVItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
JVItem.AmountInTransactionCurrency AS YrToDteAmtInTransacCrcy,
JVItem.AmountInCompanyCodeCurrency AS YearToDateAmountInCoCodeCrcy,
JVItem.AmountInGlobalCurrency AS YearToDateAmountInGlobalCrcy,
JVItem.AmountInBalanceTransacCrcy AS YearToDateAmountInBalTransCrcy,
JVItem.AmountInFreeDefinedCurrency1 AS YearToDateAmountInFDCrcy1,
JVItem.AmountInFreeDefinedCurrency2 AS YearToDateAmountInFDCrcy2,
JVItem.AmountInFreeDefinedCurrency3 AS YearToDateAmountInFDCrcy3,
JVItem.AmountInFreeDefinedCurrency4 AS YearToDateAmountInFDCrcy4,
JVItem.AmountInFreeDefinedCurrency5 AS YearToDateAmountInFDCrcy5,
JVItem.AmountInFreeDefinedCurrency6 AS YearToDateAmountInFDCrcy6,
JVItem.AmountInFreeDefinedCurrency7 AS YearToDateAmountInFDCrcy7,
JVItem.AmountInFreeDefinedCurrency8 AS YearToDateAmountInFDCrcy8,
JVItem._CompanyCode AS _CompanyCode,
JVItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
JVItem._FiscalYear AS _FiscalYear,
JVItem._FiscalYearVariant AS _FiscalYearVariant,
JVItem._JointVentureMasterFld AS _JointVentureMasterFld,
JVItem._JournalEntry AS _JournalEntry,
JVItem._Ledger AS _Ledger,
JVItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
JVItem._TransactionCurrency AS _TransactionCurrency,
JVItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
JVItem._GlobalCurrency AS _GlobalCurrency,
JVItem._BalanceTransactionCurrency AS _BalanceTransactionCurrency,
JVItem._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
JVItem._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
JVItem._FreeDefinedCurrency3 AS _FreeDefinedCurrency3,
JVItem._FreeDefinedCurrency4 AS _FreeDefinedCurrency4,
JVItem._FreeDefinedCurrency5 AS _FreeDefinedCurrency5,
JVItem._FreeDefinedCurrency6 AS _FreeDefinedCurrency6,
JVItem._FreeDefinedCurrency7 AS _FreeDefinedCurrency7,
JVItem._FreeDefinedCurrency8 AS _FreeDefinedCurrency8
FROM I_JVALineItemCube AS JVItem
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- 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