What is I_JVAJntInterestBillingCube2 in SAP S/4HANA?

I_JVAJntInterestBillingCube2 is a composite CDS view in SAP S/4HANA. JVA Joint Interest Billing 2 - Cube It contains 113 fields.

Which tables does I_JVAJntInterestBillingCube2 read from?

I_JVAJntInterestBillingCube2 reads data from: I_JointVentureLineItemIndex, I_JVALineItemCube, I_JVABillingIndexMaxPeriod.

What VDM layer is I_JVAJntInterestBillingCube2?

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

I_JVAJntInterestBillingCube2

DDL: I_JVAJNTINTERESTBILLINGCUBE2 Type: view COMPOSITE Package: GJVA_UI_BACKEND

113 Fields 3 Data Sources

JVA Joint Interest Billing 2 - Cube

I_JVAJntInterestBillingCube2 is a Composite CDS View (Cube) that provides data about "JVA Joint Interest Billing 2 - Cube" in SAP S/4HANA. It reads from 3 data sources (I_JointVentureLineItemIndex, I_JVALineItemCube, I_JVABillingIndexMaxPeriod) and exposes 113 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem. Part of development package GJVA_UI_BACKEND.

Data Sources (3)

Source	Alias	Join Type
I_JointVentureLineItemIndex	BillIndex	inner
I_JVALineItemCube	JVItem	from
I_JVABillingIndexMaxPeriod	MaxPeriod	inner

Annotations (16)

Name	Value	Level
EndUserText.label	JVA Joint Interest Billing 2 - Cube	view
AbapCatalog.sqlViewName	IJVAJIB2	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
VDM.viewType	#COMPOSITE	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.modelingPattern	#NONE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view

Fields (113)

