What is I_JntVntrGLAcctLineItemData in SAP S/4HANA?

I_JntVntrGLAcctLineItemData is a composite CDS view in SAP S/4HANA. JVA GL Account Line Item - Cube It contains 76 fields.

Which tables does I_JntVntrGLAcctLineItemData read from?

I_JntVntrGLAcctLineItemData reads data from: I_JVALineItemCube.

What VDM layer is I_JntVntrGLAcctLineItemData?

I_JntVntrGLAcctLineItemData is classified as a Composite view that combines data from multiple basic views.

I_JntVntrGLAcctLineItemData

DDL: I_JNTVNTRGLACCTLINEITEMDATA Type: view COMPOSITE

76 Fields 1 Data Sources

JVA GL Account Line Item - Cube

I_JntVntrGLAcctLineItemData is a Composite CDS View (Cube) that provides data about "JVA GL Account Line Item - Cube" in SAP S/4HANA. It reads from 1 data source (I_JVALineItemCube) and exposes 76 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (1)

Source	Alias	Join Type
I_JVALineItemCube	JVItem	from

Annotations (16)

Name	Value	Level
EndUserText.label	JVA GL Account Line Item - Cube	view
AbapCatalog.sqlViewName	IGLACCTLINEITM	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view

Fields (76)

Key	Field	Source Table	Source Field	Description
	JointVentureType
	YrToDteAmtInTransacCrcy
	ITDAmtInTC
	YearToDateAmountInCoCodeCrcy
	YearToDateAmountInGlobalCrcy
	ITDAmtInGCrcy
	YearToDateAmountInBalTransCrcy
	YearToDateAmountInFDCrcy1
	YearToDateAmountInFDCrcy2
	YearToDateAmountInFDCrcy3
	YearToDateAmountInFDCrcy4
	YearToDateAmountInFDCrcy5
	YearToDateAmountInFDCrcy6
	YearToDateAmountInFDCrcy7
	YearToDateAmountInFDCrcy8
KEY	Ledger	I_JVALineItemCube	Ledger	Ledger
KEY	CompanyCode	I_JVALineItemCube	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_JVALineItemCube	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_JVALineItemCube	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	I_JVALineItemCube	LedgerGLLineItem	Journal Entry Item
	LedgerFiscalYear	I_JVALineItemCube	LedgerFiscalYear
	FiscalPeriod	I_JVALineItemCube	FiscalPeriod	Tax period
	FiscalYearVariant	I_JVALineItemCube	FiscalYearVariant	FY Variant
	FiscalYearPeriod	I_JVALineItemCube	FiscalYearPeriod	Period/Year
	JointVenture	I_JVALineItemCube	JointVenture	Joint venture
	JointVentureEquityGroup	I_JVALineItemCube	JointVentureEquityGroup	Joint Venture Equity Group
	JointVentureEquityType	I_JVALineItemCube	JointVentureEquityType	Joint Venture Equity Type
	JointVentureCostRecoveryCode	I_JVALineItemCube	JointVentureCostRecoveryCode	Recovery Ind.
	GLAccount	I_JVALineItemCube	GLAccount	General Ledger
	ChartOfAccounts	I_JVALineItemCube	ChartOfAccounts	Node Class
	JointVentureBillingType	I_JVALineItemCube	JointVentureBillingType
	JntVntrRcvryCodeIsBillable	I_JVALineItemCube	JntVntrRcvryCodeIsBillable
	JointVentureAccountingActivity	I_JVALineItemCube	JointVentureAccountingActivity
	Customer	I_JVALineItemCube	Customer	Sold-to Party
	CutbackRun	I_JVALineItemCube	CutbackRun
	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
	_CompanyCode	I_JVALineItemCube	_CompanyCode
	_Ledger	I_JVALineItemCube	_Ledger
	_FiscalYear	I_JVALineItemCube	_FiscalYear
	_JournalEntry	I_JVALineItemCube	_JournalEntry
	_FiscalYearVariant	I_JVALineItemCube	_FiscalYearVariant
	_FiscalPeriodForVariant	I_JVALineItemCube	_FiscalPeriodForVariant
	_LedgerFiscalYearForVariant	I_JVALineItemCube	_LedgerFiscalYearForVariant
	_FiscalYearPeriodForVariant	I_JVALineItemCube	_FiscalYearPeriodForVariant
	_JointVentureMasterFld	I_JVALineItemCube	_JointVentureMasterFld
	_JntVntrEquityGrp	I_JVALineItemCube	_JntVntrEquityGrp
	_JntVntrEquityTypeMaster	I_JVALineItemCube	_JntVntrEquityTypeMaster
	_JntVntrRecoveryInd	I_JVALineItemCube	_JntVntrRecoveryInd
	_GLAccountInChartOfAccounts	I_JVALineItemCube	_GLAccountInChartOfAccounts
	_ChartOfAccounts	I_JVALineItemCube	_ChartOfAccounts
	_Customer	I_JVALineItemCube	_Customer
	_GLAccountType	I_JVALineItemCube	_GLAccountType
	_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 I_JntVntrGLAcctLineItemData.
