SAP ABAP View J_1BNF_PO_SEARCH (Purchase Orders by NF values on PO Header and Main Items)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil

Basic Data

View Type	D	Database View
Database View	J_1BNF_PO_SEARCH
Short Description	Purchase Orders by NF values on PO Header and Main Items
Root table	EKKO	Purchasing Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKKO	EKKO
2	EKPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKPO	MANDT	JL	EQ				0	0
2	EKKO	MANDT	JR	EQ			AND	0	0
3	EKPO	EBELN	JL	EQ				0	0
4	EKKO	EBELN	JR	EQ			AND	0	0
5	EKKO	LOEKZ		EQ	' '		AND	0	0
6	EKPO	LOEKZ		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKKO	MANDT		☐	MANDT	☐	Client
2	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
3	BSTYP_EKKO	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
4	BEDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
5	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
6	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
7	BSTYP_EKPO	EKPO	BSTYP		☐	BSTYP	☐	Purchasing document category
8	LOEKZ_EKPO	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
9	ELIKZ	EKPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
10	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
11	LOEKZ_EKKO	EKKO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
12	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
13	MENGE	EKPO	MENGE		☐	BSTMG	☐	Purchase Order Quantity
14	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
15	EBELN	EKPO	EBELN		☐	EBELN	☐	Purchasing Document Number
16	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
17	EMATN	EKPO	EMATN		☐	EMATNR	☐	Material number
18	J_1BNBM	EKPO	J_1BNBM		☐	J_1BNBMCO1	☐	Brazilian NCM Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in	606