Appendix A
Tables/Columns for Shipping Emissions Reduction App (in addition to existing tables of the standard O2C data connector)
Table | Column | Description | Possible values |
|---|---|---|---|
VTTS | |||
VTTS | MANDT | Client | |
VTTS | TKNUM | Shipment Number | |
VTTS | TSNUM | Stage of transport number | |
VTTS | TSTYP | Stage category | |
VTTS | TSRFO | Stage of transport sequence | |
VTTS | ERDAT | Date on Which Record Was Created | |
VTTS | ERZET | Entry time | |
VTTS | VSART | Shipping type for shipment stage | |
VTTS | INC01 | Incoterms for printout | |
VTTS | LAUFK | Leg indicator for shipment stage | 1 - Preliminary leg 2 - Main leg 3 - Subsequent leg 4 - Direct leg 5 - Return leg |
VTTS | VSTEL | Shipping point at point of departure | |
VTTS | LSTEL | Point of departure: Loading point at shipping point | |
VTTS | KUNNA | Departure point: Customer | |
VTTS | ADRNZ | Destination address | |
VTTS | KUNNZ | Customer number for destination point | |
VTTS | DATEN | Stage: Actual Date for End of Shipment | |
VTTS | TDLNR | Number of forwarding agent in the shipment stage | |
VTTS | LGNUMA | Point of departure: Warehouse number | |
VTTS | ADRKNZA | Point of departure: Origin indicator of address | A - Address from master data (SADR, ADRC, KNA1, LFA1) B - Address entered manually in current document (ADRC) C - Address entered manually in preceding document (SADR) D - Address entered manually in preceding document (SADR) |
VTTS | ADRKNZZ | Destination: Origin indicator of address | A - Address from master data (SADR, ADRC, KNA1, LFA1) B - Address entered manually in current document (ADRC) C - Address entered manually in preceding document (SADR) D - Address entered manually in preceding document (ADRC) |
VTTS | KUNABLZ | Destination: Customer's unloading point | |
VTTS | ABLAND1 | Country of departure | |
VTTS | ABPSTLZ | Departure postal code | |
VTTS | ABORT01 | Point of departure | |
VTTS | EDLAND1 | Destination Country | |
VTTS | EDPSTLZ | Destination Postal Code | |
VTTS | EDORT01 | Destination | |
VTSP | |||
VTSP | MANDT | Client | |
VTSP | TKNUM | Shipment Number | |
VTSP | TSNUM | Stage of transport number | |
VTSP | TPNUM | Shipment item | |
VTTP | |||
VTTP | MANDT | Client | |
VTTP | TKNUM | Shipment Number | |
VTTP | TPNUM | Shipment item | |
VTTP | VBELN | Delivery | |
VTTP | TPRFO | Itinerary of shipment items | |
VTTP | ERDAT | Date on Which Record Was Created | |
VTTP | ERZET | Entry time | |
VTTK | |||
VTTK | MANDT | Client | |
VTTK | TKNUM | Shipment Number | |
VTTK | VBTYP | SD document category | |
VTTK | SHTYP | Shipment type | |
VTTK | TPLST | Transportation planning point | |
VTTK | ERDAT | Date on Which Record Was Created | |
VTTK | ERZET | Entry time | |
VTTK | STERM | Leg determination | NULL - No legs to be determined 0 - Only determine assignment of deliveries to stages 1 - Legs determined according to departure point & itinerary 2 - Prelim.leg per loading point, subsequent leg per ship-to pty 3 - Determine preliminary and subsequent leg by delivery note 4 - As 1, but ship. type for prel. and subs. legs changeable |
VTTK | ABFER | Shipment completion type | 1 - Loaded outbound shipment 2 - Loaded inbound shipment 3 - Empty outbound shipment 4 - Empty inbound shipment |
VTTK | ABWST | Processing control | 1 - Individual shipment using one mode of transport 2 - Individual shipment using several modes of transport 3 - Collective shipment using one mode of transport 4 - Collective shipment using several modes of transport |
VTTK | BFART | Service Level | 1 - Load 2 - General cargo 3 - Groupage 4 - Express |
VSAVL | Shipping type of preliminary leg | ||
VTTK | VSANL | Shipping type of subsequent leg | |
VTTK | LAUFK | Leg Indicator | 1 - Preliminary leg 2 - Main leg 3 - Subsequent leg 4 - Direct leg 5 - Return leg |
VTTK | VSBED | Shipping Conditions | |
VTTK | STDIS | Status of transportation planning | NULL Not completed X Completed |
VTTK | DTDIS | Date of end of planning | |
VTTK | UZDIS | Scheduling end time | |
VTTK | STREG | Status of check-in | NULL Not completed X Completed |
VTTK | DPREG | Planned date of check-in | |
VTTK | UPREG | Planned check-in time | |
VTTK | DAREG | Actual date of check-in | |
VTTK | UAREG | Current time of check-in | |
VTTK | STLBG | Status for start of loading | NULL Not completed X Completed |
VTTK | DPLBG | Planned date for start of loading | |
VTTK | UPLBG | Planned loading start time | |
VTTK | DALBG | Current date for start of loading | |
VTTK | UALBG | Actual loading start time | |
VTTK | STLAD | Status for end of loading | NULL Not completed X Completed |
VTTK | DALEN | Actual date for end of loading | |
VTTK | UALEN | Actual loading end time | |
VTTK | STABF | Status of shipment completion | NULL Not completed X Completed |
VTTK | DTABF | Current date of shipment completion | |
VTTK | UZABF | Time of transportation processing | |
VTTK | STTBG | Status for start of shipment | NULL Not completed X Completed |
VTTK | DATEN | Actual Date for End of Shipment | |
VTTK | UATEN | Actual shipment end time | |
VTTK | STTRG | Overall transportation status | 0 - Planned 1 - Planning completed 2 - Check-in 3 - Loading start 4 - Loading end 5 - Shipment completion 6 - Shipment start 7 - Shipment end |
VTTK | TDLNR | Number of forwarding agent | |
T173T | |||
T173T | MANDT | Client | |
T173T | SPRAS | Language Key | |
T173T | VSART | Shipping type | |
T173T | BEZEI | Description of the Shipping Type | |
T001W | |||
T001W | MANDT | Client | |
T001W | WERKS | Plant | |
T001W | NAME1 | Name | |
T001W | LAND1 | Country Key | |
T001W | PSTLZ | Postal Code | |
T001W | ORT01 | City | |