PASQNCD

Transparent Table Application Table
18 Fields 1 CDS Views

Draft table for entity I_PRODALLOCATIONSEQUENCETP

PASQNCD is an SAP database table in S/4HANA. Draft table for entity I_PRODALLOCATIONSEQUENCETP. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SDMProdAllocRAIMigration view_entity union_all COMPOSITE

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt 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
creationdate pal_creationdate Creation Date
createdbyuser pal_createdbyuser Created by User
lastchangedatetime pal_lastchangedatetime Last Change Date Time
lastchangedate pal_lastchangedate Last Change Date
lastchangedbyuser pal_lastchangedbyuser Last Changed by User
activeuuid /bobf/uuid Key

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.

-- Draft table for entity I_PRODALLOCATIONSEQUENCETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNCD (
    MANDT,                           -- 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]
    CREATIONDATE,                    -- Creation Date [pal_creationdate]
    CREATEDBYUSER,                   -- Created by User [pal_createdbyuser]
    LASTCHANGEDATETIME,              -- Last Change Date Time [pal_lastchangedatetime]
    LASTCHANGEDATE,                  -- Last Change Date [pal_lastchangedate]
    LASTCHANGEDBYUSER,               -- Last Changed by User [pal_lastchangedbyuser]
    ACTIVEUUID,                      -- Key [/bobf/uuid]
    PRIMARY KEY (MANDT, PRODUCTALLOCATIONSEQUENCEUUID)
);

Learn More