PAQTYASSGMT

Transparent Table Application Table
21 Fields 2 CDS Views

Product Allocation Quantity Assignment

PAQTYASSGMT is an SAP database table in S/4HANA. Product Allocation Quantity Assignment. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_ProdAllocQtyAssignmentDEX view_entity from BASIC Product Allocation Quantity Assignment
I_ProdAllocQuantityAssignment view from BASIC Product Allocation Quantity Assignment

Fields (21)

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 assignmentsequencenumbervalue assignmentsequencenumbervalue Assignment Sequence Number
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
confirmationdatetimetype confirmationdatetimetype Confirmation Date Type
prodallocsqncconstraintuuid prodallocsqncconstraintuuid Product Allocation Sequence Constraint UUID
creationdatetime pal_creationdatetime Creation Date Time
createdbyuser pal_createdbyuser Created by User
lastchangedatetime pal_lastchangedatetime Last Change Date Time
lastchangedbyuser pal_lastchangedbyuser Last Changed by User
_dataaging data_temperature Data Aging

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 Quantity Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PAQTYASSGMT (
    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]
    ASSIGNMENTSEQUENCENUMBERVALUE,  -- Assignment Sequence Number [assignmentsequencenumbervalue]
    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]
    CONFIRMATIONDATETIMETYPE,       -- Confirmation Date Type [confirmationdatetimetype]
    PRODALLOCSQNCCONSTRAINTUUID,    -- Product Allocation Sequence Constraint UUID [prodallocsqncconstraintuuid]
    CREATIONDATETIME,               -- Creation Date Time [pal_creationdatetime]
    CREATEDBYUSER,                  -- Created by User [pal_createdbyuser]
    LASTCHANGEDATETIME,             -- Last Change Date Time [pal_lastchangedatetime]
    LASTCHANGEDBYUSER,              -- Last Changed by User [pal_lastchangedbyuser]
    _DATAAGING,                     -- Data Aging [data_temperature]
    PRIMARY KEY (CLIENT, PRODALLOCASSIGNEDORDER, PRODALLOCASSIGNEDORDERITEM, PRODALLOCASSIGNEDORDERTYPE, CHARCVALUECOMBINATIONUUID, PRODALLOCPERDSTARTUTCDATETIME, CONFIRMATIONUTCDATETIME, ASSIGNMENTSEQUENCENUMBERVALUE)
);

Learn More