DOCUMENTITEM

46 Fields

DOCUMENTITEM is an SAP database table in S/4HANA. It contains 46 fields.

Fields (46)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument,ReferenceJournalEntry 4
KEY AccountingDocumentItem AccountingDocumentItem 3
KEY AlternativeGLAccount AlternativeGLAccount,GLAccount 3
KEY CompanyCode CompanyCode 4
KEY DocumentItemText DocumentItemText 4
KEY FiscalYear FiscalYear,JournalEntryFiscalYear 4
KEY GLAccount GLAccount 3
KEY Ledger Ledger 3
KEY SourceLedger SourceLedger 3
KEY StatryRptCategory StatryRptCategory 3
KEY StatryRptgEntity StatryRptgEntity 3
KEY StatryRptRunID StatryRptRunID 3
_AlternativeGLAccount _AlternativeGLAccount 1
_CompanyCode _CompanyCode 1
_FiscalYear _FiscalYear 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_TransactionCurrency _TransactionCurrency 1
AmountInCompanyCodeCurrency TaxBaseAmountInCoCodeCrcy 1
ChartOfAccounts ChartOfAccounts 3
ClearingDate ClearingDate 2
ClearingJournalEntry ClearingAccountingDocument 2
CN_TaxBuyerRegnNmbr CN_TaxBuyerRegnNmbr 1
CN_TaxInvcCodeNmbr CN_TaxInvcCodeNmbr 1
CN_TaxInvcDate CN_TaxInvcDate 1
CN_TaxInvcGldnTxSystSts CN_TaxInvcGldnTxSystSts 1
CN_TaxInvcInptProcgSts CN_TaxInvcInptProcgSts 1
CN_TaxInvcType CN_TaxInvcType 1
CN_TaxInvoiceUsage CN_TaxInvoiceUsage 1
CN_TaxInvoiceUsageDescription CN_TaxInvoiceUsageDescription 1
CN_TaxSellerName CN_TaxSellerName 1
CN_TaxSellerRegnNmbr CN_TaxSellerRegnNmbr 1
CN_TaxTransfDrctn CN_TaxTransfDrctn 1
CN_TaxTransfType CN_TaxTransfType 1
CountryChartOfAccounts CountryChartOfAccounts 3
CreditAmountInReportingCrcy CreditAmountInReportingCrcy 1
Customer Customer 1
DebitAmountInReportingCurrency DebitAmountInReportingCurrency 2
DebitCreditCode DebitCreditCode 2
DocumentReferenceID DocumentReferenceID 3
IsPostedOnAccount IsPostedOnAccount 1
PostingDate PostingDate 4
ReportingCurrency ReportingCurrency 3
Supplier Supplier 1
TransactionCurrency DocumentCurrency 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 DOCUMENTITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ALTERNATIVEGLACCOUNT,
    COMPANYCODE,
    DOCUMENTITEMTEXT,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    _ALTERNATIVEGLACCOUNT,
    _COMPANYCODE,
    _FISCALYEAR,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _JOURNALENTRY,
    _LEDGER,
    _TRANSACTIONCURRENCY,
    AMOUNTINCOMPANYCODECURRENCY,
    CHARTOFACCOUNTS,
    CLEARINGDATE,
    CLEARINGJOURNALENTRY,
    CN_TAXBUYERREGNNMBR,
    CN_TAXINVCCODENMBR,
    CN_TAXINVCDATE,
    CN_TAXINVCGLDNTXSYSTSTS,
    CN_TAXINVCINPTPROCGSTS,
    CN_TAXINVCTYPE,
    CN_TAXINVOICEUSAGE,
    CN_TAXINVOICEUSAGEDESCRIPTION,
    CN_TAXSELLERNAME,
    CN_TAXSELLERREGNNMBR,
    CN_TAXTRANSFDRCTN,
    CN_TAXTRANSFTYPE,
    COUNTRYCHARTOFACCOUNTS,
    CREDITAMOUNTINREPORTINGCRCY,
    CUSTOMER,
    DEBITAMOUNTINREPORTINGCURRENCY,
    DEBITCREDITCODE,
    DOCUMENTREFERENCEID,
    ISPOSTEDONACCOUNT,
    POSTINGDATE,
    REPORTINGCURRENCY,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ALTERNATIVEGLACCOUNT, COMPANYCODE, DOCUMENTITEMTEXT, FISCALYEAR, GLACCOUNT, LEDGER, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More