1. SAP Tutorial
  2. FI Module

FIEUD_SDINV_I SAP table for – SAFT: Invoices from SD module(Item)

Here we would like to draw your attention to FIEUD_SDINV_I table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). FIEUD_SDINV_I is a SAP standard transp table used for storing SAFT: Invoices from SD module(Item) related data in SAP. It comes under the package ID-FI-SAFT.

SAP FIEUD_SDINV_I table

Table FIEUD_SDINV_I technical data

TableFIEUD_SDINV_I
Data storingSAFT: Invoices from SD module(Item)
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-SAFT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FIEUD_SDINV_I Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FIEUD_SDINV_I table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • INVOICE_NO : Sales and Distribution Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • INV_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • POSNR : Item number of the SD document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • INV_DATE : Billing date for billing index and printout
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXT_UUID : UUID in character form
    Its a key field. Its data type is CHAR (Character String) with field length 32
  • ORG_ON : SAFT PT : Originating ON
    Its data type is CHAR (Character String) with field length 30
  • ORG_DATE : Document Date (Date Received/Sent)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PRODUCTCODE : SAFT :Product Code
    Its data type is CHAR (Character String) with field length 30
  • PRODUCTDESC : SAFT : Product Description
    Its data type is CHAR (Character String) with field length 200
  • QUANTITY : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • UNITOFMEASURE : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • UNITPRICE : 9(17)-character value field with 2 decimal places
    Its data type is CURR (Currency Field) with field length 17
  • DOCUMNTTYPE : Document category of preceding SD document
    Its data type is CHAR (Character String) with field length 1
  • VGBEL : Document number of the reference document
    Its data type is CHAR (Character String) with field length 10
  • VGPOS : Item number of the reference item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • TAXPOINTDATE : Delivery Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRED_NOTE_REF : SAFT : Reference Document
    Its data type is CHAR (Character String) with field length 60
  • CRED_NOTE_REA : SAFT : Reason
    Its data type is CHAR (Character String) with field length 50
  • DESCRIPTION_LINE : Description
    Its data type is CHAR (Character String) with field length 60
  • DOCUMENT_WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DEBIT_AMOUNT : 9(17)-character value field with 2 decimal places
    Its data type is CURR (Currency Field) with field length 17
  • CREDIT_AMOUNT : 9(17)-character value field with 2 decimal places
    Its data type is CURR (Currency Field) with field length 17
  • TAXCODE : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • TAXPERCENT : Rate (condition amount or percentage)
    Its data type is CURR (Currency Field) with field length 11
  • TAXAMOUNT : Tax Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • SHKZG : Returns item
    Its data type is CHAR (Character String) with field length 1
  • EXCHANGERATE : Exchange Rate for Pricing and Statistics
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • PLANT : Plant
    Its data type is CHAR (Character String) with field length 4
  • KNUMV : Number of the document condition
    Its data type is CHAR (Character String) with field length 10
  • KPOSN : Condition Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KAPPL : Application
    Its data type is CHAR (Character String) with field length 2
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • KAWRT : Condition Basis
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • TAXLIKE_MAT_IND : SAFT PT : Tax Like Materials Indicator
    Its data type is CHAR (Character String) with field length 1
  • DISCOUNT_AMT : 9(17)-character value field with 2 decimal places
    Its data type is CURR (Currency Field) with field length 17
  • SALES_ORDER : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • SORDER_POSNR : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • SETLMNT_AGRMNT : Own Explanation of Term of Payment
    Its data type is CHAR (Character String) with field length 50
  • CURRR_DEBIT_AMT : Value field 13(25) characters with 2 decimal places
    Its data type is CURR (Currency Field) with field length 25
  • CURR_CREDIT_AMT : Value field 13(25) characters with 2 decimal places
    Its data type is CURR (Currency Field) with field length 25
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WITH_TAXCODE : Withholding tax code
    Its data type is CHAR (Character String) with field length 2
  • WITH_TAXTYPE : SAFT PT : Withholding Tax Type
    Its data type is CHAR (Character String) with field length 3
  • WITH_TAXDESC : SAFT PT : Withholding tax type description
    Its data type is CHAR (Character String) with field length 60
  • WITH_AMOUNT : SAFT PT : Withholding Tax Amount
    Its data type is CURR (Currency Field) with field length 17
  • DISCOUNT_AGRMNT : SAFT PT : Discount Agreements
    Its data type is CHAR (Character String) with field length 30
  • DISCOUNT_DATE : SAFT : Discount Agreement Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EACCODE : SAFT PT : CAE code of Company
    Its data type is CHAR (Character String) with field length 5
  • PAYMENTTERM : SAFT : Payment Terms
    Its data type is CHAR (Character String) with field length 100
  • PAYMENTAMT : Payment Amount
    Its data type is CURR (Currency Field) with field length 17
  • PAYMENTDATE : Posting date of the payment document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PAYCURR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5

    • FIEUD_SDINV_I related tables

    • FIEUD_FISUMMARY : SAFT: FI Transaction Summary Information
    • FIEUD_FIDOC_I : SAFT: FI Transaction Document Item
    • FIEUD_SDINV_H : SAFT: Invoices from SD module(Header)
    • FIEUD_GENERIC : SAFT : Generic Customization
    • FIEUD_PRODS : SAFT : Product Type
    • FIEUD_SDGEN : SAFT : Invoice Type for SD
    • FIEUD_INVSUMMARY : SAFT: FI Transaction Summary Information
    • FIEUD_USER_HIST : SAFT: User history for extraction details
    • FIEUD_SDINV_I : SAFT: Invoices from SD module(Item)
    • FIEUD_BC : SAFT: Identifying Business Cases
    • FIEUD_FIDOC_H : SAFT: FI Transaction Document Header
    • FIEUD_MFI : SAFT : Manual FI Invoices
    • FIEUD_PAYM : SAFT : Payment Mechanism

    FIEUD_SDINV_I related transaction codes under SAP package ID-FI-SAFT

    • FIEU_PTYPE : Maintain Product Type for SAF-T
    • FIEU_MFI : Set Document Types for FI Invoices
    • FIEU_SDGEN : Maintain Invoice for SAF-T SD Inv
    • FIEU_BC : Maintain SAF-T Bussiness Cases
    • FIEU_GEN : Maintain SAF-T Generic Customization
    • FIEU_SAFT : EU : SAFT Reporting
    • FIEUVC_GEN_SAFT : SAF-T Generic Settings
    • FIEU_PAYM : Maintain Payment Mechanism for SAF-T
    • FIEU_BCP : Business Case

    Related References

    Related Tutorials

    FIEUD_SDINV_H SAP table for – SAFT: Invoices from SD module(Header)

    FIEUD_SDINV_H table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: Invoices from...

    FIEUD_MFI SAP table for – SAFT : Manual FI Invoices

    FIEUD_MFI table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT : Manual...

    FIEUD_FIDOC_I SAP table for – SAFT: FI Transaction Document Item

    FIEUD_FIDOC_I table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    FIEUD_INVSUMMARY SAP table for – SAFT: FI Transaction Summary Information

    FIEUD_INVSUMMARY table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    FIEUD_FIDOC_H SAP table for – SAFT: FI Transaction Document Header

    FIEUD_FIDOC_H table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    FIEUD_FISUMMARY SAP table for – SAFT: FI Transaction Summary Information

    FIEUD_FISUMMARY table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    SAFTPT_FIMD SAP table for – SAFT PT Master data for FI invoices

    SAFTPT_FIMD table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT PT Master...

    «
    »