Overview
ATP_RESULT_SCHED is a standard SAP S/4HANA table that stores Scheduling information of the item details of the ATP check data. There are total 27 fields in the ATP_RESULT_SCHED table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ATP_RESULT_SCHED 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_SCHED to other SAP tables and standard CDS views available based on ATP_RESULT_SCHED table in S/4HANA 2020.
Techincal Settings of ATP_RESULT_SCHED
Below are technical details of the table ATP_RESULT_SCHED
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ATP_RESULT_SCHED Fields
The following table gives you an overview of the fields available in ATP_RESULT_SCHED
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| MANDT | Client | MANDT | | CLNT | 3 |
| CID | Check ID | ATP_CID | | RAW | 16 |
| DELNR | MRP element number | DELNR | | CHAR | 10 |
| DELPS | MRP element item | DELPS | | NUMC | 6 |
| DELET | Schedule Line Number MRP Element | DELET | | NUMC | 4 |
| ATPCAT | MRP element | DELKZ | | CHAR | 2 |
| ITEM_TYPE | Type of the item | ATP_ITEM_TYPE | | CHAR | 1 |
| RESIND | Result indicator for item detail | ATP_RESULT_DETAIL_RESIND | | CHAR | 2 |
| ATPDATE | Material Staging/Availability Date | MBDAT | | DATS | 8 |
| MAT_AVAIL_DATE | Material Staging/Availability Date | MBDAT | | DATS | 8 |
| MAT_AVAIL_TIME | Material Staging Time (Local, Relating to a Plant) | MBUHR | | TIMS | 6 |
| MAT_AVAIL_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
| TRANS_DISPO_DATE | Transportation Planning Date | TDDAT_D | | DATS | 8 |
| TRANS_DISPO_TIME | Transp. Planning Time (Local, Relating to a Shipping Point) | TDUHR | | TIMS | 6 |
| TRANS_DISPO_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
| LOADING_DATE | Loading Date | LDDAT | | DATS | 8 |
| LOADING_TIME | Loading Time (Local Time Relating to a Shipping Point) | LDUHR | | TIMS | 6 |
| LOADING_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
| GOODS_ISSUE_DATE | Goods Issue Date | WADAT | | DATS | 8 |
| GOODS_ISSUE_TIME | Time of Goods Issue (Local, Relating to a Plant) | WAUHR | | TIMS | 6 |
| GOODS_ISSUE_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
| DELIVERY_DATE | Delivery date | LFDAT | | DATS | 8 |
| DELIVERY_TIME | Time of delivery | LFUHR | | TIMS | 6 |
| DELIVERY_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
| UNLOADING_DATE | Goods Receipt End Date | ELDAT | | DATS | 8 |
| UNLOADING_TIME | Goods Receipt End Time (Local, Relating to a Plant) | ELUHR | | TIMS | 6 |
| UNLOADING_TIMEZONE | Time Zone | TZNZONE | | CHAR | 6 |
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_SCHED
Other References