GMSPCLASS
Sponsored Class Master
GMSPCLASS is an SAP database table in S/4HANA. Sponsored Class Master. It contains 16 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_SponsoredClassCore | view | from | EXTENSION | Manage Sponsored Class Extension |
| I_SponsoredClass | view | from | BASIC | Sponsored Class |
| I_SponsoredClassCore | view | from | BASIC | Sponsored Class |
Fields (16)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | mandt | Client | |||
| KEY | sponsored_class | gm_sponsored_class | Sponsored Class | |||
| class_type | gm_class_type | Class Type | ||||
| fipex | gm_obsolete_c24 | obsolete | ||||
| fipex_grp | gm_obsolete_c15 | obsolete | ||||
| flg_billable | gm_flg_billable | Billable | ||||
| account_for_budget | gm_budget_account_for_sp_class | Account for Budget | ||||
| validate_fmbt | gm_validate_fmbt | Valid.Budgt Transfer | ||||
| validate_fmba | gm_validate_fmba | Validate Allowed Bgt | ||||
| auth_group | gm_authgr | Authorization Group | ||||
| created_by | gm_created_by | Created by | ||||
| created_on | gm_created_on | Created on | ||||
| modified_by | gm_last_modified_by | Last Modified by | ||||
| modified_on | gm_last_modified_date | Last Modified on | ||||
| flg_inkind | gm_flg_inkind | In Kind | ||||
| chartofaccounts | ktopl | Chart of Accts |
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.
-- Sponsored Class Master
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GMSPCLASS (
CLIENT, -- Client [mandt]
SPONSORED_CLASS, -- Sponsored Class [gm_sponsored_class]
CLASS_TYPE, -- Class Type [gm_class_type]
FIPEX, -- obsolete [gm_obsolete_c24]
FIPEX_GRP, -- obsolete [gm_obsolete_c15]
FLG_BILLABLE, -- Billable [gm_flg_billable]
ACCOUNT_FOR_BUDGET, -- Account for Budget [gm_budget_account_for_sp_class]
VALIDATE_FMBT, -- Valid.Budgt Transfer [gm_validate_fmbt]
VALIDATE_FMBA, -- Validate Allowed Bgt [gm_validate_fmba]
AUTH_GROUP, -- Authorization Group [gm_authgr]
CREATED_BY, -- Created by [gm_created_by]
CREATED_ON, -- Created on [gm_created_on]
MODIFIED_BY, -- Last Modified by [gm_last_modified_by]
MODIFIED_ON, -- Last Modified on [gm_last_modified_date]
FLG_INKIND, -- In Kind [gm_flg_inkind]
CHARTOFACCOUNTS, -- Chart of Accts [ktopl]
PRIMARY KEY (CLIENT, SPONSORED_CLASS)
);
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