I_PeggingAssignmentConversion

DDL: I_PEGGINGASSIGNMENTCONVERSION Type: view_entity BASIC
33 Fields 1 Data Sources

Pegging Assignment from Conversions

I_PeggingAssignmentConversion is a Basic CDS View that provides data about "Pegging Assignment from Conversions" in SAP S/4HANA. It reads from 1 data source (pmmo_assign_conv) and exposes 33 fields with key fields MRPArea, MatlStkOwnrGrpgWBSElmntIntID, ReplenishmentElement, ReplenishmentDate, RequirementDate.

Data Sources (1)

SourceAliasJoin Type
pmmo_assign_conv pmmo_assign_conv from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pegging Assignment from Conversions view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY MRPArea berid Single-Character Flag
KEY MatlStkOwnrGrpgWBSElmntIntID Ownr Grouping WBS El
KEY ReplenishmentElement repobj Replenishm. El.
KEY ReplenishmentDate repobj_date Replenishment Date
KEY RequirementDate rqmt_date Requirement Date
KEY AssignedWBSElementInternalID Assigned WBS Element
KEY MaterialStockAndConsumptionSts instk In Stock
KEY AlternateCostAssignmentObject objnr_brk Breakpoint
KEY NextHigherAssemblyObject repobj_nha NHA Repl. Elem.
KEY TopLevelRequirementObject rqmtobj_top Top Level Rqmt
Material matnr Vehicle Model
AcctAsgtGroupingWBSElmntIntID Asgt Grouping WBS El
Plant werks Receiving Plant
WBSElmntAssgdMatlQuantity assgdqty Allocated Qty
WBSElmntAssgdMatlExssQuantity xssqty Excess Quantity
WBSElmntAssgdMatlScrapQuantity scpqty Scrap Quantity
WBSElmntAssgdMatlLossQuantity lqty Loss Quantity
WBSElmntMatlCarryFwdQuantity undqty
MaterialBaseUnit meins Valuation Unit
MaterialExcessAssgmtMethod excess_assgmt_method Excess Method
MaterialLossAssgmtMethod lost_assgmt_method Loss Method
MaterialScrapAssgmtMethod scrap_assgmt_method Scrap Method
ReplnmtElmntTotalOrderQuantity totalreplqty Totl. Order Qty
TopLevelRequirementObjQuantity rqmtqty_top Requirement Quantity
TopLevelRqmtObjQuantityUnit rqmtqty_top_uom Base Unit
TopLevelRequirementObjRqmtDate top_rqmt_date Top Requirement Date
LeadingOrderOfCollectiveOrder leading_coll_order Leading Order
OriginOfPeggingAssignment conversion_type Assignment Source
ReplnmtElmntIsStockGain sgind Stock Gain Indicator
CreationDateTime Timestamp
LastChangeDateTime Timestamp
SourceReplenishmentElement source_repobj Source Repobj
ShippingNotice shipping_notice Ship.Notif.Seq.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PeggingAssignmentConversion.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_PeggingAssignmentConversion AS
SELECT
  berid AS MRPArea,
  cast(grpnr_stk as ps_s4_pspnr preserving type ) AS MatlStkOwnrGrpgWBSElmntIntID,
  repobj AS ReplenishmentElement,
  repobj_date AS ReplenishmentDate,
  rqmt_date AS RequirementDate,
  cast(pspnr_assgd as ps_s4_pspnr preserving type ) AS AssignedWBSElementInternalID,
  instk AS MaterialStockAndConsumptionSts,
  objnr_brk AS AlternateCostAssignmentObject,
  repobj_nha AS NextHigherAssemblyObject,
  rqmtobj_top AS TopLevelRequirementObject,
  matnr AS Material,
  cast(grpnr_aa as ps_s4_pspnr preserving type ) AS AcctAsgtGroupingWBSElmntIntID,
  werks AS Plant,
  assgdqty AS WBSElmntAssgdMatlQuantity,
  xssqty AS WBSElmntAssgdMatlExssQuantity,
  scpqty AS WBSElmntAssgdMatlScrapQuantity,
  lqty AS WBSElmntAssgdMatlLossQuantity,
  undqty AS WBSElmntMatlCarryFwdQuantity,
  meins AS MaterialBaseUnit,
  excess_assgmt_method AS MaterialExcessAssgmtMethod,
  lost_assgmt_method AS MaterialLossAssgmtMethod,
  scrap_assgmt_method AS MaterialScrapAssgmtMethod,
  totalreplqty AS ReplnmtElmntTotalOrderQuantity,
  rqmtqty_top AS TopLevelRequirementObjQuantity,
  rqmtqty_top_uom AS TopLevelRqmtObjQuantityUnit,
  top_rqmt_date AS TopLevelRequirementObjRqmtDate,
  leading_coll_order AS LeadingOrderOfCollectiveOrder,
  conversion_type AS OriginOfPeggingAssignment,
  sgind AS ReplnmtElmntIsStockGain,
  cast(creationdatetime as timestampl) AS CreationDateTime,
  cast(lastchangedatetime as timestampl) AS LastChangeDateTime,
  source_repobj AS SourceReplenishmentElement,
  shipping_notice AS ShippingNotice
FROM pmmo_assign_conv
;

Learn More