I_JVACarriedIntrstInvcItmFDP

DDL: I_JVACARRIEDINTRSTINVCITMFDP SQL: IJVCIITEMFDP Type: view COMPOSITE

Carried Interest Document Items for JVA

I_JVACarriedIntrstInvcItmFDP is a Composite CDS View that provides data about "Carried Interest Document Items for JVA" in SAP S/4HANA. It reads from 1 data source (I_JntVntrCarriedInterestItem) and exposes 53 fields with key fields FiscalYear, PostingPeriod, CompanyCode, JntOpgAgrmtEquityGrp, JointVenturePartner.

Data Sources (1)

SourceAliasJoin Type
I_JntVntrCarriedInterestItem I_JntVntrCarriedInterestItem from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IJVCIITEMFDP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Carried Interest Document Items for JVA view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY FiscalYear I_JntVntrCarriedInterestItem FiscalYear G/L Fiscal Year
KEY PostingPeriod I_JntVntrCarriedInterestItem PostingPeriod Posting Period
KEY CompanyCode I_JntVntrCarriedInterestItem CompanyCode Receiver Company Code
KEY JntOpgAgrmtEquityGrp I_JntVntrCarriedInterestItem JntOpgAgrmtEquityGrp Equity group
KEY JointVenturePartner I_JntVntrCarriedInterestItem JointVenturePartner Joint Venture Partner
KEY JntVntrCarriedIntrstGrp I_JntVntrCarriedInterestItem JntVntrCarriedIntrstGrp CI Group
KEY JointVenture I_JntVntrCarriedInterestItem JointVenture Joint venture
KEY JntVntrPenaltyCategory I_JntVntrCarriedInterestItem JntVntrPenaltyCategory Pen Category
JntVntrInterestType I_JntVntrCarriedInterestItem JntVntrInterestType Obj. Type
JointVentureEquityType I_JntVntrCarriedInterestItem JointVentureEquityType Joint Venture Equity Type
TransactionCurrency I_JntVntrCarriedInterestItem TransactionCurrency Transaction Currency
CompanyCodeCurrency I_JntVntrCarriedInterestItem CompanyCodeCurrency Local Currency
JntVntrAcctgIsExpnOrRevn I_JntVntrCarriedInterestItem JntVntrAcctgIsExpnOrRevn Expense/Revenue Indi
JointVentureBillingType I_JntVntrCarriedInterestItem JointVentureBillingType ProcurementType
JntVntrNonSignatoryRcvryPct I_JntVntrCarriedInterestItem JntVntrNonSignatoryRcvryPct Non-signatory %
JntVntrPayIsStppd I_JntVntrCarriedInterestItem JntVntrPayIsStppd StopPay
PnltyAmtInCoCodeCrcy I_JntVntrCarriedInterestItem PnltyAmtInCoCodeCrcy Amnt in Comp Cd Crcy
StartingBalanceAmtInTransCrcy I_JntVntrCarriedInterestItem StartingBalanceAmtInTransCrcy
CurPerdAmtInBlTCrcy I_JntVntrCarriedInterestItem CurPerdAmtInBlTCrcy
EndingBalanceAmtInTransCrcy I_JntVntrCarriedInterestItem EndingBalanceAmtInTransCrcy
StartingBalanceAmtInCoCodeCrcy I_JntVntrCarriedInterestItem StartingBalanceAmtInCoCodeCrcy Amnt in Comp Cd Crcy
CurrentAmtInCoCodeCrcy I_JntVntrCarriedInterestItem CurrentAmtInCoCodeCrcy Amnt in Comp Cd Crcy
EndingBalanceAmtInCoCodeCrcy I_JntVntrCarriedInterestItem EndingBalanceAmtInCoCodeCrcy Amnt in Comp Cd Crcy
TotEndBalInTransCrcyWithPnlty I_JntVntrCarriedInterestItem TotEndBalInTransCrcyWithPnlty
StartingBalanceAmtInGlobalCrcy I_JntVntrCarriedInterestItem StartingBalanceAmtInGlobalCrcy Amnt in Global Crcy
StrtgBalAmtInFreeDfndCrcy1 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy1 Amount in Currency 1
StrtgBalAmtInFreeDfndCrcy2 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy2 Amount in Currency 2
StrtgBalAmtInFreeDfndCrcy3 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy3 Amount in Currency 3
StrtgBalAmtInFreeDfndCrcy4 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy4 Amount in Currency 4
StrtgBalAmtInFreeDfndCrcy5 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy5 Amount in Currency 5
StrtgBalAmtInFreeDfndCrcy6 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy6 Amount in Currency 6
StrtgBalAmtInFreeDfndCrcy7 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy7 Amount in Currency 7
StrtgBalAmtInFreeDfndCrcy8 I_JntVntrCarriedInterestItem StrtgBalAmtInFreeDfndCrcy8 Amount in Currency 8
CurPerdAmtInCCrcy I_JntVntrCarriedInterestItem CurPerdAmtInCCrcy Amnt in Comp Cd Crcy
CurPerdAmtInGCrcy I_JntVntrCarriedInterestItem CurPerdAmtInGCrcy Amnt in Global Crcy
CurPerdAmtInFDCrcy1 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy1 Amount in Currency 1
CurPerdAmtInFDCrcy2 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy2 Amount in Currency 2
CurPerdAmtInFDCrcy3 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy3 Amount in Currency 3
CurPerdAmtInFDCrcy4 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy4 Amount in Currency 4
CurPerdAmtInFDCrcy5 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy5 Amount in Currency 5
CurPerdAmtInFDCrcy6 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy6 Amount in Currency 6
CurPerdAmtInFDCrcy7 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy7 Amount in Currency 7
CurPerdAmtInFDCrcy8 I_JntVntrCarriedInterestItem CurPerdAmtInFDCrcy8 Amount in Currency 8
EndingBalanceAmtInGlobalCrcy I_JntVntrCarriedInterestItem EndingBalanceAmtInGlobalCrcy Amnt in Global Crcy
EndingBalAmtInFreeDfndCrcy1 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy1 Amount in Currency 1
EndingBalAmtInFreeDfndCrcy2 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy2 Amount in Currency 2
EndingBalAmtInFreeDfndCrcy3 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy3 Amount in Currency 3
EndingBalAmtInFreeDfndCrcy4 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy4 Amount in Currency 4
EndingBalAmtInFreeDfndCrcy5 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy5 Amount in Currency 5
EndingBalAmtInFreeDfndCrcy6 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy6 Amount in Currency 6
EndingBalAmtInFreeDfndCrcy7 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy7 Amount in Currency 7
EndingBalAmtInFreeDfndCrcy8 I_JntVntrCarriedInterestItem EndingBalAmtInFreeDfndCrcy8 Amount in Currency 8
JVAEndBalInCoCodeCrcyWithPnlty I_JntVntrCarriedInterestItem JVAEndBalInCoCodeCrcyWithPnlty

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_JVACarriedIntrstInvcItmFDP.
-- 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: IJVCIITEMFDP

