/ISDFPS/MATSPPLN SAP (Materials Planned for Force Element) Table details

Dictionary Type: Table
Description: Materials Planned for Force Element




ABAP Code to SELECT data from /ISDFPS/MATSPPLN
Related tables to /ISDFPS/MATSPPLN
Access table /ISDFPS/MATSPPLN




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

/ISDFPS/MATSPPLN is a standard SAP Table which is used to store Materials Planned for Force Element data and is available within R/3 SAP systems depending on the version and release level.

The /ISDFPS/MATSPPLN table consists of various fields, each holding specific information or linking keys about Materials Planned for Force Element data available in SAP. These include PLANNING_GUID (Planning GUID), RECTYPE (Record Type Planning), FORCE_REC_ID (Internal Key for Force Element), FORCE_REC_CNT (Internal (Version) Counter).. 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 /ISDFPS/MATSPPLN 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
CLIENTClient MANDTCLNT3T000MANDT
PLANNING_GUIDPlanning GUID /ISDFPS/PLANNING_GUIDCHAR32SYSUUID_C
RECTYPERecord Type Planning /ISDFPS/FDPMAT_RECTYPECHAR3/ISDFPS/FDPMAT_RECTYPE
FORCE_REC_IDInternal Key for Force Element /ISDFPS/FORCE_IDCHAR32SYSUUID_C
FORCE_REC_CNTInternal (Version) Counter /ISDFPS/FORCE_CNTNUMC6NUMC6
PLANT_RECPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
STORAGE_LOC_RECStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
HU_LOC_RECHU Storage Location /ISDFPS/HU_LOCCHAR4Assigned to domainLGORT
FORCE_PROV_IDInternal Key for Force Element /ISDFPS/FORCE_IDCHAR32SYSUUID_C
FORCE_PROV_CNTInternal (Version) Counter /ISDFPS/FORCE_CNTNUMC6NUMC6
PLANT_PROVPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
STORAGE_LOC_PROVStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
HU_LOC_PROVHU Storage Location /ISDFPS/HU_LOCCHAR4Assigned to domainLGORT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
SERNRSerial Number GERNRCHAR18GERNRGERNRSER
BATCHBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
PSPNRWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
HU_EXIDExternal Handling Unit Identification EXIDVCHAR20ALPHAEXIDVHU_IDENT_ALLG
VEPOSHandling Unit Item VEPOSNUMC6Assigned to domainVEPOS
PACK_MATPackaging Materials VHILMCHAR18Assigned to domainMATN1MATNR
QUPLNPlanned Quantity /ISDFPS/QUPLNQUAN13(3) MENG13V
DELIVERY_DATEDelivery Date /ISDFPS/DEL_DATEDATS8
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
COMNTPlanning Comment /ISDFPS/COMNTCHAR40TEXT40
REF_GUIDPlanning GUID /ISDFPS/PLANNING_GUIDCHAR32SYSUUID_C
REF_TYPEType of Reference Relationship /ISDFPS/MATPLN_REFTYPECHAR2/ISDFPS/MATPLN_REF
REF_GUID2Planning GUID /ISDFPS/PLANNING_GUIDCHAR32SYSUUID_C
REF_TYPE2Type of Reference Relationship /ISDFPS/MATPLN_REFTYPECHAR2/ISDFPS/MATPLN_REF
PREQ_NOPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
PREQ_ITEMItem Number of Purchase Requisition BNFPONUMC5Assigned to domainBNFPOBAP
FLAG_LOANLoan /ISDFPS/FLAG_LOANCHAR1XFLAG
RETURN_DATEReturn Date for Loan /ISDFPS/RETURN_DATEDATS8DATS
FLAG_LOAN_RETLoan Return /ISDFPS/FLAG_LOAN_RETURNCHAR1XFLAG
RECORD_INVISIBLESingle-Character Indicator CHAR1CHAR1CHAR1
RELOC_IDRelocation ID /ISDFPS/RELOC_IDCHAR10Assigned to domain/ISDFPS/RELOC_ID
RELOC_SEQ_IDRelocation Step ID /ISDFPS/RELOC_SEQ_IDCHAR4Assigned to domain/ISDFPS/RELOC_SEQ_ID
PNGUIDInternal Identification for PVS Objects PVS_GUIDRAW16SYSUUID
FORCEM_CNTInternal (Version) Counter /ISDFPS/FORCEM_CNTNUMC6NUMC6
DGUIDDistribution Assignment ID /ISDFPS/DGUIDCHAR32SYSUUID_C
FLAG_EVRelocation: Initial Supply /ISDFPS/REL_FLAG_EVCHAR1XFELD
FORCE_ASGN_IDInternal Key for Force Element /ISDFPS/FORCE_IDCHAR32SYSUUID_C
FORCE_ASGN_CNTInternal (Version) Counter /ISDFPS/FORCE_CNTNUMC6NUMC6
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MBDATMaterial Staging/Availability Date MBDATDATS8DATUM
DAT_SPCollectn Pt Date /ISDFPS/DAT_SPDATS8DATUM
BSARTOrder Type (Purchasing) BSARTCHAR4Assigned to domainBSARTBSA
LFARTDelivery Type LFARTCHAR4Assigned to domainLFARTALT
ROUTERoute ROUTECHAR6Assigned to domainROUTE
APPLOBJ_TYPEApplication Object Type for iPPE PVS_APPLOBJ_TYPECHAR4PVS_APPLOBJ_TYPE
FBSTARelocation: Follow-On Document Status /ISDFPS/FBSTACHAR1/ISDFPS/FBSTA
PNAMEiPPE Node Description PVS_PNODECHAR40PVS_PNODEPND
FLAG_PROVProvisions /ISDFPS/FLAG_PROVCHAR1
LOCATION_S_GUIDISDFPS: Location ID (GUID) /ISDFPS/LOCATION_IDCHAR32SYSUUID_C
LOCATION_D_GUIDISDFPS: Location ID (GUID) /ISDFPS/LOCATION_IDCHAR32SYSUUID_C
CREATED_ONDate record created on ANDATDATS8DATUM
CREATED_BYUser who created record ANNAMCHAR12USNAM
CHANGED_ONChanged On AEDATDATS8DATUM
CHANGED_BYName of Person Who Changed Object AENAMCHAR12USNAM
FLAG_HISTORYRecord Is Historical /ISDFPS/FLAG_HISTORYCHAR1XFELD
FLAG_MAINTENANCEChange of Ownership /ISDFPS/FLAG_MAINTENANCECHAR1XFLAG
VBELNDelivery VBELN_VLCHAR10Assigned to domainALPHAVBELNVL
FLAG_COMPLETEDCompletely Processed /ISDFPS/FLAG_PREQ_COMPLETEDCHAR1XFLAG
FLAG_FORWARDEDPurchase Requisition Forwarded /ISDFPS/FLAG_PREQ_FORWARDEDCHAR1XFLAG
FLAG_DERIVEDPReq Is Derived (Forwarding) /ISDFPS/FLAG_PREQ_DERIVEDCHAR1XFLAG
VSBEDShipping Conditions VSBEDCHAR2Assigned to domainVSBED
FLAG_WBPlanned Record Created in Workbench /ISDFPS/FLAG_WORKBENCHCHAR1XFLAG
FLAG_SUBITEMSubitem /ISDFPS/FLAG_SUBITEMCHAR1XFLAG
FLAG_RETURNReturn Delivery /ISDFPS/FLAG_RETURNCHAR1XFLAG
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
FLAG_RES_FWDForwarded Reservation /ISDFPS/FLAG_RES_FWDCHAR1XFLAG
SERNR_PREQSerial Number /ISDFPS/SERNR_PREQCHAR18GERNRGERNRSER
FLAG_SERNR_PREQSerial Number PReq /ISDFPS/FLAG_SERNR_PREQCHAR1XFLAG
RELSEQ_TYPERelocation Step Type /ISDFPS/RELSEQ_TYPECHAR1Assigned to domain/ISDFPS/RELSEQ_TYPE

Key field Non-key field



How do I retrieve data from SAP table /ISDFPS/MATSPPLN using ABAP code

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

SELECT SINGLE *
FROM /ISDFPS/MATSPPLN
INTO CORRESPONDING FIELDS OF WA_/ISDFPS/MATSPPLN
WHERE...

How to access SAP table /ISDFPS/MATSPPLN

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