_GLACCOUNTLINEITEM

65 Fields

_GLACCOUNTLINEITEM is an SAP database table in S/4HANA. It contains 65 fields.

Fields (65)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode,CompanyCode2,SourceCompanyCode 5
KEY FiscalYear FiscalYear 2
_AccountingDocumentType _AccountingDocumentType 5
_AlternativeGLAccount _AlternativeGLAccount 3
_BusinessArea _BusinessArea 5
_ChartOfAccounts _ChartOfAccounts 3
_CompanyCode _CompanyCode 3
_ControllingArea _ControllingArea 5
_CostCenter _CostCenter 5
_CountryChartOfAccounts _CountryChartOfAccounts 3
_Customer _Customer 2
_FinancialManagementArea _FinancialManagementArea 3
_FixedAsset _FixedAsset 3
_FixedAssetText _FixedAssetText 3
_FunctionalArea _FunctionalArea 5
_FundsCenter _FundsCenter 3
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 3
_InventoryValuationType _InventoryValuationType 5
_MasterFixedAsset _MasterFixedAsset 3
_Material _Material 5
_Plant _Plant 3
_Product _Product 5
_ProfitCenter _ProfitCenter 5
_PurReqValuationArea _PurReqValuationArea 5
_Segment _Segment 5
_Supplier _Supplier 2
_WBSElement _WBSElement 3
AccountingDocumentItem AccountingDocumentItem 3
AccountingDocumentType AccountingDocumentType 7
AlternativeGLAccount AlternativeGLAccount 3
AssetClass AssetClass 5
AssignmentReference AssignmentReference 5
BusinessArea BusinessArea 5
ChartOfAccounts ChartOfAccounts 3
ControllingArea ControllingArea 5
CostCenter CostCenter 5
CountryChartOfAccounts CountryChartOfAccounts 3
Customer Customer 3
DocumentDate DocumentDate 3
DocumentItemText DocumentItemText 1
FinancialManagementArea FinancialManagementArea 3
FiscalPeriod FiscalPeriod 7
FixedAsset FixedAsset 6
FunctionalArea FunctionalArea 5
FundsCenter FundsCenter 3
GLAccount GLAccount 5
GLAccountType GLAccountType 2
InventoryValuationType InventoryValuationType 5
MasterFixedAsset MasterFixedAsset 6
Material Material 5
Plant Plant 5
PostingDate PostingDate 1
Product Product 5
ProfitCenter ProfitCenter 5
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
ReferenceDocument ReferenceDocument 3
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
Segment Segment 5
Supplier Supplier 3
ValuationArea ValuationArea 5
WBSElement WBSElement 2
WBSElementInternalID WBSElementInternalID 3

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _GLACCOUNTLINEITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    _ACCOUNTINGDOCUMENTTYPE,
    _ALTERNATIVEGLACCOUNT,
    _BUSINESSAREA,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _COUNTRYCHARTOFACCOUNTS,
    _CUSTOMER,
    _FINANCIALMANAGEMENTAREA,
    _FIXEDASSET,
    _FIXEDASSETTEXT,
    _FUNCTIONALAREA,
    _FUNDSCENTER,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _INVENTORYVALUATIONTYPE,
    _MASTERFIXEDASSET,
    _MATERIAL,
    _PLANT,
    _PRODUCT,
    _PROFITCENTER,
    _PURREQVALUATIONAREA,
    _SEGMENT,
    _SUPPLIER,
    _WBSELEMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    ASSETCLASS,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CHARTOFACCOUNTS,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CUSTOMER,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALMANAGEMENTAREA,
    FISCALPERIOD,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUNDSCENTER,
    GLACCOUNT,
    GLACCOUNTTYPE,
    INVENTORYVALUATIONTYPE,
    MASTERFIXEDASSET,
    MATERIAL,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCEDOCUMENT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SEGMENT,
    SUPPLIER,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More