PASQNC_GRP
Product Allocation Sequence Group
PASQNC_GRP is an SAP database table in S/4HANA. Product Allocation Sequence Group. It contains 14 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdAllocationSequenceGroup | view | from | BASIC | Product Allocation Sequence Group |
Fields (14)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | prodallocsequencegroupuuid | PRODALLOCSEQUENCEGROUPUUID | Product Allocation Sequence Group UUID | |||
| productallocationsequenceuuid | PRODUCTALLOCATIONSEQUENCEUUID | Product Allocation Sequence UUID | ||||
| productallocationsequencegroup | PRODUCTALLOCATIONSEQUENCEGROUP | Sequence Group | ||||
| productallocationsequence | PRODUCTALLOCATIONSEQUENCE | Allocation Sequence | ||||
| prodallocsequencegrouptype | PRODALLOCSEQUENCEGROUPTYPE | Sequence Group Type | ||||
| prodallocsqncgrppriorityvalue | PRODALLOCSQNCGRPPRIORITYVALUE | Priority | ||||
| numberofbackwardcnsmpnperiods | NUMBEROFBACKWARDCNSMPNPERIODS | Backward Consumption | ||||
| numberofforwardcnsmpnperiods | NUMBEROFFORWARDCNSMPNPERIODS | Forward Consumption | ||||
| horizontalconsumptiondirection | HORIZONTALCONSUMPTIONDIRECTION | Consumption Direction | ||||
| pastperiodisallowed | PASTPERIODISALLOWED | Past Period Allowed | ||||
| onlyoverlappingqtyisconsumed | ONLYOVERLAPPINGQTYISCONSUMED | Consume Overlapping Quantity Only | ||||
| isdeleted | LKENZ | Deletion Ind. | ||||
| prodallocsqncgrpcnsmpnunit | PRODALLOCSQNCGRPCNSMPNUNIT | Group 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 Group
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PASQNC_GRP (
CLIENT, -- Client [MANDT]
PRODALLOCSEQUENCEGROUPUUID, -- Product Allocation Sequence Group UUID [PRODALLOCSEQUENCEGROUPUUID]
PRODUCTALLOCATIONSEQUENCEUUID, -- Product Allocation Sequence UUID [PRODUCTALLOCATIONSEQUENCEUUID]
PRODUCTALLOCATIONSEQUENCEGROUP, -- Sequence Group [PRODUCTALLOCATIONSEQUENCEGROUP]
PRODUCTALLOCATIONSEQUENCE, -- Allocation Sequence [PRODUCTALLOCATIONSEQUENCE]
PRODALLOCSEQUENCEGROUPTYPE, -- Sequence Group Type [PRODALLOCSEQUENCEGROUPTYPE]
PRODALLOCSQNCGRPPRIORITYVALUE, -- Priority [PRODALLOCSQNCGRPPRIORITYVALUE]
NUMBEROFBACKWARDCNSMPNPERIODS, -- Backward Consumption [NUMBEROFBACKWARDCNSMPNPERIODS]
NUMBEROFFORWARDCNSMPNPERIODS, -- Forward Consumption [NUMBEROFFORWARDCNSMPNPERIODS]
HORIZONTALCONSUMPTIONDIRECTION, -- Consumption Direction [HORIZONTALCONSUMPTIONDIRECTION]
PASTPERIODISALLOWED, -- Past Period Allowed [PASTPERIODISALLOWED]
ONLYOVERLAPPINGQTYISCONSUMED, -- Consume Overlapping Quantity Only [ONLYOVERLAPPINGQTYISCONSUMED]
ISDELETED, -- Deletion Ind. [LKENZ]
PRODALLOCSQNCGRPCNSMPNUNIT, -- Group Consumption Unit [PRODALLOCSQNCGRPCNSMPNUNIT]
PRIMARY KEY (CLIENT, PRODALLOCSEQUENCEGROUPUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA