I_JVALINEITEMCUBE

CDS View
154 Fields 19 CDS Views

JVA Line Item - Cube

I_JVALINEITEMCUBE is a CDS View in S/4HANA. JVA Line Item - Cube. It contains 154 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
C_JVAInceptionToDateDetObjPg view from CONSUMPTION JVA Inception To Date Detail Object Page
C_JVAOperatorNetCostDetObjPg view from CONSUMPTION Operator Net Cost Detail Object Page
C_JVATotalCostDetailObjectPage view from CONSUMPTION Operator Net Cost Detail Object Page
C_JVAVentureGrossCostDetObjPg view from CONSUMPTION Venture Gross Cost Detail Object Page
C_JVAVentureWrkgCptlDetObjPg view from CONSUMPTION Object Page for Venture Working Capital
C_JVAYearToDateDetObjPg view from CONSUMPTION JVA Year To Date Detail Object Page
I_GrossBillByVntrC view from COMPOSITE Gross Bill By Venture - Cube
I_GrossPartNetByCostCtrC view from COMPOSITE Gross Partner Net By Cost Center
I_GrossPartNetByCostCtrEntyC view_entity from COMPOSITE JVA Gross Partner by Cost Center - Cube
I_JntVntrGLAcctLineItemData view from COMPOSITE JVA GL Account Line Item - Cube
I_JntVntrGrssNonOprtdC view from COMPOSITE JV Gross Non Operated
I_JntVntrRmngCutbackAmt view inner COMPOSITE JV Remaining Cutback Amount
I_JVAActualCashCallLineItem view from COMPOSITE Actual Cost and Cash Call for UJE
I_JVACalculatedITDPerdData view inner COMPOSITE JVA Calculated ITD Period Data - Cube
I_JVACalculatedYTDPerdData view inner COMPOSITE JVA Calculated YearToDate Period - Cube
I_JVAJntInterestBillingCube view from COMPOSITE JVA Joint Interest Billing - Cube
I_JVAJntInterestBillingCube2 view from COMPOSITE JVA Joint Interest Billing 2 - Cube
I_JVAPartnerBillingCube view from COMPOSITE Joint Venture Partner Billing
I_JVAPartnerBillingEntyCube view_entity from COMPOSITE Joint Venture Partner Billing - Cube

