PASQNC_ASSGMT

Transparent Table Application Table
11 Fields 1 CDS Views

Product Allocation Sequence Assignment

PASQNC_ASSGMT is an SAP database table in S/4HANA. Product Allocation Sequence Assignment. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProdAllocSequenceAssignment view from BASIC Product Allocation Sequence Assignment

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY prodallocsqncassignmentuuid prodallocsqncassignmentuuid Product Allocation Sequence Assignment UUID
productallocationsequenceuuid productallocationsequenceuuid Product Allocation Sequence UUID
productallocationsequence productallocationsequence Allocation Sequence
material matnr Material
plant werks_d Plant
validitystartutcdatetime validitystartutcdatetime Validity Start
validitystarttimezone validitystarttimezone Validity Start Time Zone
validityendutcdatetime validityendutcdatetime Validity End
validityendtimezone validityendtimezone Validity End Time Zone
isdeleted lkenz Deletion Ind.

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 Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNC_ASSGMT (
    CLIENT,                         -- Client [mandt]
    PRODALLOCSQNCASSIGNMENTUUID,    -- Product Allocation Sequence Assignment UUID [prodallocsqncassignmentuuid]
    PRODUCTALLOCATIONSEQUENCEUUID,  -- Product Allocation Sequence UUID [productallocationsequenceuuid]
    PRODUCTALLOCATIONSEQUENCE,      -- Allocation Sequence [productallocationsequence]
    MATERIAL,                       -- Material [matnr]
    PLANT,                          -- Plant [werks_d]
    VALIDITYSTARTUTCDATETIME,       -- Validity Start [validitystartutcdatetime]
    VALIDITYSTARTTIMEZONE,          -- Validity Start Time Zone [validitystarttimezone]
    VALIDITYENDUTCDATETIME,         -- Validity End [validityendutcdatetime]
    VALIDITYENDTIMEZONE,            -- Validity End Time Zone [validityendtimezone]
    ISDELETED,                      -- Deletion Ind. [lkenz]
    PRIMARY KEY (CLIENT, PRODALLOCSQNCASSIGNMENTUUID)
);

Learn More