Sunday, May 19, 2024

SAP Table AUSB – Plant Status Table

AUSB is a standard SAP table in SAP ERP (or) S/4HANA which stores Plant Status Table data. There are total 13 fields in AUSB table.This blog post provides key technical details of SAP table AUSB, including its availability across SAP S/4HANA versions and the list of CDS views for AUSB table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Application development R/3 Purchasing, Allocation table (WAUF)
Technical Component Allocation (LO-RFM-PUR-AL)

SAP AUSB Table Fields

The following is the list of fields that are available in SAP AUSB table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
ABELN Allocation Table ABELN ABELN * CHAR (10)
ABELP Allocation Table Item ABELP ABELP * NUMC (5)
ABELG Store Group of an Allocation Table ABELG ABELG * NUMC (5)
ABELF Identifier of a Recipient of an Item of an Allocation Table ABELF ABELF * NUMC (5)
ABFST Status plant notification ABFST ASTAB CHAR (1)
ABAST Details status, plant notification ABAST ABAST CHAR (1)
BSTST Supplier Purchase Order Generation BSTST ASTAB CHAR (1)
UMLST Status: warehouse order generation UMLST ASTAB CHAR (1)
LIEST Status: generate deliveries LIEST ASTAB CHAR (1)
ABVST Notification status (DC) ABVST ASTAB CHAR (1)
WEEST Entry status of GR in DC WEEST ASTAB CHAR (1)
KAGST Status of sales order generation KAGST ASTAB CHAR (1)

Availability

The SAP table AUSB 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 AUSB table

The following is the list of AUSB CDS views, which can also be used instead of AUSB table based on your business requirements.

CDS View CDS View Type Description
I_ALLOCATIONTABLEITEMRCPNTSTS BASIC Allocation Table Recipient Status
I_ALLOCTABLEWITHSUBSQNTDOCS COMPOSITE Allocation Table with Subsequent Documents
I_ALLOCTBLITEMWITHSUBSQNTDOCS COMPOSITE Allocation Table Item with Subsequent Documents
C_ALLOCATIONTABLEITEMOBJPG CONSUMPTION Allocation Table Item Object Page
C_ALLOCATIONTABLEOBJPG CONSUMPTION Allocation Table Object Page
C_ALLOCTBLITEMOBJPGVARIANT CONSUMPTION Allocation Table Item Object Page – Variants