LINEITEM

41 Fields

LINEITEM is an SAP database table in S/4HANA. It contains 41 fields.

Fields (41)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY CompanyCode CompanyCode 2
KEY FiscalPeriod FiscalPeriod 3
KEY FiscalYear FiscalYear 3
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 3
KEY PostingDate PostingDate 5
_Customer _Customer 3
_Supplier _Supplier 3
AccountingDocCreatedByUser AccountingDocCreatedByUser 5
AccountingDocumentHeaderText AccountingDocumentHeaderText 4
AccountingDocumentType AccountingDocumentType 5
AlternativeGLAccount AlternativeGLAccount 2
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInDisplayCurrency AmountInDisplayCurrency 4
AmountInTransactionCurrency AmountInTransactionCurrency 5
AssignmentReference AssignmentReference 6
BusinessArea BusinessArea 5
ClearingDate ClearingDate 5
ClearingJournalEntry ClearingJournalEntry 5
CreditAmountInDisplayCrcy CreditAmountInDisplayCrcy 2
CreditAmountInTransCrcy CreditAmountInTransCrcy 3
Customer Customer 3
DebitAmountInDisplayCrcy DebitAmountInDisplayCrcy 4
DebitAmountInTransCrcy DebitAmountInTransCrcy 5
DebitCreditCode DebitCreditCode 5
DisplayCurrency DisplayCurrency 2
DistributionChannel DistributionChannel 3
DocumentDate DocumentDate 5
DocumentItemText DocumentItemText 5
FinancialAccountType FinancialAccountType 5
GLAccount GLAccount 5
IsCleared IsCleared 4
OrganizationDivision OrganizationDivision 3
PartnerProfitCenter PartnerProfitCenter 5
ProfitCenter ProfitCenter 5
SalesOrganization SalesOrganization 3
Segment Segment 5
SpecialGLCode SpecialGLCode 5
Supplier Supplier 3
TransactionCurrency TransactionCurrency 5

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 LINEITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIOD,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    POSTINGDATE,
    _CUSTOMER,
    _SUPPLIER,
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ALTERNATIVEGLACCOUNT,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINDISPLAYCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CREDITAMOUNTINDISPLAYCRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    DEBITAMOUNTINDISPLAYCRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DISPLAYCURRENCY,
    DISTRIBUTIONCHANNEL,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    ISCLEARED,
    ORGANIZATIONDIVISION,
    PARTNERPROFITCENTER,
    PROFITCENTER,
    SALESORGANIZATION,
    SEGMENT,
    SPECIALGLCODE,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIOD, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, POSTINGDATE)
);

Learn More