ACCOUNTINGDOCITEMWITHREF

21 Fields

ACCOUNTINGDOCITEMWITHREF is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
AccountingDocument AccountingDocument 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentItem AccountingDocumentItem 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
BusinessArea BusinessArea 1
ClearingDate ClearingDate 1
CompanyCode CompanyCode 1
CompanyCodeCurrency CompanyCodeCurrency 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
FinancialAccountType FinancialAccountType 1
FiscalYear FiscalYear 1
FollowOnDocumentType FollowOnDocumentType 1
GLAccount GLAccount 1
InvoiceItemReference InvoiceItemReference 1
InvoiceReference InvoiceReference 1
InvoiceReferenceFiscalYear InvoiceReferenceFiscalYear 1
PaymentBlockingReason PaymentBlockingReason 1
PostingDate PostingDate 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 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 ACCOUNTINGDOCITEMWITHREF (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    AMOUNTINCOMPANYCODECURRENCY,
    BUSINESSAREA,
    CLEARINGDATE,
    COMPANYCODE,
    COMPANYCODECURRENCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FISCALYEAR,
    FOLLOWONDOCUMENTTYPE,
    GLACCOUNT,
    INVOICEITEMREFERENCE,
    INVOICEREFERENCE,
    INVOICEREFERENCEFISCALYEAR,
    PAYMENTBLOCKINGREASON,
    POSTINGDATE,
    SPECIALGLCODE,
    SUPPLIER
);

Learn More