PASQNC_CSTRT

Transparent Table Application Table
25 Fields 1 CDS Views

Product Allocation Sequence Constraint

PASQNC_CSTRT is an SAP database table in S/4HANA. Product Allocation Sequence Constraint. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocSequenceConstraint view from BASIC Product Allocation Sequence Constraint

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY prodallocsqncconstraintuuid prodallocsqncconstraintuuid Product Allocation Sequence Constraint UUID
prodallocsequenceconstraint prodallocsequenceconstraint Sequence Constraint
prodallocsequencegroupuuid prodallocsequencegroupuuid Product Allocation Sequence Group UUID
productallocationsequenceuuid productallocationsequenceuuid Product Allocation Sequence UUID
productallocationsequencegroup productallocationsequencegroup Sequence Group
productallocationsequence productallocationsequence Allocation Sequence
productallocationobjectuuid productallocationobjectuuid Product Allocation Object UUID
validitystartutcdatetime validitystartutcdatetime Validity Start
validitystarttimezone validitystarttimezone Validity Start Time Zone
validityendutcdatetime validityendutcdatetime Validity End
validityendtimezone validityendtimezone Validity End Time Zone
numberofbackwardcnsmpnperiods numberofbackwardcnsmpnperiods Backward Consumption
numberofforwardcnsmpnperiods numberofforwardcnsmpnperiods Forward Consumption
horizontalconsumptiondirection horizontalconsumptiondirection Consumption Direction
pastperiodisallowed pastperiodisallowed Past Period Allowed
prodallocleadtimeduration prodallocleadtimeduration Lead Time Duration
prodallocleadtimedurationunit prodallocleadtimedurationunit Lead Time Duration Unit
prodallocationconstraintstatus prodallocationconstraintstatus Constraint Status
aftervalidityconstraintstatus aftervalidityconstraintstatus After Validity Status
beforevalidityconstraintstatus beforevalidityconstraintstatus Before Valdty Status
productallocationrate productallocationrate Allocation Rate
prodalloccheckdatetimetype prodalloccheckdatetimetype Check Date Time Type
isdeleted lkenz Deletion Ind.
prodallocsqnccstrtcnsmpnunit prodallocsqnccstrtcnsmpnunit Constraint 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 Constraint
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNC_CSTRT (
    CLIENT,                          -- Client [mandt]
    PRODALLOCSQNCCONSTRAINTUUID,     -- Product Allocation Sequence Constraint UUID [prodallocsqncconstraintuuid]
    PRODALLOCSEQUENCECONSTRAINT,     -- Sequence Constraint [prodallocsequenceconstraint]
    PRODALLOCSEQUENCEGROUPUUID,      -- Product Allocation Sequence Group UUID [prodallocsequencegroupuuid]
    PRODUCTALLOCATIONSEQUENCEUUID,   -- Product Allocation Sequence UUID [productallocationsequenceuuid]
    PRODUCTALLOCATIONSEQUENCEGROUP,  -- Sequence Group [productallocationsequencegroup]
    PRODUCTALLOCATIONSEQUENCE,       -- Allocation Sequence [productallocationsequence]
    PRODUCTALLOCATIONOBJECTUUID,     -- Product Allocation Object UUID [productallocationobjectuuid]
    VALIDITYSTARTUTCDATETIME,        -- Validity Start [validitystartutcdatetime]
    VALIDITYSTARTTIMEZONE,           -- Validity Start Time Zone [validitystarttimezone]
    VALIDITYENDUTCDATETIME,          -- Validity End [validityendutcdatetime]
    VALIDITYENDTIMEZONE,             -- Validity End Time Zone [validityendtimezone]
    NUMBEROFBACKWARDCNSMPNPERIODS,   -- Backward Consumption [numberofbackwardcnsmpnperiods]
    NUMBEROFFORWARDCNSMPNPERIODS,    -- Forward Consumption [numberofforwardcnsmpnperiods]
    HORIZONTALCONSUMPTIONDIRECTION,  -- Consumption Direction [horizontalconsumptiondirection]
    PASTPERIODISALLOWED,             -- Past Period Allowed [pastperiodisallowed]
    PRODALLOCLEADTIMEDURATION,       -- Lead Time Duration [prodallocleadtimeduration]
    PRODALLOCLEADTIMEDURATIONUNIT,   -- Lead Time Duration Unit [prodallocleadtimedurationunit]
    PRODALLOCATIONCONSTRAINTSTATUS,  -- Constraint Status [prodallocationconstraintstatus]
    AFTERVALIDITYCONSTRAINTSTATUS,   -- After Validity Status [aftervalidityconstraintstatus]
    BEFOREVALIDITYCONSTRAINTSTATUS,  -- Before Valdty Status [beforevalidityconstraintstatus]
    PRODUCTALLOCATIONRATE,           -- Allocation Rate [productallocationrate]
    PRODALLOCCHECKDATETIMETYPE,      -- Check Date Time Type [prodalloccheckdatetimetype]
    ISDELETED,                       -- Deletion Ind. [lkenz]
    PRODALLOCSQNCCSTRTCNSMPNUNIT,    -- Constraint Consumption Unit [prodallocsqnccstrtcnsmpnunit]
    PRIMARY KEY (CLIENT, PRODALLOCSQNCCONSTRAINTUUID)
);

Learn More