SAP ABAP Table ROIJ_DOCNR_Q (Search Help Structure Requisitions)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	INTTAB	Structure
Structure	ROIJ_DOCNR_Q	Table Relationship Diagram
Short Description	Search Help Structure Requisitions

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
2	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
3	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
4	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	T161
5	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
6	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
7	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
8	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
9	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
12	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
14	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
15	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
16	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
17	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
18	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
19	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
20	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
21	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
22	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
23	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
24	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
25	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
26	VKTRA	☐	OIJ_VKTRA	VKTRA	CHAR	2	0	EDI Mode of Transport	*
27	LOCID	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*
28	IDATE	☐	OIJ_IDATE	DATUM	DATS	8	0	Scheduled date
29	FROMDATE	☐	OIJ_FROMDATE	DATUM	DATS	8	0	OIL-TSW: Deal validity From date
30	TODATE	☐	OIJ_TODATE	DATUM	DATS	8	0	OIL-TSW: Deal validity To date
31	PLANLOC	☐	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIJ_DOCNR_Q	BSART	T161	BSART	REF	1	N
2	ROIJ_DOCNR_Q	BWTAR	T149D	BWTAR	REF	1	N
3	ROIJ_DOCNR_Q	EKGRP	T024	EKGRP	REF	1	N
4	ROIJ_DOCNR_Q	EKORG	T024E	EKORG	REF	1	N
5	ROIJ_DOCNR_Q	EMATN	MARA	MATNR	REF	1	N
6	ROIJ_DOCNR_Q	FLIEF	LFA1	LIFNR	REF	1	N
7	ROIJ_DOCNR_Q	KONNR	EKKO	EBELN	REF	1	N
8	ROIJ_DOCNR_Q	LGORT	T001L	LGORT	REF	1	N
9	ROIJ_DOCNR_Q	LIFNR	LFA1	LIFNR	REF	1	N
10	ROIJ_DOCNR_Q	MANDT	T000	MANDT	KEY	1	N
11	ROIJ_DOCNR_Q	MATNR	MARA	MATNR	REF	1	N
12	ROIJ_DOCNR_Q	MEINS	T006	MSEHI	REF	1	N
13	ROIJ_DOCNR_Q	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20050301
SAP Release Created in	472