SAP ATP_TQA_PAC Temporary Quantity Assigments for PAC Table

Overview

ATP_TQA_PAC is a standard SAP S/4HANA table that stores Temporary Quantity Assigments for PAC data. There are total 24 fields in the ATP_TQA_PAC table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ATP_TQA_PAC belongs to ATP: Product Availability Check (CA-ATP-PAC) module and is located in the package ATP Product Availability Check (ATP_PAC).

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

Techincal Settings of ATP_TQA_PAC

Below are technical details of the table ATP_TQA_PAC

Buffering not allowed
No buffering
Storage type is Column Store

List of ATP_TQA_PAC Fields

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

Field	Description	Data Element	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
MATNR	Material Number	MATNR	CHAR	40
WERKS	Plant	WERKS_D	CHAR	4
LGORT	Storage location	LGORT_D	CHAR	4
CHARG	Batch Number	CHARG_D	CHAR	10
SGT_CATV	Segmentation Value	SGT_CATV	CHAR	40
SOBKZ	Special Stock Indicator	SOBKZ	CHAR	1
SSKEY	Key for Special Stock Segment	SSKEY_S4	CHAR	20
SSKEY_EXT	Extension for Key for Special Stock Segment	SSKEY_EXT	CHAR	6
ATPCAT	MRP element	DELKZ	CHAR	2
ATPCAT_SUCCESSOR	MRP element	DELKZ	CHAR	2
DELNR_SUCCESSOR	MRP element number	DELNR	CHAR	10
DELPS_SUCCESSOR	MRP element item	DELPS	NUMC	6
ATPDATE	Requirements date	DAT04	DATS	8
REQQTY	Open Qty in Stockkeeping Units for Transfer of Reqmts to MRP	OMENG	QUAN	15
CNFQTY	Confirmed quantity for availability check in SKU	VMENG	QUAN	15
VALTMS	Expiration Date of Temporary Quantity Assignments	TQA_DURTMS	DEC	15
UNAME	User Name	SYUNAME	CHAR	12
CREATION_TIME	Field of type TIMS	TIMS	TIMS	6
DELETE_AFTER_COMMIT	TQA PAC Lifecycle Handling - delete after commit	ATP_TQA_PAC_LCYC_DEL_ON_COMMIT	CHAR	1
ENQUEUE_CID	TQA PAC Lifecycle Handling - enqueue cid	ATP_TQA_PAC_LCYC_ENQUEUE_CID	CHAR	1

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_TQA_PAC

SAP ATP_TQA_PAC Temporary Quantity Assigments for PAC Table

Overview

Techincal Settings of ATP_TQA_PAC

List of ATP_TQA_PAC Fields

Foreign Key Relationships

Other References