MCCOMVTRLP SAP (BW Communication Structure Delivery in Shipping: Item) Structure details
Description: BW Communication Structure Delivery in Shipping: Item
Structure field list including key, data, relationships and ABAP select examples
MCCOMVTRLP 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 "BW Communication Structure Delivery in Shipping: Item" 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_MCCOMVTRLP TYPE MCCOMVTRLP.
The MCCOMVTRLP table consists of various fields, each holding specific information or linking keys about BW Communication Structure Delivery in Shipping: Item data available in SAP. These include VBELN (Sales and Distribution Document Number), POSNR (Item number of the SD document), POSEX (Item Number of the Underlying Purchase Order), MATNR (Material Number).. 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 MCCOMVTRLP 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 |
VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item number of the SD document | POSNR | NUMC | 6 | VBUP | POSNR | |||
POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATWA | Material entered | MATWA | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
IDNKD | Material Number Used by Customer | MATNR_KU | CHAR | 35 | IDNEX | ||||
ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | TEXT40 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
VKBUR | Sales Office | VKBUR | CHAR | 4 | Assigned to domain | VKBUR | VKB | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
SERNR | BOM explosion number | SERNR | CHAR | 8 | Assigned to domain | SERNR | |||
HERKL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
HERKR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | Assigned to domain | REGIO | |||
STAWN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | Assigned to domain | STAWN | |||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
LFIMG | Actual quantity delivered (in sales units) | LFIMG | QUAN | 13(3) | MENG13 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
MBDAT | Material Staging/Availability Date | MBDAT | DATS | 8 | DATUM | ||||
VBELN_VAUF | Order | VBELN_VAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUF | |
POSNR_VAUF | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
AUDAT_VAUF | Sales order date | AUDAT_VAUF | DATS | 8 | DATUM | ||||
BSTDK | Customer purchase order date | BSTDK | DATS | 8 | DATUM | ||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | BSTNK | ||||
BSTZD | Purchase order number supplement | BSTZD | CHAR | 4 | BSTZD | ||||
IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
INCO1_BEZ | Incoterm description | INCO1_BEZ | CHAR | 30 | TEXT30 | ||||
TDNAME | Name | TDOBNAME | CHAR | 70 | TDOBNAME | ||||
UEPOS | Higher-level item in bill of material structures | UEPOS | NUMC | 6 | Assigned to domain | POSNR | |||
VOLUM | Volume | VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
EXART | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | Assigned to domain | EXART | EXA | ||
EXART_BEZ | Description | BEZEI20 | CHAR | 20 | TEXT20 | ||||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | Assigned to domain | POSNR | |||
VGTYP | Activity or element category | VGTYP | CHAR | 3 | VORG_TYP | ||||
SORTKRI | Sort Criterion | SORTKRI | CHAR | 20 | CHAR20 | ||||
LGMNG | Actual quantity delivered in stockkeeping units | LGMNG | QUAN | 13(3) | MENG13 | ||||
KCMENG | Cumulative batch quantity of all split items (in StckUnit) | KCMENG | QUAN | 15(3) | MENG15 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | Assigned to domain | POSNR | |||
KCBRGEW | Cumulative gross weight of all batch split items | KCBRGEW | QUAN | 15(3) | MENG15 | ||||
KCNTGEW | Cumulative net weight of all batch split items | KCNTGEW | QUAN | 15(3) | MENG15 | ||||
KCGEWEI | Weight unit for weight of all batch split items | KCGEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KCVOLUM | Cumulative volume of all batch split items | KCVOLUM | QUAN | 15(3) | MENG15 | ||||
KCVOLEH | Volume Unit for Volume of all Batch Split Items | KCVOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KNUMH_CH | Number of condition record from batch determination | KNUMH_CH | CHAR | 10 | KNUMB | ||||
UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | UMBSZ | ||||
UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | UMBSN | ||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | CUOBJ | ||||
SHKZG | Returns Item | SHKZG_VA | CHAR | 1 | XFELD | ||||
PCKPF | Packing control | PCKPF | CHAR | 1 | PCKPF | ||||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | Assigned to domain | ABRVW | |||
ABART | Release type | ABART | CHAR | 1 | ABART | ||||
ABRLI | Internal delivery schedule number | ABRLI | NUMC | 4 | Assigned to domain | ABRLI | |||
AESKD | Customer Engineering Change Status | AESKD | CHAR | 17 | AESKD | ||||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
ABTNR | Department number | ABTNR | CHAR | 4 | Assigned to domain | ABTNR | |||
POSAR | Item type | POSAR | CHAR | 1 | POSAR | ||||
PSTYV | Delivery item category | PSTYV_VL | CHAR | 4 | TVLP | PSTYV | |||
TPREL | Indicator: Relevance for transport of deliv. item categories | TPREL | CHAR | 1 | XFELD | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NETPR | Net price | NETPR | CURR | 11(2) | WERTV6 | ||||
NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | Assigned to domain | ALPHA | WAKTION | WAK | |
SUGRD | Reason for material substitution | SUGRD | CHAR | 4 | Assigned to domain | SUGRD | VDG | ||
SUDRU | Original entry will be printed | SUDRU | CHAR | 1 | XFELD | ||||
VBRST | Customer point of consumption | VBRST | CHAR | 14 | CHAR14 | ||||
USR01_VBLB | Additional data field 1 for delivery schedules | USR01_D | CHAR | 35 | TEXT35 | ||||
USR02_VBLB | Additional data field 2 for delivery schedules | USR02_D | CHAR | 35 | TEXT35 | ||||
USR03_VBLB | Additional data field 3 for delivery schedules | USR03_D | CHAR | 35 | TEXT35 | ||||
USR04_VBLB | Additional data field 4 for delivery schedules | USR04_D | CHAR | 10 | CHAR10 | ||||
USR05_VBLB | Additional data field 5 for delivery schedules | USR05_D | CHAR | 10 | CHAR10 | ||||
PREFE | Preference indicator in export/import | PREFE | CHAR | 1 | PREFE | ||||
LABNK | Customer number for forecast / JIT dlv. sched. | LABNK | CHAR | 17 | TEXT17 | ||||
ABRDT | Delivery Schedule Date | ABRDT | DATS | 8 | DATUM | ||||
KZUMW | Environmentally Relevant | KZUMW | CHAR | 1 | XFELD | ||||
PROFL | Dangerous Goods Indicator Profile | ADGE_PROFL | CHAR | 3 | Assigned to domain | ADGD_PROFL | |||
IDGPA | Relevant for Dangerous Goods Documents | ADGE_IDGPA | CHAR | 1 | X | ||||
IDGCH | Relevant for Dangerous Goods Checks | ADGE_IDGCH | CHAR | 1 | X | ||||
DGNTGEW | Dangerous goods - net weight | ADGE_NTGEW | QUAN | 15(3) | MENG15 | ||||
DGBRGEW | Dangerous Goods - Gross Weight | ADGE_BRGEW | QUAN | 15(3) | MENG15 | ||||
DGGEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DGVOLUM | Dangerous goods - volume | ADGE_VOLUM | QUAN | 15(3) | MENG15 | ||||
DGVOLEH | Volume unit | VOLEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DGARAND | Exemption | ADGE_KARN | CHAR | 1 | X | ||||
DGREPQU | Indicator: Reportable quantity | ADGE_IRQA | CHAR | 1 | X | ||||
DGPULIM | Packed Under 450 l | ADGE_IPUL | CHAR | 1 | X | ||||
DGPAS | Listed Goods | ADGE_PAS | CHAR | 1 | X | ||||
DGMDDAT | Selection date dangerous goods master data | ADGE_MDDAT | DATS | 8 | DATUM | ||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | BSTKD | ||||
BSARK | Customer purchase order type | BSARK | CHAR | 4 | Assigned to domain | BSARK | |||
BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | BSTKD | ||||
BSTDK_E | Ship-to party's PO date | BSTDK_E | DATS | 8 | DATUM | ||||
BSARK_E | Ship-to party purchase order type | BSARK_E | CHAR | 4 | Assigned to domain | BSARK | |||
IHREZ_E | Ship-to party character | IHREZ_E | CHAR | 12 | TEXT12 | ||||
POSEX_E | Item Number of the Underlying Purchase Order | POSEX_E | CHAR | 6 | ALPHA | POSEX | |||
VBKLT | SD document indicator | VBKLT | CHAR | 1 | VBKLT | ||||
MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG | |
MTART | Material Type | MTART | CHAR | 4 | Assigned to domain | MTART | MTA | ||
PRODH | Product hierarchy | PRODH_D | CHAR | 18 | Assigned to domain | PRODH | VPR | ||
QMNUM | Notification No | QMNUM | CHAR | 12 | Assigned to domain | ALPHA | QMNUM | IQM | |
QMDAT | Date of Notification | QMDAT | DATS | 8 | DATUM | ||||
MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | ALPHA | MSR_PROCESS_ID | |||
MSR_ITEM | Item Number | MSR_PROCESS_ITEM | NUMC | 6 | MSR_PROCESS_ITEM | ||||
RMA_CUSTOMER | Customer RMA Number | MSR_CRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | CHAR | 3 | Assigned to domain | MSR_RETURNS_REASON | |||
MSR_RET_REASON_TEXT | Return Reason Description | MSR_RET_REASON_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_MAT_RECEIVED | Material Received | MSR_MATERIAL_RECEIVED | CHAR | 1 | XFELD | ||||
MSR_FU_CODE | Follow-Up Activity Code | MSR_FU_CODE | CHAR | 4 | Assigned to domain | MSR_FU_CODE | |||
MSR_FU_CODE_TEXT | Follow-Up Activity Description | MSR_FU_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_VENDOR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
MSR_FWV_TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | Assigned to domain | AD_TITLE | |||
MSR_FWV_ADDRNUM | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
MSR_FWV_NAME1 | Name 1 | AD_NAME1 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME2 | Name 2 | AD_NAME2 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME3 | Name 3 | AD_NAME3 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_NAME4 | Name 4 | AD_NAME4 | CHAR | 40 | TEXT40 | ||||
MSR_FWV_STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
MSR_FWV_PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
MSR_FWV_PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
MSR_FWV_CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | Assigned to domain | ALPHA | CITY_CODE | ||
MSR_FWV_COUNTRY | Country Key | LAND1 | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
MSR_FWV_LANGU | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
MSR_FWV_POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
MSR_FWV_CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
MSR_FWV_CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
MSR_FWV_REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
RMA_VENDOR | Vendor RMA Number | MSR_VRMA_NR | CHAR | 20 | MSR_RMA_NR | ||||
MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | CHAR | 3 | MSR_RETURNS_REFUND_CODE | ||||
MSR_REFUND_CODE_TEXT | Refund Code Description | MSR_REFUND_CODE_TEXT | CHAR | 60 | TEXT60 | ||||
MSR_FORW_PLANT1 | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MSR_PLANT1_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT2 | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MSR_PLANT2_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
MSR_FORW_PLANT3 | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
MSR_PLANT3_TXT | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/EMMVGR1 | Material group 1 | MVGR1 | CHAR | 3 | Assigned to domain | MVGR1 | |||
/BEV1/EMMVGR2 | Material group 2 | MVGR2 | CHAR | 3 | Assigned to domain | MVGR2 | |||
/BEV1/EMMVGR3 | Material group 3 | MVGR3 | CHAR | 3 | Assigned to domain | MVGR3 | |||
/BEV1/EMMVGR4 | Material group 4 | MVGR4 | CHAR | 3 | Assigned to domain | MVGR4 | |||
/BEV1/EMMVGR5 | Material group 5 | MVGR5 | CHAR | 3 | Assigned to domain | MVGR5 | |||
/BEV1/EMNEUPOS | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
.INCLU--AP | 0 | ||||||||
LIFEXPOS | External item number | LIFEXPOS | NUMC | 6 | Assigned to domain | POSNR | |||
PROSA | ID for material determination | PROSA | CHAR | 1 | PROSA | ||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | XFELD | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | Assigned to domain | BWART | BWA | ||
MFRGR | Material freight group | MFRGR | CHAR | 8 | Assigned to domain | MFRGR | |||
GARVZ | Freight code set | GARVZ | CHAR | 6 | TGAV | GARVZ | GVZ | ||
GTART | Freight code | GTART | CHAR | 12 | TGAR | GTART | |||
GTKLS | Freight class | GTKLS | CHAR | 12 | CHAR12 | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
UEPVW | ID for higher-level item usage | UEPVW | CHAR | 1 | UEPVW | ||||
MAGRV | Material Group: Packaging Materials | MAGRV | CHAR | 4 | Assigned to domain | MAGRV | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
LADGR | Loading Group | LADGR | CHAR | 4 | Assigned to domain | LADGR | |||
TRAGR | Transportation Group | TRAGR | CHAR | 4 | Assigned to domain | TRAGR | |||
FKREL | Relevant for Billing | FKREL | CHAR | 1 | FKREL | ||||
KZFME | ID: Leading unit of measure for completing a transaction | KZFME | CHAR | 1 | KZFME | ||||
KCMENGVME | Cumulative batch quantity of all split items in sales units | KCMENG_VME | QUAN | 15(3) | MENGV15_3 | ||||
VBELV | Originating document | VBELV | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
POSNV | Originating item | POSNV | NUMC | 6 | Assigned to domain | POSNR | |||
VBTYV | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ |
Key field | Non-key field |
How do I retrieve data from SAP structure MCCOMVTRLP using ABAP code?
As MCCOMVTRLP 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 MCCOMVTRLP as there is no data to select.How to access SAP table MCCOMVTRLP
Within an ECC or HANA version of SAP you can also view further information about MCCOMVTRLP 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