PBIM
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ForecastDemandHeader | view_entity | 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_entity | from | BASIC | PIR Requirement Plan PopUp View |
| I_SupDmndAllDocPlndIndepRqmts | view | inner | BASIC | View for Planned Independent Requirements |
| P_PlndIndepRqmt | view | from | BASIC | Planned Independent Requirement: Union of PBIM and PBID |
| Pir_inactive_exists | view_entity | from | An inactive PIR exists | |
| Pir_Union_Head | view_entity | from | All PIR Headers | |
| PIR_UNION_HEAD_ALL | view | from | All PIR Headers | |
| PPH_E_MDPB | view | inner | Read MDPB |
Fields (36)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA