I_SEMTAGGLACCOUNT
G/L Account with Semantic Tag
I_SEMTAGGLACCOUNT is a CDS View in S/4HANA. G/L Account with Semantic Tag. It contains 7 fields. 30 CDS views read from this table.
CDS Views using this table (30)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| F_GLAccountBySemanticTag | view_entity | from | DERIVATION_FUNCTION | GL Accounts By Semantic Tag |
| FIS_COGS | view | inner | Cost of Goods Sold | |
| I_SemTagFinStmntLeafItem | view | from | COMPOSITE | Financial Statement Leaf Items for Semantic Tag |
| I_SemTagFinStmntLeafItem | view | union_all | COMPOSITE | Financial Statement Leaf Items for Semantic Tag |
| I_StatementOfChanges | view | right_outer | COMPOSITE | Statement of Changes line items |
| P_AcctgPrncpGLAcctSemTagValdty | view | from | COMPOSITE | |
| P_ActualPlanBalFlowSemtag | view | inner | COMPOSITE | |
| P_ActualPlanGLAcctBalance | view | inner | COMPOSITE | |
| P_EBRRProjMntrSemanticTagCalc | view | inner | COMPOSITE | |
| P_EBRRPrvdrContrSemTagCalc | view | inner | COMPOSITE | |
| P_EBRRSDMonSemTagCalc | view | inner | COMPOSITE | |
| P_EBRRSvdMonSemtagCalc | view | inner | COMPOSITE | |
| P_EvtBsdRevnRecgnProjMntrAmt | view | inner | COMPOSITE | |
| P_EvtBsdRevnRecgnProjMntrAmtST | view | inner | COMPOSITE | |
| P_GLAccountLineItemSemTagGLACC | view | inner | COMPOSITE | GL Account Line Item with Semantic Tag for GLAcc |
| P_GLAcctFlowSemTagDateFunc | view | inner | COMPOSITE | |
| P_GLAcctFlowSemTagDateFunc2 | view | inner | COMPOSITE | |
| P_GLAcctLineItemSemTagGLAcct | view | inner | COMPOSITE | |
| P_GLIncgOrdPrdtvAnalysisUnion | view | inner | COMPOSITE | |
| P_GrossMarginUnion_2 | view | inner | COMPOSITE | |
| P_PE_GLAccountLineItemSemTag | view_entity | inner | CONSUMPTION | |
| P_PlanLineItemSemTagGLAcc | view | inner | COMPOSITE | |
| P_PlnLineItemSemTagGLAcct | view | inner | COMPOSITE | |
| P_ProjectFinancialSummary | view | inner | COMPOSITE | |
| P_SRVCDOCREVNRECGNCHSTBASE | view | left_outer | CONSUMPTION | |
| P_SrvcDocRevnRecgnSTBase | view | inner | CONSUMPTION | |
| P_Trrmonbase | view | inner | COMPOSITE | |
| P_Trrmonchart | view | inner | COMPOSITE | |
| P_Trrsobase | view | inner | COMPOSITE | |
| P_Trrsochartbase | view | inner | COMPOSITE |
Fields (7)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ChartOfAccounts | ChartOfAccounts | 1 |
| KEY | GLAccountHierarchy | GLAccountHierarchy | 5 |
| KEY | SemanticTag | SemanticTag | 7 |
| KEY | ValidityEndDate | ValidityEndDate | 2 |
| KEY | ValidityStartDate | ValidityStartDate | 2 |
| _Hierarchy | _Hierarchy | 1 | |
| _SemanticTag | _SemanticTag | 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 with Semantic Tag
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SEMTAGGLACCOUNT (
CHARTOFACCOUNTS,
GLACCOUNTHIERARCHY,
SEMANTICTAG,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
_HIERARCHY,
_SEMANTICTAG,
PRIMARY KEY (CHARTOFACCOUNTS, GLACCOUNTHIERARCHY, SEMANTICTAG, VALIDITYENDDATE, VALIDITYSTARTDATE)
);
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