PASQNC_GRP

Transparent Table Application Table
14 Fields 1 CDS Views

Product Allocation Sequence Group

PASQNC_GRP is an SAP database table in S/4HANA. Product Allocation Sequence Group. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocationSequenceGroup view from BASIC Product Allocation Sequence Group

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY prodallocsequencegroupuuid prodallocsequencegroupuuid Product Allocation Sequence Group UUID
productallocationsequenceuuid productallocationsequenceuuid Product Allocation Sequence UUID
productallocationsequencegroup productallocationsequencegroup Sequence Group
productallocationsequence productallocationsequence Allocation Sequence
prodallocsequencegrouptype prodallocsequencegrouptype Sequence Group Type
prodallocsqncgrppriorityvalue prodallocsqncgrppriorityvalue Priority
numberofbackwardcnsmpnperiods numberofbackwardcnsmpnperiods Backward Consumption
numberofforwardcnsmpnperiods numberofforwardcnsmpnperiods Forward Consumption
horizontalconsumptiondirection horizontalconsumptiondirection Consumption Direction
pastperiodisallowed pastperiodisallowed Past Period Allowed
onlyoverlappingqtyisconsumed onlyoverlappingqtyisconsumed Consume Overlapping Quantity Only
isdeleted lkenz Deletion Ind.
prodallocsqncgrpcnsmpnunit prodallocsqncgrpcnsmpnunit Group Consumption Unit

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 Sequence Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNC_GRP (
    CLIENT,                          -- Client [mandt]
    PRODALLOCSEQUENCEGROUPUUID,      -- Product Allocation Sequence Group UUID [prodallocsequencegroupuuid]
    PRODUCTALLOCATIONSEQUENCEUUID,   -- Product Allocation Sequence UUID [productallocationsequenceuuid]
    PRODUCTALLOCATIONSEQUENCEGROUP,  -- Sequence Group [productallocationsequencegroup]
    PRODUCTALLOCATIONSEQUENCE,       -- Allocation Sequence [productallocationsequence]
    PRODALLOCSEQUENCEGROUPTYPE,      -- Sequence Group Type [prodallocsequencegrouptype]
    PRODALLOCSQNCGRPPRIORITYVALUE,   -- Priority [prodallocsqncgrppriorityvalue]
    NUMBEROFBACKWARDCNSMPNPERIODS,   -- Backward Consumption [numberofbackwardcnsmpnperiods]
    NUMBEROFFORWARDCNSMPNPERIODS,    -- Forward Consumption [numberofforwardcnsmpnperiods]
    HORIZONTALCONSUMPTIONDIRECTION,  -- Consumption Direction [horizontalconsumptiondirection]
    PASTPERIODISALLOWED,             -- Past Period Allowed [pastperiodisallowed]
    ONLYOVERLAPPINGQTYISCONSUMED,    -- Consume Overlapping Quantity Only [onlyoverlappingqtyisconsumed]
    ISDELETED,                       -- Deletion Ind. [lkenz]
    PRODALLOCSQNCGRPCNSMPNUNIT,      -- Group Consumption Unit [prodallocsqncgrpcnsmpnunit]
    PRIMARY KEY (CLIENT, PRODALLOCSEQUENCEGROUPUUID)
);

Learn More