SAP Table JKSDMATERIALSTATUS

IS-M: Material Status (MARA/MVKE/MARC)

JKSDMATERIALSTATUS (IS-M: Material Status (MARA/MVKE/MARC)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link JKSDMATERIALSTATUS to other SAP tables.

JKSDMATERIALSTATUS table fields

Field Data element Checktable Datatype Length Decimals
ISMREFMDPROD Higher-Level Media Product ISMREFMDPROD CHAR 18 0
SEQUENCE_LFDNR Sequence number of media issue within issue sequence MPG_LFDNR NUMC 6 0
MATNR Material Number MATNR CHAR 18 0
PH_PHASEMDL Phase Model JVPHASEMDL CHAR 10 0
PH_PHASENBR Sequence Number in Phase Delivery JVPHASENBR NUMC 10 0
PH_DELIV_DATE IS-M: Shipping Date VRSNDDATUM DATS 8 0
ISMPUBLDATE Publication Date ISMPUBLDATE DATS 8 0
ISMINITSHIPDATE Initial Shipping Date ISMERSTVERDAT DATS 8 0
ISMCOPYNR Copy Number of Media Issue ISMHEFTNUMMER CHAR 9 0
MEDPROD_MAKTX Material Description (Short Text) MAKTX CHAR 40 0
MEDISSUE_MAKTX Material Description (Short Text) MAKTX CHAR 40 0
XFIRST_ISSUE_LINE Checkbox XFELD CHAR 1 0
X Yes
NULL No
XISSUE_IS_DUPLICATE Checkbox XFELD CHAR 1 0
X Yes
NULL No
MSTAV Cross-distribution-chain material status MSTAV CHAR 2 0
MSTDV Date from which the X-distr.-chain material status is valid MSTDV DATS 8 0
MSTAE Cross-Plant Material Status MSTAE CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
MARC_WERKS Plant WERKS_D CHAR 4 0
MARC_ISMPURCHASEDATE IS-M: Latest Possible Purchase Order Date ISMPURCHASE_DATE_PL DATS 8 0
MARC_ISMARRIVALDATEPL Planned Goods Arrival Date ISMANLFTAGS DATS 8 0
MARC_ISMARRIVALDATEAC Actual Goods Arrival Date ISMANLFTAGI DATS 8 0
MARC_MMSTA Plant-Specific Material Status MMSTA CHAR 2 0
MARC_MMSTD Date from which the plant-specific material status is valid MMSTD DATS 8 0
MARC_STOCK01 Stock 01 JKSDSTOCK01 QUAN 13 3
MARC_STOCK02 Stock 02 JKSDSTOCK02 QUAN 13 3
MARC_STOCK03 Stock 03 JKSDSTOCK03 QUAN 13 3
MARC_STOCK04 Stock 04 JKSDSTOCK04 QUAN 13 3
MARC_STOCK05 Stock 05 JKSDSTOCK05 QUAN 13 3
MARC_STOCK06 Stock 06 JKSDSTOCK06 QUAN 13 3
MARC_STOCK07 Stock 07 JKSDSTOCK07 QUAN 13 3
MARC_STOCK08 Stock 08 JKSDSTOCK08 QUAN 13 3
MARC_STOCK09 Stock 09 JKSDSTOCK09 QUAN 13 3
MARC_STOCK10 Stock 10 JKSDSTOCK10 QUAN 13 3
MARC_SFMEINS Base Unit of Measure MEINS UNIT 3 0
MVKE_VKORG Sales Organization VKORG CHAR 4 0
MVKE_VTWEG Distribution Channel VTWEG CHAR 2 0
MVKE_ISMINITSHIPDATE Initial Shipping Date ISMERSTVERDAT DATS 8 0
MVKE_ISMONSALEDATE IS-M: On-Sale Date ISMONSALEDATE DATS 8 0
MVKE_ISMOFFSALEDATE IS-M: End of Sales Period ISMOFFSALEDATE DATS 8 0
MVKE_ISMINTERRUPT Indicator: Delivery Delayed After Suspension ISMNOTINTERRUPTABLE CHAR 1 0
X Yes
NULL No
MVKE_ISMINTERRUPTDATE IS-M: Latest Delivery Date ISMINTERRUPTDATE DATS 8 0
MVKE_ISMCOLLDATE Recall Date ISMCOLLDATE DATS 8 0
MVKE_ISMRETURNBEGIN IS-M: Start of Return Period ISMRETURNBEGIN DATS 8 0
MVKE_ISMRETURNEND IS-M: End of Return Period ISMRETURNEND DATS 8 0
MVKE_VMSTA Distribution-chain-specific material status VMSTA CHAR 2 0
MVKE_VMSTD Date from which distr.-chain-spec. material status is valid VMSTD DATS 8 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
TEXT_ICON Media Issue Texts in Worklist TEXT_ICON_WORKLIST CHAR 132 0
XARCHIVE Media Issue Is Archived or to Be Archived XISSUESEQ_ARCHIVE CHAR 1 0
X Yes
NULL No