PSM_D_GLACCTX
Additional FM Settings to GL accounts
PSM_D_GLACCTX is an SAP database table in S/4HANA. Additional FM Settings to GL accounts. It contains 12 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FGL_BCF_ALLP10 | view | left_outer | PL-items: prev. fiscal year + invert. period 0 bcf-year | |
| FGL_BCF_BS | view | left_outer | Balance Carry Forward: Balance Sheet | |
| FGL_BCF_MIG | view | left_outer | Calculate Balances from open items | |
| FGL_BCF_MIG_TR | view | left_outer | Calculate Balances from open items for treasury | |
| FGL_BCF_PL | view | left_outer | Balance Carry Forward: Profit and Loss | |
| FGL_BCF_PRFYB10 | view | left_outer | All BS-items of previous fiscal year | |
| I_CarryForwardBudgetAccount | view | from | BASIC | Carry Forward Budget Accounts |
| I_GLAccountForPublicSector | view | from | BASIC | FM Settings for GL Accounts |
Fields (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | chrt_accts | ktopl | Chart of Accts | |||
| KEY | gl_account | racct | Account Number | |||
| bdgt_cnsmpn_type | psm_bdgt_cnsmpn_type | Budget Consumption Type | ||||
| bdgt_acct_rev_or_exp | psm_bdgt_acct_rev_or_exp | Expense/Revenue | ||||
| bdgt_relevant | psm_bdgt_relevant | Budget-Relevant | ||||
| bdgt_acct_postg_allwd | psm_bdgt_acct_postg_allwd | Posting Allowed | ||||
| bdgt_acct_bdgtg_allwd | psm_bdgt_acct_bdgtg_allwd | Budgeting Allowed | ||||
| bdgt_acct_cf_use | psm_bdgt_acct_cf_use | Use Budget Account as Carry Forward Acct | ||||
| bdgt_acct_cf_to | psm_bdgt_acct_cf_to | Carry Forward to Account | ||||
| re_account | fis_re_account | Cash Origin Account | ||||
| sponsored_class | gm_sponsored_class | Sponsored Class |
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.
-- Additional FM Settings to GL accounts
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PSM_D_GLACCTX (
CLIENT, -- Client [mandt]
CHRT_ACCTS, -- Chart of Accts [ktopl]
GL_ACCOUNT, -- Account Number [racct]
BDGT_CNSMPN_TYPE, -- Budget Consumption Type [psm_bdgt_cnsmpn_type]
BDGT_ACCT_REV_OR_EXP, -- Expense/Revenue [psm_bdgt_acct_rev_or_exp]
BDGT_RELEVANT, -- Budget-Relevant [psm_bdgt_relevant]
BDGT_ACCT_POSTG_ALLWD, -- Posting Allowed [psm_bdgt_acct_postg_allwd]
BDGT_ACCT_BDGTG_ALLWD, -- Budgeting Allowed [psm_bdgt_acct_bdgtg_allwd]
BDGT_ACCT_CF_USE, -- Use Budget Account as Carry Forward Acct [psm_bdgt_acct_cf_use]
BDGT_ACCT_CF_TO, -- Carry Forward to Account [psm_bdgt_acct_cf_to]
RE_ACCOUNT, -- Cash Origin Account [fis_re_account]
SPONSORED_CLASS, -- Sponsored Class [gm_sponsored_class]
PRIMARY KEY (CLIENT, CHRT_ACCTS, GL_ACCOUNT)
);
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