I_PlndIndepRqmtItmBasicPlanInd

DDL: I_PLNDINDEPRQMTITMBASICPLANIND SQL: IPIRITBPI Type: view BASIC
18 Fields 2 Data Sources

Planned Independent Requirement Item Basic internal key

I_PlndIndepRqmtItmBasicPlanInd is a Basic CDS View that provides data about "Planned Independent Requirement Item Basic internal key" in SAP S/4HANA. It reads from 2 data sources (I_PrPlPlndInRqmtAreaOfRespy, pbed) and exposes 18 fields with key fields PlndIndepRqmtInternalID, WorkingDayDate, Product, Plant, MRPArea.

Data Sources (2)

SourceAliasJoin Type
I_PrPlPlndInRqmtAreaOfRespy head from
pbed pbed left_outer

Annotations (9)

NameValueLevelField
EndUserText.label Planned Independent Requirement Item Basic 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 IPIRITBPI view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PlndIndepRqmtInternalID pbed bdzei PIR Pointer
KEY WorkingDayDate
KEY Product I_PrPlPlndInRqmtAreaOfRespy Product Product Sold
KEY Plant I_PrPlPlndInRqmtAreaOfRespy Plant Valuation Area
KEY MRPArea I_PrPlPlndInRqmtAreaOfRespy MRPArea MRP Area
KEY PlndIndepRqmtType I_PrPlPlndInRqmtAreaOfRespy PlndIndepRqmtType
KEY PlndIndepRqmtVersion I_PrPlPlndInRqmtAreaOfRespy PlndIndepRqmtVersion
KEY RequirementPlan I_PrPlPlndInRqmtAreaOfRespy RequirementPlan Requirements Plan
KEY RequirementSegment I_PrPlPlndInRqmtAreaOfRespy RequirementSegment Req. Segment
PlndIndepRqmtIsActive I_PrPlPlndInRqmtAreaOfRespy PlndIndepRqmtIsActive
UnitOfMeasure I_PrPlPlndInRqmtAreaOfRespy UnitOfMeasure Unit Protected Qty
PeriodTypeendasPeriodType
dec133endasPlannedQuantity
WithdrawalQuantity pbed entmg Withdrawal Qty
LastChangedByUser pbed aenam User Name
LastChangeDate pbed laeda Last Change
DmndFcstInPastIsAccepted pbed acc_past Accptd Past Demand
DmndFcstIsDeleted pbed loevr Fcst to be Deltd

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_PlndIndepRqmtItmBasicPlanInd.
-- 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: IPIRITBPI

CREATE VIEW I_PlndIndepRqmtItmBasicPlanInd 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,
  head.UnitOfMeasure AS UnitOfMeasure,
  case when pbed.entli = '3' then 'M' when pbed.entli = '2' then 'W' else head.PeriodType end as PeriodType AS PeriodTypeendasPeriodType,
  case when pbed.loevr = '' then cast(pbed.plnmg + pbed.entmg as abap.dec(13,3)) end as PlannedQuantity AS dec133endasPlannedQuantity,
  pbed.entmg AS WithdrawalQuantity,
  pbed.aenam AS LastChangedByUser,
  pbed.laeda AS LastChangeDate,
  pbed.acc_past AS DmndFcstInPastIsAccepted,
  pbed.loevr AS DmndFcstIsDeleted
FROM I_PrPlPlndInRqmtAreaOfRespy AS head
LEFT OUTER JOIN pbed ON /* join condition not captured in parsed metadata */
;

Learn More