I_SEMTAGGLACCOUNT

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);