ATP_PAC_TQA2DOC

Transparent Table Temporary Data
5 Fields 1 CDS Views

Many-Many Relationship betw. ATP_PAC_TQA and ATP_PAC_TQA_DOC

ATP_PAC_TQA2DOC is an SAP database table in S/4HANA. Many-Many Relationship betw. ATP_PAC_TQA and ATP_PAC_TQA_DOC. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cds_atp_pac_tqa view inner CDS view on PAC TQA tables

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY prodavailytmpqtyassgmtuuid ATP_PAC_TQA_UUID TQA UUID
KEY atprequirementuuid ATP_REQUIREMENT_UUID Requirement UUID
KEY atpsuccessorrqmtuuid ATP_REQUIREMENT_UUID Requirement UUID
atpcheckuuid ATP_CID Check ID

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.

-- Many-Many Relationship betw. ATP_PAC_TQA and ATP_PAC_TQA_DOC
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ATP_PAC_TQA2DOC (
    MANDT,                       -- Client [MANDT]
    PRODAVAILYTMPQTYASSGMTUUID,  -- TQA UUID [ATP_PAC_TQA_UUID]
    ATPREQUIREMENTUUID,          -- Requirement UUID [ATP_REQUIREMENT_UUID]
    ATPSUCCESSORRQMTUUID,        -- Requirement UUID [ATP_REQUIREMENT_UUID]
    ATPCHECKUUID,                -- Check ID [ATP_CID]
    PRIMARY KEY (MANDT, PRODAVAILYTMPQTYASSGMTUUID, ATPREQUIREMENTUUID, ATPSUCCESSORRQMTUUID)
);

Learn More