I_JOINTVENTURELINEITEMINDEX

CDS View
42 Fields 3 CDS Views

Jv Line Item Index

I_JOINTVENTURELINEITEMINDEX is a CDS View in S/4HANA. Jv Line Item Index. It contains 42 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_JointVentureAuditCube view left_outer COMPOSITE Joint Venture Audit Report Cube
I_JVABillingIndexYearPeriod view_entity from COMPOSITE JV Billing Index Year Period
I_JVAJntInterestBillingCube2 view inner COMPOSITE JVA Joint Interest Billing 2 - Cube

Fields (42)

KeyField CDS FieldsUsed in Views
KEY AssetTransactionType AssetTransactionType 1
KEY BusinessArea BusinessArea 1
KEY CompanyCode CompanyCode 1
KEY ControllingArea ControllingArea 1
KEY CostCenter CostCenter 1
KEY FiscalPeriod FiscalPeriod,OriginalFiscalPeriod 2
KEY FixedAsset FixedAsset 1
KEY GLAccount GLAccount 1
KEY JointVenture JointVenture 1
KEY JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
KEY JointVentureEquityGroup JointVentureEquityGroup 1
KEY JointVenturePartner JointVenturePartner 1
KEY LedgerFiscalYear LedgerFiscalYear,OriginalFiscalYear 2
KEY MasterFixedAsset MasterFixedAsset 1
KEY OrderID OrderID 1
KEY ProfitCenter ProfitCenter 1
KEY WBSElementInternalID WBSElementInternalID 1
_JntIntrstBillgClass _JntIntrstBillgClass 1
_JntIntrstBillgClassText _JntIntrstBillgClassText 1
_JntIntrstBillgSubclass _JntIntrstBillgSubclass 1
_JntIntrstBillgSubclass2 _JntIntrstBillgSubclass2 1
_JntIntrstBillgSubclass2T _JntIntrstBillgSubclass2T 1
_JntIntrstBillgSubclassT _JntIntrstBillgSubclassT 1
_JVAExpenditureTypeText _JVAExpenditureTypeText 1
FiscalYearPeriod FiscalYearPeriod 1
JntIntrstBillgClass JntIntrstBillgClass 3
JntIntrstBillgClassText JntIntrstBillgClassText 2
JntIntrstBillgCostObjectType JntIntrstBillgCostObjectType 2
JntIntrstBillgSubClass JntIntrstBillgSubClass 3
JntIntrstBillgSubClass2 JntIntrstBillgSubClass2 3
JntIntrstBillgSubclass2Text JntIntrstBillgSubclass2Text 2
JntIntrstBillgSubClassText JntIntrstBillgSubClassText 2
JntVntrAuthznForExpndtrObject JntVntrAuthznForExpndtrObject 3
JntVntrBillgCode JntVntrBillgCode 2
JntVntrCostTypeText JntVntrCostTypeText 2
JntVntrSuspenseStatusText JntVntrSuspenseStatusText 2
JVAExpenditureType JVAExpenditureType 2
JVAExpenditureTypeText JVAExpenditureTypeText 2
JVAProjIsAuthzdForCptlExpndtr JVAProjIsAuthzdForCptlExpndtr 1
JVASupplementalDetSetForAcct JVASupplementalDetSetForAcct 1
JVASupplementalDetSetForBillg JVASupplementalDetSetForBillg 1
JVASupplementalDetSetRcvryCode JVASupplementalDetSetRcvryCode 1

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.

-- Jv Line Item Index
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JOINTVENTURELINEITEMINDEX (
    ASSETTRANSACTIONTYPE,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    FISCALPERIOD,
    FIXEDASSET,
    GLACCOUNT,
    JOINTVENTURE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREPARTNER,
    LEDGERFISCALYEAR,
    MASTERFIXEDASSET,
    ORDERID,
    PROFITCENTER,
    WBSELEMENTINTERNALID,
    _JNTINTRSTBILLGCLASS,
    _JNTINTRSTBILLGCLASSTEXT,
    _JNTINTRSTBILLGSUBCLASS,
    _JNTINTRSTBILLGSUBCLASS2,
    _JNTINTRSTBILLGSUBCLASS2T,
    _JNTINTRSTBILLGSUBCLASST,
    _JVAEXPENDITURETYPETEXT,
    FISCALYEARPERIOD,
    JNTINTRSTBILLGCLASS,
    JNTINTRSTBILLGCLASSTEXT,
    JNTINTRSTBILLGCOSTOBJECTTYPE,
    JNTINTRSTBILLGSUBCLASS,
    JNTINTRSTBILLGSUBCLASS2,
    JNTINTRSTBILLGSUBCLASS2TEXT,
    JNTINTRSTBILLGSUBCLASSTEXT,
    JNTVNTRAUTHZNFOREXPNDTROBJECT,
    JNTVNTRBILLGCODE,
    JNTVNTRCOSTTYPETEXT,
    JNTVNTRSUSPENSESTATUSTEXT,
    JVAEXPENDITURETYPE,
    JVAEXPENDITURETYPETEXT,
    JVAPROJISAUTHZDFORCPTLEXPNDTR,
    JVASUPPLEMENTALDETSETFORACCT,
    JVASUPPLEMENTALDETSETFORBILLG,
    JVASUPPLEMENTALDETSETRCVRYCODE,
    PRIMARY KEY (ASSETTRANSACTIONTYPE, BUSINESSAREA, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, FISCALPERIOD, FIXEDASSET, GLACCOUNT, JOINTVENTURE, JOINTVENTURECOSTRECOVERYCODE, JOINTVENTUREEQUITYGROUP, JOINTVENTUREPARTNER, LEDGERFISCALYEAR, MASTERFIXEDASSET, ORDERID, PROFITCENTER, WBSELEMENTINTERNALID)
);

Learn More