MC11V_0ITM SAP (Extraction SD Sales BW: Document Item Allocation) Structure details

Dictionary Type: Structure
Description: Extraction SD Sales BW: Document Item Allocation




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




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

MC11V_0ITM 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 "Extraction SD Sales BW: Document Item Allocation" 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_MC11V_0ITM TYPE MC11V_0ITM.

The MC11V_0ITM table consists of various fields, each holding specific information or linking keys about Extraction SD Sales BW: Document Item Allocation data available in SAP. These include VBELN (Sales and Distribution Document Number), ABSTA (Rejection status for SD item), POSNR (Item number of the SD document), BUKRS (Company Code).. 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 MC11V_0ITM 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
ROCANCELIndicator: Cancel Data Record ROCANCELCHAR1BOOLE
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
ABSTARejection status for SD item ABSTA_VBCHAR1STATV
POSNRItem number of the SD document POSNRNUMC6Assigned to domainPOSNR
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
FAKSKBilling block in SD document FAKSKCHAR2Assigned to domainFAKSP
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
KUNNRSold-to party KUNAGCHAR10Assigned to domainALPHAKUNNRVAG
KURSTExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
KVGR1Customer group 1 KVGR1CHAR3Assigned to domainKVGR1
KVGR2Customer group 2 KVGR2CHAR3Assigned to domainKVGR2
KVGR3Customer group 3 KVGR3CHAR3Assigned to domainKVGR3
KVGR4Customer group 4 KVGR4CHAR3Assigned to domainKVGR4
KVGR5Customer group 5 KVGR5CHAR3Assigned to domainKVGR5
LIFSKDelivery block (document header) LIFSKCHAR2Assigned to domainLIFSP
STWAEStatistics currency STWAECUKY5Assigned to domainWAERS
VBTYPSD document category VBTYPCHAR1VBTYP
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
ABGRUReason for rejection of quotations and sales orders ABGRU_VACHAR2Assigned to domainABGRU_VA
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
ERDATDate on Which Record Was Created ERDATDATS8DATUM
FAKSPBilling block for item FAKSP_APCHAR2Assigned to domainFAKSP
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MATWAMaterial entered MATWACHAR18Assigned to domainMATN1MATNRMAT
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MVGR1Material group 1 MVGR1CHAR3Assigned to domainMVGR1
MVGR2Material group 2 MVGR2CHAR3Assigned to domainMVGR2
MVGR3Material group 3 MVGR3CHAR3Assigned to domainMVGR3
MVGR4Material group 4 MVGR4CHAR3Assigned to domainMVGR4
MVGR5Material group 5 MVGR5CHAR3Assigned to domainMVGR5
OAUMEOpen orders quantity in base unit of measure MC_OAUMEQUAN15(3) MENGV15_3
OAUWEOpen net value of orders MC_OAUWECURR19(2) WERTV10
PKUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
PKUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
PKUNWEShip-to party KUNWECHAR10Assigned to domainALPHAKUNNR
PRODHProduct hierarchy PRODH_DCHAR18Assigned to domainPRODHVPR
PSPDNRForwarding agent SPDNRCHAR10Assigned to domainALPHALIFNR
PVRTNRSales employee VRTNRNUMC8PERNRPREMV
PZPERSPerson responsible DZPERSNUMC8PERNR
ROUTERoute ROUTECHAR6Assigned to domainROUTE
SHKZGReturns Item SHKZG_VACHAR1XFELD
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
STADATStatistics date STADATDATS8DATUM
STCURExchange rate for statistics (Exch.rate at time of creation) STCUR_APDEC9(5) KURRF
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
VRKMESales unit VRKMEUNIT3Assigned to domainCUNITMEINS
VSTELShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
WAERKSD Document Currency WAERKCUKY5Assigned to domainWAERSFWS
WERKSPlant (Own or External) WERKS_EXTCHAR4Assigned to domainWERKSWRKSH_T001W_EXTS
BZIRKSales district BZIRKCHAR6Assigned to domainBZIRKBZI
INCO1Incoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
KDGRPCustomer group KDGRPCHAR2Assigned to domainKDGRPVKD
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
KURSK_DATTranslation Date WWERT_DDATS8DATUM
WAKTIONCOUPON WAKTIONCHAR10Assigned to domainALPHAWAKTIONWAK
SPARADivision for order header SPART_AKCHAR2Assigned to domainSPARTSPA
PS_POSIDWork Breakdown Structure Element (WBS Element) PS_POSIDCHAR24PROJNPS_POSIDPRO
ANZOAUPONumber of Open Sales Order Items MCBW_ANZOAUPODEC9MCZAEHLER
LFIMG_AVMEActual quantity delivered (in sales units) LFIMGQUAN13(3) MENG13
MCBW_LFWRTBW: Delivered Sales Order Value MCBW_LFWRTCURR19(2) WERTV10
MCBW_NETPR_AVKMBW: Net Price Referring to Sales Quantity for Order Item MCBW_NETPR_AVKMCURR11(2) WERTV6
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
MCEX_APCAMPAIGNCampaign of referred sales order item for BW-Extraction MCEX_APCAMPAIGNCHAR32SYSUUID_C

Key field Non-key field



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

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

How to access SAP table MC11V_0ITM

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