SAP ATP_RESULT_DTAIL Information about the item details of the ATP check Table

Overview

ATP_RESULT_DTAIL is a standard SAP S/4HANA table that stores Information about the item details of the ATP check data. There are total 14 fields in the ATP_RESULT_DTAIL table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ATP_RESULT_DTAIL belongs to Available to Promise (ATP) (CA-ATP) module and is located in the package ATP Result (ATP_RESULT).

In addition, following links provide an overview of foreign key relationships, if any, that link ATP_RESULT_DTAIL to other SAP tables and standard CDS views available based on ATP_RESULT_DTAIL table in S/4HANA 2020.

Techincal Settings of ATP_RESULT_DTAIL

Below are technical details of the table ATP_RESULT_DTAIL

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of ATP_RESULT_DTAIL Fields

The following table gives you an overview of the fields available in ATP_RESULT_DTAIL

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTCLNT3
CIDCheck IDATP_CIDRAW16
DELNRMRP element numberDELNRCHAR10
DELPSMRP element itemDELPSNUMC6
DELETSchedule Line Number MRP ElementDELETNUMC4
ATPCATMRP elementDELKZCHAR2
ITEM_TYPEType of the itemATP_ITEM_TYPECHAR1
RESINDResult indicator for item detailATP_RESULT_DETAIL_RESINDCHAR2
ATPDATEMaterial Staging/Availability DateMBDATDATS8
REQQTYOpen Qty in Stockkeeping Units for Transfer of Reqmts to MRPOMENGQUAN15
CNFQTYConfirmed quantity for availability check in SKUVMENGQUAN15
AVAILABLE_QTYATP Server: ATP quantityATPMNGQUAN15
BASE_UOMBase Unit of MeasureMEINSUNIT3
REASON_CODEReason Code in the context of ATP ResultATP_REASON_CODECHAR3

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ATP_RESULT_DTAIL

Other References