I_JVASuspenseWBSAvgCostLineItm

DDL: I_JVASUSPENSEWBSAVGCOSTLINEITM SQL: IJVASUWBSCSTITM Type: view COMPOSITE
26 Fields 5 Data Sources 1 Associations

Avg Cost of Supense WBS Element in JVA

I_JVASuspenseWBSAvgCostLineItm is a Composite CDS View (Cube) that provides data about "Avg Cost of Supense WBS Element in JVA" in SAP S/4HANA. It reads from 5 data sources (I_GLAccountLineItemCube, I_JVALedger, I_JointVentureCompanyCodeVH, I_JntVntrRecoveryInd, I_JointVentureProjInSuspense) and exposes 26 fields with key fields CompanyCode, AccountingDocument, WBSElement, WBSElementInternalID, FiscalYear. It has 1 association to related views.

Data Sources (5)

SourceAliasJoin Type
I_GLAccountLineItemCube _GLAccLineItm from
I_JVALedger _JVALedger inner
I_JointVentureCompanyCodeVH _JVCompanyCode inner
I_JntVntrRecoveryInd _RecInd inner
I_JointVentureProjInSuspense _VntrProjInSusp inner

Parameters (2)

NameTypeDefault
P_FiscalYear gjahr
P_FiscalPeriod poper

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_WBSElementBasicData _WBSElement $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IJVASUWBSCSTITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #CUBE view
VDM.viewType #COMPOSITE view
Search.searchable false view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.internalName #LOCAL view
EndUserText.label Avg Cost of Supense WBS Element in JVA view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_GLAccountLineItemCube CompanyCode Receiver Company Code
KEY AccountingDocument I_GLAccountLineItemCube AccountingDocument Journal Entry
KEY WBSElement I_GLAccountLineItemCube WBSElement WBS Internal ID
KEY WBSElementInternalID I_GLAccountLineItemCube WBSElementInternalID WBS Internal ID
KEY FiscalYear I_GLAccountLineItemCube FiscalYear G/L Fiscal Year
KEY FiscalPeriod I_GLAccountLineItemCube FiscalPeriod Tax period
KEY LedgerFiscalYear I_GLAccountLineItemCube LedgerFiscalYear
KEY Ledger I_GLAccountLineItemCube Ledger Ledger
KEY LedgerGLLineItem I_GLAccountLineItemCube LedgerGLLineItem Journal Entry Item
FiscalYearVariant I_GLAccountLineItemCube FiscalYearVariant FY Variant
FiscalYearPeriod I_GLAccountLineItemCube FiscalYearPeriod Period/Year
GLAccountType I_GLAccountLineItemCube GLAccountType G/L Account Type
AssetClass I_GLAccountLineItemCube AssetClass Asset Class
JointVentureCostRecoveryCode I_GLAccountLineItemCube JointVentureCostRecoveryCode Recovery Ind.
CompanyCodeCurrency I_GLAccountLineItemCube CompanyCodeCurrency Local Currency
WBSSuspenseITDAmtInCoCodeCrcy
_WBSElement _WBSElement
_CompanyCode I_GLAccountLineItemCube _CompanyCode
_CompanyCodeCurrency I_GLAccountLineItemCube _CompanyCodeCurrency
_FiscalYear I_GLAccountLineItemCube _FiscalYear
_FiscalPeriod I_GLAccountLineItemCube _FiscalPeriod
_LedgerFiscalYear I_GLAccountLineItemCube _LedgerFiscalYear
_FiscalYearVariant I_GLAccountLineItemCube _FiscalYearVariant
_Ledger I_GLAccountLineItemCube _Ledger
_JournalEntry I_GLAccountLineItemCube _JournalEntry
_GLAccountType I_GLAccountLineItemCube _GLAccountType

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_JVASuspenseWBSAvgCostLineItm.
-- 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: IJVASUWBSCSTITM
-- Parameters: P_FiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW I_JVASuspenseWBSAvgCostLineItm AS
SELECT
  _GLAccLineItm.CompanyCode AS CompanyCode,
  _GLAccLineItm.AccountingDocument AS AccountingDocument,
  _GLAccLineItm.WBSElement AS WBSElement,
  _GLAccLineItm.WBSElementInternalID AS WBSElementInternalID,
  _GLAccLineItm.FiscalYear AS FiscalYear,
  _GLAccLineItm.FiscalPeriod AS FiscalPeriod,
  _GLAccLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  _GLAccLineItm.Ledger AS Ledger,
  _GLAccLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  _GLAccLineItm.FiscalYearVariant AS FiscalYearVariant,
  _GLAccLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  _GLAccLineItm.GLAccountType AS GLAccountType,
  _GLAccLineItm.AssetClass AS AssetClass,
  _GLAccLineItm.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _GLAccLineItm.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast(_GLAccLineItm.AmountInCompanyCodeCurrency as jv_itdamt_cc preserving type) AS WBSSuspenseITDAmtInCoCodeCrcy,
  _GLAccLineItm._CompanyCode AS _CompanyCode,
  _GLAccLineItm._CompanyCodeCurrency AS _CompanyCodeCurrency,
  _GLAccLineItm._FiscalYear AS _FiscalYear,
  _GLAccLineItm._FiscalPeriod AS _FiscalPeriod,
  _GLAccLineItm._LedgerFiscalYear AS _LedgerFiscalYear,
  _GLAccLineItm._FiscalYearVariant AS _FiscalYearVariant,
  _GLAccLineItm._Ledger AS _Ledger,
  _GLAccLineItm._JournalEntry AS _JournalEntry,
  _GLAccLineItm._GLAccountType AS _GLAccountType
FROM I_GLAccountLineItemCube AS _GLAccLineItm
INNER JOIN I_JVALedger AS _JVALedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureCompanyCodeVH AS _JVCompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureProjInSuspense AS _VntrProjInSusp ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrRecoveryInd AS _RecInd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;

Learn More