C_JVAVentureGrossCostDetObjPg
Venture Gross Cost Detail Object Page
C_JVAVentureGrossCostDetObjPg is a Consumption CDS View that provides data about "Venture Gross Cost Detail Object Page" in SAP S/4HANA. It reads from 1 data source (I_JVALineItemCube) and exposes 62 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 (11)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CVNTRGROSSCOST | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #MANDATORY | 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 | |
| EndUserText.label | Venture Gross Cost Detail Object Page | 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 (62)
| 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 | ||
| JointVenture | I_JVALineItemCube | JointVenture | Joint venture | |
| JointVentureEquityGroup | JointVentureEquityGroup | Joint Venture Equity Group | ||
| TransactionCurrency | I_JVALineItemCube | TransactionCurrency | Transaction Currency | |
| CompanyCodeCurrency | I_JVALineItemCube | CompanyCodeCurrency | Local Currency | |
| GLAccountType | I_JVALineItemCube | GLAccountType | G/L Account Type | |
| 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 | |
| FiscalYearVariant | I_JVALineItemCube | FiscalYearVariant | FY Variant | |
| JointVentureType | ||||
| JointVentureEquityType | I_JVALineItemCube | JointVentureEquityType | Joint Venture Equity Type | |
| JointVentureBillingType | I_JVALineItemCube | JointVentureBillingType | ||
| JntVntrRcvryCodeIsBillable | I_JVALineItemCube | JntVntrRcvryCodeIsBillable | ||
| JointVentureAccountingActivity | I_JVALineItemCube | JointVentureAccountingActivity | ||
| Customer | I_JVALineItemCube | Customer | Sold-to Party | |
| VntrGrossCostInTransCrcy | I_JVALineItemCube | AmountInTransactionCurrency | Pt Crcy Amt | |
| VntrGrossCostInCoCodeCrcy | I_JVALineItemCube | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| VntrGrossCostsInGCrcy | I_JVALineItemCube | AmountInGlobalCurrency | Amount in Global Currency | |
| VntrGrossCostInBalTransCrcy | I_JVALineItemCube | AmountInBalanceTransacCrcy | Amount in Balance Transaction Currency | |
| VntrGrossCostInFDCrcy1 | I_JVALineItemCube | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| VntrGrossCostInFDCrcy2 | I_JVALineItemCube | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| VntrGrossCostInFDCrcy3 | I_JVALineItemCube | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| VntrGrossCostInFDCrcy4 | I_JVALineItemCube | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| VntrGrossCostInFDCrcy5 | I_JVALineItemCube | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| VntrGrossCostInFDCrcy6 | I_JVALineItemCube | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| VntrGrossCostInFDCrcy7 | I_JVALineItemCube | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| VntrGrossCostInFDCrcy8 | 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 | ||
| _CompanyCodeCurrency | I_JVALineItemCube | _CompanyCodeCurrency | ||
| _TransactionCurrency | I_JVALineItemCube | _TransactionCurrency | ||
| _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_JVAVentureGrossCostDetObjPg.
-- 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: CVNTRGROSSCOST
CREATE VIEW C_JVAVentureGrossCostDetObjPg AS
SELECT
JVItem.CompanyCode AS CompanyCode,
JVItem.Ledger AS Ledger,
JVItem.FiscalYear AS FiscalYear,
JVItem.AccountingDocument AS AccountingDocument,
JVItem.LedgerGLLineItem AS LedgerGLLineItem,
cast( '02' as abap.char(2) ) AS UniqueItemIdentifier,
JVItem.FiscalPeriod AS FiscalPeriod,
JVItem.LedgerFiscalYear AS LedgerFiscalYear,
JVItem.JointVenture AS JointVenture,
JointVentureEquityGroup,
JVItem.TransactionCurrency AS TransactionCurrency,
JVItem.CompanyCodeCurrency AS CompanyCodeCurrency,
JVItem.GLAccountType AS GLAccountType,
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.FiscalYearVariant AS FiscalYearVariant,
JVItem._JointVentureMasterFld.JointVentureType AS JointVentureType,
JVItem.JointVentureEquityType AS JointVentureEquityType,
JVItem.JointVentureBillingType AS JointVentureBillingType,
JVItem.JntVntrRcvryCodeIsBillable AS JntVntrRcvryCodeIsBillable,
JVItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
JVItem.Customer AS Customer,
JVItem.AmountInTransactionCurrency AS VntrGrossCostInTransCrcy,
JVItem.AmountInCompanyCodeCurrency AS VntrGrossCostInCoCodeCrcy,
JVItem.AmountInGlobalCurrency AS VntrGrossCostsInGCrcy,
JVItem.AmountInBalanceTransacCrcy AS VntrGrossCostInBalTransCrcy,
JVItem.AmountInFreeDefinedCurrency1 AS VntrGrossCostInFDCrcy1,
JVItem.AmountInFreeDefinedCurrency2 AS VntrGrossCostInFDCrcy2,
JVItem.AmountInFreeDefinedCurrency3 AS VntrGrossCostInFDCrcy3,
JVItem.AmountInFreeDefinedCurrency4 AS VntrGrossCostInFDCrcy4,
JVItem.AmountInFreeDefinedCurrency5 AS VntrGrossCostInFDCrcy5,
JVItem.AmountInFreeDefinedCurrency6 AS VntrGrossCostInFDCrcy6,
JVItem.AmountInFreeDefinedCurrency7 AS VntrGrossCostInFDCrcy7,
JVItem.AmountInFreeDefinedCurrency8 AS VntrGrossCostInFDCrcy8,
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._CompanyCodeCurrency AS _CompanyCodeCurrency,
JVItem._TransactionCurrency AS _TransactionCurrency,
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