Monday, May 27, 2024

SAP Table ACMTST_DB_SO – ACMTST: Sales Order Header (DB-Table)

ACMTST_DB_SO is a standard SAP table in SAP ECC (or) S/4HANA which stores ACMTST: Sales Order Header (DB-Table) data. There are total 10 fields in ACMTST_DB_SO table.This blog post provides key technical details of SAP table ACMTST_DB_SO, including its availability across SAP S/4HANA versions and the list of CDS views for ACMTST_DB_SO table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Objects for Testing the ACM functionality (SACMTST)
Technical Component Data Control Language (DCL) (Define Authorizations for CDS) (BC-SEC-AUT-DCL)

SAP ACMTST_DB_SO Table Fields

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

Field Description Data Element Domain Check Table Data Type
CLIENT Client MANDT MANDT T000 CLNT (3)
UUID ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID RAW (16)
CREATED_BY ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID ACMTST_DB_EMPL RAW (16)
CREATED_AT UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL TZNTSTMPL DEC (21)
CHANGED_BY ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID ACMTST_DB_EMPL RAW (16)
CHANGED_AT UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL TZNTSTMPL DEC (21)
CUSTOMER_UUID ACMTST: Globally unique-ID – PrimaryKey of all ACMTST-Tables ACMTST_ID ACM_ID ACMTST_DB_BPA RAW (16)
LIFECYCLE_STATUS ACMTST: SalesOrder Lifecycle Status ACMTST_SO_LC_STATUS ACMTST_SO_LC_STATUS CHAR (1)
BILLING_STATUS ACMTST: SalesOrder Confirmation Status ACMTST_SO_CF_STATUS ACMTST_SO_CF_STATUS CHAR (1)
DELIVERY_STATUS ACMTST: SalesOrder Ordering Status ACMTST_SO_OR_STATUS ACMTST_SO_OR_STATUS CHAR (1)

Availability

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

There are no CDS views available in the system. We’re updating the content all the time, so check back regularly.