_GLACCOUNTLINEITEM

62 Fields

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

Fields (62)

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

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 (
    _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,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRYCHARTOFACCOUNTS,
    CUSTOMER,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALMANAGEMENTAREA,
    FISCALPERIOD,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUNDSCENTER,
    GLACCOUNT,
    INVENTORYVALUATIONTYPE,
    MASTERFIXEDASSET,
    MATERIAL,
    PLANT,
    POSTINGDATE,
    PRODUCT,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    REFERENCEDOCUMENT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SEGMENT,
    SUPPLIER,
    VALUATIONAREA,
    WBSELEMENT,
    WBSELEMENTINTERNALID
);

Learn More