-- 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 I_JntVntrGLAcctLineItemData AS
SELECT
  JVItem._JointVentureMasterFld.JointVentureType AS JointVentureType,
  cast( JVItem.AmountInTransactionCurrency as jv_ytdamt_tc preserving type ) AS YrToDteAmtInTransacCrcy,
  cast( JVItem.AmountInTransactionCurrency as jv_itdamt_tc preserving type ) AS ITDAmtInTC,
  cast( JVItem.AmountInCompanyCodeCurrency as jv_ytdamt_cc preserving type ) AS YearToDateAmountInCoCodeCrcy,
  cast( JVItem.AmountInGlobalCurrency as jv_ytdamt_gc preserving type ) AS YearToDateAmountInGlobalCrcy,
  cast( JVItem.AmountInGlobalCurrency as jv_itdamt_gc preserving type ) AS ITDAmtInGCrcy,
  cast( JVItem.AmountInBalanceTransacCrcy as jv_ytdamt_btc preserving type ) AS YearToDateAmountInBalTransCrcy,
  cast( JVItem.AmountInFreeDefinedCurrency1 as jv_ytdamt_fdc1 preserving type ) AS YearToDateAmountInFDCrcy1,
  cast( JVItem.AmountInFreeDefinedCurrency2 as jv_ytdamt_fdc2 preserving type ) AS YearToDateAmountInFDCrcy2,
  cast( JVItem.AmountInFreeDefinedCurrency3 as jv_ytdamt_fdc3 preserving type ) AS YearToDateAmountInFDCrcy3,
  cast( JVItem.AmountInFreeDefinedCurrency4 as jv_ytdamt_fdc4 preserving type ) AS YearToDateAmountInFDCrcy4,
  cast( JVItem.AmountInFreeDefinedCurrency5 as jv_ytdamt_fdc5 preserving type ) AS YearToDateAmountInFDCrcy5,
  cast( JVItem.AmountInFreeDefinedCurrency6 as jv_ytdamt_fdc6 preserving type ) AS YearToDateAmountInFDCrcy6,
  cast( JVItem.AmountInFreeDefinedCurrency7 as jv_ytdamt_fdc7 preserving type ) AS YearToDateAmountInFDCrcy7,
  cast( JVItem.AmountInFreeDefinedCurrency8 as jv_ytdamt_fdc8 preserving type ) AS YearToDateAmountInFDCrcy8,
  JVItem.Ledger AS Ledger,
  JVItem.CompanyCode AS CompanyCode,
  JVItem.FiscalYear AS FiscalYear,
  JVItem.AccountingDocument AS AccountingDocument,
  JVItem.LedgerGLLineItem AS LedgerGLLineItem,
  JVItem.LedgerFiscalYear AS LedgerFiscalYear,
  JVItem.FiscalPeriod AS FiscalPeriod,
  JVItem.FiscalYearVariant AS FiscalYearVariant,
  JVItem.FiscalYearPeriod AS FiscalYearPeriod,
  JVItem.JointVenture AS JointVenture,
  JVItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JVItem.JointVentureEquityType AS JointVentureEquityType,
  JVItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  JVItem.GLAccount AS GLAccount,
  JVItem.ChartOfAccounts AS ChartOfAccounts,
  JVItem.JointVentureBillingType AS JointVentureBillingType,
  JVItem.JntVntrRcvryCodeIsBillable AS JntVntrRcvryCodeIsBillable,
  JVItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  JVItem.Customer AS Customer,
  JVItem.CutbackRun AS CutbackRun,
  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._CompanyCode AS _CompanyCode,
  JVItem._Ledger AS _Ledger,
  JVItem._FiscalYear AS _FiscalYear,
  JVItem._JournalEntry AS _JournalEntry,
  JVItem._FiscalYearVariant AS _FiscalYearVariant,
  JVItem._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  JVItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  JVItem._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  JVItem._JointVentureMasterFld AS _JointVentureMasterFld,
  JVItem._JntVntrEquityGrp AS _JntVntrEquityGrp,
  JVItem._JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster,
  JVItem._JntVntrRecoveryInd AS _JntVntrRecoveryInd,
  JVItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JVItem._ChartOfAccounts AS _ChartOfAccounts,
  JVItem._Customer AS _Customer,
  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
FROM I_JVALineItemCube AS JVItem
;

Depth:

I_JntVntrGLAcctLineItemData view

I_JVALineItemCube view