PIR_UNION_HEAD_ALL

DDL: PIR_UNION_HEAD_ALL SQL: PIR_V_UNIONA_HD Type: view
72 Fields 4 Data Sources

All PIR Headers

PIR_UNION_HEAD_ALL is a CDS View that provides data about "All PIR Headers" in SAP S/4HANA. It reads from 4 data sources (pbid, pbim, prps, prps) and exposes 72 fields with key fields matnr, werks, berid, bedae, versb.

Data Sources (4)

SourceAliasJoin Type
pbid pbid union_all
pbim pbim from
prps prps left_outer
prps prps left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PIR_V_UNIONA_HD view
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label All PIR Headers view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY matnr pbim matnr Vehicle Model
KEY werks pbim werks Receiving Plant
KEY berid Single-Character Flag
KEY bedae pbim bedae Reqmts type
KEY versb pbim versb Version
KEY sgt_rcat pbim sgt_rcat Req. Segment
KEY pbdnr pbim pbdnr Requirements Plan
KEY pbdnr_ext pbim pbdnr_ext Ext. Req. Plan
bdzei pbim bdzei PIR Pointer
zuvkz pbim zuvkz Consumption
vervs pbim vervs Active
verkz pbim verkz Version
zuokr pbim zuokr Alloc.criterion
plnkz pbim plnkz Planning ind.
txtkz pbim txtkz Long txt exists
uebkz pbim uebkz Copied
datlp pbim datlp Date
uhrlp pbim uhrlp Time
aggpb pbim aggpb Aggregation
plscn pbim plscn Planning Scenario
vrsio pbim vrsio Version
mcinf pbim mcinf Info structure
stfna pbim stfna Field name
oplkz pbim oplkz Without MRP
mcinc pbim mcinc Info structure
vrsic pbim vrsic Version
knttp pbim knttp AcctAssgnCat:CC
sobkz pbim sobkz Special Stock
kzvbr pbim kzvbr Consumption
pspel pbim pspel WBS Element
posid prps posid WBS Element
kdpos pbim kdpos Sales Ord. Item
kdauf pbim kdauf SD Document
profilid pbim profilid Prof. name
kzbws pbim kzbws Valuation
loevr pbim loevr Fcst to be Deltd
matnr Vehicle Model
KEY werks pbid werks Receiving Plant
KEY berid pbid berid Single-Character Flag
KEY bedae pbid bedae Reqmts type
KEY versb pbid versb Version
KEY sgt_rcat pbid sgt_rcat Req. Segment
KEY pbdnr pbid pbdnr Requirements Plan
KEY pbdnr_ext pbid pbdnr_ext Ext. Req. Plan
bdzei pbid bdzei PIR Pointer
zuvkz pbid zuvkz Consumption
vervs pbid vervs Active
verkz pbid verkz Version
zuokr pbid zuokr Alloc.criterion
plnkz pbid plnkz Planning ind.
txtkz pbid txtkz Long txt exists
uebkz pbid uebkz Copied
datlp pbid datlp Date
uhrlp pbid uhrlp Time
aggpb pbid aggpb Aggregation
plscn pbid plscn Planning Scenario
vrsio pbid vrsio Version
mcinf pbid mcinf Info structure
stfna pbid stfna Field name
oplkz pbid oplkz Without MRP
mcinc pbid mcinc Info structure
vrsic pbid vrsic Version
knttp pbid knttp AcctAssgnCat:CC
sobkz pbid sobkz Special Stock
kzvbr pbid kzvbr Consumption
pspel pbid pspel WBS Element
posid prps posid WBS Element
kdpos pbid kdpos Sales Ord. Item
kdauf pbid kdauf SD Document
profilid pbid profilid Prof. name
kzbws pbid kzbws Valuation
loevr pbid 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 PIR_UNION_HEAD_ALL.
-- 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: PIR_V_UNIONA_HD

CREATE VIEW PIR_UNION_HEAD_ALL AS
SELECT
  pbim.matnr AS matnr,
  pbim.werks AS werks,
  cast(rpad(pbim.werks,10,'') as berid preserving type ) AS berid,
  pbim.bedae AS bedae,
  pbim.versb AS versb,
  pbim.sgt_rcat AS sgt_rcat,
  pbim.pbdnr AS pbdnr,
  pbim.pbdnr_ext AS pbdnr_ext,
  pbim.bdzei AS bdzei,
  pbim.zuvkz AS zuvkz,
  pbim.vervs AS vervs,
  pbim.verkz AS verkz,
  pbim.zuokr AS zuokr,
  pbim.plnkz AS plnkz,
  pbim.txtkz AS txtkz,
  pbim.uebkz AS uebkz,
  pbim.datlp AS datlp,
  pbim.uhrlp AS uhrlp,
  pbim.aggpb AS aggpb,
  pbim.plscn AS plscn,
  pbim.vrsio AS vrsio,
  pbim.mcinf AS mcinf,
  pbim.stfna AS stfna,
  pbim.oplkz AS oplkz,
  pbim.mcinc AS mcinc,
  pbim.vrsic AS vrsic,
  pbim.knttp AS knttp,
  pbim.sobkz AS sobkz,
  pbim.kzvbr AS kzvbr,
  pbim.pspel AS pspel,
  prps.posid AS posid,
  pbim.kdpos AS kdpos,
  pbim.kdauf AS kdauf,
  pbim.profilid AS profilid,
  pbim.kzbws AS kzbws,
  pbim.loevr AS loevr
FROM pbim
LEFT OUTER JOIN prps ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): pbid
;

Learn More