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