A066 is a standard SAP table in SAP ECC (or) S/4HANA which stores Info record per order unit data. There are total 11 fields in A066 table.This blog post provides key technical details of SAP table A066, including its availability across SAP S/4HANA versions and the list of CDS views for A066 table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Full table is passed to buffer |
| Package | Application development Conditions (VKON) |
| Technical Component | Conditions (SD-MD-CM) |
SAP A066 Table Fields
The following is the list of fields that are available in SAP A066 table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| KAPPL | Application | KAPPL | KAPPL | T681A | CHAR (2) |
| KSCHL | Condition type | KSCHA | KSCHL | T685 | CHAR (4) |
| LIFNR | Vendor’s account number | ELIFN | LIFNR | LFA1 | CHAR (10) |
| MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| EKORG | Purchasing organization | EKORG | EKORG | T024E | CHAR (4) |
| ESOKZ | Purchasing info record category | ESOKZ | ESOKZ | CHAR (1) | |
| BSTME | Purchase Order Unit of Measure | BSTME | MEINS | T006 | UNIT (3) |
| DATBI | Validity end date of the condition record | KODATBI | DATUM | DATS (8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATUM | DATS (8) | |
| KNUMH | Number of the Condition Record | KNUMH | KNUMH | CHAR (10) |
Availability
The SAP table A066 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for A066 table
The following is the list of A066 CDS views, which can also be used instead of A066 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_PURINFORECDORDERUNITPRCGCNDN | BASIC | Purch Info Record Order Unit Cond |
| A_PURINFORECDPRCGCNDNVALIDITY | COMPOSITE | Pricing Condition Validity |
| I_PURINFORECDPRCGCNDNVALIDITY | COMPOSITE | Purch Info Record Cond Validity |
