SAP CSORDER_MAT Table – Administration of generated materials per sales order

The CSORDER_MAT table in SAP ERP or S/4HANA stores Administration of generated materials per sales order data. There are total 15 fields in CSORDER_MAT table. The Administration of generated materials per sales order table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CSORDER_MAT table. It is in R/3 Application development: PP Bills of Material (CS) ABAP package and is part of the Bills of Material (LO-MD-BOM) module.

SAP CSORDER_MAT Table Fields

Following is the list of fields that are available in SAP CSORDER_MAT table. The primary key fields of the table are MANDT (Client), VBELN (Sales Order), VBPOS (Sales order item), MATNR_OLD (Reference material number of a material replacement), MATNR_NEW (New material number of a material exchange).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT (3)
VBELN Sales Order CS_VBELN * CHAR (10)
VBPOS Sales order item CS_VBPOS * NUMC (6)
MATNR_OLD Reference material number of a material replacement O_MATNR_REF MARA CHAR (40)
MATNR_NEW New material number of a material exchange O_MATNR_NEW MARA CHAR (40)
MTART_OLD Reference material type of a material replacement O_MTART_REF T134 CHAR (4)
MTART_NEW New material type of a material replacement O_MTART_NEW T134 CHAR (4)
VPSTA_OLD Complete maintenance status of ref. material O_VPSTA_REF CHAR (15)
VPSTA_NEW Complete maintenance status of new material O_VPSTA_NEW CHAR (15)
WERKS Plant WERKS_D T001W CHAR (4)
ANNAM User who created record ANNAM CHAR (12)
CREATE_VIA Source of material replacement O_VIA CHAR (8)
ANDAT Date Record Created On ANDAT DATS (8)
DEL_DAT Date of Last Change AEDAT DATS (8)
LKENZ Deletion Indicator LKENZ CHAR (1)