SAP RCPS_IDL_MATERIAL_DATA Material Data Table data and field list

RCPS_IDL_MATERIAL_DATA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Material Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_RCPS_IDL_MATERIAL_DATA TYPE RCPS_IDL_MATERIAL_DATA.

The RCPS_IDL_MATERIAL_DATA table consists of various fields, each holding specific information or linking keys about Material Data data available in SAP. These include MATERIAL (Material Number), IND_SECTOR (Industry sector), MATL_TYPE (Material Type), CREATED_ON (Created On)... 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. .

RCPS_IDL_MATERIAL_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP RCPS_IDL_MATERIAL_DATA structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the RCPS_IDL_MATERIAL_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTDATA 0
MATERIALMaterial Number MATNRCHAR18MATN1MATNRMATS_MAT1
IND_SECTORIndustry sector MBRSHCHAR1MBRSHMTP
MATL_TYPEMaterial Type MTARTCHAR4MTARTMTA
CREATED_ONCreated On ERSDADATS8DATUM
CREATED_BYName of Person who Created the Object ERNAMCHAR12USNAM
LAST_CHNGEDate of Last Change LAEDADATS8DATUM
CHANGED_BYName of Person Who Changed Object AENAMCHAR12USNAM
MAT_STATUSMaintenance status of complete material VPSTACHAR15PSTAT
MAINT_STATMaintenance status PSTAT_DCHAR15PSTAT
MATL_GROUPMaterial Group MATKLCHAR9MATKLMKLS_WBWG
OLD_MAT_NOOld material number BISMTCHAR18BISMT
BASE_UOMBase Unit of Measure MEINSUNIT3CUNITMEINS
BASE_UOM_ISOBase unit of measure in ISO code MEINS_ISOCHAR3ISOCD_UNIT
PO_UNITPurchase Order Unit of Measure BSTMEUNIT3CUNITMEINS
PO_UNIT_ISOOrder unit in ISO code BSTME_ISOCHAR3ISOCD_UNIT
DOCUMENTDocument number (without document management system) DZEINRCHAR22CHAR22
DOC_TYPEDocument type (without Document Management system) DZEIARCHAR3ZEIAR
DOC_VERSDocument version (without Document Management system) DZEIVRCHAR2VERSI
DOC_FORMATPage format of document (without Document Management system) DZEIFOCHAR4DINFO
DOC_CHG_NODocument change number (without document management system) AESZNCHAR6AENUM
PAGE_NOPage number of document (without Document Management system) BLATTCHAR3BLATT
NO_SHEETSNumber of sheets (without Document Management system) BLANZNUMC3NUM3
PROD_MEMOProduction/inspection memo FERTHCHAR18FERTH
PAGEFORMATPage Format of Production Memo FORMTCHAR4DINFO
SIZE_DIMSize/dimensions GROESCHAR32CHAR32
BASIC_MATLBasic Material WRKSTCHAR48WRKST
STD_DESCRIndustry Standard Description (such as ANSI or ISO) NORMTCHAR18NORMT
DSN_OFFICELaboratory/design office LABORCHAR3LABOR
PUR_VALKEYPurchasing Value Key EKWSLCHAR4EKWSL
NET_WEIGHTNet Weight NTGEWQUAN13(3) MENG13
UNIT_OF_WTWeight Unit GEWEIUNIT3CUNITMEINS
UNIT_OF_WT_ISOUnit of weight in ISO code GEWEI_ISOCHAR3ISOCD_UNIT
CONTAINERContainer requirements BEHVOCHAR2BEHVO
STOR_CONDSStorage conditions RAUBECHAR2RAUBE
TEMP_CONDSTemperature conditions indicator TEMPBCHAR2TEMPB
TRANS_GRPTransportation Group TRAGRCHAR4TRAGR
HAZ_MAT_NOHazardous material number STOFFCHAR18MATN1STOFFSTO
DIVISIONDivision SPARTCHAR2SPARTSPAC_SPART
COMPETITORCompetitor WETTBCHAR10ALPHAKUNNRKUN
QTY_GR_GIQuantity: Number of GR/GI slips to be printed WESCHQUAN13(3) MENG13
PROC_RULEProcurement rule BWVORCHAR1BWVOR
SUP_SOURCESource of Supply BWSCLCHAR1BQSCL
SEASONSeason Category SAISOCHAR4SAISOSAISO
LABEL_TYPELabel type ETIARCHAR2ETIAR
LABEL_FORMLabel form ETIFOCHAR2ETIFO
PROD_HIERProduct hierarchy PRODH_DCHAR18PRODHVPR
CAD_IDCAD Indicator CADKZCHAR1XFELD
ALLOWED_WTAllowed packaging weight ERGEWQUAN13(3) MENG13
PACK_WT_UNUnit of weight (allowed packaging weight) ERGEIUNIT3CUNITMEINS
PACK_WT_UN_ISOUnit of weight (allowed packaging weight) in ISO code ERGEI_ISOCHAR3ISOCD_UNIT
ALLWD_VOLAllowed packaging volume ERVOLQUAN13(3) MENG13
PACK_VO_UNVolume unit (allowed packaging volume) ERVOEUNIT3CUNITMEINS
PACK_VO_UN_ISOVolume unit (allowed packaging volume) in ISO code ERVOE_ISOCHAR3ISOCD_UNIT
WT_TOL_LTExcess Weight Tolerance for Handling unit GEWTODEC3(1) PRZ21
VOL_TOL_LTExcess Volume Tolerance of the Handling Unit VOLTODEC3(1) PRZ21
VAR_ORD_UNVariable Purchase Order Unit Active VABMECHAR1VABME
CONFIGUREDConfigurable Material KZKFGCHAR1XFELD
BATCH_MGMTBatch management requirement indicator XCHPFCHAR1XFELD
SH_MAT_TYPPackaging Material Type VHIARTCHAR4TRATY
FILL_LEVELMaximum level (by volume) FUELGDEC3DEC3
STACK_FACTStacking factor STFAKINT25INT2
MAT_GRP_SMMaterial Group: Packaging Materials MAGRVCHAR4MAGRV
AUTHORITYGROUPAuthorization Group BEGRUCHAR4BEGRU
QM_PROCMNTQM in Procurement is Active QMPURCHAR1XFELD
CATPROFILECatalog Profile RBNRCHAR9RBNR
MINREMLIFEMinimum Remaining Shelf Life MHDRZDEC4DEC4
SHELF_LIFETotal shelf life MHDHBDEC4DEC4
STOR_PCTStorage percentage MHDLPDEC3DEC3
CONF_MATLCross-Plant Configurable Material SATNRCHAR18MATN1MATNR
CO_PRODUCTIndicator: Material can be co-product KZKUPMATCHAR1FLAG
PR_REF_MATPricing Reference Material PMATNCHAR18MATN1MATNRMAT
PUR_STATUSCross-Plant Material Status MSTAECHAR2MMSTA
SAL_STATUSCross-distribution-chain material status MSTAVCHAR2VMSTA
PVALIDFROMDate from which the cross-plant material status is valid MSTDEDATS8DATUM
SVALIDFROMDate from which the X-distr.-chain material status is valid MSTDVDATS8DATUM
ENVT_RLVTEnvironmentally Relevant KZUMWCHAR1XFELD
PROD_ALLOCProduct allocation determination procedure KOSCHCHAR18KOSCH
QUAL_DIKMaterial qualifies for discount in kind NRFHGCHAR1NRFHG
MANU_MATManufacturer Part Number MFRPNCHAR40CHAR40
MFR_NONumber of a Manufacturer MFRNRCHAR10ALPHALIFNR
INV_MAT_NONumber of firm's own (internal) inventory-managed material MPMATCHAR18MATN1MATNRMAT
MANUF_PROFManufacturer Part Profile MPROFCHAR4MPROF
HAZMATPROFDangerous Goods Indicator Profile ADGE_PROFLCHAR3ADGD_PROFL
HIGH_VISCIndicator: Highly Viscous ADGE_IHIVICHAR1X
LOOSEORLIQIndicator: In Bulk/Liquid ADGE_ILOOSCHAR1X
CLOSED_BOXPackaging Material is Closed Packaging KZGVHCHAR1XFELD
APPD_B_RECIndicator: Approved batch record required XGCHPCHAR1XFELD
MATCMPLLVLMaterial completion level CSCP_COMP_LVLNUMC2CSCP_COMP_LVL
PAR_EFFAssign effectivity parameter values/ override change numbers CC_MTEFFCHAR1XFELD
ROUND_UP_RULE_EXPIRATION_DATERounding rule for calculation of SLED RDMHDCHAR1RDMHD
PERIOD_IND_EXPIRATION_DATEPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
PROD_COMPOSITION_ON_PACKAGINGIndicator: Product composition printed on packaging PRZUSCHAR1XFELD
ITEM_CATGeneral item category group MTPOS_MARACHAR4MTPOS
HAZ_MAT_NO_EXTERNALLong Material Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_EXTERNALCHAR40MATNR_EXT
HAZ_MAT_NO_GUIDExternal GUID for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_GUIDCHAR32MATNR_EGUID
HAZ_MAT_NO_VERSIONVersion Number for HAZ_MAT_NO Field MGV_HAZ_MAT_NO_VERSIONCHAR10MATNWMATNR_VERS
INV_MAT_NO_EXTERNALLong Material Number for INV_MAT_NO Field MGV_INV_MAT_NO_EXTERNALCHAR40MATNR_EXT
INV_MAT_NO_GUIDExternal GUID for INV_MAT_NO Field MGV_INV_MAT_NO_GUIDCHAR32MATNR_EGUID
INV_MAT_NO_VERSIONVersion Number for INV_MAT_NO Field MGV_INV_MAT_NO_VERSIONCHAR10MATNWMATNR_VERS
MATERIAL_FIXEDMaterial Is Locked MATFICHAR1XFELD
CM_RELEVANCE_FLAGRelevant for Configuration Management DE_CM_RELEVANCE_FLAGCHAR1DO_CM_RELEVANCE_FLAG
SLED_BBDExpiration Date SLED_BBDCHAR1SLED_BBD
GTIN_VARIANTGlobal Trade Item Number Variant GTIN_VARIANTCHAR2GTIN_VARIANT
SERIALIZATION_LEVELLevel of Explicitness for Serial Number SERLVCHAR1SERLV
PL_REF_MATReference material for materials packed in same way PL_RMATPCHAR18MATN1MATNRMAT
EXTMATLGRPExternal Material Group EXTWGCHAR18EXTWG
UOMUSAGEUnits of measure usage KZWSOCHAR1KZWSO
GDS_RELEVANTIndicator: Global Data Synchronization-Relevant GDS_RELEVANTCHAR1XFELD
MATERIAL_EXTERNALLong Material Number for MATERIAL Field MGV_MATERIAL_EXTERNALCHAR40MATNR_EXT
MATERIAL_GUIDExternal GUID for MATERIAL Field MGV_MATERIAL_GUIDCHAR32MATNR_EGUID
MATERIAL_VERSIONVersion Number for MATERIAL Field MGV_MATERIAL_VERSIONCHAR10MATNWMATNR_VERS
CONF_MATL_EXTERNALLong Material Number for CONF_MATL field MGV_CONF_MATL_EXTERNALCHAR40MATNR_EXT
CONF_MATL_GUIDExternal GUID for CONF_MATL Field MGV_CONF_MATL_GUIDCHAR32MATNR_EGUID
CONF_MATL_VERSIONVersion Number for Field CONF_MATL MGV_CONF_MATL_VERSIONCHAR10MATNWMATNR_VERS
PL_REF_MAT_EXTERNALLong Material Number for PL_REF_MAT Field MGV_PL_REF_MAT_EXTERNALCHAR40MATNR_EXT
PL_REF_MAT_GUIDExternal GUID for PL_REF_MAT Field MGV_PL_REF_MAT_GUIDCHAR32MATNR_EGUID
PL_REF_MAT_VERSIONVersion Number for PL_REF_MAT Field MGV_PL_REF_MAT_VERSIONCHAR10MATNWMATNR_VERS
PR_REF_MAT_EXTERNALLong Material Number for PR_REF_MAT Field MGV_PR_REF_MAT_EXTERNALCHAR40MATNR_EXT
PR_REF_MAT_GUIDExternal GUID for PR_REF_MAT Field MGV_PR_REF_MAT_GUIDCHAR32MATNR_EGUID
PR_REF_MAT_VERSIONVersion Number for PR_REF_MAT Field MGV_PR_REF_MAT_VERSIONCHAR10MATNWMATNR_VERS
WE_ORIGIN_ACCEPTANCEAcceptance At Origin WEORACHAR1XFELD
PLANTDATA 0
PLANTPlant WERKS_DCHAR4WERKSWRKH_T001W_C
MAINT_STATMaintenance status PSTAT_DCHAR15PSTAT
DEL_FLAGFlag Material for Deletion at Plant Level LVOWKCHAR1XFELD
ABC_IDABC Indicator MAABCCHAR1MAABC
CRIT_PARTIndicator: Critical part KZKRICHAR1XFELD
PUR_GROUPPurchasing Group EKGRPCHAR3EKGRPEKG
ISSUE_UNITUnit of issue AUSMEUNIT3CUNITMEINS
ISSUE_UNIT_ISOUnit of issue in ISO code AUSME_ISOCHAR3ISOCD_UNIT
MRPPROFILEMaterial: MRP profile DISPRCHAR4DISPRDPR
MRP_TYPEMRP Type DISMMCHAR2DISMM
MRP_CTRLERMRP Controller (Materials Planner) DISPOCHAR3DISPODGRHS_T024D
PLND_DELRYPlanned Delivery Time in Days PLIFZDEC3DEC3
GR_PR_TIMEGoods Receipt Processing Time in Days WEBAZDEC3DEC3
PERIOD_INDPeriod Indicator PERKZCHAR1PERKZPKZ
ASSY_SCRAPAssembly scrap in percent AUSSSDEC5(2) DEC3_2
LOTSIZEKEYLot size (materials planning) DISLSCHAR2DISLS
PROC_TYPEProcurement Type BESKZCHAR1BESKZMBS
SPPROCTYPESpecial procurement type SOBSLCHAR2SOBSL
REORDER_PTReorder Point MINBEQUAN13(3) MENG13
SAFETY_STKSafety Stock EISBEQUAN13(3) MENG13
MINLOTSIZEMinimum Lot Size BSTMIQUAN13(3) MENG13
MAXLOTSIZEMaximum Lot Size BSTMAQUAN13(3) MENG13
FIXED_LOTFixed lot size BSTFEQUAN13(3) MENG13
ROUND_VALRounding value for purchase order quantity BSTRFQUAN13(3) MENG13
MAX_STOCKMaximum stock level MABSTQUAN13(3) MENG13
ORD_COSTSOrdering costs (BAPI interfaces) LOSFX_BAPIDEC23(4) BAPICURR
DEP_REQ_IDDependent requirements ind. for individual and coll. reqmts SBDKZCHAR1SBDKZ
STOR_COSTSStorage costs indicator LAGPRCHAR1LAGPR
ALT_BOM_IDMethod for Selecting Alternative Bills of Material ALTSLCHAR1ALTSL
DISCONTINUDiscontinuation indicator KZAUSCHAR1KZAUS
EFF_O_DAYEffective-Out Date AUSDTDATS8DATUM
FOLLOW_UPFollow-Up Material NFMATCHAR18MATN1MATNRMAT
GRP_REQMTSIndicator for Requirements Grouping KZBEDCHAR1KZBED
MIXED_MRPMixed MRP indicator MISKZCHAR1MISKZ
SM_KEYScheduling Margin Key for Floats FHORICHAR3FHORI
BACKFLUSHIndicator: Backflush RGEKMCHAR1RGEKM
PRODUCTION_SCHEDULERProduction Supervisor FEVORCHAR3FEVORCFV
PROC_TIMEProcessing time BEARZDEC5(2) DEC3_2
SETUPTIMESetup and teardown time RUEZTDEC5(2) DEC3_2
INTEROPInteroperation time TRANZDEC5(2) DEC3_2
BASE_QTYBase quantity BASMGQUAN13(3) MENG13
INHSEPRODTIn-house production time DZEITDEC3DEC3
STGEPERIODMaximum Storage Period MAXLZDEC5DEC5
STGE_PD_UNUnit for maximum storage period LZEIHUNIT3CUNITMEINS
STGE_PD_UN_ISOUnit for the maximum storage period in ISO code LZEIH_ISOCHAR3ISOCD_UNIT
OVER_TOLOverdelivery tolerance limit UEETODEC3(1) DEC2_1
UNLIMITEDIndicator: Unlimited Overdelivery Allowed UEETKCHAR1XFELD
UNDER_TOLUnderdelivery tolerance limit UNETODEC3(1) DEC2_1
REPLENTIMETotal replenishment lead time (in workdays) WZEITDEC3DEC3
REPLACE_PTReplacement part ATPKZCHAR1ATPKZ
IND_POST_TO_INSP_STOCKPost to Inspection Stock INSMK_MATCHAR1QKZ
CTRL_KEYControl Key for Quality Management in Procurement QSSPURCHAR8QSSPUR
DOC_REQDDocumentation required indicator KZDKZCHAR1XFELD
LOADINGGRPLoading Group LADGRCHAR4LADGR
BATCH_MGMTBatch management requirement indicator XCHPFCHAR1XFELD
QUOTAUSAGEQuota arrangement usage USEQUCHAR1USEQU
SERV_LEVELService level LGRADDEC3(1) DEC2_1
SPLIT_INDSplitting Indicator AUFTLCHAR1AUFTL
AVAILCHECKChecking Group for Availability Check MTVFPCHAR2MTVFP
FY_VARIANTFiscal Year Variant PERIVCHAR2PERIV
CORR_FACTIndicator: take correction factors into account KZKFKCHAR1XFELD
SETUP_TIMEShipping setup time VRVEZDEC5(2) DEC3_2
BASE_QTY_PLANBase quantity for capacity planning in shipping VBAMGQUAN13(3) MENG13
SHIP_PROC_TIMEShipping processing time VBEAZDEC5(2) DEC3_2
SUP_SOURCESource of Supply BWSCLCHAR1BQSCL
AUTO_P_ORDIndicator: 'automatic purchase order allowed' KAUTBCHAR1FLAG
SOURCELISTIndicator: Source list requirement KORDBCHAR1XFELD
COMM_CODECommodity Code/Import Code Number for Foreign Trade STAWNCHAR17STAWN
COUNTRYORICountry of origin of the material HERKLCHAR3LAND1LND
COUNTRYORI_ISOMaterial's country of origin in ISO code HERKL_ISOCHAR2INTCA
REGIONORIGRegion of origin of material (non-preferential origin) HERKRCHAR3REGIO
COMM_CO_UNUnit of measure for commodity code (foreign trade) EXPMEUNIT3CUNITMEINS
COMM_CO_UN_ISOUnit of measure for commodity code (for. trade) in ISO code EXPME_ISOCHAR3ISOCD_UNIT
EXPIMPGRPExport/import material group MTVERCHAR4MTVER
PROFIT_CTRProfit Center PRCTRCHAR10ALPHAPRCTRPRCPRCTR_EMPTY
PPC_PL_CALPPC planning calendar MRPPPCHAR3MRPPP
REP_MANUFInd.: Repetitive mfg allowed SA_SAUFTCHAR1XFELD
PL_TI_FNCEPlanning time fence FXHORNUMC3FXHOR
CONSUMMODEConsumption mode VRMODCHAR1VRMOD
BWD_CONSConsumption period: backward VINT1NUMC3VRINT
FWD_CONSConsumption period: forward VINT2NUMC3VRINT
VERSION_FLAGVersion Indicator CK_VERK1CHAR1XFELD
ALTERNATIVE_BOMAlternative BOM STLALCHAR2ALPHAALTNR
BOM_USAGEBOM Usage STLANCHAR1STLANCSV
PLANLISTGRPKey for Task List Group PLNNRCHAR8ALPHAPLNNRPLNPLKS
PLANLISTCNTGroup Counter PLNALCHAR2ALPHAALTNRPAL
LOT_SIZELot Size for Product Costing CK_LOSGRQUAN13(3) MENG13
SPECPROCTYSpecial Procurement Type for Costing CK_SOBSLCHAR2SOBSL
PROD_UNITProduction unit FRTMEUNIT3CUNITMEINS
PROD_UNIT_ISOProduction Unit in ISO Code FRTME_ISOCHAR3ISOCD_UNIT
ISS_ST_LOCIssue Storage Location LGPROCHAR4LGORT
MRP_GROUPMRP Group DISGRCHAR4DISGR
COMP_SCRAPComponent scrap in percent KAUSFDEC5(2) DEC3_2
CERT_TYPECertificate Type QZGTYPCHAR4QZGTYPQCT
CYCLE_TIMETakt time TAKZTDEC3DEC3
INSP_SETUP_FLAGInspection Setup Exists for Material/Plant QMATVCHAR1XFELD
COVPROFILERange of coverage profile RWPROCHAR3RWPRO
CC_PH_INVPhysical inventory indicator for cycle counting ABCINCHAR1ABCIN
VARIANCE_KEYVariance Key AWSLSCHAR6AWSLS
SERNO_PROFSerial Number Profile SERAILCHAR4SERAIL
PS_CONF_MATConfigurable material STDPDCHAR18MATN1MATNR
REPMANPROFRepetitive manufacturing profile SFEPRCHAR4SFEPR
NEG_STOCKSNegative stocks allowed in plant XMCNGCHAR1XFELD
QM_RGMTSRequired QM System for Vendor QSSYS_SOLLCHAR4QSSYS
PLNG_CYCLEPlanning cycle LFRHYCHAR3MRPPP
ROUND_PROFRounding Profile RDPRFCHAR4RDPRF
REFMATCONSReference material for consumption VRBMTCHAR18MATN1MATNR
REFPLTCONSReference plant for consumption VRBWKCHAR4WERKS
D_TO_REF_MTo date of the material to be copied for consumption VRBDTDATS8DATUM
MULT_REF_MMultiplier for reference material for consumption VRBFKDEC4(2) DEC2_2
AUTO_RESETReset Forecast Model Automatically AUTRUCHAR1XFELD
PREF_STAT_FLAGPreference indicator in export/import PREFECHAR1PREFE
EX_CERT_IDExemption certificate: Indicator for legal control PRENCCHAR1PRENC
EX_CERT_NO_NEWExemption certificate number for legal control PRENNCHAR8PRENN
EX_CERT_DTExemption certificate: Issue date of exemption certificate PRENDDATS8PREND
DECL_STAT_FLAGIndicator: Vendor declaration exists PRENECHAR1PRENEPNE
MILIT_IDIndicator: Military goods ITARKCHAR1XFELD
INSP_INTInterval until next recurring inspection PRFRQDEC5DEC5
CO_PRODUCTIndicator: Material can be co-product KZKUPMATCHAR1FLAG
PLAN_STRGPPlanning strategy group STRGRCHAR2STRGR
SLOC_EXPRCDefault storage location for external procurement LGFSBCHAR4LGORT
BULK_MATIndicator: Bulk Material SCHGTCHAR1XFELD
CC_FIXEDCC indicator is fixed CCFIXCHAR1XFELD
DETERM_GRPStock determination group BF_GROUPCHAR4BF_GROUP
QM_AUTHGRPMaterial Authorization Group for Activities in QM QMATAUTHCHAR6QMATAUTH
TASK_LIST_TYPETask List Type PLNTYCHAR1PLNTYPTYH_TCA01
PUR_STATUSPlant-Specific Material Status MMSTACHAR2MMSTA
PRODPROFProduction Scheduling Profile CO_PRODPRFCHAR6CO_PRODPRF
SAFTY_T_IDSafety time indicator (with or without safety time) SHFLGCHAR1SHFLG
SAFETYTIMESafety time (in workdays) SHZETNUMC2NUMC2
PLORD_CTRLAction control: planned order processing MDACHCHAR2MDACH
BATCHENTRYDetermination of batch entry in the production/process order KZECHCHAR1KZECH
PVALIDFROMDate from which the plant-specific material status is valid MMSTDDATS8DATUM
MATFRGTGRPMaterial freight group MFRGRCHAR8MFRGR
PRODVERSCSProduction Version To Be Costed CK_VERIDCHAR4VERID
MAT_CFOPMaterial CFOP category J_1BINDUS3CHAR2ALPHAJ_1BINDUS3
EU_LIST_NOCAP: Number of CAP products list MOWNRCHAR12MOWNR
EU_MAT_GRPCommon Agricultural Policy: CAP products group-Foreign Trade MOGRUCHAR6MOGRU
CAS_NOCAS number for pharmaceutical products in foreign trade CASNRCHAR15CASNR
PRODCOM_NOProduction statistics: PRODCOM number for foreign trade GPNUMCHAR9GPNUM
CTRL_CODEControl code for consumption taxes in foreign trade STEUCCHAR16STEUC
JIT_RELVTIndicator: Item Relevant to JIT Delivery Schedules FABKZCHAR1FABKZ
MAT_GRP_TRANSGroup of Materials for Transition Matrix MATNRGROUPCHAR20CHAR20
HANDLG_GRPLogistics handling group for workload calculation LOGGRCHAR4LOGGR
SUPPLY_AREAProposed Supply Area in Material Master Record VSPVBCHAR10PRVBE
FAIR_SHARE_RULEFair share rule DPLFSCHAR2DPLFS
PUSH_DISTRIBIndicator: push distribution DPLPUCHAR1DPLPU
DEPLOY_HORIZDeployment horizon in days DPLHODEC3DEC3
MIN_LOT_SIZEMinimum lot size for Supply Demand Match CSCP_MINLOTSIZEQUAN13(3) MENG13
MAX_LOT_SIZEMaximum lot size for Supply Demand Match CSCP_MAXLOTSIZEQUAN13(3) MENG13
FIX_LOT_SIZEFixed lot size for Supply Demand Match CSCP_FIXLOTSIZEQUAN13(3) MENG13
LOT_INCREMENTLot size increment for Supply Demand Match CSCP_LOTINCREMENTQUAN13(3) MENG13
PROD_CONV_TYPEConversion types for production figures CSCP_CONV_TYPECHAR2CSCP_CONV_TYPE
DISTR_PROFDistribution profile of material in plant FPRFMCHAR3MPPRF
PERIOD_PROFILE_SAFETY_TIMEPeriod Profile for Safety Time SHPROCHAR3SHPRO
FXD_PRICEFixed-Price Co-Product CK_FIXPRKUCHAR1XFELD
AVAIL_CHECK_ALL_PROJ_SEGMENTSIndicator for cross-project material KZPSPCHAR1KZPSP
OVERALLPRFOverall profile for order change management OCM_GPROFILECHAR6CHAR6
MRP_RELEVANCY_DEP_REQUIREMENTSMRP relevancy for dependent requirements AHDISCHAR1AHDIS
MRP_AREA_EXISTSIndicator: MRP area exists DIBERCHAR1XFELD
MIN_SAFETY_STKMinimum Safety Stock EISLOQUAN13(3) MENG13
NO_COSTINGDo Not Cost CK_NO_COSTINGCHAR1CK_NO_COSTING
UNIT_GROUPUnit of Measure Group MEGRUCHAR4MEGRU
FOLLOW_UP_EXTERNALLong Material Number for field FOLLOW_UP MGV_FOLLOW_UP_EXTERNALCHAR40MATNR_EXT
FOLLOW_UP_GUIDExternal GUID for FOLLOW_UP Field MGV_FOLLOW_UP_GUIDCHAR32MATNR_EGUID
FOLLOW_UP_VERSIONVersion Number for FOLLOW_UP Field MGV_FOLLOW_UP_VERSIONCHAR10MATNWMATNR_VERS
REFMATCONS_EXTERNALLong Material Number for REFMATCONS Field MGV_REFMATCONS_EXTERNALCHAR40MATNR_EXT
REFMATCONS_GUIDExternal GUID for REFMATCONS Field MGV_REFMATCONS_GUIDCHAR32MATNR_EGUID
REFMATCONS_VERSIONVersion Number for REFMATCONS Field MGV_REFMATCONS_VERSIONCHAR10MATNWMATNR_VERS
ROTATION_DATEStrategy for Putaway and Stock Removal ROTATION_DATECHAR1ROTATION_DATE
ORIGINAL_BATCH_FLAGIndicator for Original Batch Management UCHKZCHAR1UCHKZ
ORIGINAL_BATCH_REF_MATERIALReference Material for Original Batches VBOB_OB_RFMATCHAR18MATN1MATNRMAT1
PS_CONF_MAT_EXTERNALLong Material Number (Future Development) for PS_CO Field MGV_PS_CONF_MAT_EXTERNALCHAR40MATNLMATNR_EXT
PS_CONF_MAT_GUIDExternal GUID (Future Development) for PS_CONF_MAT Field MGV_PS_CONF_MAT_GUIDCHAR32MATNR_EGUID
PS_CONF_MAT_VERSIONVersion Number (Future Development) for PS_CONF_MAT Field MGV_PS_CONF_MAT_VERSIONCHAR10MATNWMATNR_VERS
ORIGINAL_BATCH_REF_MATERIAL_EReference Material for Original Batches MGV_VBOB_OB_RFMAT_EXTERNALCHAR40MATNLMATNR_EXT
ORIGINAL_BATCH_REF_MATERIAL_VReference Material for Original Batches MGV_VBOB_OB_RFMAT_VERSIONCHAR10MATNWMATNR_VERS
ORIGINAL_BATCH_REF_MATERIAL_GReference Material for Original Batches MGV_VBOB_OB_RFMAT_GUIDCHAR32MATNR_EGUID
IUID_RELEVANTIUID-Relevant IUID_RELEVANTCHAR1UID_RELEVANT
IUID_TYPEStructure Type of UII IUID_TYPECHAR10IUID_TYPEH_IUID_TYPE
UID_IEAExternal Allocation of UII UID_IEACHAR1UID_IEA
STORAGELOCATIONDATA 0
PLANTPlant WERKS_DCHAR4WERKSWRKH_T001W_C
STGE_LOCStorage Location LGORT_DCHAR4LGORTLAG
MAINT_STATMaintenance status PSTAT_DCHAR15PSTAT
DEL_FLAGFlag Material for Deletion at Storage Location Level LVOLGCHAR1XFELD
FISC_YEARFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
CURR_PERIODCurrent period (posting period) LFMONNUMC2MONAT
MRP_INDStorage location MRP indicator DISKZCHAR1DISKZ
SPEC_PROCSpecial procurement type at storage location level LSOBSCHAR2SOBSL
REORDER_PTReorder point for storage location MRP LMINBQUAN13(3) MENG13
REPL_QTYReplenishment quantity for storage location MRP LBSTFQUAN13(3) MENG13
STGE_BINStorage Bin LGPBECHAR10CHAR10
PICKG_AREAPicking area for lean WM MARD_KOBERCHAR3KOBER
INV_CORR_FACInventory correction factor BSKRFFLTP16(16) FLTP
VALUATIONDATA 0
VAL_AREAValuation Area BWKEYCHAR4BWKEYBWK
VAL_TYPEValuation Type BWTAR_DCHAR10BWTARBWT
MAINT_STATMaintenance status PSTAT_DCHAR15PSTAT
DEL_FLAGDeletion flag for all material data of a valuation type LVOBACHAR1XFELD
PRICE_CTRLPrice control indicator VPRSVCHAR1VPRSV
MOVING_PRMoving average price/periodic unit price VERPR_BAPIDEC23(4) BAPICURR
STD_PRICEStandard price STPRS_BAPIDEC23(4) BAPICURR
PRICE_UNITPrice Unit PEINHDEC5PACK3
VAL_CLASSValuation Class BKLASCHAR4BKLAS
PR_CTRL_PPPrice Control Indicator in Previous Period VMVPRCHAR1VPRSV
MOV_PR_PPMoving average price/periodic unit price in previous period VMVER_BAPIDEC23(4) BAPICURR
STD_PR_PPStandard price in the previous period VMSTP_BAPIDEC23(4) BAPICURR
PR_UNIT_PPPrice unit of previous period VMPEIDEC5PACK3
VCLASS_PPValuation Class in Previous Period VMBKLCHAR4BKLAS
PR_CTRL_PYPrice Control Indicator in Previous Year VJVPRCHAR1VPRSV
MOV_PR_PYMoving average price/periodic unit price in previous year VJVER_BAPIDEC23(4) BAPICURR
STD_PR_PYStandard price in previous year VJSTP_BAPIDEC23(4) BAPICURR
VCLASS_PYValuation Class in Previous Year VJBKLCHAR4BKLAS
PR_UNIT_PYPrice unit of previous year VJPEIDEC5PACK3
FISC_YEARFiscal Year of Current Period LFGJANUMC4GJAHRGJAHR
CURR_PERIODCurrent period (posting period) LFMONNUMC2MONAT
VAL_CATValuation Category BWTTY_DCHAR1BWTTY
FUTURE_PRFuture price PRSZK_BAPIDEC23(4) BAPICURR
VALID_FROMDate as of which the price is valid DZKDATDATS8DATUM
TAXPRICE_1Valuation price based on tax law: level 1 BWPRS_BAPIDEC23(4) BAPICURR
COMMPRICE1Valuation price based on commercial law: level 1 BWPRH_BAPIDEC23(4) BAPICURR
TAXPRICE_3Valuation price based on tax law: level 3 VJBWS_BAPIDEC23(4) BAPICURR
COMMPRICE3Valuation price based on commercial law: level 3 VJBWH_BAPIDEC23(4) BAPICURR
PLND_PRICEFuture Planned Price DZPLPR_BAPIDEC23(4) BAPICURR
PLNDPRICE1Future Planned Price 1 DZPLP1_BAPIDEC23(4) BAPICURR
PLNDPRICE2Future Planned Price 2 DZPLP2_BAPIDEC23(4) BAPICURR
PLNDPRICE3Future Planned Price 3 DZPLP3_BAPIDEC23(4) BAPICURR
PLNDPRDATE1Date from Which Future Planned Price 1 Is Valid DZPLD1DATS8DATUM
PLNDPRDATE2Date from Which Future Planned Price 2 Is Valid DZPLD2DATS8DATUM
PLNDPRDATE3Date from Which Future Planned Price 3 Is Valid DZPLD3DATS8DATUM
LIFO_FIFOLIFO/FIFO-Relevant XLIFOCHAR1LIFO_FIFO
POOLNUMBERPool number for LIFO valuation MYPOOLCHAR4LIFO_POOLPOL
TAXPRICE_2Valuation price based on tax law: level 2 BWPS1_BAPIDEC23(4) BAPICURR
COMMPRICE2Valuation price based on commercial law: level 2 BWPH1_BAPIDEC23(4) BAPICURR
DEVAL_INDLowest value: devaluation indicator ABWKZNUMC2NUMC2
ORIG_GROUPOrigin Group as Subdivision of Cost Element HRKFTCHAR4HRKFT
OVERHEAD_GRPCosting Overhead Group CK_KOSGRCHAR10CK_KOSGR
PER_FUT_COST_ESTPeriod of Future Standard Cost Estimate CK_PPRDZNUMC3POPERBUP
PER_CUR_COST_ESTPeriod of Current Standard Cost Estimate CK_PPRDLNUMC3POPER
PER_PRE_COST_ESTPeriod of Previous Standard Cost Estimate CK_PPRDVNUMC3POPER
FIJ_FUT_COST_ESTFiscal Year of Future Standard Cost Estimate CK_PDATZNUMC4GJAHRGJAHRGEJ
FIJ_CUR_COST_ESTFiscal Year of Current Standard Cost Estimate CK_PDATLNUMC4GJAHRGJAHR
FIJ_PRE_COST_ESTFiscal Year of Previous Standard Cost Estimate CK_PDATVNUMC4GJAHRGJAHR
QTY_STRUCTMaterial Is Costed with Quantity Structure CK_EKALRELCHAR1XFELD
PREV_PLAN_PRICEValuation Price Based on Tax Law: Level 2 VPLPR_BAPIDEC23(4) BAPICURR
ML_ACTIVEMaterial ledger activated at material level CK_ML_MAACCHAR1XFELD
ML_SETTLEMaterial Price Determination: Control CK_ML_ABSTCHAR1CK_ML_ABST
CURR_PLAN_PRICEValuation Price Based on Tax Law: Level 2 LPLPR_BAPIDEC23(4) BAPICURR
ORIG_MATMaterial-related origin HKMATCHAR1HKMAT
VM_SO_STKValuation Class for Sales Order Stock EKLASCHAR4BKLAS
VM_P_STOCKValuation Class for Project Stock QKLASCHAR4BKLAS
MATL_USAGEUsage of the material J_1BMATUSECHAR1J_1BMATUSE
MAT_ORIGINOrigin of the material J_1BMATORGCHAR1J_1BMATORG
IN_HOUSEProduced in-house J_1BOWNPROCHAR1XFELD
TAX_CML_UNPrice unit for valuation prices based on tax/commercial law BWPEIDEC5PACK3
CURRENCYCurrency Key WAERSCUKY5WAERSFWS
CURRENCY_ISOISO code currency WAERS_ISOCHAR3ISOCD
SALESDATA 0
SALES_ORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
DISTR_CHANDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
DEL_FLAGInd.: Flag material for deletion at distribution chain level LVOVKCHAR1XFELD
MATL_STATSMaterial statistics group STGMACHAR1STGMA
REBATE_GRPVolume rebate group BONUSCHAR2BONUS
COMM_GROUPCommission group PROVGCHAR2PROVG
CASH_DISCCash discount indicator SKTOFCHAR1XFELD
SAL_STATUSDistribution-chain-specific material status VMSTACHAR2VMSTA
VALID_FROMDate from which distr.-chain-spec. material status is valid VMSTDDATS8DATUM
MIN_ORDERMinimum order quantity in base unit of measure MINAUQUAN13(3) MENG13
MIN_DELYMinimum delivery quantity in delivery note processing MINLFQUAN13(3) MENG13
MIN_MTOMinimum make-to-order quantity MINEFQUAN13(3) MENG13
DELY_UNITDelivery unit SCHRTQUAN13(3) MENG13
DELY_UOMUnit of measure of delivery unit SCHMEUNIT3CUNITMEINS
DELY_UOM_ISOUnit of measure for delivery unit in ISO code SCHME_ISOCHAR3ISOCD_UNIT
SALES_UNITSales unit VRKMEUNIT3CUNITMEINS
SALES_UNIT_ISOSales unit in ISO code VRKME_ISOCHAR3ISOCD_UNIT
ITEM_CATItem category group from material master MTPOSCHAR4MTPOS
DELYG_PLNTDelivering Plant DWERKCHAR4WERKS
PROD_HIERProduct hierarchy PRODH_DCHAR18PRODHVPR
PR_REF_MATPricing Reference Material PMATNCHAR18MATN1MATNRMAT
MAT_PR_GRPMaterial Pricing Group KONDMCHAR2KONDMVKM
ACCT_ASSGTAccount assignment group for this material KTGRMCHAR2KTGRM
MATL_GRP_1Material group 1 MVGR1CHAR3MVGR1
MATL_GRP_2Material group 2 MVGR2CHAR3MVGR2
MATL_GRP_3Material group 3 MVGR3CHAR3MVGR3
MATL_GRP_4Material group 4 MVGR4CHAR3MVGR4
MATL_GRP_5Material group 5 MVGR5CHAR3MVGR5
PROD_ATT_1ID for product attribute 1 PRAT1CHAR1PRATA
PROD_ATT_2ID for product attribute 2 PRAT2CHAR1PRATA
PROD_ATT_3ID for product attribute 3 PRAT3CHAR1PRATA
PROD_ATT_4ID for product attribute 4 PRAT4CHAR1PRATA
PROD_ATT_5ID for product attribute 5 PRAT5CHAR1PRATA
PROD_ATT_6ID for product attribute 6 PRAT6CHAR1PRATA
PROD_ATT_7ID for product attribute 7 PRAT7CHAR1PRATA
PROD_ATT_8ID for product attribute 8 PRAT8CHAR1PRATA
PROD_ATT_9ID for product attribute 9 PRAT9CHAR1PRATA
PROD_ATT10ID for product attribute 10 PRATACHAR1PRATA
ROUND_PROFRounding Profile RDPRFCHAR4RDPRF
VAR_SALES_UNVariable Sales Unit Not Allowed VAVMECHAR1XFELD
UNIT_GROUPUnit of Measure Group MEGRUCHAR4MEGRU
PR_REF_MAT_EXTERNALLong Material Number for PR_REF_MAT Field MGV_PR_REF_MAT_EXTERNALCHAR40MATNR_EXT
PR_REF_MAT_GUIDExternal GUID for PR_REF_MAT Field MGV_PR_REF_MAT_GUIDCHAR32MATNR_EGUID
PR_REF_MAT_VERSIONVersion Number for PR_REF_MAT Field MGV_PR_REF_MAT_VERSIONCHAR10MATNWMATNR_VERS
MATERIALDESCRIPTION 0
UNITSOFMEASURE 0

Key field Non-key field



How do I retrieve data from SAP structure RCPS_IDL_MATERIAL_DATA using ABAP code?

As RCPS_IDL_MATERIAL_DATA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on RCPS_IDL_MATERIAL_DATA as there is no data to select.

How to access SAP table RCPS_IDL_MATERIAL_DATA

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

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