ACCTDOCITM

63 Fields

ACCTDOCITM is an SAP database table in S/4HANA. It contains 63 fields.

Fields (63)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 9
KEY AccountingDocumentItem AccountingDocumentItem 9
KEY AccountingDocumentType AccountingDocumentType 10
KEY BusinessArea BusinessArea 10
KEY CompanyCode CompanyCode 10
KEY CostCenter CostCenter 10
KEY FiscalYear FiscalYear 9
KEY GLAccount GLAccount 10
KEY GLAccountInPurchaseOrg GLAccountInPurchaseOrg 8
KEY JP_VATReturnRule JP_VATReturnRule 3
KEY TaxCode TaxCode 10
AccountAssignmentNumber AccountAssignmentNumber 3
AccountingDocumentItemType AccountingDocumentItemType 9
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 9
AmountInTransactionCurrency AmountInTransactionCurrency 9
BalanceTransactionCurrency BalanceTransactionCurrency 9
BaseUnit BaseUnit 9
CAReconciliationKey CAReconciliationKey 1
CompanyCodeCurrency CompanyCodeCurrency 10
DebitCreditCode DebitCreditCode 9
DistributedTaxAmountInCcrcy DistributedTaxAmountInCCrcy 6
DocumentDate DocumentDate 9
DocumentItemText DocumentItemText 9
FinancialAccountType FinancialAccountType 9
FiscalPeriod FiscalPeriod 9
haveonlyonebset haveonlyonebset 2
Isvstmst Isvstmst 2
JP_DcblNatlPrtAmtInCoCodeCrcy JP_DcblNatlPrtAmtInCoCodeCrcy 6
JP_VATReturnRuleName JP_VATReturnRuleName 1
JP_VATReturnRules JP_VATReturnRules 4
JP_VATReturnRuleTaxRateDesc JP_VATReturnRuleTaxRateDesc 1
Material Material 9
OriginalReferenceDocument OriginalReferenceDocument 9
OriglTaxBaseAmountInCoCodeCrcy OriglTaxBaseAmountInCoCodeCrcy 3
PostingDate PostingDate 9
PostingKey PostingKey 9
PurchasingDocument PurchasingDocument 9
PurchasingDocumentItem PurchasingDocumentItem 9
Quantity Quantity 9
ReconciliationAccountType ReconciliationAccountType 1
ReferenceDocumentType ReferenceDocumentType 6
RuleOrder RuleOrder 3
StatryRptRun StatryRptRun 1
SystemMessageIdentification SystemMessageIdentification 4
T_DebitCreditCode T_DebitCreditCode 2
T_TaxCode T_TaxCode 2
T_TaxItemGroup T_TaxItemGroup 2
TaxAmt TaxAmt 2
TaxBaseAmountInCoCodeCrcy TaxBaseAmountInCoCodeCrcy 5
TaxBaseAmountInTransCrcy TaxBaseAmountInTransCrcy 5
TaxBaseAmt TaxBaseAmt 2
TaxBaseAmtTcc TaxBaseAmtTcc 2
TaxBrkdwnAmount1InCoCodeCrcy TaxBrkdwnAmount1InCoCodeCrcy 3
TaxBrkdwnAmount2InCoCodeCrcy TaxBrkdwnAmount2InCoCodeCrcy 3
TaxBrkdwnAmount3InCoCodeCrcy TaxBrkdwnAmount3InCoCodeCrcy 3
TaxDistributionCode1 TaxDistributionCode1 3
TaxDistributionCode2 TaxDistributionCode2 3
TaxDistributionCode3 TaxDistributionCode3 3
TaxItemGroup TaxItemGroup 9
TaxRate TaxRate 1
TaxReportingDate TaxReportingDate 8
TransactionCurrency TransactionCurrency 9
TransactionTypeDetermination TransactionTypeDetermination 9

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 ACCTDOCITM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTTYPE,
    BUSINESSAREA,
    COMPANYCODE,
    COSTCENTER,
    FISCALYEAR,
    GLACCOUNT,
    GLACCOUNTINPURCHASEORG,
    JP_VATRETURNRULE,
    TAXCODE,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENTITEMTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BALANCETRANSACTIONCURRENCY,
    BASEUNIT,
    CARECONCILIATIONKEY,
    COMPANYCODECURRENCY,
    DEBITCREDITCODE,
    DISTRIBUTEDTAXAMOUNTINCCRCY,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    HAVEONLYONEBSET,
    ISVSTMST,
    JP_DCBLNATLPRTAMTINCOCODECRCY,
    JP_VATRETURNRULENAME,
    JP_VATRETURNRULES,
    JP_VATRETURNRULETAXRATEDESC,
    MATERIAL,
    ORIGINALREFERENCEDOCUMENT,
    ORIGLTAXBASEAMOUNTINCOCODECRCY,
    POSTINGDATE,
    POSTINGKEY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    QUANTITY,
    RECONCILIATIONACCOUNTTYPE,
    REFERENCEDOCUMENTTYPE,
    RULEORDER,
    STATRYRPTRUN,
    SYSTEMMESSAGEIDENTIFICATION,
    T_DEBITCREDITCODE,
    T_TAXCODE,
    T_TAXITEMGROUP,
    TAXAMT,
    TAXBASEAMOUNTINCOCODECRCY,
    TAXBASEAMOUNTINTRANSCRCY,
    TAXBASEAMT,
    TAXBASEAMTTCC,
    TAXBRKDWNAMOUNT1INCOCODECRCY,
    TAXBRKDWNAMOUNT2INCOCODECRCY,
    TAXBRKDWNAMOUNT3INCOCODECRCY,
    TAXDISTRIBUTIONCODE1,
    TAXDISTRIBUTIONCODE2,
    TAXDISTRIBUTIONCODE3,
    TAXITEMGROUP,
    TAXRATE,
    TAXREPORTINGDATE,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTITEM, ACCOUNTINGDOCUMENTTYPE, BUSINESSAREA, COMPANYCODE, COSTCENTER, FISCALYEAR, GLACCOUNT, GLACCOUNTINPURCHASEORG, JP_VATRETURNRULE, TAXCODE)
);

Learn More