SAP table TTDS (Organizational Unit: Transportation Scheduling Point)

SAP table TTDS has 2 primary key fields being MANDT,TPLST.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TPLST Transportation planning point CHAR 4 0 TPLST
FABKL Factory calendar key CHAR 2 0 TFACD FABKL
ADRNR Address CHAR 10 0 * ADRNR
TPSID ID for External Transport System CHAR 5 0 TQCOM TPSID
VTPARN Partner number of external transportation planning system CHAR 10 0 * EDI_VTPARN
VTPART Partner type of external transportation planning system CHAR 2 0 * EDI_VTPART
KSCHL Output type for transportation planning systems CHAR 4 0 T685 NA_KSCHL_T
NKETP External no.range for external transporation planning system CHAR 2 0 NKETP
TRAEND Controlling for changes to externally planned shipments CHAR 2 0 TRAEND
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 CHAR 1 0 STTRG_TPS
TPSSF Status filtering mode for TPS CHAR 1 0 TPSSF
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 CHAR 4 0 * VTPS_LFTX
TPSTX2 Delivery header text ID for transferral to ext. trans.pl.sys CHAR 4 0 * VTPS_LFTX
TPSTX3 Delivery header text ID for transferral to ext. trans.pl.sys CHAR 4 0 * VTPS_LFTX
BUKRS Company Code CHAR 4 0 T001 BUKRS
STAGEW Weight unit for statistics update UNIT 3 0 T006 STAGEW
STAVOL Volume unit for statistics update UNIT 3 0 T006 STAVOL
STADIS Distance unit for statistics update UNIT 3 0 T006 STADIS
STACUR Currency Unit for Statistical Update CUKY 5 0 TCURC STACUR

TTDS foreign key relationships

Table Field Check Table Check Field
0 TTDS BUKRS T001 Company Codes BUKRS
1 TTDS KSCHL T685 Conditions: Types KAPPL
1 TTDS KSCHL T685 Conditions: Types KSCHL
0 TTDS STACUR TCURC Currency Codes MANDT
0 TTDS STACUR TCURC Currency Codes WAERS
1 TTDS STADIS T006 Units of Measurement MANDT
1 TTDS STADIS T006 Units of Measurement MSEHI
0 TTDS STAGEW T006 Units of Measurement MANDT
0 TTDS STAGEW T006 Units of Measurement MSEHI
1 TTDS STAVOL T006 Units of Measurement MANDT
1 TTDS STAVOL T006 Units of Measurement MSEHI