MSC_ITEM_S SAP (Logical Item Structure for IS-M Complaint) Structure details

Dictionary Type: Structure
Description: Logical Item Structure for IS-M Complaint




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




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

MSC_ITEM_S 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 "Logical Item Structure for IS-M Complaint" 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_MSC_ITEM_S TYPE MSC_ITEM_S.

The MSC_ITEM_S table consists of various fields, each holding specific information or linking keys about Logical Item Structure for IS-M Complaint data available in SAP. These include MANDT (Client), VBELN (IS-M/SD: Publishing Sales Order), POSNR (Sales Order Item), KONDA (Price group (customer)).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MSC_ITEM_S structure 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
JKKD 0
MANDTClient MANDTCLNT3MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10ALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6APNR
KONDAPrice group (customer) KONDACHAR2KONDAVKA
KDGRPCustomer group KDGRPCHAR2KDGRPVKD
PLTYPPrice list type PLTYPCHAR2PLTYPVPL
INCO1Incoterms (Part 1) INCO1CHAR3INCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
PERFKInvoice dates (calendar identification) PERFKCHAR2WFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2WFCID
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
KTGRDAccount assignment group for this customer KTGRDCHAR2KTGRD
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
STCURExchange rate for statistics STCURDEC9(5) EXCRTKURRF
FKPERBilling Frequency FKPERCHAR2FKPERJFKPER
ZAHLWBilling method JZAHLWCHAR1JZAHLWJKZAHLW
PRBASPrice Basis PRBAS_ISPCHAR1PRBAS_ISP
PRBAS_VKPrice Basis for Shipping Costs PRBAS_VKCHAR1PRBAS_ISPJKPRBAS_VK
XFKKOMPIndicator: Perform Billing in Full for Billing Period XFKKOMPCHAR1XFELD
XFKENDEIndicator: Billing at end of calculation XFKENDECHAR1XFELD
FBUDADate on which services rendered FBUDADATS8DATUM
POPERPosting period POPERNUMC3POPERPOPR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
JUEBARTIS-M: Transfer Type JUEBARTCHAR1JUEBART
XRECHDRUCKIS-M: Print Invoice XRECHDRUCKCHAR1XFELD
XFKRUECKIS-M: Retroactive Billing of Period Already Billed XFKRUECKCHAR1XFELD
XSEPFKPOSSeparate billing document for order item XSEPFKPOSCHAR1XFELD
XKINKASSOIS-M: Payment by field collector XKINKASSOCHAR1XFELD
FKDATVSYST'Billed to' Date in Legacy System FKDATVSYSTDATS8DATUM
XFAKT_ARCArchived billing documents exist for order item XFAKT_ARCCHAR1XFELD
RCODEIS-M/SD: Rate Code RATE_CODECHAR4RATE_CODEJKM
XAUTO_RENIS-M/SD: Customer Requests Automatic Renewal XAUTO_RENCHAR1XFELD
STCEG_LTax Destination Country LAND1TXCHAR3LAND1LND
STBFREIType of Tax Exemption JSTBFREICHAR2JSTBFREI
XNORENEWALIS-M/SD: No Further Renewal Required XNORENEWALCHAR1XFELD
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
XPAYMODE_FIXIS-M/SD: Payment Arrangement in Order Fixed XPAYMODE_FIXCHAR1XFELD
DUEDAYIS-M/SD: Renewals, Due Day DUEDAYNUMC2DUEDAY
PRSANZPIS-M: Number of Periods to Which Offer Refers PRSANZP_OFFERDEC8ISPWERT8
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
JKAP 0
MANDTClient MANDTCLNT3MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10ALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6APNR
GUELTIGVONValid-From Date of Sales Order Item JKAPVONDATS8DATUMJC1
GUELTIGBISDate to which Sales Order Item is Valid JKAPBISDATS8DATUMJC2
POARTInternal Item Type for Sales Order POART_ISPCHAR2POART_ISPJAP
AEARTOrder Change Type AEART_JSDKCHAR1AEART_JSDK
ZSKLSTime slice classification for sales order JZSKLSCHAR1JZSKLS
POSEXExternal Item Number (Purchase Order Item) POSEX_ISPNUMC6POSEX_ISPJK2
KUNWEIS-M: Business Partner Ship-to Party GPNR_WECHAR10ALPHAGPNRJGP
KUNWEFREMDCust.No. with External Company (External Deliveries/Retail) JKUNNRVERLCHAR15JKUNNRVERL
LANDECurrent country being supplied LANDE_ISPCHAR3LAND1LND
LAND1Normal delivery country LAND1_ISPCHAR3LAND1LND
DRERZPublication DRERZCHAR8ALPHADRERZJD1MJD1
PVAEdition PVACHAR8ALPHAPVAJD2
BEZUGSTYPMix Type BEZUGSTYP_JE_PVACHAR2BEZUGSTYP_JE_PVAJD3MJD7
XRUECKABOIS-M: Backdated subscription created XRUECKABOCHAR1XFELD
LIEFVONRegular start of delivery for item in sales order LIEFVONDATS8DATUMJK3
SPARTDivision for publication SPARTDRERZCHAR2SPARTSPA
MATKLMaterial Group MATKLCHAR9MATKLMKLS_WBWG
GSBERBusiness Area GSBERCHAR4GSBERGSB
VOREFComplete reference indicator VOREFCHAR1XFELD
ERLRECompletion rule for quotation / contract ERLRECHAR1ERLRE
TAXM1Tax classification material TAXMTCHAR1TAXKD
TAXM2Tax classification material TAXMTCHAR1TAXKD
TAXM3Tax classification material TAXMTCHAR1TAXKD
TAXM4Tax classification material TAXMTCHAR1TAXKD
TAXM5Tax classification material TAXMTCHAR1TAXKD
TAXM6Tax classification material TAXMTCHAR1TAXKD
TAXM7Tax classification material TAXMTCHAR1TAXKD
TAXM8Tax classification material TAXMTCHAR1TAXKD
TAXM9Tax classification material TAXMTCHAR1TAXKD
VGREFPreceding document has resulted from reference VGREFCHAR1XFELD
STAFOUpdate group for statistics update STAFOCHAR6ALPHASTAFOMCF
STCURExchange rate for statistics (Exch.rate at time of creation) STCUR_APDEC9(5) KURRF
IVWKNCirculation Audit Report Category ID IVWKNCHAR8IVWKN
IVWKNFREICirculation Report Category ID for Non-Calculation Period IVWKNFREICHAR8IVWKN
XLIEFSEDelivery to social facility XLIEFSECHAR1XFELD
LIEFERARTDelivery Type LIEFERARTCHAR2LIEFERARTJLA
LIEFXUHRTime of latest delivery LIEFXUHRTIMS6UZEIT
DRUCKEREIPlant JWERKCHAR4WERKSWRK
VSAUSSTARTShipping outsorting type VSAUSSTARTCHAR2VSAUSSTART
UNTBRGRDReason for Suspension UNTBRGRDCHAR3UNTBRGRDJK9
BEZUGGRDPurchase Reason BEZUGGRDCHAR3BEZUGGRDJK8
KORRGRDIS-M: Reason for correction KORRGRDCHAR3KORRGRDJK7
GUTSCHEINCoupon Number GUTSCHEINNUMC8GUTSCHEIN
XGUTSCHEINIndicator: Vouchers allowed XGUTSCHEINCHAR1XFELD
XDISPOIndicator: relevant to planning XDISPOCHAR1XFELD
XUNVLIEFERIS-M: Viability Data Incomplete for Item XUNVLIEFERCHAR1XFELD
XUNVLAUTOIS-M: Via.data incomp.for item (due to automatic change) XUNVLAUTOCHAR1XFELD
RECHBEGINNBilling From RECHBEGINNDATS8DATUM
RECHENDEBilling To RECHENDEDATS8DATUM
XLIEFBARDetermine delivery viability XLIEFBARCHAR1XFELD
XIVWIndicator: Relevant for audit report XIVWCHAR1XFELD
XFAKTURAIndicator: Relevant for billing XFAKTURACHAR1XFELD
PRSFDCarry out pricing PRSFDCHAR1PRSFD
SBFREIAdministrator responsible for free copies SBFREICHAR12USNAM
WDVDATResubmission date WDVDATDATS8DATUM
KUENDGRDReason for end of delivery KUENDGRDCHAR3KUENDGRD
XLOGOPrint Logo XLOGOCHAR1XFELD
FAKSPBilling Block FAKTSPERRECHAR2FAKSP
XFAKTSPERRIS-M: Billing block set XFAKTSPERRCHAR1XFELD
XREMRECHTIS-M: Right of Return XREMRECHTCHAR1XFELD
XBAGABRIndicator: BAG billing procedure XBAGABRCHAR1XFELD
XURPOSOriginal item in publishing sales order XURPOSCHAR1XFELD
POSNR_UROriginal Item in Publishing Sales Order APNR_URNUMC6APNR
POSNR_VGPreceding Item in Publishing Sales Order APNR_VGNUMC6APNR
VBELN_VLReference Document AVNR_VLCHAR10ALPHAAVNR
POSNR_VLReference Document Item APNR_VLNUMC6APNR
PVAKNTGRPAccount Assignment Grouping for Edition PVAKNTGRPCHAR2KTGRM
PVAKONGRPCondition Grouping for Edition PVAKONGRPCHAR2JKONDMJDPVAKONGRP
PVABONGRPEdition bonus grouping PVABONGRPCHAR2JBONUS
XTECHVORBIndicator: Technical problem XTECHVORBCHAR1XFELD
REMARTReturn Type REMARTCHAR1REMART
REMWEISEReturn Method REMWEISECHAR1REMWEISE
REMQUOTEExpected return rate in percent REMQUOTEDEC5(2) ISPNUM32
XMAXREMMGExpected return quantity is maximum return quantity XMAXREMMGCHAR1XFELD
ETENR_LASTLast Schedule Line Number Assigned ETENR_LASTNUMC4AENR
ETEEX_LASTLast Schedule Line Number Assigned ETEEX_LASTNUMC6ETEEX
KOKRSControlling Area KOKRSCHAR4CACCDCAC
KOSTL_LDebit Cost Center KOSTL_LCHAR10ALPHAKOSTLKOS
XPATEIS-M: Sponsored subscription XPATECHAR1XFELD
BEZIRKCarrier Route BEZIRKCHAR10ALPHABEZIRKBEZMJVC
XLIEFGPIS-M: Delivery to business partner XLIEFGPCHAR1XFELD
XLIEFBEZIS-M: Delivery to a carrier route (reserve) XLIEFBEZCHAR1XFELD
XNEGOPTIONIS-M: Item with Automatic Transformation to Chargeable XNEGOPTIONCHAR1XFELD
BEZPERSEIS-M: Service Type for Social Facility BEZPERSECHAR5BEZPERJD4
VSOZMENGEIS-M: Maximum schedule line quantity for social facility VSOZMENGEQUAN10MENGGPOS
LFBARDATDelivery viability set for sales order item valid from LFBARDATDATS8DATUM
SHKZGIS-M: Debit indicator for schedule line SHKZG_ISPCHAR1XFELD
VKBURZUSSales office responsible VKBURZUSCHAR4VKBUR
ERFUSERCreated By ERFUSERCHAR12USNAM
ERFDATECreated On ERFDATEDATS8DATUM
ERFTIMETime Created ERFTIMETIMS6UZEIT
AENUSERLast Changed By AENUSERCHAR12USNAM
AENDATEDate of Last Change AENDATEDATS8DATUM
AENTIMETime of Last Change AENTIMETIMS6UZEIT
XSTORNOIndicator: Reversed XJSTORNOCHAR1XFELD
STORNOGRDReversal Reason STORNOGRDCHAR3STORNOGRDJK6
REFBELEGIS-M/SD: Reference Document in Legacy System REMELD_ISPCHAR20CHAR20
XSCRIPTSAPscript comment recorded XSCRIPTCHAR1XFELD
WBZSATZARTIS-M: WBZ, Record Type JWBZSTZARTCHAR3JWBZSTZART
WBZVORGARTIS-M: WBZ, Operation Type JWBZVORARTCHAR3JWBZVORART
WERBKZSCHLIS-M: WBZ, Promotion Rebate Key JWBZWKZSCHCHAR1JWBZWKZSCH
WBZABOKUNRIS-M: Subscription Customer Number JWBZABOKNRCHAR9JKWBZJWBZABOKNR
XWBZRUECKUIS-M: WBZ, reply to WBZ company required XJWBZRUECKCHAR1XFELD
WBZKUNNRIS-M: WBZ, VDZ Number of WBZ Company JWBZKUNNRCHAR6JKWBZJWBZKUNNR
VERTRKENNZIS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code) JWBZVKENNZCHAR5JKWBZJWBZVKENNZ
WBZTERMINIS-M: WBZ, Date (Format: MMYYYYCCCC) JWBZTERMINCHAR9CHAR9
WBZVERTRETERIS-M: WBZ, representative indicator JWBZVERTRCHAR7CHAR07
XSEPARATVSIS-M: Separate first delivery JXSEPRATVSCHAR1XFELD
HEFTNUMVONCopy Number of First Issue to be Delivered HEFTNUMVONCHAR9HEFTNUMMER
HEFTNUMBISCopy Number of Last Issue for Delivery HEFTNUMBISCHAR9HEFTNUMMER
XNOMESSIS-M: Indicator - Do Not Perform Output Determination XNOMESSCHAR1XFELD
JNBRIEFTYPLetter type for generating letters using output control JNBRIEFTYPCHAR4JNBRIEFTYP
XFMODRUECKIS-M: Backdated changes to billing method XFMODRUECKCHAR1XFELD
XEXPDATELimited order change affects expiration date XEXPDATECHAR1XFELD
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
XDELIV_FIXEDIS-M/SD: No Del.Viability Optimization (Parameters Fixed) XDELIV_FIXEDCHAR1XFELDJKDELIV_FIXED
XNEW_PUBLIS-M/SD: Item created by change of publication XNEW_PUBLCHAR1XFELD
DELIVSPLITGRPIS-M/SD: Address Alternation Group DELIVSPLITGRPCHAR10ALPHADELIVSPLITGRP
DELIVSPLITIS-M/SD: Alternating Address Element DELIVSPLITCHAR8ALPHADELIVSPLIT
POSNR_MAINIS-M/SD: Main Item in Sales Order APNR_MAINNUMC6APNR
POSNR_SUBIS-M/SD: Sub-Item in Sales Order APNR_SUBNUMC6APNR
XMAINSPLITItem for this Alternating Add. Element is a Main Sub-Item XMAINSPLITCHAR1XFELD
X_MONTAGIS-M: Monday X_MONTAGCHAR1XFELD
X_DIENSTAGIS-M: Tuesday X_DIENSTAGCHAR1XFELD
X_MITTWOCHIS-M: Wednesday X_MITTWOCHCHAR1XFELD
X_DONNETAGIS-M: Thursday X_DONNETAGCHAR1XFELD
X_FREITAGIS-M: Friday X_FREITAGCHAR1XFELD
X_SAMSTAGIS-M: Saturday X_SAMSTAGCHAR1XFELD
X_SONNTAGIS-M: Sunday X_SONNTAGCHAR1XFELD
CAMPAIGNIS-M: Marketing Campaign ISM_MARKETING_CAMPAIGNRAW16MCAMPISM_MARKETING_CAMPAIGNPRPM_CGPL_K
REFUNDTYPEIS-M/SD: Refund Type REFUNDTYPECHAR2REFUNDTYPE
XVACPACKVacation Service: Postponed Delivery XVACPACKCHAR1XFELD
BONUSTYPEIS-M/SD: Bonus Type JBONUSTYPECHAR2JBONUSTYPE
JKAPCC 0
MANDTClient MANDTCLNT3MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10ALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6APNR
CCACTG/L Account Number for Payment Card Receivables CCACTCHAR10ALPHASAKNR
CCINSPayment cards: Card type CCINSCHAR4CCINS
CCNUMPayment cards: Card number CCNUMCHAR25CCNUM
CCFOLPayment cards: Payment card suffix CCFOLCHAR10CHAR10
DATABPayment cards: Valid from DATAB_CCDATS8DATUM
DATBIPayment Cards: Valid To DATBI_CCDATS8DATUM
CCNAMEPayment cards: Name of cardholder CCNAMECHAR40TEXT40
CSOURPayment cards: Entry mode CSOURCHAR1CSOUR
AUTWRPayment cards: Authorized amount AUTWRCURR15(2) WERTV8
CCWAECurrency Key WAERSCUKY5WAERSFWS
SETTLPayment cards: Settlement carried out SETTLCHAR1XFELD
AUNUMPayment cards: Authorization number AUNUMCHAR10CHAR10
AUTRAPayment cards: Authoriz. reference code of clearing house AUTRACHAR15CHAR15
AUDATPayment cards: Authorization date AUDAT_CCDATS8DATUM
AUTIMPayment cards: Authorization time AUTIMTIMS6UZEIT
MERCHPayment cards: Merchant ID at the clearing house MERCHCHAR15MERCH
LOCIDPayment cards: Point of receipt for the transaction LOCID_CCCHAR10LOCID_CC
TRMIDPayment cards: Terminal TRMIDCHAR10CHAR10
CCBTCPayment cards: Settlement run CCBTCCHAR10ALPHACCBTC
CCTYPPayment cards: Card category CCTYPCHAR2CCTYP
CCARD_GUIDReference to Encrypted Payment Card Data CCARDEC_GUIDCHAR32SYSUUID_C
CCAUAPayment cards: Authorization type CCAUACHAR1CCAUA
CCALLPayment cards: Status when external system is called? CCALLCHAR1CCALL
REACTPayment cards: Response to authorization checks REACT_SDCHAR1REACT_SD
AUTWVPayment cards: Amount to be authorized AUTWVCURR15(2) WERTV8
CCOLDPayment cards: Authorization has expired CCOLDCHAR1XFELD
CCVALPayment cards: Amount changed CCVALCHAR1XFELD
CCPREPayment cards: Preauthorization CCPRECHAR1XFELD
UELTR_AHigher-level authorization for billing plan UELTR_ANUMC6FPLTR
RCAVRPayment Cards: Result of Address Check (Address Result) RCAVR_CCCHAR4CHAR4
RCAVAPayment Cards: Result of Address Check (Address Approval) RCAVA_CCCHAR4CHAR4
RCAVZPayment Cards: Result of Address Check (ZIP Code Result) RCAVZ_CCCHAR4CHAR4
RCRSPPayment cards: Result of card check (response code) RCRSP_CCCHAR4CHAR4
RTEXTPayment cards: Result text RTEXT_CCCHAR40TXT40
XPAYMODE_SYNC Synch. of Payment Method from Contract Account After Billing0
ISM_CVVALCard Verification Value ISM_CVVALCHAR6ISM_CVVAL
ISM_CVVCTControl Field for Card Verification Value ISM_CVVCTCHAR1ISM_CVVCT
ISM_CVVSTUsage Status of Card Verification Value ISM_CVVSTCHAR1ISM_CVVST
ISM_RCCVVResults Check for Card Verification Value ISM_RCCVV_CCCHAR4CHAR4
CGUIDGUID of a Payment Card CARD_GUIDRAW16SYSUUID
ENCTPType of Encryption CCSECA_ENCTYPECHAR1CCSECA_ENCTYPE
JKPA 0
MANDTClient MANDTCLNT3MANDT
VBELNIS-M/SD: Publishing Sales Order AVNRCHAR10ALPHAAVNRJK1MJK1
POSNRSales Order Item APNRNUMC6APNR
JPARVWIS-M: Business Partner Role JPARVWCHAR2PARVWJPARVWJGR
PARZAIS-M: Partner Role Counter JPARZANUMC3JPARZA
GUELTIGVONDate from Which Partner Data in Sales Order is Valid JKPAVONDATS8DATUM
GUELTIGBISDate to Which Partner Data in Sales Order is Valid JKPABISDATS8DATUM
GPNRIS-M: Business Partner Key GPNRCHAR10ALPHAGPNRJGPMJG0
VERSERVGESIS-M: Service Company VERSERVGESCHAR10ALPHAGPNRJGFMJG0G
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
PARNRNumber of contact person PARNRNUMC10PARNRVPA
ADRNRIS-M: Address Number JADRNRCHAR10ALPHAJADRNR
ADRESSVARIS-M: Address Variant ADRESSVARCHAR1ERSTADR
HERKIS-M: Use of Address HERKCHAR1HERK
PLZ_ORDERIS-M: Postal Code PLZ_ISPCHAR10PSTLZ
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
BEABLSTIS-M: Unloading Point BEABLSTCHAR10ALPHABEABLSTBASMJV2
BANKSBank country key BANKSCHAR3LAND1BKL
BANKLBank Keys BANKKCHAR15BANKKBNK
BANKNBank account number BANKNCHAR18BANKN
BKONTBank Control Key BKONTCHAR2BKONT
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
XEZERIndicator: Is there collection authorization ? XEZERCHAR1XFELD
ZLSCHIS-M: Payment Method JZLSCHCHAR1ZLSCH
KREISG_SCHIS-M: District municipality key of ship-to party KGS_ORDERCHAR15ALPHAKREISG_SCH

Key field Non-key field



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

As MSC_ITEM_S 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 MSC_ITEM_S as there is no data to select.

How to access SAP table MSC_ITEM_S

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