I_GLACCTLINEITEMSEMTAGGLACCT

CDS View
71 Fields 9 CDS Views

G/L Line Item with Semantic Tag

I_GLACCTLINEITEMSEMTAGGLACCT is a CDS View in S/4HANA. G/L Line Item with Semantic Tag. It contains 71 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_ActualPlanServiceMarginCube view_entity from COMPOSITE Actual and Plan Service Margin - Cube
I_CompanyMarginCube view_entity from COMPOSITE Company Margin - Cube
I_CompanyMarginCube_2 view_entity from COMPOSITE Company Margin - Cube
I_ServiceMarginCube view_entity from COMPOSITE Service Margin - Cube
P_ActlPlnLineItemSemTagGLAcct view from COMPOSITE P Actual&plan GL Account Line Item with Semetic Tag
P_EntPrjProfnlSrvcRecgdRevnDoc view_entity inner COMPOSITE Professional Service Recognized Revenue
P_EntProjProfnlSrvcCostRevenue view_entity inner COMPOSITE Prj. Cost & Revn in Transaction Currency
P_GLAcctLineItemSemTagProjects view from COMPOSITE General Ledger Account Line Item Semantic Tag For Projects
P_SemTagAndSubldgrItmDisCrcy view_entity from COMPOSITE SubLedger and Semantic Tag View

Fields (71)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY CompanyCodeCurrency CompanyCodeCurrency 3
KEY ControllingObjectCurrency ControllingObjectCurrency 2
KEY FiscalYear FiscalYear 2
KEY GlobalCurrency GlobalCurrency 3
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY PostingDate PostingDate 3
KEY ProjectInternalID ProjectInternalID 2
KEY SemanticTag SemanticTag 2
KEY SourceLedger SourceLedger 3
KEY TransactionCurrency TransactionCurrency 2
KEY WBSElementInternalID WBSElementInternalID 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GlobalCurrency _GlobalCurrency 1
_Supplier _Supplier 1
AccountAssignmentType AccountAssignmentType 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInGlobalCurrency AmountInGlobalCurrency 2
AmountInObjectCurrency AmountInObjectCurrency 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
AssetClass AssetClass 1
BaseUnit QuantityUnit 1
BillToParty BillToParty 1
BusinessArea BusinessArea 1
BusinessTransactionType BusinessTransactionType 2
ChartOfAccounts ChartOfAccounts 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostSourceUnit CostSourceUnit 1
Customer Customer 1
CustomerGroup CustomerGroup 1
CustomerSupplierCountry CustomerSupplierCountry 1
CustomerSupplierIndustry CustomerSupplierIndustry 1
DistributionChannel DistributionChannel 1
FinancialAccountType FinancialAccountType 1
FiscalPeriod FiscalPeriod 1
FiscalYearPeriod FiscalYearPeriod 1
FiscalYearVariant FiscalYearVariant 1
FixedAmountInCoCodeCrcy FixedAmountInCoCodeCrcy 1
FixedAmountInGlobalCrcy FixedAmountInGlobalCrcy 1
FixedQuantity FixedQuantity 1
FunctionalArea FunctionalArea 1
GLAccount GLAccount 1
GLAccountHierarchy GLAccountHierarchy 1
InventoryValuationType InventoryValuationType 1
LedgerFiscalYear LedgerFiscalYear 1
OrderCategory OrderCategory 1
OrderID OrderID 1
OrganizationDivision OrganizationDivision 1
Plant Plant 1
Product Product 1
ProfitCenter ProfitCenter 1
PurchasingDocument PurchasingDocument 1
Quantity Quantity 1
ReferenceDocumentType ReferenceDocumentType 1
SalesDistrict SalesDistrict 1
SalesDocument SalesDocument 1
SalesOrderItem SalesDocumentItem 1
SalesOrganization SalesOrganization 1
Segment Segment 1
ShipToParty ShipToParty 1
SoldProduct SoldProduct 1
SoldProductGroup SoldProductGroup 1
Supplier Supplier 1
ValuationArea ValuationArea 1
ValuationQuantity ValuationQuantity 1
WBSElementExternalID ProjectElement 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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCTLINEITEMSEMTAGGLACCT (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    CONTROLLINGOBJECTCURRENCY,
    FISCALYEAR,
    GLOBALCURRENCY,
    LEDGER,
    LEDGERGLLINEITEM,
    POSTINGDATE,
    PROJECTINTERNALID,
    SEMANTICTAG,
    SOURCELEDGER,
    TRANSACTIONCURRENCY,
    WBSELEMENTINTERNALID,
    _CHARTOFACCOUNTS,
    _COMPANYCODECURRENCY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLOBALCURRENCY,
    _SUPPLIER,
    ACCOUNTASSIGNMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINOBJECTCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSETCLASS,
    BASEUNIT,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTSOURCEUNIT,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FIXEDAMOUNTINCOCODECRCY,
    FIXEDAMOUNTINGLOBALCRCY,
    FIXEDQUANTITY,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLACCOUNTHIERARCHY,
    INVENTORYVALUATIONTYPE,
    LEDGERFISCALYEAR,
    ORDERCATEGORY,
    ORDERID,
    ORGANIZATIONDIVISION,
    PLANT,
    PRODUCT,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    QUANTITY,
    REFERENCEDOCUMENTTYPE,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUPPLIER,
    VALUATIONAREA,
    VALUATIONQUANTITY,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, COMPANYCODECURRENCY, CONTROLLINGOBJECTCURRENCY, FISCALYEAR, GLOBALCURRENCY, LEDGER, LEDGERGLLINEITEM, POSTINGDATE, PROJECTINTERNALID, SEMANTICTAG, SOURCELEDGER, TRANSACTIONCURRENCY, WBSELEMENTINTERNALID)
);

Learn More