I_GLACCOUNTLINEITEMCUBE

CDS View
103 Fields 6 CDS Views

G/L Account Line Item - Cube

I_GLACCOUNTLINEITEMCUBE is a CDS View in S/4HANA. G/L Account Line Item - Cube. It contains 103 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
A_OpeningBalance view from COMPOSITE API Opening Balance
C_GLLineItemsQ0001 view from CONSUMPTION Journal Entry Analyzer
FAC_DART_Z3_GL_LEDGER_ITEM view from Audit Z3 G/L Accounts-Line Items
FAC_DART_Z3_JOURNAL_ENTRY view from DART Z3 G/L Accounts-Line Items
I_JointVentureAuditCube view from COMPOSITE Joint Venture Audit Report Cube
I_JVASuspenseWBSAvgCostLineItm view from COMPOSITE Avg Cost of Supense WBS Element in JVA

Fields (103)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 4
KEY FiscalPeriod FiscalPeriod 2
KEY FiscalYear FiscalYear 4
KEY Ledger Ledger 3
KEY LedgerFiscalYear LedgerFiscalYear 2
KEY LedgerGLLineItem LedgerGLLineItem 4
KEY SourceLedger SourceLedger 1
KEY WBSElement WBSElement 1
KEY WBSElementInternalID WBSElementInternalID 2
_CompanyCode _CompanyCode 2
_CompanyCodeCurrency _CompanyCodeCurrency 3
_FiscalPeriod _FiscalPeriod 1
_FiscalYear _FiscalYear 1
_FiscalYearVariant _FiscalYearVariant 1
_GLAccountType _GLAccountType 1
_JournalEntry _JournalEntry 3
_Ledger _Ledger 1
_LedgerFiscalYear _LedgerFiscalYear 1
AccountingDocCreatedByUser AccountingDocCreatedByUser 1
AccountingDocumentItem AccountingDocumentItem 2
AccountingDocumentType AccountingDocumentType 1
AmountInBalanceTransacCrcy AmountInBalanceTransacCrcy 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 1
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 1
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 1
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 1
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 1
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 1
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 1
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
AssetClass AssetClass 2
AssetTransactionType AssetTransactionType 1
BalanceTransactionCurrency BalanceTransactionCurrency 1
BaseUnit BaseUnit 1
BusinessArea BusinessArea 1
BusinessTransactionCategory BusinessTransactionCategory 1
BusinessTransactionType BusinessTransactionType 1
ClearingAccountingDocument ClearingAccountingDocument 1
CompanyCodeCurrency CompanyCodeCurrency,CreditCompanyCodeCurrency,DebitCompanyCodeCurrency 4
ControllingArea ControllingArea 1
ControllingBusTransacType ControllingBusTransacType 1
CostCenter CostCenter 1
CostObject CostObject 1
Customer Customer 1
DebitCreditCode DebitCreditCode 3
DistributionChannel DistributionChannel 1
DocumentDate DocumentDate 1
DocumentItemText DocumentItemText 1
FinancialAccountType FinancialAccountType 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 2
FixedAsset FixedAsset 1
FreeDefinedCurrency1 FreeDefinedCurrency1 1
FreeDefinedCurrency2 FreeDefinedCurrency2 1
FreeDefinedCurrency3 FreeDefinedCurrency3 1
FreeDefinedCurrency4 FreeDefinedCurrency4 1
FreeDefinedCurrency5 FreeDefinedCurrency5 1
FreeDefinedCurrency6 FreeDefinedCurrency6 1
FreeDefinedCurrency7 FreeDefinedCurrency7 1
FreeDefinedCurrency8 FreeDefinedCurrency8 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 3
GLAccountType GLAccountType 1
GlobalCurrency GlobalCurrency 1
GLRecordType GLRecordType 1
JointVenture JointVenture 1
JointVentureBillingType JointVentureBillingType 1
JointVentureCostRecoveryCode JointVentureCostRecoveryCode 2
JointVenturePartner JointVenturePartner 1
MasterFixedAsset MasterFixedAsset 1
OrderCategory OrderCategory 1
OrderID OrderID 1
OrganizationDivision OrganizationDivision 1
PartnerAccountAssignment PartnerAccountAssignment 1
PartnerAccountAssignmentType PartnerAccountAssignmentType 1
PartnerCostCenter PartnerCostCenter 1
Plant Plant 1
PostingDate PostingDate 1
Product Product 1
ProfitCenter ProfitCenter 1
ProjectNetwork ProjectNetwork 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
Quantity Quantity 1
RealEstateContract RealEstateContract 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentType ReferenceDocumentType 1
RelatedNetworkActivity RelatedNetworkActivity 1
SalesDocument SalesDocument 1
SalesOrganization SalesOrganization 1
Segment Segment 1
ServiceDocument ServiceDocument 1
ServiceDocumentType ServiceDocumentType 1
Supplier Supplier 1
TaxCode TaxCode 2
TaxCountry TaxCountry 1
TransactionCurrency TransactionCurrency 1
TransactionTypeDetermination TransactionTypeDetermination 2
ValuationArea ValuationArea 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.

-- G/L Account Line Item - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTLINEITEMCUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGER,
    LEDGERFISCALYEAR,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _FISCALPERIOD,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _GLACCOUNTTYPE,
    _JOURNALENTRY,
    _LEDGER,
    _LEDGERFISCALYEAR,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINBALANCETRANSACCRCY,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    ASSETTRANSACTIONTYPE,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    BUSINESSAREA,
    BUSINESSTRANSACTIONCATEGORY,
    BUSINESSTRANSACTIONTYPE,
    CLEARINGACCOUNTINGDOCUMENT,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGBUSTRANSACTYPE,
    COSTCENTER,
    COSTOBJECT,
    CUSTOMER,
    DEBITCREDITCODE,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDASSET,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTTYPE,
    GLOBALCURRENCY,
    GLRECORDTYPE,
    JOINTVENTURE,
    JOINTVENTUREBILLINGTYPE,
    JOINTVENTURECOSTRECOVERYCODE,
    JOINTVENTUREPARTNER,
    MASTERFIXEDASSET,
    ORDERCATEGORY,
    ORDERID,
    ORGANIZATIONDIVISION,
    PARTNERACCOUNTASSIGNMENT,
    PARTNERACCOUNTASSIGNMENTTYPE,
    PARTNERCOSTCENTER,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PROJECTNETWORK,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    REALESTATECONTRACT,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    RELATEDNETWORKACTIVITY,
    SALESDOCUMENT,
    SALESORGANIZATION,
    SEGMENT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTTYPE,
    SUPPLIER,
    TAXCODE,
    TAXCOUNTRY,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    VALUATIONAREA,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIOD, FISCALYEAR, LEDGER, LEDGERFISCALYEAR, LEDGERGLLINEITEM, SOURCELEDGER, WBSELEMENT, WBSELEMENTINTERNALID)
);

Learn More