back to top

SAP A109 Table – Vendor hierarchy: vendor sub-range

The A109 table in SAP ERP or S/4HANA stores Vendor hierarchy: vendor sub-range data. There are total 9 fields in A109 table. The Vendor hierarchy: vendor sub-range table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database.Additionally we provide an overview of the structure and fields of A109 table. It is in Application development Conditions (VKON) ABAP package and is part of the Conditions (SD-MD-CM) module.

SAP A109 Table Fields

Following is the list of fields that are available in SAP A109 table. The primary key fields of the table are MANDT (Client), KAPPL (Application), KSCHL (Condition type), EKORG (Purchasing organization), LHIENR (Vendor number of vendor hierarchy), LTSNR (Supplier Subrange), 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)
EKORG Purchasing organization EKORG T024E CHAR (4)
LHIENR Vendor number of vendor hierarchy LIFNR_LH LFA1 CHAR (10)
LTSNR Supplier Subrange LTSNR WYT1 CHAR (6)
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)