P_PlndIndepRqmt

DDL: P_PLNDINDEPRQMT SQL: PPIR_H Type: view BASIC Package: PPH_FORECAST_DEMAND
28 Fields 2 Data Sources

Planned Independent Requirement: Union of PBIM and PBID

P_PlndIndepRqmt is a Basic CDS View that provides data about "Planned Independent Requirement: Union of PBIM and PBID" in SAP S/4HANA. It reads from 2 data sources (pbid, pbim) and exposes 28 fields with key fields Product, Plant, MRPArea, PlndIndepRqmtType, PlndIndepRqmtVersion. Part of development package PPH_FORECAST_DEMAND.

Data Sources (2)

SourceAliasJoin Type
pbid pbid union_all
pbim pbim from

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PPIR_H view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY Product matnr Vehicle Model
KEY Plant werks Receiving Plant
KEY MRPArea Single-Character Flag
KEY PlndIndepRqmtType bedae Reqmts type
KEY PlndIndepRqmtVersion versb Version
KEY RequirementSegment sgt_rcat Req. Segment
PlndIndepRqmtInternalID bdzei PIR Pointer
PlndIndepRqmtIsActive vervs Active
WBSElementInternalID pspel WBS Element
PlndIndepRqmtAcctAssgmtCat knttp AcctAssgnCat:CC
InventorySpecialStockType sobkz Special Stock
ConsumptionPosting kzvbr Consumption
InventorySpecialStockValnType kzbws Valuation
PlndIndepRqmtOwningApplication Copied
KEY Plant werks Receiving Plant
KEY MRPArea berid Single-Character Flag
KEY PlndIndepRqmtType bedae Reqmts type
KEY PlndIndepRqmtVersion versb Version
KEY RequirementSegment sgt_rcat Req. Segment
PlndIndepRqmtInternalID bdzei PIR Pointer
PlndIndepRqmtIsActive vervs Active
WBSElementInternalID pspel WBS Element
PlndIndepRqmtAcctAssgmtCat knttp AcctAssgnCat:CC
InventorySpecialStockType sobkz Special Stock
ConsumptionPosting kzvbr Consumption
InventorySpecialStockValnType kzbws Valuation
PlndIndepRqmtOwningApplication uebkz Copied
PlndIndepRqmtLastChgdDateTime lastchangedts Time Stamp

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 P_PlndIndepRqmt.
-- 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: PPIR_H

CREATE VIEW P_PlndIndepRqmt AS
SELECT
  matnr AS Product,
  werks AS Plant,
  cast(rpad(werks,10,'') as berid preserving type ) AS MRPArea,
  bedae AS PlndIndepRqmtType,
  versb AS PlndIndepRqmtVersion,
  sgt_rcat AS RequirementSegment,
  bdzei AS PlndIndepRqmtInternalID,
  vervs AS PlndIndepRqmtIsActive,
  pspel AS WBSElementInternalID,
  knttp AS PlndIndepRqmtAcctAssgmtCat,
  sobkz AS InventorySpecialStockType,
  kzvbr AS ConsumptionPosting,
  kzbws AS InventorySpecialStockValnType,
  cast ( uebkz as pph_uebkz_cds ) AS PlndIndepRqmtOwningApplication,
  lastchangedts AS PlndIndepRqmtLastChgdDateTime
FROM pbim
-- UNION ALL with additional select branch(es): pbid
;

Learn More