SAP ABAP View PORDARCH ("View from Order of Status")

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC-CPL (Application Component) Order Closing
     ⤷ CORE (Package) Archiving for application area PP

Basic Data

View Type	D	Database View
Database View	PORDARCH
Short Description	"View from Order of Status"
Root table	AUFK	Order master data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AUFK	AUFK
2	AFPO
3	AFKO
4	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AUFK	MANDT	JL	EQ				0	0
2	AFPO	MANDT	JR	EQ			AND	0	0
3	AUFK	AUFNR	JL	EQ				0	0
4	AFPO	AUFNR	JR	EQ			AND	0	0
5	AUFK	MANDT	JL	EQ				0	0
6	AFKO	MANDT	JR	EQ			AND	0	0
7	AUFK	AUFNR	JL	EQ				0	0
8	AFKO	AUFNR	JR	EQ			AND	0	0
9	AUFK	MANDT	JL	EQ				0	0
10	JEST	MANDT	JR	EQ			AND	0	0
11	AUFK	OBJNR	JL	EQ				0	0
12	JEST	OBJNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AUFK	MANDT		☐	MANDT	☐	Client
2	AUFNR	AUFK	AUFNR		☐	AUFNR	☐	Order Number
3	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
4	POSNR	AFPO	POSNR		☐	CO_POSNR	☐	Order item number
5	AUART	AUFK	AUART		☐	AUFART	☐	Order Type
6	AUTYP	AUFK	AUTYP		☐	AUFTYP	☐	Order category
7	WERKS	AUFK	WERKS		☐	WERKS_D	☐	Plant
8	DISPO	AFKO	DISPO		☐	CO_DISPO	☐	MRP controller for the order
9	FEVOR	AFKO	FEVOR		☐	FEVOR	☐	Production Supervisor
10	MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
11	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive
12	LOEKZ	AUFK	LOEKZ		☐	AUFLOEKZ	☐	Deletion flag
13	MAUFNR	AFKO	MAUFNR		☐	MAUFNR	☐	Number of superior order
14	PRODNET	AFKO	PRODNET		☐	CO_PRODNET	☐	Indicator: Order is part of collective order
15	LEAD_AUFNR	AFKO	LEAD_AUFNR		☐	CO_LAUFNR	☐	Leading order in current processing
16	AEDAT	AUFK	AEDAT		☐	AUFAEDAT	☐	Change date for Order Master
17	SPLSTAT	AFKO	SPLSTAT		☐	SPLIT_STAT	☐	Status of an order in a split hierarchy
18	GSTRP	AFKO	GSTRP		☐	PM_ORDGSTRP	☐	Basic Start Date

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	20130529
SAP Release Created in