GLITEM

47 Fields

GLITEM is an SAP database table in S/4HANA. It contains 47 fields.

Fields (47)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentItem AccountingDocumentItem 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY Statryrptcategory Statryrptcategory 1
KEY Statryrptgentity Statryrptgentity 1
KEY TaxBox TaxBox 1
KEY TaxBoxStructureType TaxBoxStructureType 1
KEY TaxCode TaxCode 1
AccountingDocumentType AccountingDocumentType 1
BusinessPlace BusinessPlace 1
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCurrency CompanyCodeCurrency 1
Country Country 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
FinancialAccountType Financialaccounttype 1
GLAccount GLAccount 1
PostingDate PostingDate 1
ReferenceDocumentType ReferenceDocumentType 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 1
TaxAmountInCoCodeCrcy TaxAmountInCoCodeCrcy 1
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 1
TaxBoxCondition TaxBoxCondition 1
TaxBoxName TaxBoxName 1
TaxBoxStructure TaxBoxStructure 1
TaxBoxStructureName TaxBoxStructureName 1
TaxBoxStrucValidityEndDate TaxBoxStrucValidityEndDate 1
TaxBoxStrucValidityStartDate TaxBoxStrucValidityStartDate 1
TaxCountry TaxCountry 1
TaxDeclnAmountType TaxDeclnAmountType 1
TaxGroup TaxGroup 1
TaxGroupFreeClassification TaxGroupFreeClassification 1
TaxGroupOperation TaxGroupOperation 1
TaxItemGroup TaxItemGroup 1
TaxItemGroupingAccountNumber TaxItemGroupingAccountNumber 1
TaxItemGroupingVersion TaxItemGroupingVersion 1
TaxRate TaxRate 1
TaxRateValidityStartDate TaxRateValidityStartDate 1
TaxReportingDate TaxReportingDate 1
TaxType TaxType 1
TransactionTypeDetermination TransactionTypeDetermination 1
UnifiedTaxBoxStructureType UnifiedTaxBoxStructureType 1
ValidFrom ValidFrom 1
ValidTo ValidTo 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GLITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODE,
    FISCALYEAR,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    TAXBOX,
    TAXBOXSTRUCTURETYPE,
    TAXCODE,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSPLACE,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    COUNTRY,
    CUSTOMER,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    POSTINGDATE,
    REFERENCEDOCUMENTTYPE,
    SPECIALGLCODE,
    SUPPLIER,
    TAXAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBOXCONDITION,
    TAXBOXNAME,
    TAXBOXSTRUCTURE,
    TAXBOXSTRUCTURENAME,
    TAXBOXSTRUCVALIDITYENDDATE,
    TAXBOXSTRUCVALIDITYSTARTDATE,
    TAXCOUNTRY,
    TAXDECLNAMOUNTTYPE,
    TAXGROUP,
    TAXGROUPFREECLASSIFICATION,
    TAXGROUPOPERATION,
    TAXITEMGROUP,
    TAXITEMGROUPINGACCOUNTNUMBER,
    TAXITEMGROUPINGVERSION,
    TAXRATE,
    TAXRATEVALIDITYSTARTDATE,
    TAXREPORTINGDATE,
    TAXTYPE,
    TRANSACTIONTYPEDETERMINATION,
    UNIFIEDTAXBOXSTRUCTURETYPE,
    VALIDFROM,
    VALIDTO,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, COMPANYCODE, FISCALYEAR, STATRYRPTCATEGORY, STATRYRPTGENTITY, TAXBOX, TAXBOXSTRUCTURETYPE, TAXCODE)
);

Learn More