SAP table PBIM (Independent Requirements for Material)

SAP table PBIM has 6 primary key fields being MANDT,MATNR,WERKS,BEDAE,VERSB,PBDNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
BEDAE Requirements type CHAR 4 0 BEDAE
VERSB Version Number for Independent Requirements CHAR 2 0 VERSB
PBDNR Requirements Plan CHAR 10 0 PBDNR
BDZEI Independent Requirements Pointer NUMC 12 0 PBED BDZEI
ZUVKZ Consumption Indicator CHAR 1 0 DZUVKZ
VERVS Indicator: Version Active CHAR 1 0 VERVS
No
X Yes
VERKZ Consumption indicator for planning requirements CHAR 1 0 VERVP
No Allocation
1 Consume only with customer requirements
2 Only consume reservations, dependent requirements
3 Consume customer reqmts, reserv., dependent reqmts
4 Flexible Consumption for Different MRP Elements (BAdI)
ZUOKR Criterion for allocation CHAR 16 0 DZUOKR
PLNKZ Planning Indicator CHAR 1 0 PLNKZ
1 Net requirements planning
2 Gross requirements planning
3 Single-item planning
TXTKZ Long Text Exists CHAR 1 0 TXTKZ
LOEVR Deletion Indicator CHAR 1 0 LOEVR
UEBKZ Indicator: data copied CHAR 1 0 UEBKZ
DATLP Date DATS 8 0 DATUM
UHRLP Time TIMS 6 0 UZEIT
AGGPB Aggregation indicator for planned independent requirements CHAR 1 0 AGGPB
PLSCN Planning Scenario in Long-Term Planning NUMC 3 0 PLSCN
VRSIO Version number in the information structure CHAR 3 0 VRSIO
MCINF Name of information structure CHAR 8 0 MCINF
STFNA Field name in the generated DDIC structure CHAR 30 0 STFNA
OPLKZ With no MRP CHAR 1 0 OPLKZ
MCINC Name of info structure - characteristic values CHAR 8 0 MCINC
VRSIC Version number in the information structure CHAR 3 0 VRSIO
KNTTP Account Assignment Category CHAR 1 0 KNTTP
SOBKZ Special Stock Indicator CHAR 1 0 SOBKZ
KZVBR Consumption posting CHAR 1 0 KZVBR
No consumption
A Asset
E Sales order
P Project
V Consumption
PSPEL Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
KDPOS Item number in Sales Order NUMC 6 0 KDPOS
KDAUF Sales Order Number CHAR 10 0 KDAUF
PROFILID Name of planning profile NUMC 12 0 PROFILID
KZBWS Valuation of Special Stock CHAR 1 0 KZBWS
No stock valuation
A Valuation without reference to sales document
M Separate valuation with ref. to sales document/project
PBDNR_EXT External Requirements Plan ID CHAR 10 0 PBDNR_EXT
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
LASTCHANGEDTS UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL

PBIM foreign key relationships

Table Field Check Table Check Field
0 PBIM BDZEI PBED Independent Requirements Data MANDT
0 PBIM BDZEI PBED Independent Requirements Data BDZEI
0 PBIM BDZEI PBED Independent Requirements Data PDATU
1 PBIM MANDT T000 Clients MANDT
0 PBIM MATNR MARA General Material Data MANDT
0 PBIM MATNR MARA General Material Data MATNR
1 PBIM WERKS T001W Plants/Branches MANDT
1 PBIM WERKS T001W Plants/Branches WERKS