ATP_PAC_TQA

Transparent Table Temporary Data
10 Fields 1 CDS Views

Temporary Quantity Assigments for PAC

ATP_PAC_TQA is an SAP database table in S/4HANA. Temporary Quantity Assigments for PAC. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cds_atp_pac_tqa view from CDS view on PAC TQA tables

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY prodavailytmpqtyassgmtuuid atp_pac_tqa_uuid TQA UUID
atpcheckuuid atp_cid Check ID
productavailabilityutcdatetime atp_mat_availability_timestamp Availy Timestamp
productavailabilitytimezone timezone Time Zone
requestedquantityinbaseunit bs_atp_req_qty Requested Qty
confirmedquantityinbaseunit bs_atp_cnf_qty Confirmed Qty
baseunit unit Unit
creationutcdatetime atp_creation_timestamp Creation Timestamp
creationtimezone timezone Time Zone

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Temporary Quantity Assigments for PAC
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATP_PAC_TQA (
    MANDT,                           -- Client [mandt]
    PRODAVAILYTMPQTYASSGMTUUID,      -- TQA UUID [atp_pac_tqa_uuid]
    ATPCHECKUUID,                    -- Check ID [atp_cid]
    PRODUCTAVAILABILITYUTCDATETIME,  -- Availy Timestamp [atp_mat_availability_timestamp]
    PRODUCTAVAILABILITYTIMEZONE,     -- Time Zone [timezone]
    REQUESTEDQUANTITYINBASEUNIT,     -- Requested Qty [bs_atp_req_qty]
    CONFIRMEDQUANTITYINBASEUNIT,     -- Confirmed Qty [bs_atp_cnf_qty]
    BASEUNIT,                        -- Unit [unit]
    CREATIONUTCDATETIME,             -- Creation Timestamp [atp_creation_timestamp]
    CREATIONTIMEZONE,                -- Time Zone [timezone]
    PRIMARY KEY (MANDT, PRODAVAILYTMPQTYASSGMTUUID)
);

Learn More