I_PlndIndepRqmtItemBasic

DDL: I_PLNDINDEPRQMTITEMBASIC SQL: IPIR_IT_BAS Type: view BASIC Package: PPH_FORECAST_DEMAND
15 Fields 2 Data Sources

Planned Independent Requirement Item Basic with internal key

I_PlndIndepRqmtItemBasic is a Basic CDS View that provides data about "Planned Independent Requirement Item Basic with internal key" in SAP S/4HANA. It reads from 2 data sources (P_PlndIndepRqmt, pbed) and exposes 15 fields with key fields PlndIndepRqmtInternalID, WorkingDayDate. Part of development package PPH_FORECAST_DEMAND.

Data Sources (2)

SourceAliasJoin Type
P_PlndIndepRqmt head inner
pbed pbed from

Annotations (9)

NameValueLevelField
EndUserText.label Planned Independent Requirement Item Basic with internal key view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IPIR_IT_BAS view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PlndIndepRqmtInternalID pbed bdzei PIR Pointer
KEY WorkingDayDate
Product P_PlndIndepRqmt Product Product Sold
Plant P_PlndIndepRqmt Plant Valuation Area
MRPArea P_PlndIndepRqmt MRPArea MRP Area
PlndIndepRqmtType P_PlndIndepRqmt PlndIndepRqmtType Reqmts type
PlndIndepRqmtVersion P_PlndIndepRqmt PlndIndepRqmtVersion Version
RequirementPlan P_PlndIndepRqmt RequirementPlan Requirements Plan
RequirementSegment P_PlndIndepRqmt RequirementSegment Req. Segment
PlndIndepRqmtIsActive P_PlndIndepRqmt PlndIndepRqmtIsActive Active
PlannedQuantity pbed plnmg Planned qty
WithdrawalQuantity pbed entmg Withdrawal Qty
UnitOfMeasure pbed meins Valuation Unit
LastChangedByUser pbed aenam User Name
LastChangeDate pbed laeda Last Change

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_PlndIndepRqmtItemBasic.
-- 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_BAS

CREATE VIEW I_PlndIndepRqmtItemBasic AS
SELECT
  pbed.bdzei AS PlndIndepRqmtInternalID,
  cast(pbed.pdatu as pph_working_day preserving type) AS WorkingDayDate,
  head.Product AS Product,
  head.Plant AS Plant,
  head.MRPArea AS MRPArea,
  head.PlndIndepRqmtType AS PlndIndepRqmtType,
  head.PlndIndepRqmtVersion AS PlndIndepRqmtVersion,
  head.RequirementPlan AS RequirementPlan,
  head.RequirementSegment AS RequirementSegment,
  head.PlndIndepRqmtIsActive AS PlndIndepRqmtIsActive,
  pbed.plnmg AS PlannedQuantity,
  pbed.entmg AS WithdrawalQuantity,
  pbed.meins AS UnitOfMeasure,
  pbed.aenam AS LastChangedByUser,
  pbed.laeda AS LastChangeDate
FROM pbed
INNER JOIN P_PlndIndepRqmt AS head ON /* join condition not captured in parsed metadata */
;

Learn More