SAP ABAP View REORGVIEW (DB View for Reorg. of Scheduling Agreement Schedule Lines)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

View Type	D	Database View
Database View	REORGVIEW
Short Description	DB View for Reorg. of Scheduling Agreement Schedule Lines
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	EKPO
3	EKET
4	MAKT
5	EKKO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKKO	MANDT	JL	EQ				0	0
2	EKET	MANDT	JR	EQ			AND	0	0
3	EKKO	EBELN	JL	EQ				0	0
4	EKET	EBELN	JR	EQ			AND	0	0
5	EKPO	MANDT	JL	EQ				0	0
6	EKET	MANDT	JR	EQ			AND	0	0
7	EKPO	EBELN	JL	EQ				0	0
8	EKET	EBELN	JR	EQ			AND	0	0
9	EKPO	EBELP	JL	EQ				0	0
10	EKET	EBELP	JR	EQ			AND	0	0
11	EKKO	MANDT	JL	EQ				0	0
12	EKPO	MANDT	JR	EQ			AND	0	0
13	EKKO	EBELN	JL	EQ				0	0
14	EKPO	EBELN	JR	EQ			AND	0	0
15	MARA	MANDT	JL	EQ				0	0
16	EKPO	MANDT	JR	EQ			AND	0	0
17	MARA	MATNR	JL	EQ				0	0
18	EKPO	MATNR	JR	EQ			AND	0	0
19	MARA	MANDT	JL	EQ				0	0
20	MAKT	MANDT	JR	EQ			AND	0	0
21	MARA	MATNR	JL	EQ				0	0
22	MAKT	MATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKPO	MANDT		☐	MANDT	☐	Client
2	SPRAS	MAKT	SPRAS		☐	SPRAS	☐	Language Key
3	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
4	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
5	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
6	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
7	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
8	MAKTX	MAKT	MAKTX		☐	MAKTX	☐	Material description
9	KANBA	EKPO	KANBA		☐	KBNKZ	☐	Kanban Indicator
10	LOEKZ	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
11	BSTYP	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
12	BSART	EKKO	BSART		☐	ESART	☐	Purchasing Document Type
13	EBELN	EKET	EBELN		☐	EBELN	☐	Purchasing Document Number
14	EBELP	EKET	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
15	ETENR	EKET	ETENR		☐	EETEN	☐	Delivery Schedule Line Counter
16	EINDT	EKET	EINDT		☐	EINDT	☐	Item delivery date
17	SLFDT	EKET	SLFDT		☐	SLFDT	☐	Statistics-Relevant Delivery Date
18	LPEIN	EKET	LPEIN		☐	LPEIN	☐	Category of delivery date
19	MENGE	EKET	MENGE		☐	ETMEN	☐	Scheduled Quantity
20	AMENG	EKET	AMENG		☐	VOMNG	☐	Previous Quantity (Delivery Schedule Lines)
21	WEMNG	EKET	WEMNG		☐	WEEMG	☐	Quantity of goods received
22	WAMNG	EKET	WAMNG		☐	WAMNG	☐	Issued quantity
23	UZEIT	EKET	UZEIT		☐	LZEIT	☐	Delivery Date Time-Spot
24	BANFN	EKET	BANFN		☐	BANFN	☐	Purchase requisition number
25	BNFPO	EKET	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
26	ESTKZ	EKET	ESTKZ		☐	ESTKZ	☐	Creation indicator (purchase requisition/schedule lines)
27	QUNUM	EKET	QUNUM		☐	QUNUM	☐	Number of quota arrangement
28	QUPOS	EKET	QUPOS		☐	QUPOS	☐	Quota arrangement item
29	MAHNZ	EKET	MAHNZ		☐	MAHNZE	☐	No. of Reminders/Expediters for Schedule Line
30	BEDAT	EKET	BEDAT		☐	ETBDT	☐	Order date of schedule line
31	RSNUM	EKET	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
32	SERNR	EKET	SERNR		☐	SERNR	☐	BOM explosion number
33	FIXKZ	EKET	FIXKZ		☐	ETFIX	☐	Schedule Line is "Fixed"
34	GLMNG	EKET	GLMNG		☐	GLMNG	☐	Quantity Delivered (Stock Transfer)
35	DABMG	EKET	DABMG		☐	DABMG	☐	Quantity Reduced (MRP)
36	CHARG	EKET	CHARG		☐	CHARG_D	☐	Batch Number
37	LICHA	EKET	LICHA		☐	LICHN	☐	Vendor Batch Number
38	CHKOM	EKET	CHKOM		☐	CHKOM	☐	Components
39	VERID	EKET	VERID		☐	VERID	☐	Production Version
40	ABART	EKET	ABART		☐	MEABART	☐	Scheduling agreement release type
41	MNG02	EKET	MNG02		☐	MNG06	☐	Committed quantity
42	DAT01	EKET	DAT01		☐	DAT05	☐	Committed date
43	APOMS	EKPO	APOMS		☐	APOMS	☐	APO as Planning System

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