SAP ABAP View AFFWV0 (View of AFFW for background job "open goods movements")

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ CORU (Package) R/3 Application development: PP Confirmations

Basic Data

View Type	D	Database View
Database View	AFFWV0
Short Description	View of AFFW for background job "open goods movements"
Root table	AFFW	Goods Movements with Errors from Confirmations

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	AFFW	AFFW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	AFFW	INACT		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	AFFW	MANDT		☐	MANDT	☐	Client
2	WEBLNR	AFFW	WEBLNR		☐	WEBLNR	☐	Number of a document from a goods movement with errors
3	WEBLPOS	AFFW	WEBLPOS		☐	CIM_COUNT	☐	Internal counter
4	MATNR	AFFW	MATNR		☐	MATNR	☐	Material Number
5	WERKS	AFFW	WERKS		☐	WERKS_D	☐	Plant
6	LGORT	AFFW	LGORT		☐	LGORT_D	☐	Storage location
7	CHARG	AFFW	CHARG		☐	CHARG_D	☐	Batch Number
8	BWART	AFFW	BWART		☐	BWART	☐	Movement type (inventory management)
9	SOBKZ	AFFW	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
10	KZVBR	AFFW	KZVBR		☐	KZVBR	☐	Consumption posting
11	KDAUF	AFFW	KDAUF		☐	KDAUF	☐	Sales Order Number
12	KDPOS	AFFW	KDPOS		☐	KDPOS	☐	Item number in Sales Order
13	KDEIN	AFFW	KDEIN		☐	KDEIN	☐	Delivery schedule for sales order
14	SHKZG	AFFW	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
15	WAERS	AFFW	WAERS		☐	WAERS	☐	Currency Key
16	ERFMG	AFFW	ERFMG		☐	ERFMG	☐	Quantity in unit of entry
17	ERFME	AFFW	ERFME		☐	ERFME	☐	Unit of entry
18	ELIKZ	AFFW	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
19	WEMPF	AFFW	WEMPF		☐	WEMPF	☐	Goods recipient
20	ABLAD	AFFW	ABLAD		☐	ABLAD	☐	Unloading Point
21	AUFNR	AFFW	AUFNR		☐	AUFNR	☐	Order Number
22	RSNUM	AFFW	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
23	RSPOS	AFFW	RSPOS		☐	RSPOS	☐	Item Number of Reservation / Dependent Requirements
24	KZEAR	AFFW	KZEAR		☐	KZEAR	☐	Final issue for this reservation
25	KZBEW	AFFW	KZBEW		☐	KZBEW	☐	Movement Indicator
26	LGNUM	AFFW	LGNUM		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
27	LGTYP	AFFW	LGTYP		☐	LGTYP	☐	Storage Type
28	LGPLA	AFFW	LGPLA		☐	LGPLA	☐	Storage Bin
29	RUECK	AFFW	RUECK		☐	CO_RUECK	☐	Completion confirmation number for the operation
30	RMZHL	AFFW	RMZHL		☐	CIM_COUNT	☐	Internal counter
31	AUFPL	AFFW	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
32	APLZL	AFFW	APLZL		☐	CIM_COUNT	☐	Internal counter
33	AUFPS	AFFW	AUFPS		☐	CO_POSNR	☐	Order item number
34	MSGID	AFFW	MSGID		☐	ARBGB	☐	Application Area
35	MSGNO	AFFW	MSGNO		☐	MSGNO	☐	System Message Number
36	WABLNR	AFFW	WABLNR		☐	MBLNR	☐	Number of Material Document
37	AUTYP	AFFW	AUTYP		☐	AUFTYP	☐	Order category
38	LIFNR	AFFW	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
39	INSMK	AFFW	INSMK		☐	INSMK	☐	Stock Type
40	FWDAT	AFFW	FWDAT		☐	CO_FWDAT	☐	Date when the error first arose
41	BUDAT	AFFW	BUDAT		☐	BUDAT	☐	Posting Date in the Document
42	BLDAT	AFFW	BLDAT		☐	BLDAT	☐	Document Date in Document
43	SMBLN	AFFW	SMBLN		☐	MBLNR	☐	Number of Material Document
44	SMBLP	AFFW	SMBLP		☐	MBLPO	☐	Item in material document
45	SJAHR	AFFW	SJAHR		☐	MJAHR	☐	Year of material document
46	RSART	AFFW	RSART		☐	RSART	☐	Record type
47	MHDAT	AFFW	MHDAT		☐	TMHHD	☐	SLED/Best-Before Date or Date of Production
48	PS_PSP_PNR	AFFW	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
49	FWZET	AFFW	FWZET		☐	CO_FWZET	☐	Time when the error first arose
50	REFBLN	AFFW	REFBLN		☐	RU_WEBLNR	☐	Reference doc. number for linked entries in AFFW
51	GRUND	AFFW	GRUND		☐	MB_GRBEW	☐	Reason for movement
52	BWTAR	AFFW	BWTAR		☐	BWTAR_D	☐	Valuation type
53	PRVBE	AFFW	PRVBE		☐	PRVBE	☐	Production Supply Area
54	BERKZ	AFFW	BERKZ		☐	BERKZ	☐	Material Staging Indicator for Production Supply

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