CSPRJ_MAT SAP (Management of generated materials to project) Table details

Dictionary Type: Table
Description: Management of generated materials to project




ABAP Code to SELECT data from CSPRJ_MAT
Related tables to CSPRJ_MAT
Access table CSPRJ_MAT




Table field list including key, data, relationships and ABAP select examples

CSPRJ_MAT is a standard SAP Table which is used to store Management of generated materials to project data and is available within R/3 SAP systems depending on the version and release level.

The CSPRJ_MAT table consists of various fields, each holding specific information or linking keys about Management of generated materials to project data available in SAP. These include PSPNR (Work breakdown structure element (WBS element)), WERKS (Plant), MATNR_OLD (Reference material number of a material replacement), MATNR_NEW (New material number of a material exchange).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CSPRJ_MAT table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PSPNRWork breakdown structure element (WBS element) CS_PSPNRNUMC8PRPSABPSPPS_POSNRPEI
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATNR_OLDReference material number of a material replacement O_MATNR_REFCHAR18MARAMATN1MATNR
MATNR_NEWNew material number of a material exchange O_MATNR_NEWCHAR18MARAMATN1MATNR
MTART_OLDReference material type of a material replacement O_MTART_REFCHAR4T134MTART
MTART_NEWNew material type of a material replacement O_MTART_NEWCHAR4T134MTART
VPSTA_OLDComplete maintenance status of ref. material O_VPSTA_REFCHAR15PSTAT
VPSTA_NEWComplete maintenance status of new material O_VPSTA_NEWCHAR15PSTAT
ANNAMUser who created record ANNAMCHAR12USNAM
CREATE_VIASource of material replacement O_VIACHAR8CHAR0008
ANDATDate record created on ANDATDATS8DATUM
DEL_DATChanged On AEDATDATS8DATUM
LKENZDeletion Indicator LKENZCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table CSPRJ_MAT using ABAP code

The following ABAP code Example will allow you to do a basic selection on CSPRJ_MAT to SELECT all data from the table
DATA: WA_CSPRJ_MAT TYPE CSPRJ_MAT.

SELECT SINGLE *
FROM CSPRJ_MAT
INTO CORRESPONDING FIELDS OF WA_CSPRJ_MAT
WHERE...

How to access SAP table CSPRJ_MAT

Within an ECC or HANA version of SAP you can also view further information about CSPRJ_MAT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!