C_CurrentAssignments

DDL: C_CURRENTASSIGNMENTS Type: view_entity CONSUMPTION
57 Fields 1 Data Sources

Current Pegging Assignments

C_CurrentAssignments is a Consumption CDS View that provides data about "Current Pegging Assignments" in SAP S/4HANA. It reads from 1 data source (I_CurrentAssignments) and exposes 57 fields with key fields MRPArea, MatlStkOwnrGrpgWBSElmntIntID, ReplenishmentElement, ReplenishmentDate, RequirementDate.

Data Sources (1)

SourceAliasJoin Type
I_CurrentAssignments I_CurrentAssignments from

Annotations (10)

NameValueLevelField
EndUserText.label Current Pegging Assignments view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
UI.headerInfo.typeName Assignment view
UI.headerInfo.typeNamePlural Assignments view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY MRPArea MRPArea MRP Area
KEY MatlStkOwnrGrpgWBSElmntIntID MatlStkOwnrGrpgWBSElmntIntID
KEY ReplenishmentElement ReplenishmentElement
KEY ReplenishmentDate ReplenishmentDate
KEY RequirementDate RequirementDate Requirement Date
KEY AssignedWBSElementInternalID AssignedWBSElementInternalID WBS Element
KEY MaterialStockAndConsumptionSts MaterialStockAndConsumptionSts
KEY AlternateCostAssignmentObject AlternateCostAssignmentObject
KEY NextHigherAssemblyObject NextHigherAssemblyObject
KEY TopLevelRequirementObject TopLevelRequirementObject
Plant Plant Valuation Area
Material Material Vehicle Model
MatlStkOwnrGrpgWBSElmntExtID _StkOwnrGrpgWBSElmnt WBSElementExternalID WBS Element External ID
AcctAsgtGroupingWBSElmntExtID _AcctAsgtGrpgWBSElmnt WBSElementExternalID WBS Element External ID
AssignedWBSElementExternalID _AssignedWBSElmnt WBSElementExternalID WBS Element External ID
AlternateCostAssgmtObjExtID AlternateCostAssgmtObjExtID
MRPElementIDForDisplay MRPElementIDForDisplay
NextHigherMRPElmntIDForDisplay NextHigherMRPElmntIDForDisplay
TopLevelMRPElementIDForDisplay TopLevelMRPElementIDForDisplay
WBSElmntAssgdMatlQuantity WBSElmntAssgdMatlQuantity
WBSElmntAssgdMatlExssQuantity WBSElmntAssgdMatlExssQuantity
WBSElmntAssgdMatlScrapQuantity WBSElmntAssgdMatlScrapQuantity
WBSElmntAssgdMatlLossQuantity WBSElmntAssgdMatlLossQuantity
WBSElmntMatlCarryFwdQuantity WBSElmntMatlCarryFwdQuantity
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MaterialExcessAssgmtMethod MaterialExcessAssgmtMethod
MaterialLossAssgmtMethod MaterialLossAssgmtMethod
MaterialScrapAssgmtMethod MaterialScrapAssgmtMethod
ReplnmtElmntTotalOrderQuantity ReplnmtElmntTotalOrderQuantity
TopLevelRequirementObjQuantity TopLevelRequirementObjQuantity
TopLevelRqmtObjQuantityUnit TopLevelRqmtObjQuantityUnit
TopLevelRequirementObjRqmtDate TopLevelRequirementObjRqmtDate
LeadingOrderOfCollectiveOrder LeadingOrderOfCollectiveOrder
ReplnmtElmntIsStockGain ReplnmtElmntIsStockGain
OriginOfPeggingAssignment OriginOfPeggingAssignment
ShippingNotice ShippingNotice
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
MRPController _MaterialPlant MRPController MRP Controller
MRPElementCategoryName MRPElementCategoryName
NextHigherMRPElementCatName NextHigherMRPElementCatName
TopLevelMRPElementCategoryName TopLevelMRPElementCategoryName
MRPElementCategory MRPElementCategory MRP Elmnt Ind.
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
NextHigherMRPElementCategory NextHigherMRPElementCategory
NextHigherAssyPurgDocCat NextHigherAssyPurgDocCat Doc. Category
TopLevelMRPElementCategory TopLevelMRPElementCategory
AlternateCostAssignmentObjType AlternateCostAssignmentObjType
AlternateCostAssgmtObjTypeName AlternateCostAssgmtObjTypeName
AcctAsgtGroupingWBSElmntIntID AcctAsgtGroupingWBSElmntIntID
OriginOfPeggingAssignmentDesc _OriginOfPeggingAssignment OriginOfPeggingAssignmentDesc
MaterialExcessAssgmtMethodDesc _MaterialExcessAssgmtMethod MaterialExcessAssgmtMethodDesc
MaterialScrapAssgmtMethodDesc _MaterialScrapAssgmtMethod MaterialScrapAssgmtMethodDesc
MaterialLossAssgmtMethodDesc _MaterialLossAssgmtMethod MaterialLossAssgmtMethodDesc
MatlStockAndCnsmpnStatusDesc _MaterialStockAndCnsmpnSts MatlStockAndCnsmpnStatusDesc
MaterialName _MaterialText MaterialName Material Description
MRPControllerName

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 C_CurrentAssignments.
-- 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 C_CurrentAssignments AS
SELECT
  MRPArea,
  MatlStkOwnrGrpgWBSElmntIntID,
  ReplenishmentElement,
  ReplenishmentDate,
  RequirementDate,
  AssignedWBSElementInternalID,
  MaterialStockAndConsumptionSts,
  AlternateCostAssignmentObject,
  NextHigherAssemblyObject,
  TopLevelRequirementObject,
  Plant,
  Material,
  _StkOwnrGrpgWBSElmnt.WBSElementExternalID AS MatlStkOwnrGrpgWBSElmntExtID,
  _AcctAsgtGrpgWBSElmnt.WBSElementExternalID AS AcctAsgtGroupingWBSElmntExtID,
  _AssignedWBSElmnt.WBSElementExternalID AS AssignedWBSElementExternalID,
  AlternateCostAssgmtObjExtID,
  MRPElementIDForDisplay,
  NextHigherMRPElmntIDForDisplay,
  TopLevelMRPElementIDForDisplay,
  WBSElmntAssgdMatlQuantity,
  WBSElmntAssgdMatlExssQuantity,
  WBSElmntAssgdMatlScrapQuantity,
  WBSElmntAssgdMatlLossQuantity,
  WBSElmntMatlCarryFwdQuantity,
  MaterialBaseUnit,
  MaterialExcessAssgmtMethod,
  MaterialLossAssgmtMethod,
  MaterialScrapAssgmtMethod,
  ReplnmtElmntTotalOrderQuantity,
  TopLevelRequirementObjQuantity,
  TopLevelRqmtObjQuantityUnit,
  TopLevelRequirementObjRqmtDate,
  LeadingOrderOfCollectiveOrder,
  ReplnmtElmntIsStockGain,
  OriginOfPeggingAssignment,
  ShippingNotice,
  CreationDateTime,
  LastChangeDateTime,
  _MaterialPlant.MRPController AS MRPController,
  MRPElementCategoryName,
  NextHigherMRPElementCatName,
  TopLevelMRPElementCategoryName,
  MRPElementCategory,
  PurchasingDocumentCategory,
  NextHigherMRPElementCategory,
  NextHigherAssyPurgDocCat,
  TopLevelMRPElementCategory,
  AlternateCostAssignmentObjType,
  AlternateCostAssgmtObjTypeName,
  AcctAsgtGroupingWBSElmntIntID,
  _OriginOfPeggingAssignment.OriginOfPeggingAssignmentDesc AS OriginOfPeggingAssignmentDesc,
  _MaterialExcessAssgmtMethod.MaterialExcessAssgmtMethodDesc AS MaterialExcessAssgmtMethodDesc,
  _MaterialScrapAssgmtMethod.MaterialScrapAssgmtMethodDesc AS MaterialScrapAssgmtMethodDesc,
  _MaterialLossAssgmtMethod.MaterialLossAssgmtMethodDesc AS MaterialLossAssgmtMethodDesc,
  _MaterialStockAndCnsmpnSts.MatlStockAndCnsmpnStatusDesc AS MatlStockAndCnsmpnStatusDesc,
  _MaterialText.MaterialName AS MaterialName,
  _MaterialPlant._MRPController.MRPControllerName AS MRPControllerName
FROM I_CurrentAssignments
;

Learn More