I_PEGGINGASSIGNMENT
Pegging Assignment
I_PEGGINGASSIGNMENT is a CDS View in S/4HANA. Pegging Assignment. It contains 31 fields. 8 CDS views read from this table.
CDS Views using this table (8)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PeggingAssgmtsHistoryDteRnge | view_entity | from | COMPOSITE | Assignment History in Date range |
| I_PeggingAssignmentAsOf | view_entity | from | COMPOSITE | Pegging Assignments As Of Data |
| I_PeggingAssignmentChange | view_entity | from | COMPOSITE | Changed Pegging Records as of Given Date |
| I_PeggingAssignmentForDisplay | view_entity | from | COMPOSITE | Pegging Assignments for display |
| I_PeggingAssignmentNew | view_entity | from | COMPOSITE | New Pegging Assignments |
| I_PeggingAssignmentSum | view_entity | from | COMPOSITE | Aggregated Pegging Assignments |
| I_PeggingAssignmentWithHistory | view_entity | from | COMPOSITE | Current Pegging Assignments plus History |
| I_PggngAssignmentWthConversion | view_entity | union_all | COMPOSITE | Pegging Assignment With Conversions |
Fields (31)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AlternateCostAssignmentObject | AlternateCostAssignmentObject | 1 |
| KEY | AssignedWBSElementInternalID | AssignedWBSElementInternalID | 1 |
| KEY | MaterialStockAndConsumptionSts | MaterialStockAndConsumptionSts | 1 |
| KEY | MatlStkOwnrGrpgWBSElmntIntID | MatlStkOwnrGrpgWBSElmntIntID | 1 |
| KEY | NextHigherAssemblyObject | NextHigherAssemblyObject | 1 |
| KEY | ReplenishmentDate | ReplenishmentDate | 1 |
| KEY | ReplenishmentElement | ReplenishmentElement | 1 |
| KEY | RequirementDate | RequirementDate | 1 |
| KEY | TopLevelRequirementObject | TopLevelRequirementObject | 1 |
| AcctAsgtGroupingWBSElmntIntID | AcctAsgtGroupingWBSElmntIntID | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LeadingOrderOfCollectiveOrder | LeadingOrderOfCollectiveOrder | 1 | |
| Material | Material | 1 | |
| MaterialBaseUnit | MaterialBaseUnit | 1 | |
| MaterialExcessAssgmtMethod | MaterialExcessAssgmtMethod | 1 | |
| MaterialLossAssgmtMethod | MaterialLossAssgmtMethod | 1 | |
| MaterialScrapAssgmtMethod | MaterialScrapAssgmtMethod | 1 | |
| OriginOfPeggingAssignment | OriginOfPeggingAssignment | 1 | |
| Plant | Plant | 1 | |
| ReplnmtElmntIsStockGain | ReplnmtElmntIsStockGain | 1 | |
| ReplnmtElmntTotalOrderQuantity | ReplnmtElmntTotalOrderQuantity | 1 | |
| ShippingNotice | ShippingNotice | 1 | |
| TopLevelRequirementObjQuantity | TopLevelRequirementObjQuantity | 1 | |
| TopLevelRequirementObjRqmtDate | TopLevelRequirementObjRqmtDate | 1 | |
| TopLevelRqmtObjQuantityUnit | TopLevelRqmtObjQuantityUnit | 1 | |
| WBSElmntAssgdMatlExssQuantity | WBSElmntAssgdMatlExssQuantity | 1 | |
| WBSElmntAssgdMatlLossQuantity | WBSElmntAssgdMatlLossQuantity | 1 | |
| WBSElmntAssgdMatlQuantity | WBSElmntAssgdMatlQuantity | 1 | |
| WBSElmntAssgdMatlScrapQuantity | WBSElmntAssgdMatlScrapQuantity | 1 | |
| WBSElmntMatlCarryFwdQuantity | WBSElmntMatlCarryFwdQuantity | 1 |
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.
-- Pegging Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PEGGINGASSIGNMENT (
ALTERNATECOSTASSIGNMENTOBJECT,
ASSIGNEDWBSELEMENTINTERNALID,
MATERIALSTOCKANDCONSUMPTIONSTS,
MATLSTKOWNRGRPGWBSELMNTINTID,
NEXTHIGHERASSEMBLYOBJECT,
REPLENISHMENTDATE,
REPLENISHMENTELEMENT,
REQUIREMENTDATE,
TOPLEVELREQUIREMENTOBJECT,
ACCTASGTGROUPINGWBSELMNTINTID,
CREATIONDATETIME,
LASTCHANGEDATETIME,
LEADINGORDEROFCOLLECTIVEORDER,
MATERIAL,
MATERIALBASEUNIT,
MATERIALEXCESSASSGMTMETHOD,
MATERIALLOSSASSGMTMETHOD,
MATERIALSCRAPASSGMTMETHOD,
ORIGINOFPEGGINGASSIGNMENT,
PLANT,
REPLNMTELMNTISSTOCKGAIN,
REPLNMTELMNTTOTALORDERQUANTITY,
SHIPPINGNOTICE,
TOPLEVELREQUIREMENTOBJQUANTITY,
TOPLEVELREQUIREMENTOBJRQMTDATE,
TOPLEVELRQMTOBJQUANTITYUNIT,
WBSELMNTASSGDMATLEXSSQUANTITY,
WBSELMNTASSGDMATLLOSSQUANTITY,
WBSELMNTASSGDMATLQUANTITY,
WBSELMNTASSGDMATLSCRAPQUANTITY,
WBSELMNTMATLCARRYFWDQUANTITY,
PRIMARY KEY (ALTERNATECOSTASSIGNMENTOBJECT, ASSIGNEDWBSELEMENTINTERNALID, MATERIALSTOCKANDCONSUMPTIONSTS, MATLSTKOWNRGRPGWBSELMNTINTID, NEXTHIGHERASSEMBLYOBJECT, REPLENISHMENTDATE, REPLENISHMENTELEMENT, REQUIREMENTDATE, TOPLEVELREQUIREMENTOBJECT)
);
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