I_GLACCOUNTLINEITEMSEMTAG

CDS View
22 Fields 21 CDS Views

G/L Line Item with Semantic Tag Including FA

I_GLACCOUNTLINEITEMSEMTAG is a CDS View in S/4HANA. G/L Line Item with Semantic Tag Including FA. It contains 22 fields. 21 CDS views read from this table.

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_CashFlowIndirectIFRS view from CONSUMPTION Cash Flow Statement - Indirect Method for IFRS
C_CshFlwIndrctBsdOnAcctType view from CONSUMPTION Cash Flow Statement with Net Income from G/L Account Type
C_GLAccountLineItemSemTag view from CONSUMPTION G/L Line Item with Semantic Tag - Query
C_Profitability_Q0001 view from CONSUMPTION Project Profitability
C_Profitability_Q0002 view from CONSUMPTION Product Profitability
C_ProjectProfitabilityOverview view from CONSUMPTION Project Profitability Overview
I_FundAcctgBalanceItemC view from COMPOSITE Fund Accounting Balance Item - Cube
I_FundAcctgBalanceItemC view union_all COMPOSITE Fund Accounting Balance Item - Cube
I_GLIncgOrdPrdtvAnalysis view from COMPOSITE Pred. Analysis based on Inc. Orders
I_MargAnlysProdAndSrvcCube view from COMPOSITE Product and Service Margins - Cube
I_SlsAcctgGrssPrftDcmpstnOvw view from COMPOSITE Gross Profit Decomposition card data
I_SolnOrderProfitabilityCube view from COMPOSITE Solution Business Profitability - Cube
P_Actualplanlineitemsemtag view from COMPOSITE
P_DMVCEdgeSemanticTag view inner COMPOSITE
P_EngmntProjGLAcctLneItmSemTag view inner COMPOSITE
P_GLAccountBalanceInCCCrcy2 view from CONSUMPTION
P_GLRevenueExpensesOvw view from COMPOSITE
P_GrossMarginUnion view from COMPOSITE
P_SemTagAndSubLedgerItem view union_all COMPOSITE
P_ServiceDocLinItmFinData view from COMPOSITE
P_SrvcDocIntOrdFinData view from COMPOSITE

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY GLAccountHierarchy GLAccountHierarchy 3
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SemanticTag SemanticTag 2
KEY SourceLedger SourceLedger 1
KEY ValidityEndDate ValidityEndDate 3
KEY ValidityStartDate ValidityStartDate 3
AccountAssignmentType AccountAssignmentType 1
BusinessTransactionType BusinessTransactionType 1
CompanyCodeCurrency CompanyCodeCurrency 1
Customer Customer 1
FiscalYearVariant FiscalYearVariant 3
FunctionalArea FunctionalArea 1
PostingDate PostingDate 1
Project Project 1
RevenueAmountInCompanyCodeCrcy RevenueAmountInCompanyCodeCrcy 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 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 Line Item with Semantic Tag Including FA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCOUNTLINEITEMSEMTAG (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    GLACCOUNTHIERARCHY,
    LEDGER,
    LEDGERGLLINEITEM,
    SEMANTICTAG,
    SOURCELEDGER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    ACCOUNTASSIGNMENTTYPE,
    BUSINESSTRANSACTIONTYPE,
    COMPANYCODECURRENCY,
    CUSTOMER,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    POSTINGDATE,
    PROJECT,
    REVENUEAMOUNTINCOMPANYCODECRCY,
    SALESORDER,
    SALESORDERITEM,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIOD, FISCALYEAR, GLACCOUNTHIERARCHY, LEDGER, LEDGERGLLINEITEM, SEMANTICTAG, SOURCELEDGER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More