I_GLACCOUNTLINEITEMSEMTAG

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,
    _ACCOUNTINGDOCUMENTTYPE,
    _BASEUNIT,
    _BILLTOPARTY,
    _BUSINESSTRANSACTIONTYPE,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTANALYSISRESOURCE,
    _COSTCENTER,
    _COSTSOURCEUNIT,
    _CURRENTCOSTCENTER,
    _CURRENTPROFITCENTER,
    _CUSTOMER,
    _CUSTOMERGROUP,
    _CUSTOMERSUPPLIERCOUNTRY,
    _CUSTOMERSUPPLIERINDUSTRY,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _EMPLOYMENT,
    _EQUIPMENT,
    _FINANCIALACCOUNTTYPE,
    _FISCALYEAR,
    _FISCALYEARVARIANT,
    _FUNCTIONALAREA,
    _GLACCOUNTHIERARCHY,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _JOURNALENTRY,
    _LEDGER,
    _MATERIAL,
    _ORDER,
    _ORIGINCOSTCTRACTIVITYTYPE,
    _ORIGINPROFITCENTER,
    _PARTNERCOSTCTRACTIVITYTYPE,
    _PLANT,
    _PRODUCT,
    _PROFITCENTER,
    _PROJECT,
    _PROJECTBASICDATA,
    _PROJECTEXTERNALID,
    _PROVIDERCONTRACT,
    _PROVIDERCONTRACTITEM,
    _PURCHASINGDOCUMENT,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _SALESORGANIZATION,
    _SEGMENT,
    _SEMANTICTAG,
    _SERVICEDOCUMENT,
    _SHIPTOPARTY,
    _SOLDPRODUCT,
    _SOLDPRODUCTGROUP,
    _SOURCELEDGER,
    _SUPPLIER,
    _WBSELEMENT,
    _WBSELEMENTBASICDATA,
    _WBSELEMENTEXTERNALID,
    _WORKPACKAGE,
    _WORKPACKAGEWORKITEM,
    ACCOUNTASSIGNMENTTYPE,
    ACCOUNTINGDOCUMENTTYPE,
    ASSETCLASS,
    BASEUNIT,
    BILLABLECONTROL,
    BILLTOPARTY,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    BUSINESSSOLUTIONORDERITEM,
    BUSINESSTRANSACTIONTYPE,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONDITIONCONTRACT,
    CONTROLLINGAREA,
    CONTROLLINGDEBITCREDITCODE,
    COSTANALYSISRESOURCE,
    COSTCENTER,
    COSTSOURCEUNIT,
    CUSTOMER,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    EQUIPMENT,
    FINANCIALACCOUNTTYPE,
    FISCALYEARPERIOD,
    FISCALYEARVARIANT,
    FUNCTIONALAREA,
    GLACCOUNT,
    ISCOMMITMENT,
    LASTCHANGEDATETIME,
    LEDGERFISCALYEAR,
    MATERIAL,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    ORGANIZATIONDIVISION,
    ORIGINCOSTCTRACTIVITYTYPE,
    ORIGINPROFITCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PERSONNELNUMBER,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PROJECT,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PROJECTNETWORK,
    PROVIDERCONTRACT,
    PROVIDERCONTRACTITEM,
    PURCHASINGDOCUMENT,
    RECOGNIZEDREVNAMTINCCCRCY,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTTYPE,
    REVENUEAMOUNTINCOMPANYCODECRCY,
    SALESDISTRICT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORGANIZATION,
    SEGMENT,
    SERVICECONTRACT,
    SERVICECONTRACTITEM,
    SERVICECONTRACTTYPE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SERVICESRENDEREDDATE,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBLEDGERACCTLINEITEMTYPE,
    SUPPLIER,
    TIMESHEETOVERTIMECATEGORY,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    WORKITEM,
    WORKPACKAGE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIOD, FISCALYEAR, GLACCOUNTHIERARCHY, LEDGER, LEDGERGLLINEITEM, SEMANTICTAG, SOURCELEDGER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);