ITM

89 Fields

ITM is an SAP database table in S/4HANA. It contains 89 fields.

Fields (89)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY BOPForm BOPForm 1
KEY BOPFormItem BOPFormItem 1
KEY BOPRptgCntry BOPRptgCntry 1
KEY CABPItemNumber CABPItemNumber 2
KEY CADocumentNumber CADocumentNumber 3
KEY CADocumentType CADocumentType 3
KEY CAGLItemNumber CAGLItemNumber 1
KEY CARepetitionItemNumber CARepetitionItemNumber 1
KEY CASubItemNumber CASubItemNumber 2
KEY CompanyCode CompanyCode 4
KEY FiscalYear FiscalYear 3
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SourceLedger SourceLedger 2
AccountAssignmentNumber AccountAssignmentNumber 1
AccountingDocumentType AccountingDocumentType 3
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
BOPPartnerCntry BOPPartnerCntry 1
BusinessPartner BusinessPartner 3
CAAccountDeterminationCode CAAccountDeterminationCode 2
CAAmountInLocalCurrency AmountInCompanyCodeCurrency,CAAmountInLocalCurrency 2
CAAmountInTransactionCurrency AmountInTransactionCurrency,CAAmountInTransactionCurrency 2
CAApplicationArea CAApplicationArea 2
CAClearingDate ClearingDate 1
CAClearingDocumentNumber CAClearingAccountingDocument 1
CAClearingStatus CAClearingStatus 1
CAIsDownPaymentRequest CAIsDownPaymentRequest 2
CAIsIndividualValueAdjustment CAIsIndividualValueAdjustment 1
CANetDueDate CANetDueDate 2
CAPaymentMethod CAPaymentMethod 2
CAPostingDate CAPostingDate,PostingDate 3
CAReconciliationAccount CAReconciliationAccount 2
CAReconciliationKey CAReconciliationKey 1
CAStatisticalItemCode CAStatisticalItemCode 2
CATaxAmountInLocalCurrency CATaxAmountInLocalCurrency 1
ChartOfAccounts ChartOfAccounts 4
ClearingAccountingDocument ClearingAccountingDocument 2
ClearingDate ClearingDate 2
ClearingDocFiscalYear ClearingDocFiscalYear 2
CN_TaxInvcCode CN_TaxInvcCode 2
CN_TaxInvcNmbr CN_TaxInvcNmbr 2
CompanyCodeCountry CompanyCodeCountry 1
CompanyCodeCurrency CompanyCodeCurrency 4
ContractAccount ContractAccount 2
Country Country 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 2
CreditAmountInTransCrcy CreditAmountInTransCrcy 2
Customer Customer 2
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 2
DebitAmountInTransCrcy DebitAmountInTransCrcy 2
DebitCreditCode DebitCreditCode 2
DocumentDate DocumentDate 2
FinancialAccountType FinancialAccountType 2
FiscalPeriod FiscalPeriod 1
FiscalYearVariant FiscalYearVariant 2
GLAccount GLAccount 3
HasUniqueClrgDate HasUniqueClrgDate 1
IsEUTriangularDeal IsEUTriangularDeal 1
IsReversal IsReversal 2
IsReversed IsReversed 2
OffsettingAccount OffsettingAccount 2
OffsettingAccountType OffsettingAccountType 2
PartnerCompany PartnerCompany 2
PostingDate PostingDate 2
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
SpecialGLCode SpecialGLCode 2
Supplier Supplier 2
TaxCode TaxCode 5
TaxInvoiceItem TaxInvoiceItem 2
TaxInvoiceItemGoodsNumber TaxInvoiceItemGoodsNumber 2
TaxInvoiceItemGoodsServiceName TaxInvoiceItemGoodsServiceName 2
TaxInvoiceItemNetAmount TaxInvoiceItemNetAmount 2
TaxInvoiceItemNetUnitPrice TaxInvoiceItemNetUnitPrice 2
TaxInvoiceItemQuantity TaxInvoiceItemQuantity 1
TaxInvoiceItemSpecModel TaxInvoiceItemSpecModel 2
TaxInvoiceItemTaxAmount TaxInvoiceItemTaxAmount 2
TaxInvoiceItemTaxRate TaxInvoiceItemTaxRate 2
TaxInvoiceItemTollCarCategory TaxInvoiceItemTollCarCategory 2
TaxInvoiceItemTollCarLicPlate TaxInvoiceItemTollCarLicPlate 2
TaxInvoiceItemTollEndDateTime TaxInvoiceItemTollEndDateTime 2
TaxInvoiceItemTollStrtDateTime TaxInvoiceItemTollStrtDateTime 2
TaxInvoiceItemUnitDescription TaxInvoiceItemUnitDescription 2
TransactionCurrency TransactionCurrency 4
TransactionTypeDetermination TransactionTypeDetermination 1
UniqueAcctgDocClrgDate UniqueAcctgDocClrgDate 1
UnitOfMeasure UnitOfMeasure 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 ITM (
    ACCOUNTINGDOCUMENT,
    BOPFORM,
    BOPFORMITEM,
    BOPRPTGCNTRY,
    CABPITEMNUMBER,
    CADOCUMENTNUMBER,
    CADOCUMENTTYPE,
    CAGLITEMNUMBER,
    CAREPETITIONITEMNUMBER,
    CASUBITEMNUMBER,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    ACCOUNTASSIGNMENTNUMBER,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    BOPPARTNERCNTRY,
    BUSINESSPARTNER,
    CAACCOUNTDETERMINATIONCODE,
    CAAMOUNTINLOCALCURRENCY,
    CAAMOUNTINTRANSACTIONCURRENCY,
    CAAPPLICATIONAREA,
    CACLEARINGDATE,
    CACLEARINGDOCUMENTNUMBER,
    CACLEARINGSTATUS,
    CAISDOWNPAYMENTREQUEST,
    CAISINDIVIDUALVALUEADJUSTMENT,
    CANETDUEDATE,
    CAPAYMENTMETHOD,
    CAPOSTINGDATE,
    CARECONCILIATIONACCOUNT,
    CARECONCILIATIONKEY,
    CASTATISTICALITEMCODE,
    CATAXAMOUNTINLOCALCURRENCY,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CN_TAXINVCCODE,
    CN_TAXINVCNMBR,
    COMPANYCODECOUNTRY,
    COMPANYCODECURRENCY,
    CONTRACTACCOUNT,
    COUNTRY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINTRANSCRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINTRANSCRCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    FINANCIALACCOUNTTYPE,
    FISCALPERIOD,
    FISCALYEARVARIANT,
    GLACCOUNT,
    HASUNIQUECLRGDATE,
    ISEUTRIANGULARDEAL,
    ISREVERSAL,
    ISREVERSED,
    OFFSETTINGACCOUNT,
    OFFSETTINGACCOUNTTYPE,
    PARTNERCOMPANY,
    POSTINGDATE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    SPECIALGLCODE,
    SUPPLIER,
    TAXCODE,
    TAXINVOICEITEM,
    TAXINVOICEITEMGOODSNUMBER,
    TAXINVOICEITEMGOODSSERVICENAME,
    TAXINVOICEITEMNETAMOUNT,
    TAXINVOICEITEMNETUNITPRICE,
    TAXINVOICEITEMQUANTITY,
    TAXINVOICEITEMSPECMODEL,
    TAXINVOICEITEMTAXAMOUNT,
    TAXINVOICEITEMTAXRATE,
    TAXINVOICEITEMTOLLCARCATEGORY,
    TAXINVOICEITEMTOLLCARLICPLATE,
    TAXINVOICEITEMTOLLENDDATETIME,
    TAXINVOICEITEMTOLLSTRTDATETIME,
    TAXINVOICEITEMUNITDESCRIPTION,
    TRANSACTIONCURRENCY,
    TRANSACTIONTYPEDETERMINATION,
    UNIQUEACCTGDOCCLRGDATE,
    UNITOFMEASURE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BOPFORM, BOPFORMITEM, BOPRPTGCNTRY, CABPITEMNUMBER, CADOCUMENTNUMBER, CADOCUMENTTYPE, CAGLITEMNUMBER, CAREPETITIONITEMNUMBER, CASUBITEMNUMBER, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More