A304 is a standard SAP table in SAP ERP (or) S/4HANA which stores Material with release status data. There are total 11 fields in A304 table.This blog post provides key technical details of SAP table A304, including its availability across SAP S/4HANA versions and the list of CDS views for A304 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 A304 Table Fields
The following is the list of fields that are available in SAP A304 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) |
| VKORG | Sales Organization | VKORG | VKORG | TVKO | CHAR (4) |
| VTWEG | Distribution Channel | VTWEG | VTWEG | TVTW | CHAR (2) |
| MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| KFRST | Release Status | KFRST | KFRST | CHAR (1) | |
| DATBI | Validity end date of the condition record | KODATBI | DATUM | DATS (8) | |
| DATAB | Validity start date of the condition record | KODATAB | DATUM | DATS (8) | |
| KBSTAT | Processing status for conditions | KBSTAT | KBSTAT | T686E | CHAR (2) |
| KNUMH | Number of the Condition Record | KNUMH | KNUMH | CHAR (10) |
Availability
The SAP table A304 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 A304 table
The following is the list of A304 CDS views, which can also be used instead of A304 table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| P_CUSTOMERAVGQUANTITY | BASIC | Average Quantity for Customer |
| P_CUSTOMERORDER | BASIC | Customer and Order information |
| P_MATERIALINFO | BASIC | Material Info Stock Champion |
| I_CUSTOMERORDERS | COMPOSITE | Customer and Order information |
| P_BATCHINFO | COMPOSITE | Batch detail table |
