CHVW SAP table for – Table CHVW for Batch Where-Used List

Here we would like to draw your attention to CHVW table in SAP. As we know it is being mainly used with the SAP MM-IM (Inventory Management in MM) component which is coming under MM module (Material Management). CHVW is a SAP standard transparent table used for storing Table CHVW for Batch Where-Used List related data in SAP. It comes under the package MB.

SAP CHVW table

Table CHVW technical data

TableCHVW
Data storingTable CHVW for Batch Where-Used List
ModuleMM
ComponentMM-IM
SAP PackageMB
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP CHVW 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 CHVW table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KDAUF : Sales Order Number
    Its a key field. Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • MBLNR : Number of Material Document
    Its a key field. Its data type is C (Character String) with field length 10
  • MJAHR : Year of material document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • ZEILE : Item in material or invoice verification document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • XSTBW
    Its data type is C (Character String) with field length 1
  • KZBEW : Movement Indicator
    Its data type is C (Character String) with field length 1
  • XZUGA
    Its a key field. Its data type is C (Character String) with field length 1
  • SOBKZ : Special Stock Indicator
    Its data type is C (Character String) with field length 1
  • MENGE : Quantity
    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
  • ZUSCH
    Its data type is C (Character String) with field length 1
  • ZUSTD
    Its data type is C (Character String) with field length 1
  • VERAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UMWRK
    Its data type is C (Character String) with field length 4
  • UMMAT
    Its data type is C (Character String) with field length 18
  • UMCHA
    Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its a key field. Its data type is C (Character String) with field length 4
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • LICHA : Vendor Batch Number
    Its data type is C (Character String) with field length 15
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • PSTYP : Item category in purchasing document
    Its data type is C (Character String) with field length 1
  • AUTYP : Order category
    Its data type is N (Character String with Digits Only) with field length 2
  • VBELN : Sales and Distribution Document Number
    Its data type is C (Character String) with field length 10
  • POSNR : Item number of the SD document
    Its data type is N (Character String with Digits Only) with field length 6
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CHVW_CIDUMMY
  • DUMMY
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • CHARG : Batch Number
    Its a key field. Its data type is C (Character String) with field length 10
  • AUFNR : Order Number
    Its a key field. Its data type is C (Character String) with field length 12
  • AUFPS : Order item number
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • EBELN : Purchasing Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5