MMBSI_SRC_DETRM_EXTN_STY SAP (source of supply additional column) Structure details

Dictionary Type: Structure
Description: source of supply additional column




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




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

MMBSI_SRC_DETRM_EXTN_STY 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 "source of supply additional column" 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_MMBSI_SRC_DETRM_EXTN_STY TYPE MMBSI_SRC_DETRM_EXTN_STY.

The MMBSI_SRC_DETRM_EXTN_STY table consists of various fields, each holding specific information or linking keys about source of supply additional column data available in SAP. These include LIFNR (Account Number of Vendor or Creditor), RESWK (Supplying (Issuing) Plant in Stock Transport Order), EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document).. 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 MMBSI_SRC_DETRM_EXTN_STY 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
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4Assigned to domainWERKS
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
PSTYPItem Category in Purchasing Document PSTYPCHAR1Assigned to domainPSTYP
NETPRNet price NETPRCURR11(2) WERTV6
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
EMATNMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
UMREZNumerator for Conversion to Base Units of Measure UMREZDEC5UMBSZ
UMRENDenominator for conversion to base units of measure UMRENDEC5UMBSN
VRTYPPurchasing Document Category BSTYPCHAR1BSTYP
VERIDProduction Version VERIDCHAR4Assigned to domainVERIDVER
INF_EKORGReference Purchasing Organization WEKORGCHAR4Assigned to domainEKORGEKO
UEKONNumber of Principal Purchase Agreement KONNRCHAR10Assigned to domainALPHAEBELNKTR
UEKTPItem Number of Principal Purchase Agreement KTPNRNUMC5Assigned to domainEBELP
MPROFManufacturer Part Profile MPROFCHAR4Assigned to domainMPROF
MFRNRNumber of a Manufacturer MFRNRCHAR10Assigned to domainALPHALIFNR
MFRPNManufacturer Part Number MFRPNCHAR40CHAR40
EMNFRExternal manufacturer code name or number EMNFRCHAR10CHAR10
RLFDTRealistic Delivery Date RLFDTDATS8DATUM
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
MNG02Committed Quantity MNG06QUAN13(3) MENGV13
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4Assigned to domainLGORT
MHDRZMinimum Remaining Shelf Life MHDRZDEC4DEC4
IPRKZPeriod Indicator for Shelf Life Expiration Date DATTPCHAR1PERKZDATTPH_PERDKZ
SRM_CONTRACT_IDCentral Contract SRM_CONTRACT_IDCHAR10ALPHABBP_BAPI_EBELNMMBSI_MEKK_CC
SRM_CONTRACT_ITMCentral Contract Item Number SRM_CONTRACT_ITEMNUMC10BBP_ITEMNO
.INCLU--AP 0
BESWKProcuring Plant BESWKCHAR4Assigned to domainWERKSBESW
EXT_SRCHExtended Source Determination EXT_SRCHCHAR1EXT_SRCH
TEXTLong Text Information MMBSI_TEXTCHAR20CHAR20
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
STATUStatus of Purchasing Document ESTAKCHAR1ESTAK
DESCRIPTIONContract Name CONTRACT_DESCRIPTIONCHAR40TEXT40
HIERARCHY_EXISTSPart of a Contract Hierarchy HIERARCHY_EXISTSCHAR1XFELD
THRESHOLD_EXISTSThreshold Value for Exchange Rates Exists EX_RATE_THRESHOLDCHAR1XFELD
NETWRNet Order Value in PO Currency BWERTCURR13(2) WERT7
REL_QUANTITYQuantity with Sign MENGEVQUAN13(3) MENGV13
REL_VALUERelease Value of Contract REL_VALUECURR15(2) WERT15

Key field Non-key field



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

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

How to access SAP table MMBSI_SRC_DETRM_EXTN_STY

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