_GLACCTBALWITHCOMPRNPERIOD

53 Fields

_GLACCTBALWITHCOMPRNPERIOD is an SAP database table in S/4HANA. It contains 53 fields.

Fields (53)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
_AccountingDocumentType _AccountingDocumentType 1
_BusinessArea _BusinessArea 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_FinancialStatementLeafItem _FinancialStatementLeafItem 1
_FinancialTransactionType _FinancialTransactionType 1
_FiscalYear _FiscalYear 1
_FunctionalArea _FunctionalArea 1
_GLAccountExternal _GLAccountExternal 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GLAccountInCompanyCode _GLAccountInCompanyCode 1
_Ledger _Ledger 1
_LedgerFiscalYear _LedgerFiscalYear 1
_ProfitCenter _ProfitCenter 1
_Segment _Segment 1
AccountingDocumentType AccountingDocumentType 1
AlternativeGLAccount AlternativeGLAccount 1
BusinessArea BusinessArea 1
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CountryChartOfAccounts CountryChartOfAccounts 1
CreditPeriodBalAmtInDspCrcy CreditPeriodBalAmtInDspCrcy 1
Currency Currency 1
DebitCreditCode DebitCreditCode 1
DebitPeriodBalAmtInDspCrcy DebitPeriodBalAmtInDspCrcy 1
EndingPeriodBalAmtInDspCrcy EndingPeriodBalAmtInDspCrcy 1
FinancialStatementLeafItem FinancialStatementLeafItem 1
FinancialTransactionType FinancialTransactionType 1
FiscalPeriod FiscalPeriod 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
GLAccountExternal GLAccountExternal 1
GLAccountInfo GLAccountInfo 1
GLAccountType GLAccountType 1
LedgerFiscalYear LedgerFiscalYear 1
OpeningPeriodBalAmtInDspCrcy OpeningPeriodBalAmtInDspCrcy 1
PartnerCompany PartnerCompany 1
PeriodBalAmtInDspCrcy PeriodBalAmtInDspCrcy 1
PeriodFlag PeriodFlag 1
PostingDate PostingDate 1
ProfitCenter ProfitCenter 1
ReportingPeriod ReportingPeriod 1
Segment Segment 1
WBSElement WBSElement 1
YearOpeningBalAmtInDspCrcy YearOpeningBalAmtInDspCrcy 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _GLACCTBALWITHCOMPRNPERIOD (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    _ACCOUNTINGDOCUMENTTYPE,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _FINANCIALSTATEMENTLEAFITEM,
    _FINANCIALTRANSACTIONTYPE,
    _FISCALYEAR,
    _FUNCTIONALAREA,
    _GLACCOUNTEXTERNAL,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLACCOUNTINCOMPANYCODE,
    _LEDGER,
    _LEDGERFISCALYEAR,
    _PROFITCENTER,
    _SEGMENT,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CREDITPERIODBALAMTINDSPCRCY,
    CURRENCY,
    DEBITCREDITCODE,
    DEBITPERIODBALAMTINDSPCRCY,
    ENDINGPERIODBALAMTINDSPCRCY,
    FINANCIALSTATEMENTLEAFITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCALPERIOD,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTEXTERNAL,
    GLACCOUNTINFO,
    GLACCOUNTTYPE,
    LEDGERFISCALYEAR,
    OPENINGPERIODBALAMTINDSPCRCY,
    PARTNERCOMPANY,
    PERIODBALAMTINDSPCRCY,
    PERIODFLAG,
    POSTINGDATE,
    PROFITCENTER,
    REPORTINGPERIOD,
    SEGMENT,
    WBSELEMENT,
    YEAROPENINGBALAMTINDSPCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM)
);

Learn More