PBIM

Transparent Table Application Table
36 Fields 10 CDS Views

Independent Requirements for Material

PBIM is an SAP database table in S/4HANA. Independent Requirements for Material. It contains 36 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
I_ForecastDemandHeader view from BASIC Forecast Demand Header
I_MRPPlndIndepRqmt view_entity inner BASIC Planned Independent Requirements
I_PlndIndepRqmtByIntKey view from BASIC Planned Independent Requirement by Internal Key
I_PlndIndepRqmtPlan view from BASIC PIR Requirement Plan PopUp View
I_SupDmndAllDocPlndIndepRqmts view inner BASIC View for Planned Independent Requirements
P_PlndIndepRqmt view from BASIC
Pir_inactive_exists view from An inactive PIR exists
Pir_Union_Head view from All PIR Headers
PIR_UNION_HEAD_ALL view from All PIR Headers
PPH_E_MDPB view inner

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY matnr MATNR Material
KEY werks WERKS_D Plant
KEY bedae BEDAE Reqmts type
KEY versb VERSB Version
KEY pbdnr PBDNR Requirements Plan
bdzei BDZEI PIR Pointer
zuvkz DZUVKZ Consumption
vervs VERVS Active
verkz VERVP CInd.
zuokr DZUOKR Alloc.criterion
plnkz PLNKZ Planning ind.
txtkz TXTKZ Long txt exists
loevr LOEVR Deletion Indicator
uebkz UEBKZ Copied
datlp DATUM Date
uhrlp UZEIT Time
aggpb AGGPB Aggregation
plscn PLSCN Planning Scenario
vrsio VRSIO Version
mcinf MCINF Info structure
stfna STFNA Field name
oplkz OPLKZ Without MRP
mcinc MCINC Info structure
vrsic VRSIO Version
knttp KNTTP Acct Assgmt Cat
sobkz SOBKZ Special Stock
kzvbr KZVBR Consumption
pspel PS_PSP_PNR WBS Element
kdpos KDPOS Sales Ord. Item
kdauf KDAUF Sales Order
profilid PROFILID Prof. name
kzbws KZBWS Valuation
pbdnr_ext PBDNR_EXT Ext. Req. Plan
sgt_rcat SGT_RCAT Req. Segment
lastchangedts TIMESTAMPL Time Stamp

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Independent Requirements for Material
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PBIM (
    MANDT,          -- Client [MANDT]
    MATNR,          -- Material [MATNR]
    WERKS,          -- Plant [WERKS_D]
    BEDAE,          -- Reqmts type [BEDAE]
    VERSB,          -- Version [VERSB]
    PBDNR,          -- Requirements Plan [PBDNR]
    BDZEI,          -- PIR Pointer [BDZEI]
    ZUVKZ,          -- Consumption [DZUVKZ]
    VERVS,          -- Active [VERVS]
    VERKZ,          -- CInd. [VERVP]
    ZUOKR,          -- Alloc.criterion [DZUOKR]
    PLNKZ,          -- Planning ind. [PLNKZ]
    TXTKZ,          -- Long txt exists [TXTKZ]
    LOEVR,          -- Deletion Indicator [LOEVR]
    UEBKZ,          -- Copied [UEBKZ]
    DATLP,          -- Date [DATUM]
    UHRLP,          -- Time [UZEIT]
    AGGPB,          -- Aggregation [AGGPB]
    PLSCN,          -- Planning Scenario [PLSCN]
    VRSIO,          -- Version [VRSIO]
    MCINF,          -- Info structure [MCINF]
    STFNA,          -- Field name [STFNA]
    OPLKZ,          -- Without MRP [OPLKZ]
    MCINC,          -- Info structure [MCINC]
    VRSIC,          -- Version [VRSIO]
    KNTTP,          -- Acct Assgmt Cat [KNTTP]
    SOBKZ,          -- Special Stock [SOBKZ]
    KZVBR,          -- Consumption [KZVBR]
    PSPEL,          -- WBS Element [PS_PSP_PNR]
    KDPOS,          -- Sales Ord. Item [KDPOS]
    KDAUF,          -- Sales Order [KDAUF]
    PROFILID,       -- Prof. name [PROFILID]
    KZBWS,          -- Valuation [KZBWS]
    PBDNR_EXT,      -- Ext. Req. Plan [PBDNR_EXT]
    SGT_RCAT,       -- Req. Segment [SGT_RCAT]
    LASTCHANGEDTS,  -- Time Stamp [TIMESTAMPL]
    PRIMARY KEY (MANDT, MATNR, WERKS, BEDAE, VERSB, PBDNR)
);

Learn More