PASQNC

Transparent Table Application Table
15 Fields 2 CDS Views

Product Allocation Sequence

PASQNC is an SAP database table in S/4HANA. Product Allocation Sequence. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ProductAllocationSequence view from EXTENSION Product Allocation Sequence - Extension
I_ProductAllocationSequence view from BASIC Product Allocation Sequence

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY productallocationsequenceuuid productallocationsequenceuuid Product Allocation Sequence UUID
productallocationsequence productallocationsequence Allocation Sequence
numberofbackwardcnsmpnperiods numberofbackwardcnsmpnperiods Backward Consumption
numberofforwardcnsmpnperiods numberofforwardcnsmpnperiods Forward Consumption
horizontalconsumptiondirection horizontalconsumptiondirection Consumption Direction
verticalconsumptiondirection verticalconsumptiondirection Vertical Consumption
pastperiodisallowed pastperiodisallowed Past Period Allowed
prodallocsqncconsumptionunit prodallocsqncconsumptionunit Consumption Unit
prodallocconsistencystatus prodallocconsistencystatus Consistency Status
prodallocationlifecyclestatus prodallocationlifecyclestatus Lifecycle Status
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

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
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNC (
    CLIENT,                          -- Client [mandt]
    PRODUCTALLOCATIONSEQUENCEUUID,   -- Product Allocation Sequence UUID [productallocationsequenceuuid]
    PRODUCTALLOCATIONSEQUENCE,       -- Allocation Sequence [productallocationsequence]
    NUMBEROFBACKWARDCNSMPNPERIODS,   -- Backward Consumption [numberofbackwardcnsmpnperiods]
    NUMBEROFFORWARDCNSMPNPERIODS,    -- Forward Consumption [numberofforwardcnsmpnperiods]
    HORIZONTALCONSUMPTIONDIRECTION,  -- Consumption Direction [horizontalconsumptiondirection]
    VERTICALCONSUMPTIONDIRECTION,    -- Vertical Consumption [verticalconsumptiondirection]
    PASTPERIODISALLOWED,             -- Past Period Allowed [pastperiodisallowed]
    PRODALLOCSQNCCONSUMPTIONUNIT,    -- Consumption Unit [prodallocsqncconsumptionunit]
    PRODALLOCCONSISTENCYSTATUS,      -- Consistency Status [prodallocconsistencystatus]
    PRODALLOCATIONLIFECYCLESTATUS,   -- Lifecycle Status [prodallocationlifecyclestatus]
    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]
    PRIMARY KEY (CLIENT, PRODUCTALLOCATIONSEQUENCEUUID)
);

Learn More