MCCOMVTTS SAP (BW Communication Structure Stage of Shipment) Structure details
Description: BW Communication Structure Stage of Shipment
Structure field list including key, data, relationships and ABAP select examples
MCCOMVTTS 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 Stage of Shipment" 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_MCCOMVTTS TYPE MCCOMVTTS.
The MCCOMVTTS table consists of various fields, each holding specific information or linking keys about BW Communication Structure Stage of Shipment data available in SAP. These include MANDT (Client), TKNUM (Shipment Number), TSNUM (Stage of transport number), TSTYP (Stage category).. 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 MCCOMVTTS 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
TKNUM | Shipment Number | TKNUM | CHAR | 10 | VTTK | ALPHA | TKNUM | TNR | SD_F4_SHP_ID |
TSNUM | Stage of transport number | TSNUM | NUMC | 4 | Assigned to domain | TSNUM | |||
TSTYP | Stage category | TSTYP | CHAR | 1 | TSTYP | ||||
TSRFO | Stage of transport sequence | TSRFO | NUMC | 4 | TSRFO | ||||
ELUPD | Change Indicator | ELUPD | CHAR | 1 | ELUPD | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
ROUTE | Route for shipment stage | ROUTES | CHAR | 6 | TVRO | ROUTE | |||
VSART | Shipping type for shipment stage | VERSARTS | CHAR | 2 | T173 | VERSART | |||
INCO1 | Incoterms for printout | INCO1VTTS | CHAR | 3 | TINC | INCO1 | |||
LAUFK | Leg indicator for shipment stage | LAUFS | CHAR | 1 | LAUFK | ||||
ADRNA | Departure point: Address | ADRNA | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
KNOTA | Departure Point | KNOTA | CHAR | 10 | TVKN | KNOTN | |||
VSTEL | Shipping point at point of departure | VSTELA | CHAR | 4 | TVST | VSTEL | VST | ||
LSTEL | Point of departure: Loading point at shipping point | LSTELA | CHAR | 2 | TVLA | LSTEL | |||
WERKA | Plant at point of departure | WERKSA | CHAR | 4 | T001W | WERKS | |||
LGORTA | Departure point: Storage location in plant | LGORTA | CHAR | 4 | T001L | LGORT | |||
KUNNA | Departure point: Customer | KUNNA | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LIFNA | Vendor number of departure point | LIFNA | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
BELAD | Point of departure: Additional info (e.g. loading point) | BELAD | CHAR | 25 | TEXT25 | ||||
ADRNZ | Destination address | ADRNZ | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
KNOTZ | Destination point | KNOTZ | CHAR | 10 | TVKN | KNOTN | |||
VSTEZ | Shipping point at destination | VSTELZ | CHAR | 4 | TVST | VSTEL | VST | ||
LSTEZ | Destination: Loading point at shipping point | LSTELZ | CHAR | 2 | TVLA | LSTEL | |||
WERKZ | Plant at destination point | WERKSZ | CHAR | 4 | T001W | WERKS | |||
LGORTZ | Destination: Storage location in plant | LGORTZ | CHAR | 4 | T001L | LGORT | |||
KUNNZ | Customer number for destination point | KUNNZ | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
LIFNZ | Vendor number of destination point | LIFNZ | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
ABLAD | Destination: Additional information (e.g. unloading point) | ABLADZ | CHAR | 25 | TEXT25 | ||||
DPTBG | Stage: Planned date for start of shipment | DPTBGS | DATS | 8 | DATUM | ||||
UPTBG | Stage: Planned shipment start time | UPTBGS | TIMS | 6 | UZEIT | ||||
DATBG | Stage: Current date for start of shipment | DATBGS | DATS | 8 | DATUM | ||||
UATBG | Stage: Current shipment start time | UATBGS | TIMS | 6 | UZEIT | ||||
DPTEN | Stage: Planned date for end of shipment | DPTENS | DATS | 8 | DATUM | ||||
UPTEN | Stage: Planned shipemnt end time | UPTENS | TIMS | 6 | UZEIT | ||||
DATEN | Stage: Actual Date for End of Shipment | DATENDS | DATS | 8 | DATUM | ||||
UATEN | Stage: Actual shipment end time | UATENDS | TIMS | 6 | UZEIT | ||||
TDLNR | Number of forwarding agent in the shipment stage | TDLNRS | CHAR | 10 | LFA1 | ALPHA | LIFNR | F4_CARRIERS | |
DISTZ | Distance | DISTZ | QUAN | 13(3) | MENG13 | ||||
MEDST | Unit of measure for distance | MEDST | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FAHZT | Travelling time only between two locations | FAHZT | QUAN | 5(2) | FAHZT | ||||
GESZT | Total travelling time between two locations incl. breaks | GESZT | QUAN | 5(2) | FAHZT | ||||
MEIZT | Unit of measure for travelling times | MEIZT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LGNUMA | Point of departure: Warehouse number | LGNUMA | CHAR | 3 | T300 | LGNUM | LGN | ||
TORA | Point of departure: Gate for warehouse number | LGTORA | CHAR | 3 | T30B | LGTOR | |||
ADRKNZA | Point of departure: Origin indicator of address | ADRKNZA | CHAR | 1 | ADRKNZ | ||||
KUNABLA | Point of departure: Customer's unloading point | KUNABLA | CHAR | 25 | KNVA | TEXT25 | |||
LGNUMZ | Destination: Warehouse number | LGNUMZ | CHAR | 3 | T300 | LGNUM | LGN | ||
TORZ | Destination. Gate for warehouse number | LGTORZ | CHAR | 3 | T30B | LGTOR | |||
ADRKNZZ | Destination: Origin indicator of address | ADRKNZZ | CHAR | 1 | ADRKNZ | ||||
KUNABLZ | Destination: Customer's unloading point | KUNABLZ | CHAR | 25 | KNVA | TEXT25 | |||
GESZTD | Planned total time at stage level (in days) | AB_GESZTDP | DEC | 11 | TSTRG | TSTRDURAG | |||
FAHZTD | Plan: Actual duration at stage level (in hours:minutes) | AB_EFFZTDP | DEC | 11 | TSTRN | TSTRDURAN | |||
GESZTDA | Actual total time at stage of shipment (in days) | AB_GESZTDA | DEC | 11 | TSTRG | TSTRDURAG | |||
FAHZTDA | Actual duration of shipment stage (in hours:minutes) | AB_EFFZTDA | DEC | 11 | TSTRN | TSTRDURAN | |||
SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | SDABW | |||
FRKRL | Shipment costs relevance | FRKRL | CHAR | 1 | FRKRL | ||||
SKALSM | Pricing procedure in stage of shipment | KALSM_TRAB | CHAR | 6 | T683 | KALSM | |||
FBSTA | Status of shipment costs calculation | FBSTA | CHAR | 1 | FBSTA | ||||
ARSTA | Status of shipment costs settlement | ARSTA | CHAR | 1 | ARSTA | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
CONT_DG | Indicator: Section contains dangerous goods | ADGE_SCDG | CHAR | 1 | X | ||||
WARZTD | Planned waiting time in shipment stage (in hrs:min) | AB_WARZTDP | DEC | 11 | TSTRN | TSTRDURAN | |||
WARZTDA | Current waiting time in shipment stage (in hrs:min) | AB_WARZTDA | DEC | 11 | TSTRN | TSTRDURAN | |||
ABLAND1 | Country of departure | ABLAND1 | CHAR | 3 | T005 | LAND1 | |||
ABPSTLZ | Departure postal code | ABPSTLZ | CHAR | 10 | PSTLZ | ||||
ABORT01 | Point of departure | ABORT01 | CHAR | 35 | ORT01 | ||||
EDLAND1 | Destination Country | EDLAND1 | CHAR | 3 | T005 | LAND1 | |||
EDPSTLZ | Destination Postal Code | EDPSTLZ | CHAR | 10 | PSTLZ | ||||
EDORT01 | Destination | EDORT01 | CHAR | 35 | ORT01 | ||||
UPDKZ | Update indicator | UPDKZ_D | CHAR | 1 | UPDKZ | ||||
DLNAMT | Name of the Service Agent | DLNRNAME | CHAR | 35 | NAME | ||||
VSBEDT | Description of the shipping conditions | VSBED_BEZ | CHAR | 20 | TEXT20 | ||||
ADRNAD | Departure point: Address | ADRNA | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
ADRHNDA | Point of departure: Handle of an address | ADRHNDA | CHAR | 10 | TEXT10 | ||||
UPDADA | Point of departure: Update indicator of address | UPDKZA | CHAR | 1 | UPDKZ | ||||
TKNOTA | Description of departure point | BEZKNOTA | CHAR | 30 | TEXT30 | ||||
TORT2A | Description of departure point - Part 2 | BEZKNOTA2 | CHAR | 30 | TEXT30 | ||||
PSTLZA | Departure point: Postal code | PSTLZ_A | CHAR | 10 | PSTLZ | ||||
LAND1A | Point of departure: Country key | LAND1_A | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LZONEA | Point of departure: Transportation zone | LZONE_A | CHAR | 10 | Assigned to domain | ZONE | |||
REGIOA | Dep.point: Region (state, Federal county, province etc.) | REGIO_A | CHAR | 3 | Assigned to domain | REGIO | |||
BEZKOMPRA | Departure point: Description of location (compressed) | BEZKOMPRA | CHAR | 60 | CHAR60 | ||||
ADRNZD | Destination address | ADRNZ | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
ADRHNDZ | Destination: Handle of an address | ADRHNDZ | CHAR | 10 | TEXT10 | ||||
UPDADZ | Destination: Update indicator of address | UPDKZZ | CHAR | 1 | UPDKZ | ||||
TKNOTZ | Description of destination point | BEZKNOTZ | CHAR | 30 | TEXT30 | ||||
TORT2Z | Description of destination - Part 2 | BEZKNOTZ2 | CHAR | 30 | TEXT30 | ||||
PSTLZZ | Destination: Postal code | PSTLZ_Z | CHAR | 10 | PSTLZ | ||||
LAND1Z | Destination: Country key | LAND1_Z | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
LZONEZ | Destination: Transportation zone | LZONE_Z | CHAR | 10 | Assigned to domain | ZONE | |||
REGIOZ | Destination: Region (state, Federal county, province) | REGIO_Z | CHAR | 3 | Assigned to domain | REGIO | |||
BEZKOMPRZ | Destination: Description of Location (Compressed) | BEZKOMPRZ | CHAR | 60 | CHAR60 | ||||
ADRNRDL | Address no. of forwarding agent | ADRNR_SP | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
ADRDADL | Address indicator | ADRDA | CHAR | 1 | ADRDA | ||||
PARVW | Partner Function | PARVW | CHAR | 2 | Assigned to domain | PARVW | PARVW | PAR | |
SUPKZ | Statistics update indicator (post in/post out) | SUPKZ | CHAR | 1 | SUPKZ | ||||
.INCLU--AP | 0 | ||||||||
OBJIDPROV | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
MPO_MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
RIC | Reportable Item Code | /ISDFPS/RICODE | CHAR | 6 | Assigned to domain | /ISDFPS/RICODE | |||
OBJIDREC | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
OPERATION_ID | Operation/Exercise ID | /ISDFPS/OPERATION_ID | NUMC | 8 | Assigned to domain | HROBJID | |||
CON_ID | Contingent Key | /ISDFPS/CON_ID | CHAR | 5 | /ISDFPS/CON_ID | ||||
OBJID_COM | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
PROVIDER_MAT | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON | ||
PROVIDER_PER | Object ID | HROBJID | NUMC | 8 | Assigned to domain | HROBJID | PON |
Key field | Non-key field |
How do I retrieve data from SAP structure MCCOMVTTS using ABAP code?
As MCCOMVTTS 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 MCCOMVTTS as there is no data to select.How to access SAP table MCCOMVTTS
Within an ECC or HANA version of SAP you can also view further information about MCCOMVTTS 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