SAP ABAP Table AFFW (Goods Movements with Errors from Confirmations)

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

Table Category	TRANSP	Transparent table
Transparent table	AFFW	Table Relationship Diagram
Short Description	Goods Movements with Errors from Confirmations

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
7	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
12	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
13	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
14	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
15	KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
16	KDPOS	☐	KDPOS	NUM06	NUMC	6	0	Item number in Sales Order
17	KDEIN	☐	KDEIN	NUM04	NUMC	4	0	Delivery schedule for sales order
18	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
19	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
20	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
21	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
22	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
23	WEMPF	☐	WEMPF	WEMPF	CHAR	12	0	Goods recipient
24	ABLAD	☐	ABLAD	TEXT25	CHAR	25	0	Unloading Point
25	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
26	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
27	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
28	KZEAR	☐	KZEAR	XFELD	CHAR	1	0	Final issue for this reservation
29	KZBEW	☐	KZBEW	KZBEW	CHAR	1	0	Movement Indicator
30	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
31	LGTYP	☐	LGTYP	LGTYP	CHAR	3	0	Storage Type	T301
32	LGPLA	☐	LGPLA	LGPLA	CHAR	10	0	Storage Bin	LAGP
33	RUECK	☐	CO_RUECK	CO_RUECK	NUMC	10	0	Completion confirmation number for the operation
34	RMZHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
35	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
36	APLZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
37	AUFPS	☐	CO_POSNR	CO_POSNR	NUMC	4	0	Order item number
38	MSGID	☐	ARBGB	ARBGB	CHAR	20	0	Application Area	T100A
39	MSGNO	☐	MSGNO	MSGNR	CHAR	3	0	System Message Number	T100
40	MSGTY	☐	MSGTY	MSGAR	CHAR	1	0	Message Type
41	MSGV1	☐	MSGV1	CHAR50	CHAR	50	0	Message variable 01
42	MSGV2	☐	MSGV2	CHAR50	CHAR	50	0	Message variable 02
43	MSGV3	☐	MSGV3	CHAR50	CHAR	50	0	Message variable 03
44	MSGV4	☐	MSGV4	CHAR50	CHAR	50	0	Message variable 04
45	WABLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
46	AUTYP	☐	AUFTYP	AUFTYP	NUMC	2	0	Order category
47	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
48	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
49	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
50	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
51	FWDAT	☐	CO_FWDAT	DATUM	DATS	8	0	Date when the error first arose
52	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
53	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
54	SMBLN	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
55	SMBLP	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
56	SJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
57	RSART	☐	RSART	RSART	CHAR	1	0	Record type
58	MHDAT	☐	TMHHD	DATUM	DATS	8	0	SLED/Best-Before Date or Date of Production
59	DNOTW	☐	DNOTW	XFELD	CHAR	1	0	Indicator: Dialog necessary
60	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
61	MBLPO	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
62	PS_PSP_PNR	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
63	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
64	FWZET	☐	CO_FWZET	UZEIT	TIMS	6	0	Time when the error first arose
65	PRVBE	☐	PRVBE	PRVBE	CHAR	10	0	Production Supply Area	*
66	PRTNR	☐	PRTNR	PRTNR	NUMC	10	0	Confirmation number	*
67	REFBLN	☐	RU_WEBLNR	BELNR	CHAR	10	0	Reference doc. number for linked entries in AFFW
68	INACT	☐	RU_VRMKZ	XFELD	CHAR	1	0	Indicator: Planned confirmation
69	BEMOT	☐	BEMOT	BEMOT	CHAR	2	0	Accounting Indicator	TBMOT
70	PARBU	☐	PARBU	BUKRS	CHAR	4	0	Clearing company code	*
71	.INCLUDE	☐				0	0	Structure for Include in AFFW
72	GRUND	☐	MB_GRBEW	MB_GRBEW	NUMC	4	0	Reason for movement	*
73	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
74	KUNNR	☐	EKUNN	KUNNR	CHAR	10	0	Account number of customer	*
75	BERKZ	☐	BERKZ	LVS_BERKZ	CHAR	1	0	Material Staging Indicator for Production Supply
76	LINE_ID	☐	MB_LINE_ID	MB_LINE_ID	NUMC	6	0	Unique identification of document line
77	BATCH_TYPE	☐	BATCH_TYPE	BATCH_TYPE	CHAR	1	0	Type of Batch
78	LICHA	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in