Fields (154)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 17
KEY CompanyCode CompanyCode 19
KEY FiscalYear CurrentFiscalYear,FiscalYear 17
KEY JointVenture JointVenture 19
KEY JointVentureEquityGroup JointVentureEquityGroup 18
KEY Ledger Ledger,SourceLedger 19
KEY LedgerGLLineItem LedgerGLLineItem 17
_AccountingDocumentType _AccountingDocumentType 7
_AssetTransactionType _AssetTransactionType 7
_BalanceTransactionCurrency _BalanceTransactionCurrency 14
_BaseUnit _BaseUnit 7
_BusinessArea _BusinessArea 7
_ChartOfAccounts _ChartOfAccounts 10
_CompanyCode _CompanyCode 19
_CompanyCodeCurrency _CompanyCodeCurrency 18
_CompanyCodeText _CompanyCodeText 2
_ControllingArea _ControllingArea 9
_ControllingAreaText _ControllingAreaText 2
_CostCenter _CostCenter 9
_CostCenterText _CostCenterText 2
_CurrentCostCenter _CurrentCostCenter 7
_CurrentProfitCenter _CurrentProfitCenter 7
_Customer _Customer 8
_DebitCreditCode _DebitCreditCode 7
_DistributionChannel _DistributionChannel 7
_FinancialAccountType _FinancialAccountType 1
_FiscalPeriodCompanyCode _FiscalPeriod,_FiscalPeriodCompanyCode 2
_FiscalPeriodForVariant _FiscalPeriodForVariant 14
_FiscalPeriodLedger _FiscalPeriodLedger 2
_FiscalYear _FiscalYear 16
_FiscalYearPeriodForVariant _FiscalYearPeriodForVariant 1
_FiscalYearVariant _FiscalYearVariant 16
_FixedAsset _FixedAsset 7
_FreeDefinedCurrency1 _FreeDefinedCurrency1 18
_FreeDefinedCurrency2 _FreeDefinedCurrency2 18
_FreeDefinedCurrency3 _FreeDefinedCurrency3 18
_FreeDefinedCurrency4 _FreeDefinedCurrency4 18
_FreeDefinedCurrency5 _FreeDefinedCurrency5 18
_FreeDefinedCurrency6 _FreeDefinedCurrency6 18
_FreeDefinedCurrency7 _FreeDefinedCurrency7 18
_FreeDefinedCurrency8 _FreeDefinedCurrency8 18
_FunctionalArea _FunctionalArea 1
_FunctionalCurrency _FunctionalCurrency 3
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 10
_GLAccountInCompanyCode _GLAccountInCompanyCode 7
_GLAccountTxt _GLAccountTxt 2
_GLAccountType _GLAccountType 3
_GlobalCurrency _GlobalCurrency 18
_JntVntrBusinessPartner _JntVntrBusinessPartner 3
_JntVntrEquityGrp _JntVntrEquityGrp 9
_JntVntrEquityTypeMaster _JntVntrEquityTypeMaster 7
_JntVntrRecoveryInd _JntVntrRecoveryInd 9
_JntVntrRecoveryIndText _JntVntrRecoveryIndText 2
_JointVentureDesc _JointVentureDesc 2
_JointVentureMasterFld _JointVentureMasterFld 15
_JointVenturePayrollType _JointVenturePayrollType 6
_JournalEntry _JournalEntry 16
_Ledger _Ledger 16
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant 16
_MasterFixedAsset _MasterFixedAsset 7
_Order _Order 9
_Plant _Plant 1
_ProfitCenter _ProfitCenter 7
_ProjectNetwork _ProjectNetwork 8
_PurReqValuationArea _PurReqValuationArea 1
_SalesDocument _SalesDocument 7
_SalesOrganization _SalesOrganization 1
_Segment _Segment 1
_ServiceDocument _ServiceDocument 7
_ServiceDocumentType _ServiceDocumentType 1
_Supplier _Supplier 7
_TransactionCurrency _TransactionCurrency 16
_WBSElementBasicData _WBSElementBasicData 9
_WBSElementExternalID _WBSElementExternalID 9
_WBSElementExternalIDText _WBSElementExternalIDText 2
_WBSElementInternalID _WBSElementInternalID 2
_WBSElementInternalIDText _WBSElementInternalIDText 2
AccountingDocumentType AccountingDocumentType 7
AmountInBalanceTransacCrcy ITDAmtInBlTCrcy,OperatorNetCostInBalTransCrcy,VntrGrossCostInBalTransCrcy,VntrWrkgCptlAmtInBalTransCrcy,YearToDateAmountInBalTransCrcy 6
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency,ITDAmtInCCrcy,OperatorNetCostInCoCodeCrcy,VntrGrossCostInCoCodeCrcy,VntrWrkgCptlAmtInCCrcy,YearToDateAmountInCoCodeCrcy 8
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1,ITDAmtInFDCrcy1,OperatorNetCostInFDCrcy1,VntrGrossCostInFDCrcy1,VntrWrkgCptlAmountInFDCrcy1,YearToDateAmountInFDCrcy1 8
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2,ITDAmtInFDCrcy2,OperatorNetCostInFDCrcy2,VntrGrossCostInFDCrcy2,VntrWrkgCptlAmountInFDCrcy2,YearToDateAmountInFDCrcy2 8
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3,ITDAmtInFDCrcy3,OperatorNetCostInFDCrcy3,VntrGrossCostInFDCrcy3,VntrWrkgCptlAmountInFDCrcy3,YearToDateAmountInFDCrcy3 8
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4,ITDAmtInFDCrcy4,OperatorNetCostInFDCrcy4,VntrGrossCostInFDCrcy4,VntrWrkgCptlAmountInFDCrcy4,YearToDateAmountInFDCrcy4 8
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5,ITDAmtInFDCrcy5,OperatorNetCostInFDCrcy5,VntrGrossCostInFDCrcy5,VntrWrkgCptlAmountInFDCrcy5,YearToDateAmountInFDCrcy5 8
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6,ITDAmtInFDCrcy6,OperatorNetCostInFDCrcy6,VntrGrossCostInFDCrcy6,VntrWrkgCptlAmountInFDCrcy6,YearToDateAmountInFDCrcy6 8
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7,ITDAmtInFDCrcy7,OperatorNetCostInFDCrcy7,VntrGrossCostInFDCrcy7,VntrWrkgCptlAmountInFDCrcy7,YearToDateAmountInFDCrcy7 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8,ITDAmtInFDCrcy8,OperatorNetCostInFDCrcy8,VntrGrossCostInFDCrcy8,VntrWrkgCptlAmountInFDCrcy8,YearToDateAmountInFDCrcy8 8
AmountInFunctionalCurrency AmountInFunctionalCurrency 2
AmountInGlobalCurrency AmountInGlobalCurrency,ITDAmtInGCrcy,OperatorNetCostInGCrcy,VntrGrossCostsInGCrcy,VntrWrkgCptlAmountInGCrcy,YearToDateAmountInGlobalCrcy 8
AmountInJVAFundingCurrency AmountInJVAFundingCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency,ITDAmtInTC,OperatorNetCostInTransCrcy,VntrGrossCostInTransCrcy,VntrWrkgCptlAmountInTransCrcy,YrToDteAmtInTransacCrcy 8
AssetClass AssetClass 7
AssetTransactionType AssetTransactionType 9
BalanceTransactionCurrency BalanceTransactionCurrency 14
BaseUnit BaseUnit 7
BusinessArea BusinessArea 7
ChartOfAccounts ChartOfAccounts 9
CompanyCodeCurrency CompanyCodeCurrency 18
ControllingArea ControllingArea 10
CostCenter CostCenter 10
Customer Customer 9
CutbackCostObject CutbackCostObject 1
CutbackRun CutbackRun 2
DebitCreditCode DebitCreditCode 7
DistributionChannel DistributionChannel 7
FinancialAccountType FinancialAccountType 7
FiscalPeriod CurrentFiscalPeriod,FiscalPeriod 16
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 15
FixedAsset FixedAsset 9
FreeDefinedCurrency1 FreeDefinedCurrency1 18
FreeDefinedCurrency2 FreeDefinedCurrency2 18
FreeDefinedCurrency3 FreeDefinedCurrency3 18
FreeDefinedCurrency4 FreeDefinedCurrency4 18
FreeDefinedCurrency5 FreeDefinedCurrency5 18
FreeDefinedCurrency6 FreeDefinedCurrency6 18
FreeDefinedCurrency7 FreeDefinedCurrency7 18
FreeDefinedCurrency8 FreeDefinedCurrency8 18
FunctionalArea FunctionalArea 7
FunctionalCurrency FunctionalCurrency 3
GLAccount GLAccount 10
GLAccountType GLAccountType 5
GlobalCurrency GlobalCurrency 18
GLRecordType GLRecordType 7
JntVntrRcvryCodeIsBillable JntVntrRcvryCodeIsBillable 9
JntVntrRcvryCodeIsRlvtToBillg JntVntrRcvryCodeIsRlvtToBillg 1
JointVentureAccountingActivity JointVentureAccountingActivity 8
JointVentureBillingType JointVentureBillingType 15
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 11
JointVentureEquityType JointVentureEquityType 15
JointVenturePartner BusinessPartner,JointVenturePartner 6
JVAFundingCurrency JVAFundingCurrency,JVAFundingCurrency1 3
LedgerFiscalYear LedgerFiscalYear 18
MasterFixedAsset MasterFixedAsset 9
OrderID OrderID 9
OrganizationDivision OrganizationDivision 7
Plant Plant 7
PostingDate PostingDate 9
ProfitCenter ProfitCenter 10
ProjectNetwork ProjectNetwork 8
Quantity Quantity 7
RelatedNetworkActivity RelatedNetworkActivity 1
SalesDocument SalesDocument 7
SalesOrganization SalesOrganization 7
Segment Segment 7
ServiceDocument ServiceDocument 7
ServiceDocumentType ServiceDocumentType 7
SuperiorOrder SuperiorOrder 1
Supplier Supplier 7
TransactionCurrency TransactionCurrency 16
ValuationArea ValuationArea 7
WBSElementExternalID WBSElementExternalID 9
WBSElementInternalID WBSElementInternalID 10

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- JVA Line Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JVALINEITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    JOINTVENTURE,
    JOINTVENTUREEQUITYGROUP,
    LEDGER,
    LEDGERGLLINEITEM,
    _ACCOUNTINGDOCUMENTTYPE,
    _ASSETTRANSACTIONTYPE,
    _BALANCETRANSACTIONCURRENCY,
    _BASEUNIT,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _COMPANYCODETEXT,
    _CONTROLLINGAREA,
    _CONTROLLINGAREATEXT,
    _COSTCENTER,
    _COSTCENTERTEXT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _DEBITCREDITCODE,
    _DISTRIBUTIONCHANNEL,
    _FINANCIALACCOUNTTYPE,
    _FISCALPERIODCOMPANYCODE,
    _FISCALPERIODFORVARIANT,
    _FISCALPERIODLEDGER,
    _FISCALYEAR,
    _FISCALYEARPERIODFORVARIANT,
    _FISCALYEARVARIANT,
    _FIXEDASSET,
    _FREEDEFINEDCURRENCY1,
    _FREEDEFINEDCURRENCY2,
    _FREEDEFINEDCURRENCY3,
    _FREEDEFINEDCURRENCY4,
    _FREEDEFINEDCURRENCY5,
    _FREEDEFINEDCURRENCY6,
    _FREEDEFINEDCURRENCY7,
    _FREEDEFINEDCURRENCY8,
    _FUNCTIONALAREA,
    _FUNCTIONALCURRENCY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _GLACCOUNTTXT,
    _GLACCOUNTTYPE,
    _GLOBALCURRENCY,
    _JNTVNTRBUSINESSPARTNER,
    _JNTVNTREQUITYGRP,
    _JNTVNTREQUITYTYPEMASTER,
    _JNTVNTRRECOVERYIND,
    _JNTVNTRRECOVERYINDTEXT,
    _JOINTVENTUREDESC,
    _JOINTVENTUREMASTERFLD,
    _JOINTVENTUREPAYROLLTYPE,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEARFORVARIANT,
    _MASTERFIXEDASSET,
    _ORDER,
    _PLANT,
    _PROFITCENTER,
    _PROJECTNETWORK,
    _PURREQVALUATIONAREA,
    _SALESDOCUMENT,
    _SALESORGANIZATION,
    _SEGMENT,
    _SERVICEDOCUMENT,
    _SERVICEDOCUMENTTYPE,
    _SUPPLIER,
    _TRANSACTIONCURRENCY,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    _WBSELEMENTEXTERNALIDTEXT,
    _WBSELEMENTINTERNALID,
    _WBSELEMENTINTERNALIDTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINFUNCTIONALCURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINJVAFUNDINGCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    ASSETTRANSACTIONTYPE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    CUTBACKCOSTOBJECT,
    CUTBACKRUN,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    FUNCTIONALCURRENCY,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    JNTVNTRRCVRYCODEISBILLABLE,
    JNTVNTRRCVRYCODEISRLVTTOBILLG,
    JOINTVENTUREACCOUNTINGACTIVITY,
    JOINTVENTUREBILLINGTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYTYPE,
    JOINTVENTUREPARTNER,
    JVAFUNDINGCURRENCY,
    LEDGERFISCALYEAR,
    MASTERFIXEDASSET,
    ORDERID,
    ORGANIZATIONDIVISION,
    PLANT,
    POSTINGDATE,
    PROFITCENTER,
    PROJECTNETWORK,
    QUANTITY,
    RELATEDNETWORKACTIVITY,
    SALESDOCUMENT,
    SALESORGANIZATION,
    SEGMENT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTTYPE,
    SUPERIORORDER,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    VALUATIONAREA,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, JOINTVENTURE, JOINTVENTUREEQUITYGROUP, LEDGER, LEDGERGLLINEITEM)
);

Learn More