SAP Table TTDS

Organizational Unit: Transportation Scheduling Point

TTDS (Organizational Unit: Transportation Scheduling Point) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TTDS to other SAP tables.

TTDS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TPLST Transportation planning point TPLST CHAR 4 0
FABKL Factory calendar key FABKL TFACD CHAR 2 0
ADRNR Address ADRNR CHAR 10 0
TPSID ID for external transport system TPSID TQCOM CHAR 5 0
VTPARN Partner number of external transportation planning system EDI_VTPARN CHAR 10 0
VTPART Partner type of external transportation planning system EDI_VTPART CHAR 2 0
KSCHL Output type for transportation planning systems NA_KSCHL_T T685 CHAR 4 0
NKETP External no.range for external transporation planning system NKETP CHAR 2 0
TRAEND Controlling for changes to externally planned shipments TRAEND CHAR 2 0
00 No restrictions for changes
01 No change relevant to planning; only the service agent
02 No change relevant to planning allowed
STTRG Overall status of a shipment for which plan. end is set STTRG_TPS CHAR 1 0
0 Planned
1 Planning completed
2 Check-in
3 Loading start
4 Loading end
5 Shipment completion
6 Shipment start
7 Shipment end
TPSSF Status filtering mode for TPS TPSSF CHAR 1 0
NULL No confirmation to TPS
1 Error message to TPS
2 Error and Success message to TPS
TPSTX1 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
TPSTX2 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
TPSTX3 Delivery header text ID for transferral to ext. trans.pl.sys VTPS_LFTX CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
STAGEW Weight unit for statistics update STAGEW T006 UNIT 3 0
STAVOL Volume unit for statistics update STAVOL T006 UNIT 3 0
STADIS Distance unit for statistics update STADIS T006 UNIT 3 0
STACUR Currency Unit for Statistical Update STACUR TCURC CUKY 5 0

TTDS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TTDS BUKRS TTDS BUKRS T001 Company Codes BUKRS
TTDS BUKRS TTDS MANDT T001 Company Codes MANDT
TTDS FABKL TTDS FABKL TFACD Factory calendar definition IDENT
TTDS KSCHL TTDS KSCHL T685 Conditions: Types KSCHL
TTDS KSCHL TTDS MANDT T685 Conditions: Types MANDT
TTDS KSCHL 'B' T685 Conditions: Types KVEWE
TTDS KSCHL 'V2' T685 Conditions: Types KAPPL
TTDS MANDT TTDS MANDT T000 Clients MANDT
TTDS STACUR TTDS MANDT TCURC Currency Codes MANDT
TTDS STACUR TTDS STACUR TCURC Currency Codes WAERS
TTDS STADIS TTDS MANDT T006 Units of Measurement MANDT
TTDS STADIS TTDS STADIS T006 Units of Measurement MSEHI
TTDS STAGEW TTDS MANDT T006 Units of Measurement MANDT
TTDS STAGEW TTDS STAGEW T006 Units of Measurement MSEHI
TTDS STAVOL TTDS MANDT T006 Units of Measurement MANDT
TTDS STAVOL TTDS STAVOL T006 Units of Measurement MSEHI
TTDS TPSID TTDS TPSID TQCOM Assignment of Communication No. to Logical Queue ID (APPQ) COMMN