_ACCOUNTINGDOCUMENT

44 Fields

_ACCOUNTINGDOCUMENT is an SAP database table in S/4HANA. It contains 44 fields.

Fields (44)

KeyField CDS FieldsUsed in Views
KEY AccountingDocCreatedByUser AccountingDocCreatedByUser,CaseCreatedBy 6
KEY AccountingDocument AccountingDocument 4
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 3
AccountingDocCreatedByUserName AccountingDocCreatedByUserName 1
AccountingDocumentCategory AccountingDocumentCategory 2
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate 4
AccountingDocumentHeaderText AccountingDocumentHeaderText 3
AccountingDocumentType AccountingDocumentType 8
AccountingDocumentTypeName AccountingDocumentTypeName 1
AcctgDocumentWorkflowStatus AcctgDocumentWorkflowStatus 1
AdditionalCurrency1 AdditionalCurrency1 2
AdditionalCurrency2 AdditionalCurrency2 2
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInTransactionCurrency AmountInTransactionCurrency 1
augbl augbl 1
budat PostingDate 1
CompanyCodeCurrency CompanyCodeCurrency 1
CompanyCodeName CompanyCodeName 1
CreationTime CreationTime 2
Currency DocumentCurrency 2
DocumentDate DocumentDate,InvoiceDate 5
DocumentReferenceID DocumentReferenceID 2
ExchangeRate ExchangeRate 2
FiscalPeriod FiscalPeriod 5
GLAccount GLAccount 2
IsReversal IsReversal 1
IsReversed IsReversed 1
LastChangeDate LastChangeDate 1
LedgerGroup LedgerGroup 2
OriginalReferenceDocument OriginalReferenceDocument 7
ParkedByUser ParkedByUser 1
ParkedByUserName ParkedByUserName 1
PostingDate PostingDate 9
Reference1InDocumentHeader Reference1InDocumentHeader 1
Reference2InDocumentHeader Reference2InDocumentHeader 1
ReferenceDocumentType ReferenceDocumentType 1
ReverseDocument ReverseDocument 1
TechnicalWrkflwObject TechnicalWrkflwObject 1
TransactionCode TransactionCode 2
TransactionCurrency TransactionCurrency 3
vatdate TaxReportingDate 1
waers TransactionCurrency 1
WorkflowInternalID WorkflowInternalID 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 _ACCOUNTINGDOCUMENT (
    ACCOUNTINGDOCCREATEDBYUSER,
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    ACCOUNTINGDOCCREATEDBYUSERNAME,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    ACCTGDOCUMENTWORKFLOWSTATUS,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINTRANSACTIONCURRENCY,
    AUGBL,
    BUDAT,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    CREATIONTIME,
    CURRENCY,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LASTCHANGEDATE,
    LEDGERGROUP,
    ORIGINALREFERENCEDOCUMENT,
    PARKEDBYUSER,
    PARKEDBYUSERNAME,
    POSTINGDATE,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTTYPE,
    REVERSEDOCUMENT,
    TECHNICALWRKFLWOBJECT,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    VATDATE,
    WAERS,
    WORKFLOWINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCCREATEDBYUSER, ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR)
);

Learn More