_ACCOUNTINGDOCUMENT

82 Fields

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

Fields (82)

KeyField CDS FieldsUsed in Views
KEY AccountingDocCreatedByUser AccountingDocCreatedByUser,CaseCreatedBy 6
KEY AccountingDocument AccountingDocument 4
KEY BusinessPartner BusinessPartner 6
KEY CompanyCode CompanyCode 6
KEY DCoAccountingDocumentBranch BusinessPartner,DCoAccountingDocumentBranch 6
KEY FiscalYear FiscalYear 3
_BranchAccount _BusinessPartner 1
AccountingDocCreatedByUserName AccountingDocCreatedByUserName 1
AccountingDocumentCategory AccountingDocumentCategory 2
AccountingDocumentCreationDate AccountingDocumentCreationDate,CreationDate 3
AccountingDocumentHeaderText AccountingDocumentHeaderText 3
AccountingDocumentType AccountingDocumentType 9
AccountingDocumentTypeName AccountingDocumentTypeName 1
AcctgDocumentWorkflowStatus AcctgDocumentWorkflowStatus 1
AdditionalCurrency1 AdditionalCurrency1 5
AdditionalCurrency2 AdditionalCurrency2 5
AlternativeReferenceDocument AlternativeReferenceDocument 2
AmountInTransactionCurrency AmountInTransactionCurrency 1
augbl augbl 1
budat PostingDate 1
CompanyCodeCurrency CompanyCodeCurrency 2
CompanyCodeName CompanyCodeName 1
CreationTime CreationTime 1
Currency DocumentCurrency,TransactionCurrency 5
DCoAccountingDocumentCurrency DCoAccountingDocumentCurrency 1
DCoAccountingDocumentDate DCoAccountingDocumentDate 1
DCoAccountingDocumentDueDate DCoAccountingDocumentDueDate 6
DCoAccountingDocumentID DCoAccountingDocument,DCoAccountingDocumentID 6
DCoAccountingDocumentIsCleared DCoAccountingDocumentIsCleared 1
DCoAccountingDocumentNoteText DCoAccountingDocumentNoteText 5
DCoAccountingDocumentOrigin DCoAccountingDocumentOrigin 1
DCoAcctgDocCshDiscUsedAmount DCoAcctgDocCshDiscUsedAmount 1
DCoAcctgDocHierarchyLevelValue DCoAcctgDocHierarchyLevelValue 1
DCoAcctgDocIsBlockedForPayment DCoAcctgDocIsBlockedForPayment 1
DCoAcctgDocLastPaymentDate DCoAcctgDocLastPaymentDate 1
DCoAcctgDocOriginalDueDate DCoAcctgDocOriginalDueDate 1
DCoAcctgDocumentCreditedAmount DCoAcctgDocumentCreditedAmount 6
DCoAcctgDocumentIsReversed DCoAcctgDocumentIsReversed 1
DCoAcctgDocumentLogicalSystem DCoAcctgDocumentLogicalSystem,SourceLogicalSystem 5
DCoAcctgDocumentOpenAmount DCoAcctgDocumentOpenAmount 6
DCoAcctgDocumentOriginalAmount DCoAcctgDocumentOriginalAmount 6
DCoAcctgDocumentPaidAmount DCoAcctgDocumentPaidAmount 6
DCoAcctgDocumentReference1ID DCoAcctgDocumentReference1ID 5
DCoAcctgDocumentReference2ID DCoAcctgDocumentReference2ID 5
DCoAcctgDocumentReference3ID DCoAcctgDocumentReference3ID 5
DCoAcctgDocWriteOffAmount DCoAcctgDocWriteOffAmount 6
DCoAltvDocumentReference DCoAltvDocumentReference 5
DCoDocumentReference DCoDocumentReference 6
DCoOriginalReferenceDocument DCoOriginalReferenceDocument 6
DCoOriglAccountingDocumentUUID DCoOriglAccountingDocumentUUID 6
DCoOriglRefDocLogicalSystem DCoOriglRefDocLogicalSystem 6
DCoOriglReferenceDocumentType DCoOriglReferenceDocumentType 6
DCoPaymentIsArranged DCoPaymentIsArranged 1
DCoPrdcssrAcctgDocumentUUID DCoPrdcssrAcctgDocumentUUID 1
DCoRefAccountingDocumentUUID DCoRefAccountingDocumentUUID 1
DocumentDate DocumentDate,InvoiceDate 5
DocumentReferenceID DocumentReferenceID 2
ExchangeRate ExchangeRate 2
FiscalPeriod FiscalPeriod 6
GLAccount GLAccount 2
IsReversal IsReversal 2
IsReversed IsReversed 1
LastChangeDate LastChangeDate 1
LedgerGroup LedgerGroup 2
OriginalReferenceDocument OriginalReferenceDocument 7
ParkedByUser ParkedByUser 1
ParkedByUserName ParkedByUserName 1
PartnerCompany PartnerCompany 1
PaymentDifferenceReason PaymentDifferenceReason 3
PostingClassification PostingClassification 3
PostingDate PostingDate 10
PostingSubclassification PostingSubclassification 3
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,
    BUSINESSPARTNER,
    COMPANYCODE,
    DCOACCOUNTINGDOCUMENTBRANCH,
    FISCALYEAR,
    _BRANCHACCOUNT,
    ACCOUNTINGDOCCREATEDBYUSERNAME,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTCREATIONDATE,
    ACCOUNTINGDOCUMENTHEADERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    ACCOUNTINGDOCUMENTTYPENAME,
    ACCTGDOCUMENTWORKFLOWSTATUS,
    ADDITIONALCURRENCY1,
    ADDITIONALCURRENCY2,
    ALTERNATIVEREFERENCEDOCUMENT,
    AMOUNTINTRANSACTIONCURRENCY,
    AUGBL,
    BUDAT,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    CREATIONTIME,
    CURRENCY,
    DCOACCOUNTINGDOCUMENTCURRENCY,
    DCOACCOUNTINGDOCUMENTDATE,
    DCOACCOUNTINGDOCUMENTDUEDATE,
    DCOACCOUNTINGDOCUMENTID,
    DCOACCOUNTINGDOCUMENTISCLEARED,
    DCOACCOUNTINGDOCUMENTNOTETEXT,
    DCOACCOUNTINGDOCUMENTORIGIN,
    DCOACCTGDOCCSHDISCUSEDAMOUNT,
    DCOACCTGDOCHIERARCHYLEVELVALUE,
    DCOACCTGDOCISBLOCKEDFORPAYMENT,
    DCOACCTGDOCLASTPAYMENTDATE,
    DCOACCTGDOCORIGINALDUEDATE,
    DCOACCTGDOCUMENTCREDITEDAMOUNT,
    DCOACCTGDOCUMENTISREVERSED,
    DCOACCTGDOCUMENTLOGICALSYSTEM,
    DCOACCTGDOCUMENTOPENAMOUNT,
    DCOACCTGDOCUMENTORIGINALAMOUNT,
    DCOACCTGDOCUMENTPAIDAMOUNT,
    DCOACCTGDOCUMENTREFERENCE1ID,
    DCOACCTGDOCUMENTREFERENCE2ID,
    DCOACCTGDOCUMENTREFERENCE3ID,
    DCOACCTGDOCWRITEOFFAMOUNT,
    DCOALTVDOCUMENTREFERENCE,
    DCODOCUMENTREFERENCE,
    DCOORIGINALREFERENCEDOCUMENT,
    DCOORIGLACCOUNTINGDOCUMENTUUID,
    DCOORIGLREFDOCLOGICALSYSTEM,
    DCOORIGLREFERENCEDOCUMENTTYPE,
    DCOPAYMENTISARRANGED,
    DCOPRDCSSRACCTGDOCUMENTUUID,
    DCOREFACCOUNTINGDOCUMENTUUID,
    DOCUMENTDATE,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FISCALPERIOD,
    GLACCOUNT,
    ISREVERSAL,
    ISREVERSED,
    LASTCHANGEDATE,
    LEDGERGROUP,
    ORIGINALREFERENCEDOCUMENT,
    PARKEDBYUSER,
    PARKEDBYUSERNAME,
    PARTNERCOMPANY,
    PAYMENTDIFFERENCEREASON,
    POSTINGCLASSIFICATION,
    POSTINGDATE,
    POSTINGSUBCLASSIFICATION,
    REFERENCE1INDOCUMENTHEADER,
    REFERENCE2INDOCUMENTHEADER,
    REFERENCEDOCUMENTTYPE,
    REVERSEDOCUMENT,
    TECHNICALWRKFLWOBJECT,
    TRANSACTIONCODE,
    TRANSACTIONCURRENCY,
    VATDATE,
    WAERS,
    WORKFLOWINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCCREATEDBYUSER, ACCOUNTINGDOCUMENT, BUSINESSPARTNER, COMPANYCODE, DCOACCOUNTINGDOCUMENTBRANCH, FISCALYEAR)
);

Learn More