CREATE VIEW I_JVACarriedIntrstInvcItmFDP AS
SELECT
  I_JntVntrCarriedInterestItem.FiscalYear AS FiscalYear,
  I_JntVntrCarriedInterestItem.PostingPeriod AS PostingPeriod,
  I_JntVntrCarriedInterestItem.CompanyCode AS CompanyCode,
  I_JntVntrCarriedInterestItem.JntOpgAgrmtEquityGrp AS JntOpgAgrmtEquityGrp,
  I_JntVntrCarriedInterestItem.JointVenturePartner AS JointVenturePartner,
  I_JntVntrCarriedInterestItem.JntVntrCarriedIntrstGrp AS JntVntrCarriedIntrstGrp,
  I_JntVntrCarriedInterestItem.JointVenture AS JointVenture,
  I_JntVntrCarriedInterestItem.JntVntrPenaltyCategory AS JntVntrPenaltyCategory,
  I_JntVntrCarriedInterestItem.JntVntrInterestType AS JntVntrInterestType,
  I_JntVntrCarriedInterestItem.JointVentureEquityType AS JointVentureEquityType,
  I_JntVntrCarriedInterestItem.TransactionCurrency AS TransactionCurrency,
  I_JntVntrCarriedInterestItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_JntVntrCarriedInterestItem.JntVntrAcctgIsExpnOrRevn AS JntVntrAcctgIsExpnOrRevn,
  I_JntVntrCarriedInterestItem.JointVentureBillingType AS JointVentureBillingType,
  I_JntVntrCarriedInterestItem.JntVntrNonSignatoryRcvryPct AS JntVntrNonSignatoryRcvryPct,
  I_JntVntrCarriedInterestItem.JntVntrPayIsStppd AS JntVntrPayIsStppd,
  I_JntVntrCarriedInterestItem.PnltyAmtInCoCodeCrcy AS PnltyAmtInCoCodeCrcy,
  I_JntVntrCarriedInterestItem.StartingBalanceAmtInTransCrcy AS StartingBalanceAmtInTransCrcy,
  I_JntVntrCarriedInterestItem.CurPerdAmtInBlTCrcy AS CurPerdAmtInBlTCrcy,
  I_JntVntrCarriedInterestItem.EndingBalanceAmtInTransCrcy AS EndingBalanceAmtInTransCrcy,
  I_JntVntrCarriedInterestItem.StartingBalanceAmtInCoCodeCrcy AS StartingBalanceAmtInCoCodeCrcy,
  I_JntVntrCarriedInterestItem.CurrentAmtInCoCodeCrcy AS CurrentAmtInCoCodeCrcy,
  I_JntVntrCarriedInterestItem.EndingBalanceAmtInCoCodeCrcy AS EndingBalanceAmtInCoCodeCrcy,
  I_JntVntrCarriedInterestItem.TotEndBalInTransCrcyWithPnlty AS TotEndBalInTransCrcyWithPnlty,
  I_JntVntrCarriedInterestItem.StartingBalanceAmtInGlobalCrcy AS StartingBalanceAmtInGlobalCrcy,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy1 AS StrtgBalAmtInFreeDfndCrcy1,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy2 AS StrtgBalAmtInFreeDfndCrcy2,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy3 AS StrtgBalAmtInFreeDfndCrcy3,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy4 AS StrtgBalAmtInFreeDfndCrcy4,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy5 AS StrtgBalAmtInFreeDfndCrcy5,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy6 AS StrtgBalAmtInFreeDfndCrcy6,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy7 AS StrtgBalAmtInFreeDfndCrcy7,
  I_JntVntrCarriedInterestItem.StrtgBalAmtInFreeDfndCrcy8 AS StrtgBalAmtInFreeDfndCrcy8,
  I_JntVntrCarriedInterestItem.CurPerdAmtInCCrcy AS CurPerdAmtInCCrcy,
  I_JntVntrCarriedInterestItem.CurPerdAmtInGCrcy AS CurPerdAmtInGCrcy,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy1 AS CurPerdAmtInFDCrcy1,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy2 AS CurPerdAmtInFDCrcy2,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy3 AS CurPerdAmtInFDCrcy3,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy4 AS CurPerdAmtInFDCrcy4,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy5 AS CurPerdAmtInFDCrcy5,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy6 AS CurPerdAmtInFDCrcy6,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy7 AS CurPerdAmtInFDCrcy7,
  I_JntVntrCarriedInterestItem.CurPerdAmtInFDCrcy8 AS CurPerdAmtInFDCrcy8,
  I_JntVntrCarriedInterestItem.EndingBalanceAmtInGlobalCrcy AS EndingBalanceAmtInGlobalCrcy,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy1 AS EndingBalAmtInFreeDfndCrcy1,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy2 AS EndingBalAmtInFreeDfndCrcy2,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy3 AS EndingBalAmtInFreeDfndCrcy3,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy4 AS EndingBalAmtInFreeDfndCrcy4,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy5 AS EndingBalAmtInFreeDfndCrcy5,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy6 AS EndingBalAmtInFreeDfndCrcy6,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy7 AS EndingBalAmtInFreeDfndCrcy7,
  I_JntVntrCarriedInterestItem.EndingBalAmtInFreeDfndCrcy8 AS EndingBalAmtInFreeDfndCrcy8,
  I_JntVntrCarriedInterestItem.JVAEndBalInCoCodeCrcyWithPnlty AS JVAEndBalInCoCodeCrcyWithPnlty
FROM I_JntVntrCarriedInterestItem
;