Key	Field	Source Table	Source Field	Description
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	Ref. Year1
	FiscalPeriod	I_JVALineItemCube	FiscalPeriod	Tax period
	FiscalYearVariant	I_JVALineItemCube	FiscalYearVariant	FY Variant
	PostingDate	I_JVALineItemCube	PostingDate	Posting Date for GR
	CompanyCodeName
	JointVenture	I_JVALineItemCube	JointVenture	Joint venture
	JointVentureName
	JointVentureEquityGroup	I_JVALineItemCube	JointVentureEquityGroup	Joint Venture Equity Group
	JntOpgAgrmtEquityGrpText
	JointVentureCostRecoveryCode	I_JVALineItemCube	JointVentureCostRecoveryCode	Recovery Ind.
	JointVentureRecoveryCodeName
	JointVenturePartner	I_JVALineItemCube	JointVenturePartner	Joint Venture Partner
	JointVenturePartnerShortText
	CostCenter	I_JVALineItemCube	CostCenter	Cost Center
	CostCenterName
	ControllingArea	I_JVALineItemCube	ControllingArea	Controlling Area
	ChartOfAccounts	I_JVALineItemCube	ChartOfAccounts	Node Class
	WBSElementExternalID	I_JVALineItemCube	WBSElementExternalID	WBS Element External ID
	WBSDescription
	WBSElementInternalID	I_JVALineItemCube	WBSElementInternalID	WBS Internal ID
	OrderID	I_JVALineItemCube	OrderID	Order ID
	AssetTransactionType	I_JVALineItemCube	AssetTransactionType	Trans.Type
	GLAccount	I_JVALineItemCube	GLAccount	General Ledger
	GLAccountName
	ProfitCenter	I_JVALineItemCube	ProfitCenter	Profit Center
	MasterFixedAsset	I_JVALineItemCube	MasterFixedAsset	Fixed Asset
	FixedAsset	I_JVALineItemCube	FixedAsset	Sub-number
	OriginalFiscalYear	I_JointVentureLineItemIndex	LedgerFiscalYear	Ref. Year1
	OriginalFiscalPeriod	I_JointVentureLineItemIndex	FiscalPeriod	Tax period
	JVAExpenditureType	I_JointVentureLineItemIndex	JVAExpenditureType	Expense Type
	JVAExpenditureTypeText	I_JointVentureLineItemIndex	JVAExpenditureTypeText
	JntIntrstBillgClass	I_JointVentureLineItemIndex	JntIntrstBillgClass	JIB/JIBE Class
	JntIntrstBillgClassText	I_JointVentureLineItemIndex	JntIntrstBillgClassText
	JntIntrstBillgSubClass	I_JointVentureLineItemIndex	JntIntrstBillgSubClass	JIB/JIBE SbClsA
	JntIntrstBillgSubClassText	I_JointVentureLineItemIndex	JntIntrstBillgSubClassText
	JntIntrstBillgSubClass2	I_JointVentureLineItemIndex	JntIntrstBillgSubClass2	JIB/JIBE Sub B
	JntIntrstBillgSubclass2Text	I_JointVentureLineItemIndex	JntIntrstBillgSubclass2Text
	JntVntrAuthznForExpndtrObject	I_JointVentureLineItemIndex	JntVntrAuthznForExpndtrObject
	JntVntrCostTypeText	I_JointVentureLineItemIndex	JntVntrCostTypeText	JIB Cost Objects
	JntIntrstBillgCostObjectType	I_JointVentureLineItemIndex	JntIntrstBillgCostObjectType	JIB Cost Objects
	JntVntrSuspenseStatusText	I_JointVentureLineItemIndex	JntVntrSuspenseStatusText
	TransactionCurrency	I_JVALineItemCube	TransactionCurrency	Transaction Currency
	AmountInTransactionCurrency	I_JVALineItemCube	AmountInTransactionCurrency	Pt Crcy Amt
	CompanyCodeCurrency	I_JVALineItemCube	CompanyCodeCurrency	Local Currency
	AmountInCompanyCodeCurrency	I_JVALineItemCube	AmountInCompanyCodeCurrency	Local Crcy Amt
	GlobalCurrency	I_JVALineItemCube	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	I_JVALineItemCube	AmountInGlobalCurrency	Amount in Global Currency
	FunctionalCurrency	I_JVALineItemCube	FunctionalCurrency	Functional Currency
	AmountInFunctionalCurrency	I_JVALineItemCube	AmountInFunctionalCurrency	Amount in Functional Currency
	FreeDefinedCurrency1	I_JVALineItemCube	FreeDefinedCurrency1	Freely Defined Currency 1
	AmountInFreeDefinedCurrency1	I_JVALineItemCube	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FreeDefinedCurrency2	I_JVALineItemCube	FreeDefinedCurrency2	Freely Defined Currency 2
	AmountInFreeDefinedCurrency2	I_JVALineItemCube	AmountInFreeDefinedCurrency2	Amount in Freely Defined Currency 2
	FreeDefinedCurrency3	I_JVALineItemCube	FreeDefinedCurrency3	Freely Defined Currency 3
	AmountInFreeDefinedCurrency3	I_JVALineItemCube	AmountInFreeDefinedCurrency3	Amount in Freely Defined Currency 3
	FreeDefinedCurrency4	I_JVALineItemCube	FreeDefinedCurrency4	Freely Defined Currency 4
	AmountInFreeDefinedCurrency4	I_JVALineItemCube	AmountInFreeDefinedCurrency4	Amount in Freely Defined Currency 4
	FreeDefinedCurrency5	I_JVALineItemCube	FreeDefinedCurrency5	Freely Defined Currency 5
	AmountInFreeDefinedCurrency5	I_JVALineItemCube	AmountInFreeDefinedCurrency5	Amount in Freely Defined Currency 5
	FreeDefinedCurrency6	I_JVALineItemCube	FreeDefinedCurrency6	Freely Defined Currency 6
	AmountInFreeDefinedCurrency6	I_JVALineItemCube	AmountInFreeDefinedCurrency6	Amount in Freely Defined Currency 6
	FreeDefinedCurrency7	I_JVALineItemCube	FreeDefinedCurrency7	Freely Defined Currency 7
	AmountInFreeDefinedCurrency7	I_JVALineItemCube	AmountInFreeDefinedCurrency7	Amount in Freely Defined Currency 7
	FreeDefinedCurrency8	I_JVALineItemCube	FreeDefinedCurrency8	Freely Defined Currency 8
	AmountInFreeDefinedCurrency8	I_JVALineItemCube	AmountInFreeDefinedCurrency8	Amount in Freely Defined Currency 8
	JVAFundingCurrency	I_JVALineItemCube	JVAFundingCurrency
	AmountInJVAFundingCurrency	I_JVALineItemCube	AmountInJVAFundingCurrency	Amount in JVA Funding Currency
	_Ledger	I_JVALineItemCube	_Ledger
	_CompanyCode	I_JVALineItemCube	_CompanyCode
	_CompanyCodeText	I_JVALineItemCube	_CompanyCodeText
	_ControllingArea	I_JVALineItemCube	_ControllingArea
	_ControllingAreaText	I_JVALineItemCube	_ControllingAreaText
	_ChartOfAccounts	I_JVALineItemCube	_ChartOfAccounts
	_FiscalYear	I_JVALineItemCube	_FiscalYear
	_FiscalPeriodCompanyCode	I_JVALineItemCube	_FiscalPeriodCompanyCode
	_FiscalPeriod	I_JVALineItemCube	_FiscalPeriodCompanyCode
	_FiscalPeriodLedger	I_JVALineItemCube	_FiscalPeriodLedger
	_LedgerFiscalYearForVariant	I_JVALineItemCube	_LedgerFiscalYearForVariant
	_FiscalYearVariant	I_JVALineItemCube	_FiscalYearVariant
	_JournalEntry	I_JVALineItemCube	_JournalEntry
	_CostCenter	I_JVALineItemCube	_CostCenter
	_CostCenterText	I_JVALineItemCube	_CostCenterText
	_WBSElementBasicData	I_JVALineItemCube	_WBSElementBasicData
	_WBSElementInternalID	I_JVALineItemCube	_WBSElementInternalID
	_WBSElementInternalIDText	I_JVALineItemCube	_WBSElementInternalIDText
	_WBSElementExternalID	I_JVALineItemCube	_WBSElementExternalID
	_WBSElementExternalIDText	I_JVALineItemCube	_WBSElementExternalIDText
	_JointVentureDesc	I_JVALineItemCube	_JointVentureDesc
	_Order	I_JVALineItemCube	_Order
	_JointVentureMasterFld	I_JVALineItemCube	_JointVentureMasterFld
	_GLAccountTxt	I_JVALineItemCube	_GLAccountTxt
	_GLAccountInChartOfAccounts	I_JVALineItemCube	_GLAccountInChartOfAccounts
	_JntVntrEquityGrp	I_JVALineItemCube	_JntVntrEquityGrp
	_JntVntrRecoveryInd	I_JVALineItemCube	_JntVntrRecoveryInd
	_JntVntrRecoveryIndText	I_JVALineItemCube	_JntVntrRecoveryIndText
	_JntVntrBusinessPartner	I_JVALineItemCube	_JntVntrBusinessPartner
	_TransactionCurrency	I_JVALineItemCube	_TransactionCurrency
	_CompanyCodeCurrency	I_JVALineItemCube	_CompanyCodeCurrency
	_GlobalCurrency	I_JVALineItemCube	_GlobalCurrency
	_FunctionalCurrency	I_JVALineItemCube	_FunctionalCurrency
	_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_JVAJntInterestBillingCube2.
