MX_OPERATIONALACCTDOCITEM

32 Fields

MX_OPERATIONALACCTDOCITEM is an SAP database table in S/4HANA. It contains 32 fields.

Fields (32)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear,InvoiceReferenceFiscalYear 1
KEY Ledger Ledger 1
KEY SourceLedger SourceLedger 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
AccountingDocumentItem AccountingDocumentItem 1
AccountingDocumentType AccountingDocumentType 1
AmountInTransactionCurrency AmountInTransactionCurrency 1
ClearingDate ClearingDate 1
ClearingDocFiscalYear ClearingDocFiscalYear 1
Country Country 1
Customer Customer 1
DebitCreditCode DebitCreditCode 1
DigInvcOp1 DigInvcOp1 1
DigInvcOp2 DigInvcOp2 1
DocumentReferenceID DocumentReferenceID 1
ExchangeRate ExchangeRate 1
FinancialAccountType FinancialAccountType 1
IsReversal IsReversal 1
IsReversed IsReversed 1
JrnlEntryCntrySpecificRef5 JrnlEntryCntrySpecificRef5 1
PaymentMethod PaymentMethod 1
PostingDate PostingDate 1
ReferenceDocument ReferenceDocument 1
ReferenceDocumentContext ReferenceDocumentContext 1
ReferenceDocumentType ReferenceDocumentType 1
Supplier Supplier 1
TaxNumberLineItem TaxNumberLineItem 1
TransactionCurrency TransactionCurrency 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 MX_OPERATIONALACCTDOCITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    SOURCELEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINTRANSACTIONCURRENCY,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    COUNTRY,
    CUSTOMER,
    DEBITCREDITCODE,
    DIGINVCOP1,
    DIGINVCOP2,
    DOCUMENTREFERENCEID,
    EXCHANGERATE,
    FINANCIALACCOUNTTYPE,
    ISREVERSAL,
    ISREVERSED,
    JRNLENTRYCNTRYSPECIFICREF5,
    PAYMENTMETHOD,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    SUPPLIER,
    TAXNUMBERLINEITEM,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, SOURCELEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More