SAP ABAP Table OLR3_RESBI (PSIS - Individual Overviews: Components)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PS-ST (Application Component) Structures
     ⤷ R3_OBJECTLINK_R3 (Package) Object Link cProjects and R/3

Basic Data

Table Category	INTTAB	Structure
Structure	OLR3_RESBI	Table Relationship Diagram
Short Description	PSIS - Individual Overviews: Components

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Material Component Structure for Project Reporting
2	ARNUMMER	☐	ADMI_RUN_D	ADMI_RUN	CHAR	6	0	Archiving Session Number
3	VSGRUPPE	☐	VSGRUPPE	TEXT20	CHAR	20	0	Group for a project version
4	VSNUMMER	☐	VSNMR	VSNMR	CHAR	12	0	Number or description of a version
5	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
6	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
7	PRPOS	☐	IM_POSID	IM_POSID	CHAR	24	0	Identification for an investment program position
8	PSPID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
9	POSID	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
10	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
11	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
12	PLNUM	☐	PLNUM	PLNUM	CHAR	10	0	Planned order number	PLAF
13	AUFNR	☐	AUF_NETNR	AUFNR	CHAR	12	0	Order/Network number	AUFK
14	VORNR	☐	CN_VORNR	VORNR	CHAR	4	0	Activity number in network and standard network
15	UVORN	☐	CN_ELEMENT	VORNR	CHAR	4	0	Activity element number (work/external/general costs)
16	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	RESB
17	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
18	AUTYPTXT	☐	AUTYPTEXT	TEXT40	CHAR	40	0	Display field for order category description
19	RSART	☐	RSART	RSART	CHAR	1	0	Record type
20	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
21	RSSTA	☐	RSSTA	STATR	CHAR	1	0	Status of reservation
22	XFEHL	☐	XFEHL	XFELD	CHAR	1	0	Pre-allocated stock
23	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
24	MTEXT	☐	PS_MATTEXT	TEXT40	CHAR	40	0	Material description
25	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
26	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
27	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
28	PLPLA	☐	PLPLA	PLPLA	CHAR	10	0	Distribution of Differences
29	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
30	BDTER	☐	BDTER	DATUM	DATS	8	0	Requirements date for the component
31	BDMNG	☐	BDMNG	MENG13	QUAN	13	3	Requirement Quantity
32	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
33	ENMNG	☐	ENMNG	MENG13	QUAN	13	3	Quantity withdrawn
34	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
35	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
36	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
37	BAUGR	☐	BAUGR	MATNR	CHAR	18	0	Material number of higher-level assembly	MARA
38	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	SNUM
39	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
40	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
41	NOMNG	☐	NOMNG	MENG13	QUAN	13	3	Required quantity
42	POSTP	☐	POSTP	POSTP	CHAR	1	0	Item category (bill of material)	T418
43	APOSN	☐	APOSN	SPOSN	CHAR	4	0	BOM item number
44	ROMS1	☐	ROMS1	MENG13	QUAN	13	3	Size 1
45	ROMS2	☐	ROMS2	MENG13	QUAN	13	3	Size 2
46	ROMS3	☐	ROMS3	MENG13	QUAN	13	3	Size 3
47	ROMEI	☐	ROMEI	MEINS	UNIT	3	0	Unit of measure for sizes 1 to 3	T006
48	ROMEN	☐	ROMEN	MENG13	QUAN	13	3	VarSizeItem Qty
49	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
50	RFORM	☐	RFORM	RFORM	CHAR	2	0	Formula Key	T418F
51	ROANZ	☐	ROANZ	MENG13	QUAN	13	3	Number of Variable-Size Items
52	FLMNG	☐	FLMNG	MENG13	QUAN	13	3	Shortfall quantity of the component in the order
53	LTXSP	☐	LTXSP	SPRAS	LANG	1	0	Language: The long text was stored in this language	T002
54	POTX1	☐	POTX1	TEXT40	CHAR	40	0	BOM Item Text (Line 1)
55	SANKA	☐	CK_SELKZ	CK_SELKZ	CHAR	1	0	Indicator for Relevancy to Costing	TCK08
56	EWAHR	☐	EWAHR	DEC3	DEC	3	0	Usage Probability in % (Alternative Item)
57	AENNR	☐	AENNR	AENNR	CHAR	12	0	Change Number	AENR
58	SBTER	☐	SBTER	DATUM	DATS	8	0	Latest requirements date
59	SORTF	☐	SORTP	CHAR10	CHAR	10	0	Sort String
60	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
61	GPREIS	☐	PPCOMP	WERTV8	CURR	15	2	Price in component currency
62	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
63	RGEKZ	☐	RGEKZ	XFELD	CHAR	1	0	Indicator: Backflush
64	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
65	ROKME	☐	ROKME	MEINS	UNIT	3	0	Unit of measure for variable-size component	T006
66	VMENG	☐	VMENG	MENG15	QUAN	15	3	Confirmed quantity for availability check in SKU
67	LIFZT	☐	LIFZT	DEC3	DEC	3	0	Delivery Time in Days
68	KFPOS	☐	KFPOS	XFLAG	CHAR	1	0	Indicator: "configurable item"
69	AUDISP	☐	AUDISP_PLUS	AUDISP	CHAR	1	0	Reservation Relevance/Generation of Purchase Requisition
70	VORAB	☐	VORABKZ	XFELD	CHAR	1	0	Ind: Preliminary order
71	LTEXT	☐	AUFLTEXT	XFELD	CHAR	1	0	Long Text Exists
72	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
73	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
74	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
75	KZMPF	☐	KZMPF	XFELD	CHAR	1	0	Manual Maintenance of Requirement Date
76	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
77	NLFZV	☐	CS_NLFZV	NLFZT	DEC	3	0	Lead-time offset for operation
78	NLFMV	☐	CS_NLFMV	MEINS	UNIT	3	0	Unit for lead-time offset for operation	*
79	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
80	BANFNR	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
81	BANFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
82	EINHEIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
83	FLG_PURS	☐	FLG_PURS	KREUZ	CHAR	1	0	Indicator: Purchase order exists
84	WEMNG_CMP	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
85	WEMEH_CMP	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
86	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
87	PSTXTAR	☐	NPTXART	TXTAR	CHAR	2	0	Type of PS text to be copied into the purchase requisition	TCN03
88	PSTXTTI	☐	TXTTI	CHAR20	CHAR	20	0	PS text description
89	STATXT	☐	STATUSTEXT_2	CHAR80	CHAR	80	0	Edited status text
90	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
91	MENGE	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
92	BMENGE	☐	CO_MENGE	MENGV13	QUAN	13	3	Requirement quantity of the component
93	INT_ID	☐	OBJEKT_ID	CHAR30	CHAR	30	0	ID/Object key
94	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
95	ARBID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource	*
96	KALID	☐	FABKL	WFCID	CHAR	2	0	Factory calendar key	*
97	XWAOK	☐	XWAOK	XFELD	CHAR	1	0	Goods movement for reservation allowed
98	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
99	VGTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
100	ELTYP	☐	VGTYP	VORG_TYP	CHAR	3	0	Activity or element category
101	ZUONR	☐	CIM_ZUORD	KNTNR	NUMC	8	0	No. for material comp. allocation to task list
102	LOEKZ	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
103	LIGHT	☐	LVC_EXLED	CHAR1	CHAR	1	0	ALV control: Exception as LED

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OLR3_RESBI	AENNR	AENR	AENNR	REF
2	OLR3_RESBI	AUFNR	AUFK	AUFNR	REF	C	CN
3	OLR3_RESBI	BANFPO	EBAN	BNFPO	REF	C	CN
4	OLR3_RESBI	BAUGR	MARA	MATNR	REF	C	CN
5	OLR3_RESBI	BWART	T156	BWART	REF	C	CN
6	OLR3_RESBI	CHARG	MCHA	CHARG	REF	C	CN
7	OLR3_RESBI	EINHEIT	T006	MSEHI	REF	C	CN
8	OLR3_RESBI	EKGRP	T024	EKGRP	REF	C	CN
9	OLR3_RESBI	ERFME	T006	MSEHI	REF	C	CN
10	OLR3_RESBI	KDAUF	VBUK	VBELN	REF	C	CN
11	OLR3_RESBI	KDPOS	VBUP	POSNR	REF	C	CN
12	OLR3_RESBI	KNTTP	T163K	KNTTP
13	OLR3_RESBI	LGORT	T001L	LGORT	REF	C	CN
14	OLR3_RESBI	LIFNR	LFA1	LIFNR	REF	C	CN
15	OLR3_RESBI	LTXSP	T002	SPRAS	REF	C	CN
16	OLR3_RESBI	MATKL	T023	MATKL	REF	C	CN
17	OLR3_RESBI	MATNR	MARA	MATNR	REF	C	CN
18	OLR3_RESBI	MEINS	T006	MSEHI	REF	C	CN
19	OLR3_RESBI	PLNUM	PLAF	PLNUM	REF	C	CN
20	OLR3_RESBI	POSTP	T418	POSTP	REF	C	CN
21	OLR3_RESBI	PRCTR	CEPC	PRCTR	REF	C	CN
22	OLR3_RESBI	PRNAM	IMTP	PRNAM			CN
23	OLR3_RESBI	PSTXTAR	TCN03	TXTAR	REF	C	CN
24	OLR3_RESBI	RFORM	T418F	RFORM	REF	C	CN
25	OLR3_RESBI	ROKME	T006	MSEHI	REF	C	CN
26	OLR3_RESBI	ROMEI	T006	MSEHI	REF	C	CN
27	OLR3_RESBI	RSNUM	RESB	RSNUM	REF	C	CN
28	OLR3_RESBI	SAKNR	SKA1	SAKNR	REF	C	CN
29	OLR3_RESBI	SANKA	TCK08	SELKZ	REF	C	CN
30	OLR3_RESBI	SERNR	SNUM	SERNR	REF	C	CN
31	OLR3_RESBI	SOBKZ	T148	SOBKZ	REF	C	CN
32	OLR3_RESBI	WAERS	TCURC	WAERS	REF	C	CN
33	OLR3_RESBI	WERKS	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in