Skip to main content

Celonis Product Documentation

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

https://www.leanx.eu/en/sap/table/vttk.html

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