/ISDFPS/MATSPPLN SAP (Materials Planned for Force Element) Table details
Dictionary Type: Table
Description: Materials Planned for Force Element
Description: Materials Planned for Force Element
ABAP Code to SELECT data from /ISDFPS/MATSPPLN
Related tables to /ISDFPS/MATSPPLN
Access table /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 |
CLIENT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PLANNING_GUID | Planning GUID | /ISDFPS/PLANNING_GUID | CHAR | 32 | SYSUUID_C | ||||
RECTYPE | Record Type Planning | /ISDFPS/FDPMAT_RECTYPE | CHAR | 3 | /ISDFPS/FDPMAT_RECTYPE | ||||
FORCE_REC_ID | Internal Key for Force Element | /ISDFPS/FORCE_ID | CHAR | 32 | SYSUUID_C | ||||
FORCE_REC_CNT | Internal (Version) Counter | /ISDFPS/FORCE_CNT | NUMC | 6 | NUMC6 | ||||
PLANT_REC | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
STORAGE_LOC_REC | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
HU_LOC_REC | HU Storage Location | /ISDFPS/HU_LOC | CHAR | 4 | Assigned to domain | LGORT | |||
FORCE_PROV_ID | Internal Key for Force Element | /ISDFPS/FORCE_ID | CHAR | 32 | SYSUUID_C | ||||
FORCE_PROV_CNT | Internal (Version) Counter | /ISDFPS/FORCE_CNT | NUMC | 6 | NUMC6 | ||||
PLANT_PROV | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
STORAGE_LOC_PROV | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
HU_LOC_PROV | HU Storage Location | /ISDFPS/HU_LOC | CHAR | 4 | Assigned to domain | LGORT | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
SERNR | Serial Number | GERNR | CHAR | 18 | GERNR | GERNR | SER | ||
BATCH | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
HU_EXID | External Handling Unit Identification | EXIDV | CHAR | 20 | ALPHA | EXIDV | HU_IDENT_ALLG | ||
VEPOS | Handling Unit Item | VEPOS | NUMC | 6 | Assigned to domain | VEPOS | |||
PACK_MAT | Packaging Materials | VHILM | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
QUPLN | Planned Quantity | /ISDFPS/QUPLN | QUAN | 13(3) | MENG13V | ||||
DELIVERY_DATE | Delivery Date | /ISDFPS/DEL_DATE | DATS | 8 | |||||
RSNUM | Number of Reservation/Dependent Requirement | RSNUM | NUMC | 10 | Assigned to domain | RSNUM | RES | ||
COMNT | Planning Comment | /ISDFPS/COMNT | CHAR | 40 | TEXT40 | ||||
REF_GUID | Planning GUID | /ISDFPS/PLANNING_GUID | CHAR | 32 | SYSUUID_C | ||||
REF_TYPE | Type of Reference Relationship | /ISDFPS/MATPLN_REFTYPE | CHAR | 2 | /ISDFPS/MATPLN_REF | ||||
REF_GUID2 | Planning GUID | /ISDFPS/PLANNING_GUID | CHAR | 32 | SYSUUID_C | ||||
REF_TYPE2 | Type of Reference Relationship | /ISDFPS/MATPLN_REFTYPE | CHAR | 2 | /ISDFPS/MATPLN_REF | ||||
PREQ_NO | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
PREQ_ITEM | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | Assigned to domain | BNFPO | BAP | ||
FLAG_LOAN | Loan | /ISDFPS/FLAG_LOAN | CHAR | 1 | XFLAG | ||||
RETURN_DATE | Return Date for Loan | /ISDFPS/RETURN_DATE | DATS | 8 | DATS | ||||
FLAG_LOAN_RET | Loan Return | /ISDFPS/FLAG_LOAN_RETURN | CHAR | 1 | XFLAG | ||||
RECORD_INVISIBLE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
RELOC_ID | Relocation ID | /ISDFPS/RELOC_ID | CHAR | 10 | Assigned to domain | /ISDFPS/RELOC_ID | |||
RELOC_SEQ_ID | Relocation Step ID | /ISDFPS/RELOC_SEQ_ID | CHAR | 4 | Assigned to domain | /ISDFPS/RELOC_SEQ_ID | |||
PNGUID | Internal Identification for PVS Objects | PVS_GUID | RAW | 16 | SYSUUID | ||||
FORCEM_CNT | Internal (Version) Counter | /ISDFPS/FORCEM_CNT | NUMC | 6 | NUMC6 | ||||
DGUID | Distribution Assignment ID | /ISDFPS/DGUID | CHAR | 32 | SYSUUID_C | ||||
FLAG_EV | Relocation: Initial Supply | /ISDFPS/REL_FLAG_EV | CHAR | 1 | XFELD | ||||
FORCE_ASGN_ID | Internal Key for Force Element | /ISDFPS/FORCE_ID | CHAR | 32 | SYSUUID_C | ||||
FORCE_ASGN_CNT | Internal (Version) Counter | /ISDFPS/FORCE_CNT | NUMC | 6 | NUMC6 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
DAT_SP | Collectn Pt Date | /ISDFPS/DAT_SP | DATS | 8 | DATUM | ||||
BSART | Order Type (Purchasing) | BSART | CHAR | 4 | Assigned to domain | BSART | BSA | ||
LFART | Delivery Type | LFART | CHAR | 4 | Assigned to domain | LFART | ALT | ||
ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
APPLOBJ_TYPE | Application Object Type for iPPE | PVS_APPLOBJ_TYPE | CHAR | 4 | PVS_APPLOBJ_TYPE | ||||
FBSTA | Relocation: Follow-On Document Status | /ISDFPS/FBSTA | CHAR | 1 | /ISDFPS/FBSTA | ||||
PNAME | iPPE Node Description | PVS_PNODE | CHAR | 40 | PVS_PNODE | PND | |||
FLAG_PROV | Provisions | /ISDFPS/FLAG_PROV | CHAR | 1 | |||||
LOCATION_S_GUID | ISDFPS: Location ID (GUID) | /ISDFPS/LOCATION_ID | CHAR | 32 | SYSUUID_C | ||||
LOCATION_D_GUID | ISDFPS: Location ID (GUID) | /ISDFPS/LOCATION_ID | CHAR | 32 | SYSUUID_C | ||||
CREATED_ON | Date record created on | ANDAT | DATS | 8 | DATUM | ||||
CREATED_BY | User who created record | ANNAM | CHAR | 12 | USNAM | ||||
CHANGED_ON | Changed On | AEDAT | DATS | 8 | DATUM | ||||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FLAG_HISTORY | Record Is Historical | /ISDFPS/FLAG_HISTORY | CHAR | 1 | XFELD | ||||
FLAG_MAINTENANCE | Change of Ownership | /ISDFPS/FLAG_MAINTENANCE | CHAR | 1 | XFLAG | ||||
VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
FLAG_COMPLETED | Completely Processed | /ISDFPS/FLAG_PREQ_COMPLETED | CHAR | 1 | XFLAG | ||||
FLAG_FORWARDED | Purchase Requisition Forwarded | /ISDFPS/FLAG_PREQ_FORWARDED | CHAR | 1 | XFLAG | ||||
FLAG_DERIVED | PReq Is Derived (Forwarding) | /ISDFPS/FLAG_PREQ_DERIVED | CHAR | 1 | XFLAG | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | Assigned to domain | VSBED | |||
FLAG_WB | Planned Record Created in Workbench | /ISDFPS/FLAG_WORKBENCH | CHAR | 1 | XFLAG | ||||
FLAG_SUBITEM | Subitem | /ISDFPS/FLAG_SUBITEM | CHAR | 1 | XFLAG | ||||
FLAG_RETURN | Return Delivery | /ISDFPS/FLAG_RETURN | CHAR | 1 | XFLAG | ||||
RSPOS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
FLAG_RES_FWD | Forwarded Reservation | /ISDFPS/FLAG_RES_FWD | CHAR | 1 | XFLAG | ||||
SERNR_PREQ | Serial Number | /ISDFPS/SERNR_PREQ | CHAR | 18 | GERNR | GERNR | SER | ||
FLAG_SERNR_PREQ | Serial Number PReq | /ISDFPS/FLAG_SERNR_PREQ | CHAR | 1 | XFLAG | ||||
RELSEQ_TYPE | Relocation Step Type | /ISDFPS/RELSEQ_TYPE | CHAR | 1 | Assigned 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 tableDATA: 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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects