PATQA

Transparent Table Application Table
22 Fields 1 CDS Views

Product Allocation Temporary Quantity Assignment

PATQA is an SAP database table in S/4HANA. Product Allocation Temporary Quantity Assignment. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocTmpQtyAssignment view from BASIC Product Allocation Temporary Quantity Assignment

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY prodallocassignedorder PRODALLOCASSIGNEDORDER Assigned Order
KEY prodallocassignedorderitem PRODALLOCASSIGNEDORDERITEM Assigned Order Item
KEY prodallocassignedordertype PRODALLOCASSIGNEDORDERTYPE Order Type
KEY charcvaluecombinationuuid CHARCVALUECOMBINATIONUUID Characteristic Value Combination UUID
KEY prodallocperdstartutcdatetime PERIODSTARTUTCDATETIME Period Start Date Time
KEY confirmationutcdatetime CONFIRMATIONUTCDATETIME Confirmation Date Time
KEY transactionuuid ATP_CID Check ID
KEY assignmentsequencenumbervalue ASSIGNMENTSEQUENCENUMBERVALUE Assignment Sequence Number
KEY enqueuemode XENQMD ATP Server: mode for exclusive locking
prodallocperiodstarttimezone PERIODSTARTTIMEZONE Period Start Time Zone
confirmationtimezone CONFIRMATIONTIMEZONE Confirmation Time Zone
prodallocperiodendutcdatetime PERIODENDUTCDATETIME Period End Date Time
prodallocperiodendtimezone PERIODENDTIMEZONE Period End Time Zone
prodallocassignedquantity PRODALLOCASSIGNEDQUANTITY Assigned Quantity
prodallocassignedquantityunit PRODALLOCASSIGNEDQUANTITYUNIT Assigned Quantity Unit
prodallocsqncconstraintuuid PRODALLOCSQNCCONSTRAINTUUID Product Allocation Sequence Constraint UUID
confirmationdatetimetype CONFIRMATIONDATETIMETYPE Confirmation Date Type
tmpqtyassgmtexpirydatetime TMPQTYASSGMTEXPIRYDATETIME TQA Expiry Date Time
creationdatetime PAL_CREATIONDATETIME Creation Date Time
createdbyuser PAL_CREATEDBYUSER Created by User
isreactivationrelevant BOOLE_D TRUE

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.

-- Product Allocation Temporary Quantity Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PATQA (
    CLIENT,                         -- Client [MANDT]
    PRODALLOCASSIGNEDORDER,         -- Assigned Order [PRODALLOCASSIGNEDORDER]
    PRODALLOCASSIGNEDORDERITEM,     -- Assigned Order Item [PRODALLOCASSIGNEDORDERITEM]
    PRODALLOCASSIGNEDORDERTYPE,     -- Order Type [PRODALLOCASSIGNEDORDERTYPE]
    CHARCVALUECOMBINATIONUUID,      -- Characteristic Value Combination UUID [CHARCVALUECOMBINATIONUUID]
    PRODALLOCPERDSTARTUTCDATETIME,  -- Period Start Date Time [PERIODSTARTUTCDATETIME]
    CONFIRMATIONUTCDATETIME,        -- Confirmation Date Time [CONFIRMATIONUTCDATETIME]
    TRANSACTIONUUID,                -- Check ID [ATP_CID]
    ASSIGNMENTSEQUENCENUMBERVALUE,  -- Assignment Sequence Number [ASSIGNMENTSEQUENCENUMBERVALUE]
    ENQUEUEMODE,                    -- ATP Server: mode for exclusive locking [XENQMD]
    PRODALLOCPERIODSTARTTIMEZONE,   -- Period Start Time Zone [PERIODSTARTTIMEZONE]
    CONFIRMATIONTIMEZONE,           -- Confirmation Time Zone [CONFIRMATIONTIMEZONE]
    PRODALLOCPERIODENDUTCDATETIME,  -- Period End Date Time [PERIODENDUTCDATETIME]
    PRODALLOCPERIODENDTIMEZONE,     -- Period End Time Zone [PERIODENDTIMEZONE]
    PRODALLOCASSIGNEDQUANTITY,      -- Assigned Quantity [PRODALLOCASSIGNEDQUANTITY]
    PRODALLOCASSIGNEDQUANTITYUNIT,  -- Assigned Quantity Unit [PRODALLOCASSIGNEDQUANTITYUNIT]
    PRODALLOCSQNCCONSTRAINTUUID,    -- Product Allocation Sequence Constraint UUID [PRODALLOCSQNCCONSTRAINTUUID]
    CONFIRMATIONDATETIMETYPE,       -- Confirmation Date Type [CONFIRMATIONDATETIMETYPE]
    TMPQTYASSGMTEXPIRYDATETIME,     -- TQA Expiry Date Time [TMPQTYASSGMTEXPIRYDATETIME]
    CREATIONDATETIME,               -- Creation Date Time [PAL_CREATIONDATETIME]
    CREATEDBYUSER,                  -- Created by User [PAL_CREATEDBYUSER]
    ISREACTIVATIONRELEVANT,         -- TRUE [BOOLE_D]
    PRIMARY KEY (CLIENT, PRODALLOCASSIGNEDORDER, PRODALLOCASSIGNEDORDERITEM, PRODALLOCASSIGNEDORDERTYPE, CHARCVALUECOMBINATIONUUID, PRODALLOCPERDSTARTUTCDATETIME, CONFIRMATIONUTCDATETIME, TRANSACTIONUUID, ASSIGNMENTSEQUENCENUMBERVALUE, ENQUEUEMODE)
);

Learn More