I_PlndIndepRqmtItem

DDL: I_PLNDINDEPRQMTITEM SQL: IPIR_IT Type: view COMPOSITE
16 Fields 1 Data Sources 1 Associations

Planned Independent Requirement Item

I_PlndIndepRqmtItem is a Composite CDS View that provides data about "Planned Independent Requirement Item" in SAP S/4HANA. It reads from 1 data source (I_PlndIndepRqmtItemBasic) and exposes 16 fields with key fields Product, Plant, MRPArea, PlndIndepRqmtType, PlndIndepRqmtVersion. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PlndIndepRqmtItemBasic Item from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PlndIndepRqmt _PlndIndepRqmt $projection.Product = _PlndIndepRqmt.Product and $projection.Plant = _PlndIndepRqmt.Plant and $projection.MRPArea = _PlndIndepRqmt.MRPArea and $projection.PlndIndepRqmtType = _PlndIndepRqmt.PlndIndepRqmtType and $projection.PlndIndepRqmtVersion = _PlndIndepRqmt.PlndIndepRqmtVersion and $projection.RequirementPlan = _PlndIndepRqmt.RequirementPlan and $projection.RequirementSegment = _PlndIndepRqmt.RequirementSegment

Annotations (11)

NameValueLevelField
EndUserText.label Planned Independent Requirement Item view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IPIR_IT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Product I_PlndIndepRqmtItemBasic Product Product Sold
KEY Plant I_PlndIndepRqmtItemBasic Plant Valuation Area
KEY MRPArea I_PlndIndepRqmtItemBasic MRPArea MRP Area
KEY PlndIndepRqmtType I_PlndIndepRqmtItemBasic PlndIndepRqmtType
KEY PlndIndepRqmtVersion I_PlndIndepRqmtItemBasic PlndIndepRqmtVersion
KEY RequirementPlan I_PlndIndepRqmtItemBasic RequirementPlan Requirements Plan
KEY RequirementSegment I_PlndIndepRqmtItemBasic RequirementSegment Req. Segment
KEY PeriodType I_PlndIndepRqmtItemBasic PeriodType PeriodIndicator
PlndIndepRqmtInternalID I_PlndIndepRqmtItemBasic PlndIndepRqmtInternalID PIR Pointer
WorkingDayDate I_PlndIndepRqmtItemBasic WorkingDayDate
PlannedQuantity I_PlndIndepRqmtItemBasic PlannedQuantity Planned qty
WithdrawalQuantity I_PlndIndepRqmtItemBasic WithdrawalQuantity Withdrawal Qty
UnitOfMeasure I_PlndIndepRqmtItemBasic UnitOfMeasure Unit Protected Qty
LastChangedByUser I_PlndIndepRqmtItemBasic LastChangedByUser User Name
LastChangeDate I_PlndIndepRqmtItemBasic LastChangeDate Time Stamp
_PlndIndepRqmt _PlndIndepRqmt

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_PlndIndepRqmtItem.
-- 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.
-- SQL view name: IPIR_IT

CREATE VIEW I_PlndIndepRqmtItem AS
SELECT
  Item.Product AS Product,
  Item.Plant AS Plant,
  Item.MRPArea AS MRPArea,
  Item.PlndIndepRqmtType AS PlndIndepRqmtType,
  Item.PlndIndepRqmtVersion AS PlndIndepRqmtVersion,
  Item.RequirementPlan AS RequirementPlan,
  Item.RequirementSegment AS RequirementSegment,
  Item.PeriodType AS PeriodType,
  Item.PlndIndepRqmtInternalID AS PlndIndepRqmtInternalID,
  Item.WorkingDayDate AS WorkingDayDate,
  Item.PlannedQuantity AS PlannedQuantity,
  Item.WithdrawalQuantity AS WithdrawalQuantity,
  Item.UnitOfMeasure AS UnitOfMeasure,
  Item.LastChangedByUser AS LastChangedByUser,
  Item.LastChangeDate AS LastChangeDate
FROM I_PlndIndepRqmtItemBasic AS Item
LEFT OUTER JOIN I_PlndIndepRqmt AS _PlndIndepRqmt ON Product = _PlndIndepRqmt.Product AND Plant = _PlndIndepRqmt.Plant AND MRPArea = _PlndIndepRqmt.MRPArea AND PlndIndepRqmtType = _PlndIndepRqmt.PlndIndepRqmtType AND PlndIndepRqmtVersion = _PlndIndepRqmt.PlndIndepRqmtVersion AND RequirementPlan = _PlndIndepRqmt.RequirementPlan AND RequirementSegment = _PlndIndepRqmt.RequirementSegment  -- association [1..1]
;

Learn More