PASQNCD

Transparent Table Application Table
26 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 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SDMProdAllocRAIMigration view_entity union_all COMPOSITE

Fields (26)

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
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityconsistencystatus abap.char
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
pasqnc_incl_eew_ps PAL_DUMMY PAL Dummy

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]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYCONSISTENCYSTATUS,    -- abap.char
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PASQNC_INCL_EEW_PS,              -- PAL Dummy [PAL_DUMMY]
    PRIMARY KEY (MANDT, PRODUCTALLOCATIONSEQUENCEUUID)
);

Learn More