SAP ABAP Table AFFWV0 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	AFFWV0	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	AFFWV0	AUFNR	AUFK	AUFNR		C	CN
2	AFFWV0	BWART	T156	BWART		C	CN
3	AFFWV0	CHARG	MCH1	CHARG
4	AFFWV0	ERFME	T006	MSEHI
5	AFFWV0	KDAUF	VBUK	VBELN
6	AFFWV0	LGNUM	T300	LGNUM
7	AFFWV0	LGORT	T001L	LGORT		C	CN
8	AFFWV0	LGPLA	LAGP	LGPLA
9	AFFWV0	LGTYP	T301	LGTYP
10	AFFWV0	LIFNR	LFA1	LIFNR
11	AFFWV0	MATNR	MARA	MATNR
12	AFFWV0	MSGID	T100A	ARBGB		C	CN
13	AFFWV0	MSGNO	T100	MSGNR		C	CN
14	AFFWV0	SOBKZ	T148	SOBKZ
15	AFFWV0	WAERS	TCURC	WAERS
16	AFFWV0	WERKS	T001W	WERKS		C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in