T030
Standard Accounts Table
T030 is an SAP database table in S/4HANA. Standard Accounts Table. It contains 8 fields. 13 CDS views read from this table.
CDS Views using this table (13)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAC_AD_CDS_SYMB_ACCT | view | from | CDS View for Symbolic Account | |
| Fac_Ad_Cds_T030 | view | from | CDS View For T030 | |
| FACVD_GLCASHMC_WLI_02 | view | left_outer | Cash account clearing worklist item | |
| FACVD_GLLGMC_WLI_02 | view | left_outer | OPEN ITEMS | |
| FACVD_GLMC_WLI_02 | view | left_outer | OPEN ITEMS | |
| fco_grir_accnt_det_view | view | from | Account determination for GR/IR | |
| fgl_bcf_acc | view | left_outer | Balance Carryforward: Acc. Master Data | |
| fgl_bcf_acc | view | inner | Balance Carryforward: Acc. Master Data | |
| fisvd_glacct_coa | view | left_outer | Master Data GLAccounts in ChartofAccts | |
| I_RetainedEarningsGLAccount | view | from | BASIC | Retained Earnings G/L Account |
| I_TransactionTypeStdGLAcct | view | from | BASIC | Transaction Type Standard G/L Account |
| P_T030 | view | from | BASIC | |
| v_fml_accnt_det | view | from | Account determination for material inventory |
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.
-- Standard Accounts Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T030 (
MANDT, -- Client [MANDT]
KTOPL, -- Chart of Accts [KTOPL]
KTOSL, -- Transaction [KTOSL]
BWMOD, -- Val.Grpg Code [BWMOD]
KOMOK, -- Account Modif. [KOMOK]
BKLAS, -- Valuation Class [BKLAS]
KONTS, -- G/L Account [SAKNR]
KONTH, -- G/L Account [SAKNR]
PRIMARY KEY (MANDT, KTOPL, KTOSL, BWMOD, KOMOK, BKLAS)
);
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