I_JOURNALENTRYITEMCUBE

CDS View
34 Fields 15 CDS Views

Journal Entry Item - Cube

I_JOURNALENTRYITEMCUBE is a CDS View in S/4HANA. Journal Entry Item - Cube. It contains 34 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
A_JournalEntryItemBasic view from COMPOSITE API Journal Entry Item Basic
C_CostCenterQ2001 view from CONSUMPTION Cost Centers Actuals
C_FunctionalAreasQ2801 view from CONSUMPTION Functional Areas Actuals
C_MarketSegmentQ2501 view from CONSUMPTION Market Segments Actuals
C_ProfitAndLossQ2901 view from CONSUMPTION Profit Loss Actuals
C_ProfitCenterQ2701 view from CONSUMPTION Profit Centers Actuals
C_ProjectQ2201 view from CONSUMPTION Projects Actuals
C_SalesOrderQ2301 view from CONSUMPTION Sales Orders Actuals
C_ServiceOrderQry2401 view from CONSUMPTION Service Orders Actuals
FAC_DART_Z3_SALES_LINEITEM view from Sales Documents - Line Items
I_AccountingDocumentJournal view from COMPOSITE Journal
I_AU_StRpTPARInvoiceLineItems view inner COMPOSITE Australia TPAR Invoice Line Items
I_CompactJournal view from COMPOSITE Compact Journal
I_JournalEntryItemBasic view from COMPOSITE Journal Entry Item Basic
P_JournalEntryItemBrowser view from CONSUMPTION Accounting Journal Entry Item Cube

Fields (34)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
BaseUnit BaseUnit 1
BusinessTransactionType BusinessTransactionType 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
CutbackAccount CutbackAccount 1
CutbackCostObject CutbackCostObject 1
CutbackRun CutbackRun 1
FiscalYearVariant FiscalYearVariant 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 2
JointVenture JointVenture 1
JointVentureAccountingActivity JointVentureAccountingActivity 1
JointVentureBillingDate JointVentureBillingDate 1
JointVentureBillingType JointVentureBillingType 1
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 1
JointVentureEquityGroup JointVentureEquityGroup 1
JointVentureEquityType JointVentureEquityType 1
JointVentureOperationalDate JointVentureOperationalDate 1
JointVenturePartner JointVenturePartner 1
JointVentureProductionDate JointVentureProductionDate 1
PartnerEquityGroup PartnerEquityGroup 1
PartnerVenture PartnerVenture 1
PostingDate PostingDate 1
Quantity Quantity 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
SenderCostRecoveryCode SenderCostRecoveryCode 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.

-- Journal Entry Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_JOURNALENTRYITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    LEDGER,
    LEDGERGLLINEITEM,
    AMOUNTINCOMPANYCODECURRENCY,
    BASEUNIT,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    CUTBACKACCOUNT,
    CUTBACKCOSTOBJECT,
    CUTBACKRUN,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    JOINTVENTURE,
    JOINTVENTUREACCOUNTINGACTIVITY,
    JOINTVENTUREBILLINGDATE,
    JOINTVENTUREBILLINGTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREEQUITYGROUP,
    JOINTVENTUREEQUITYTYPE,
    JOINTVENTUREOPERATIONALDATE,
    JOINTVENTUREPARTNER,
    JOINTVENTUREPRODUCTIONDATE,
    PARTNEREQUITYGROUP,
    PARTNERVENTURE,
    POSTINGDATE,
    QUANTITY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    SALESORDER,
    SALESORDERITEM,
    SENDERCOSTRECOVERYCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, LEDGER, LEDGERGLLINEITEM)
);

Learn More