I_JointVentureLineItemIndex

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_JointVentureLineItemIndex.
-- 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: IJVLII

CREATE VIEW I_JointVentureLineItemIndex AS
SELECT
  cast(jv_rec as gu_recid preserving type) AS ItemUUID,
  poper AS FiscalPeriod,
  ryear AS LedgerFiscalYear,
  rbukrs AS CompanyCode,
  rjvnam AS JointVenture,
  regrou AS JointVentureEquityGroup,
  racct AS GLAccount,
  rbusa AS BusinessArea,
  rcntr AS CostCenter,
  rordnr AS OrderID,
  cast( rprojk as fis_wbsint_no_conv preserving type ) AS WBSElementInternalID,
  rprctr AS ProfitCenter,
  ranln1 AS MasterFixedAsset,
  ranln2 AS FixedAsset,
  ranbwa AS AssetTransactionType,
  rrecin AS JointVentureCostRecoveryCode,
  rpartn AS JointVenturePartner,
  rkokrs AS ControllingArea,
  jibcl AS JntIntrstBillgClass,
  _JntIntrstBillgClassText.JntIntrstBillgClassText AS JntIntrstBillgClassText,
  jibsa AS JntIntrstBillgSubClass,
  _JntIntrstBillgSubclassT.JntIntrstBillgSubClassText AS JntIntrstBillgSubClassText,
  jibsb AS JntIntrstBillgSubClass2,
  _JntIntrstBillgSubclass2T.JntIntrstBillgSubclass2Text AS JntIntrstBillgSubclass2Text,
  billcode AS JntVntrBillgCode,
  ceind AS JVAProjIsAuthzdForCptlExpndtr,
  ceind AS JVAExpenditureType,
  _JVAExpenditureTypeText.JVAExpenditureTypeText AS JVAExpenditureTypeText,
  ceind AS JntVntrRcvryCodeIsBillable,
  cast(sds_co as jv_sds_co preserving type) AS JVASupplementalDetSetForBillg,
  cast(sds_acc as jv_sds_acc preserving type) AS JVASupplementalDetSetForAcct,
  cast(sds_ri as jv_sds_ri preserving type) AS JVASupplementalDetSetRcvryCode,
  cast(afenum as jv_afenum_cds preserving type) AS JntVntrAuthznForExpndtrObject,
  jib_cobj AS JntVntrCostTypeText,
  jib_cobj AS JntIntrstBillgCostObjectType,
  cast( case when jibcl is not initial and jibsa is not initial and jibsb is not initial then concat( concat( jibcl, '/' ), concat( concat( jibsa,'/' ), jibsb ) ) when jibcl is not initial and jibsa is not initial then concat( concat( jibcl, '/' ), jibsa ) when jibcl is not initial then jibcl else ' ' end as abap.char(34) ) as JntVntrSuspenseStatusText AS char34asJntVntrSuspenseStatusText
FROM t8jix
LEFT OUTER JOIN I_JVAExpenditureTypeText AS _JVAExpenditureTypeText ON _JVAExpenditureTypeText.JVAExpenditureType = JVAExpenditureType AND _JVAExpenditureTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClass AS _JntIntrstBillgClass ON _JntIntrstBillgClass.CompanyCode = CompanyCode AND _JntIntrstBillgClass.JntIntrstBillgClass = JntIntrstBillgClass  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgClassText AS _JntIntrstBillgClassText ON _JntIntrstBillgClassText.CompanyCode = CompanyCode AND _JntIntrstBillgClassText.JntIntrstBillgClass = JntIntrstBillgClass AND _JntIntrstBillgClassText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass AS _JntIntrstBillgSubclass ON _JntIntrstBillgSubclass.CompanyCode = CompanyCode AND _JntIntrstBillgSubclass.JntIntrstBillgClass = JntIntrstBillgClass AND _JntIntrstBillgSubclass.JntIntrstBillgSubClass = JntIntrstBillgSubClass  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclassT AS _JntIntrstBillgSubclassT ON _JntIntrstBillgSubclassT.CompanyCode = CompanyCode AND _JntIntrstBillgSubclassT.JntIntrstBillgClass = JntIntrstBillgClass AND _JntIntrstBillgSubclassT.JntIntrstBillgSubClass = JntIntrstBillgSubClass AND _JntIntrstBillgSubclassT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass2 AS _JntIntrstBillgSubclass2 ON _JntIntrstBillgSubclass2.CompanyCode = CompanyCode AND _JntIntrstBillgSubclass2.JntIntrstBillgClass = JntIntrstBillgClass AND _JntIntrstBillgSubclass2.JntIntrstBillgSubClass = JntIntrstBillgSubClass AND _JntIntrstBillgSubclass2.JntIntrstBillgSubClass2 = JntIntrstBillgSubClass2  -- association [0..1]
LEFT OUTER JOIN I_JntIntrstBillgSubclass2T AS _JntIntrstBillgSubclass2T ON _JntIntrstBillgSubclass2T.CompanyCode = CompanyCode AND _JntIntrstBillgSubclass2T.JntIntrstBillgClass = JntIntrstBillgClass AND _JntIntrstBillgSubclass2T.JntIntrstBillgSubClass = JntIntrstBillgSubClass AND _JntIntrstBillgSubclass2T.JntIntrstBillgSubClass2 = JntIntrstBillgSubClass2 AND _JntIntrstBillgSubclass2T.Language = $session.system_language  -- association [0..1]
;