A407 table in SAP ERP or S/4HANA stores Route, Loading Point, Discharge Point data. There are total 9 fields in A407 table. The Route, Loading Point, Discharge Point table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of A407 table. It is in TD Transport and Distribution (OIG) ABAP package and is part of the Transportation and Distribution (IS-OIL-DS-TD) module.
SAP A407 Table Fields
Following is the list of fields that are available in SAP A407 table. The primary key fields of Route, Loading Point, Discharge Point table in SAP are MANDT (Client), KAPPL (Application), KSCHL (Condition type), OIGROUTEV (TD-F vehicle route), OIGKNOTL (TD-F – loading point), OIGKNOTD (TD-F – discharge point), DATBI (Validity end date of the condition record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| KAPPL | Application | KAPPL | T681A | CHAR(2) |
| KSCHL | Condition type | KSCHA | T685 | CHAR(4) |
| OIGROUTEV | TD-F vehicle route | OIG_ROUTEV | TVRO | CHAR(6) |
| OIGKNOTL | TD-F – loading point | OIG_KNOTL | TVKN | CHAR(10) |
| OIGKNOTD | TD-F – discharge point | OIG_KNOTD | TVKN | CHAR(10) |
| DATBI | Validity end date of the condition record | KODATBI | DATS(8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATS(8) | |
| KNUMH | Number of the Condition Record | KNUMH | CHAR(10) |
