IFW_ITEM SAP table for – Invoice forecasting item

Here we would like to draw your attention to IFW_ITEM table in SAP. As we know it is being mainly used with the SAP LO-AB (Agency Business (Global Trade) in LO) component which is coming under LO module (Logistics). IFW_ITEM is a SAP standard transparent table used for storing Invoice forecasting item related data in SAP. It comes under the package CIWB.

SAP IFW_ITEM table

Table IFW_ITEM technical data

TableIFW_ITEM
Data storingInvoice forecasting item
ModuleLO
ComponentLO-AB
SAP PackageCIWB
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP IFW_ITEM Table Fields

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

  • CLIENT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • PAIR_ITEM
    Its data type is N (Character String with Digits Only) with field length 6
  • REF_TYPE : Valid Reference Types in Structure Repository
    Its data type is C (Character String) with field length 2
  • NET_VAL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DOC_CUKY
    Its data type is C (Character String) with field length 5
  • QUANTITY : Total Quantity To Be Accrued
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • PR_STATUS
    Its data type is N (Character String with Digits Only) with field length 2
  • PRCUR
    Its data type is C (Character String) with field length 5
  • PRUOM
    Its data type is C (Character String) with field length 3
  • PR_END_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ROOT_DOC
    Its a key field. Its data type is C (Character String) with field length 20
  • FX_END_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PRCUR_RD
    Its data type is C (Character String) with field length 5
  • PRUOM_RD
    Its data type is C (Character String) with field length 3
  • INV_DUE_DATE_PRO
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PAYDD_DET_PRO
    Its data type is C (Character String) with field length 1
  • PAY_DUE_DATE_FIN
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PAYDD_DET_FIN
    Its data type is C (Character String) with field length 1
  • OUTDATED
    Its data type is C (Character String) with field length 1
  • INV_TYPE
    Its a key field. Its data type is C (Character String) with field length 2
  • INV_ITEM
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • BILL_SCEN
    Its data type is C (Character String) with field length 1