I_GLACCOUNTYEARTODATEBALANCEC
G/L Account Balances - Cube
I_GLACCOUNTYEARTODATEBALANCEC is a CDS View in S/4HANA. G/L Account Balances - Cube. It contains 85 fields. 25 CDS views read from this table.
CDS Views using this table (25)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_GLAccountYTDBalanceQ | view | from | CONSUMPTION | Year-to-Date Balances |
| I_NO_SAFTBusPartAcctBalanceEnd | view_entity | from | COMPOSITE | BP account balance at end of period |
| I_NO_SAFTBusPartAcctBalanceMvt | view_entity | from | COMPOSITE | BP Account Balance Movement |
| I_SAFTAccountBalanceEnd | view | from | COMPOSITE | GL Account End Balance |
| I_SAFTAccountBalanceMovement | view | from | COMPOSITE | GL Account Balance Movement |
| I_SAFTCustomerBalanceEnd | view | from | COMPOSITE | Customer Balance End |
| I_SAFTCustomerBalanceMovement | view | from | COMPOSITE | Customer Balance Movement |
| I_SAFTSupplierBalanceEnd | view | from | COMPOSITE | Supplier Balance End |
| I_SAFTSupplierBalanceMovement | view | from | COMPOSITE | Supplier Balance Movement |
| P_BG_SAFTBalanceBase | view_entity | from | CONSUMPTION | BG SAFT acdoca for balances |
| P_LU_SAFT_CUSTACCTBALEND | view | from | COMPOSITE | SAFT LU - Customer and GL Account Balance End |
| P_LU_SAFT_CUSTACCTBALMOV | view | from | COMPOSITE | SAFT LU - Customer and GL Account Balance Mov |
| P_LU_SAFT_SupplierAcctBalEnd | view | from | COMPOSITE | SAFT LU - Supplier and GL Account Balance End |
| P_LU_SAFT_SUPPLIERACCTBALMOV | view | from | COMPOSITE | SAFT LU - Supplier and GL Account Balance Mov |
| P_PL_SAFTAccBalanceMovement | view_entity | from | CONSUMPTION | SAF-T PL Balance Movement |
| P_PL_SAFTAccountBalanceEnd | view_entity | from | CONSUMPTION | SAFT PL GL Account Balance |
| P_RO_SAFTAccBalanceMovement | view_entity | from | CONSUMPTION | GL Account Balance Movement |
| P_RO_SAFTAccountBalanceEnd | view_entity | from | CONSUMPTION | GL Account End Balance |
| P_RO_SAFTBalanceBase | view | from | CONSUMPTION | RO SAFT acdoca for balances |
| P_SAFTGLBAL_END | view | from | COMPOSITE | Saft GL ending balance |
| P_SAFTGLBAL_MOV | view | from | COMPOSITE | Saft GL balance movements |
| P_SAFTGLCustomerBalanceMov | view | from | COMPOSITE | GL customer balance movements |
| P_SAFTGLCustomerEndBalance | view | from | COMPOSITE | GL customer ending balance |
| P_SAFTGLSupplierBalanceMov | view | from | COMPOSITE | GL supplier balance movements |
| P_SAFTGLSupplierEndBalance | view | from | COMPOSITE | GL supplier ending balance |
Fields (85)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AccountAssignmentNumber | AccountAssignmentNumber | 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 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 1 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| BalanceTransactionCurrency | BalanceTransactionCurrency | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CreditAmountInBalanceTransCrcy | CreditAmountInBalanceTransCrcy | 1 | |
| CreditAmountInCoCodeCrcy | CreditAmountInCoCodeCrcy | 1 | |
| CreditAmountInFreeDfndCrcy1 | CreditAmountInFreeDfndCrcy1 | 1 | |
| CreditAmountInFreeDfndCrcy2 | CreditAmountInFreeDfndCrcy2 | 1 | |
| CreditAmountInFreeDfndCrcy3 | CreditAmountInFreeDfndCrcy3 | 1 | |
| CreditAmountInFreeDfndCrcy4 | CreditAmountInFreeDfndCrcy4 | 1 | |
| CreditAmountInFreeDfndCrcy5 | CreditAmountInFreeDfndCrcy5 | 1 | |
| CreditAmountInFreeDfndCrcy6 | CreditAmountInFreeDfndCrcy6 | 1 | |
| CreditAmountInFreeDfndCrcy7 | CreditAmountInFreeDfndCrcy7 | 1 | |
| CreditAmountInFreeDfndCrcy8 | CreditAmountInFreeDfndCrcy8 | 1 | |
| CreditAmountInFunctionalCrcy | CreditAmountInFunctionalCrcy | 1 | |
| CreditAmountInGlobalCrcy | CreditAmountInGlobalCrcy | 1 | |
| CreditAmountInTransCrcy | CreditAmountInTransCrcy | 1 | |
| Customer | Customer | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DebitAmountInBalanceTransCrcy | DebitAmountInBalanceTransCrcy | 1 | |
| DebitAmountInCoCodeCrcy | DebitAmountInCoCodeCrcy | 1 | |
| DebitAmountInFreeDfndCrcy1 | DebitAmountInFreeDfndCrcy1 | 1 | |
| DebitAmountInFreeDfndCrcy2 | DebitAmountInFreeDfndCrcy2 | 1 | |
| DebitAmountInFreeDfndCrcy3 | DebitAmountInFreeDfndCrcy3 | 1 | |
| DebitAmountInFreeDfndCrcy4 | DebitAmountInFreeDfndCrcy4 | 1 | |
| DebitAmountInFreeDfndCrcy5 | DebitAmountInFreeDfndCrcy5 | 1 | |
| DebitAmountInFreeDfndCrcy6 | DebitAmountInFreeDfndCrcy6 | 1 | |
| DebitAmountInFreeDfndCrcy7 | DebitAmountInFreeDfndCrcy7 | 1 | |
| DebitAmountInFreeDfndCrcy8 | DebitAmountInFreeDfndCrcy8 | 1 | |
| DebitAmountInFunctionalCrcy | DebitAmountInFunctionalCrcy | 1 | |
| DebitAmountInGlobalCrcy | DebitAmountInGlobalCrcy | 1 | |
| DebitAmountInTransCrcy | DebitAmountInTransCrcy | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalQuarter | FiscalQuarter | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| FiscalYearVariant | FiscalYearVariant | 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 | |
| FunctionalCurrency | FunctionalCurrency | 1 | |
| GLAccount | GLAccount | 1 | |
| GLAccountType | GLAccountType | 1 | |
| GlobalCurrency | GlobalCurrency | 1 | |
| LedgerFiscalYear | LedgerFiscalYear | 1 | |
| OrderCategory | OrderCategory | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| PostingKey | PostingKey | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectExternalID | ProjectExternalID | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| Supplier | Supplier | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| WBSElementExternalID | WBSElementExternalID | 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 Balances - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTYEARTODATEBALANCEC (
ACCOUNTASSIGNMENTNUMBER,
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFREEDEFINEDCURRENCY1,
AMOUNTINFREEDEFINEDCURRENCY2,
AMOUNTINFREEDEFINEDCURRENCY3,
AMOUNTINFREEDEFINEDCURRENCY4,
AMOUNTINFREEDEFINEDCURRENCY5,
AMOUNTINFREEDEFINEDCURRENCY6,
AMOUNTINFREEDEFINEDCURRENCY7,
AMOUNTINFREEDEFINEDCURRENCY8,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
BALANCETRANSACTIONCURRENCY,
BUSINESSAREA,
BUSINESSTRANSACTIONTYPE,
CHARTOFACCOUNTS,
COMPANYCODE,
COMPANYCODECURRENCY,
CONTROLLINGAREA,
COSTCENTER,
COSTCTRACTIVITYTYPE,
CREDITAMOUNTINBALANCETRANSCRCY,
CREDITAMOUNTINCOCODECRCY,
CREDITAMOUNTINFREEDFNDCRCY1,
CREDITAMOUNTINFREEDFNDCRCY2,
CREDITAMOUNTINFREEDFNDCRCY3,
CREDITAMOUNTINFREEDFNDCRCY4,
CREDITAMOUNTINFREEDFNDCRCY5,
CREDITAMOUNTINFREEDFNDCRCY6,
CREDITAMOUNTINFREEDFNDCRCY7,
CREDITAMOUNTINFREEDFNDCRCY8,
CREDITAMOUNTINFUNCTIONALCRCY,
CREDITAMOUNTINGLOBALCRCY,
CREDITAMOUNTINTRANSCRCY,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DEBITAMOUNTINBALANCETRANSCRCY,
DEBITAMOUNTINCOCODECRCY,
DEBITAMOUNTINFREEDFNDCRCY1,
DEBITAMOUNTINFREEDFNDCRCY2,
DEBITAMOUNTINFREEDFNDCRCY3,
DEBITAMOUNTINFREEDFNDCRCY4,
DEBITAMOUNTINFREEDFNDCRCY5,
DEBITAMOUNTINFREEDFNDCRCY6,
DEBITAMOUNTINFREEDFNDCRCY7,
DEBITAMOUNTINFREEDFNDCRCY8,
DEBITAMOUNTINFUNCTIONALCRCY,
DEBITAMOUNTINGLOBALCRCY,
DEBITAMOUNTINTRANSCRCY,
FISCALPERIOD,
FISCALQUARTER,
FISCALYEARPERIOD,
FISCALYEARVARIANT,
FREEDEFINEDCURRENCY1,
FREEDEFINEDCURRENCY2,
FREEDEFINEDCURRENCY3,
FREEDEFINEDCURRENCY4,
FREEDEFINEDCURRENCY5,
FREEDEFINEDCURRENCY6,
FREEDEFINEDCURRENCY7,
FREEDEFINEDCURRENCY8,
FUNCTIONALAREA,
FUNCTIONALCURRENCY,
GLACCOUNT,
GLACCOUNTTYPE,
GLOBALCURRENCY,
LEDGERFISCALYEAR,
ORDERCATEGORY,
ORDERID,
ORGANIZATIONDIVISION,
PLANT,
POSTINGDATE,
POSTINGKEY,
PROFITCENTER,
PROJECTEXTERNALID,
PROJECTNETWORK,
SALESORGANIZATION,
SEGMENT,
SUPPLIER,
TRANSACTIONCURRENCY,
WBSELEMENTEXTERNALID
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA