SAP ABAP View MDFA (Data Base View of Production Order for MD)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MD03 (Package) Appl. development R/3 MPS/determin. requirements planning

Basic Data

View Type	D	Database View
Database View	MDFA
Short Description	Data Base View of Production Order for MD
Root table	AFPO	Order item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFPO	AFPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFPO	MANDT		☐	MANDT	☐	Client
2	AUFNR	AFPO	AUFNR		☐	AUFNR	☐	Order Number
3	POSNR	AFPO	POSNR		☐	CO_POSNR	☐	Order item number
4	AFTYP	AFPO	DAUTY		☐	AUFTYP	☐	Order category
5	AFART	AFPO	DAUAT		☐	AUFART	☐	Order Type
6	ELIKZ	AFPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
7	STATF	AFPO	DFREI		☐	CO_FREI	☐	Indicator: Order released/partially released (for MRP)
8	DNREL	AFPO	DNREL		☐	CO_DNREL	☐	Indicator: Order item not relevant for MRP
9	MATNR	AFPO	MATNR		☐	CO_MATNR	☐	Material Number for Order
10	PLWRK	AFPO	PWERK		☐	CO_PWERK	☐	Planning plant for the order
11	LGORT	AFPO	LGORT		☐	LGORT_D	☐	Storage location
12	PWWRK	AFPO	DWERK		☐	WERKS_D	☐	Plant
13	BESKZ	AFPO	BESKZ		☐	BESKZ	☐	Procurement Type
14	SOBES	AFPO	PSOBS		☐	SOBES	☐	Special procurement type
15	GSMNG	AFPO	PSMNG		☐	CO_PSMNG	☐	Order item quantity
16	WEMNG	AFPO	WEMNG		☐	CO_WEMNG	☐	Quantity of goods received for the order item
17	PAMNG	AFPO	PSAMG		☐	CO_PSAMG	☐	Scrap quantity in item
18	IAMNG	AFPO	IAMNG		☐	CO_IAMNG	☐	Expected surplus/deficit for goods receipt
19	AMEIN	AFPO	AMEIN		☐	CO_AUFME	☐	Unit of measure for in-house production
20	MEINS	AFPO	MEINS		☐	LAGME	☐	Base Unit of Measure
21	UMREZ	AFPO	UMREZ		☐	UMREZ	☐	Numerator for Conversion to Base Units of Measure
22	UMREN	AFPO	UMREN		☐	UMREN	☐	Denominator for conversion to base units of measure
23	PEDTR	AFPO	DGLTP		☐	CO_GLTRP	☐	Basic finish date
24	SEDTR	AFPO	DGLTS		☐	CO_GLTRS	☐	Scheduled finish
25	WEBAZ	AFPO	WEBAZ		☐	PLWEZ	☐	Goods receipt processing time in days
26	SERNR	AFPO	SERNR		☐	SERNR	☐	BOM explosion number
27	CUOBJ	AFPO	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
28	KNTTP	AFPO	KNTTP		☐	KNTTP	☐	Account assignment category
29	SOBKZ	AFPO	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
30	KZVBR	AFPO	KZVBR		☐	KZVBR	☐	Consumption posting
31	KDAUF	AFPO	KDAUF		☐	CO_KDAUF	☐	Sales order number
32	KDPOS	AFPO	KDPOS		☐	CO_KDPOS	☐	Sales order item
33	KDEIN	AFPO	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
34	PSPEL	AFPO	PROJN		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
35	WEPOS	AFPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
36	SAFNR	AFPO	SAFNR		☐	SA_AUFNR	☐	Run schedule header number
37	VERID	AFPO	VERID		☐	VERID	☐	Production Version
38	VERTO	AFPO	VERTO		☐	SA_VERTL	☐	MRP Distribution Key
39	QUNUM	AFPO	QUNUM		☐	QUNUM	☐	Number of quota arrangement
40	QUPOS	AFPO	QUPOS		☐	QUPOS	☐	Quota arrangement item
41	ARSNR	AFPO	ARSNR		☐	ARSNR	☐	Settlement reservation number
42	ARSPS	AFPO	ARSPS		☐	ARSPS	☐	Item number of the settlement reservation
43	NDISR	AFPO	NDISR		☐	CO_NDISR	☐	Ind.: Material in order item is not relevant for MRP
44	VFMNG	AFPO	VFMNG		☐	CO_VFMNG	☐	Committed quantity for order acc. to ATP check components
45	GSBTR	AFPO	GSBTR		☐	CO_GSBTR	☐	Overall commitment date
46	CHARG	AFPO	CHARG		☐	CHARG_D	☐	Batch Number
47	BWTAR	AFPO	BWTAR		☐	BWTAR_D	☐	Valuation type
48	UNTTO	AFPO	UNTTO		☐	UNTTO	☐	Underdelivery Tolerance Limit
49	TECHS	AFPO	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
50	BERID	AFPO	BERID		☐	BERID	☐	MRP Area
51	KRSNR	AFPO	KRSNR		☐	RSNUM	☐	Number of reservation/dependent requirements
52	KRSPS	AFPO	KRSPS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
53	INSMK	AFPO	INSMK		☐	INSMK	☐	Stock Type

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