CHVW

Transparent Table Application Table
38 Fields 1 CDS Views

Table CHVW for Batch Where-Used List

CHVW is an SAP database table in S/4HANA. Table CHVW for Batch Where-Used List. It contains 38 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BatchHistory view from BASIC History of Batch Usage

Fields (38)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY xzuga XZUGA Receipt indic.
KEY werks WERKS_D Plant
KEY matnr MATNR Material
KEY charg CHARG_D Batch
KEY aufnr AUFNR Order
KEY aufps CO_POSNR Item Number
KEY ebeln EBELN Purchasing Doc.
KEY ebelp EBELP Item
KEY kdauf KDAUF Sales Order
KEY kdpos KDPOS Sales Ord. Item
KEY mblnr MBLNR Material Doc.
KEY mjahr MJAHR Mat. Doc. Year
KEY zeile MBLPO Mat. Doc.Item
budat BUDAT Posting Date
shkzg SHKZG Debit/Credit
bwart BWART Movement Type
xstbw XSTBW RevMvmtTypeInd.
kzbew KZBEW Movement ind.
sobkz SOBKZ Special Stock
menge MENGE_D Quantity
meins MEINS Base Unit
zusch DZUSCH Status key
zustd DZUSTD Batch restr.
verab VERAB Available from
vfdat VFDAT SLED/BBD
umwrk UMWRK Receiving plant
ummat UMMAT Receiving Mat.
umcha UMCHA Receiving Batch
lifnr LIFNR Supplier
licha LICHN Supplier Batch
kunnr KUNNR Customer
pstyp PSTYP Item Category
autyp AUFTYP Order category
vbeln VBELN_VL Delivery
posnr POSNR_VL Item
dummy DUMMY Dummy function in length 1
mill_oc_aufnr_o MILL_OC_AUFNR_MO Combined Order

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.

-- Table CHVW for Batch Where-Used List
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CHVW (
    MANDT,            -- Client [MANDT]
    XZUGA,            -- Receipt indic. [XZUGA]
    WERKS,            -- Plant [WERKS_D]
    MATNR,            -- Material [MATNR]
    CHARG,            -- Batch [CHARG_D]
    AUFNR,            -- Order [AUFNR]
    AUFPS,            -- Item Number [CO_POSNR]
    EBELN,            -- Purchasing Doc. [EBELN]
    EBELP,            -- Item [EBELP]
    KDAUF,            -- Sales Order [KDAUF]
    KDPOS,            -- Sales Ord. Item [KDPOS]
    MBLNR,            -- Material Doc. [MBLNR]
    MJAHR,            -- Mat. Doc. Year [MJAHR]
    ZEILE,            -- Mat. Doc.Item [MBLPO]
    BUDAT,            -- Posting Date [BUDAT]
    SHKZG,            -- Debit/Credit [SHKZG]
    BWART,            -- Movement Type [BWART]
    XSTBW,            -- RevMvmtTypeInd. [XSTBW]
    KZBEW,            -- Movement ind. [KZBEW]
    SOBKZ,            -- Special Stock [SOBKZ]
    MENGE,            -- Quantity [MENGE_D]
    MEINS,            -- Base Unit [MEINS]
    ZUSCH,            -- Status key [DZUSCH]
    ZUSTD,            -- Batch restr. [DZUSTD]
    VERAB,            -- Available from [VERAB]
    VFDAT,            -- SLED/BBD [VFDAT]
    UMWRK,            -- Receiving plant [UMWRK]
    UMMAT,            -- Receiving Mat. [UMMAT]
    UMCHA,            -- Receiving Batch [UMCHA]
    LIFNR,            -- Supplier [LIFNR]
    LICHA,            -- Supplier Batch [LICHN]
    KUNNR,            -- Customer [KUNNR]
    PSTYP,            -- Item Category [PSTYP]
    AUTYP,            -- Order category [AUFTYP]
    VBELN,            -- Delivery [VBELN_VL]
    POSNR,            -- Item [POSNR_VL]
    DUMMY,            -- Dummy function in length 1 [DUMMY]
    MILL_OC_AUFNR_O,  -- Combined Order [MILL_OC_AUFNR_MO]
    PRIMARY KEY (MANDT, XZUGA, WERKS, MATNR, CHARG, AUFNR, AUFPS, EBELN, EBELP, KDAUF, KDPOS, MBLNR, MJAHR, ZEILE)
);

Learn More