-- 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_JVAJntInterestBillingCube2 AS
SELECT
  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.PostingDate AS PostingDate,
  JVItem._CompanyCode[ 1:Language = $session.system_language ].CompanyCodeName AS CompanyCodeName,
  JVItem.JointVenture AS JointVenture,
  JVItem._JointVentureDesc[ 1:Language = $session.system_language ].JointVentureName AS JointVentureName,
  JVItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  JVItem._JntVntrEquityGrp._JntVntrEquityGrpText[ 1:Language = $session.system_language ].JntOpgAgrmtEquityGrpText AS JntOpgAgrmtEquityGrpText,
  JVItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  JVItem._JntVntrRecoveryIndText[ 1:Language = $session.system_language ].JointVentureRecoveryCodeName AS JointVentureRecoveryCodeName,
  JVItem.JointVenturePartner AS JointVenturePartner,
  JVItem._JntVntrBusinessPartner.JointVenturePartnerShortText AS JointVenturePartnerShortText,
  JVItem.CostCenter AS CostCenter,
  JVItem._CostCenterText[ 1:Language = $session.system_language ].CostCenterName AS CostCenterName,
  JVItem.ControllingArea AS ControllingArea,
  JVItem.ChartOfAccounts AS ChartOfAccounts,
  JVItem.WBSElementExternalID AS WBSElementExternalID,
  JVItem._WBSElementExternalID.WBSDescription AS WBSDescription,
  JVItem.WBSElementInternalID AS WBSElementInternalID,
  JVItem.OrderID AS OrderID,
  JVItem.AssetTransactionType AS AssetTransactionType,
  JVItem.GLAccount AS GLAccount,
  JVItem._GLAccountTxt[ 1:Language = $session.system_language].GLAccountName AS GLAccountName,
  JVItem.ProfitCenter AS ProfitCenter,
  JVItem.MasterFixedAsset AS MasterFixedAsset,
  JVItem.FixedAsset AS FixedAsset,
  BillIndex.LedgerFiscalYear AS OriginalFiscalYear,
  BillIndex.FiscalPeriod AS OriginalFiscalPeriod,
  BillIndex.JVAExpenditureType AS JVAExpenditureType,
  BillIndex.JVAExpenditureTypeText AS JVAExpenditureTypeText,
  BillIndex.JntIntrstBillgClass AS JntIntrstBillgClass,
  BillIndex.JntIntrstBillgClassText AS JntIntrstBillgClassText,
  BillIndex.JntIntrstBillgSubClass AS JntIntrstBillgSubClass,
  BillIndex.JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText,
  BillIndex.JntIntrstBillgSubClass2 AS JntIntrstBillgSubClass2,
  BillIndex.JntIntrstBillgSubclass2Text AS JntIntrstBillgSubclass2Text,
  BillIndex.JntVntrAuthznForExpndtrObject AS JntVntrAuthznForExpndtrObject,
  BillIndex.JntVntrCostTypeText AS JntVntrCostTypeText,
  BillIndex.JntIntrstBillgCostObjectType AS JntIntrstBillgCostObjectType,
  BillIndex.JntVntrSuspenseStatusText AS JntVntrSuspenseStatusText,
  JVItem.TransactionCurrency AS TransactionCurrency,
  JVItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  JVItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  JVItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  JVItem.GlobalCurrency AS GlobalCurrency,
  JVItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JVItem.FunctionalCurrency AS FunctionalCurrency,
  JVItem.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  JVItem.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  JVItem.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  JVItem.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  JVItem.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  JVItem.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  JVItem.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  JVItem.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  JVItem.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  JVItem.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  JVItem.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  JVItem.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  JVItem.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  JVItem.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  JVItem.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  JVItem.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  JVItem.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  JVItem.JVAFundingCurrency AS JVAFundingCurrency,
  JVItem.AmountInJVAFundingCurrency AS AmountInJVAFundingCurrency,
  JVItem._Ledger AS _Ledger,
  JVItem._CompanyCode AS _CompanyCode,
  JVItem._CompanyCodeText AS _CompanyCodeText,
  JVItem._ControllingArea AS _ControllingArea,
  JVItem._ControllingAreaText AS _ControllingAreaText,
  JVItem._ChartOfAccounts AS _ChartOfAccounts,
  JVItem._FiscalYear AS _FiscalYear,
  JVItem._FiscalPeriodCompanyCode AS _FiscalPeriodCompanyCode,
  JVItem._FiscalPeriodCompanyCode AS _FiscalPeriod,
  JVItem._FiscalPeriodLedger AS _FiscalPeriodLedger,
  JVItem._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  JVItem._FiscalYearVariant AS _FiscalYearVariant,
  JVItem._JournalEntry AS _JournalEntry,
  JVItem._CostCenter AS _CostCenter,
  JVItem._CostCenterText AS _CostCenterText,
  JVItem._WBSElementBasicData AS _WBSElementBasicData,
  JVItem._WBSElementInternalID AS _WBSElementInternalID,
  JVItem._WBSElementInternalIDText AS _WBSElementInternalIDText,
  JVItem._WBSElementExternalID AS _WBSElementExternalID,
  JVItem._WBSElementExternalIDText AS _WBSElementExternalIDText,
  JVItem._JointVentureDesc AS _JointVentureDesc,
  JVItem._Order AS _Order,
  JVItem._JointVentureMasterFld AS _JointVentureMasterFld,
  JVItem._GLAccountTxt AS _GLAccountTxt,
  JVItem._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  JVItem._JntVntrEquityGrp AS _JntVntrEquityGrp,
  JVItem._JntVntrRecoveryInd AS _JntVntrRecoveryInd,
  JVItem._JntVntrRecoveryIndText AS _JntVntrRecoveryIndText,
  JVItem._JntVntrBusinessPartner AS _JntVntrBusinessPartner,
  JVItem._TransactionCurrency AS _TransactionCurrency,
  JVItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  JVItem._GlobalCurrency AS _GlobalCurrency,
  JVItem._FunctionalCurrency AS _FunctionalCurrency,
  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
INNER JOIN I_JVABillingIndexMaxPeriod AS MaxPeriod ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureLineItemIndex AS BillIndex ON /* join condition not captured in parsed metadata */
;

Depth:

I_JVAJntInterestBillingCube2 view