NMATP SAP (IS-H: Material planned for case) Table details

Dictionary Type: Table
Description: IS-H: Material planned for case




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




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

NMATP is a standard SAP Table which is used to store IS-H: Material planned for case data and is available within R/3 SAP systems depending on the version and release level.

The NMATP table consists of various fields, each holding specific information or linking keys about IS-H: Material planned for case data available in SAP. These include LNRLM (IS-H MM: Sequence Number of a Material Requisition), FALNR (IS-H: Case Number), EINRI (Institution), LNRLS (IS-H: Service Sequence Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP NMATP 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
LNRLMIS-H MM: Sequence Number of a Material Requisition ISH_LNRLMCHAR10ALPHAISH_LNRLM
FALNRIS-H: Case Number FALNRCHAR10NFALALPHAFALNRFAL
EINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
LNRLSIS-H: Service Sequence Number LNRLSCHAR10ALPHALNRLS
MATNRIS-H: Material Number for Material Requisition ISH_MMATNRCHAR18MARAMATN1MATNR
MBLNRNumber of a Material Document ISH_MBLNRCHAR10ALPHABELNR
MBPOSIS-H MM: Item Number on the Material Document ISH_MBPOSNUMC5Assigned to domainBNFPO
MJAHRIS-H MM: Material Document Year ISH_MJAHRNUMC4GJAHRGJAHR
WERKSIS-H MM: Issuing Point for Material (e.g. Pharmacy) ISH_MWERKSCHAR4TNM01WERKSWRK
EXMATIS-H: External Material Number ISH_EXMATCHAR20ALPHAISH_EXMAT
ANFOEDepartmental Organizational Unit That Requests the Service ANFOECHAR8NORGALPHAORGID
ANPOEIS-H: Nursing Organizational Unit Requesting the Service ANPOECHAR8NORGALPHAORGID
ERBOEIS-H: Organizational Unit that Performs the Service ERBOECHAR8Assigned to domainALPHAORGID
PREISIS-H MM: Price of Material ISH_MPREISCURR11(2) ISH_WERTV6
WAERSIS-H: Currency Key ISH_WAERSCUKY5Assigned to domainWAERS
ABRKZIS-H: Indicator Whether Material Can Be Billed For ISH_MABRKZCHAR1ISH_MABRKZ
MENGEIS-H MM: Quantity of Material ISH_MENGEQUAN15(3) MENGV8
MEINSUnit of Measure ISH_MEINSUNIT3Assigned to domainCUNITMEINS
LFSTAIS-H: Delivery Status of Material Requisition Item ISH_MLFSTACHAR1ISH_MLFSTA
GESTAIS-H MM: Approval Status for Material Requisition ISH_MGESTACHAR1ISH_MGESTA
GENAMIS-H MM: Name of Approval Giver ISH_MGENAMCHAR12USNAM
GEDATIS-H MM: Date of Approval ISH_MGEDATDATS8RI_DATUM
TCODEIS-H: Report Control: Transaction Code for Application ISH_TCODECHAR20Assigned to domainTCODE
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
STUSRIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
MBARTIS-H MM: Type of Material Document ISH_MBARTCHAR1ISH_MBART
MMBSKStatus for Transfer into MM ISH_MMBSKCHAR1ISH_MMBSK
RLDATIS-H MM: Date of Requisition in MM ISH_MRELDTDATS8DATUM
RLTIMIS-H MM: Time of Requisition in MM ISH_MRELTMTIMS6UZEIT
LFDATIS-H: Desired Delivery Date for Item ISH_MLFDATDATS8DATUM
POSTXIS-H MM: Material Requisition Item Text ISH_MPOSTXCHAR40TEXT40
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
SIGIDIS-H: Digital Signature ID ISH_SIGIDCHAR32NSIGHSYSUUID_C
FTXTKZIS-H MM: Free-Text Requisition Indicator ISH_MFTXTKZCHAR1XFELD
TXZ01Short Text TXZ01CHAR40TEXT40
PRIO_URGIS-H-MM: Requirement Urgency ISH_PRIO_URGNUMC2Assigned to domainPRIO_URG
PRIO_REQIS-H-MM: Requirement Priority ISH_PRIO_REQNUMC3Assigned to domainPRIO_REQ
GERNRSerial Number ISH_GERNRCHAR18GERNRGERNR

Key field Non-key field



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

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

SELECT SINGLE *
FROM NMATP
INTO CORRESPONDING FIELDS OF WA_NMATP
WHERE...

How to access SAP table NMATP

Within an ECC or HANA version of SAP you can also view further information about NMATP 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!