SAP ABAP Table V_OIJ_DOCNR_Q (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_OIJ_DOCNR_Q   Table Relationship Diagram
Short Description Generated Table for View    
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  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_OIJ_DOCNR_Q BSART T161 BSART REF 1 N
2 V_OIJ_DOCNR_Q BWTAR T149D BWTAR REF 1 N
3 V_OIJ_DOCNR_Q EKGRP T024 EKGRP REF 1 N
4 V_OIJ_DOCNR_Q EKORG T024E EKORG REF 1 N
5 V_OIJ_DOCNR_Q EMATN MARA MATNR REF 1 N
6 V_OIJ_DOCNR_Q FLIEF LFA1 LIFNR REF 1 N
7 V_OIJ_DOCNR_Q KONNR EKKO EBELN REF 1 N
8 V_OIJ_DOCNR_Q LGORT T001L LGORT REF 1 N
9 V_OIJ_DOCNR_Q LIFNR LFA1 LIFNR REF 1 N
10 V_OIJ_DOCNR_Q MANDT T000 MANDT KEY 1 N
11 V_OIJ_DOCNR_Q MATNR MARA MATNR REF 1 N
12 V_OIJ_DOCNR_Q MEINS T006 MSEHI REF 1 N
13 V_OIJ_DOCNR_Q WERKS T001W WERKS REF 1 N
History
Last changed by/on SAP  20130529 
SAP Release Created in